finance-business · personal-finance · debt

Credit Card Payoff Calculator

Runs a credit card balance to zero twice, once at a fixed monthly payment you choose and once at the issuer minimum stated the way the large issuers state it, as the month's interest plus a percentage of the balance with a money floor underneath, and reports the months, the interest and the total paid on each path beside what the difference is worth. Use it to see what a statement's minimum payment actually costs over its whole life and what a fixed payment buys instead.

Last updated

Calculator overview

Inputs and outputs

This summary comes from the calculator's published input and output contract.

Inputs

Minimum Percent (required)
About this input

The share of the balance an issuer asks for as principal, on top of the month's interest. One percent is what the largest issuers publish. This is why a minimum payment falls every month and why the minimum path takes years: one percent of a shrinking balance shrinks with it.

Unit fraction Default 0.01 Range 0.01 to 0.05
Monthly Payment (required)
About this input

The fixed amount you intend to pay every month, whatever the statement asks for. It has to be more than the first month's interest or the balance grows instead of falling, and the status line says so when it is not. A payment larger than what is owed is trimmed to the balance plus that month's interest, so the last month is a part payment.

Unit $/month Default 200 Range 0 to 5000
Minimum Floor (required)
About this input

The smallest payment the issuer will accept in money, whatever the percentage works out to. Twenty five to forty is common. Once the balance is small enough that interest plus the percentage falls below this figure, the floor takes over and what is left clears far faster than the percentage alone would clear it.

Unit $ Default 25 Range 0 to 100
APR (required)
About this input

The annual percentage rate the card charges on this balance, as the statement states it. Each month is charged one twelfth of it on the balance at the start of the month. Where a card shows separate rates for purchases, balance transfers and cash advances, use the one that applies to the balance you are paying down.

Unit fraction Default 0.22 Range 0 to 0.36
Balance (required)
About this input

What you owe on the card today, the figure a statement calls the balance or the amount outstanding. Both payoff paths start from it. Nothing charged to the card after today is counted, so enter the balance you intend to stop adding to.

Unit $ Default 6500 Range 0 to 50000

Outputs

Table1 Payoff Column Axis
About this output

The values across the top of the grid: the annual percentage rate, in steps of two points either side of yours and never below zero. Read a column to hold the rate fixed and vary the payment. The middle entry is your own rate.

No unit declared
Table1 Payoff Column Input
About this output

Machinery, and NOT an input. The same for the column axis: Excel substitutes into it while filling the grid, and the rest of the time it mirrors APR.

Unit fraction
Model Status
About this output

Reads OK, or explains why the inputs are not valid or why the answer deserves a second look before you act on it.

No unit declared
Months Saved By Fixed
About this output

How many months sooner the fixed payment clears the balance than the minimum would. Negative means it clears later, which happens when the fixed payment is smaller than what the issuer would have asked for in the first place.

Unit months
Table1 Payoff Row Input
About this output

Machinery, and NOT an input. Excel substitutes each value from the row axis into this cell while it fills the grid; the rest of the time it mirrors Monthly_Payment. Change Monthly_Payment, never this: the axis is derived from it, so editing the mirror moves the axis while the grid is being filled and the whole grid comes out meaningless.

Unit currency/month
Table1 Payoff Values
About this output

The body of the grid: the months to clear the balance at a fixed payment, recomputed for every combination of the two axes. One hundred and twenty one cells, each one the whole schedule run again. It is a component of the grid rather than a result on its own.

Unit months
Table1 Payoff Corner
About this output

Machinery. Excel requires the quantity being tabulated to sit in the grid's top-left corner, where it means nothing to a reader, so it is formatted away. It holds Fixed_Months.

Unit months
Table1 Payoff Row Axis
About this output

The values down the left of the grid: the fixed monthly payment, in steps of fifty either side of yours and never below twenty five. Read a row to hold the payment fixed and vary the rate. The middle entry is your own payment; where five steps below it would fall under twenty five, the lowest entries repeat at twenty five.

No unit declared
Minimum Total Paid
About this output

Every amount that leaves your account on the minimum payment path: the balance cleared plus the interest charged.

Unit $
Fixed Months
About this output

How many months the balance takes to reach zero at your fixed payment, counting the first payment as month one. The last month is usually a part payment, because a full one would overshoot.

Unit months
Fixed Total Paid
About this output

Every amount that leaves your account on the fixed payment path: the balance cleared plus the interest charged. Set it beside the balance to see what the borrowing cost.

Unit $
First Month Interest
About this output

What the card charges in the first month alone: the balance multiplied by the annual rate divided by twelve. Any payment at or below it leaves the balance where it was or higher, which makes this the most useful single figure here for deciding whether a payment is enough.

Unit $/month
Fixed Interest
About this output

Everything the card charges in interest over the fixed payment path, summed month by month. It is the price of the time the balance stays outstanding, and it falls steeply as the payment rises.

Unit $
Minimum Interest
About this output

