Question about Bionic Turtle's 2009 FRM Program
07 Jan 2009
Sep
26
Modified vs. Macaulay Duration
by David Harper, CFA, FRM, CIPM
FRM |
Learning Outcome
- LO 23.9: Define, interpret, and calculate the yield-based DV01, the modified duration, and the Macaulay duration of a security.
This article contains:
- Formulas for each duration measure.
- English explanations
- EditGrid spreadsheet that solves for each. To make it easier, each term's calculations in the spreadsheet is color-coded: DV01, modified duration, and Macaulay duration
- A note about internal consistencies (reconciliations) in the spreadsheet
1. Formulas for each duration
In the course of FRM study, we price bonds without embedded options. For such plain-vanilla bonds, the distinction between modified and effective duration does not matter. (see Fabozzi for the difference: effective duration recognizes that cash flows dynamically change with the yield. An unnecessary nuance in our case).
Given that we assume a bond without embedded options, modified (or effective) duration is given by:
The dollar value of an zero (DV01) is given by:
And the Macaulay duration can be expressed as a function of the (modified/effective) duration above:
That is because Modified duration can be expressed as this expanded format:
And the term inside the braces above is the Macaulay Duration. I calculate this above formula in the spreadsheet below (see the blue section, which solves for the Macaulay)
2. English explanations
The modified (or effective) duration is arguably the most relevant risk measure: the approximate percentage change in bond price given a 1% (100 basis point) yield change.
The dollar value of an zero (DV01) is the approximate dollar price change given a one basis point (0.01%) change in yield. The difference between modified duration and DV01 is that the former measure a percentage change and the latter measures an absolute dollar change. The learning outcome calls for the yield-based DV01. That is what we have been doing! The yield-based DV01 is a special case of the DV01. A general DV01 is unspecific about the rate shift: it is agnostic about the type of interest rate change. A yield-based DV01 gives the dollar change for a change in the yield to maturity (YTM, or what we often just call 'yield').
And the Macaulay duration is the duration that can be expressed in time units. In the example below, the Macaulay duration is 8.17, so we could say "the weighted average time to receipt of the coupons and principal is 8.17 years." But some bond folks will grimace (although, it does have an intuitive meaning, it means our bond has roughly the sensitivity to rates of a zero-coupon bond with 8.17 years to maturity).
3. EditGrid spreadsheet
The EditGrid spreadsheet (below) can be easily uploaded into several formats, including MS Excel (Select File > Save As...).
The initial bond assumptions include the following (four bond inputs and one assumption about how much we will 'shock' the yield to estimate duration):
- Par value: $1,000
- Maturity: 10 years
- Coupon: 4.0%
- Yield: 6%
- Duration "shock:" 20 basis points
The layout contains four blocks, one input area and four solutions, as follows:
| Layout of the EditGrid Spreadsheet | |
| Input (Yellow) | Macaulay Duration (Blue) |
| Modified Duration (Green) | |
| DV01 (Orange) | |
4. Note about reconciliation
A great way to really understand these durations is to observe how they relate. Specifically, in the spreadsheet, notice the following:
We solve the DV01 by shocking the yield up one basis point. This gives the same result ($0.68) as (Price x Duration)/10,000:
The Macaulay Duration involves time weighting all of the cash flows. It produces a Macaulay duration of 8.17. The Modified Duration therefore equals 7.93 = 8.17/(1+6%/2). This is the same duration we get with the typical (the green block) modified duration where we shock the yield +/- 20 basis points.
Comments
In the fomula of Modified duration, the text indicate that ‘the term inside the braces is the Macaulay Duration’. I think you forgot to include the term 1/P for Macaulay duration.
JP - Yes, thanks for your careful eye. It is corrected - David
I know Macauley Duration has a unit of years but I never see a discussion of the units for modified duration. Is it unitless? Is the assumption that the yield is per year and cancels the macauley year units? Thanks
Hi Thomas,
Totally great question. Duration is a 1st derivative, like velocity is 1st derivative of distance (with respect to time). Distance is measured in feet, so velocity is measured in “feet per second” (feet/second, feet/time or dDistance/dTime). The bond curve is plotted Price versus Yield, so duration, as the Slope (1st derivative) is change in Price per change in Yield (dPrice/dYield). Because it is a straight tangent line on the P/Yield curve, it’s units are Price/Yield.
That’s just the math, maybe the way to think about it is (and i am just parroting Fabozzi) is “% change in bond price given a 1% increase in the yield.”. And regarding the period, no I don’t think an annual period is (should be) assumed for the yield. Yield can be annual, semiannual, monthly, etc. This is perhaps why most authors recommend thinking of duration not as “time to weighted average cash flow” (per Macaulay) and instead as a *sensitivity* concept. Hope that helps!
David, great article! Thank you for actually including the formulas, for clearly explaining the distinction between Macaulay and modified duration, and providing great examples. This was the best resource I could find on the web regarding this subject.
Leave a Comment