Debt Snowball Avalanche Planner

Description

See your debt-free date. Enter up to 10 debts, choose Snowball (smallest balance first) or Avalanche (highest interest first) from one dropdown, and the planner builds your month-by-month payoff plan. It calculates both methods side by side, so you can see how much interest Avalanche saves and how much sooner Snowball gives you your first win.

━━━━━━━━━━━━━━━━━━
WHAT’S INCLUDED
━━━━━━━━━━━━━━━━━━
1 spreadsheet file (.xlsx) with:

• Start Here: setup guide, tips and how the math works
• Debts & Plan: your debts (balance, APR, minimum), extra monthly payment, start month and the method switch. Shows your debt-free date, payoff order, each debt’s payoff date and interest, and a Snowball vs Avalanche comparison. A minimum payment that doesn’t cover the interest is flagged
• Payoff Schedule: every month’s total payment, interest, principal and remaining balance, plus each debt’s balance until it shows PAID ✓ (up to 30 years)
• Dashboard: debt-free date, overall % paid, a progress bar for each debt, and charts of projected balance (Snowball vs Avalanche) and starting vs latest balance
• Progress Log: record your actual payments and statement balances to track real progress against the plan

Example debts are shaded yellow so you can see how it works. Replace them with your own.

━━━━━━━━━━━━━━━━━━
HOW TO USE IT
━━━━━━━━━━━━━━━━━━
Google Sheets (free): Upload the .xlsx to Google Drive, open it with Google Sheets, then File > Save as Google Sheets. The method dropdown, formulas and charts carry over (chart styling may differ slightly).
Excel: Open the file directly. Works in Excel 2019, 2021 and Microsoft 365, and in LibreOffice Calc. No macros.

1. Enter each debt’s balance, APR and minimum payment
2. Add any extra amount you can pay each month and your first payment month
3. Pick Snowball or Avalanche, then follow your plan and log your progress

━━━━━━━━━━━━━━━━━━
GOOD TO KNOW
━━━━━━━━━━━━━━━━━━
• Interest is estimated monthly (balance × APR ÷ 12). Lenders may calculate it daily or add fees, so real numbers will differ slightly. This is a planning tool, not financial advice.
• Not tested in Apple Numbers.
• For personal use. Please don’t resell or redistribute the file.

━━━━━━━━━━━━━━━━━━
This is a digital download. No physical item will be shipped. Your download link appears right after checkout and is emailed to you. You can also find it anytime under My Account > Downloads. Colours may look slightly different on screen vs. print.

AI disclosure: This product was created with the help of AI tools, which were used to assist with drafting the content, building the formulas and layout, and generating the preview images from the actual files. The files were then reviewed and tested before listing.