FormulaLab

Debt snowball spreadsheet: how it works and when you'll be debt-free

The debt snowball is simple: pay the minimum on every debt, and put every extra dollar toward the smallest balance. When it's paid off, roll that payment into the next one.

Snowball vs. avalanche

The avalanche method targets the highest interest rate first and saves the most money. The snowball targets the smallest balance first and gives you quick wins. The best method is the one you'll stick with.

How to calculate months to payoff

In Google Sheets or Excel, =NPER(rate/12, -payment, balance) gives the number of months to pay off a debt at a fixed payment.

Track it monthly

Update balances once a month. Watching the payoff date move closer is what keeps people going.

Our Family Budget Planner includes a debt payoff sheet that shows months to payoff, total interest and the snowball order for every debt.

Want to skip the setup?
See the Family Budget Planner ($5.99)