I need assistance with solving for the empty yellow cells in the image below:

Image transcription text

-1 v Lh = W D \o GO 24 A G H I J K 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. Coupon Par value Market rate Cash flows: 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 Price b, __ E_ _F|___ G Coupon 6.00% 6.70% 5.40% 0.00% Par Value 1,000 Cash flows: Market price (757) (813) (799) (505) 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 Yield

Transcribed Image Text:

2 A B E F G H I J K 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. 3 4 A B E F G 5 Coupon 4.6% 5.0% 6.0% 0.0% Coupon 6.00% 6.70% 5.40% 0.00% 6 Par value 1,000 Par Value 1,000 7 Market rate 4.7% 5.2% 5.9% 5.5% Cash flows: 8 Cash flows: Market price (757) (813) (799) (505) 9 0.5 0.5 10 1.0 1.0 11 1.5 1.5 12 2.0 2.0 13 2.5 2.5 14 3.0 3.0 15 3.5 3.5 16 4.0 4.0 17 4.5 4.5 18 5.0 5.0 19 5.5 5.5 20 6.0 6.0 21 6.5 6.5 22 7.0 7.0 23 24 Price Yield 25 2 A B E F G H I J K 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. 3 4 A B E F G 5 Coupon 4.6% 5.0% 6.0% 0.0% Coupon 6.00% 6.70% 5.40% 0.00% 6 Par value 1,000 Par Value 1,000 7 Market rate 4.7% 5.2% 5.9% 5.5% Cash flows: 8 Cash flows: Market price (757) (813) (799) (505) 9 0.5 0.5 10 1.0 1.0 11 1.5 1.5 12 2.0 2.0 13 2.5 2.5 14 3.0 3.0 15 3.5 3.5 16 4.0 4.0 17 4.5 4.5 18 5.0 5.0 19 5.5 5.5 20 6.0 6.0 21 6.5 6.5 22 7.0 7.0 23 24 Price Yield 25