Modified duration is a formula that measures the sensitivity ... value of $1,000 that matures in three years. This bond has an annual coupon rate (the yield paid through maturity) of 5%.

To use the Duration function in Microsoft Excel, follow the steps below. Launch Excel Create a table or use an existing table Type the formula for ... the security’s annual yield.