The Mountain Path Academy
Bond Bootstrapping & Spot Rate Engine
Build the zero-coupon curve from zero-coupon bonds, par bonds, a mixed set of bonds with interpolation, or a LINEST-style least-squares fit, and read spot, forward and par curves in any compounding convention.
THE MOUNTAIN PATH ACADEMYFinance · Risk Management · Quantitative Analytics
Bond Bootstrapping & Spot Rate Engine
Zero-coupon, par curve, mixed bonds with interpolation and LINEST least-squares methods
Bootstrapping method
Spot-rate convention
Coupon frequency
Shortest spot rate–
Longest spot rate–
Minimum discount factor–
Longest-maturity DF
Terminal forward rate–
Bootstrapped term structure
Spot (zero) curve, forward curve between curve points, and the par-yield curve implied by the same discount factors.
Input bond instruments
Face value 100. Coupon is the annual coupon rate; it is paid at the frequency chosen above.
| Maturity (yrs) | Annual coupon % | Clean price | Model price |
|---|
Method applied
Bootstrapped curve outputs
Prof. V. Ravichandran · The Mountain Path Academy
How to use this tool: pick a method, enter bond prices, and watch the discount factors, spot rates, forwards and par yields update. “Model price” reprices every bond off the bootstrapped curve, so a match confirms the curve. Work through the same steps by hand in the bootstrapping guide → and in Excel with the companion workbook ↓
Teaching tool with illustrative prices; not investment advice. https://themountainpathacademy.com