calculate-loan

01 Loan payments

Credit Card Payoff Calculator Month by Month

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

Months to payoff 32 months
Total paid
$6,400.00
= Monthly payment × months to payoff
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), Total paid ($), 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.

A credit card payoff calculator month by month shows your exact payment schedule, including how much of each payment goes to interest versus principal, and when the balance reaches zero. You enter your current balance, annual interest rate (APR), and a monthly payment, and it returns the number of months to payoff, total interest paid, and a full month-by-month breakdown.

Formula

The calculator uses the standard amortization formula rearranged to solve for the number of months. The monthly interest rate is r = APR / 1200 (APR is an annual percentage, so you divide by 100 to get a decimal and by 12 for months). The number of months to payoff is:

n = −ln(1 − r × P / M) / ln(1 + r)

where:

  • P = current credit card balance (in dollars)
  • APR = annual percentage rate (as a percentage, e.g., 18 for 18%)
  • r = monthly interest rate = APR / 1200
  • M = fixed monthly payment (in dollars)
  • n = number of months to payoff (rounded up to the next whole month)

This formula assumes you make the same payment every month, the APR stays constant, and interest compounds monthly on the unpaid balance.

Worked Example

Using the default values: balance P = $5,000, APR = 18%, monthly payment M = $200.

  1. Monthly rate: r = 18 / 1200 = 0.015
  2. Compute r × P / M = 0.015 × 5000 / 200 = 75 / 200 = 0.375
  3. 1 − 0.375 = 0.625
  4. ln(0.625) ≈ −0.4700
  5. −ln(0.625) = 0.4700
  6. ln(1 + 0.015) = ln(1.015) ≈ 0.014889
  7. n = 0.4700 / 0.014889 ≈ 31.57 months
  8. Round up to 32 months.

Total paid = $200 × 32 = $6,400. Total interest = $6,400 − $5,000 = $1,400. The calculator shows 32 months, $6,400 total, and $1,400 interest.

Assumptions

  • Fixed APR for the entire payoff period (credit card APRs can change).
  • Monthly compounding at APR / 12.
  • Payments are made at the end of each billing cycle.
  • No additional purchases, fees, or balance transfers are added.
  • Minimum payment requirements are ignored; you pay the same amount each month.

How to Use the Month-by-Month Breakdown

While the calculator gives you the total months, the month-by-month breakdown is what shows you the progress. Each month, the interest is calculated on the remaining balance, and the rest of your payment reduces the principal. For example, in month 1 with a $5,000 balance at 1.5% monthly interest, interest is $75, so $125 of your $200 payment goes to principal, leaving $4,875. In month 2, interest is $73.13, principal reduction is $126.87, and so on. The interest portion decreases each month because the balance shrinks.

You can replicate this with a simple spreadsheet: for each row, interest = previous balance × r, principal = payment − interest, new balance = previous balance − principal. Continue until the balance reaches zero. The calculator’s formula does this in one step, but the breakdown helps you see how much of your money is going to interest early on.

Common Mistakes and Misconceptions

  • Using the minimum payment: The minimum payment is usually a percentage of the balance (e.g., 1–2%) plus interest, so it decreases over time. If you enter a fixed minimum as a constant, the result will be wrong because the payment actually drops.
  • Forgetting that APR is annual: Dividing the APR by 12 is correct for monthly interest, but some people mistakenly divide by 12 after converting to a decimal incorrectly. Always use APR / 1200.
  • Rounding too early: If you round the monthly interest to the nearest cent each month, the final month may differ slightly. The formula assumes exact interest, so the real-world payoff might be a few cents off.
  • Ignoring rate changes: Many cards have a promotional APR that jumps after a period. This calculator assumes a constant rate, so if your rate changes, you need to recalculate with the new rate for the remaining balance.

How to Choose a Monthly Payment

Your payment amount directly affects how fast you pay off the card and how much interest you pay. A higher payment shortens the term and reduces total interest, but you need to choose an amount that fits your budget. A common strategy is to pay more than the minimum, but the calculator lets you test different amounts. For example, with a $5,000 balance at 18% APR:

  • $200/month → 32 months, $1,400 interest
  • $250/month → 24 months, $1,000 interest
  • $300/month → 20 months, $800 interest

Notice that increasing the payment by $50 saves you $400 in interest and 8 months. The calculator lets you compare scenarios before you commit.

What If Your Payment Doesn’t Cover the Interest?

If your monthly payment is less than the monthly interest (i.e., M ≤ r × P), the balance will never decrease—it will grow or stay the same. The calculator shows “Cannot compute” in that case. For example, with a $5,000 balance at 18% APR, the monthly interest is $75. If you pay only $50, you’re not covering the interest, so the balance increases. This is a critical reason to avoid paying only the minimum on a high-rate card. Always ensure your payment exceeds the interest to make progress.

Alternatives to a Fixed Payment

Some people prefer a different payoff approach, such as paying a fixed amount plus any new interest, or making extra payments when possible. The calculator models a fixed payment, which is simple and predictable. If you make irregular extra payments, you can use the calculator for each segment: after an extra payment, recalculate with the new balance and the same APR. Another alternative is the debt snowball or avalanche method, which involves multiple cards—this calculator handles one card at a time, but you can run it for each card to plan your overall strategy.

Frequently Asked Questions

How do I calculate the month-by-month breakdown myself?

Start with your balance. Each month, multiply the balance by the monthly rate (APR/1200) to get interest. Subtract that interest from your payment; the remainder reduces the balance. Repeat until the balance is zero. A spreadsheet makes this easy, and the formula n = −ln(1 − rP/M)/ln(1+r) gives the total months directly.

Why does the calculator show “Cannot compute”?

That happens when your monthly payment is less than or equal to the monthly interest. In that case, the balance never decreases—it grows or stays the same. You need to increase your payment to at least cover the interest plus a little extra to make progress.

Does the calculator include annual fees or other charges?

No. It only models the balance, APR, and payment. Annual fees, late fees, balance transfer fees, and cash advance fees are not included. If you have such fees, add them to the balance or account for them separately to get a more accurate picture.

What if my APR changes during the payoff period?

The calculator assumes a constant APR. If your rate changes, you can recalculate using the remaining balance at the time of the change. For example, if you pay for 10 months at 18%, then the rate drops to 15%, use the balance after 10 months as the new principal and recompute the months with the new APR.

Is it better to pay more than the minimum?

Yes, because the minimum payment is often designed to keep you in debt for years and results in much higher total interest. The calculator shows that even a modest increase in your payment can dramatically reduce the payoff time and interest. However, you should always ensure the payment fits your budget.

How does the calculator handle rounding in real life?

Credit card companies round interest to the nearest cent each month, so your actual payoff may differ by a few cents or a month. The calculator uses exact math, so treat the result as an estimate. The lender’s statement will show the exact payoff amount.

This calculator provides an estimate based on the assumptions above; your credit card statement and lender’s disclosure give the exact figures.

Related

Formula used
in p | Current balance | $ | 5000 | 1 | 1000000
in apr | Interest rate (APR) | % | 18 | 0.01 | 100
in pmt | Monthly payment | $ | 200 | 1 | 1000000
out months | Months to payoff | months | ceil(round(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200), 6)) | 0
out tot | Total paid | $ | pmt * months | 2
out int | Total interest | $ | pmt * months - p | 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 →