Everything the card charges in interest over the minimum payment path. It is the cost of letting the issuer set the pace, and it is what the fixed payment is measured against.

Unit $
Minimum Months
About this output

How many months the same balance takes to reach zero if you pay only what the issuer asks each month. This is the figure the minimum payment warning on a statement is about, and it is usually years rather than months.

Unit months
Interest Saved By Fixed
About this output

The minimum path's interest less the fixed path's. Positive means the fixed payment costs less. It can be negative, and that is a real answer rather than a fault: a fixed payment smaller than the first minimum keeps the balance outstanding longer than the issuer's own schedule would, and costs more.

Unit $
Minimum First Payment
About this output

What the issuer would ask for in the first month: that month's interest plus the share of the balance, lifted to the floor if that comes to less, and trimmed to what is owed on a very small balance. This is the figure to check against a statement, because it is the one a statement prints.

Unit $/month
This page is provided by LogicCommons for informational purposes only. Results are model outputs computed from the inputs you supply and are not financial, investment, tax, accounting, or legal advice, and no advisory relationship is created. Verify all inputs and results independently before relying on them in any decision.

LogicCommons is in beta. If a result, label, or reference looks wrong, tell us here; we read every message.

Methodology

Purpose and model boundary

Use this to see what a statement's minimum payment actually costs over its whole life, and what paying a fixed amount instead buys you. The same balance is run to zero twice: once at a fixed monthly payment you choose, and once at a minimum payment of the shape most issuers use, the month's interest plus a share of the balance with a money floor underneath, where you supply the share and the floor from your own statement.

It prices one balance you have stopped adding to. Nothing charged to the card after today is counted, and no annual fee, late fee, penalty rate or rewards value is modelled.

Inputs and units

Input Unit Accepted range What it means
Balance $ 0 through 50,000 What you owe on the card today, the figure a statement calls the balance or the amount outstanding. Both payoff paths start from it.
APR % 0% through 36% The annual percentage rate the card charges on this balance, as the statement states it. Where a card shows separate rates for purchases, balance transfers and cash advances, use the one that applies to the balance you are paying down.
Monthly Payment $/month 0 through 5,000 The fixed amount you intend to pay every month, whatever the statement asks for. It has to be more than the first month's interest or the balance grows instead of falling. A payment larger than what is owed is trimmed to the balance plus that month's interest, so the last month is a part payment.
Minimum Percent % 1% through 5% The share of the balance an issuer asks for as principal, on top of the month's interest. Take it from your own agreement or statement; a low single-digit percentage is typical. This is why a minimum payment falls every month, and why the minimum path takes years: one percent of a shrinking balance shrinks with it.
Minimum Floor $ 0 through 100 The smallest payment the issuer will accept in money, whatever the percentage works out to. Twenty five to forty is common. Once the balance is small enough that interest plus the percentage falls below this figure, the floor takes over and what is left clears far faster than the percentage alone would clear it.

Governing relationships

Both paths are followed month by month. Each month is charged one twelfth of the annual rate on the balance standing at the start of that month, the payment for that month is applied, and what remains carries forward.

On the fixed path the payment is the same every month, except in the last month, where it is trimmed to whatever is actually owed plus that month's interest.

On the minimum path the payment is recomputed every month as that month's interest plus the stated share of the current balance, lifted to the money floor whenever that sum falls below it, and trimmed to what is owed on a very small balance. That is the shape of the rule, and it is why the minimum payment falls month after month while the balance is large and then stops falling once the floor takes over.

What the fixed payment buys is the difference between the two paths: the months it saves and the interest it never has to pay.

Calculation sequence

This is the order in which the reported figures depend on one another, each step traceable to what the calculator says a figure is built from. It is not a claim about the order in which the workbook evaluates its own cells.

  1. Charge the first month of interest on the balance, which is the figure that decides whether any payment is large enough to make progress at all.
  2. Work out what the issuer would ask for in the first month under its own rule, so the fixed payment has something to be compared against.
  3. Run the fixed payment path to zero, accumulating the interest charged and the total handed over.
  4. Run the minimum payment path to zero the same way, recomputing the payment every month.
  5. Subtract the fixed path's months from the minimum path's to get the months saved, and its interest from the minimum path's interest to get the interest saved.
  6. Rerun the fixed path across a grid of monthly payments and annual rates, so the sensitivity of the answer to each is visible rather than asserted.

Outputs and interpretation

