# i need excel formula to solve these problems

A B C D E F G Bond valuation: Annual interest. Calculate the value of each of the bonds shown in the following table, all of which pay interest annually Coupon interest rate 11% Years to maturity Bond Required return 12% 20 Par value 1,000 1,000 100 500 1,000 a000 Solution Bond A Par value Coupon interest rate Years to maturity Required return Coupon payment Present value 1,000 11% 20 12% 1,000 89% Bond B Par value Coupon interest rate Years to maturity Required return Coupon payment Present value 8 % Problem 6-16 221 0101 2219 SAM S 100 99 Bond C Par valve Coupon interest rate Years to maturity Required return Coupon payment Present value 7% Bond D Par value Coupon interest rate Years to maturity Required return Coupon payment Present value 500 6% 13 8% Bond E Par value Coupon interest rate Years to maturity Required return Coupon payment Present value 1,000 70% 10 5% 55 Requirements 56 1 In cell E 19, by using cell references to the given data, calculate the coupon payment 2 In cell E20, by using cell references to the given data and the function PV, calculate Problem 6-16 9 20 21a0| lg 2