please answer in excel format / excel equation to solve this. thank you!!

Problem 1 - 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? 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? c&d. 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? Please enter all answers in the following format: $1,234.56. Negative answers: ($1,234.56) Part A: Bond Value: Part B: Bond Value: Part C: Bond Value: Part D: Bond Value