Question: please help Accounting Spreadsheet Assignment Credit Card You went on a binge. You've heard the old saving. If you play, you're going to have to
Accounting Spreadsheet Assignment Credit Card You went on a binge. You've heard the old saving. If you play, you're going to have to pay. The day of reckoning has arrived. Your current credit card balance is $10,000 1 Your Name 2 Credit Card Payment Schedule 3 Date 5 Interest Rate XX% 7 Monthly Pymt L SXXX.XX Month Card Balance 10,000.00 XXX.XX Monthly Payment Interest Principal SXXX.XX $XXX.XX Sxxxxx Hint: Interest Card Balance Interest Rate 1/12 $ USE FORMULAS,461,85 WHEREVER POSSIBLE Required: 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%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
