Debt Payoff Planner spreadsheet
The snowball and avalanche methods in one spreadsheet you own. Enter your debts once, then watch your balances fall and your debt-free date get closer every month.
Get the planner ($9) Instant download · Excel (.xlsx) · tested in Excel · no macros
What's inside
- Debt list for up to 15 debts: balance, APR, and minimum payment, with totals and weighted average APR.
- Snowball and avalanche schedules: a full 30-year month-by-month plan for each method, with payment rollover handled for you.
- Comparison dashboard: debt-free date, months to freedom, and total interest for both methods, plus how much the avalanche saves.
- Payoff order and dates: when each debt will be gone under each method.
- Payment log: record what you actually pay each month and track your real progress against the plan.
- How-to tab with step-by-step instructions, including how to open it in Google Sheets.
No macros, no add-ons, and no sign-up. It's plain formulas you can inspect and edit.
Who it's for
Anyone with credit cards, store cards, car loans, personal loans, or student loans who wants a clear plan to pay them off, and wants to keep using that plan month after month. If you only need a one-time answer, the free online calculator works fine.
FAQ
Does it work in Google Sheets?
It's made for Microsoft Excel and tested there: we recalculate every formula in Excel and check the results. It uses only standard functions (like SUMIFS, INDEX, and MATCH) that have been in Excel since 2010 and that Google Sheets and LibreOffice also have, with no macros, so you can upload it to Google Drive and open it with Google Sheets. We haven't tested every feature in Google Sheets or LibreOffice yet, though, and some formatting may look different there.
Can I change the extra payment later?
Yes. Change the extra payment amount (or any balance or rate) and every schedule recalculates instantly.
What if it doesn't work for me?
Contact us through the purchase receipt and we'll help, or refund you.