Please show how to solve using EXCEL ONLY.

10. Calculate the duration of a $1,000, 12year zero coupon bond using annual compounding and a current market rate of 9 percent.

12. Calculate the duration for a $1,000, 4year bond with a 4.5 percent annual coupon, currently selling at par. Use the bonds duration to estimate the percentage change in the bonds price for a decrease in the market interest rate to 3.5 percent. How different is your answer from the actual price change calculated using Equation 5.6?