Calculator overview
Inputs and outputs
This summary comes from the calculator's published input and output contract.
Inputs
- Extra Monthly Payment (required)
-
Unit $/month Default 200 Range 0 to 5000
About this input
Money you can put against the debts each month on top of every minimum. It is the field that decides how much the choice of order matters, which is why it is asked for rather than left blank: with nothing spare there is no pool to direct, so both orders pay the same minimums in the same months and give identical answers until the first debt clears and its own minimum comes free. Enter nothing above the minimums as zero, which is a real situation and a preset, rather than a reason to skip the field.
- Debts Grid (required)
-
Default 2 rows
About this input
One row per debt, up to ten: what you owe on it today, the interest rate it charges you a year, and the smallest payment the lender will accept each month. Enter the minimum the lender asks for, not what you intend to pay, because anything above it belongs in the extra payment field where both orders can direct it. The name column is yours to read and no calculation looks at it. Leave unused rows blank and keep them at the bottom; a filled row below a blank one is refused rather than quietly skipped, and a row carrying only some of its three figures is refused by number.
Column Range or allowed values Debt Not declared Balance now At least 0 Interest rate 0 to 0.36 Minimum payment At least 0 - APR Shift
-
When omitted Blank
Unit percent points Default Not set Range -0.05 to 0.05
About this input
Optional. The same movement applied to every rate, in percentage points, which is the scenario a variable-rate card puts you in: enter 2 to ask what happens if every rate rises two points, or minus 1 for a fall. Each rate is floored at zero, so a large fall cannot make a lender pay you. Leave it blank to use the rates as entered. It moves the order as well as the cost, because the highest-rate order is decided on the rates after the change.
Outputs
- Table1 Payoff Column Input
-
Unit percent points
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 the rate change you entered.
- Table1 Payoff Corner
-
Unit months
About this output
Machinery. Excel requires the formula 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 the months to clear everything under the dearest-first order.
- Snowball Months
-
Unit months
About this output
The same count if the spare money always goes to the smallest balance instead. It is usually the same or a month or two longer, because the money going in each month is identical and only its destination changes.
- Table1 Payoff Column Axis
-
No unit declared
About this output
The values across the top of the grid: the same change applied to every rate, in half-point steps either side of your own figure and inside the range the field accepts. Read a column to hold the rate change fixed and vary the extra payment. The middle entry is your own figure.
- Table1 Payoff Values
-
Unit months
About this output
The body of the grid: how many months until every debt is gone, paying the dearest first, recomputed for every combination of the two axes. One hundred and twenty-one cells, each one the whole plan run again. It is a component of the table rather than a result on its own.
- Total Principal
-
Unit $
About this output
What you owe today, added up across every debt listed. Every interest figure here is on top of this, and the difference between the two orders never touches it: both clear exactly the same debt.
- Table1 Payoff Row Axis
-
No unit declared
About this output
The values down the left of the grid: what you can pay each month above every minimum, in steps of a hundred either side of your own figure, never below nothing and never above the largest the field accepts. Read a row to hold the extra payment fixed and vary the rate. The middle entry is your own figure, and any row that would fall below nothing reads nothing instead, which is the floor doing its job rather than an error.
- Table1 Payoff Row Input
-
Unit currency/month
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 the extra payment you entered. Change that field above, never this one: the axis is derived from it, so editing the mirror moves the axis while the table walks and the grid comes out meaningless.
- Snowball Interest
-
Unit $
About this output
The same total if the spare money goes to the smallest balance first. The extra you pay for that order is what you are buying the early win with, and seeing it as a number is the point of running both.
- Avalanche Months
-
Unit months
About this output
How many months until every debt is gone if the spare money always goes to the debt charging the most. Counted from now, with the first payment a month away. This is what the grid at the foot of the sheet tabulates.
- Avalanche Total Paid
-
Unit $
About this output
Everything you hand over from now until the last debt is gone, under the dearest-first order: what you owe today plus all the interest on it. The gap between this and what you owe today is the price of the borrowing.
- Avalanche First Payoff Month
-
Unit months
About this output
The month the first debt disappears entirely if you pay the dearest first. Zero means no debt clears inside the months this model runs.
- Avalanche Interest
-
Unit $
About this output
Every dollar of interest you pay along the way if the spare money always goes to the dearest debt. It is the smaller of the two interest figures in almost every case, and the amount it is smaller by is the whole financial argument for this order.
- Months Difference
-
Unit months
About this output
How many months longer the smallest-balance order takes. Zero is a common and honest answer: the two orders only diverge once there is money spare to direct, and even then the gap is usually small.
- Snowball First Payoff Month
-
Unit months
About this output
The month the first debt disappears entirely if you pay the smallest first. This is the figure the smallest-balance order exists for, and it is usually much earlier than the other one. Whether that is worth the extra interest is a question about you rather than about arithmetic, and this reports both sides of it.
- Interest Saved By Avalanche
-
Unit $
About this output
The second figure less the first: what paying the dearest debt first saves you over paying the smallest first. Read it against the month the first debt clears under each order, because that is the trade. Zero means the two orders coincide, which happens whenever the dearest debt is also the smallest and whenever there is nothing spare to direct.
- Model Status
-
No unit declared
About this output
Reads OK, or explains why the debts as listed are not a question this model can answer, or why an answer that computed deserves a second look.
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 run both debt payoff orders against the same money: highest rate first, and smallest balance first. Up to ten debts are followed month by month with their own rates and minimum payments, and the calculator reports what each order costs in interest, how long each takes, and the month each one clears its first debt, so the case for clearing a small debt early is a number rather than a claim.
It compares two orders. It does not tell you which to choose, because the early win one of them buys is worth something this model cannot price.
Inputs and units
| Input | Unit | Accepted range | What it means |
|---|---|---|---|
| Debts Grid | mixed | at least two debts, up to ten | One row per debt: a name for your own use, what you owe on it today, the interest rate it charges you a year, and the smallest payment the lender will accept each month. Enter the minimum the lender asks for, not what you intend to pay, because anything above it belongs in the extra payment field where both orders can direct it. Leave unused rows blank and keep them at the bottom. |
| Extra Monthly Payment | $/month | 0 through 5,000 | Money you can put against the debts each month on top of every minimum. It is the field that decides how much the choice of order matters: with nothing spare there is no pool to direct, so both orders pay the same minimums in the same months. Nothing spare is a real situation and is entered as nothing rather than skipped. |
| APR Shift | percentage points | minus 5 through plus 5 | Optional. The same movement applied to every rate, which is the scenario a variable rate card puts you in. Enter 2 to ask what happens if every rate rises two points, or minus 1 for a fall. Each rate is held at or above nothing, so a large fall cannot make a lender pay you. It moves the order as well as the cost, because the highest rate order is decided on the rates after the change. |
Governing relationships
Every debt is followed month by month. Each month a debt is charged one twelfth of its annual rate on the balance standing at the start of that month, and its own minimum payment is applied.
The extra payment is a pool on top of those minimums, and the two orders differ only in where the pool goes. Under the highest rate order it goes to whichever live debt charges the most; under the smallest balance order it goes to whichever live debt owes the least. When a debt clears, its minimum payment joins the pool for the rest of the plan, which is why both orders finish faster than the minimums alone would.
The same money goes in every month under both orders, so both clear exactly the same principal. The whole of the difference between them is interest, and it comes from how long each balance is carried before the pool reaches it.
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.
- Read the debts and apply the rate movement, if one was entered, to every rate at once.
- Add the balances together to get what is owed today, which both orders will clear identically.
- Run the plan month by month with the pool directed at the dearest live debt, recording the month each debt disappears and the interest charged along the way.
- Run the same plan again with the pool directed at the smallest live balance instead.
- Read off, for each order, the month everything is gone, the month the first debt is gone, and the interest paid.
- Subtract one order's interest from the other's to get what paying the dearest first saves, and one set of months from the other to get how much longer the other order takes.
- Rerun the dearest first plan across a grid of extra payments and rate movements, so the sensitivity of the answer to each is visible rather than asserted.
Outputs and interpretation
| Output | Role | Unit | What it means |
|---|---|---|---|
| Avalanche Months | primary | months | How many months until every debt is gone if the spare money always goes to the debt charging the most, counted from now with the first payment a month away. |
| Snowball First Payoff Month | primary | months | The month the first debt disappears entirely if you pay the smallest first. This is the figure the smallest balance order exists for, and it is usually much earlier than the other one. Whether that is worth the extra interest is a question about you rather than about arithmetic, and this reports both sides of it. |
| Interest Saved By Avalanche | primary | $ | What paying the dearest debt first saves you over paying the smallest first. Read it against the month the first debt clears under each order, because that is the trade. Nothing means the two orders coincide, which happens whenever the dearest debt is also the smallest and whenever there is nothing spare to direct. |
| Avalanche Interest | detail | $ | Every dollar of interest you pay along the way if the spare money always goes to the dearest debt. It is the smaller of the two interest figures in almost every case, and the amount it is smaller by is the whole financial argument for this order. |
| Snowball Interest | detail | $ | The same total if the spare money goes to the smallest balance first. The extra you pay for that order is what you are buying the early win with, and seeing it as a number is the point of running both. |
| Snowball Months | detail | months | The same count as above if the spare money always goes to the smallest balance. It is usually the same or a month or two longer, because the money going in each month is identical and only its destination changes. |
| Months Difference | detail | months | How many months longer the smallest balance order takes. Nothing here is a common and honest answer: the two orders only diverge once there is money spare to direct, and even then the gap is usually small. |
| Avalanche First Payoff Month | detail | months | The month the first debt disappears entirely if you pay the dearest first. Nothing means no debt clears inside the months this model runs. |
| Avalanche Total Paid | detail | $ | Everything you hand over from now until the last debt is gone, under the dearest first order: what you owe today plus all the interest on it. |
| Total Principal | detail | $ | What you owe today, added up across every debt listed. Every interest figure here is on top of this, and the difference between the two orders never touches it: both clear exactly the same debt. |
Model Status reads OK, or explains why the debts as listed are not a question this model can answer, or why an answer that computed deserves a second look.
The calculator also returns a grid that reruns the plan across a range of extra payments and rate movements 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 |
|---|---|
| Fewer than two debts carry all three of their figures | NOT VALID: list at least two debts, each with a balance, an interest rate and a minimum payment; with one debt there is no order to choose |
| A debt is missing one of its three figures | NOT VALID: debt … is missing one of its three figures; every debt needs a balance, an interest rate and a minimum payment |
| A debt has a balance but no minimum payment | NOT VALID: debt … has a balance but no minimum payment; enter what the lender asks for each month, even if you pay more |
| A filled row sits below a blank one | NOT VALID: list the debts from the first row down with no blank row in between; the unused rows go at the bottom |
| The extra payment is below nothing | NOT VALID: an extra payment cannot be negative; this tool plans money going in, not coming out |
| A debt's minimum does not cover its own first month of interest | CHECK: debt …'s minimum does not cover its own first month of interest, so that balance stands still or grows until the order reaches it; it needs more than its interest every month to fall at all |
| The debts have not cleared within the months this model runs | CHECK: at this payment the debts do not clear inside the … months this model runs, so the months and the interest are floors rather than answers; add to the extra payment |
| None of the preceding conditions applies | OK |
Assumptions and limitations
- Interest on every debt is charged once a month, at its annual rate divided by twelve, on the balance at the start of the month.
- Minimum payments are held fixed at the amounts you enter. A card whose minimum falls as its balance falls will ask for less over time than this assumes, which makes the plan modelled here the faster of the two.
- The extra payment is the same every month for the whole plan.
- A cleared debt's minimum joins the pool, which is what makes either order finish sooner than the minimums alone.
- The name column is yours to read and no calculation looks at it.
- Nothing is charged to any of these accounts after today, and no fee, penalty rate or promotional rate ending is modelled.
Restrictions and non-computing states
This calculator enforces the numeric limits recorded above before either order is run, so a value outside them is refused rather than answered.
At least two debts must carry all three of their figures. With one debt there is no order to choose, and a row carrying only some of its figures is refused by number rather than quietly ignored.
The debts must be listed from the first row down with no gap between them. A filled row below a blank one is refused rather than silently skipped.
The plan is followed for a limited number of months. Where the debts do not clear inside that window the run stops there, and the status line says the months and the interest are floors rather than answers.
Errors and warnings
NOT VALID means the debts as listed are not 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 debt whose minimum cannot cover 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
Both payoff orders are defined, and both are computed from the same debts, by the US Department of Defense Office of Financial Readiness in its Debt Destroyer, which states the two methods in the same terms this calculator uses.
For a published comparison of the two orders across a real set of debts, showing how small the difference in months usually is and how the whole of the difference falls in interest, see the LendingTree debt avalanche against debt snowball study.
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. Which order to follow is partly a question about what keeps you paying, and no arithmetic here can answer that half of it.
Found a problem, or have an idea?
Tell us if a result looks wrong, a label is unclear, or something is missing. We read every message.