Please show work in excel. Thank you

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 A B D Price 984.00 799.00 767.00 566.34 Annual Coupon 3% 6% 5% Maturing in 2 years 5 years 10 years 8 years A B D E D 1 A B 8 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 YTM Start 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0 9.5 10.0 23 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 A B D Price 984.00 799.00 767.00 566.34 Annual Coupon 3% 6% 5% Maturing in 2 years 5 years 10 years 8 years A B D E D 1 A B 8 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 YTM Start 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0 9.5 10.0 23