Advertisement

Mortgage calculator with taxes and insurance

See the housing payment after property tax, insurance and recurring fees are added to the mortgage.

Calculator

Regular principal and interest
$2,791.70
Property tax per payment
$300.00
Home insurance per payment
$100.00
Condo and other costs per payment
$0.00
First payment PMI
$0.00
First all-in payment
$3,291.70
Annual carrying costs excluding PMI
$4,800.00
Down payment and modelled total housing costs
$1,031,160.91
Mortgage payoff date
2049-10-01
Full housing payment breakdown
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

Taxes and home insurance are annual amounts spread over the selected number of payments each year. Condo or HOA fees and other costs are monthly amounts converted to that same frequency. The first all-in payment includes any extras due then. A quoted optional monthly PMI model is separate from a financed Canadian default-insurance premium. Constant carrying costs are a budget allocation, not a prediction of future tax bills or an escrow statement.

Formula

Annual carrying costs = property tax + home insurance + 12 × (monthly condo fee + other monthly costs). Periodic carrying costs = annual carrying costs / payments per year. All-in payment = actual principal and interest payment + periodic carrying costs + applicable PMI.

Worked example

At 0%, an $80,000 loan over 120 months has $666.67 monthly P&I. Add $100 tax, $50 home insurance and $50 condo fees per month for an $866.67 housing payment. A $200,000 loan over 240 months with $400 monthly carrying costs totals $1,233.33.

Advertisement

Frequently asked questions

Are property tax and insurance part of mortgage interest?

No. They are ownership costs even when a lender collects them with the mortgage payment.

Does the annual carrying-cost figure include PMI?

No. PMI may stop partway through the mortgage. It is shown separately in the payment table.

Will escrow collect exactly this amount?

Not necessarily. Escrow reserves, billing dates and future adjustments can differ. Use the figure as a budget estimate.

Sources

Advertisement