Solve question in Excel Format

1. Assume that Providence Health sold bonds that had a seven-year maturity, a 11 percent coupon rate with annual payments and a $2,000 par value. - Suppose that two years after the bonds were issued, the required interest rate fell to 8%. What would be the bonds' value? - Suppose that two years after the bonds were issued, the required interest rate rose to 14%. What would be the bonds value? - What would be the value of the bonds three years after issue in each scenario above, assuming that interest rates stayed steady at either 8 percent or 14 percent