Can you show the formula to put the answers to A, B, and C in an excel spreadsheet? Please upload an excel spreadsheet document with the response.

Assume Venture Healthcare sold bonds that have a ten-year maturity, a 12 percent coupon rate with annual payments, and a $1,000 par value. a. Suppose that two years after the bonds were issued, the required interest rate fell to 7 percent. What would be the bond's value? Solution: Par value = $1,000 Annual coupon = 12% of 1,000 = $120 Time to maturity = 10 - 2 = 8 years Value of the bond P = 120*PVIFA7%, 8 + 1,000*PVIF7%, 8 = 120*5.971 + 1,000*0.582 = 716.52 + 582 = $1,298.52 b. Suppose that two years after the bonds were issued, the required interest rate rose to 13 percent. What would be the bond's value? Solution: Par value = $1,000 Annual coupon = 12% of 1,000 = $120 Time to maturity = 10 - 2 = 8 years Value of the bond P = 120*PVIFA13%, 8 + 1,000*PVIF13%, 8 = 120*4.799 + 1,000*0.376 = 575.88 + 376 = $951.88 c. What would be the value of the bonds three years after issue in each scenario above, assuming that interest rates stayed steady at either 7 percent or 13 percent? Solution: Time to maturity = 10 - 3 = 7 years Interest rate = 7%, Value of the bond P = 120*PVIFA7%, 7 + 1,000*PVIF7%, 7 = 120*5.389 + 1,000*0.623 = 646.68 + 623 = $1,269.68 Interest rate = 13%, Value of the bond P = 120*PVIFA13%, 7 + 1,000*PVIF13%, 7 = 120*4.423 + 1,000*0.425 = 530.76 + 425 = $955.76