ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
Make a copy of this sheet by going to File > Make a Copy
3
Canadian Mortgage Payment Calculator
4
5
Created by Mike Sukmanowsky as part of this blog post.
6
7
8
Inputs
9
Loan Amount $ 700,000.00
10
Rate (Nominal)5.00%
11
Amortization (Years)
30
12
Payment Frequency
Bi-weekly
13
14
Assumptions
15
Rate TypeFixed
16
17
Calculated
18
Periods per Year26
19
Effective Annual Rate
5.06%
20
Monthly Periodic Rate
0.41%
21
Monthly Payment
 $ 3,735.83
22
Periodic Payment
 $ 1,724.23
23
Periodic Rate0.19%
24
25
Schedule
26
27
Period
Starting Balance
PaymentInterestPrincipalEnding Balance
28
1 $ 700,000.00 $ 1,724.23 $ 1,330.87 $ 393.37 $ 699,606.63
29
2 $ 699,606.63 $ 1,724.23 $ 1,330.12 $ 394.11 $ 699,212.52
30
3 $ 699,212.52 $ 1,724.23 $ 1,329.37 $ 394.86 $ 698,817.66
31
4 $ 698,817.66 $ 1,724.23 $ 1,328.62 $ 395.61 $ 698,422.04
32
5 $ 698,422.04 $ 1,724.23 $ 1,327.87 $ 396.37 $ 698,025.68
33
6 $ 698,025.68 $ 1,724.23 $ 1,327.11 $ 397.12 $ 697,628.56
34
7 $ 697,628.56 $ 1,724.23 $ 1,326.36 $ 397.87 $ 697,230.68
35
8 $ 697,230.68 $ 1,724.23 $ 1,325.60 $ 398.63 $ 696,832.05
36
9 $ 696,832.05 $ 1,724.23 $ 1,324.84 $ 399.39 $ 696,432.67
37
10 $ 696,432.67 $ 1,724.23 $ 1,324.08 $ 400.15 $ 696,032.52
38
11 $ 696,032.52 $ 1,724.23 $ 1,323.32 $ 400.91 $ 695,631.61
39
12 $ 695,631.61 $ 1,724.23 $ 1,322.56 $ 401.67 $ 695,229.94
40
13 $ 695,229.94 $ 1,724.23 $ 1,321.80 $ 402.43 $ 694,827.50
41
14 $ 694,827.50 $ 1,724.23 $ 1,321.03 $ 403.20 $ 694,424.30
42
15 $ 694,424.30 $ 1,724.23 $ 1,320.27 $ 403.97 $ 694,020.34
43
16 $ 694,020.34 $ 1,724.23 $ 1,319.50 $ 404.73 $ 693,615.60
44
17 $ 693,615.60 $ 1,724.23 $ 1,318.73 $ 405.50 $ 693,210.10
45
18 $ 693,210.10 $ 1,724.23 $ 1,317.96 $ 406.27 $ 692,803.82
46
19 $ 692,803.82 $ 1,724.23 $ 1,317.18 $ 407.05 $ 692,396.78
47
20 $ 692,396.78 $ 1,724.23 $ 1,316.41 $ 407.82 $ 691,988.96
48
21 $ 691,988.96 $ 1,724.23 $ 1,315.63 $ 408.60 $ 691,580.36
49
22 $ 691,580.36 $ 1,724.23 $ 1,314.86 $ 409.37 $ 691,170.99
50
23 $ 691,170.99 $ 1,724.23 $ 1,314.08 $ 410.15 $ 690,760.83
51
24 $ 690,760.83 $ 1,724.23 $ 1,313.30 $ 410.93 $ 690,349.90
52
25 $ 690,349.90 $ 1,724.23 $ 1,312.52 $ 411.71 $ 689,938.19
53
26 $ 689,938.19 $ 1,724.23 $ 1,311.74 $ 412.50 $ 689,525.69
54
27 $ 689,525.69 $ 1,724.23 $ 1,310.95 $ 413.28 $ 689,112.41
55
28 $ 689,112.41 $ 1,724.23 $ 1,310.17 $ 414.07 $ 688,698.35
56
29 $ 688,698.35 $ 1,724.23 $ 1,309.38 $ 414.85 $ 688,283.50
57
30 $ 688,283.50 $ 1,724.23 $ 1,308.59 $ 415.64 $ 687,867.85
58
31 $ 687,867.85 $ 1,724.23 $ 1,307.80 $ 416.43 $ 687,451.42
59
32 $ 687,451.42 $ 1,724.23 $ 1,307.01 $ 417.22 $ 687,034.20
60
33 $ 687,034.20 $ 1,724.23 $ 1,306.21 $ 418.02 $ 686,616.18
61
34 $ 686,616.18 $ 1,724.23 $ 1,305.42 $ 418.81 $ 686,197.37
62
35 $ 686,197.37 $ 1,724.23 $ 1,304.62 $ 419.61 $ 685,777.76
63
36 $ 685,777.76 $ 1,724.23 $ 1,303.83 $ 420.41 $ 685,357.36
64
37 $ 685,357.36 $ 1,724.23 $ 1,303.03 $ 421.20 $ 684,936.15
65
38 $ 684,936.15 $ 1,724.23 $ 1,302.23 $ 422.01 $ 684,514.15
66
39 $ 684,514.15 $ 1,724.23 $ 1,301.42 $ 422.81 $ 684,091.34
67
40 $ 684,091.34 $ 1,724.23 $ 1,300.62 $ 423.61 $ 683,667.73
68
41 $ 683,667.73 $ 1,724.23 $ 1,299.81 $ 424.42 $ 683,243.31
69
42 $ 683,243.31 $ 1,724.23 $ 1,299.01 $ 425.22 $ 682,818.09
70
43 $ 682,818.09 $ 1,724.23 $ 1,298.20 $ 426.03 $ 682,392.05
71
44 $ 682,392.05 $ 1,724.23 $ 1,297.39 $ 426.84 $ 681,965.21
72
45 $ 681,965.21 $ 1,724.23 $ 1,296.58 $ 427.65 $ 681,537.56
73
46 $ 681,537.56 $ 1,724.23 $ 1,295.76 $ 428.47 $ 681,109.09
74
47 $ 681,109.09 $ 1,724.23 $ 1,294.95 $ 429.28 $ 680,679.81
75
48 $ 680,679.81 $ 1,724.23 $ 1,294.13 $ 430.10 $ 680,249.71
76
49 $ 680,249.71 $ 1,724.23 $ 1,293.32 $ 430.92 $ 679,818.79
77
50 $ 679,818.79 $ 1,724.23 $ 1,292.50 $ 431.73 $ 679,387.06
78
51 $ 679,387.06 $ 1,724.23 $ 1,291.68 $ 432.56 $ 678,954.50
79
52 $ 678,954.50 $ 1,724.23 $ 1,290.85 $ 433.38 $ 678,521.13
80
53 $ 678,521.13 $ 1,724.23 $ 1,290.03 $ 434.20 $ 678,086.92
81
54 $ 678,086.92 $ 1,724.23 $ 1,289.20 $ 435.03 $ 677,651.90
82
55 $ 677,651.90 $ 1,724.23 $ 1,288.38 $ 435.85 $ 677,216.04
83
56 $ 677,216.04 $ 1,724.23 $ 1,287.55 $ 436.68 $ 676,779.36
84
57 $ 676,779.36 $ 1,724.23 $ 1,286.72 $ 437.51 $ 676,341.84
85
58 $ 676,341.84 $ 1,724.23 $ 1,285.89 $ 438.35 $ 675,903.50
86
59 $ 675,903.50 $ 1,724.23 $ 1,285.05 $ 439.18 $ 675,464.32
87
60 $ 675,464.32 $ 1,724.23 $ 1,284.22 $ 440.01 $ 675,024.31
88
61 $ 675,024.31 $ 1,724.23 $ 1,283.38 $ 440.85 $ 674,583.46
89
62 $ 674,583.46 $ 1,724.23 $ 1,282.54 $ 441.69 $ 674,141.77
90
63 $ 674,141.77 $ 1,724.23 $ 1,281.70 $ 442.53 $ 673,699.24
91
64 $ 673,699.24 $ 1,724.23 $ 1,280.86 $ 443.37 $ 673,255.87
92
65 $ 673,255.87 $ 1,724.23 $ 1,280.02 $ 444.21 $ 672,811.66
93
66 $ 672,811.66 $ 1,724.23 $ 1,279.17 $ 445.06 $ 672,366.60
94
67 $ 672,366.60 $ 1,724.23 $ 1,278.33 $ 445.90 $ 671,920.70
95
68 $ 671,920.70 $ 1,724.23 $ 1,277.48 $ 446.75 $ 671,473.95
96
69 $ 671,473.95 $ 1,724.23 $ 1,276.63 $ 447.60 $ 671,026.34
97
70 $ 671,026.34 $ 1,724.23 $ 1,275.78 $ 448.45 $ 670,577.89
98
71 $ 670,577.89 $ 1,724.23 $ 1,274.93 $ 449.30 $ 670,128.59
99
72 $ 670,128.59 $ 1,724.23 $ 1,274.07 $ 450.16 $ 669,678.43
100
73 $ 669,678.43 $ 1,724.23 $ 1,273.22 $ 451.01 $ 669,227.42