please show all the formulas (how to use in excel) and steps in detail.

PROBLEM 1 Assume HCA 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. 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