How to Build a Debt Snowball in a Spreadsheet

Someone carrying five different debts can usually name the total they owe and the checks they write each month. The harder question is what to do with a spare $250. Split it evenly across everything? Send it to the biggest balance, the one that feels heaviest? Aim it at the card charging the most interest? Each of those choices produces a different payoff date and a different interest bill, and none of them is obvious from a stack of statements. Working out which debt to attack first, and what happens to every other debt while that one is cleared, is exactly the kind of bookkeeping a spreadsheet does well.

The debt snowball is one specific answer to that question: pay every minimum, then throw the extra at the smallest balance until it is gone, and roll each freed-up payment onto the next-smallest debt. The examples below come from our Debt Snowball Ultimate Spreadsheet Template ($29), which takes a list of debts and a single extra payment and computes the full plan from them. The structure is reproducible by hand if you would rather build your own.

What a debt snowball spreadsheet has to hold

Strip the plan down and there are only a few moving parts:

1. The debts. For each one: a name, the current balance, the APR, and the minimum payment. This is everything you type.
2. One extra payment. A single monthly amount, above all the minimums, that drives the whole plan.
3. The schedule. A month-by-month projection of what gets paid and what remains on every debt, with the extra rolling forward as balances clear.
4. The read-outs. Payoff order, months to debt-free, interest paid, milestones, and a comparison against paying only the minimums. These are all calculated, never typed.

The template gives each of these its own sheet. Debt Setup holds the inputs, the Snowball Schedule is the engine, and Payoff Milestones, Snowball vs Minimum, and What-If Analysis are three different ways of reading the result, with a Dashboard on top and a How to Use sheet carrying the instructions. The walkthrough below works through them from the inputs to the dashboard.

Start with the inputs: the Debt Setup sheet

Everything begins on Debt Setup, and it asks for little. Up to 12 debts are supported, one per row, and each row takes four entries: a free-text name, the balance, the APR, and the minimum payment the lender requires. The sample fills five rows:

Two more columns fill themselves for each row. Monthly Interest turns the balance and APR into a dollar figure, so the $2,400 store card at 24.99 percent shows about $50 of interest a month while the interest-free medical bill shows $0. Min-Only Months estimates how long that one debt would take carrying its minimum alone, which is why the store card reads 54 months and the credit card 73. Those per-debt estimates are context, not the plan; the plan comes later once the debts are paid in sequence.

Above the debt list sits the single most important input: the Extra Monthly Payment, set to $250 in the sample, described on the sheet as the amount above all minimums applied to the smallest balance. That one cell is the engine’s fuel. Set it to zero and the plan runs on the minimums alone, with each cleared payment still rolling onto the next debt; raise it and every payoff date moves in.

A couple of entry habits keep the numbers honest. The APR field takes the annual rate as the lender quotes it, and an interest-free balance such as the medical bill or a promotional zero-percent period is entered as 0, which is why the medical bill shows no monthly interest and accrues nothing across the plan. The debt name is free text, so “Visa” or “Car Loan” reads however you label it, and the schedule columns later inherit those exact names. The sheet also shades its input cells, leaving the calculated cells white and set to warn before they are overwritten, so it is clear at a glance which four columns are yours to fill and which are doing the arithmetic.

Underneath, a Calculated Summary block turns the inputs into headline numbers before you have looked at any other sheet:

The weighted average APR is balance-weighted, so the big low-rate car loan pulls the blended figure down to 11.67 percent even though two of the debts sit above 20 percent. The total monthly payment is the $780 of minimums plus the $250 extra, which is $1,030. That total is the amount leaving the account every month until the last debt is cleared. Everything below it is read off the schedule that the next sheet builds.

The engine: the Snowball Schedule

The Snowball Schedule is where the plan plays out. It runs a 180-month grid, one Payment and one Balance column for every debt, in the order the debts were listed on Debt Setup. The columns take their names from the setup sheet, and the rows stop once nothing is owed, so a schedule is as long as the plan needs and no longer. In the sample, that means 37 rows carry numbers.

The month-by-month numbers make the snowball concrete. Trace the sample:

