September 9th, 2008
Using the Bond Duration Add-in Functions
Making bond duration calculations? Microsoft Excel can help. Excel provides two functions that help you with bond duration calculations.
Excel provides two functions that let you make bond duration calculations: DURATION and MDURATION. Duration, a weighted average measure of the present value of a bond’s cash flows, quantifies how a change in the bond yield affects the bond price.
Understanding the Bond Duration Function Arguments