The information in this article applies to:
SUMMARYDuration is a measure of the sensitivity of a bond's price to changes in interest rates. A bond with a high duration will tend to be highly sensitive to a change in interest rates. It is the preferred measure used by portfolio investment managers to evaluate what types of bonds they should include in a portfolio for a given investment objective. MORE INFORMATIONExampleThe example below outlines a method to calculate duration in Microsoft Excel. Consider the following bond for which dividends are paid annually:
Create a worksheet as follows:
The value for "duration" will be in cell E5. Duration is a weighted average time to full recovery of principal and interest payments from a bond. It is calculated as follows by dividing the summation of the present value of the cash flows, multiplied by the time period over which the cash flow occurs, multiplied by the price of the bond. The price of the bond is in cell C5. The present value of the cash flows divided by the price of the bond is in cells D2:D4. This value multiplied by the time period over which the cash flow occurs is in cells E2:E4. The duration, which is the sum of the values in cells E2:E4, is in cell E5. REFERENCES
"Function Reference," version 4.0, page 341-342
Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
Keywords : |
Last Reviewed: March 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |