Debt Snowball & Avalanche Calculator – Debt Payoff Tracker, Sheets & Excel
See which payoff method gets you debt-free faster, then track every payment.
List your debts once. The dashboard runs both methods so you can see months to debt-free, total interest and the debt-free date for each.
What's included (debt-snowball-avalanche-tracker.zip: debt-snowball-avalanche-tracker.xlsx + start-here-debt-snowball-avalanche.pdf)
- Debt Payoff: up to 15 debts (balance, APR, minimum), your extra monthly payment, and a chosen-method dropdown. The debt to pay first turns green. Months to debt-free and total interest for your plan, with a chart.
- Dashboard: Snowball vs. Avalanche side by side, with months to debt-free, total interest, debt-free date, first debt to attack, and how much Avalanche saves. Also your chosen method, starting debt, total paid and payments logged, paid % per debt, and a "Snowball vs Avalanche" total balance line chart (60 months).
- Schedule, Snowball Schedule, Avalanche Schedule: month-by-month simulations for up to 360 months (30 years), where paid-off debts roll into the next one
- Payment Log (up to 999 rows): date, a debt dropdown from your list, amount paid, note
- Instructions tab + 1-page Start Here PDF. Estimates only, not financial advice. Fictional DEMO rows (yellow) show how it works. Delete them to start.
How it works
- Open the .xlsx in Excel or save it as a Google Sheet.
- List your debts and your extra monthly payment.
- Compare the two methods on the Dashboard and pick one.
- Log each payment and watch the paid % per debt.
Compatibility: Google Sheets and Microsoft Excel. In Google Sheets, upload the .xlsx to Drive, then choose File > Save as Google Sheets. No macros, scripts or add-ons. Your copy stays private to you.
Who it's for: anyone paying off credit cards, loans or medical debt who wants to choose a method and stay on track.
FAQ
- How is this different from the Monthly Budget & Debt Payoff Planner ($9)? That planner is a full budget (categories, transactions, monthly dashboard, savings goals) with a debt planner that runs one method at a time. This $5 tracker does debt only, but goes deeper: both methods side by side with the interest difference and debt-free dates, a comparison chart and a payment log. If you already own the planner, you only need this for the comparison and payment tracking.
- Is it financial advice? No. The results are estimates from the numbers you enter; real interest may differ.
- Is it a subscription? No. You pay once.
- Questions? hirelinetemplates@mail.grokbot.com
Cross-sell: Need a full budget too? See the Monthly Budget & Debt Payoff Planner ($9, https://payhip.com/b/Is04a) or the Personal Finance Bundle ($22, https://payhip.com/b/jhoZ7). Track the result with the Net Worth Tracker ($5, https://payhip.com/b/lFIib).