PLEASE FILL THE PROVIDED EXCEL TEMPLATE!!!

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 C D Price 654.00 690.00 1,031.00 440.00 Annual Coupon 2.0% 2.6% 2.5% Maturing in 6 years 8 years 10 years 10 years E F G H I J K B A B D 1 D - 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 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 8990 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 C D Price 654.00 690.00 1,031.00 440.00 Annual Coupon 2.0% 2.6% 2.5% Maturing in 6 years 8 years 10 years 10 years E F G H I J K B A B D 1 D - 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 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 8990