Big purchases · Reference
Home all-in cost worksheet
By Leo HongReviewed 1 min read
Use before any offer; the full rent-vs-buy method is in home in Canada. Keep cash flow separate from unrecoverable costs.
Monthly cash outflow — affordability:
- Full mortgage payment, principal + interest: $________/mo
- Property tax/year ÷ 12: $________/mo
- Home insurance: $________/mo
- Condo fees (if any): $________/mo
- Utilities: $________/mo
- Maintenance reserve (illustrative 1–2% of value/year) ÷ 12: $________/mo
- Owner cash outflow: add the six lines above = $________/mo
- Comparable renter outflow (rent, tenant insurance, utilities): $________/mo
- Renter’s investment difference: owner − renter = $________/mo (negative: the owner has the cash-flow edge).
Costs and equity — a separate view:
- Principal in the mortgage payment: $________/mo. It builds equity but still leaves your account; do not subtract it above.
- Down payment $______; closing cash $______; expected selling costs $______; stay ___ years.
- Rough unrecoverable-cost subtotal: (owner outflow − principal) + (closing + selling costs) ÷ (stay years × 12) + (down payment × assumed after-tax return ÷ 12) = $________/mo. Compare it with the renter outflow above; price growth is left out (the home in Canada calculator adds it).
Test: can you carry the payment at +2% rates and still keep 3–6 months of essentials? If not, keep renting and rerun in 12 months.