3 4 S Excel Work #5 This assignment is based on contents in 4D. #2 Suppose we borrow $1000 with the following terms. APR n Y 2% 12 10 Use arrow to adjust APR. P 1,000.00 1. Produce a table that shows (at 7 columns, not necessarily in this order) month (should be the first column. Numbers 1 through 120) Balance at the beginning of the month Interest debt created during the month payment made at the end of the month (using PMT formula) Percentage of payment that went toward paying for Interest created Percentage of payment that went toward the reduction of Principal Balance at the end of the month 2. At the bottom of the "Interest debt....." column, compute the total interest paid. 3. At the bottom of the " Payment made......" column, compute the total. 4. The items #2 and #3 above can be used to check if your table is correct. If these two numbers and the principal do not fit together exactly, there is something wrong with your table. Correct it! Otherwise, continue. 5. Create a scatter plot that shows the balance (debt) as a function of month.. 6. Create a "Stacked Area Chart" using the two "percentage" columns. (a) With 7. Now, read your own table to answer the following questions. APR 8% what is your monthly payment? (b) With APR 20%, how many months will it take before you start paying more for principal reduction than for the Ma Seoring Gu Scoring Ga 7. Now, read your own table to answer the following questions. APR 8% what is your monthly payment? (a) With (b) With APR 20%, how many months will it take before you start paying more for principal reduction than for the interest? Write your answers in the green box ( at row 51) APR W H - M M H month B Balance at the Beginning of the Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 10 1,000.00 17 18 APR DIAL CREATE YOUR TABLE HERE. Interest Created Payment Made Percent of Payment Used for Paying Interest Percent of Payment Used for Reducing Principal Balance at the End of the Mont APR Dial 2% Seving # Topp Put your response to #5 in this box Put your answer to #6 (stacked area chart in this box