![](\"http:\/\/www.prefblog.com\/images\/ad_ModifiedDuration.jpg\")
<\/a><\/div>\n*Assuming, of course, that the keeners care<\/em> about understanding what I say!<\/p>\n Update and Bump, 2007-10-27<\/strong>: I have received a rather patronizing communication from a correspondent who claims that the formula given in the article for modified duration is incorrect.<\/p>\n \u00a0<\/p>\n He claims that the variable “f” should always be equal to one and attaches two pages of calculus (including patronizing commentary) that proves it.<\/p>\n Alas, my correspondent has forgotten to ask himself the questions that any investment manager should ask himself – particularly if holding himself out to be a quant:<\/p>\n In this particular case, my correspondent has slipped up by assuming that “yield-to-maturity” (the “y” in the equation) is equal to the\u00a0internal rate of return.<\/p>\n It ain’t. Yield-to-Maturity is, by street convention, equal to N times the coupon-period return, where N is the number of coupons per year. This point comes up over and over again – on this blog, for instance, there is a very similar discussion on Research : Yield from On-Line Calculator<\/a>. It’s a tricky point and, in this degenerate age where one can find internal rate of return on Excel more easily than by explicit trial-and-error approximations, one that is easily forgotten.<\/p>\n Ah, for the good old days! When men were men, when you had to understand a calculation before you could perform it, and no back-of-an-envelope was too humble to serve as a scratch pad!<\/p>\n I have uploaded an MS-Excel Spreadsheet<\/a> in which two sets of calculations are made – the way in which my correspondent does calculations, and the way in which we do it on Planet Earth. I believe that my computer – and my Excel programme – are bug-free, so there will be no virus transmission; I believe that all reasonable precautions are made with my site and my hosting provider so that the spreadsheet will not be hacked after upload; and I believe that even if a macro-virus should reach my readers’ computers, their anti-virus software will prevent harm.<\/p>\n But what if I’m wrong<\/em>? I have also uploaded PDF file<\/a> that reflects the spreadsheet, for use by those who don’t want to take the chance.<\/p>\n In cells a1:d22, I have input the cash flows\u00a0reflecting the November 1, 2007, purchase of a par\u00a0bond that pays $5 every six months commencing May 1, 2008, and repays its principal on November 1, 2017. Since all calculations will be performed as of November 1, 2007, I feel perfectly justified in referring to this bond as a ten-year, 10% bond.<\/p>\n The crucial point of the analysis is found in cell B24 – the XIRR function provided by Microsoft. It indicates that the internal rate of this bond is not 10%, as one might expect, but 10.2425%. This is easy enough to understand – for each year, we’re getting half of our quoted 10% six months early and can earn interest on this – but it is often forgotten. And this bond will not be quoted – anywhere – as yielding 10.24%. As an exercise, I suggest that interested readers sell such\u00a0a bond to their brokerage house “at a price to\u00a0yield 10.24%” and then invoice them for $100. Let me know what they tell you.<\/p>\n In cells E1:E22, I have discounted each cash flow by time in years<\/em> at the yearly rate<\/em> of 10.25% indicated in cell E24. Cell E23 shows the sum of the present values thus calculated, 99.99945, so we may conclude that we understand how the XIRR functions works.<\/p>\n In cells F1:F22, I have discounted each cash flow by period<\/em> at the period rate of return<\/em> of 5% indicated in cell F24. Cell F23 shows the sum of the present values thus calculated, 99.99945258, which I’m willing to conclude is a rounding error (particularly since I was lazy, and determined the period number by doubling the time in years, which will be off due to day-count and leap-year approximations. It’s OK for a quant to be lazy, as long as he knows<\/em> he’s being lazy!). Anyway, this calculation confirms we know how to calculate returns by period.<\/p>\n Cells H1:H26 calculate the Macaulay Duration of the bond according to the “time” cash flows; cells I1:I26 perform this calculation using the “period” cash flows; the results are as equal as we can expect anything in this wicked world to be.<\/p>\n The next four cells to be examined, H28:I29,\u00a0are a little more complex. The Modified Duration is calculated by the disputed Equation 2 for each calculation method\u00a0using the indicated value of “y” and setting “f” to either “1” (as my correspondent insists is always the case) or “2” (which is dependent upon the number of coupon periods per year, as explained in the article. We obtain the following results:<\/p>\n That’s quite the range of differences! It should be clear from the calculations that the “correct” answer is given by “f=1” for the “Time” method and by “f=2” for the “Period” method … but what if I’m wrong<\/em>?<\/p>\n Cells E31:E53 calculate the present value of the bond according to the “time” method when the Internal rate of return is increased by 1 basis point. Cells F31:F53 calculate the present value when the “Yield to Maturity” (= twice period return) is increased by 1 basis point. The change in price effected by these changes is calculated as PVBP (Price Value of a Basis Point) in cells H53 and I53, respectively.<\/p>\n We find that the Effective Modified Duration (we will refer to the results of this calculation as “Effective” modified duration because the change of 1bp in yield, while small, is not infinitesimal) is 5.93 for the “Time” method, which is equal to the answer calculated in cell H28 using f=1; it is 6.23 for the “Period” method, equal to the answer calculated in cell I29 using f=2.<\/p>\n Thus, we find that Equation (2) of the article is absolutely correct – given the universally accepted definition of yield-to-maturity as being\u00a0(periods per year) * (period-rate-of-return).<\/p>\n So, we can summarize our characterization of this bond as:<\/p>\n![\"modDurFormula.gif\"](\"http:\/\/www.prefblog.com\/wp-content\/uploads\/2007\/10\/modDurFormula.gif\")
<\/div>\n\n
\n
\n Modified Duration by Four Methodologies<\/td>\n<\/tr>\n \n \u00a0<\/td>\n “Time”<\/td>\n “Period”<\/td>\n<\/tr>\n \n f=1<\/td>\n 5.934<\/td>\n 5.948<\/td>\n<\/tr>\n \n f=2<\/td>\n 6.223<\/td>\n 6.231<\/td>\n<\/tr>\n<\/table>\n<\/div>\n