Home & budget

Debt Payoff Tracker 2027

Enter up to 10 debts with balance, rate and minimum payment, pick snowball or avalanche and the extra you can pay each month. The file works out the payoff order, when you'll be debt-free, the interest you'll pay and a month-by-month schedule.

File in EnglishNo macrosExcel · Google Sheets4 linked sheets

Buy on Etsy See the screenshots

Price, checkout and download happen on Etsy.

Debt Payoff: your debts, the method and the two plans side by side (Example data) — Debt Payoff: your debts, the method and the two plans side by side · Example data · Enlarge image

Real screenshots of the file

Images of the file with example data. Tap an image to enlarge it.

Payoff schedule: what each debt is paid every month, balance left and money passed on (Example data) — Payoff schedule: what each debt is paid every month, balance left and money passed on

What's inside

Linked sheets, with instructions on the first sheet.

InstructionsHow to fill in the file, step by step.

SettingsYear and currency symbol.

Debt PayoffUp to 10 debts, snowball or avalanche, extra payment, months until debt-free and total interest, both methods side by side.

Payoff scheduleMonth by month for every debt: paid, balance left and money passed on to the next debt.

Demo data

A worked example

In the example two debts are listed, a credit card (3,200 at 22.9%) and a car loan (9,800 at 6.9%), with an extra 100 per month.

Example data in the file, there to overwrite. A simplified estimate: fixed rate, fixed payments, no new charges.

Debt Payoff Tracker 2027
Months until debt-free, your plan	34
Months with minimum payments only	55
Total interest, your plan	1,837.19
Total interest, minimum payments only	3,342.06
You save	1,504.87

Getting started

Settings: check the year and your currency symbol.
Debt Payoff: enter your debts, choose Snowball or Avalanche and the extra amount per month.
Read months until debt-free and total interest: the payoff schedule updates by itself.

Compatibility and limits

Compatibility

Plain .xlsx file, no macros, standard functions only.
Tested by full recalculation in Excel for Microsoft 365.
Calculations also checked in Google Sheets (upload the file to Google Drive).
Not tested in Apple Numbers or Excel for Mac.

Good to know

A simplified estimate: fixed interest rate, fixed payments and no new charges.
Entries are typed in; there is no bank connection.
This template helps you organise your money; it is not financial advice.

Questions

Snowball or avalanche?

The file calculates both and shows months until debt-free and total interest side by side. Avalanche (highest rate first) usually costs less interest; snowball (smallest balance first) clears single debts sooner.

Is this part of the Budget Planner 2027?

Yes: it is the debt payoff part of it, sold on its own. The full Budget Planner 2027 also has the monthly budget, transactions, savings goals and bills.

Will anything be posted to me?

No. It's a digital file you download from Etsy straight after purchase.