Canadian Mortgage Calculator

https://www.vertex42.com/Calculators/Canadian-mortgage.html © 2007-2020 Vertex42 LLC

Inputs Balance at Term

Purchase Price 150,000.00 Date at Term 7/1/2023
Down Payment - Interest Paid $23,761.87
Costs added to Loan (CMHC) - Principal Paid $9,199.37
Loan Amount 150,000.00 Outstanding Balance $140,800.63
Canadian Mortgage Rate 5.50%
Compound Period Semi-Annually
160,000 No Extra Payments
Amortization Period (in years) 25 Balance
140,000
Term (in years) 3
120,000
First Payment Date 8/1/2020
100,000
Payment Frequency Monthly
Payment $915.59 80,000
60,000
.
Property Value 150,000.00 40,000
Est. Yearly Property Taxes 1,350.00 20,000
Est. Yearly H.O. Insurance 600.00 0
Other Fees -

2/1/2023

2/1/2028

5/1/2034

5/1/2039
11/1/...

11/1/...

11/1/...

11/1/...

11/1/...
8/1/2020

5/1/2024
8/1/2025

5/1/2029
8/1/2030

2/1/2033

8/1/2035

2/1/2038

8/1/2040

2/1/2043
5/1/2044
PITI Payment $1,078.09

Fully Amortized Extra Payments (Prepayments)

