calculate-loan

01 Loan payments

Credit Card Loan Amortization Calculator and Payoff

Calculator No. 01-12804 · 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 loan amortization calculator estimates how many monthly payments it takes to repay a balance, and how much interest those payments add up to. Enter your current balance, APR, and planned monthly payment to see an estimated payoff time and total cost; the calculation assumes a fixed rate and regular monthly payments.

Formula

The calculator estimates the number of equal monthly payments needed to reduce a balance to zero, then multiplies that rounded-up payment count by the planned monthly payment. It uses the monthly rate derived from APR and assumes interest accrues monthly.

  • B = starting balance in dollars.
  • A = annual percentage rate (APR), entered as a percentage per year.
  • r = monthly rate as a decimal, calculated as A ÷ 1,200.
  • M = planned monthly payment in dollars.
  • N = estimated number of monthly payments, rounded up to a whole month.

The underlying payoff-time equation is N = ceil(−ln(1 − rB/M) ÷ ln(1 + r)). The outputs are total paid = M × N and estimated interest = total paid − B. The expression also checks whether the payment exceeds the first month’s estimated interest, rB. If it does not, the calculator reports that it cannot compute a payoff: under this fixed-rate model, the balance will not decline.

Worked Example

Using the calculator’s default inputs: balance B = $5,000, APR A = 20%, and monthly payment M = $200.

  1. Convert APR to a monthly decimal rate: r = 20 ÷ 1,200 = 0.0166667, or about 1.66667% per month.
  2. Estimate the first month’s interest: $5,000 × 0.0166667 = about $83.33. The planned $200 payment is greater than this amount, so the balance can decline in the model.
  3. Substitute into the payoff equation: N = ceil[−ln(1 − (0.0166667 × $5,000 ÷ $200)) ÷ ln(1.0166667)] = ceil(about 39.58) = 40 months.
  4. Calculate the total paid using the full planned payment for each estimated month: $200 × 40 = $8,000.
  5. Subtract the starting balance to estimate interest: $8,000 − $5,000 = $3,000.

The result is an estimated payoff period of 40 months, total payments of $8,000, and estimated interest of $3,000. The final payment in practice may be smaller than $200 because the remaining balance and interest could be less than one full scheduled payment; this calculator conservatively counts whole months at the entered payment amount.

Assumptions

  • The APR stays fixed throughout the estimated payoff period.
  • Payments are made once per month after interest accrues for that month; actual statement timing may differ.
  • Interest is modelled using monthly compounding at APR ÷ 12.
  • No new purchases, cash advances, balance transfers, late charges, annual fees, or other fees are added.
  • The calculator does not model variable APRs, grace periods, daily balance methods, promotional periods, or payment allocation among multiple balances.

How Credit Card Payoff Amortization Works

An amortization schedule shows how a debt changes over time as interest is added and payments are applied. For a card balance, each payment first has to cover the period’s interest before it can reduce principal. With a fixed monthly rate and payment, the balance generally falls as long as the payment is greater than the interest charged. The calculator uses a compact logarithmic equation to estimate the number of periods, rather than displaying every month’s row.

In a real card account, interest may be calculated using a daily balance method and the APR may change. Statements can also include more than one balance category, each with its own rate or payment-allocation treatment. Because this calculator treats the debt as one balance at one fixed APR, it is a planning estimate, not a reproduction of a card issuer’s statement calculation.

How to Use the Estimate

  • Enter the balance you want to model. If your account has balances at different rates, estimate each separately or recognize that one blended APR will not capture how the account works.
  • Use the APR applicable to that balance, not a monthly rate. The calculator divides the entered annual percentage by 1,200 to obtain a monthly decimal rate.
  • Enter the monthly amount you intend to pay. The result assumes that same amount is paid every month and that no new charges are added.
  • Read months to repay as a whole-month estimate. Total paid and interest are derived from that whole-month count, so they may differ from the exact final payment on an account.

For example, the default $5,000 balance and 20% APR produce about $83.33 in first-month interest under the model. A $200 payment leaves roughly $116.67 to reduce the balance in that first period. This illustrates why the payment amount matters: a payment only slightly above monthly interest can make progress slowly, while one below interest cannot repay the balance in this fixed-rate model.

Common Limitations and Misconceptions

A frequent mistake is entering “20” to represent a monthly rate when the input asks for an annual APR of 20%. Another is assuming that the calculated total is a guaranteed amount owed. Actual interest depends on account terms, transaction dates, payment dates, balance categories, new transactions, fees, and rate changes.

The payoff equation requires the monthly payment to exceed the first month’s interest. If it is equal to or below that amount, the balance cannot be paid off under the assumed fixed payment and rate. Even when it is above interest, the calculator’s rounded-up month count applies a full payment in the final month when an actual account might require less. It also does not infer a minimum payment from a card agreement; enter the payment amount you want to evaluate and check account documents for the amount due.

Credit Card Calculator Compared with a Loan Calculator

A standard installment-loan calculator often starts with a fixed principal, term, and interest rate, then calculates a level payment. This credit card calculator instead takes the payment as an input and estimates the payoff time. That distinction matters because card balances usually do not have a pre-set repayment term, and the amount paid can change from month to month.

If you want a month-by-month schedule, use the estimate as a starting point and build a separate table that applies monthly interest to the opening balance, subtracts each payment, and carries the result forward. For an exact account figure, consult the card’s statement and terms or ask the issuer how it calculates interest and applies payments.

Frequently Asked Questions

How do I calculate how long it will take to pay off a credit card?
Use the starting balance, APR, and a fixed monthly payment. Convert APR to a monthly rate by dividing by 1,200, then apply the payoff equation shown above. The calculator rounds the result up to a whole month.

What happens if my credit card payment is less than the interest?
In this model, the balance will not decline if the payment does not cover the month’s interest. The calculator therefore returns “Cannot compute” rather than a payoff time.

Does this calculator include new purchases or fees?
No. It assumes no new charges, fees, or other balance changes. Adding them would change the payoff period and total cost.

Why is my card statement’s interest different from the estimate?
The estimate uses monthly compounding at APR ÷ 12. An account may use daily balances, different transaction rates, payment dates, variable rates, or other terms that this simplified model does not represent.

Is the final credit card payment always the amount shown?
No. The calculator multiplies the planned payment by a whole-month estimate. The actual last payment may be smaller, and account-level interest or charges can change the amount due.

This result is an estimate for educational purposes; the lender’s disclosure gives the exact figures.

Related

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