Calculate These Questions Using An Excel Spreadsheet and Show All Formulas Used

15. (0.2 point) A 5 year, zero-coupon bond has a maturity of $1,000 and a present market price of $713. Its duration in years is (a) 4.7. (b) 5. (c) 4.2. (d) 3.9. 16.(0.5 point) A bond has a duration of 8 years and a present yield-to-maturity of 88. If the yie to-maturity rises to 10%, the approximate bond price change would be (a) +7.9%. (b) -25%. (c) -14.8%. (d) -12.98. 15. (0.2 point) A 5 year, zero-coupon bond has a maturity of $1,000 and a present market price of $713. Its duration in years is (a) 4.7. (b) 5. (c) 4.2. (d) 3.9. 16.(0.5 point) A bond has a duration of 8 years and a present yield-to-maturity of 88. If the yie to-maturity rises to 10%, the approximate bond price change would be (a) +7.9%. (b) -25%. (c) -14.8%. (d) -12.98