Please show im excel with formulas. URGENT

3. Show the cash flows and prices for the following four bonds, each with a par value of $1,000 and paying interest semi-annually: # Years to Maturity Market Yield Coupon Rate 2.4% 5 5.0 B 3.4% 6 4.0 4.4% 8 4.6 D 0.0% 9 4.3 Which of the four bonds would you prefer to hold and why? (Answer in the box provided.) B D E F G H I J K L M N o P Enter choice here. 2 3 4. 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 A Yield Price 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 Prob. 1 Prob. 2 Prob. 3 Prob. 4 Prob. 5 v. FEB 2021 +