calculate-loan

01 Loan payments

How to Calculate Credit Card Payoff Date

Calculator No. 01-22287 · Updated · Formula and assumptions shown below

Months to payoff 32 months
Payoff date
2,024
= 2026-01-01
Total interest
$1,400.00
= Monthly payment × months to payoff − current balance
Current balance
$5,000
Input
You enter
Current balance ($), Interest rate (APR) (%), Monthly payment ($)
You get
Months to payoff (months), Payoff date, Total interest ($)
Rounding
0 dp · 2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

This guide shows you how to calculate the date your credit card balance will be paid off based on your current balance, interest rate, and monthly payment. You’ll get a clear payoff date and see how much interest you’ll pay. All you need is your latest statement and a calculator.

Formula

The number of months to pay off a credit card balance with a fixed monthly payment is calculated using the following formula:

n = ⌈ -ln(1 – r × B / P) / ln(1 + r) ⌉

Where:

  • n = number of months to payoff (rounded up to the next whole month)
  • r = monthly interest rate = APR / 1200 (APR is the annual percentage rate, e.g., 18% → 0.015 per month)
  • B = current balance (in dollars)
  • P = fixed monthly payment (in dollars)

The formula comes from the standard amortization equation. It assumes interest is compounded monthly and that you make the same payment every month until the balance reaches zero.

Worked Example

Using the default values from the calculator:

  • Balance (B) = $5,000
  • APR = 18% → monthly rate r = 18 / 1200 = 0.015
  • Monthly payment (P) = $200

Step 1: Calculate r × B / P

0.015 × 5000 / 200 = 75 / 200 = 0.375

Step 2: Calculate 1 – r × B / P

1 – 0.375 = 0.625

Step 3: Take the natural log: ln(0.625) ≈ -0.4700036

Step 4: Calculate ln(1 + r) = ln(1.015) ≈ 0.0148886

Step 5: Divide and negate: -(-0.4700036) / 0.0148886 ≈ 31.56

Step 6: Round up to the next whole month: 32 months

So the payoff date is 32 months from now. If today is January 1, 2025, the payoff date would be September 1, 2027.

Total interest paid = P × n – B = 200 × 32 – 5000 = 6400 – 5000 = $1,400.

Assumptions

  • The APR remains constant for the entire payoff period.
  • You make the same fixed payment every month, on time.
  • Interest is compounded monthly at APR / 12.
  • No additional purchases, fees, or cash advances are added to the balance.
  • The result is an estimate; your credit card issuer’s disclosure provides the exact payoff figures.

When to Use This Calculation

Use this calculator when you want to know how long it will take to eliminate your current credit card balance with a set monthly payment. It helps you set realistic payment goals and compare different payment amounts. For example, you can see how increasing your payment by $50 shortens the payoff time and reduces total interest.

How to Read the Result

The main output is the number of months to payoff. The payoff date is calculated by adding that many months to today’s date. The total interest shows how much extra you’ll pay beyond the principal. A higher payment reduces both the months and the interest.

Common Mistakes

  • Using the APR as a monthly rate: Always divide the APR by 12 (and by 100 to convert from percentage to decimal). For example, 18% APR = 0.18 per year, 0.015 per month.
  • Forgetting to round up: The formula gives a fractional number of months; you must round up to the next whole month because you can’t make a partial payment.
  • Ignoring the minimum payment: If you only pay the minimum, the payment changes over time as the balance drops. This calculator assumes a fixed payment, so it won’t match a minimum-payment scenario.
  • Not including new purchases: If you continue using the card, the balance will not decrease as quickly, and the payoff date will be later.

Tips

  • Use the exact APR from your statement, not an average or estimate.
  • If you can, round your payment up to the nearest $10 or $50 to simplify tracking.
  • Check your statement for any annual fees or other charges that might be added to the balance.
  • Consider setting up automatic payments to avoid late fees and interest rate increases.
  • Re-run the calculation after any change in your APR or payment amount.

Troubleshooting

If the calculator shows “Cannot compute”: This means your payment is not enough to cover the monthly interest. For example, with a $5,000 balance at 18% APR, the monthly interest is $75, so a payment of $50 would never pay off the debt. Increase your payment to at least the monthly interest plus $1.

If the payoff date seems too far away: Check that you entered the balance correctly and that your payment is realistic. Even a small increase in payment can significantly shorten the payoff time.

If the total interest seems too high: That’s the reality of carrying a balance. Try increasing your payment to see how much interest you can save.

Frequently Asked Questions

What if I make multiple payments per month?

The formula assumes one payment per month. If you make biweekly payments, you can use the total monthly amount (e.g., $100 every two weeks = $200 per month) and get a close estimate. Interest is still compounded monthly, so the result is approximate.

Does the payoff date change if my APR changes?

Yes. If your APR increases, the payoff date will be later (unless you increase your payment). If your APR decreases, you’ll pay off the balance sooner.

What is the minimum payment and how does it affect the payoff date?

Minimum payments are usually a percentage of the balance (e.g., 1-3%) or a fixed amount, whichever is higher. Since the minimum decreases as the balance drops, the payoff time is much longer than with a fixed payment. This calculator is for fixed payments only.

Can I use this for a 0% APR promotional period?

Yes, but you’ll need to adjust the APR to 0% for that period. However, if the APR changes after the promo, you’ll need to recalculate. This calculator assumes a constant APR.

How do I find my current APR?

Your APR is listed on your monthly statement, usually in a section called “Interest Charge Calculation” or “Pricing Information.” It may be a variable rate tied to the prime rate.

Should I include fees in the balance?

Yes, include any outstanding fees, such as annual fees or late fees, in the balance field. This gives a more accurate payoff estimate.

Remember, this calculation is an estimate. Your credit card issuer’s monthly statement provides the exact payoff amount and interest charges.

Related

Formula used
in bal | Current balance | $ | 5000 | 0 | 1000000
in apr | Interest rate (APR) | % | 18 | 0.01 | 100
in pay | Monthly payment | $ | 200 | 1 | 1000000
out months | Months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * bal / pay) / ln(1 + apr / 1200), 6)) | 0
out date | Payoff date | - | 2026-01-01 | 0
out interest | Total interest | $ | pay * months - bal | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →