Debt Payoff Tracker Spreadsheet

Type in your debts once: name, balance, interest rate, minimum payment. Add whatever extra you can find each month. The sheet does the rest.

It builds a full month by month schedule for both the snowball method and the avalanche method, up to ten debts and thirty years ahead, and puts them next to each other: how many months, how much interest, which one wins and by how much.

Every formula was tested against an independent simulation before this went on sale, including the awkward cases — equal balances, a zero percent debt, minimum payments too small to cover the interest. It warns you about that last one.

1. Type every debt in My debts: name, balance, interest rate and minimum payment.
2. Set the extra amount you can pay on top of the minimums each month.
3. Open Summary: snowball and avalanche side by side, and which one wins.
4. Follow the month-by-month plan and log what you paid. Color in the printables.

• Debt_Payoff_Tracker.xlsx for Excel or Google Sheets, no macros
• Snowball plan and avalanche plan, month by month, up to 360 months
• Summary tab: months, total interest, total paid, and the difference
• Milestones tab: the month each individual debt disappears
• Balance chart, payment log and a My debts input tab
• 9 printable sheets in A4 and US Letter, two PDFs
• Visual trackers, debt thermometer, monthly check in, dividers

• Works in Microsoft Excel, and in Google Sheets by uploading the file
• No macros and nothing to enable. Yellow cells are the ones you type in
• Up to ten debts. Leave rows empty if you have fewer
• Undated printables in A4 and US Letter, print at home
• A calculator and a set of worksheets, not financial advice