DEBT PAYOFF
How to Make a Debt Snowball Spreadsheet in Excel or Google Sheets
A debt snowball spreadsheet answers two questions every month: which debt gets the extra money, and when will you be debt-free? Here's how the method works, how to set up the sheet with formulas that work in Excel and Google Sheets, and a calculator that compares snowball and avalanche on your own debts.
THE METHOD
How the debt snowball method works
List every debt from smallest to largest balance
Ignore the interest rate for the order. The smallest balance goes first, whatever its APR.
Pay the minimum on everything
Every account gets its required minimum payment every month, so nothing goes late.
Put every extra dollar on the smallest debt
Whatever you can add beyond the minimums goes to the debt at the top of the list.
Roll the payment forward
When a debt is paid off, its whole payment moves to the next one. The payment grows like a snowball while your total monthly outlay stays the same.
The method, popularized by personal finance author Dave Ramsey (see our guide to budgeting the Dave Ramsey way), trades some interest for quick wins. Research on consumer debt backs the psychology: a 2016 study in the Journal of Consumer Research found that people felt more progress, and were more motivated to keep repaying, when they concentrated payments on one account, especially a small one.
STEP-BY-STEP
How to set up a debt snowball spreadsheet
You need two areas: a debt list that stays short, and a monthly schedule that grows one row per month. Both work the same in Excel and Google Sheets.
| Column | What goes in it | Example |
|---|---|---|
| Debt name | Lender or account nickname | Store card |
| Balance | Current balance from your latest statement | $450 |
| APR | Annual interest rate, as a percentage | 24.99% |
| Minimum payment | Required monthly minimum | $25 |
| Order | Rank by balance, smallest = 1 | 1 |
| Months to pay off | Calculated, see formulas below | 3 |
| Payoff date | Calculated from today | Jan 2027 |
Above the list, add two input cells: Extra per month (what you can add on top of all minimums) and Total monthly budget =SUM(Minimums)+Extra. That total stays fixed until the last debt is gone; it's what makes the snowball roll.
SPREADSHEET FORMULAS
Debt snowball formulas for Excel and Google Sheets
| Task | Formula |
|---|---|
| Snowball order | =RANK.EQ(B2,$B$2:$B$11,1) ranks balances smallest first |
| Sorted list (Excel 365) | =SORTBY(A2:D11,B2:B11,1) |
| Sorted list (Google Sheets) | =SORT(A2:D11,2,TRUE) |
| Monthly interest | =Balance*APR/12 |
| Months at a fixed payment | =NPER(APR/12,-Payment,Balance) |
| Payoff date | =EDATE(TODAY(),ROUNDUP(Months,0)) |
| Schedule: payment on a non-target debt | =MIN(StartBalance+Interest,Minimum) |
| Schedule: payment on the target debt | =MIN(StartBalance+Interest,Budget-SUM(OtherPayments)) |
| Schedule: end balance | =StartBalance+Interest-Payment |
The "target debt" is the first debt in your order that still has a balance. In the schedule, give each debt three columns (start balance, payment, end balance) and one row per month. When a debt's end balance reaches zero, the target moves to the next one automatically, because the budget minus the other payments now flows there.
WORKED EXAMPLE
Four debts, $200 extra a month
Store card $450 at 24.99% ($25 minimum), medical bill $1,200 at 0% ($50), credit card $3,800 at 22.9% ($95), car loan $9,500 at 7.5% ($260). Minimums total $430; with $200 extra the monthly budget is $630.
Illustrative debts, monthly interest approximation- Store card paid off
- Month 3 Smallest balance goes first
- Medical bill paid off
- Month 7 Its $50 joins the snowball
- Credit card paid off
- Month 18 Now with a $370 payment
- Debt-free
- Month 27 Car loan gets the full $630
- Total interest
- $1,917 Over the 27 months
- Minimums only
- 44 months $3,761 interest, no extra
The $200 extra cuts 17 months and about $1,840 of interest compared with paying only the minimums (with freed-up minimums still rolled over). That gap is why the "extra per month" cell is the most important number in the sheet.
WHICH ORDER?
Debt snowball vs. debt avalanche
Smallest balance first
In the example: first payoff in month 3, second in month 7. Debt-free in month 27 with $1,917 interest. Faster visible wins, fewer accounts to juggle sooner.
Highest APR first
Same debts: first payoff in month 3, but the second not until month 16. Debt-free in month 27 with $1,714 interest, about $200 less. Mathematically cheaper whenever rates differ.
The avalanche always costs the same or less in interest. The snowball wins on momentum: more debts disappear early. If the difference on your own debts is small, the method you'll stick with is the better one. The calculator below shows both for your numbers.
YOUR DEBTS
Debt snowball calculator
TRY IT
Enter your debts
Replace the example rows with your own balances, APRs and minimum payments. Nothing you type is saved or sent anywhere.
Snowball Β· smallest balance first
Avalanche Β· highest APR first
Enter your debts to see the plan.
The calculator applies interest monthly (APR Γ· 12), pays every minimum first, then sends the rest of the budget to the target debt. Real statements will differ slightly; promotional rates, fees and new charges aren't included.
KEEP IT ROLLING
Debt snowball mistakes to avoid
- !Lowering the budget after a payoffThe freed payment must roll to the next debt. Spending it stops the snowball.
- !Adding new chargesNew balances on paid-off cards quietly undo the plan. Track them in the sheet if they happen.
- !Skipping a minimumLate fees and penalty APRs cost more than any ordering choice. Minimums come first, every month.
- !Never updating balancesEnter the real statement balance monthly; the schedule is only as accurate as its inputs.
- !No emergency cushionOne surprise bill on a card can erase months of progress. Many plans start with a small cash buffer, plus sinking funds for bills you can see coming.
- !Ignoring promo rate end datesA 0% balance that jumps to 25% may deserve to move up the list before the promo ends.
Next steps: track how paying off debt raises your net worth, and plan the extra payments month by month in a yearly budget for 2027.
READY-MADE TEMPLATE
Prefer a debt snowball spreadsheet that's already built?
The steps above are enough to build your own. If you'd rather enter your debts and get the schedule straight away, there is a ready-made template for Excel and Google Sheets; check the product page for current features and requirements.
Debt Snowball Calculator Spreadsheet Template for Excel & Google Sheets
The current listing describes tracking up to 50 debts with the snowball method, automatic calculations in any currency, a payment schedule that accepts extra payments, a debt balance breakdown, a repayment end date, a dashboard with monthly targets per debt and a payments tracker.
- Up to 50 debts
- Payment schedule with extra payments
- Debt-free end date and dashboard
The same template comes in several color themes, and debt payoff trackers for any order are in the debt collections. Product features and compatibility are listed on each product page and may change.
See all debt snowball templatesFAQ
Debt snowball spreadsheet questions
How do I make a debt snowball spreadsheet?
List each debt with balance, APR and minimum payment, sort by balance from smallest to largest, set a fixed monthly budget equal to all minimums plus your extra, and build a monthly schedule where the extra goes to the first unpaid debt.
Does Google Sheets work for a debt snowball?
Yes. SORT, NPER, EDATE, MIN and RANK.EQ all work in Google Sheets, and the same layout works in Excel. In Excel 365 you can use SORTBY instead of SORT.
Is the debt snowball or avalanche better?
The avalanche (highest APR first) never costs more interest. The snowball (smallest balance first) pays off accounts sooner, which many people find motivating. Compare both on your own debts and pick the one you'll follow.
Should a 0% debt be in the snowball?
Yes, it goes in the list by balance like any other debt. Check when a promotional rate ends; if the rate will jump, consider moving it up the order before then.
Should I include my mortgage?
Many people leave the mortgage out and run the snowball on consumer debts only, then decide separately whether to pay the mortgage early. It's a personal choice; the spreadsheet works either way.
How do I calculate the months to pay off a debt in Excel?
Use =NPER(APR/12,-Payment,Balance). It returns the number of months at a fixed payment; wrap it in ROUNDUP and EDATE to get a payoff date.
Sources and further reading
- Kettle, Trudel, Blanchard and HΓ€ubl (2016), Repayment Concentration and Consumer Motivation to Get Out of Debt, Journal of Consumer Research
- CFPB: How does my credit card company calculate the interest I owe?
- Microsoft Support: NPER function
- Google Docs Editors Help: NPER
Formulas and example checked October 2026. This article provides general educational information, not financial advice.
