Household Debt Planner (Canada)

Debt payoff planner spreadsheet for Canadian households. List every debt once, see what each one really costs, and compare avalanche, snowball and consolidation before you decide.

WHAT IT DOES

• Your debts: up to 18 debts in five groups (credit cards, lines of credit and HELOCs, overdraft, loans, mortgages), with monthly payment and interest, months to pay off, total interest, payoff date and a status flag, colour-coded by interest rate
• Income per payday (every 2 weeks), living costs, what is left over, net worth and what you own
• Payoff plan: add an extra amount each payday and compare as-is, avalanche (highest rate first) and snowball (smallest balance first) month by month with full payment rollover: debt-free date, total interest and interest saved, plus the exact payoff order
• Consolidate: roll your debts into one loan and compare four rate tiers each for a line of credit, a personal loan and a mortgage refinance
• Mortgage consolidation: four lender quotes side by side, with switching cost and prepayment-privilege limits
• Sell and buy: three sale prices by three purchase prices with commission, legal costs, penalties, land transfer tax tiers, down payment, default insurance and cash left over
• Charts: total debt by strategy, what you owe vs what you own, debt by category and consolidation options over time
• Made for Canada: fixed-rate mortgages compound semi-annually and other debts monthly, chosen automatically by debt type

WHAT YOU GET

• Household-Debt-Planner.xlsx, filled with an invented sample household so you can see every tab working. Type your own numbers over the sample ones (blue text on yellow)
• Quick-start guide (PDF)

HOW YOU GET IT

Digital download. After checkout you get a download page right away, plus a receipt by email. Nothing is shipped.

COMPATIBILITY

• Microsoft Excel 2016 or newer (Windows or Mac) and Excel for the web
• Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
• Needs a computer or tablet with a spreadsheet app. This is not an app or a printable planner

PLEASE NOTE

A planning tool, not financial advice. Rates, mortgage penalties, default insurance premiums and land transfer tax vary by lender and province and change over time. The tax tiers and insurance bands are editable sample values, so confirm them with your lender or a qualified professional. For personal and household use; please don't resell or share the file.

DISCLAIMER

This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor, lawyer or certified tradesperson). Check the results before you rely on them.

HOW IT WAS MADE

Designed by VARS Digital with AI-assisted tools. Every formula is checked before release.

QUESTIONS

Email varsdigitals@gmail.com and we'll help you get set up.