Debt Payoff Planner — Snowball & Avalanche Calculator

Debt Payoff Planner - Snowball & Avalanche Calculator

Eliminate your debt faster with this 12-sheet professional Excel workbook that gives you a crystal-clear roadmap to becoming debt-free. Whether you carry credit card debt, student loans, auto loans, or medical bills — this planner does the math for you.

What Makes This Different

• 12 integrated sheets — not just a basic calculator, but a complete debt management system
• Snowball AND Avalanche methods — compare both side by side with an auto-generated recommendation
• Live dashboard with 12 KPIs — total debt, weighted APR, debt-free date, progress tracking — all update automatically
• 60-month amortization schedule — watch every balance shrink month by month
• Scenario Modeler — test 7 different extra payment levels ($0 to $2,000/mo) and a windfall calculator
• Milestone Tracker — 7 progress milestones with celebration ideas built in
• Payment Tracker — log every payment with running totals and percentage paid
• Debt Analysis sheet — breakdown by type, health scores, debt-to-income ratio
• 12 pre-loaded example debts — see it working instantly, then replace with your real data
• Data validation dropdowns — debt types, payment types, status tracking
• Conditional formatting — color-coded APR alerts (red for high interest, green for low)
• Professional branding — dark navy headers, alternating row colors, consistent color scheme

What's Inside

• Dashboard — At-a-glance KPIs: total balance, monthly minimums, weighted APR, interest totals, debt-free dates, payoff progress
• Debt Inventory — Enter all your debts with balance, APR, minimum payment, debt type, creditor. Yellow cells = input fields
• Snowball Plan — Auto-sorted smallest balance first. Months-to-payoff, total interest, debt-free date all calculated
• Avalanche Plan — Auto-sorted highest APR first. Same calculations as Snowball for direct comparison
• Comparison — Side-by-side metrics with interest savings calculation and method recommendation
• Amortization Schedule — 60-month balance tracker for all 12 debts with monthly decrease highlighting
• Payment Tracker — Log each payment with date, type, amount, running total, and percentage of balance paid
• Analysis — Debt breakdown by type (count, total balance, % of portfolio, avg APR), plus 4 health metrics
• Scenario Modeler — 7 payment scenarios plus windfall impact calculator (bonus, tax refund, etc.)
• Milestones — 7 tracked milestones from "first debt paid" to "ALL DEBTS ELIMINATED!" with celebration ideas
• How to Use — Complete walkthrough guide with pro tips
• Changelog — Version history documenting all updates

Who It's For

• Anyone carrying credit card debt, student loans, personal loans, auto loans, or medical bills
• People who want a clear, structured plan to become debt-free
• Couples managing household finances together
• Financial coaches and advisors looking for a client-ready tool

Technical Details

• Compatible with Excel, Google Sheets, LibreOffice Calc
• XLSX format — no special software or add-ons needed
• All formulas included — just enter your data and watch it calculate
• 12 pre-loaded example debts so you can see it working immediately
• Data validation dropdowns prevent input errors
• Conditional formatting highlights high-interest debts in red

Recent Updates

• v2.0 (Apr 2026): Complete overhaul — expanded from 7 to 12 sheets, added live KPI Dashboard, Scenario Modeler with 7 payment levels, Milestone Tracker with celebration ideas, Payment Tracker with running totals, Debt Analysis sheet with health scores, data validation dropdowns, conditional formatting for APR alerts, professional dark navy branding, and windfall impact calculator
• v1.1 (Mar 2026): Added Method Comparison sheet
• v1.0 (Feb 2026): Initial release

No more guessing which debt to pay first. No more wondering how long it'll take. Enter your debts once, and this planner gives you a complete debt-free roadmap with both Snowball and Avalanche strategies.