Free Excel templates

A free debt snowball vs avalanche calculator in Excel

Five debts paid off three ways: minimums only, the avalanche (highest rate first) and the snowball (smallest balance first), month by month, plus the cost of building a starter emergency fund first and a sheet for your own debt.

Five debts total 13,930. Paying minimums only takes 258 months and 10,886 of interest. With 250 a month extra, the avalanche clears them in 30 months for 2,033 of interest; the snowball takes 31 months and costs 224 more.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Debt_Snowball_vs_Avalanche_Calculator.xlsx (269 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with Personal Finance for Beginners, which explains the method behind it, chapter by chapter.

Get the book on Amazon →

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

6 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Your Debts
The five debts, and your surplus. Change any of it.
Minimums Only
What happens if you never pay more than required (the engine is sheet 2a)
Avalanche vs Snowball
The two methods, month by month, side by side
The Emergency Fund
What a starter fund costs, and what it buys (the engine is sheet 4a)
Your Own Debt
One debt, your figures, three questions answered
Checks
Every figure in Appendix G, recomputed and compared, and the identities the model must keep

What the worked case returns

MeasureValue
Total owed13,930
Card A: first minimum payment81.53
...of which interest61.07
Minimums only: months to clear258
Minimums only: total interest10,886
Avalanche: months to clear30
Avalanche: total interest2,033
Snowball: months to clear31
Snowball: total interest2,257
Starter emergency fund: extra interest348

The snowball costs about 7.5 a month over the plan. If paying off the smallest debt first is what keeps you going, that is a small price for a plan you finish.

How to use it on your own case

  1. Enter each debt's balance, rate and minimum payment on Your Debts, and the extra you can pay each month.
  2. Read Minimums Only to see how long the debts last without extra payments.
  3. Compare the avalanche and the snowball on Avalanche vs Snowball.
  4. Test a starter emergency fund on The Emergency Fund, then run one debt on Your Own Debt.

Questions people ask about it

Which is better, the debt snowball or the debt avalanche?

The avalanche, paying the highest rate first, costs less interest. The snowball, smallest balance first, clears debts sooner one by one. The file shows the difference in money and months.

Why does paying the minimum take so long?

Because most of a minimum payment on a high-rate card is interest. Only a small part reduces the balance each month.

Should I build an emergency fund before paying off debt?

A small starter fund costs some extra interest, but it avoids new borrowing when something goes wrong. The file prices that cost.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of Personal Finance for Beginners go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with Personal Finance for Beginners. The book is on Amazon.

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.