Please show all 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% 566.34 8 years 10 years D A B c D YTM Start 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10