Deposits to accumulate future sums. For each case shown in the following table, determine the amount of the equal, end-of-year deposits necessary to accumulate the given sum at the end of the specified period, assuming the stated annual interest rate.

1. In cell G15, by using cell references to the given data and the function PMT, calculate the payment for case A.

2. In cell G16, by using cell references to the given data and the function PMT, calculate the payment for case B.

3. In cell G17, by using cell references to the given data and the function PMT, calculate the payment for case C.

4. In cell G18, by using cell references to the given data and the function PMT, calculate the payment for case D.

5. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.