calculate-loan

01 Loan payments

Credit Card Payoff Schedule: How to Build One

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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 schedule is a month-by-month plan that shows your payment amount, the interest charged, and your remaining balance until the card reaches $0. You enter your current balance, interest rate (APR), and either a fixed monthly payment or a target payoff date, and the schedule tells you how long it will take and how much total interest you will pay.

Formula

The schedule uses the standard amortization formula for a fixed monthly payment:

Monthly payment = P × (r / (1 − (1 + r)^(−n)))

  • P = current credit card balance (in dollars)
  • r = monthly interest rate = APR ÷ 12 ÷ 100 (as a decimal)
  • n = total number of monthly payments (years × 12)

Each month, the interest charged is the current balance times the monthly rate. The rest of your payment reduces the principal. The formula above finds the fixed payment that exactly pays off the balance after n months.

Worked Example

Using the calculator defaults: balance = $5,000, APR = 22%, payoff time = 3 years.

  1. Convert APR to monthly rate: r = 22 ÷ 1200 = 0.0183333
  2. Total months: n = 3 × 12 = 36
  3. Plug into the formula: payment = 5000 × (0.0183333 / (1 − (1 + 0.0183333)^(−36)))
  4. Calculate (1 + 0.0183333)^(−36) ≈ 0.5196, so denominator = 1 − 0.5196 = 0.4804
  5. Payment = 5000 × (0.0183333 / 0.4804) = 5000 × 0.03816 = $190.80 (rounded)
  6. Total paid = 190.80 × 36 = $6,868.80
  7. Total interest = 6,868.80 − 5,000 = $1,868.80

The calculator shows a monthly payment of $190.80 and total interest of $1,868.80, matching the steps above.

Assumptions

  • Fixed APR for the entire payoff period (credit card APRs can change).
  • You make the same payment every month on the same due date.
  • Interest compounds monthly at APR ÷ 12.
  • No new purchases, fees, cash advances, or balance transfers are added.
  • Minimum payment requirements and late fees are not included.

How to Read Your Payoff Schedule

Each row of a payoff schedule shows four things: the month number, the payment amount, the interest portion of that payment, and the remaining balance after the payment. Early in the schedule, most of your payment goes to interest. For example, in the first month of the worked example, interest is 5000 × 0.0183333 = $91.67, so only $99.13 reduces the principal. By the final month, nearly the entire payment goes to principal because the balance is small.

You can use the schedule to see how much total interest you will pay over the life of the debt. Comparing a 3-year plan with a 5-year plan shows that a longer schedule lowers the monthly payment but increases total interest. For a $5,000 balance at 22% APR, a 5-year plan requires about $137.65 per month and costs $3,259 in interest – about $1,390 more than the 3-year plan.

Common Mistakes and Misconceptions

  • Using the minimum payment. The minimum payment is usually 1%–3% of the balance plus interest, so it shrinks as the balance shrinks. Paying only the minimum can stretch payoff over decades and triple the interest cost.
  • Ignoring the APR change. Many cards have a promotional 0% APR for a set period. After that, the rate jumps to the regular APR. Your schedule should use the regular APR unless you are certain you will pay off the balance before the promo ends.
  • Adding new purchases. If you keep using the card, the balance goes up, and the schedule no longer applies. A payoff schedule assumes you stop spending on that card.
  • Rounding too early. Rounding the monthly rate to 0.018 instead of 0.018333 changes the payment by a few cents each month. Over 36 months, that adds up to a few dollars.
  • Forgetting that interest is charged daily. Most credit cards calculate interest daily based on the average daily balance. The monthly formula is an approximation that is close but not exact to the penny.

How to Choose a Payoff Time or Payment

You have two ways to build a schedule: pick a monthly payment you can afford and see how long it takes, or pick a target payoff date and see what payment is required. Both are valid; the choice depends on your budget and goals.

  • Fixed payment method: Choose a round number like $200 or $300 per month. The schedule shows the number of months and total interest. To find months from a payment, use the formula: n = −ln(1 − r × P / M) / ln(1 + r), where M is your monthly payment. If the payment is less than the monthly interest, the balance never decreases – the formula returns “Cannot compute.”
  • Target date method: Choose a date (e.g., 2 years from now) and the calculator gives the exact payment. This is useful if you want to be debt-free by a specific event like a wedding or retirement.
  • Extra payments: If you make an extra payment in a month, the balance drops faster, and the schedule shortens. You can recalculate with the new balance and remaining time.

