Calcady
Home / Professional / Financial / Macaulay Duration Calculator

Macaulay Duration Calculator

Calculate Macaulay Duration and Modified Duration for any coupon bond. Measure weighted average time to cash flow recovery, quantify price sensitivity to interest rate changes, and model duration-matching strategies for liability-driven investing and bond portfolio immunization.

Macaulay Duration Calculator

Macaulay Duration is the weighted average time an investor must wait to receive the present value of a bond's cash flows. It is the foundational measure of interest rate risk — a bond with a 10-year duration will lose approximately 10% of its price for every 1% rise in interest rates. Portfolio managers use duration to immunize bond portfolios against rate movements.

N = 5 × 2 = 10 periods
y = 6% / 2 = 3.0000% / period
C = $1,000 × 5% / 2 = $25.00 / period
Current Bond Price
$957.35
Present Value of Cash Flows
Discount (YTM > Coupon)
Macaulay Duration
4.4717
Years
Weighted avg. payback time
Modified Duration
4.3414
= Mac.D / (1 + y)
≈ % price change per 1% rate move
Cash Flow Schedule
PeriodTime (yrs)Cash FlowPVt × PV
10.50$25.00$24.27$12.14
21.00$25.00$23.56$23.56
31.50$25.00$22.88$34.32
42.00$25.00$22.21$44.42
52.50$25.00$21.57$53.91
63.00$25.00$20.94$62.81
73.50$25.00$20.33$71.15
84.00$25.00$19.74$78.94
94.50$25.00$19.16$86.22
105.00$1025.00$762.70$3813.48
TOTAL$957.35$4280.96
Duration = ΣWeighted PV / ΣPV4.4717 years

Practical Example

A 5-year $1,000 corporate bond pays a 5% annual coupon semi-annually (C = $25 every 6 months). The market yield (YTM) is 6% — higher than the coupon, so the bond trades at a discount.

N = 5 × 2 = 10 periods. Periodic yield = 6%/2 = 3% per period.
Sum PV of all cash flows ≈ $957.35 (trades below par).
Sum of time-weighted PVs / Price = ~4.45 years Macaulay Duration.

This means: if the Fed raises rates by 1%, this bond will lose approximately 4.45% × 1% = 4.45% of its market value. A 20-year bond with a 5-year duration would only lose 5%, while a 20-year zero-coupon bond (duration = 20 years) would lose 20% — exactly why duration is the key metric for rate risk management.

💡 Field Notes

  • Why coupon reduces duration: Each coupon payment you receive earlier reduces your weighted average waiting time. A zero-coupon bond has a duration equal to its maturity — you wait the full term for your only cash flow. A high-coupon bond of the same tenor has a much shorter duration because you recover significant value early through coupons. This is why callable bonds and high-yield bonds (high coupons) tend to have shorter durations despite long maturities.
  • Modified Duration vs. Macaulay: Modified Duration = Macaulay Duration / (1 + y/m). It directly approximates the percentage price change for a given yield change: ΔP/P ≈ −ModDuration × Δy. A bond with Modified Duration = 4.30 loses ~4.30% of price for a 100bps rate increase — this is the number portfolio managers use for hedging.
  • Duration matching (immunization): If you have a liability due in 4.45 years, holding this bond exactly immunizes your position — even if rates change, the price loss is exactly offset by reinvestment income changes, because you "break even" at the duration date. This is the core principle of liability-driven investing (LDI), used by pension funds and insurance companies worldwide.
Email LinkText/SMSWhatsApp

Quick Answer: What does Macaulay Duration actually measure?

Macaulay Duration measures the weighted average time (in years) to receive all of a bond's discounted cash flows. Each coupon and the final principal payment is weighted by its present value relative to the total bond price. A duration of 4.5 years means the investor recovers the present value of their investment in 4.5 years on a present-value-weighted basis. More practically, it is the foundation of Modified Duration — the metric that directly answers: "how much does this bond's price change for every 1% move in interest rates?"

The Three Duration Formulas

Bond Price (Sum of Discounted Cash Flows)

P = ∑ C÷(1+y)ⁱ + F÷(1+y)𝑁

Macaulay Duration (Weighted Average Time)

Dₘₐₙ = ∑ (t × PVᵢ) ÷ ∑ PVᵢ

Modified Duration (Price Sensitivity to Yield)

Dₘₒₑ = Dₘₐₙ ÷ (1 + y) ≈ −%ΔP ÷ ΔYTM

Duration Risk Scenarios

✓ Duration Immunization in Practice

Pension fund precisely matching asset duration to liability date.

  1. Liability: $10M pension obligation due in exactly 8 years.
  2. Strategy: Build a bond portfolio with Macaulay Duration = 8.0 years. Mix of 10-year Treasuries (D≈8.2yr) and 5-year corporates (D≈4.5yr) blended to a portfolio-weighted duration of 8.0.
  3. Rate shock test: Rates spike 2% immediately. Bond prices fall ~14% (8 years × 2% × Modified Duration adjustment). But now reinvested coupons grow faster at higher rates.
  4. Net result: Price loss on bonds ≈ reinvestment gain on coupons. At exactly 8 years, the portfolio still delivers the $10M liability — the two effects offset. This is immunization working as designed.

