You owe $2000 on a credit card. The card charges 1.5% monthly interest on your balance, and requires a minimum monthly payment of 2.5% of your balance. All transactions (payments and interest charges) are recorded at the end of the month. You make only the minimum payment every month and incur no additional debt.

A) Complete the table for a twelve month period.

B) What is your unpaid balance after one year had passed?

C) At that time, how much of your debt have you paid off?

D) How much money in interest charges have you paid your creditors?

This is most conveniently done using a spreadsheet program, such as Microsoft Excel or Google Sheets. The latter is one of many free or low-cost spreadsheet programs available for a number of platforms, including phones, tablets, and personal computers.

__

As the problem statement tells you, the amount of interest paid is 0.015 times the balance.

As the problem statement tells you, the minimum payment is 0.025 times the balance.

Of course, the new balance is the difference between the previous balance and the amount of the payment.

The spreadsheet allows you to copy the formulas doing these calculations into all the appropriate cells of the table, so the remaining table is filled "automatically."

Spreadsheet functions also make it simple to do the sums and differences required to answer parts C and D.

A) see below

B) The beginning balance after 12 payments is $1,476.00.

C) The difference between the original debt and the amount remaining after 12 months is ...

2000 -1476 = 524 . . . dollars

D) The sum of the 12 interest charges is $314.41.