Accounting Spreadsheet Assignment Credit Card You went on a binge. You've heard the old saying, "If you play, you're going to have to pay." The day of reckoning has arrived. Your current credit card balance is $10,000 D E A 1 Your Name 2 Credit Card Payment Schedule 3 Date 4 5 Interest Rate XX% 6 7 Monthly Pymt SXXX.XX 8 9 Monthly 10 Month Payment 11 0 12 1 SXXX.XX Interest Principal Card Balance 10,000.00 XXX.XX $ $XXX XX $XXX XX Hint: Interest - Card Balance Interest Rate 1/12 USE FORMULAS WHEREVER POSSIBLE Required (if you desire full credit): a) Use dollar signs at the top of each column ONLY. b) Right justify each column heading, b) Format each cell with two decimal places and commas (where appropriate). d) Prepare for the first 30 months only (to comfortably fit each on one page). MasterCard. VISA Please submit the following three spreadsheets: 1) Payments are $300 per month with an interest rate of 9% 2) Payments are $300 per month with an interest rate of 12% 3) Payments are 3% of loan balance with an interest rate of 11% ..20