Advertisement

Home mortgage calculator

Build a home purchase mortgage and a payment-by-payment ownership budget.

Calculator

Mortgage including financed premium
$480,000.00
Down payment percentage
20.0000%
Regular principal and interest
$2,791.70
First payment plus carrying costs
$3,291.70
Total mortgage interest
$320,760.91
Modelled monthly PMI total
$0.00
Down payment plus lifetime payments and carrying costs
$1,031,160.91
Mortgage payoff date
2049-10-01
Modelled PMI stop date
Not charged
Number of mortgage payments
276
Payment and ownership budget
PaymentDue dateDebt payment ($)Other costs ($)PMI ($)Total ($)Balance ($)
1.002026-11-012,891.70400.000.003,291.70479,087.78
2.002026-12-012,891.70400.000.003,291.70478,171.79
3.002027-01-012,891.70400.000.003,291.70477,252.03
4.002027-02-012,891.70400.000.003,291.70476,328.47
5.002027-03-012,891.70400.000.003,291.70475,401.10
6.002027-04-012,891.70400.000.003,291.70474,469.91
7.002027-05-012,891.70400.000.003,291.70473,534.88
8.002027-06-012,891.70400.000.003,291.70472,596.00
9.002027-07-012,891.70400.000.003,291.70471,653.24
10.002027-08-012,891.70400.000.003,291.70470,706.59
11.002027-09-012,891.70400.000.003,291.70469,756.04
12.002027-10-012,891.70400.000.003,291.70468,801.57
13.002027-11-017,891.70400.000.008,291.70462,843.17
14.002027-12-012,891.70400.000.003,291.70461,860.19
15.002028-01-012,891.70400.000.003,291.70460,873.16
16.002028-02-012,891.70400.000.003,291.70459,882.06
17.002028-03-012,891.70400.000.003,291.70458,886.87
18.002028-04-012,891.70400.000.003,291.70457,887.57
19.002028-05-012,891.70400.000.003,291.70456,884.16
20.002028-06-012,891.70400.000.003,291.70455,876.61
21.002028-07-012,891.70400.000.003,291.70454,864.90
22.002028-08-012,891.70400.000.003,291.70453,849.02
23.002028-09-012,891.70400.000.003,291.70452,828.95
24.002028-10-012,891.70400.000.003,291.70451,804.68
25.002028-11-012,891.70400.000.003,291.70450,776.18
26.002028-12-012,891.70400.000.003,291.70449,743.43
27.002029-01-012,891.70400.000.003,291.70448,706.43
28.002029-02-012,891.70400.000.003,291.70447,665.16
29.002029-03-012,891.70400.000.003,291.70446,619.59
30.002029-04-012,891.70400.000.003,291.70445,569.71
31.002029-05-012,891.70400.000.003,291.70444,515.49
32.002029-06-012,891.70400.000.003,291.70443,456.93
33.002029-07-012,891.70400.000.003,291.70442,394.01
34.002029-08-012,891.70400.000.003,291.70441,326.70
35.002029-09-012,891.70400.000.003,291.70440,254.99
36.002029-10-012,891.70400.000.003,291.70439,178.86
37.002029-11-012,891.70400.000.003,291.70438,098.29
38.002029-12-012,891.70400.000.003,291.70437,013.27
39.002030-01-012,891.70400.000.003,291.70435,923.77
40.002030-02-012,891.70400.000.003,291.70434,829.78
41.002030-03-012,891.70400.000.003,291.70433,731.28
42.002030-04-012,891.70400.000.003,291.70432,628.24
43.002030-05-012,891.70400.000.003,291.70431,520.66
44.002030-06-012,891.70400.000.003,291.70430,408.51
45.002030-07-012,891.70400.000.003,291.70429,291.78
46.002030-08-012,891.70400.000.003,291.70428,170.44
47.002030-09-012,891.70400.000.003,291.70427,044.47
48.002030-10-012,891.70400.000.003,291.70425,913.86
49.002030-11-012,891.70400.000.003,291.70424,778.59
50.002030-12-012,891.70400.000.003,291.70423,638.64
51.002031-01-012,891.70400.000.003,291.70422,493.99
52.002031-02-012,891.70400.000.003,291.70421,344.61
53.002031-03-012,891.70400.000.003,291.70420,190.50
54.002031-04-012,891.70400.000.003,291.70419,031.62
55.002031-05-012,891.70400.000.003,291.70417,867.97
56.002031-06-012,891.70400.000.003,291.70416,699.52
57.002031-07-012,891.70400.000.003,291.70415,526.25
58.002031-08-012,891.70400.000.003,291.70414,348.14
59.002031-09-012,891.70400.000.003,291.70413,165.17
60.002031-10-012,891.70400.000.003,291.70411,977.33
61.002031-11-012,891.70400.000.003,291.70410,784.58
62.002031-12-012,891.70400.000.003,291.70409,586.92
63.002032-01-012,891.70400.000.003,291.70408,384.32
64.002032-02-012,891.70400.000.003,291.70407,176.75
65.002032-03-012,891.70400.000.003,291.70405,964.21
66.002032-04-012,891.70400.000.003,291.70404,746.67
67.002032-05-012,891.70400.000.003,291.70403,524.11
68.002032-06-012,891.70400.000.003,291.70402,296.50
69.002032-07-012,891.70400.000.003,291.70401,063.84
70.002032-08-012,891.70400.000.003,291.70399,826.09
71.002032-09-012,891.70400.000.003,291.70398,583.23
72.002032-10-012,891.70400.000.003,291.70397,335.25
73.002032-11-012,891.70400.000.003,291.70396,082.12
74.002032-12-012,891.70400.000.003,291.70394,823.83
75.002033-01-012,891.70400.000.003,291.70393,560.35
76.002033-02-012,891.70400.000.003,291.70392,291.65
77.002033-03-012,891.70400.000.003,291.70391,017.72
78.002033-04-012,891.70400.000.003,291.70389,738.55
79.002033-05-012,891.70400.000.003,291.70388,454.09
80.002033-06-012,891.70400.000.003,291.70387,164.34
81.002033-07-012,891.70400.000.003,291.70385,869.27
82.002033-08-012,891.70400.000.003,291.70384,568.86
83.002033-09-012,891.70400.000.003,291.70383,263.08
84.002033-10-012,891.70400.000.003,291.70381,951.92
85.002033-11-012,891.70400.000.003,291.70380,635.35
86.002033-12-012,891.70400.000.003,291.70379,313.36
87.002034-01-012,891.70400.000.003,291.70377,985.91
88.002034-02-012,891.70400.000.003,291.70376,652.99
89.002034-03-012,891.70400.000.003,291.70375,314.57
90.002034-04-012,891.70400.000.003,291.70373,970.63
91.002034-05-012,891.70400.000.003,291.70372,621.15
92.002034-06-012,891.70400.000.003,291.70371,266.11
93.002034-07-012,891.70400.000.003,291.70369,905.47
94.002034-08-012,891.70400.000.003,291.70368,539.23
95.002034-09-012,891.70400.000.003,291.70367,167.35
96.002034-10-012,891.70400.000.003,291.70365,789.81
97.002034-11-012,891.70400.000.003,291.70364,406.59
98.002034-12-012,891.70400.000.003,291.70363,017.67
99.002035-01-012,891.70400.000.003,291.70361,623.02
100.002035-02-012,891.70400.000.003,291.70360,222.62
101.002035-03-012,891.70400.000.003,291.70358,816.44
102.002035-04-012,891.70400.000.003,291.70357,404.47
103.002035-05-012,891.70400.000.003,291.70355,986.67
104.002035-06-012,891.70400.000.003,291.70354,563.03
105.002035-07-012,891.70400.000.003,291.70353,133.51
106.002035-08-012,891.70400.000.003,291.70351,698.10
107.002035-09-012,891.70400.000.003,291.70350,256.77
108.002035-10-012,891.70400.000.003,291.70348,809.49
109.002035-11-012,891.70400.000.003,291.70347,356.25
110.002035-12-012,891.70400.000.003,291.70345,897.01
111.002036-01-012,891.70400.000.003,291.70344,431.76
112.002036-02-012,891.70400.000.003,291.70342,960.46
113.002036-03-012,891.70400.000.003,291.70341,483.10
114.002036-04-012,891.70400.000.003,291.70339,999.64
115.002036-05-012,891.70400.000.003,291.70338,510.07
116.002036-06-012,891.70400.000.003,291.70337,014.35
117.002036-07-012,891.70400.000.003,291.70335,512.47
118.002036-08-012,891.70400.000.003,291.70334,004.39
119.002036-09-012,891.70400.000.003,291.70332,490.09
120.002036-10-012,891.70400.000.003,291.70330,969.55
121.002036-11-012,891.70400.000.003,291.70329,442.73
122.002036-12-012,891.70400.000.003,291.70327,909.62
123.002037-01-012,891.70400.000.003,291.70326,370.19
124.002037-02-012,891.70400.000.003,291.70324,824.41
125.002037-03-012,891.70400.000.003,291.70323,272.25
126.002037-04-012,891.70400.000.003,291.70321,713.70
127.002037-05-012,891.70400.000.003,291.70320,148.71
128.002037-06-012,891.70400.000.003,291.70318,577.28
129.002037-07-012,891.70400.000.003,291.70316,999.36
130.002037-08-012,891.70400.000.003,291.70315,414.93
131.002037-09-012,891.70400.000.003,291.70313,823.97
132.002037-10-012,891.70400.000.003,291.70312,226.45
133.002037-11-012,891.70400.000.003,291.70310,622.34
134.002037-12-012,891.70400.000.003,291.70309,011.62
135.002038-01-012,891.70400.000.003,291.70307,394.25
136.002038-02-012,891.70400.000.003,291.70305,770.22
137.002038-03-012,891.70400.000.003,291.70304,139.49
138.002038-04-012,891.70400.000.003,291.70302,502.03
139.002038-05-012,891.70400.000.003,291.70300,857.82
140.002038-06-012,891.70400.000.003,291.70299,206.82
141.002038-07-012,891.70400.000.003,291.70297,549.02
142.002038-08-012,891.70400.000.003,291.70295,884.39
143.002038-09-012,891.70400.000.003,291.70294,212.89
144.002038-10-012,891.70400.000.003,291.70292,534.49
145.002038-11-012,891.70400.000.003,291.70290,849.17
146.002038-12-012,891.70400.000.003,291.70289,156.91
147.002039-01-012,891.70400.000.003,291.70287,457.66
148.002039-02-012,891.70400.000.003,291.70285,751.41
149.002039-03-012,891.70400.000.003,291.70284,038.12
150.002039-04-012,891.70400.000.003,291.70282,317.77
151.002039-05-012,891.70400.000.003,291.70280,590.32
152.002039-06-012,891.70400.000.003,291.70278,855.74
153.002039-07-012,891.70400.000.003,291.70277,114.02
154.002039-08-012,891.70400.000.003,291.70275,365.11
155.002039-09-012,891.70400.000.003,291.70273,608.99
156.002039-10-012,891.70400.000.003,291.70271,845.62
157.002039-11-012,891.70400.000.003,291.70270,074.99
158.002039-12-012,891.70400.000.003,291.70268,297.05
159.002040-01-012,891.70400.000.003,291.70266,511.78
160.002040-02-012,891.70400.000.003,291.70264,719.15
161.002040-03-012,891.70400.000.003,291.70262,919.12
162.002040-04-012,891.70400.000.003,291.70261,111.68
163.002040-05-012,891.70400.000.003,291.70259,296.77
164.002040-06-012,891.70400.000.003,291.70257,474.39
165.002040-07-012,891.70400.000.003,291.70255,644.49
166.002040-08-012,891.70400.000.003,291.70253,807.04
167.002040-09-012,891.70400.000.003,291.70251,962.01
168.002040-10-012,891.70400.000.003,291.70250,109.38
169.002040-11-012,891.70400.000.003,291.70248,249.11
170.002040-12-012,891.70400.000.003,291.70246,381.16
171.002041-01-012,891.70400.000.003,291.70244,505.51
172.002041-02-012,891.70400.000.003,291.70242,622.13
173.002041-03-012,891.70400.000.003,291.70240,730.98
174.002041-04-012,891.70400.000.003,291.70238,832.03
175.002041-05-012,891.70400.000.003,291.70236,925.25
176.002041-06-012,891.70400.000.003,291.70235,010.60
177.002041-07-012,891.70400.000.003,291.70233,088.06
178.002041-08-012,891.70400.000.003,291.70231,157.59
179.002041-09-012,891.70400.000.003,291.70229,219.16
180.002041-10-012,891.70400.000.003,291.70227,272.74
181.002041-11-012,891.70400.000.003,291.70225,318.29
182.002041-12-012,891.70400.000.003,291.70223,355.78
183.002042-01-012,891.70400.000.003,291.70221,385.18
184.002042-02-012,891.70400.000.003,291.70219,406.45
185.002042-03-012,891.70400.000.003,291.70217,419.56
186.002042-04-012,891.70400.000.003,291.70215,424.47
187.002042-05-012,891.70400.000.003,291.70213,421.16
188.002042-06-012,891.70400.000.003,291.70211,409.59
189.002042-07-012,891.70400.000.003,291.70209,389.72
190.002042-08-012,891.70400.000.003,291.70207,361.52
191.002042-09-012,891.70400.000.003,291.70205,324.96
192.002042-10-012,891.70400.000.003,291.70203,280.00
193.002042-11-012,891.70400.000.003,291.70201,226.60
194.002042-12-012,891.70400.000.003,291.70199,164.74
195.002043-01-012,891.70400.000.003,291.70197,094.37
196.002043-02-012,891.70400.000.003,291.70195,015.47
197.002043-03-012,891.70400.000.003,291.70192,927.99
198.002043-04-012,891.70400.000.003,291.70190,831.91
199.002043-05-012,891.70400.000.003,291.70188,727.18
200.002043-06-012,891.70400.000.003,291.70186,613.77
201.002043-07-012,891.70400.000.003,291.70184,491.65
202.002043-08-012,891.70400.000.003,291.70182,360.77
203.002043-09-012,891.70400.000.003,291.70180,221.11
204.002043-10-012,891.70400.000.003,291.70178,072.62
205.002043-11-012,891.70400.000.003,291.70175,915.27
206.002043-12-012,891.70400.000.003,291.70173,749.03
207.002044-01-012,891.70400.000.003,291.70171,573.85
208.002044-02-012,891.70400.000.003,291.70169,389.70
209.002044-03-012,891.70400.000.003,291.70167,196.55
210.002044-04-012,891.70400.000.003,291.70164,994.35
211.002044-05-012,891.70400.000.003,291.70162,783.07
212.002044-06-012,891.70400.000.003,291.70160,562.67
213.002044-07-012,891.70400.000.003,291.70158,333.11
214.002044-08-012,891.70400.000.003,291.70156,094.36
215.002044-09-012,891.70400.000.003,291.70153,846.37
216.002044-10-012,891.70400.000.003,291.70151,589.12
217.002044-11-012,891.70400.000.003,291.70149,322.56
218.002044-12-012,891.70400.000.003,291.70147,046.65
219.002045-01-012,891.70400.000.003,291.70144,761.35
220.002045-02-012,891.70400.000.003,291.70142,466.63
221.002045-03-012,891.70400.000.003,291.70140,162.45
222.002045-04-012,891.70400.000.003,291.70137,848.76
223.002045-05-012,891.70400.000.003,291.70135,525.53
224.002045-06-012,891.70400.000.003,291.70133,192.72
225.002045-07-012,891.70400.000.003,291.70130,850.30
226.002045-08-012,891.70400.000.003,291.70128,498.21
227.002045-09-012,891.70400.000.003,291.70126,136.42
228.002045-10-012,891.70400.000.003,291.70123,764.89
229.002045-11-012,891.70400.000.003,291.70121,383.58
230.002045-12-012,891.70400.000.003,291.70118,992.45
231.002046-01-012,891.70400.000.003,291.70116,591.47
232.002046-02-012,891.70400.000.003,291.70114,180.58
233.002046-03-012,891.70400.000.003,291.70111,759.74
234.002046-04-012,891.70400.000.003,291.70109,328.93
235.002046-05-012,891.70400.000.003,291.70106,888.09
236.002046-06-012,891.70400.000.003,291.70104,437.18
237.002046-07-012,891.70400.000.003,291.70101,976.17
238.002046-08-012,891.70400.000.003,291.7099,505.00
239.002046-09-012,891.70400.000.003,291.7097,023.65
240.002046-10-012,891.70400.000.003,291.7094,532.06
241.002046-11-012,891.70400.000.003,291.7092,030.20
242.002046-12-012,891.70400.000.003,291.7089,518.02
243.002047-01-012,891.70400.000.003,291.7086,995.48
244.002047-02-012,891.70400.000.003,291.7084,462.54
245.002047-03-012,891.70400.000.003,291.7081,919.15
246.002047-04-012,891.70400.000.003,291.7079,365.28
247.002047-05-012,891.70400.000.003,291.7076,800.87
248.002047-06-012,891.70400.000.003,291.7074,225.88
249.002047-07-012,891.70400.000.003,291.7071,640.28
250.002047-08-012,891.70400.000.003,291.7069,044.02
251.002047-09-012,891.70400.000.003,291.7066,437.04
252.002047-10-012,891.70400.000.003,291.7063,819.32
253.002047-11-012,891.70400.000.003,291.7061,190.80
254.002047-12-012,891.70400.000.003,291.7058,551.44
255.002048-01-012,891.70400.000.003,291.7055,901.20
256.002048-02-012,891.70400.000.003,291.7053,240.03
257.002048-03-012,891.70400.000.003,291.7050,567.88
258.002048-04-012,891.70400.000.003,291.7047,884.72
259.002048-05-012,891.70400.000.003,291.7045,190.49
260.002048-06-012,891.70400.000.003,291.7042,485.14
261.002048-07-012,891.70400.000.003,291.7039,768.64
262.002048-08-012,891.70400.000.003,291.7037,040.94
263.002048-09-012,891.70400.000.003,291.7034,301.99
264.002048-10-012,891.70400.000.003,291.7031,551.75
265.002048-11-012,891.70400.000.003,291.7028,790.16
266.002048-12-012,891.70400.000.003,291.7026,017.18
267.002049-01-012,891.70400.000.003,291.7023,232.77
268.002049-02-012,891.70400.000.003,291.7020,436.88
269.002049-03-012,891.70400.000.003,291.7017,629.45
270.002049-04-012,891.70400.000.003,291.7014,810.45
271.002049-05-012,891.70400.000.003,291.7011,979.83
272.002049-06-012,891.70400.000.003,291.709,137.53
273.002049-07-012,891.70400.000.003,291.706,283.50
274.002049-08-012,891.70400.000.003,291.703,417.71
275.002049-09-012,891.70400.000.003,291.70540.10
276.002049-10-01542.33400.000.00942.330.00