Interest Rate (per payment) 0.453% Extra Payment $ -
Total Payments $ 274,675.24 Payment Interval 1
Total Interest $ 124,675.24 Extra Annual Payment $ -
Number of Payments 300 (25 years)
Last Payment Date 7/1/2045 Totals Assuming No Extra Payments
Interest Savings $0.00 Total Payments $274,675.24
Total Interest $124,675.24

Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance
$150,000.00
1 8/1/2020 915.59 0.00 679.75 235.84 149,764.16
2 9/1/2020 915.59 0.00 678.68 236.91 149,527.25
3 10/1/2020 915.59 0.00 677.61 237.98 149,289.27
4 11/1/2020 915.59 0.00 676.53 239.06 149,050.21
5 12/1/2020 915.59 0.00 675.45 240.14 148,810.07
6 1/1/2021 915.59 0.00 674.36 241.23 148,568.84
7 2/1/2021 915.59 0.00 673.27 242.32 148,326.52
8 3/1/2021 915.59 0.00 672.17 243.42 148,083.10
9 4/1/2021 915.59 0.00 671.07 244.52 147,838.58
10 5/1/2021 915.59 0.00 669.96 245.63 147,592.95
11 6/1/2021 915.59 0.00 668.84 246.75 147,346.20
12 7/1/2021 915.59 0.00 667.73 247.86 147,098.34
13 8/1/2021 915.59 0.00 666.60 248.99 146,849.35
14 9/1/2021 915.59 0.00 665.47 250.12 146,599.23
15 10/1/2021 915.59 0.00 664.34 251.25 146,347.98
16 11/1/2021 915.59 0.00 663.20 252.39 146,095.59
17 12/1/2021 915.59 0.00 662.06 253.53 145,842.06
18 1/1/2022 915.59 0.00 660.91 254.68 145,587.38

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 1 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance
19 2/1/2022 915.59 0.00 659.76 255.83 145,331.55
20 3/1/2022 915.59 0.00 658.60 256.99 145,074.56
21 4/1/2022 915.59 0.00 657.43 258.16 144,816.40
22 5/1/2022 915.59 0.00 656.26 259.33 144,557.07
23 6/1/2022 915.59 0.00 655.09 260.50 144,296.57
24 7/1/2022 915.59 0.00 653.91 261.68 144,034.89
25 8/1/2022 915.59 0.00 652.72 262.87 143,772.02
26 9/1/2022 915.59 0.00 651.53 264.06 143,507.96
27 10/1/2022 915.59 0.00 650.33 265.26 143,242.70
28 11/1/2022 915.59 0.00 649.13 266.46 142,976.24
29 12/1/2022 915.59 0.00 647.92 267.67 142,708.57
30 1/1/2023 915.59 0.00 646.71 268.88 142,439.69
31 2/1/2023 915.59 0.00 645.49 270.10 142,169.59
32 3/1/2023 915.59 0.00 644.27 271.32 141,898.27
33 4/1/2023 915.59 0.00 643.04 272.55 141,625.72
34 5/1/2023 915.59 0.00 641.80 273.79 141,351.93
35 6/1/2023 915.59 0.00 640.56 275.03 141,076.90
36 7/1/2023 915.59 0.00 639.32 276.27 140,800.63
37 8/1/2023 915.59 0.00 638.06 277.53 140,523.10
38 9/1/2023 915.59 0.00 636.81 278.78 140,244.32
39 10/1/2023 915.59 0.00 635.54 280.05 139,964.27
40 11/1/2023 915.59 0.00 634.27 281.32 139,682.95
41 12/1/2023 915.59 0.00 633.00 282.59 139,400.36
42 1/1/2024 915.59 0.00 631.72 283.87 139,116.49
43 2/1/2024 915.59 0.00 630.43 285.16 138,831.33
44 3/1/2024 915.59 0.00 629.14 286.45 138,544.88
45 4/1/2024 915.59 0.00 627.84 287.75 138,257.13
46 5/1/2024 915.59 0.00 626.54 289.05 137,968.08
47 6/1/2024 915.59 0.00 625.23 290.36 137,677.72
48 7/1/2024 915.59 0.00 623.91 291.68 137,386.04
49 8/1/2024 915.59 0.00 622.59 293.00 137,093.04
50 9/1/2024 915.59 0.00 621.26 294.33 136,798.71
51 10/1/2024 915.59 0.00 619.93 295.66 136,503.05
52 11/1/2024 915.59 0.00 618.59 297.00 136,206.05
53 12/1/2024 915.59 0.00 617.24 298.35 135,907.70
54 1/1/2025 915.59 0.00 615.89 299.70 135,608.00
55 2/1/2025 915.59 0.00 614.53 301.06 135,306.94
56 3/1/2025 915.59 0.00 613.17 302.42 135,004.52
57 4/1/2025 915.59 0.00 611.80 303.79 134,700.73
58 5/1/2025 915.59 0.00 610.42 305.17 134,395.56
59 6/1/2025 915.59 0.00 609.04 306.55 134,089.01
60 7/1/2025 915.59 0.00 607.65 307.94 133,781.07
61 8/1/2025 915.59 0.00 606.25 309.34 133,471.73
62 9/1/2025 915.59 0.00 604.85 310.74 133,160.99
63 10/1/2025 915.59 0.00 603.44 312.15 132,848.84
64 11/1/2025 915.59 0.00 602.03 313.56 132,535.28
65 12/1/2025 915.59 0.00 600.61 314.98 132,220.30
66 1/1/2026 915.59 0.00 599.18 316.41 131,903.89
67 2/1/2026 915.59 0.00 597.75 317.84 131,586.05
68 3/1/2026 915.59 0.00 596.31 319.28 131,266.77
69 4/1/2026 915.59 0.00 594.86 320.73 130,946.04
70 5/1/2026 915.59 0.00 593.41 322.18 130,623.86
71 6/1/2026 915.59 0.00 591.95 323.64 130,300.22
72 7/1/2026 915.59 0.00 590.48 325.11 129,975.11

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 2 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance
73 8/1/2026 915.59 0.00 589.01 326.58 129,648.53
74 9/1/2026 915.59 0.00 587.53 328.06 129,320.47
75 10/1/2026 915.59 0.00 586.04 329.55 128,990.92
76 11/1/2026 915.59 0.00 584.55 331.04 128,659.88
77 12/1/2026 915.59 0.00 583.05 332.54 128,327.34
78 1/1/2027 915.59 0.00 581.54 334.05 127,993.29
79 2/1/2027 915.59 0.00 580.02 335.57 127,657.72
80 3/1/2027 915.59 0.00 578.50 337.09 127,320.63
81 4/1/2027 915.59 0.00 576.98 338.61 126,982.02
82 5/1/2027 915.59 0.00 575.44 340.15 126,641.87
83 6/1/2027 915.59 0.00 573.90 341.69 126,300.18
84 7/1/2027 915.59 0.00 572.35 343.24 125,956.94
85 8/1/2027 915.59 0.00 570.80 344.79 125,612.15
86 9/1/2027 915.59 0.00 569.23 346.36 125,265.79
87 10/1/2027 915.59 0.00 567.66 347.93 124,917.86
88 11/1/2027 915.59 0.00 566.09 349.50 124,568.36
89 12/1/2027 915.59 0.00 564.50 351.09 124,217.27
90 1/1/2028 915.59 0.00 562.91 352.68 123,864.59
91 2/1/2028 915.59 0.00 561.31 354.28 123,510.31
92 3/1/2028 915.59 0.00 559.71 355.88 123,154.43
93 4/1/2028 915.59 0.00 558.10 357.49 122,796.94
94 5/1/2028 915.59 0.00 556.48 359.11 122,437.83
95 6/1/2028 915.59 0.00 554.85 360.74 122,077.09
96 7/1/2028 915.59 0.00 553.21 362.38 121,714.71
97 8/1/2028 915.59 0.00 551.57 364.02 121,350.69
98 9/1/2028 915.59 0.00 549.92 365.67 120,985.02
99 10/1/2028 915.59 0.00 548.27 367.32 120,617.70
100 11/1/2028 915.59 0.00 546.60 368.99 120,248.71
101 12/1/2028 915.59 0.00 544.93 370.66 119,878.05
102 1/1/2029 915.59 0.00 543.25 372.34 119,505.71
103 2/1/2029 915.59 0.00 541.56 374.03 119,131.68
104 3/1/2029 915.59 0.00 539.87 375.72 118,755.96
105 4/1/2029 915.59 0.00 538.16 377.43 118,378.53
106 5/1/2029 915.59 0.00 536.45 379.14 117,999.39
107 6/1/2029 915.59 0.00 534.74 380.85 117,618.54
108 7/1/2029 915.59 0.00 533.01 382.58 117,235.96
109 8/1/2029 915.59 0.00 531.28 384.31 116,851.65
110 9/1/2029 915.59 0.00 529.53 386.06 116,465.59
111 10/1/2029 915.59 0.00 527.78 387.81 116,077.78
112 11/1/2029 915.59 0.00 526.03 389.56 115,688.22
113 12/1/2029 915.59 0.00 524.26 391.33 115,296.89
114 1/1/2030 915.59 0.00 522.49 393.10 114,903.79
115 2/1/2030 915.59 0.00 520.71 394.88 114,508.91
116 3/1/2030 915.59 0.00 518.92 396.67 114,112.24
117 4/1/2030 915.59 0.00 517.12 398.47 113,713.77
118 5/1/2030 915.59 0.00 515.31 400.28 113,313.49
119 6/1/2030 915.59 0.00 513.50 402.09 112,911.40
120 7/1/2030 915.59 0.00 511.68 403.91 112,507.49
121 8/1/2030 915.59 0.00 509.85 405.74 112,101.75
122 9/1/2030 915.59 0.00 508.01 407.58 111,694.17
123 10/1/2030 915.59 0.00 506.16 409.43 111,284.74
124 11/1/2030 915.59 0.00 504.31 411.28 110,873.46
125 12/1/2030 915.59 0.00 502.44 413.15 110,460.31
126 1/1/2031 915.59 0.00 500.57 415.02 110,045.29

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 3 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance
127 2/1/2031 915.59 0.00 498.69 416.90 109,628.39
128 3/1/2031 915.59 0.00 496.80 418.79 109,209.60
129 4/1/2031 915.59 0.00 494.90 420.69 108,788.91
130 5/1/2031 915.59 0.00 493.00 422.59 108,366.32
131 6/1/2031 915.59 0.00 491.08 424.51 107,941.81
132 7/1/2031 915.59 0.00 489.16 426.43 107,515.38
133 8/1/2031 915.59 0.00 487.23 428.36 107,087.02
134 9/1/2031 915.59 0.00 485.28 430.31 106,656.71
135 10/1/2031 915.59 0.00 483.33 432.26 106,224.45
136 11/1/2031 915.59 0.00 481.38 434.21 105,790.24
137 12/1/2031 915.59 0.00 479.41 436.18 105,354.06
138 1/1/2032 915.59 0.00 477.43 438.16 104,915.90
139 2/1/2032 915.59 0.00 475.45 440.14 104,475.76
140 3/1/2032 915.59 0.00 473.45 442.14 104,033.62
141 4/1/2032 915.59 0.00 471.45 444.14 103,589.48
142 5/1/2032 915.59 0.00 469.43 446.16 103,143.32
143 6/1/2032 915.59 0.00 467.41 448.18 102,695.14
144 7/1/2032 915.59 0.00 465.38 450.21 102,244.93
145 8/1/2032 915.59 0.00 463.34 452.25 101,792.68
146 9/1/2032 915.59 0.00 461.29 454.30 101,338.38
147 10/1/2032 915.59 0.00 459.23 456.36 100,882.02
148 11/1/2032 915.59 0.00 457.17 458.42 100,423.60
149 12/1/2032 915.59 0.00 455.09 460.50 99,963.10
150 1/1/2033 915.59 0.00 453.00 462.59 99,500.51
151 2/1/2033 915.59 0.00 450.90 464.69 99,035.82
152 3/1/2033 915.59 0.00 448.80 466.79 98,569.03
153 4/1/2033 915.59 0.00 446.68 468.91 98,100.12
154 5/1/2033 915.59 0.00 444.56 471.03 97,629.09
155 6/1/2033 915.59 0.00 442.42 473.17 97,155.92
156 7/1/2033 915.59 0.00 440.28 475.31 96,680.61
157 8/1/2033 915.59 0.00 438.13 477.46 96,203.15
158 9/1/2033 915.59 0.00 435.96 479.63 95,723.52
159 10/1/2033 915.59 0.00 433.79 481.80 95,241.72
160 11/1/2033 915.59 0.00 431.61 483.98 94,757.74
161 12/1/2033 915.59 0.00 429.41 486.18 94,271.56
162 1/1/2034 915.59 0.00 427.21 488.38 93,783.18
163 2/1/2034 915.59 0.00 425.00 490.59 93,292.59
164 3/1/2034 915.59 0.00 422.77 492.82 92,799.77
165 4/1/2034 915.59 0.00 420.54 495.05 92,304.72
166 5/1/2034 915.59 0.00 418.30 497.29 91,807.43
167 6/1/2034 915.59 0.00 416.04 499.55 91,307.88
168 7/1/2034 915.59 0.00 413.78 501.81 90,806.07
169 8/1/2034 915.59 0.00 411.50 504.09 90,301.98
170 9/1/2034 915.59 0.00 409.22 506.37 89,795.61
171 10/1/2034 915.59 0.00 406.93 508.66 89,286.95
172 11/1/2034 915.59 0.00 404.62 510.97 88,775.98
173 12/1/2034 915.59 0.00 402.30 513.29 88,262.69
174 1/1/2035 915.59 0.00 399.98 515.61 87,747.08
175 2/1/2035 915.59 0.00 397.64 517.95 87,229.13
176 3/1/2035 915.59 0.00 395.29 520.30 86,708.83
177 4/1/2035 915.59 0.00 392.94 522.65 86,186.18
178 5/1/2035 915.59 0.00 390.57 525.02 85,661.16
179 6/1/2035 915.59 0.00 388.19 527.40 85,133.76
180 7/1/2035 915.59 0.00 385.80 529.79 84,603.97

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 4 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance
181 8/1/2035 915.59 0.00 383.40 532.19 84,071.78
182 9/1/2035 915.59 0.00 380.99 534.60 83,537.18
183 10/1/2035 915.59 0.00 378.56 537.03 83,000.15
184 11/1/2035 915.59 0.00 376.13 539.46 82,460.69
185 12/1/2035 915.59 0.00 373.69 541.90 81,918.79
186 1/1/2036 915.59 0.00 371.23 544.36 81,374.43
187 2/1/2036 915.59 0.00 368.76 546.83 80,827.60
188 3/1/2036 915.59 0.00 366.28 549.31 80,278.29
189 4/1/2036 915.59 0.00 363.80 551.79 79,726.50
190 5/1/2036 915.59 0.00 361.30 554.29 79,172.21
191 6/1/2036 915.59 0.00 358.78 556.81 78,615.40
192 7/1/2036 915.59 0.00 356.26 559.33 78,056.07
193 8/1/2036 915.59 0.00 353.73 561.86 77,494.21
194 9/1/2036 915.59 0.00 351.18 564.41 76,929.80
195 10/1/2036 915.59 0.00 348.62 566.97 76,362.83
196 11/1/2036 915.59 0.00 346.05 569.54 75,793.29
197 12/1/2036 915.59 0.00 343.47 572.12 75,221.17
198 1/1/2037 915.59 0.00 340.88 574.71 74,646.46
199 2/1/2037 915.59 0.00 338.27 577.32 74,069.14
200 3/1/2037 915.59 0.00 335.66 579.93 73,489.21
201 4/1/2037 915.59 0.00 333.03 582.56 72,906.65
202 5/1/2037 915.59 0.00 330.39 585.20 72,321.45
203 6/1/2037 915.59 0.00 327.74 587.85 71,733.60
204 7/1/2037 915.59 0.00 325.07 590.52 71,143.08
205 8/1/2037 915.59 0.00 322.40 593.19 70,549.89
206 9/1/2037 915.59 0.00 319.71 595.88 69,954.01
207 10/1/2037 915.59 0.00 317.01 598.58 69,355.43
208 11/1/2037 915.59 0.00 314.30 601.29 68,754.14
209 12/1/2037 915.59 0.00 311.57 604.02 68,150.12
210 1/1/2038 915.59 0.00 308.83 606.76 67,543.36
211 2/1/2038 915.59 0.00 306.09 609.50 66,933.86
212 3/1/2038 915.59 0.00 303.32 612.27 66,321.59
213 4/1/2038 915.59 0.00 300.55 615.04 65,706.55
214 5/1/2038 915.59 0.00 297.76 617.83 65,088.72
215 6/1/2038 915.59 0.00 294.96 620.63 64,468.09
216 7/1/2038 915.59 0.00 292.15 623.44 63,844.65
217 8/1/2038 915.59 0.00 289.32 626.27 63,218.38
218 9/1/2038 915.59 0.00 286.49 629.10 62,589.28
219 10/1/2038 915.59 0.00 283.63 631.96 61,957.32
220 11/1/2038 915.59 0.00 280.77 634.82 61,322.50
221 12/1/2038 915.59 0.00 277.89 637.70 60,684.80
222 1/1/2039 915.59 0.00 275.00 640.59 60,044.21
223 2/1/2039 915.59 0.00 272.10 643.49 59,400.72
224 3/1/2039 915.59 0.00 269.19 646.40 58,754.32
225 4/1/2039 915.59 0.00 266.26 649.33 58,104.99
226 5/1/2039 915.59 0.00 263.31 652.28 57,452.71
227 6/1/2039 915.59 0.00 260.36 655.23 56,797.48
228 7/1/2039 915.59 0.00 257.39 658.20 56,139.28
229 8/1/2039 915.59 0.00 254.41 661.18 55,478.10
230 9/1/2039 915.59 0.00 251.41 664.18 54,813.92
231 10/1/2039 915.59 0.00 248.40 667.19 54,146.73
232 11/1/2039 915.59 0.00 245.38 670.21 53,476.52
233 12/1/2039 915.59 0.00 242.34 673.25 52,803.27
234 1/1/2040 915.59 0.00 239.29 676.30 52,126.97

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 5 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance
235 2/1/2040 915.59 0.00 236.22 679.37 51,447.60
236 3/1/2040 915.59 0.00 233.14 682.45 50,765.15
237 4/1/2040 915.59 0.00 230.05 685.54 50,079.61
238 5/1/2040 915.59 0.00 226.94 688.65 49,390.96
239 6/1/2040 915.59 0.00 223.82 691.77 48,699.19
240 7/1/2040 915.59 0.00 220.69 694.90 48,004.29
241 8/1/2040 915.59 0.00 217.54 698.05 47,306.24
242 9/1/2040 915.59 0.00 214.38 701.21 46,605.03
243 10/1/2040 915.59 0.00 211.20 704.39 45,900.64
244 11/1/2040 915.59 0.00 208.01 707.58 45,193.06
245 12/1/2040 915.59 0.00 204.80 710.79 44,482.27
246 1/1/2041 915.59 0.00 201.58 714.01 43,768.26
247 2/1/2041 915.59 0.00 198.34 717.25 43,051.01
248 3/1/2041 915.59 0.00 195.09 720.50 42,330.51
249 4/1/2041 915.59 0.00 191.83 723.76 41,606.75
250 5/1/2041 915.59 0.00 188.55 727.04 40,879.71
251 6/1/2041 915.59 0.00 185.25 730.34 40,149.37
252 7/1/2041 915.59 0.00 181.94 733.65 39,415.72
253 8/1/2041 915.59 0.00 178.62 736.97 38,678.75
254 9/1/2041 915.59 0.00 175.28 740.31 37,938.44
255 10/1/2041 915.59 0.00 171.92 743.67 37,194.77
256 11/1/2041 915.59 0.00 168.55 747.04 36,447.73
257 12/1/2041 915.59 0.00 165.17 750.42 35,697.31
258 1/1/2042 915.59 0.00 161.77 753.82 34,943.49
259 2/1/2042 915.59 0.00 158.35 757.24 34,186.25
260 3/1/2042 915.59 0.00 154.92 760.67 33,425.58
261 4/1/2042 915.59 0.00 151.47 764.12 32,661.46
262 5/1/2042 915.59 0.00 148.01 767.58 31,893.88
263 6/1/2042 915.59 0.00 144.53 771.06 31,122.82
264 7/1/2042 915.59 0.00 141.04 774.55 30,348.27
265 8/1/2042 915.59 0.00 137.53 778.06 29,570.21
266 9/1/2042 915.59 0.00 134.00 781.59 28,788.62
267 10/1/2042 915.59 0.00 130.46 785.13 28,003.49
268 11/1/2042 915.59 0.00 126.90 788.69 27,214.80
269 12/1/2042 915.59 0.00 123.33 792.26 26,422.54
270 1/1/2043 915.59 0.00 119.74 795.85 25,626.69
271 2/1/2043 915.59 0.00 116.13 799.46 24,827.23
272 3/1/2043 915.59 0.00 112.51 803.08 24,024.15
273 4/1/2043 915.59 0.00 108.87 806.72 23,217.43
274 5/1/2043 915.59 0.00 105.21 810.38 22,407.05
275 6/1/2043 915.59 0.00 101.54 814.05 21,593.00
276 7/1/2043 915.59 0.00 97.85 817.74 20,775.26
277 8/1/2043 915.59 0.00 94.15 821.44 19,953.82
278 9/1/2043 915.59 0.00 90.42 825.17 19,128.65
279 10/1/2043 915.59 0.00 86.68 828.91 18,299.74
280 11/1/2043 915.59 0.00 82.93 832.66 17,467.08
281 12/1/2043 915.59 0.00 79.16 836.43 16,630.65
282 1/1/2044 915.59 0.00 75.36 840.23 15,790.42
283 2/1/2044 915.59 0.00 71.56 844.03 14,946.39
284 3/1/2044 915.59 0.00 67.73 847.86 14,098.53
285 4/1/2044 915.59 0.00 63.89 851.70 13,246.83
286 5/1/2044 915.59 0.00 60.03 855.56 12,391.27
287 6/1/2044 915.59 0.00 56.15 859.44 11,531.83
288 7/1/2044 915.59 0.00 52.26 863.33 10,668.50

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 6 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance
289 8/1/2044 915.59 0.00 48.35 867.24 9,801.26
290 9/1/2044 915.59 0.00 44.42 871.17 8,930.09
291 10/1/2044 915.59 0.00 40.47 875.12 8,054.97
292 11/1/2044 915.59 0.00 36.50 879.09 7,175.88
293 12/1/2044 915.59 0.00 32.52 883.07 6,292.81
294 1/1/2045 915.59 0.00 28.52 887.07 5,405.74
295 2/1/2045 915.59 0.00 24.50 891.09 4,514.65
296 3/1/2045 915.59 0.00 20.46 895.13 3,619.52
297 4/1/2045 915.59 0.00 16.40 899.19 2,720.33
298 5/1/2045 915.59 0.00 12.33 903.26 1,817.07
299 6/1/2045 915.59 0.00 8.23 907.36 909.71
300 7/1/2045 913.83 4.12 909.71 0.00

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 7 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 8 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 9 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 10 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 11 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 12 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 13 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 14 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 15 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 16 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 17 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 18 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 19 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 20 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 21 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 22 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 23 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 24 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 25 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 26 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 27 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 28 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 29 of 33

 Extra Additional