✗ Long-Duration Loss in a Rate Hike Cycle

How long-duration portfolios suffered in 2022's rate shock.

  1. Setup: 30-year Treasury bond, 2% coupon, YTM start = 2%. Duration ≈ 22 years.
  2. Rate shock: Fed raises rates 4.25% in 12 months (2022). New YTM = 6.25%.
  3. Price impact: Modified Duration ≈ 21.6. Loss ≈ 21.6 × 4.25% = ~91.8% decline? No — convexity moderates this. Actual decline ≈ 55–60% in long-duration bond portfolios in 2022.
  4. Lesson: Duration is a linear approximation. Large rate moves require convexity adjustment. But the directional magnitude — holding a 22-year duration portfolio into a 4%+ rate hike cycle — was catastrophic and duration predicted this risk quantitatively, years before it materialized.

Macaulay Duration Reference Table

Bond Type / Maturity Approx. Duration
Zero-Coupon, 5yr5.0 years
5yr, 5% coupon, at par4.4 years
10yr, 5% coupon, at par7.8 years
30yr Treasury, 3% coupon18 – 20 years
Zero-Coupon, 30yr30.0 years

Duration Management Directives

Do This

  • Use Modified Duration to dollar-quantify portfolio rate risk before taking positions. If your bond portfolio has $5M market value and Modified Duration 7.5, a 1% rate rise produces a $5M × 7.5% = $375,000 mark-to-market loss. Presenting duration risk in dollar terms makes it actionable for risk limits, position sizing, and hedging decisions in a way that abstract years cannot.
  • Shorten portfolio duration when the rate cycle turns rising. Rotate from long-maturity to short-maturity bonds to reduce duration. Treasury bills (duration ≈ 3–6 months) or floating-rate notes (duration near zero) dramatically reduce price sensitivity during Fed tightening cycles. Duration is the single most important position management decision in a bond portfolio — more than credit or sector selection in a rate-dominated environment.

Avoid This

  • Never use Modified Duration alone for large yield changes — add convexity adjustment. Modified Duration is a linear approximation that underestimates price gains from rate falls and overestimates price losses from rate rises. For yield changes above 1%, the convexity term matters: ΔP ≈ −D_Mod × ΔY + ½ × Convexity × (ΔY)². In the 2022 rate shock, portfolios using only duration for risk measurement consistently underestimated losses before convexity corrections.
  • Don't confuse duration with maturity when managing liability matching. A 10-year bond does not have 10 years of duration — it has roughly 7–8 years depending on coupon rate and current YTM. Matching a 7-year liability with a 10-year bond creates a duration mismatch of 2+ years that produces residual interest rate risk in the immunized portfolio. Always calculate actual Macaulay Duration, not proxy from maturity, before implementing an LDI strategy.

Frequently Asked Questions

What is the difference between Macaulay Duration and Modified Duration?

Macaulay Duration is a time-weighted measure in years — the weighted average time to receive all discounted cash flows. It is a conceptual measure of how "long" the investment is on a present-value basis. Modified Duration is a direct price sensitivity measure: it is Macaulay Duration divided by (1 + periodic yield), and directly approximates the percentage price change per 1% change in yield. In practice, Modified Duration is more actionable — you use it to calculate dollar P&L impact from rate moves. Macaulay Duration is the input required for immunization and duration matching strategies.

Why do bond prices fall when interest rates rise?

When market interest rates rise, newly issued bonds offer higher coupon payments than existing bonds. The existing bond's fixed coupons become less attractive relative to the market, so its price must fall until its total return (fixed coupons + price discount to par) equals the new market yield. The bond price adjusts down exactly enough to make the yield-to-maturity competitive with new issuances. Duration quantifies how much the price must fall — a longer duration bond has more cash flows to discount at the new higher rate, so its price drops more than a short-duration bond for the same yield change.

What is convexity and why does it matter alongside duration?

Convexity is the second-order correction to modified duration's linear approximation. The true price-yield relationship for a bond is curved (convex), not linear. For small yield changes (<1%), duration alone is sufficiently accurate. For larger yield changes, convexity matters: bonds gain more in price when yields fall than they lose when yields rise by the same amount — this asymmetry is convexity, and it is always positive for non-callable bonds. Full price change formula: ΔP ≈ −D_Mod × ΔY + ½ × Convexity × (ΔY)². Higher convexity is always preferable — it provides extra price upside in falling rate environments while cushioning losses in rising rate environments.

How does duration change as a bond ages toward maturity?

Duration generally decreases as a bond ages toward maturity, but not linearly. Each coupon payment reduces remaining cash flows and the time-weighting shifts. Duration declines by approximately 1 year for each year that passes — a bond with 4.5 years of Macaulay Duration today will have approximately 3.5 years of duration in one year (assuming stable yields). This means an immunized portfolio requires periodic rebalancing — a pension fund matched to a 7-year liability today needs to continue matching duration as the liability shortens to 6 years, 5 years, etc., and the bond portfolio's duration naturally shortens at a similar but not identical rate.

Related Fixed-Income & Risk Tools