Stratos-Tools
|

Vancouver High-Ratio Mortgage Calculator — Below the $1M CMHC Cutoff

In Canada, CMHC mortgage insurance is only available on homes purchased for less than $1,000,000. For a property priced at $999,999—the highest price eligible for an insured mortgage—the blended minimum down payment is 7.5%: 5% on the first $500,000 ($25,000) and 10% on the remaining $499,999 ($49,999), totalling $74,999. This calculator pre-loads that exact scenario so Vancouver buyers can see the precise insured payment, total interest, and amortization schedule at current rates. The CMHC insurance premium on this loan is 3.10% of the insured amount, typically added to the mortgage balance.

Expert tip: Crossing the $1,000,000 purchase price threshold means losing access to CMHC insurance entirely—requiring a full 20% down payment ($200,000+) rather than the 7.5% blended minimum ($75,000). For buyers near the cutoff, negotiating a purchase price of $999,999 instead of $1,000,001 can be the difference between qualifying with $75,000 down versus needing $200,000. Run both scenarios in this calculator to quantify the exact monthly and lifetime cost difference.

Mortgage Optimizer

Monthly (US) or semi-annual (CA) compounding · Prepayment analysis · Opportunity cost comparison

Mortgage Details

Region

Semi-annual compounding (Interest Act, R.S.C. 1985)

Mode

Down Payment

Principal Loan Amount

$924,999

Amortization

Payment Frequency

Mortgage Start Date

Required to anchor calendar-relative prepayments.

Prepayment Power

Reduce your balance faster and save on interest.

Prepayment Builder

Investment Comparison

Compare prepayments against investing the same amount in the market.

Payment Summary

Monthly Payment

$2,418.33

Bi-Weekly: $1,114.82 · Weekly: $557.12

Total Interest

$325,500

Total Cost

$725,500

Payoff Date

April 2051

1st Payment: Interest

73.6%

Amortization Chart

Amortization Schedule