• The smallest balance goes first. The medical bill has a $50 minimum, but the $250 extra piles on top of it, so it is paid $300 a month. Its balance runs $900, $600, $300, and then zero, cleared in month 4.
• The freed payment rolls forward. When the medical bill clears, its $50 minimum and the $250 extra, $300 together, move to the store card. The store card was paying its $75 minimum; from month 5 it pays $375, and its balance falls from $2,297 at the end of month 4 to $229 by month 10, clearing in month 11.
• The snowball keeps growing. The store card’s $75 now joins the pool too. The credit card, which had been paying its $145 minimum, jumps to $520 a month from month 12 and clears in month 23. The personal loan then takes the whole pool at $720 a month and clears in month 31. Finally the car loan absorbs everything at $1,030 a month, the full monthly budget, and clears in month 37.

Laid out as the amount hitting the current target, the snowball is one growing column of money:

That last figure is the tell: by the end, the entire $1,030 is landing on a single debt. Nothing about the household budget changed over those three years; the same $1,030 went out every month. What changed is that each cleared debt handed its payment to the next, so the amount hitting the target debt snowballed from $300 to $1,030. That is the whole mechanism, and watching the payment column step up each time a balance hits zero is the clearest way to see it.

The schedule also totals the interest each debt accrues along the way, and those totals feed the read-outs: about $0 on the interest-free medical bill, $383 on the store card, $1,723 on the credit card, $1,859 on the personal loan, and $1,643 on the car loan, summing to the $5,608 headline. The grid runs 180 months, so it holds 15 years of headroom for slower plans while the sample uses only the first 37.

Progress you can see: the Payoff Milestones sheet

A 37-month plan is hard to feel from a schedule grid, so the Payoff Milestones sheet reduces it to five checkpoints and puts dates on them. The milestones are fixed markers rather than something you configure: the first debt paid off, then a quarter, half, three quarters, and all of the total balance cleared.

The targets are simple fractions of the $31,900 total, and the months-away column is read from the Snowball Schedule, so the checkpoints land where the plan actually reaches them. The projected dates count forward from the month you open the file, which is why they shift over time while the months-away figures hold steady. A Current column, blank in the sample, is where you record how much you have paid off in total so far; the Progress column then shows current divided by target, capped at full, and turns green once a milestone is reached in full.

The uneven spacing is the honest part. The first debt clears in 4 months, but the halfway mark does not arrive until month 21, because the early payments are small and the snowball has not yet gathered its later size. Seeing that curve laid out as dates is different from being told the plan takes 37 months.

The comparison that gives the plan meaning: Snowball vs Minimum

A payoff date means little on its own; it needs something to be compared against. The Snowball vs Minimum sheet supplies the baseline by re-running the same debts under a strict minimum-only rule, where every debt gets exactly its minimum and nothing extra ever moves.

Read across, the two approaches diverge sharply. Minimum-only takes 73 months against the snowball’s 37, and it runs up $10,833 of interest against $5,608, a computed gap of $5,225. That same $5,225 shows up on the total-amount-paid row, since the interest is the only thing that differs between the two runs. The Difference column is defined as minimum-only less snowball, which is why the average-monthly-payment row shows a negative $429: the snowball puts more money out each month, about $1,014 on average against $585, and that higher outlay is what buys the shorter timeline. The sheet states this plainly, noting that a negative figure in that column means the snowball costs more per month.

Below the comparison, the sheet lists each debt again with its balance, APR, and the month it is paid off under the snowball, so the payoff order is visible in one place: medical bill month 4, store card month 11, credit card month 23, personal loan month 31, car loan month 37. That ordering is strictly by starting balance, which is the definition of the snowball, and it is worth noticing that it does not follow the APRs. The 24.99 percent store card is cleared second because it is small, while the 5.9 percent car loan is cleared last because it is large.

Test a bigger payment: the What-If Analysis sheet

The extra payment on Debt Setup drives the whole plan, so the natural next question is what a different amount would do. The What-If Analysis sheet answers it without disturbing the main plan. It has a single input, an extra payment to test, set to $500 in the sample, and it re-solves the entire snowball for that figure in its own hidden schedule, leaving the Debt Setup number untouched.

