Credit Cards, time in months to payoff and payoff amount

[Mike Johnstone]

How can I calculate the amount of money needed and the amount of time in
months to pay off a credit card, it I know the balance, the percentage rate
(compound interest) and the monthly minimum payment (2 to 3% of the unpaid
balance)?

 

[Fred Smith]

The Nper function will give you the number of months required given a fixed
monthly payment.

If the payment changes each month, you would need to build a table to determine
the months required.

Note that if you always use "2 to 3% of the unpaid balance", the loan will never
be paid off. To pay the loan off at some point, you will have to set a minimum
"minimum payment".