Debt Payoff Planner Excel with both payoff methods side by side — snowball and avalanche — plus a full debt list, payment log, progress tracker, and dashboard. Know the date each debt dies, what the interest is really…
About this template
Debt Payoff Planner Excel with both payoff methods side by side — snowball and avalanche — plus a full debt list, payment log, progress tracker, and dashboard. Know the date each debt dies, what the interest is really costing, and which method gets you out cheaper. Built for anyone carrying several balances at once — cards, loans, medical bills, buy-now-pay-later plans — who wants one honest plan instead of ten statements. If a minimum payment barely covers the interest, this workbook shows it in the first minute.
$49
Excel & Google Sheets template — instant download on Etsy
Debt List — every debt with its balance, APR, minimum payment, and any extra you pay. Total payment, monthly interest, months to payoff, and the payoff date fill in by formula.
Payoff Plan — the same debts in snowball order (smallest balance first) and avalanche order (highest APR first), each row pulled from the Debt List by formula, with first-win timing for each method and a simulated rollover comparison computed from the same example data.
Payment Log — every payment: date, debt, amount paid, interest portion from your statement, principal by formula, and the statement balance after the payment.
Payoff Progress — starting balance on October 1 vs current balance per debt, amount paid off, percent paid, monthly payment, payoff date, and status.
Dashboard — total debt, number of debts, total minimums, extra paid monthly, total monthly payment, interest accruing per month, weighted average APR, highest-APR debt, smallest-balance debt, paid-off progress, logged payments, balance by type, and balance by debt.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Debt Payoff Planner (Snowball and Avalanche)
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Debt Payoff Planner (Snowball and Avalanche) track?
The Debt Payoff Planner (Snowball and Avalanche) tracks Debt List; Payoff Plan; Payment Log; Payoff Progress; Dashboard.
What do the example numbers show?
The included example shows: Payment Log — every payment: date, debt, amount paid, interest portion from your statement, principal by formula, and the statement balance after the payment.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.