calculate-loan

01 Loan payments

Credit Card Amortization Schedule Formula and Example

Calculator No. 01-12756 · Updated · Formula and assumptions shown below

Months to repay 32 months
Total interest
$1,400.00
= Monthly payment × months to repay − starting balance
Balance after scheduled payments
$0.00
Level-payment formula, rounded to the cent
Starting balance
$5,000
Input
You enter
Starting balance ($), Interest rate (APR) (%), Monthly payment ($)
You get
Months to repay (months), Total interest ($), Balance after scheduled payments ($)
Rounding
0 dp · 2 dp

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 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.

  1. Convert APR to a monthly decimal rate: r = 18 / 1200 = 0.015, or 1.5%.
  2. 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.
  3. Estimate total interest using the displayed fixed-payment model: $200 × 32 − $5,000 = $1,400.
  4. 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

The whole Loan payments section →