free template · no email required
Free Debt Snowball Calculator (Google Sheets & Excel)
List your debts smallest balance first, add the extra you can pay each month, and see months-to-payoff for every debt — with your extra aimed at the top of the list, the way the snowball method works.
Works in Google Sheets & Excel · no signup, no watermark, actually free
What's in it
Smallest-first ordering
The snowball's power is early wins. The sheet aims your extra payment at the first unpaid debt on the list.
Real payoff months
Months-to-clear computed from balance, APR, and payment — including a warning when a payment doesn't even cover interest.
Total debt in one number
Sometimes seeing it is the kick. Sometimes it's smaller than the dread suggested.
How to use it
- Download the file — the button above grabs the .xlsx.
- Google Sheets: drive.google.com → New → File upload → open it → File → Save as Google Sheets. Excel: just open it.
- Enter your extra amount — whatever you can put beyond minimums, even $25.
- List debts smallest balance first with balance, APR, and minimum payment.
- When the first debt clears, roll its whole payment into the next one and delete the cleared row. Repeat until the list is empty.
- The one rule: shaded cells are yours to type in. Everything else computes itself.
Questions
Snowball or avalanche?
Snowball (smallest first) wins on behavior; avalanche (highest APR first) wins on math. For most people the interest difference is smaller than the motivation difference — our honest comparison runs the numbers.
What does the paid toolkit add?
Complete multi-debt plans for both strategies with rollover math done for you: focus order, payment schedule, debt-free dates, and total interest compared side by side.
My "months left" says payment too low.
That debt's payment doesn't cover its monthly interest, so the balance grows. It needs a bigger minimum or a spot at the top of the list — this is exactly the thing worth knowing early.
Want the whole plan, not just the list?
The Debt Payoff Toolkit builds both payoff strategies with every rolled-over dollar accounted for, and tells you your debt-free date. $19 once.
See the Debt Payoff ToolkitRelated guides: Snowball vs avalanche · Budgeting by paycheck · The bill calendar method