this is an excel assignment, if you could please answer/work the problem in a spreadsheet style format that would help me so much when trying to figure this out. you can answer the questions 1, 2, 3 in sentence form. thank you for your time!

Part 1 Bond A Bond B Bond C Face value 1000 1000 1000 15 8 coupon rate 11% 11% 11% Yield to Maturity 15 10 9 Years left to Maturity Annual or Semi.Annual Annual Annual Annual You have been hired as a financial analyst. Your client has the choice between buying one of the bonds listed in the table above. You are required to create a detailed report to aid your client to reach a decision. 1. Compute the price of each bond. Why are the bonds' prices different? 2. Compute the duration for each bond. What is the meaning of the duration result for each bond? 3. Analysts have predicted that in 3 months real interest rates will be 4% and that expected inflation will be 6.5%. Use the duration for each bond to help you to compute the expected percentage change in each price due to the change in the prevailing market interest rates in 3 months. Which bond will be more sensitive to the change in interest rates