#YrMonthly PaymentInterestPrincipalBalance
11$2,418.33$1,780.08$638.25$399,361.75
21$2,418.33$1,777.24$641.09$398,720.65
31$2,418.33$1,774.38$643.95$398,076.70
41$2,418.33$1,771.52$646.81$397,429.89
51$2,418.33$1,768.64$649.69$396,780.20
61$2,418.33$1,765.75$652.58$396,127.61
71$2,418.33$1,762.84$655.49$395,472.13
81$2,418.33$1,759.93$658.40$394,813.72
91$2,418.33$1,757.00$661.33$394,152.39
101$2,418.33$1,754.05$664.28$393,488.11
111$2,418.33$1,751.10$667.23$392,820.88
121$2,418.33$1,748.13$670.20$392,150.68
132$2,418.33$1,745.15$673.19$391,477.49
142$2,418.33$1,742.15$676.18$390,801.31
152$2,418.33$1,739.14$679.19$390,122.12
162$2,418.33$1,736.12$682.21$389,439.91
172$2,418.33$1,733.08$685.25$388,754.66
182$2,418.33$1,730.03$688.30$388,066.36
192$2,418.33$1,726.97$691.36$387,375.00
202$2,418.33$1,723.89$694.44$386,680.56
212$2,418.33$1,720.80$697.53$385,983.03
222$2,418.33$1,717.70$700.63$385,282.40
232$2,418.33$1,714.58$703.75$384,578.65
242$2,418.33$1,711.45$706.88$383,871.77
253$2,418.33$1,708.30$710.03$383,161.74
263$2,418.33$1,705.14$713.19$382,448.55
273$2,418.33$1,701.97$716.36$381,732.19
283$2,418.33$1,698.78$719.55$381,012.64
293$2,418.33$1,695.58$722.75$380,289.89
303$2,418.33$1,692.36$725.97$379,563.92
313$2,418.33$1,689.13$729.20$378,834.72
323$2,418.33$1,685.89$732.44$378,102.28
333$2,418.33$1,682.63$735.70$377,366.57
343$2,418.33$1,679.35$738.98$376,627.59
353$2,418.33$1,676.07$742.27$375,885.33
363$2,418.33$1,672.76$745.57$375,139.76
374$2,418.33$1,669.44$748.89$374,390.87
384$2,418.33$1,666.11$752.22$373,638.65
394$2,418.33$1,662.76$755.57$372,883.08
404$2,418.33$1,659.40$758.93$372,124.15
414$2,418.33$1,656.02$762.31$371,361.85
424$2,418.33$1,652.63$765.70$370,596.15
434$2,418.33$1,649.22$769.11$369,827.04
444$2,418.33$1,645.80$772.53$369,054.51
454$2,418.33$1,642.36$775.97$368,278.54
464$2,418.33$1,638.91$779.42$367,499.12
474$2,418.33$1,635.44$782.89$366,716.23
484$2,418.33$1,631.96$786.37$365,929.86
495$2,418.33$1,628.46$789.87$365,139.98
505$2,418.33$1,624.94$793.39$364,346.60
515$2,418.33$1,621.41$796.92$363,549.68
525$2,418.33$1,617.87$800.47$362,749.21
535$2,418.33$1,614.30$804.03$361,945.18
545$2,418.33$1,610.73$807.61$361,137.58
555$2,418.33$1,607.13$811.20$360,326.38
565$2,418.33$1,603.52$814.81$359,511.57
575$2,418.33$1,599.90$818.44$358,693.13
585$2,418.33$1,596.25$822.08$357,871.06
595$2,418.33$1,592.60$825.74$357,045.32
605$2,418.33$1,588.92$829.41$356,215.91
616$2,418.33$1,585.23$833.10$355,382.81
626$2,418.33$1,581.52$836.81$354,546.00
636$2,418.33$1,577.80$840.53$353,705.46
646$2,418.33$1,574.06$844.27$352,861.19
656$2,418.33$1,570.30$848.03$352,013.16
666$2,418.33$1,566.53$851.81$351,161.35
676$2,418.33$1,562.74$855.60$350,305.76
686$2,418.33$1,558.93$859.40$349,446.35
696$2,418.33$1,555.10$863.23$348,583.13
706$2,418.33$1,551.26$867.07$347,716.06
716$2,418.33$1,547.40$870.93$346,845.13
726$2,418.33$1,543.53$874.80$345,970.32
737$2,418.33$1,539.64$878.70$345,091.63
747$2,418.33$1,535.72$882.61$344,209.02
757$2,418.33$1,531.80$886.54$343,322.49
767$2,418.33$1,527.85$890.48$342,432.00
777$2,418.33$1,523.89$894.44$341,537.56
787$2,418.33$1,519.91$898.42$340,639.14
797$2,418.33$1,515.91$902.42$339,736.72
807$2,418.33$1,511.89$906.44$338,830.28
817$2,418.33$1,507.86$910.47$337,919.81
827$2,418.33$1,503.81$914.52$337,005.28
837$2,418.33$1,499.74$918.59$336,086.69
847$2,418.33$1,495.65$922.68$335,164.01
858$2,418.33$1,491.55$926.79$334,237.22
868$2,418.33$1,487.42$930.91$333,306.31
878$2,418.33$1,483.28$935.05$332,371.26
888$2,418.33$1,479.12$939.22$331,432.04
898$2,418.33$1,474.94$943.40$330,488.65
908$2,418.33$1,470.74$947.59$329,541.05
918$2,418.33$1,466.52$951.81$328,589.24
928$2,418.33$1,462.29$956.05$327,633.20
938$2,418.33$1,458.03$960.30$326,672.90
948$2,418.33$1,453.76$964.57$325,708.32
958$2,418.33$1,449.47$968.87$324,739.45
968$2,418.33$1,445.15$973.18$323,766.28
979$2,418.33$1,440.82$977.51$322,788.77
989$2,418.33$1,436.47$981.86$321,806.91
999$2,418.33$1,432.10$986.23$320,820.68
1009$2,418.33$1,427.71$990.62$319,830.06
1019$2,418.33$1,423.31$995.03$318,835.04
1029$2,418.33$1,418.88$999.45$317,835.58
1039$2,418.33$1,414.43$1,003.90$316,831.68
1049$2,418.33$1,409.96$1,008.37$315,823.31
1059$2,418.33$1,405.48$1,012.86$314,810.45
1069$2,418.33$1,400.97$1,017.36$313,793.09
1079$2,418.33$1,396.44$1,021.89$312,771.20
1089$2,418.33$1,391.89$1,026.44$311,744.76
10910$2,418.33$1,387.32$1,031.01$310,713.75
11010$2,418.33$1,382.74$1,035.60$309,678.15
11110$2,418.33$1,378.13$1,040.20$308,637.95
11210$2,418.33$1,373.50$1,044.83$307,593.12
11310$2,418.33$1,368.85$1,049.48$306,543.63
11410$2,418.33$1,364.18$1,054.15$305,489.48
11510$2,418.33$1,359.49$1,058.84$304,430.64
11610$2,418.33$1,354.78$1,063.56$303,367.08
11710$2,418.33$1,350.04$1,068.29$302,298.79
11810$2,418.33$1,345.29$1,073.04$301,225.75
11910$2,418.33$1,340.51$1,077.82$300,147.93
12010$2,418.33$1,335.72$1,082.62$299,065.31
12111$2,418.33$1,330.90$1,087.43$297,977.88
12211$2,418.33$1,326.06$1,092.27$296,885.60
12311$2,418.33$1,321.20$1,097.13$295,788.47
12411$2,418.33$1,316.32$1,102.02$294,686.46
12511$2,418.33$1,311.41$1,106.92$293,579.54
12611$2,418.33$1,306.49$1,111.85$292,467.69
12711$2,418.33$1,301.54$1,116.79$291,350.90
12811$2,418.33$1,296.57$1,121.76$290,229.13
12911$2,418.33$1,291.58$1,126.76$289,102.37
13011$2,418.33$1,286.56$1,131.77$287,970.60
13111$2,418.33$1,281.53$1,136.81$286,833.80
13211$2,418.33$1,276.47$1,141.87$285,691.93
13312$2,418.33$1,271.38$1,146.95$284,544.98
13412$2,418.33$1,266.28$1,152.05$283,392.93
13512$2,418.33$1,261.15$1,157.18$282,235.75
13612$2,418.33$1,256.00$1,162.33$281,073.43
13712$2,418.33$1,250.83$1,167.50$279,905.93
13812$2,418.33$1,245.64$1,172.70$278,733.23
13912$2,418.33$1,240.42$1,177.92$277,555.31
14012$2,418.33$1,235.18$1,183.16$276,372.16
14112$2,418.33$1,229.91$1,188.42$275,183.73
14212$2,418.33$1,224.62$1,193.71$273,990.02
14312$2,418.33$1,219.31$1,199.02$272,791.00
14412$2,418.33$1,213.97$1,204.36$271,586.64
14513$2,418.33$1,208.61$1,209.72$270,376.92
14613$2,418.33$1,203.23$1,215.10$269,161.82
14713$2,418.33$1,197.82$1,220.51$267,941.31
14813$2,418.33$1,192.39$1,225.94$266,715.37
14913$2,418.33$1,186.94$1,231.40$265,483.97
15013$2,418.33$1,181.46$1,236.88$264,247.10
15113$2,418.33$1,175.95$1,242.38$263,004.71
15213$2,418.33$1,170.42$1,247.91$261,756.80
15313$2,418.33$1,164.87$1,253.46$260,503.34
15413$2,418.33$1,159.29$1,259.04$259,244.30
15513$2,418.33$1,153.69$1,264.64$257,979.65
15613$2,418.33$1,148.06$1,270.27$256,709.38
15714$2,418.33$1,142.41$1,275.93$255,433.46
15814$2,418.33$1,136.73$1,281.60$254,151.85
15914$2,418.33$1,131.03$1,287.31$252,864.55
16014$2,418.33$1,125.30$1,293.04$251,571.51
16114$2,418.33$1,119.54$1,298.79$250,272.72
16214$2,418.33$1,113.76$1,304.57$248,968.15
16314$2,418.33$1,107.96$1,310.38$247,657.77
16414$2,418.33$1,102.13$1,316.21$246,341.57
16514$2,418.33$1,096.27$1,322.06$245,019.50
16614$2,418.33$1,090.38$1,327.95$243,691.56
16714$2,418.33$1,084.47$1,333.86$242,357.70
16814$2,418.33$1,078.54$1,339.79$241,017.90
16915$2,418.33$1,072.58$1,345.76$239,672.15
17015$2,418.33$1,066.59$1,351.74$238,320.40
17115$2,418.33$1,060.57$1,357.76$236,962.64
17215$2,418.33$1,054.53$1,363.80$235,598.84
17315$2,418.33$1,048.46$1,369.87$234,228.97
17415$2,418.33$1,042.36$1,375.97$232,853.00
17515$2,418.33$1,036.24$1,382.09$231,470.91
17615$2,418.33$1,030.09$1,388.24$230,082.67
17715$2,418.33$1,023.91$1,394.42$228,688.25
17815$2,418.33$1,017.71$1,400.62$227,287.63
17915$2,418.33$1,011.47$1,406.86$225,880.77
18015$2,418.33$1,005.21$1,413.12$224,467.65
18116$2,418.33$998.92$1,419.41$223,048.24
18216$2,418.33$992.61$1,425.72$221,622.52
18316$2,418.33$986.26$1,432.07$220,190.45
18416$2,418.33$979.89$1,438.44$218,752.01
18516$2,418.33$973.49$1,444.84$217,307.16
18616$2,418.33$967.06$1,451.27$215,855.89
18716$2,418.33$960.60$1,457.73$214,398.16
18816$2,418.33$954.11$1,464.22$212,933.94
18916$2,418.33$947.60$1,470.73$211,463.21
19016$2,418.33$941.05$1,477.28$209,985.93
19116$2,418.33$934.48$1,483.85$208,502.07
19216$2,418.33$927.87$1,490.46$207,011.61
19317$2,418.33$921.24$1,497.09$205,514.52
19417$2,418.33$914.58$1,503.75$204,010.77
19517$2,418.33$907.89$1,510.44$202,500.33
19617$2,418.33$901.17$1,517.17$200,983.16
19717$2,418.33$894.41$1,523.92$199,459.24
19817$2,418.33$887.63$1,530.70$197,928.54
19917$2,418.33$880.82$1,537.51$196,391.03
20017$2,418.33$873.98$1,544.35$194,846.68
20117$2,418.33$867.11$1,551.23$193,295.45
20217$2,418.33$860.20$1,558.13$191,737.32
20317$2,418.33$853.27$1,565.06$190,172.26
20417$2,418.33$846.30$1,572.03$188,600.23
20518$2,418.33$839.31$1,579.02$187,021.20
20618$2,418.33$832.28$1,586.05$185,435.15
20718$2,418.33$825.22$1,593.11$183,842.04
20818$2,418.33$818.13$1,600.20$182,241.84
20918$2,418.33$811.01$1,607.32$180,634.52
21018$2,418.33$803.86$1,614.47$179,020.05
21118$2,418.33$796.67$1,621.66$177,398.39
21218$2,418.33$789.46$1,628.87$175,769.52
21318$2,418.33$782.21$1,636.12$174,133.39
21418$2,418.33$774.93$1,643.40$172,489.99
21518$2,418.33$767.61$1,650.72$170,839.27
21618$2,418.33$760.27$1,658.06$169,181.21
21719$2,418.33$752.89$1,665.44$167,515.76
21819$2,418.33$745.48$1,672.85$165,842.91
21919$2,418.33$738.03$1,680.30$164,162.61
22019$2,418.33$730.56$1,687.78$162,474.83
22119$2,418.33$723.04$1,695.29$160,779.55
22219$2,418.33$715.50$1,702.83$159,076.71
22319$2,418.33$707.92$1,710.41$157,366.30
22419$2,418.33$700.31$1,718.02$155,648.28
22519$2,418.33$692.67$1,725.67$153,922.62
22619$2,418.33$684.99$1,733.35$152,189.27
22719$2,418.33$677.27$1,741.06$150,448.21
22819$2,418.33$669.52$1,748.81$148,699.40
22920$2,418.33$661.74$1,756.59$146,942.81
23020$2,418.33$653.92$1,764.41$145,178.40
23120$2,418.33$646.07$1,772.26$143,406.14
23220$2,418.33$638.19$1,780.15$141,625.99
23320$2,418.33$630.26$1,788.07$139,837.92
23420$2,418.33$622.31$1,796.03$138,041.90
23520$2,418.33$614.31$1,804.02$136,237.88
23620$2,418.33$606.29$1,812.05$134,425.83
23720$2,418.33$598.22$1,820.11$132,605.72
23820$2,418.33$590.12$1,828.21$130,777.51
23920$2,418.33$581.99$1,836.35$128,941.16
24020$2,418.33$573.81$1,844.52$127,096.64
24121$2,418.33$565.60$1,852.73$125,243.92
24221$2,418.33$557.36$1,860.97$123,382.94
24321$2,418.33$549.08$1,869.25$121,513.69
24421$2,418.33$540.76$1,877.57$119,636.12
24521$2,418.33$532.40$1,885.93$117,750.19
24621$2,418.33$524.01$1,894.32$115,855.87
24721$2,418.33$515.58$1,902.75$113,953.12
24821$2,418.33$507.11$1,911.22$112,041.90
24921$2,418.33$498.61$1,919.72$110,122.18
25021$2,418.33$490.07$1,928.27$108,193.91
25121$2,418.33$481.48$1,936.85$106,257.06
25221$2,418.33$472.86$1,945.47$104,311.59
25322$2,418.33$464.21$1,954.13$102,357.47
25422$2,418.33$455.51$1,962.82$100,394.65
25522$2,418.33$446.78$1,971.56$98,423.09
25622$2,418.33$438.00$1,980.33$96,442.76
25722$2,418.33$429.19$1,989.14$94,453.62
25822$2,418.33$420.34$1,998.00$92,455.62
25922$2,418.33$411.45$2,006.89$90,448.73
26022$2,418.33$402.51$2,015.82$88,432.92
26122$2,418.33$393.54$2,024.79$86,408.13
26222$2,418.33$384.53$2,033.80$84,374.33
26322$2,418.33$375.48$2,042.85$82,331.48
26422$2,418.33$366.39$2,051.94$80,279.54
26523$2,418.33$357.26$2,061.07$78,218.46
26623$2,418.33$348.09$2,070.24$76,148.22
26723$2,418.33$338.87$2,079.46$74,068.76
26823$2,418.33$329.62$2,088.71$71,980.05
26923$2,418.33$320.33$2,098.01$69,882.04
27023$2,418.33$310.99$2,107.34$67,774.70
27123$2,418.33$301.61$2,116.72$65,657.98
27223$2,418.33$292.19$2,126.14$63,531.84
27323$2,418.33$282.73$2,135.60$61,396.23
27423$2,418.33$273.23$2,145.11$59,251.13
27523$2,418.33$263.68$2,154.65$57,096.47
27623$2,418.33$254.09$2,164.24$54,932.23
27724$2,418.33$244.46$2,173.87$52,758.36
27824$2,418.33$234.78$2,183.55$50,574.81
27924$2,418.33$225.07$2,193.26$48,381.55
28024$2,418.33$215.31$2,203.02$46,178.52
28124$2,418.33$205.50$2,212.83$43,965.69
28224$2,418.33$195.66$2,222.68$41,743.02
28324$2,418.33$185.76$2,232.57$39,510.45
28424$2,418.33$175.83$2,242.50$37,267.95
28524$2,418.33$165.85$2,252.48$35,015.46
28624$2,418.33$155.83$2,262.51$32,752.96
28724$2,418.33$145.76$2,272.58$30,480.38
28824$2,418.33$135.64$2,282.69$28,197.69
28925$2,418.33$125.49$2,292.85$25,904.85
29025$2,418.33$115.28$2,303.05$23,601.80
29125$2,418.33$105.03$2,313.30$21,288.50
29225$2,418.33$94.74$2,323.59$18,964.90
29325$2,418.33$84.40$2,333.93$16,630.97
29425$2,418.33$74.01$2,344.32$14,286.65
29525$2,418.33$63.58$2,354.75$11,931.89
29625$2,418.33$53.10$2,365.23$9,566.66
29725$2,418.33$42.57$2,375.76$7,190.90
29825$2,418.33$32.00$2,386.33$4,804.57
29925$2,418.33$21.38$2,396.95$2,407.62
30025$2,418.33$10.71$2,407.62$0.00
30126$0.00$0.00$0.00$0.00

Understanding Your Mortgage

At its core, a mortgage is a legal agreement and a specific type of loan used to purchase real estate. Because houses are expensive, the lender (usually a bank) provides the upfront cash to buy the home, and you agree to pay back that exact amount, plus interest, over a set number of years (known as the amortization period, typically 25 to 30 years).

The key distinction of a mortgage compared to a standard personal loan is that the property itself acts as collateral. This means if you stop making your agreed-upon payments, the lender has the legal right to take possession of the home (a process known as foreclosure) to recoup their money.

Every monthly payment you make is split into two main parts: the Principal (paying down the actual borrowed amount) and the Interest (the fee the bank charges you to borrow their money). In the first few years of a mortgage, the vast majority of your payment goes strictly toward the bank's interest, which is exactly why using an optimizer tool to map out prepayment strategies is critical for building wealth.