Credit Cards, time in months to payoff and payoff amount

M

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)?
 
F

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top