Doubling the extra payment from $250 to $500 pulls the payoff in by 8 months, from 37 to 29, and trims the interest by about $1,554, from $5,608 to $4,054. The Difference row states both effects in one line: how many months sooner the plan finishes and how much interest it avoids. The two rows come from two full runs of the same snowball logic, one on the live extra payment and one on the amount being tested, so the comparison is a genuine re-solve rather than a rough estimate. Because the test run reads the same debts from Debt Setup, editing a balance or a rate moves both the current plan and the tested amount together, so the comparison always stays apples to apples. Typing any figure into that one cell re-runs the arithmetic; there is nothing else to change.

The Dashboard: six numbers and two charts

With the inputs entered, the Dashboard, shown at the top of this article, states the plan in one screen. A line above the tiles summarizes it in a sentence, reading “5 debts tracked - snowball payoff in 37 months” for the sample, and six KPI cards carry the headline figures:

The pairing of Total Interest and Interest Saved is the part worth pausing on, because the two cards answer different questions. Total Interest is the cost of the snowball itself, the $5,608 the plan hands to lenders on the way to zero. Interest Saved is a relative figure, the $5,225 that separates that plan from doing nothing extra. A household deciding whether the higher monthly outlay is worth it reads those two cards together: one is the price of the plan, the other is what the plan buys against the slow path. Both are computed, and both move the moment a balance or an extra-payment cell changes.

Below the cards, a Debt Overview table lists each debt with its balance, APR, minimum payment, the month it is paid off, and the interest it accrues, ending in a total row. Two charts sit under that. The first, “Total Balance Over Time,” plots the snowball and minimum-only trajectories side by side, so the snowball line reaching zero at month 37 while the minimum-only line trails on toward month 73 is visible at a glance. The second, “Interest Paid Per Debt,” shows where the interest lands under each method. None of these outputs is typed. Every one of them recalculates from Debt Setup, so nothing on the dashboard is a fixed example; change a balance and the whole screen moves.

Snowball, avalanche, and minimum-only in plain terms

Three phrases do most of the work in this template, and it helps to keep them straight.

The snowball pays every minimum, then aims the extra at the smallest balance, and rolls each cleared payment into the next-smallest debt. The order comes from balances, not interest rates. The Consumer Financial Protection Bureau describes this approach as focusing on the smallest debt first to get rid of it as soon as possible, which is the method this template computes.

Minimum-only is the do-nothing-extra baseline: pay each minimum and never a cent more. It is not a strategy anyone chooses so much as the default the snowball is measured against, and in the sample it is the slower, costlier path at 73 months and $10,833 of interest.

The avalanche is a different approach that targets the highest-APR debt first, on the logic that the most expensive balance costs the most to carry. The template’s notes mention it, but this file does not calculate it; the interest-saved figure here is snowball against minimum-only, not snowball against avalanche. Which order clears a given set of debts fastest or cheapest depends entirely on the specific balances and rates, and comparing the two orders side by side is a separate exercise. The CFPB lays out both methods and leaves the choice to the reader.

Excel or Google Sheets for a debt snowball

The template is an .xlsx file built on plain formulas, with no macros and no add-ons, so it runs the same way in Microsoft Excel and in Google Sheets after upload, and in LibreOffice Calc as well. A currency dropdown on the Dashboard relabels every money column and KPI across the workbook; it changes the label shown, not the underlying numbers, so it does not convert anything. Whichever program you prefer, the structure described here, a debt list feeding a rolling schedule feeding a set of read-outs, is the same, and it is buildable by hand in either if you would rather assemble your own spreadsheet template than start from a finished one.

Which debt template fits

• Debt Snowball Ultimate Spreadsheet Template ($29) is the workbook this walkthrough follows: the debt list, the rolling 180-month schedule, the milestones, the minimum-only comparison, and the what-if tester, all driven by one extra-payment cell. There is also a free Debt Snowball template for a simpler single-sheet start and an Essentials version in the same family.
• Credit Card Payoff Ultimate Spreadsheet Template ($29) is the sibling for someone whose debts are mostly cards. It plans a payoff across multiple cards with its own month-by-month schedule and adds card-specific views the snowball file does not carry, including a balance-transfer comparison and a utilization tracker.

Related

• Debt Snowball Spreadsheet: Payoff Order in One Excel File - a lighter single-file take on the same payoff-order idea
• Debt Snowball vs. Debt Avalanche: Which Actually Works? - the strategy debate this template deliberately leaves open
• Debt Payoff Calculator: Snowball vs. Avalanche Compared - putting the two orderings side by side