please show within excel not just the fuction but detail please and also attach data if possible

13. Calculate the fair present value of the following bonds, all of which have a 10 percent coupon rate (paid semiannually), face value of $1,000, and a required rate of return of 8 per- cent. (LG 3-5) a. The bond has 10 years remaining to maturity. b. The bond has 15 years remaining to maturity. c. The bond has 20 years remaining to maturity. d. What do your answers to parts (a) through (c) say about the relation between time to maturity and present values? 14. Repeat parts (a) through (c) of Problem 13 using a required rate of return on the bond of 11 percent. What do your cal- culations imply about the relation between time to maturity and bond price volatility? (LG 3-5) 15. A $1,000 par value bond with five years left to maturity pays an interest payment semiannually with a 6 percent cou- pon rate and is priced to have a 5 percent yield to maturity. If interest rates surprisingly increase by 0.5 percent, by how much will the bond's price change? (LG 3-4)