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 Weighted Maturity (1)*(4) Year Coupon 10% PV PV/$1000 Duration: a. Use the table above to estimate the actual duration. (Show your work) b. Interpret your results. What does duration tell you? i. Based on your estimated duration, what are the effect on the bond's price if interest rates go from 10% to 11%. Explain. %AP ~ -DUR (43) 1 + i ii. If 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 formula above). 1. Why are your results different