SUO FIN2030 (****** Both sum Calculated In Excel with formula) + Extra work Shee

SUO FIN2030 (****** Both sum Calculated In Excel with formula) + Extra work Sheet + 100% correct + as Discussed ******)1. Bond. What is the value of a $1000 par value bond with annual payments of ana. 11% coupon with a maturity of 20 years and a 15% required return?b. 12% coupon with a maturity of 10 years and a 7% required return?c. 8% semiannual coupon with a maturity of 10 years and a 11% required return?d. 8% semiannual coupon with a maturity of 20 years and a 6% required return?2. Bond. What is the yield to maturity of a $1000 par value bond with ana. 10% semiannual coupon and 20 years to maturity and a $1000 price?b. 6.5% semiannual coupon and 13 years to maturity and a $890 price?c. 7.5% annual coupon and 19 years to maturity and a $788 price?d. 4.5% annual coupon and 7 years to maturity and a $800 price?FIN 2030FIN2030