I need help filling in the excel spreadsheets, please show the formulas used for each cell in an excel spreadsheet and set up the spreadsheet as the attached spreadsheet is set up, the initial question is below, leave a comment if you have any questions

question 3 is the one to answer don't pay attention to question 2

2. What is the annual yield of a 15-year, 5.25% annual coupon-paying bond priced today at $799? Par is $1,000. 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 1.5% 10 4.15 B 4.4% 6 5.0 C 6.2% 5 4.2 D 0.0% 9 5.1 Which of the four bonds would you prefer to hold and why? (Answer in the box provided.) 2:17 PM SA 8/31/2020 O Type here to search BIU == E Merge & Center $ % 98 For Number Clipboard Font Alignment X SIGN IN REQUIRED We can't upload or download your changes because your cached credentials have expired. Sign In B4 x fx A E F G H J K L M 4 1 B B D D Yield 2 3 4 5 6 7 8 9 Price 0.5 1.0 1.5 2.0 2.5 3.0 3.5 10 11 4.0 4.5 5.0 12 13 14 15 16 17 18 19 20 21 22 23 24 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0 9.5 10.0 25 Prob. 1 Prob. 2 Prob. 3 Prob.4 Prob. 5 + H Type here to search IN $