A 5 Coupon 5 Par value 7 Market rate 8 Cash flows: 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Price 27 28 0.5 1.0 1.5 2.0 2.5 cm3 4 +55 6 onono 3.0 3.5 Given the coupons, par values, market rates and market prices below, please calculate the prices for bonds A-D and the yields for bonds D-G. 4.0 4.5 5.0 5.5 6.0 6.5 7.0 7.5 50 B 8.0 A 4.5% C 4.5% B 5.5% D 5.9% 0 5.8% E 5.1% D 0.0% 1.000 F 5.0% G Coupon Par Value Cash flows: Market price Yield 0.5 1.0 15 2.0 Ni ma 2.5 OnoV 3.0 3.5 4.0 4.5 5.0 5.5 in 6.0 6.5 7.0 7.5 8.0 H OVO D 5.33% I (882) E 5.55% J (874) F 4.95% K (787) 0.00% 1.000 (623)

please show excel breakdown

Given the coupons, par values, market rates and warket prices below, please calculate the prices for bonds A-D and the yields for bonds D-G