Find the duration of a bond with a settlement date of May 27, 2020, and maturity date November 15, 2031. The coupon rate of the bond is 5.5%, and the bond pays coupons semiannually. The bond is selling at a bond-equivalent yield to maturity of 6.0%. Use Spreadsheet 16.2. (Do not round intermediate calculations. Round your answers to 4 decimal places.)

Duration is used to determine a bond's price sensitivity to interest rate changes. For fixed rate bonds, an increase in market interest rates leads to a decrease in the price of a bond. On the other hand, a decrease in market interest rates leads to an increase in the price of a bond. The longer the duration, the greater the swings in a bond price for a given change in interest rates. There are various types of duration. Two well-known types used for straight bonds (i. e., bonds without embedded options) are Macauley Duration and Modified Duration. Macauley duration is the weighted average of the time until cash flow dates, where the weights are given by the fraction of the present value arising from that period's cash flow. Modified Duration is derived from Macauley Duration.

Answer and Explanation:

The formula used to calculate Macauley Duration is shown below:

{eq}Duration = t_1 * / frac{c * d (t_1) }{PV} + t_2 * / frac{c * d (t_2) }{PV} + ...