The Mountain Path Academy
Term Structure Spot & Forward Rate Suite
Interpolate yields between benchmark maturities, convert spot rates into implied forward rates under annual, money-market and continuous compounding, and rebuild spot rates from a chain of forwards.
THE MOUNTAIN PATH ACADEMYFinance · Risk Management · Quantitative Analytics
Term Structure Spot & Forward Rate Suite
Linear interpolation (formula & FORECAST.LINEAR), annual forwards, money-market FRAs, continuous and implied spot rates
Annual compounded inputs
Spot (zero) rates and their maturities in years, annual effective compounding.
Implied annual forward rates
Money-market inputs
Simple-interest rates quoted for d days on an Actual/360 or Actual/365 basis.
Implied money-market forward (FRA) rate
–
Continuously compounded inputs
Zero rates z with continuous compounding: DF = e−zt.
Continuous forward rate
–f = (z2t2 − z1t1) ÷ (t2 − t1)
Given one-year forward rates
f1 runs from today to year 1, f2 from year 1 to 2, f3 from year 2 to 3.
Implied zero (spot) rates
Known benchmark nodes (x1, y1) and (x2, y2)
Two observed maturities on the curve. The target maturity must lie between them.
Target maturity x4 years
Formula method vs Excel FORECAST.LINEAR
1 · Whiteboard formula–
2 · Excel FORECAST.LINEAR–
Interpolated yield curve
Straight lines between benchmark maturities, plotted every 0.5 years · gold dot = your targetEdit the benchmark curve below; the chart redraws as you type.
Linear interpolationy = y1 + (x − x1) × (y2 − y1) ÷ (x2 − x1). The bracket is the slope: the yield change per year of maturity.
Weighting viewy = y1 × (x2 − x) ÷ (x2 − x1) + y2 × (x − x1) ÷ (x2 − x1). The nearer node gets the larger weight.
Excel FORECAST.LINEAR=FORECAST.LINEAR(x, known_y's, known_x's). With exactly two nodes the fitted line passes through both, so it equals the formula. Give it more than two points and it fits a regression line instead, which is not interpolation.
Annual compoundingf(t1, t2) = [(1 + R2)t2 ÷ (1 + R1)t1]1/(t2 − t1) − 1. Investing to t2 directly must equal investing to t1 and rolling at the forward.
Money-market (simple interest)F = [(1 + RLτL) ÷ (1 + Rsτs) − 1] ÷ τF, with τ = days ÷ basis and τF = (d2 − d1) ÷ basis. This is the rate an FRA locks in.
Continuous compoundingf(t1, t2) = (z2t2 − z1t1) ÷ (t2 − t1). Exponents add, so the forward is a time-weighted difference of zero rates.
Spot from forwardsSN = [(1 + f1)(1 + f2) … (1 + fN)]1/N − 1. A spot rate is the geometric average of the one-year forwards up to N.
Reading the resultRising spot rates imply forwards above spot; falling spot rates imply forwards below spot. Under pure expectations the forward equals the expected future spot rate; with a term premium it lies above it.
Conventions matterNever mix bases: a 5% Actual/360 rate is 5.069% on Actual/365. Convert all quotes to one convention before computing a forward.
Prof. V. Ravichandran · The Mountain Path Academy
How to use this tool: pick a module, change the yields, and follow the whiteboard working underneath each answer. The theory and worked examples are in The Term Structure of Interest Rates →, with the Excel companion ↓
Teaching tool with illustrative rates; not market data or investment advice. https://themountainpathacademy.com