A credit card amortization table shows how each monthly payment is divided between interest and principal, and how the balance changes until payoff. This calculator estimates a fixed-payment payoff schedule: enter the balance, APR, and monthly payment to see the estimated months to repay and total interest.
Formula
The calculator estimates a payoff period by treating the monthly payment as constant and the monthly interest rate as the APR divided by 12. The number of months is rounded up to a whole payment period:
r = APR / 1200
n = ceil(round(−ln(1 − r × B / M) / ln(1 + r), 6))
Total paid = M × n
Total interest = (M × n) − B
- B is the starting card balance in dollars.
- APR is the annual percentage rate entered as a percentage, such as 20 for 20% per year.
- r is the monthly rate as a decimal.
- M is the fixed monthly payment in dollars.
- n is the estimated number of monthly payments.
The formula requires the payment to exceed the first month’s interest. If it does not, the balance will not shrink under this simplified model, so the calculator cannot produce a finite payoff estimate. The calculator’s inputs are limited to positive amounts and APRs from 0.01% to 100%.
Worked Example
Using the default inputs—$5,000 balance, 20% APR, and $200 monthly payment:
- Convert APR to a monthly rate: r = 20 / 1200 = 0.0166667, or about 1.6667% per month.
- Estimate months: −ln(1 − 0.0166667 × 5,000 / 200) / ln(1.0166667) ≈ 33.63. Rounding up gives 34 months.
- Estimate total paid: $200 × 34 = $6,800.
- Estimate interest: $6,800 − $5,000 = $1,800.
These are the calculator’s rounded outputs. The final payment in a real payoff schedule may be smaller than the regular payment; this estimate instead assumes the same full payment in every month.
Assumptions
- The APR stays fixed throughout the estimated payoff period.
- A payment is made once per month, with interest applied monthly for this simplified calculation.
- Monthly compounding is represented as APR divided by 12; actual card interest calculations may use daily balances and a daily periodic rate.
- No new purchases, cash advances, balance transfers, late charges, annual fees, penalty rates, or other charges are included.
- The payment amount stays the same each month, and payments are assumed to reduce the balance.
How to Read a Credit Card Amortization Table
A full amortization table has one row for each payment period. Common columns show the opening balance, interest charged, payment, amount applied to principal, and closing balance. The opening balance for the next row is the prior row’s closing balance.
For instance, at a 20% APR divided monthly, a $5,000 balance accrues approximately $83.33 in interest in the first month under this model. Of a $200 payment, about $116.67 then reduces principal, leaving roughly $4,883.33. As the balance falls, the interest portion generally falls too, provided the APR and payment remain unchanged.
This page calculates an estimated payoff duration and totals rather than displaying every monthly row. To build a row-by-row table, repeat the monthly steps: calculate interest on the current balance, subtract that interest from the payment to find principal reduction, then subtract principal reduction from the balance. In a real account, statement dates, transaction timing, and rounding can change the result.
When This Estimate Is Useful—and Where It Falls Short
The estimate can help explain why a payment that looks substantial may still take time to clear a revolving balance. It can also provide a baseline for understanding the effect of payment size: all else equal in this model, a larger payment reduces the payoff period and the number of months over which interest accrues.
Credit cards are revolving accounts, not ordinary fixed-term installment loans. A cardholder may continue to use the account, and the APR or balance may change. Promotional or variable rates, different APRs for purchases and cash advances, fees, and payment allocation rules are outside this calculator. Check the card agreement and statement for the terms that apply to an actual account; enter the relevant rate and balance as inputs when making an estimate.
A frequent misconception is that APR alone determines the interest shown on a statement. APR is an annualized rate, but card interest calculations can depend on the daily balance and the number of days in a billing cycle. Consequently, a monthly-rate estimate is not an exact reconstruction of a statement. A zero-interest period also cannot be represented by this calculator’s minimum APR input, and promotional periods that later change rates require a multi-stage calculation.
Common Calculation Problems
- Payment does not cover interest: At the default balance and APR, first-month interest is about $83.33. A payment at or below the interest amount cannot reduce principal under the simplified model.
- Adding new charges: Purchases made during repayment increase the balance and can extend payoff time. This calculator assumes no new activity.
- Treating an estimate as an account schedule: Daily interest, payment dates, fees, and rounding can create different statement amounts.
- Assuming the last payment equals every other payment: The calculator multiplies the fixed payment by the rounded-up month count. In practice, a final payment may be smaller.
Frequently Asked Questions
What is a credit card amortization table?
It is a period-by-period breakdown showing how payments are applied to interest and principal and how the remaining balance changes. Because cards are revolving credit, an actual schedule depends on the balance, rate, payments, and any new activity.
How do I calculate credit card payoff time?
Estimate the monthly rate as APR divided by 12, then use the balance and a fixed monthly payment in the payoff formula. The payment must exceed monthly interest for the balance to decline; this calculator rounds the result up to a whole month.
Why is my credit card payoff estimate different from my statement?
A simplified estimate may use monthly compounding and a constant rate, while an account can calculate interest from daily balances and billing-cycle details. New transactions, fees, payment dates, and changing APRs can also affect the statement.
Does paying more reduce total interest?
In a fixed-rate model with no new charges or fees, a larger payment that exceeds interest reduces the balance faster and usually lowers the total interest accumulated before payoff. The exact account outcome depends on its terms and activity.
Can I use this for a 0% promotional APR?
No. The calculator requires an APR of at least 0.01% and assumes the entered rate applies throughout repayment. A promotional period followed by a different rate needs a calculation that models both periods separately.
This result is an estimate for education, and the card issuer’s disclosure and account statements provide 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 | 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 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
- Rent-to-Income Ratio by Country: How Comparisons Work30.00 %
- Rent-to-Income Ratio: Definition and Calculator30.00 %
- Rent-to-Income Ratio Calculator and What It Means30.00 %
- Rent-to-Income Ratio by City: How to Compare
- Gross Income-to-Rent Ratio Calculator and Guide3.33 x
- Reasonable Income to Rent Ratio: A Practical Guide