A credit card amortization schedule shows how each payment is divided between interest and principal, and how the balance changes over time. Enter a starting balance, APR, and monthly payment to estimate the payoff time, total interest, and remaining balance after the final scheduled payment; this model assumes a fixed payment and rate.
Formula
For a fixed APR and a constant monthly payment, the monthly interest rate is r = APR / 1200. While the balance remains positive, the balance after each payment follows:
Bk = Bk−1(1 + r) − P
Here, Bk is the balance after payment k, Bk−1 is the balance immediately before it, r is the monthly rate as a decimal, and P is the monthly payment in dollars. The interest portion for a month is the balance before payment multiplied by r; the remainder of the payment reduces principal.
For a fixed payment that covers the monthly interest, the estimated number of months is:
n = ceil(−ln(1 − rB/P) / ln(1 + r))
B is the starting balance in dollars, P is the monthly payment in dollars, r is the monthly rate, n is the repayment period in months, and ceil means round up to a whole month. The schedule’s estimated total interest is P × n − B, because it treats every scheduled payment as the entered amount. Actual final payments are often smaller than regular payments, so the total-interest figure can overstate the amount paid by the difference between the last full payment and the payoff amount. The formula is not meaningful if the payment does not exceed the first month’s interest.
Worked Example
Using the calculator defaults: starting balance B = $5,000, APR = 18%, and monthly payment P = $200.
- Convert APR to a monthly decimal rate: r = 18 / 1200 = 0.015, or 1.5%.
- Estimate months: n = ceil(−ln(1 − 0.015 × 5,000 / 200) / ln(1.015)) = ceil(−ln(0.625) / ln(1.015)) = ceil(31.5) = 32 months.
- Estimate total interest using the displayed fixed-payment model: $200 × 32 − $5,000 = $1,400.
- Apply the balance formula after 32 full payments. The result is below zero because the final scheduled payment would have paid off the debt earlier in that month; the displayed balance is capped at $0.00.
The first month’s interest is $5,000 × 0.015 = $75, leaving $125 of the $200 payment to reduce principal. Later interest falls as the balance falls. In a real payoff, the last payment is adjusted to the remaining balance plus accrued interest, so there would not normally be 32 full $200 payments in this simplified example.
Assumptions
- The APR is fixed for the whole estimate and is divided into 12 equal monthly rates.
- A payment is made once per month after that month’s interest is added; payment dates and daily balance timing are not modelled.
- Interest compounds monthly in this simplified calculation. Card issuers may calculate interest using daily balances and their stated method.
- No new purchases, cash advances, transfers, fees, penalty charges, taxes, or payment allocation across multiple balances are included.
How a Credit Card Schedule Works
An amortization schedule is a month-by-month ledger. Each row typically shows the starting balance, interest charged, payment, principal reduction, and ending balance. To build a basic row, multiply the opening balance by the monthly rate to estimate interest, subtract that interest from the payment to find principal reduction, then subtract principal reduction from the opening balance.
For instance, if a month begins at $5,000 with a 1.5% monthly rate, estimated interest is $75. A $200 payment then reduces principal by $125, giving an estimated closing balance of $4,875. The following month’s estimated interest is calculated on that lower balance, not the original $5,000.
This is why a payment can feel slow to reduce a balance when interest is a large share of the payment. If the payment is equal to or below the interest accrued, principal will not decline under this simple model. The calculator flags a payment that does not cover first-month interest as not computable rather than presenting a misleading payoff period.
How to Read the Estimate
- Months to repay: a rounded-up estimate based on paying the same amount each month. A real final payment may be smaller.
- Total interest: an approximate total under the calculator’s fixed-payment arithmetic. Because it multiplies the full payment by the rounded-up month count, it does not adjust the final payment.
- Ending balance: the balance formula’s result after the estimated number of full payments, limited to zero. A zero result means the model has reached payoff, not that a real statement will show the same amount on the same date.
To make a month-by-month schedule outside this compact calculator, repeat the balance step for every month and reduce the last payment to the amount actually needed to clear the remaining balance. Round interest and payments according to the issuer’s statement method if matching a real account is important.
Common Problems and Limits
The main source of mismatch is that credit-card interest may be based on daily balances, transaction dates, billing-cycle length, and the account’s disclosed calculation method rather than one monthly multiplication. New charges, credits, late or returned payments, promotional rates, fees, and changing APRs also alter the path. Where an account has separate purchase, transfer, or cash-advance balances, payment allocation can change which balance declines first.
APR is an annualized rate, not the rate to multiply directly by the balance for one month. Divide a percentage APR by 1,200 to get a monthly decimal rate: for example, 18% becomes 0.015. Do not enter 18 as a decimal rate or divide by 100 only; either mistake changes the result substantially. The zero-interest case also requires a separate simple calculation (balance divided by payment); this calculator uses a positive APR input because its logarithmic formula is designed for that case.
The calculator is an estimate for one balance with a constant payment. It does not reproduce an issuer’s statement or promise a particular payoff date. Use the APR and balance shown by the account provider for an estimate, and check its disclosure for the precise interest calculation and payment treatment.
Frequently Asked Questions
What is the formula for a credit card amortization schedule?
For each month, multiply the starting balance by the monthly rate to find interest, subtract the payment to find principal reduction, and subtract that reduction from the balance: Bk = Bk−1(1 + r) − P, where r = APR / 1200.
How do I calculate how many months it will take to pay off a credit card?
With a fixed positive monthly rate and a payment greater than monthly interest, use n = ceil(−ln(1 − rB/P) / ln(1 + r)). This is an estimate; daily interest and a smaller final payment can change the actual timeline.
Why does my credit card payoff estimate differ from my statement?
A statement may use daily balances and actual transaction and payment dates. New purchases, fees, varying APRs, and payment allocation rules can also change the balance from a fixed-rate monthly estimate.
What happens if my payment is less than the interest?
Under the simplified model, none of the payment reduces principal when payment is no greater than interest for the period. The balance may stay level or grow, so a finite payoff estimate cannot be calculated with that payment and rate.
Does the final payment equal the regular monthly payment?
Usually the payoff amount is whatever remains plus interest accrued through the payoff date, so the final payment can be smaller than the regular amount. This calculator’s total-interest output instead uses full equal payments for its rounded-up month count, making it an approximation.
This result is an estimate for education, and the account’s disclosure gives the exact figures and calculation method.
Related
Formula used
in bal | Starting balance | $ | 5000 | 0 | 100000000 in apr | Interest rate (APR) | % | 18 | 0.01 | 100 in pay | Monthly payment | $ | 200 | 0 | 100000000 out mon | Months to repay | months | ceil(round(-ln(1 - (apr / 1200) * bal / pay) / ln(1 + apr / 1200), 6)) + 0 * sqrt(pay - bal * (apr / 1200)) | 0 out int | Total interest | $ | pay * mon - bal | 2 out end | Balance after scheduled payments | $ | max(0, bal * (1 + apr / 1200) ^ mon - pay * ((1 + apr / 1200) ^ mon - 1) / (apr / 1200)) | 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