First-Time Home Buyer & Mortgage Closing Cost Planner

Name: First-Time Home Buyer & Mortgage Closing Cost Planner
Brand: MyTaxCalculator.ca
SKU: MTC-FIRST-TIME-HOME-BUYER-MORTGAGE-CLOS
Price: 4.99 CAD
Availability: PreOrder

Model down payments, CMHC insurance, Land Transfer Tax rebates, and every closing cost before making an offer.

$4.99 ~~$15.99~~ CAD

Save 69%

One-time purchase · Instant digital download · Lifetime access

Available soon

Leave your email and we'll send you an instant note the day this template is released.

Stripe secure checkout · Visa, MC, Amex, Apple Pay, Google Pay

Your download includes

MTC_First_Time_Home_Buyer_Mortgage_Planner_Canada_2026.xlsx12 KB
Google Sheets Cloud Copy Setup LinkInstant copy

Instant file access
No monthly subscription
Mac, PC & Mobile
100% Private & Offline

Canadian-Specific

Key Features & Capabilities

Designed specifically around Canadian payroll, tax forms, and account structures:

Down payment roadmap modeling FHSA tax-free withdrawals + RRSP Home Buyers' Plan ($60,000/person limit)
Tiered CMHC / Sagen default mortgage insurance calculator (5%, 10%, 15% down payment tiers)
Itemized Canadian Closing Costs Calculator including legal fees, title insurance, appraisal, and CMHC PST
Provincial & Municipal Land Transfer Tax calculator with First-Time Home Buyer Rebates (Ontario & Toronto)
Canadian Mortgage Stress Test & Affordability checker modeling GDS (max 39%) and TDS (max 44%) ratios
Amortization Simulator comparing Standard Monthly vs Accelerated Bi-Weekly payments and interest saved

Complete Toolkit

What's Inside (8 Components)

Everything you receive immediately upon download:

1 × First-Time Home Buyer & Mortgage Closing Cost Workbook (.xlsx)
1 × Google Sheets Cloud Copy Setup Link
Master Home Purchase & Financing Summary Dashboard
Down Payment Funding Assembly Sheet (FHSA + RRSP HBP + Cash)
Itemized Canadian Closing Costs & Cash-to-Close Calculator
Mortgage Qualifying Stress Test (GDS/TDS) Affordability Analyzer
25-Year and 30-Year Amortization Schedule with Prepayment Accelerator
Canadian Home Buyer Checklist from pre-approval through closing day

Detailed Walkthrough

Navigate Canadian Home Buying With Zero Closing Day Surprises

Buying your first home in Canada is an exciting milestone, but the financial complexity can feel overwhelming. Many prospective buyers budget carefully for their down payment, only to be blindsided by $12,000 to $25,000+ in unexpected closing costs required on closing day—including provincial Land Transfer Tax, municipal taxes, legal disbursements, title insurance, and provincial sales tax on mortgage insurance.

The MTC First-Time Home Buyer & Mortgage Closing Cost Planner models every single dollar from initial offer to moving day so you can negotiate with complete confidence.

🏛️ Canadian Down Payment & Funding Assembly

Model all available down payment sources in one cohesive plan:

First Home Savings Account (FHSA): Tax-free qualifying withdrawals for both you and your partner.
RRSP Home Buyers' Plan (HBP): Models the expanded $60,000 per person withdrawal limit ($120,000 for couples) and the 15-year repayment schedule.
Personal Cash & Family Gifts: Tracks liquid savings to verify you meet the Canadian statutory minimum (5% on the first $500k, 10% on the portion up to $1M).

📋 Itemized Canadian Closing Costs & Rebates

Never get caught short of cash. The sheet itemizes all closing day disbursements:

Land Transfer Tax (LTT): Calculates tiered provincial LTT plus the $4,000 Ontario First-Time Home Buyer Rebate (and Toronto municipal rebate where applicable).
CMHC Mortgage Insurance & PST: Accurately computes default insurance premiums, plus the 8% Ontario/Quebec PST on the insurance premium that must be paid in cash.
Legal & Administrative Fees: Real estate lawyer disbursements, title search, title insurance, appraisal, home inspection, and municipal property tax adjustments.

📊 Mortgage Stress Test (GDS & TDS Ratios)

Test your mortgage approval odds before speaking with a broker or bank. The model tests your household income against the Canadian Mortgage Qualifying Stress Test rate (contract rate + 2.00% or 5.25% floor) to ensure your Gross Debt Service (GDS max 39%) and Total Debt Service (TDS max 44%) ratios pass lender standards.

⏱️ Accelerated Bi-Weekly Amortization Simulator

Discover how much interest you can save over the life of your mortgage. Compare standard monthly payments against Accelerated Bi-Weekly payments—which effectively makes 13 monthly payments each year, shaving up to 3 to 4 years off your amortization and saving tens of thousands in interest!

Target Audience

Who This Template Is For

First-time home buyers in Canada preparing to purchase a condo, townhouse, or detached home

Couples combining FHSA and RRSP Home Buyers' Plan funds ($120,000 combined limit)

Buyers wanting an accurate cash-to-close estimate so closing day has zero financial surprises

Homeowners shopping mortgage offers to compare fixed vs variable rates and accelerated bi-weekly savings

Frequently asked questions

Why do closing costs surprise so many Canadian home buyers?

Most buyers budget for the down payment but overlook Land Transfer Tax, 8% PST on CMHC mortgage insurance (which must be paid in cash in Ontario and Quebec!), legal fees, title insurance, and property tax adjustments. This template itemizes every single cash requirement before you put in an offer.

How does the First-Time Home Buyer Land Transfer Tax rebate work in the sheet?

The template calculates your gross provincial Land Transfer Tax based on progressive tiers, then automatically applies the $4,000 Ontario First-Time Home Buyer rebate (and Toronto municipal rebate if applicable) to give you the exact net cash payable.

Can I model both 25-year and 30-year amortizations?

Yes. Insured mortgages (under 20% down payment) are restricted to 25 years (or 30 years for newly built homes under new Canadian rules), while conventional mortgages (20%+ down) can be amortized over 30 years. You can toggle between both.