Layout References MallingsReview View LO Styles Styles | :::,,l.chri I.. Pane to-date with security updates, fixes, and Improvements, choose Check for Updates. Math 123 Quantitative Reasoning Section 10 Excel Credit Cards Assignment Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas and the drag function of Excel (see the notes), find the values for 1 year of charges 1. With a beginning balance of $3200 and no additional charges, you will just pay the minimum payment each month for the next year. The APR is 21.99% and the minimum payment each month is 6% of the balance. Determine the finance charge, new balance, and minimum payment required for each of the next year, and the starting balance for month 13: What is the total of the minimum payments? What is the total of the finance charges? How much does the starting balance decrease after one year of payments? The total of your finance charges is what percent of your total payments? Explain why making the minimum payment all the time is great for the credit card a. b. c. d. e. company, but not so great for the user. You will need to submit both your Excel spreadsheet and a Word document with the answers to the questions in order to receive full credit for this assignment. English (United States) '-- Focus