Advertisement

How this calculator works

Borrowing equals the home price less down payment plus any financed default-insurance premium you enter. Canadian fixed-rate compounding is the default. Dated extras, a lump sum and annual payment increases can shorten repayment. Property tax, insurance and other carrying costs are held constant and spread evenly over payment periods. Optional US-style PMI uses a quoted rate on the original mortgage and stops at the entered modelled LTV. This is a scenario, not a statutory cancellation decision.

Formula

Principal = price - down payment + financed premium. i = (1 + nominal rate / c)^(c/f) - 1. Regular P&I = P × i / (1 - (1 + i)^(-Nf/12)). Periodic carrying costs = (annual tax + annual home insurance + 12 × monthly fees) / f. Budget payment = actual mortgage payment + carrying costs + modelled PMI.

Worked example

For a $100,000 home with $20,000 down, no premium and a 120-month loan at 0%, monthly P&I is $666.67. Annual tax of $1,200, insurance of $600 and $50 monthly fees add $200, giving $866.67 before any extras.

Advertisement

Frequently asked questions

Is the Canadian insurance premium automatic?

No. Enter the premium quoted by the lender if it is financed. Provincial sales tax on a premium generally needs separate cash.

Do tax and insurance stop at mortgage payoff?

No. The lifetime figure here totals costs only during the modelled mortgage period. Ownership expenses continue afterwards.

Does the PMI stopping LTV guarantee cancellation?

No. The optional model uses a simple threshold. US loan type, payment history, valuation and servicing rules can change cancellation eligibility.

Sources

Advertisement