No. Due Date Payment Payments Payment Interest Principal Balance

© 2007 Vertex42 LLC https://www.vertex42.com/Calculators/Canadian-mortgage.html 30 of 33

HELP
https://www.vertex42.com/Calculators/Canadian-mortgage.html © 2007-2018 Vertex42 LLC

Getting Started
This spreadsheet creates an amortization schedule for a fixed-rate Canadian mortgage
loan, with optional extra payments. Use the spreadsheet to compare different
amortization periods, rates, and loan amounts. The compound period for a Canadian
mortgage is semi-annual, but this calculator can also be used for US mortgage
calculations by changing the compound period to monthly - the main difference
between a US and Canadian mortgage. This spreadsheet also calculates the
outstanding balance at the end of a specified term. It assumes that the rate at renewal
is the same as the original mortgage rate, but this will likely not be the case. At the start
of the next term, create a new spreadsheet based on the new mortgage rate and
amortization period.

The payment and the interest are rounded to the nearest cent. The last payment is
adjusted to bring the balance to zero.

Additional Help
The link at the top of this worksheet will take you to the web page on vertex42.com that
talks about this template.

REFERENCES

SEE ALSO Vertex42.com: Loan Amortization Schedule

SEE ALSO Vertex42.com: Personal Budget Spreadsheet

TIPS Vertex42.com: Spreadsheet Tips Workbook

07-2018 Vertex42 LLC
Canadian Mortgage Calculator

By Vertex42.com
https://www.vertex42.com/Calculators/Canadian-mortgage.html

© 2007-2020 Vertex42 LLC

This spreadsheet, including all worksheets and associated content is a

copyrighted work under the United States and other copyright laws.

Do not submit copies or modifications of this template to any website or online

template gallery.

Please review the following license agreement to learn how you may or may not
use this template. Thank you.

License Agreement
https://www.vertex42.com/licensing/EULA_personaluse.html

Do not delete this worksheet.