calculate-loan

01 Loan payments

Credit Card Amortization Schedule Calculator

Calculator No. 01-12745 · 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 estimates how a balance falls month by month as you make payments and interest is added. Enter your current balance, APR, and planned monthly payment to see an estimated payoff time, total interest, and remaining balance; the schedule assumes a fixed payment and rate.

Formula

This calculator estimates the number of equal monthly payments required to repay a balance when interest accrues monthly and the payment is made at the end of each month.

  • r = monthly interest rate, calculated as APR ÷ 1,200.
  • B = starting card balance, in dollars.
  • P = planned monthly payment, in dollars.
  • n = estimated number of monthly payments.

The payoff-time formula is n = ceil[−ln(1 − rB/P) ÷ ln(1 + r)]. The calculator rounds the logarithmic result to six decimal places before rounding up to a whole month. The monthly interest estimate is B × r. If the payment is no greater than that amount, it does not reduce the balance under this model, so the calculator cannot compute a payoff date. Total paid is P × n, and estimated total interest is (P × n) − B.

Worked Example

Using the calculator’s default values: balance $5,000, APR 20%, and monthly payment $200.

  1. Convert the APR to a monthly rate: 20 ÷ 1,200 = 0.0166667, or about 1.66667% per month.
  2. Estimate first-month interest: $5,000 × 0.0166667 = about $83.33. The $200 payment exceeds this interest, so the balance begins to decline.
  3. Apply the payoff formula: ceil[−ln(1 − (0.0166667 × 5,000 ÷ 200)) ÷ ln(1.0166667)] = ceil(about 35.16) = 36 months.
  4. Estimated total paid: 36 × $200 = $7,200.
  5. Estimated total interest: $7,200 − $5,000 = $2,200.

The total-interest figure uses the rounded whole-month payoff period and assumes the full planned payment is made in the final month. In a real payoff, the last payment is often smaller than the regular payment because only the remaining balance and accrued interest are due. For an exact final-payment estimate, calculate each month’s interest and balance individually.

How to Read a Credit Card Amortization Schedule

An amortization schedule is a table showing, for each payment period, the opening balance, interest charged, payment, amount applied to principal, and closing balance. Credit cards generally do not have a preset installment term, so their schedules are projections based on a payment plan rather than a fixed contract repayment calendar.

For a month-by-month schedule, start with the current balance. Estimate interest as the opening balance multiplied by the monthly rate. Subtract that interest from the payment to find the amount reducing principal, then subtract that principal reduction from the opening balance. Repeat for each month. For example, with a $5,000 balance, a 20% APR, and a $200 payment, the simplified first month adds about $83.33 interest; about $116.67 of the payment reduces the balance, leaving approximately $4,883.33.

Actual card interest may be calculated using a daily periodic rate and the balance on each day of a billing cycle. New purchases, payment dates, promotional balances, fees, and the issuer’s allocation rules can all change the statement amount. Consequently, a monthly-rate schedule is useful for planning, but it may not reproduce a card statement exactly.

Choosing a Payment Amount for the Estimate

Enter the payment amount you want to model, not a payment amount the calculator assumes you must make. Compare the result with the minimum payment shown on your statement and the card’s payment terms. Minimum-payment amounts can change as the balance changes, so a fixed-payment estimate may differ from a minimum-only repayment path.

  • Use the statement balance: For a practical projection, enter the balance that will accrue interest, rather than a credit limit or an old balance.
  • Use the applicable APR: A card can have different rates for purchases, cash advances, and transferred balances. Model each balance separately if the rates differ.
  • Check the interest threshold: At the defaults, monthly interest initially is about $83.33. A payment at or below the interest charged cannot pay down principal in this simplified model.
  • Consider payment changes: If you plan to make larger payments later, run separate estimates or build a schedule using the different payment for each period.

A zero payment is accepted as an input so the calculator can flag that no payoff estimate is possible. The formula requires a positive payment that exceeds the first month’s estimated interest; the added square-root check returns “Cannot compute” when the payment is too small.

Limits and Common Misconceptions

An amortization estimate does not mean a card has a fixed repayment term. The calculated months are the result of the balance, APR, and assumed payment. If any of these changes, the result changes too. Paying only the minimum can produce a different schedule because minimums commonly vary with the balance and account terms.

The formula assumes the same APR and same payment every month, no additional purchases, and no fees or credits. It also treats interest as monthly at APR ÷ 12. Many card issuers instead calculate interest using daily balances and a daily periodic rate. The actual calculation and payment allocation are described in the card agreement and billing information; use those materials for account-specific figures.

Rounding also matters. The calculator rounds payoff time up to a whole month and derives total paid using that number of full payments. It does not model a smaller final payment, and total interest is an arithmetic estimate rather than a prediction of the exact amount on a future statement.

Alternatives and Ways to Build a Detailed Schedule

For a more detailed projection, create one row per billing period with columns for starting balance, interest, payment, principal reduction, and ending balance. Use the card’s actual APR and the issuer’s stated interest method where available, and enter any planned purchases or fees separately. If the APR varies, use the applicable rate for each period rather than treating it as fixed.

A payoff calculator answers a different question from an amortization table: it may estimate a payoff date or payment amount without displaying every period. A balance-transfer or consolidation scenario also needs its own inputs, such as any transfer fee, introductory-rate duration, and later APR. This page does not compare offers or include those terms; obtain the figures from the relevant account disclosure before modeling them.

Frequently Asked Questions

Do credit cards have amortization schedules?
Usually, a card does not come with a fixed installment schedule like a standard term loan. You can make a projected schedule using a balance, APR, and assumed payment, but actual interest and minimum payments may change.

How do I calculate credit card interest per month?
A simplified estimate is balance × (APR ÷ 12). For example, a $5,000 balance at 20% APR gives about $83.33 for one month. Issuers may calculate interest by day, so the statement can differ.

Why does the calculator say it cannot compute?
The planned payment must exceed the estimated interest on the starting balance for the balance to decline under this model. If payment is less than or equal to monthly interest, there is no finite payoff estimate using a fixed payment.

Does the estimate include new purchases or fees?
No. It assumes no new charges, fees, credits, or rate changes. Add those separately or use a more detailed schedule that reflects the card’s actual activity and terms.

Will my final payment equal the monthly payment entered?
Not necessarily. The calculator estimates payoff in whole months and multiplies the planned payment by that count. In practice, the last payment may be smaller, and daily interest can affect its exact amount.

Assumptions

  • The APR remains fixed for the full estimated payoff period.
  • Payments are made monthly at the end of each modeled month.
  • Interest compounds monthly at APR ÷ 12; actual card methods may use daily balances.
  • No new purchases, fees, taxes, insurance, PMI, or escrow are included; those items do not generally apply to this card-balance calculation.

This result is an estimate for education, and the card issuer’s disclosure and statements provide the exact figures.

Related

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