calculate-loan

01 Loan payments

Credit Card Amortization Table: Estimate Your Payoff

Calculator No. 01-12746 · 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 table estimates how each monthly payment is split between interest and principal, and how the balance changes until payoff. Enter your balance, APR, monthly payment, and an estimate of new monthly charges to see a projected schedule; the result is a model, not your issuer’s statement.

Formula

This calculator estimates a level-payment payoff under a simplified monthly model. Let B be the starting balance in dollars, A the APR as a percentage per year, P the monthly payment in dollars, and C new charges added each month in dollars. The monthly rate is r = A / 1200. The payment available to reduce the existing balance is M = P − C.

Estimated months to payoff = ceil(−ln(1 − rB/M) / ln(1 + r)). The calculator rounds the unrounded month estimate to six decimal places before rounding up to a whole month. The formula requires M > rB: the payment, after modeled charges, must exceed the first month’s interest. If it does not, the result is “Cannot compute,” because this payment-and-charge pattern does not pay the balance down under the model.

Estimated total payments = P × N, where N is the estimated number of months. Estimated interest paid = total payments − starting balance − C × N. These totals assume the same payment and new charges each month, including in the final month; actual payoff usually involves a smaller final payment. The table itself should calculate each month’s interest as opening balance × monthly rate, then apply payment and charges, subject to the assumptions below.

Worked Example

Using the defaults: starting balance B = $5,000, APR A = 20%, monthly payment P = $200, and new monthly charges C = $0.

  1. Monthly rate: r = 20 / 1200 = 0.0166667, or about 1.66667%.
  2. Payment available for the balance: M = 200 − 0 = $200. First-month interest is approximately $5,000 × 0.0166667 = $83.33, so the payment exceeds that interest.
  3. Months: ceil(round(−ln(1 − 0.0166667 × 5,000 / 200) / ln(1.0166667), 6)) = 36.
  4. Total payments under the simplified formula: $200 × 36 = $7,200.
  5. Estimated interest: $7,200 − $5,000 − ($0 × 36) = $2,200.

The displayed 36 months, $7,200 in payments, and $2,200 in estimated interest follow the formula and its whole-month convention. Because a real account may require less than $200 in the final month, its actual total can differ.

Assumptions

  • The APR is fixed throughout the payoff period.
  • One payment and one set amount of new charges occur each month; the model does not specify exact transaction dates.
  • Interest compounds monthly at APR divided by 12. Actual card interest may be calculated using daily balances and a daily periodic rate.
  • New charges are treated as additions to the balance, without distinguishing purchase, cash-advance, or promotional balances.
  • Fees, late charges, changing rates, payment allocation rules, and any different treatment of transaction types are not included.

How to Read a Credit Card Amortization Table

A traditional loan table lists an opening balance, interest, payment, principal reduction, and closing balance for each period. A credit card table uses the same idea, but the schedule is more conditional: new purchases, fees, rate changes, and the issuer’s interest method can alter the balance from month to month. A useful estimate shows the assumptions beside the numbers rather than presenting the schedule as a guaranteed payoff date.

For each modeled month, interest is added to the opening balance, the payment reduces what is owed, and any new charges increase it. In a simple monthly model, a row can be represented as:

  • Interest = opening balance × monthly rate.
  • Closing balance = opening balance + interest + charges − payment.
  • The next row’s opening balance is the previous row’s closing balance.

For instance, the default example begins with $5,000 and estimates $83.33 of first-month interest. A $200 payment would reduce principal by about $116.67 if there were no new charges and the monthly-rate assumption applied exactly. Later rows change as the balance falls. Rounding each month to cents can cause small differences from a calculation that carries extra decimal places throughout.

What Changes the Estimate?

The most important inputs are the balance, APR, payment, and new charges. A higher balance or rate generally produces more interest in this model; a larger payment that exceeds interest reduces the balance faster. Ongoing charges use up part of the payment, so entering $50 of monthly charges with a $200 payment leaves only $150 for the existing balance before interest is considered.

The estimate becomes unreliable when the account changes materially during payoff. Examples include:

  • Adding purchases that vary from month to month, or stopping new purchases after the estimate begins.
  • Having multiple balances subject to different APRs or promotional periods.
  • A changing APR, fees, missed or late payments, or payment amounts that vary.
  • Interest calculated from daily balances, transaction dates, or specific payment-allocation methods rather than this monthly approximation.

For a more tailored schedule, use the balance and rates shown on the latest statement and account terms, and model each balance separately when their rates differ. Check the issuer’s disclosed interest method and payment allocation details; the calculator does not look them up.

Common Misconceptions and Limits

An amortization table does not mean a credit card is structured exactly like a fixed-term installment loan. Cardholders can often make different payment amounts and add transactions, while an installment schedule typically assumes set payments and a defined term. This calculator holds payment, APR, and monthly charges constant to make a comparable projection.

Another misconception is that paying more than the interest guarantees the exact displayed payoff date. It only makes a declining balance possible under the model. With daily interest, charges, fees, or rate changes, actual results can differ. Also, the total-interest output is a formula-based estimate using whole months and a constant payment; it is not a quotation of the amount your card issuer will collect.

Frequently Asked Questions

Can I make an amortization table for a credit card?
Yes. List each period’s opening balance, estimated interest, payment, new charges, and closing balance. The table needs an APR and assumptions about payment timing and future charges.

How do I calculate credit card interest for one month?
This calculator uses opening balance × (APR / 1200). That is a simplified monthly estimate; an issuer may instead calculate interest using daily balances and a daily periodic rate.

Why does the calculator say “Cannot compute”?
Under its assumptions, the payment minus monthly charges is not greater than the first month’s interest. The balance therefore does not decline as required by the payoff formula.

Does the estimate include new purchases?
It includes only the fixed monthly charge amount you enter. Real purchases can change from month to month and may be treated differently depending on their type or applicable rate.

Why is my statement different from the table?
Statements reflect the account’s actual transactions, dates, rates, fees, payment processing, and interest calculation. The table uses simplified fixed monthly assumptions and should not be treated as the issuer’s exact payoff figure.

This result is an estimate for education; your card issuer’s disclosure and account figures provide the exact amounts.

Related

Formula used
in bal | Starting balance | $ | 5000 | 0 | 100000000
in apr | Interest rate (APR) | % | 20 | 0.01 | 100
in pmt | Monthly payment | $ | 200 | 0.01 | 100000000
in chg | New charges per month | $ | 0 | 0 | 100000000
out months | Estimated months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * bal / (pmt - chg)) / ln(1 + apr / 1200), 6)) + 0 * sqrt(pmt - chg - (apr / 1200) * bal) | 0
out total | Total payments | $ | pmt * months | 2
out interest | Estimated interest paid | $ | total - bal - chg * months | 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 →