calculate-loan

01 Loan payments

Credit Card Amortization Schedule Calculator

Calculator No. 01-12757 · 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 amortization schedule calculator estimates how a balance declines month by month as you make payments and interest is added. Enter the balance, APR, and planned monthly payment to see an estimated payoff time, total paid, and interest cost.

Formula

The calculator estimates the number of equal monthly payments needed to repay a starting balance when interest accrues monthly and the payment stays fixed. It rounds the calculated payoff time up to a whole month, because a fraction of a monthly payment period is not displayed as a separate payment.

  • r = monthly interest rate, calculated as APR ÷ 1,200.
  • B = starting balance in dollars.
  • M = fixed monthly payment in dollars.
  • n = estimated number of monthly payments: ceil(−ln(1 − rB/M) ÷ ln(1 + r)).
  • Total payments = M × n.
  • Estimated interest = total payments − B.

The input rule requires the monthly payment to exceed the first month’s estimated interest, B × r. If it does not, the balance will not decline under this simplified model, so the calculator returns “Cannot compute.” The calculator assumes the same payment in the final month; an actual payoff schedule may have a smaller last payment.

Worked Example

Using the defaults—balance $5,000, APR 18%, and monthly payment $200:

  1. Convert the APR to a monthly rate: r = 18 ÷ 1,200 = 0.015, or 1.5%.
  2. Estimate the first month’s interest: $5,000 × 0.015 = $75. The $200 payment exceeds this amount, so it reduces principal as well as covering interest.
  3. Calculate the payoff time: −ln(1 − (0.015 × 5,000 ÷ 200)) ÷ ln(1.015) ≈ 32.2 months; rounding up gives 33 months.
  4. Calculate total payments: $200 × 33 = $6,600.
  5. Estimate interest: $6,600 − $5,000 = $1,600.

So the calculator’s headline estimate is 33 months to payoff, with $6,600 in modeled payments and $1,600 in modeled interest.

Assumptions

  • The APR is fixed throughout the estimate.
  • Payments are made once per month at the end of each modeled period.
  • Interest compounds monthly at APR ÷ 12.
  • The monthly payment remains unchanged, including in the final modeled month.
  • Fees, new purchases, cash advances, promotional rates, penalty rates, taxes, and payment-allocation rules are not included.

How to Read a Credit Card Amortization Schedule

An amortization schedule lays out a balance’s estimated progress over successive payment periods. A full monthly row typically shows the beginning balance, interest charged, payment, amount applied to principal, and ending balance. The calculator provides summary estimates rather than every row, but the same sequence explains the result.

For a $5,000 balance at a monthly rate of 1.5%, the first modeled month adds $75 in interest. A $200 payment then leaves about $4,875: $5,000 + $75 − $200. In later months, interest is calculated on the lower balance, so the interest portion generally falls while more of the fixed payment reduces principal. This is why a payment amount alone does not tell you the full cost; the balance and APR matter too.

When This Estimate Is Useful—and What It Leaves Out

Use the estimate to understand the relationship between a balance, APR, and a planned payment, or to compare hypothetical inputs. It is not a statement of what a card issuer will charge or a promise of a specific payoff date. Credit card accounts can have features that differ from this simple fixed-rate model.

For a more realistic estimate, check the account’s current balance, APR for the balance type, and payment terms in the issuer’s disclosure or account information. A card may apply different rates to purchases, balance transfers, or cash advances; rates can also change. New transactions, late or returned payments, fees, and changes in payment amount can alter both the schedule and payoff time. If several balance categories exist, calculate them separately only if you know their rates and how payments are allocated.

The calculator does not determine a required minimum payment. Minimum-payment formulas can vary and may change as the balance changes. Entering a fixed amount is a planning assumption, not a statement that the amount satisfies account terms. The issuer’s payment notice is the source for the required amount and due date.

Common Problems and Misconceptions

  • Payment barely covers interest: At the defaults, first-month interest is $75. A payment at or below $75 would not reduce principal in this model, so no finite payoff estimate is returned.
  • APR entered as a monthly rate: Enter the annual percentage rate, such as 18, not 1.5. The formula converts APR to a monthly rate by dividing by 1,200.
  • Assuming the final payment is exact: The formula rounds the number of months up and multiplies that count by the fixed payment. A real account may require a smaller final payment, so the displayed total can overstate the amount actually paid.
  • Ignoring ongoing card activity: New charges or fees can add to the balance; payments below the modeled amount or missed payments can extend repayment.

Rounding also matters. The calculator rounds payoff time to a whole month, but real statements calculate interest using account-specific balance and day-count methods. Small differences can accumulate, especially over a long payoff period.

Frequently Asked Questions

How do I calculate how long it will take to pay off a credit card?
Use the balance, APR, and a fixed monthly payment. Convert APR to a monthly rate by dividing by 1,200, then apply the payoff formula shown above. The payment must exceed the modeled monthly interest for the balance to decline.

Does a credit card amortization schedule include new purchases?
No. This calculator assumes no new purchases, fees, or other additions to the balance. Additions can change interest and payoff time, and may be charged at a different APR.

Why does the calculator say it cannot compute?
The payment may be equal to or less than the first month’s estimated interest. Under the fixed-payment assumptions, the balance would not be paid down, so a finite payoff time cannot be calculated.

Is the estimated total interest the exact amount my issuer will charge?
No. It is a mathematical estimate based on a fixed APR, monthly compounding, and an unchanged payment. Issuer terms, daily balance calculations, rate changes, fees, and transaction activity can change actual charges.

Why might my final payment be smaller than the schedule’s payment?
The estimate rounds the repayment period up to a whole month and treats every payment as the same size. Once the remaining balance and accrued interest are below the planned payment, an actual payoff amount may be smaller.

This result is an estimate; the card issuer’s disclosure gives the exact figures.

Related

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