Output Role Unit What it means
Fixed Months primary months How many months the balance takes to reach nothing at your fixed payment, counting the first payment as month one. The last month is usually a part payment, because a full one would overshoot.
Fixed Interest primary $ Everything the card charges in interest over the fixed payment path, summed month by month. It is the price of the time the balance stays outstanding, and it falls steeply as the payment rises.
Interest Saved By Fixed primary $ The minimum path's interest less the fixed path's. Positive means the fixed payment costs less. It can be negative, and that is a real answer rather than a fault: a fixed payment smaller than the first minimum keeps the balance outstanding longer than the issuer's own schedule would, and costs more.
Minimum Months detail months How many months the same balance takes to reach nothing if you pay only what the issuer asks each month. This is the figure the minimum payment warning on a statement is about, and it is usually years rather than months.
Minimum Interest detail $ Everything the card charges in interest over the minimum payment path. It is the cost of letting the issuer set the pace, and it is what the fixed payment is measured against.
Months Saved By Fixed detail months How many months sooner the fixed payment clears the balance than the minimum would. Negative means it clears later, which happens when the fixed payment is smaller than what the issuer would have asked for in the first place.
Fixed Total Paid detail $ Every amount that leaves your account on the fixed payment path: the balance cleared plus the interest charged. Set it beside the balance to see what the borrowing cost.
Minimum Total Paid detail $ Every amount that leaves your account on the minimum payment path.
First Month Interest detail $/month What the card charges in the first month alone: the balance multiplied by the annual rate divided by twelve. Any payment at or below it leaves the balance where it was or higher, which makes this the most useful single figure here for deciding whether a payment is enough.
Minimum First Payment detail $/month What the issuer would ask for in the first month: that month's interest plus the share of the balance, lifted to the floor if that comes to less. This is the figure to check against a statement, because it is the one a statement prints.

Model Status reads OK, or explains why the inputs are not valid or why the answer deserves a second look before you act on it. It is shown alongside the results rather than in place of them.

The calculator also returns a grid that reruns the fixed payment path across a range of payments and rates at once. Its axes, corner and body arrive as separate values and are the grid's parts rather than results to read on their own; the page assembles them into the table.

Every figure above is returned by the model. The page arranges and formats them; it computes none of them.

Validation and status logic

These are the states the delivery's own recorded runs exercise, so the table records what this calculator has been observed to return rather than every branch it could take. A figure that moves with the inputs is shown as ….

Condition Returned status
No monthly payment has been entered NOT VALID: enter a monthly payment above zero; nothing paid never clears a balance
The fixed payment does not exceed the first month of interest CHECK: a payment of … is not more than the … of interest charged in the first month, so the balance does not fall; pay more than the interest
The minimum path has not cleared the balance within the months this model follows CHECK: the minimum payment is still not clearing the balance after … months, which is as far as this model runs; at this percentage and floor the minimum barely covers the interest
None of the preceding conditions applies OK

Assumptions and limitations

  • Interest is charged once a month, at the annual rate divided by twelve, on the balance at the start of the month. An issuer charges on the average daily balance, so a single month here can differ from a statement by the timing of payments inside it.
  • The rate is constant for the whole payoff. A promotional rate ending, or a penalty rate applying after a missed payment, is not modelled.
  • Nothing is charged to the card after today. A card still in use has no payoff date, which is the reason that assumption is made rather than an oversight.
  • The minimum rule is a common shape, not a universal one, and the share and floor are yours to set rather than figures this page asserts. An issuer using a different rule, such as a flat share of the balance with no interest added, will ask for a different amount and take a different number of months.
  • Fees of any kind, rewards, and the value of anything bought on the card are all outside the model.

Restrictions and non-computing states

This calculator enforces the numeric limits recorded above before either path is run, so a value outside them is refused rather than answered.

Both paths are followed for a limited number of months. A minimum payment that barely covers its own interest can take longer than that, and where it does the run stops at the limit and the status line says so rather than reporting the limit as if it were a payoff.

Errors and warnings

NOT VALID means the inputs do not describe a question this calculator can answer, and the figures beside it should not be relied on. CHECK is not an error: the arithmetic is sound and the figures stand, but something about the combination is worth knowing first, such as a payment that cannot make progress against its own interest. The status is shown with the results rather than in place of them, so a flagged answer is still a readable one.

A value the page itself refuses, because it falls outside the limits above, is rejected before the calculation is requested and no figures are returned at all. That is different again from a transport or service failure, where the page reports that the result could not be fetched rather than showing a stale or partial one.

References

The minimum payment rule modelled here is the larger of a money floor or a share of the balance, with the month's interest added, and the balance itself once what is left is smaller than either. The share and the floor are yours to set: the calculator takes them as inputs rather than asserting them, because issuers differ and each publishes its own method. Card agreements generally state that method in the pricing terms or Rates and Fees Table that accompanies the agreement rather than in the agreement's main text, so the figure to trust is the one on your own statement. The calculator reports the first month's minimum precisely so you can check it against one.

The two assumptions the minimum payment path makes, that only the minimum is paid and that nothing further is charged to the card, are the same two the statutory minimum payment disclosure box requires; see the Consumer Financial Protection Bureau's Regulation Z Appendix M1.

These sources provide background; they do not supply the calculator's assumptions or certify its result. This calculator is informational and is not financial, investment, or tax advice. Results follow directly from the balance, rate and payments you enter, and a real card whose balance keeps growing has no payoff date at all.

Results are informational and not professional advice. See our Terms of Use. Powered by SpreadsheetWeb · About · Privacy · Terms