Problem 5-47 Deposits to accumulate future sums. For each case shown in the following table, determine...

Transcribed Image Text:

Problem 5-47 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. Important: 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. Case Sum to be accumulated Accumulation period (years) Interest rate ABCD $ 5,000 3 12% 100,000 20 7 30,000 8 10 15,000 12 8 Solution Sum to be Accumulation Case accumulated period (years) Interest rate Payment A $5,000 3 12% B $100,000 20 7% C $30,000 8 10% D $15,000 12 8% Requirements Points 1 In cell G15, by using cell references to the given data and the function PMT, calculate the payment for case A. 1 2 In cell G16, by using cell references to the given data and the function PMT, calculate the payment for case B. 1 3 In cell G17, by using cell references to the given data and the function PMT, calculate the payment for case C. 1 4 In cell G18, by using cell references to the given data and the function PMT, calculate the payment for case D. 1 5 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Problem 5-47 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. Important: 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. Case Sum to be accumulated Accumulation period (years) Interest rate ABCD $ 5,000 3 12% 100,000 20 7 30,000 8 10 15,000 12 8 Solution Sum to be Accumulation Case accumulated period (years) Interest rate Payment A $5,000 3 12% B $100,000 20 7% C $30,000 8 10% D $15,000 12 8% Requirements Points 1 In cell G15, by using cell references to the given data and the function PMT, calculate the payment for case A. 1 2 In cell G16, by using cell references to the given data and the function PMT, calculate the payment for case B. 1 3 In cell G17, by using cell references to the given data and the function PMT, calculate the payment for case C. 1 4 In cell G18, by using cell references to the given data and the function PMT, calculate the payment for case D. 1 5 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0