A debt snowball spreadsheet lists every debt you owe, sends all your spare money to the smallest balance, and rolls each paid-off payment into the next debt until nothing is left. It gives each debt a payoff month and gives you a debt-free date, so you can see the finish line before you start. It is built for anyone paying down two or more credit cards, loans or bills at once.
The calculator above runs the same math in your browser. The debt calculator tab in our budget spreadsheet keeps it in one file with the rest of your budget, and adds a custom payoff order.
What the debt payoff spreadsheet tracks
The debt calculator tab asks for four things per debt, plus one number for the whole plan:
- Debt name, so the payoff order is easy to read.
- Balance, the current amount owed from your latest statement.
- Interest rate (APR), the yearly rate printed on the statement.
- Minimum payment, the least you must pay each month.
- Extra monthly payment, the amount you can add on top of all the minimums.
Then you choose the order: the snowball (smallest balance first), the avalanche (highest interest rate first) or your own custom order. The tab shows the payoff date of each debt, the total interest and your debt-free date.
It is a standalone tool. Payments you log in the monthly tabs do not update it, so you refresh the balances yourself when statements arrive.
Debt snowball example: four debts, snowball vs avalanche
These are the example debts loaded in the calculator above, with a $200 extra payment. The assumptions: fixed interest rates, interest charged monthly (balance × APR ÷ 12), no new charges, and the same total payment every month. That total is the four minimums ($445) plus the $200 extra, so $645 a month.
| Debt | Balance | APR | Minimum | Snowball: paid off | Avalanche: paid off |
|---|---|---|---|---|---|
| Medical bill | $600 | 0% | $50 | Month 3 | Month 12 |
| Personal loan | $2,400 | 13.5% | $85 | Month 10 | Month 21 |
| Credit card | $4,800 | 24.9% | $120 | Month 21 | Month 18 |
| Car loan | $7,500 | 7.9% | $190 | Month 28 | Month 28 |
| Total interest | $2,649 | $2,322 |
How the snowball rolls. For two months, $250 goes to the medical bill (its $50 minimum plus the $200 extra). It is paid off in month 3, and from month 4 the personal loan gets $335 a month. From month 11 the credit card gets $455, and from month 22 the whole $645 goes to the car loan.
How the avalanche rolls. The extra $200 goes to the credit card first, so it gets $320 a month. The medical bill, at 0%, is cleared by its own minimum in month 12, which lifts the card payment to $370. After the card is gone in month 18, the personal loan gets $455, then the car loan gets $645 from month 22.
How to read the debt snowball calculator
The headline shows the debt-free time for the cheaper method, 2 years and 4 months here, and the month it lands on counting from today. The table under it compares months and total interest for both methods. With these debts both finish in month 28, the avalanche saves $327 in interest, and the snowball clears its first debt in month 3 instead of month 12. The two numbered lists show when each debt disappears.
Two more runs with the same debts:
- Raise the extra payment to $300 and both methods finish in 24 months. Interest drops to $2,173 with the snowball and $1,882 with the avalanche.
- Set the extra to $0 but keep rolling each freed minimum forward, and the plan takes 46 months.
A custom order can split the difference. Pay the medical bill first for a quick win, then switch to the highest rate. By the same month-by-month math, that finishes in 28 months with $2,405 of interest: $83 more than the pure avalanche, $244 less than the snowball, with the first debt gone in month 3. The calculator on this page compares only the snowball and the avalanche; the custom order lives in the spreadsheet tab.
How to set up the debt calculator tab
- Gather your latest statement for every debt. You need the balance, the APR and the minimum payment from each.
- Open the debt calculator tab in Excel or in your Google Sheets copy, and enter one row per debt.
- Enter the extra monthly payment. Pick an amount you can pay every month, because the plan assumes the total never drops.
- Choose snowball, avalanche or custom. For a custom order, list your debts in the order you want them paid off; with the other two methods the list order does not matter.
- Read the payoff date of each debt, the total interest and the debt-free date. Switch methods and compare before you commit.
- On the setup tab, add a category in the debts group for these payments, so each monthly tab budgets the full amount ($645 in the example).
- Once a month, after statements post, update each balance so the dates stay honest.
The method behind the snowball and the avalanche
Both methods pay every minimum and put all extra money on one target debt. When the target is paid off, its payment moves to the next one, so the amount aimed at each debt keeps growing. The only difference is the order.
The snowball targets the smallest balance, which gives you early wins: in the example, one debt is gone in 3 months and two are gone in 10. Our guide to the debt snowball method walks through a full month-by-month example and the mistakes that stall it, such as adding new charges.
The avalanche targets the highest APR, which costs less interest whenever the high-rate debt is not also the smallest. The debt avalanche method guide covers when it is hard to stick with. For a side-by-side decision table and hybrid orders, read debt snowball vs avalanche.
Two things keep either plan on track. Stop adding to the cards you are paying off (our guide on how to budget with credit cards covers that), and save ahead for irregular costs with a sinking funds tracker so a car repair does not land back on a card. In a 50/30/20 budget spreadsheet, the extra payment belongs in the 20% bucket.
Build your own debt snowball spreadsheet
If you would rather make one, start with a Debts tab: debt name in column A, balance in B, APR in C (formatted as a percent) and minimum payment in D, with one debt per row from row 2 to row 5. Put your extra payment in G1. These formulas work the same in Google Sheets and Excel:
- Total monthly payment:
=SUM(D2:D5)+G1 - Interest this month (E2, fill down):
=B2*C2/12 - Months to clear one debt on its minimum alone (F2):
=ROUNDUP(NPER(C2/12,-D2,B2),0). For the example credit card this returns 87 months, which is why the extra payment matters. It shows an error if the minimum does not cover the interest. - Snowball rank (smallest balance is 1):
=RANK(B2,$B$2:$B$5,1)+COUNTIF($B$2:B2,B2)-1 - Avalanche rank (highest APR is 1):
=RANK(C2,$C$2:$C$5,0)+COUNTIF($C$2:C2,C2)-1
The COUNTIF part breaks ties, so two equal balances still get different ranks.
Sorting the list into payoff order is where the two apps differ:
- Google Sheets:
=SORT(A2:D5,2,TRUE)for the snowball,=SORT(A2:D5,3,FALSE)for the avalanche. - Excel (Microsoft 365 or Excel 2021 and later):
=SORT(A2:D5,2,1)for the snowball,=SORT(A2:D5,3,-1)for the avalanche. In older versions, select the rows and use Data > Sort.
For the schedule, add a tab per debt with Month in A, Balance in B, Interest in C, Payment in D and End balance in E. Type the starting balance in B2 and the payment in G1, then:
- Interest (C2):
=B2*Debts!$C$4/12(pointing at that debt’s APR) - Payment (D2):
=MIN(B2+C2,$G$1) - End balance (E2):
=B2+C2-D2 - Next month’s balance (B3):
=E2
Fill down until the end balance reaches zero. From the next month, add that debt’s payment to the next target’s payment cell. A hand-built sheet usually moves money one month later than the calculator above, which sends any leftover from a payoff month straight to the next debt, so your dates can differ by a month.
Who a debt snowball spreadsheet suits
It suits you if you have two or more debts and want to see a date, if you and a partner need to agree on an order, or if you want to test the snowball, the avalanche and your own order on your real numbers before choosing.
It is less useful with a single debt, where the NPER formula above answers the question in one cell. It will not pull balances from your bank: you type them in, which takes a few minutes a month. If your minimums do not cover the interest, or you are weighing consolidation or a settlement, talk to a qualified professional before you build a plan around them.
Start with the balances you have today, even if one is rough. A plan with a date on it is easier to follow than a perfect one you never start.
This page is general information to help you organize your money, not financial advice. For decisions about debt relief, taxes or investing, talk to a qualified professional.