finance-business · personal-finance · debt

Debt Payoff Avalanche vs Snowball Calculator

Runs both debt payoff orders side by side on the same money: the highest rate first, and the smallest balance first, over up to ten debts with their own rates and minimum payments. It 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, and it tabulates the payoff across a grid of extra payments and rate changes.

Last updated

Calculator overview

Inputs and outputs

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

Inputs

Extra Monthly Payment (required)
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.

Unit $/month Default 200 Range 0 to 5000
Debts Grid (required)
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.

Default 2 rows
ColumnRange 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
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.

Unit percent points Default Not set Range -0.05 to 0.05

Outputs

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 the rate change you entered.

Unit percent points
Table1 Payoff Corner
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.

Unit months
Snowball 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.

Unit months
Table1 Payoff Column Axis
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.

No unit declared
Table1 Payoff Values
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.

Unit months
Total Principal
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.

Unit $
Table1 Payoff Row Axis
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.

No unit declared
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 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.

Unit currency/month
Snowball Interest
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.

Unit $
Avalanche 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.

Unit months
Avalanche Total Paid
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.

Unit $
Avalanche First Payoff Month
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.

Unit months
Avalanche Interest
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.

Unit $
Months Difference
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.

Unit months
Snowball First Payoff Month
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.

Unit months
Interest Saved By Avalanche
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.

Unit $
Model Status
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.

No unit declared
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 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.

  1. Read the debts and apply the rate movement, if one was entered, to every rate at once.
  2. Add the balances together to get what is owed today, which both orders will clear identically.
  3. 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.
  4. Run the same plan again with the pool directed at the smallest live balance instead.
  5. Read off, for each order, the month everything is gone, the month the first debt is gone, and the interest paid.
  6. 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.
  7. 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.

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