Choose a credit card balance between $2500 and $3000 this will be your starting balance on the table. In this part, we are going to pay it off. Assume the interest rate to 15% of the unpaid balance. Use the column headings below. Assuming you charge $300 per month and you pay $400 per month, add rows to the table until you have paid off your debt (that is, until the balance is between zero and 100 dollars). In this scenario, we assumed that you diligently paid $400 per month on your credit card until the balance was almost paid off. Most credit cards, however, suggest minimum monthly payments that are well below $400 per month. Let us assume that the criterion for calculating the minimum monthly payment on this credit card is 2% of your balance or $10.00 whichever is higher. Add another column to the table that will show the minimum monthly payment. (hint: use the Max function)

Instructions for Part 2

At the bottom of the spreadsheet, label the second tab, Part 2.

Make a credit-card table on the worksheet as described. .

Have the interest rate of 15% as a separate labeled cell.

Have the minimum payment percent of 2% as a separate labeled cell.

The table should have the following columns:

#

Month

Payment

Balance

Plus Charges

Interest

New Balance

MinPymt

For example,

#	Month	Payment	Balance	Plus Charges	Interest	New Balance	MinPymt
1	January	$400.00	$2,600.00	$300.00	$36.25	$2,936.25	$58.73

All entries in columns Old, Interest, New, and MinPymt must be formulas.

Center and bold the table titles.

# means month number. This column should be 1, 2, 3, etc.

Payment means the $400 payment.

Balance is the total amount of debt. For the first line of the table, you will choose a debt between $2500 and $3000. In subsequent lines, Balance = New Balance - $400.

Plus Charges will be $300 of spending charges per month.

Interest is 15% of the sum of the Balance, Plus Charges. Use an Excel formula to calculate this amount.

New Balance is the sum of the Balance, Plus Charges, and Interest. Use an Excel formula to calculate this amount.

MinPymt is 2% of the New Balance or $10, whichever is higher. Use an Excel formula to calculate this amount. (Max function is helpful.)

Copy/Paste line 2 to create the table.

After you complete 20+ lines of the table, analyze the results and provide suggestions for the credit card holder.