Costs Beyond Interest

Credit cards often carry other costs that a simple payoff schedule does not include. Annual fees, late payment fees, balance transfer fees (typically 3%–5% of the amount transferred), and cash advance fees (often 5% or a flat fee) all increase what you owe. If you transfer a balance to a lower-rate card, the transfer fee can offset the interest savings. Always read your card agreement for the exact fee schedule.

Also, making only the minimum payment can trigger penalty APRs – some cards raise your rate to 29.99% or higher after a late payment. Missing a payment also damages your credit score, which can affect future loan rates. These are not modeled in the calculator, so the schedule is an estimate, not a guarantee.

Alternatives to a Fixed Schedule

A fixed monthly payment is not the only way to pay off credit card debt. Two common strategies are the debt snowball and debt avalanche methods, though both apply to multiple cards.

  • Debt snowball: List debts from smallest to largest balance. Pay minimums on all, then put any extra money toward the smallest debt. When it is paid off, roll that payment to the next smallest. This builds momentum but may cost more in interest.
  • Debt avalanche: List debts from highest to lowest APR. Pay minimums on all, then put extra money toward the highest-rate debt. This minimizes total interest but can be slower to show progress.
  • Balance transfer: Move the balance to a card with a 0% introductory APR. This stops interest during the promo period, but you must pay the transfer fee and finish before the promo ends. The schedule still works – just set the APR to 0% for the promo months.

Each method has trade-offs. The best choice depends on your discipline, cash flow, and the number of cards you have. No single method is universally better.

Frequently Asked Questions

How long will it take to pay off $5,000 at 22% APR with a $200 monthly payment?

Using the formula, r = 0.0183333, P = 5000, M = 200. n = −ln(1 − 0.0183333 × 5000 / 200) / ln(1.0183333) = −ln(1 − 0.4583) / 0.01816 = −ln(0.5417) / 0.01816 = 0.612 / 0.01816 ≈ 33.7 months. So about 34 months, with total interest around $1,800.

What happens if I pay more than the minimum?

Every extra dollar goes directly to principal, reducing the balance faster and cutting total interest. For example, on the $5,000 balance at 22%, paying $250 instead of $200 shortens the payoff from 34 months to about 25 months and saves roughly $500 in interest.

Can I use this calculator for a 0% APR balance transfer?

Yes. Set the APR to 0% for the promotional period. The payment formula becomes P ÷ n, so a $5,000 balance over 18 months requires $277.78 per month. After the promo ends, the APR jumps to the regular rate, and you must recalculate with the remaining balance and new rate.

Why does my credit card statement show a different interest amount?

Credit card issuers use the average daily balance method, which compounds daily. The monthly formula assumes interest is charged once per month on the beginning balance. The difference is usually small – a few dollars – but can be larger if you make purchases or payments mid-cycle.

What if I can only make the minimum payment?

Minimum payments are typically 1%–3% of the balance plus interest. On a $5,000 balance at 22%, the first minimum might be around $150. As the balance drops, the minimum drops too, so it takes many years – often 15–20 years – and you pay more than double the original balance in interest. The schedule shows this clearly.

Is it better to pay off the credit card or save for an emergency fund?

That depends on your personal situation, which this calculator cannot judge. Mathematically, paying off a 22% APR card is like earning a guaranteed 22% return, which is higher than most savings accounts. But having some cash for emergencies can prevent new debt. A common approach is to build a small emergency fund first, then aggressively pay down the card.

This payoff schedule is an estimate based on the inputs you provide. Your credit card issuer’s monthly statement will show the exact interest and minimum payment for your account.

Related

Formula used
in p | Current balance | $ | 5000 | 1 | 100000
in apr | Interest rate (APR) | % | 22 | 0.01 | 100
in yrs | Desired payoff time | years | 3 | 0.0833 | 50
out pmt | Monthly payment needed | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest paid | $ | pmt * yrs * 12 - 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 →