Instant digital downloadExcel and Google SheetsSecure card checkout

Debt payoff

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.

C$12CAD

Secure checkout. Sales tax, VAT or GST is added at card checkout where it applies.

  • Instant download, nothing shipped
  • Excel 2016+ and Google Sheets
  • Filled-in sample file included
  • Damaged or not as described? Fixed or refunded within 60 days

Prefer Etsy? Buy this template in our Etsy shop.

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

  • XLSXHousehold-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)
  • PDFQuick-start guide (PDF)

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.

You might also like

More in Personal Finance