1. The RHR Corporation's 11% coupon (paid semiannually) bonds mature in five years. The bonds' current yield...
Question:
1. The RHR Corporation's 11% coupon (paid semiannually) bonds mature in five years. The bonds' current yield to maturity is 12%.
a. Calculate the Macaulay duration of the bonds.
b. Calculate the modified duration of the bonds
c. Assume that the bonds' YTM drops from 12% to 11.5%. Calculate an estimate of the price change.
d. Explain why modified duration is a better measure than maturity when calculating the bond's sensitivity to changes in interest rates.
e. Identify the direction of change in modified duration if:
(1) The coupon rate of the bond was 9% rather than 11%
(2) The maturity of the bond was 8 years rather than 5 years.
f. Define convexity and explain how modified duration and convexity are used to approximate the bond's percentage change in price given a large change in interest rates. I need to answer those in excel. Thank you