Deposits to aceumulate future sums. For each case shown in the following table, determine the amount of the equal, endof-year deposits necessary to accumulate the given sum at the end of the specified period, assuming the stated annual interest rate. Impertant: Do not use cell references to cells in rows 7 to 10. For all required answers, use cell references to values starting in row 15 . Solution Requirenents 1 In cell G15, by using eell references to the given data and the function PMT, calculate the payment for case A. In cell G16, by using cell references to the given data and the function PMT, calculate the payment for 2 case B. 3 In cell G17, by using cell references to the given data and the function PMT, calculate the payment for case C.. In cell G18, by using cell references to the given data and the function PMT, calculate the payment for 4 case D. Deposits to aceumulate future sums. For each case shown in the following table, determine the amount of the equal, endof-year deposits necessary to accumulate the given sum at the end of the specified period, assuming the stated annual interest rate. Impertant: Do not use cell references to cells in rows 7 to 10. For all required answers, use cell references to values starting in row 15 . Solution Requirenents 1 In cell G15, by using eell references to the given data and the function PMT, calculate the payment for case A. In cell G16, by using cell references to the given data and the function PMT, calculate the payment for 2 case B. 3 In cell G17, by using cell references to the given data and the function PMT, calculate the payment for case C.. In cell G18, by using cell references to the given data and the function PMT, calculate the payment for 4 case D