TEST REVIEW 3. Write the Excel function and arguments for DURATION of a par value 5 year, 10% coupon bond. Discount rate is also 10% 1 2. 3 4 % PV of Total Value 5 Weighted Maturity (1) "(4) Year Coupon 10% PV PV/51000 1 2 3 Duration: a. Use the table above to estimate the actual duration, (Show your work) b. Interpret your results. What does duration tell you? Based on your estimated duration, what are the effect on the band's price if Interest rates go from 10% to 11%. Explain AI MAP - DUR Duration is 2 years, how does affect the price of the bond? (Re-estimate the change in price with a 2-year duration in the formuta above) 1. Why are your results different? TEST REVIEW 3. Write the Excel function and arguments for DURATION of a par value 5 year, 10% coupon bond. Discount rate is also 10% 1 2. 3 4 % PV of Total Value 5 Weighted Maturity (1) "(4) Year Coupon 10% PV PV/51000 1 2 3 Duration: a. Use the table above to estimate the actual duration, (Show your work) b. Interpret your results. What does duration tell you? Based on your estimated duration, what are the effect on the band's price if Interest rates go from 10% to 11%. Explain AI MAP - DUR Duration is 2 years, how does affect the price of the bond? (Re-estimate the change in price with a 2-year duration in the formuta above) 1. Why are your results different