Please show Excel Formulas

3. Bond Valuation Given the purchase prices, coupons and maturities of four bonds, calculate the yields to maturity to you, the investor. Assume a $1,000 par value. Bonds A, B, and Care semi-annual. Bond D is a zero but calculate its yield with a semi-annual equivalency. Provide your answers to 4 significant digits (example: 6.1234%) Bond Price Annual Coupon Maturing in A 984.00 3% 2 years B 799.00 6% 5 years 767.00 5% 10 years D 566.34 8 years A F B A D E D B YTM Start 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 4.5 5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0 9.5 10.0 2 . 2 2