A debt snowball spreadsheet lists your debts from the smallest balance to the largest, fixes one total monthly payment, and pays only the minimum on everything except the smallest. When that debt clears, its payment rolls into the next one. The month-by-month table below shows exactly when each loan will finish.
What do I enter before building the table?
Open a tab called Plan. Put the total you can pay every month toward debt in B1, and label A1 as Total monthly payment. Then list the debts in rows 4 to 6 in order of balance, smallest first:
- A: Name of the debt
- B: Opening balance
- C: Annual interest rate, written as a percentage, for example 36%
- D: Minimum monthly payment or EMI
The total in B1 must be at least the sum of the three minimums, or the sheet will show a shortfall. Rates come from your card statement or loan schedule; if you are unsure, use the figure on the latest statement and treat the result as an estimate.
How is the month-by-month table laid out?
From row 10 down, each row is a month. Columns B to E belong to the first debt (opening, interest, payment, closing), F to I to the second, J to M to the third. Column N adds the month's interest. The first row of each opening column points at the balance you entered; later rows copy the previous closing.
- Interest, first debt: =B10*$C$4/12
- Payment, first debt: =MAX(0, MIN(B10+C10, $B$1-MIN($D$5,F10+G10)-MIN($D$6,J10+K10)))
- Closing, first debt: =B10+C10-D10
- Payment, second debt: =MAX(0, MIN(F10+G10, $B$1-D10-MIN($D$6,J10+K10)))
- Payment, third debt: =MAX(0, MIN(J10+K10, $B$1-D10-H10))
The idea is that the smallest debt receives everything left after the other two get their minimums. Once it is cleared, its share flows down automatically, because the payment cells are built from the total, not from a fixed EMI. Fill the rows down for about sixty months.
A worked example with three made-up debts
Say a credit card has ₹40,000 at 36 percent a year with a ₹2,000 minimum, a gadget EMI has ₹18,000 left at 14 percent with a ₹3,000 EMI, and a personal loan has ₹90,000 at 12 percent with a ₹4,500 EMI. You can pay ₹12,000 a month in total. Smallest balance first puts the gadget first, then the card, then the loan. In month 1 the sheet shows:
| Debt | Interest | Payment | Closing |
|---|---|---|---|
| Gadget EMI | ₹210 | ₹5,500 | ₹12,710 |
| Credit card | ₹1,200 | ₹2,000 | ₹39,200 |
| Personal loan | ₹900 | ₹4,500 | ₹86,400 |
The payments add up to ₹12,000. The gadget gets ₹3,000 plus the spare ₹2,500. Interest is simply balance times annual rate divided by twelve, such as 18,000 x 14% / 12 = ₹210.
When does each debt finish?
Run the rows down and read where each closing balance reaches zero. A quick way is =COUNTIF(E10:E69,">0.5")+1, which counts the months with a balance still open and adds one. For this example it gives:
| Debt | Cleared in month |
|---|---|
| Gadget EMI | 4 |
| Credit card | 9 |
| Personal loan | 14 |
Total interest, =SUM(N10:N69), comes to about ₹16,436. In month 4 the gadget needs only ₹1,967, so the card gets ₹5,533 that month and ₹7,500 from month 5. Seeing that jump on screen is the motivating part of the snowball.
Does the snowball order always save the most money?
No. It is built to give early wins, not to minimise interest. When a high-rate debt is large, paying it last costs more. The avalanche version of the same sheet sorts by rate instead, and comparing the two on your own numbers is the honest way to choose.
Keep it working
- Update the opening balances with real statement figures every few months and let the table recalculate.
- Stop adding new spending to the card you are paying down, or the table will drift from reality.
- Record each extra payment in your tracker so the amount you actually paid matches the plan.
- Reorder the rows if a new debt appears or a balance changes the order.
A statement import into SpendixAI can show your card and EMI debits month by month, which helps confirm that the amounts you planned really left your accounts.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


