Amortization schedule generator
Last updated:
Short answer
An amortization schedule splits each loan payment into interest and principal until the balance reaches zero. In Canada, fixed-rate mortgages compound semi-annually, so the periodic rate is (1 + rate ÷ 2)^(2 ÷ payments a year) − 1, which makes payments slightly lower than with monthly compounding.
Create your schedule
Regular payment
$2,908.02
Monthly
Total interest
$372,409.00
300 payments
Paid off
2051-11-01
EAR 5.063%
Balance after 5 years
$442,537.91
At renewal, 2031-11-01
Balance owing over time
Balance
| # | Date | Rate | Opening | Payment | Interest | Principal | Extra | Closing | Note |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-12-01 | 5% | $500,000.00 | $2,908.02 | $2,061.96 | $846.06 | – | $499,153.94 | |
| 2 | 2027-01-01 | 5% | $499,153.94 | $2,908.02 | $2,058.47 | $849.55 | – | $498,304.39 | |
| 3 | 2027-02-01 | 5% | $498,304.39 | $2,908.02 | $2,054.97 | $853.05 | – | $497,451.34 | |
| 4 | 2027-03-01 | 5% | $497,451.34 | $2,908.02 | $2,051.45 | $856.57 | – | $496,594.77 | |
| 5 | 2027-04-01 | 5% | $496,594.77 | $2,908.02 | $2,047.91 | $860.11 | – | $495,734.66 | |
| 6 | 2027-05-01 | 5% | $495,734.66 | $2,908.02 | $2,044.37 | $863.65 | – | $494,871.01 | |
| 7 | 2027-06-01 | 5% | $494,871.01 | $2,908.02 | $2,040.81 | $867.21 | – | $494,003.80 | |
| 8 | 2027-07-01 | 5% | $494,003.80 | $2,908.02 | $2,037.23 | $870.79 | – | $493,133.01 | |
| 9 | 2027-08-01 | 5% | $493,133.01 | $2,908.02 | $2,033.64 | $874.38 | – | $492,258.63 | |
| 10 | 2027-09-01 | 5% | $492,258.63 | $2,908.02 | $2,030.03 | $877.99 | – | $491,380.64 | |
| 11 | 2027-10-01 | 5% | $491,380.64 | $2,908.02 | $2,026.41 | $881.61 | – | $490,499.03 | |
| 12 | 2027-11-01 | 5% | $490,499.03 | $2,908.02 | $2,022.78 | $885.24 | – | $489,613.79 | |
| 13 | 2027-12-01 | 5% | $489,613.79 | $2,908.02 | $2,019.13 | $888.89 | – | $488,724.90 | |
| 14 | 2028-01-01 | 5% | $488,724.90 | $2,908.02 | $2,015.46 | $892.56 | – | $487,832.34 | |
| 15 | 2028-02-01 | 5% | $487,832.34 | $2,908.02 | $2,011.78 | $896.24 | – | $486,936.10 | |
| 16 | 2028-03-01 | 5% | $486,936.10 | $2,908.02 | $2,008.08 | $899.94 | – | $486,036.16 | |
| 17 | 2028-04-01 | 5% | $486,036.16 | $2,908.02 | $2,004.37 | $903.65 | – | $485,132.51 | |
| 18 | 2028-05-01 | 5% | $485,132.51 | $2,908.02 | $2,000.65 | $907.37 | – | $484,225.14 | |
| 19 | 2028-06-01 | 5% | $484,225.14 | $2,908.02 | $1,996.90 | $911.12 | – | $483,314.02 | |
| 20 | 2028-07-01 | 5% | $483,314.02 | $2,908.02 | $1,993.15 | $914.87 | – | $482,399.15 | |
| 21 | 2028-08-01 | 5% | $482,399.15 | $2,908.02 | $1,989.37 | $918.65 | – | $481,480.50 | |
| 22 | 2028-09-01 | 5% | $481,480.50 | $2,908.02 | $1,985.58 | $922.44 | – | $480,558.06 | |
| 23 | 2028-10-01 | 5% | $480,558.06 | $2,908.02 | $1,981.78 | $926.24 | – | $479,631.82 | |
| 24 | 2028-11-01 | 5% | $479,631.82 | $2,908.02 | $1,977.96 | $930.06 | – | $478,701.76 | |
| 25 | 2028-12-01 | 5% | $478,701.76 | $2,908.02 | $1,974.13 | $933.89 | – | $477,767.87 | |
| 26 | 2029-01-01 | 5% | $477,767.87 | $2,908.02 | $1,970.27 | $937.75 | – | $476,830.12 | |
| 27 | 2029-02-01 | 5% | $476,830.12 | $2,908.02 | $1,966.41 | $941.61 | – | $475,888.51 | |
| 28 | 2029-03-01 | 5% | $475,888.51 | $2,908.02 | $1,962.52 | $945.50 | – | $474,943.01 | |
| 29 | 2029-04-01 | 5% | $474,943.01 | $2,908.02 | $1,958.62 | $949.40 | – | $473,993.61 | |
| 30 | 2029-05-01 | 5% | $473,993.61 | $2,908.02 | $1,954.71 | $953.31 | – | $473,040.30 | |
| 31 | 2029-06-01 | 5% | $473,040.30 | $2,908.02 | $1,950.78 | $957.24 | – | $472,083.06 | |
| 32 | 2029-07-01 | 5% | $472,083.06 | $2,908.02 | $1,946.83 | $961.19 | – | $471,121.87 | |
| 33 | 2029-08-01 | 5% | $471,121.87 | $2,908.02 | $1,942.87 | $965.15 | – | $470,156.72 | |
| 34 | 2029-09-01 | 5% | $470,156.72 | $2,908.02 | $1,938.89 | $969.13 | – | $469,187.59 | |
| 35 | 2029-10-01 | 5% | $469,187.59 | $2,908.02 | $1,934.89 | $973.13 | – | $468,214.46 | |
| 36 | 2029-11-01 | 5% | $468,214.46 | $2,908.02 | $1,930.88 | $977.14 | – | $467,237.32 | |
| 37 | 2029-12-01 | 5% | $467,237.32 | $2,908.02 | $1,926.85 | $981.17 | – | $466,256.15 | |
| 38 | 2030-01-01 | 5% | $466,256.15 | $2,908.02 | $1,922.80 | $985.22 | – | $465,270.93 | |
| 39 | 2030-02-01 | 5% | $465,270.93 | $2,908.02 | $1,918.74 | $989.28 | – | $464,281.65 | |
| 40 | 2030-03-01 | 5% | $464,281.65 | $2,908.02 | $1,914.66 | $993.36 | – | $463,288.29 | |
| 41 | 2030-04-01 | 5% | $463,288.29 | $2,908.02 | $1,910.56 | $997.46 | – | $462,290.83 | |
| 42 | 2030-05-01 | 5% | $462,290.83 | $2,908.02 | $1,906.45 | $1,001.57 | – | $461,289.26 | |
| 43 | 2030-06-01 | 5% | $461,289.26 | $2,908.02 | $1,902.32 | $1,005.70 | – | $460,283.56 | |
| 44 | 2030-07-01 | 5% | $460,283.56 | $2,908.02 | $1,898.17 | $1,009.85 | – | $459,273.71 | |
| 45 | 2030-08-01 | 5% | $459,273.71 | $2,908.02 | $1,894.01 | $1,014.01 | – | $458,259.70 | |
| 46 | 2030-09-01 | 5% | $458,259.70 | $2,908.02 | $1,889.82 | $1,018.20 | – | $457,241.50 | |
| 47 | 2030-10-01 | 5% | $457,241.50 | $2,908.02 | $1,885.63 | $1,022.39 | – | $456,219.11 | |
| 48 | 2030-11-01 | 5% | $456,219.11 | $2,908.02 | $1,881.41 | $1,026.61 | – | $455,192.50 | |
| 49 | 2030-12-01 | 5% | $455,192.50 | $2,908.02 | $1,877.18 | $1,030.84 | – | $454,161.66 | |
| 50 | 2031-01-01 | 5% | $454,161.66 | $2,908.02 | $1,872.92 | $1,035.10 | – | $453,126.56 | |
| 51 | 2031-02-01 | 5% | $453,126.56 | $2,908.02 | $1,868.66 | $1,039.36 | – | $452,087.20 | |
| 52 | 2031-03-01 | 5% | $452,087.20 | $2,908.02 | $1,864.37 | $1,043.65 | – | $451,043.55 | |
| 53 | 2031-04-01 | 5% | $451,043.55 | $2,908.02 | $1,860.07 | $1,047.95 | – | $449,995.60 | |
| 54 | 2031-05-01 | 5% | $449,995.60 | $2,908.02 | $1,855.74 | $1,052.28 | – | $448,943.32 | |
| 55 | 2031-06-01 | 5% | $448,943.32 | $2,908.02 | $1,851.40 | $1,056.62 | – | $447,886.70 | |
| 56 | 2031-07-01 | 5% | $447,886.70 | $2,908.02 | $1,847.05 | $1,060.97 | – | $446,825.73 | |
| 57 | 2031-08-01 | 5% | $446,825.73 | $2,908.02 | $1,842.67 | $1,065.35 | – | $445,760.38 | |
| 58 | 2031-09-01 | 5% | $445,760.38 | $2,908.02 | $1,838.28 | $1,069.74 | – | $444,690.64 | |
| 59 | 2031-10-01 | 5% | $444,690.64 | $2,908.02 | $1,833.87 | $1,074.15 | – | $443,616.49 | |
| 60 | 2031-11-01 | 5% | $443,616.49 | $2,908.02 | $1,829.44 | $1,078.58 | – | $442,537.91 | |
| 61 | 2031-12-01 | 5% | $442,537.91 | $2,908.02 | $1,824.99 | $1,083.03 | – | $441,454.88 | |
| 62 | 2032-01-01 | 5% | $441,454.88 | $2,908.02 | $1,820.52 | $1,087.50 | – | $440,367.38 | |
| 63 | 2032-02-01 | 5% | $440,367.38 | $2,908.02 | $1,816.04 | $1,091.98 | – | $439,275.40 | |
| 64 | 2032-03-01 | 5% | $439,275.40 | $2,908.02 | $1,811.53 | $1,096.49 | – | $438,178.91 | |
| 65 | 2032-04-01 | 5% | $438,178.91 | $2,908.02 | $1,807.01 | $1,101.01 | – | $437,077.90 | |
| 66 | 2032-05-01 | 5% | $437,077.90 | $2,908.02 | $1,802.47 | $1,105.55 | – | $435,972.35 | |
| 67 | 2032-06-01 | 5% | $435,972.35 | $2,908.02 | $1,797.91 | $1,110.11 | – | $434,862.24 | |
| 68 | 2032-07-01 | 5% | $434,862.24 | $2,908.02 | $1,793.34 | $1,114.68 | – | $433,747.56 | |
| 69 | 2032-08-01 | 5% | $433,747.56 | $2,908.02 | $1,788.74 | $1,119.28 | – | $432,628.28 | |
| 70 | 2032-09-01 | 5% | $432,628.28 | $2,908.02 | $1,784.12 | $1,123.90 | – | $431,504.38 | |
| 71 | 2032-10-01 | 5% | $431,504.38 | $2,908.02 | $1,779.49 | $1,128.53 | – | $430,375.85 | |
| 72 | 2032-11-01 | 5% | $430,375.85 | $2,908.02 | $1,774.83 | $1,133.19 | – | $429,242.66 | |
| 73 | 2032-12-01 | 5% | $429,242.66 | $2,908.02 | $1,770.16 | $1,137.86 | – | $428,104.80 | |
| 74 | 2033-01-01 | 5% | $428,104.80 | $2,908.02 | $1,765.47 | $1,142.55 | – | $426,962.25 | |
| 75 | 2033-02-01 | 5% | $426,962.25 | $2,908.02 | $1,760.76 | $1,147.26 | – | $425,814.99 | |
| 76 | 2033-03-01 | 5% | $425,814.99 | $2,908.02 | $1,756.03 | $1,151.99 | – | $424,663.00 | |
| 77 | 2033-04-01 | 5% | $424,663.00 | $2,908.02 | $1,751.27 | $1,156.75 | – | $423,506.25 | |
| 78 | 2033-05-01 | 5% | $423,506.25 | $2,908.02 | $1,746.50 | $1,161.52 | – | $422,344.73 | |
| 79 | 2033-06-01 | 5% | $422,344.73 | $2,908.02 | $1,741.71 | $1,166.31 | – | $421,178.42 | |
| 80 | 2033-07-01 | 5% | $421,178.42 | $2,908.02 | $1,736.90 | $1,171.12 | – | $420,007.30 | |
| 81 | 2033-08-01 | 5% | $420,007.30 | $2,908.02 | $1,732.07 | $1,175.95 | – | $418,831.35 | |
| 82 | 2033-09-01 | 5% | $418,831.35 | $2,908.02 | $1,727.23 | $1,180.79 | – | $417,650.56 | |
| 83 | 2033-10-01 | 5% | $417,650.56 | $2,908.02 | $1,722.36 | $1,185.66 | – | $416,464.90 | |
| 84 | 2033-11-01 | 5% | $416,464.90 | $2,908.02 | $1,717.47 | $1,190.55 | – | $415,274.35 | |
| 85 | 2033-12-01 | 5% | $415,274.35 | $2,908.02 | $1,712.56 | $1,195.46 | – | $414,078.89 | |
| 86 | 2034-01-01 | 5% | $414,078.89 | $2,908.02 | $1,707.63 | $1,200.39 | – | $412,878.50 | |
| 87 | 2034-02-01 | 5% | $412,878.50 | $2,908.02 | $1,702.68 | $1,205.34 | – | $411,673.16 | |
| 88 | 2034-03-01 | 5% | $411,673.16 | $2,908.02 | $1,697.71 | $1,210.31 | – | $410,462.85 | |
| 89 | 2034-04-01 | 5% | $410,462.85 | $2,908.02 | $1,692.71 | $1,215.31 | – | $409,247.54 | |
| 90 | 2034-05-01 | 5% | $409,247.54 | $2,908.02 | $1,687.70 | $1,220.32 | – | $408,027.22 | |
| 91 | 2034-06-01 | 5% | $408,027.22 | $2,908.02 | $1,682.67 | $1,225.35 | – | $406,801.87 | |
| 92 | 2034-07-01 | 5% | $406,801.87 | $2,908.02 | $1,677.62 | $1,230.40 | – | $405,571.47 | |
| 93 | 2034-08-01 | 5% | $405,571.47 | $2,908.02 | $1,672.54 | $1,235.48 | – | $404,335.99 | |
| 94 | 2034-09-01 | 5% | $404,335.99 | $2,908.02 | $1,667.45 | $1,240.57 | – | $403,095.42 | |
| 95 | 2034-10-01 | 5% | $403,095.42 | $2,908.02 | $1,662.33 | $1,245.69 | – | $401,849.73 | |
| 96 | 2034-11-01 | 5% | $401,849.73 | $2,908.02 | $1,657.19 | $1,250.83 | – | $400,598.90 | |
| 97 | 2034-12-01 | 5% | $400,598.90 | $2,908.02 | $1,652.04 | $1,255.98 | – | $399,342.92 | |
| 98 | 2035-01-01 | 5% | $399,342.92 | $2,908.02 | $1,646.86 | $1,261.16 | – | $398,081.76 | |
| 99 | 2035-02-01 | 5% | $398,081.76 | $2,908.02 | $1,641.66 | $1,266.36 | – | $396,815.40 | |
| 100 | 2035-03-01 | 5% | $396,815.40 | $2,908.02 | $1,636.43 | $1,271.59 | – | $395,543.81 | |
| 101 | 2035-04-01 | 5% | $395,543.81 | $2,908.02 | $1,631.19 | $1,276.83 | – | $394,266.98 | |
| 102 | 2035-05-01 | 5% | $394,266.98 | $2,908.02 | $1,625.92 | $1,282.10 | – | $392,984.88 | |
| 103 | 2035-06-01 | 5% | $392,984.88 | $2,908.02 | $1,620.64 | $1,287.38 | – | $391,697.50 | |
| 104 | 2035-07-01 | 5% | $391,697.50 | $2,908.02 | $1,615.33 | $1,292.69 | – | $390,404.81 | |
| 105 | 2035-08-01 | 5% | $390,404.81 | $2,908.02 | $1,610.00 | $1,298.02 | – | $389,106.79 | |
| 106 | 2035-09-01 | 5% | $389,106.79 | $2,908.02 | $1,604.64 | $1,303.38 | – | $387,803.41 | |
| 107 | 2035-10-01 | 5% | $387,803.41 | $2,908.02 | $1,599.27 | $1,308.75 | – | $386,494.66 | |
| 108 | 2035-11-01 | 5% | $386,494.66 | $2,908.02 | $1,593.87 | $1,314.15 | – | $385,180.51 | |
| 109 | 2035-12-01 | 5% | $385,180.51 | $2,908.02 | $1,588.45 | $1,319.57 | – | $383,860.94 | |
| 110 | 2036-01-01 | 5% | $383,860.94 | $2,908.02 | $1,583.01 | $1,325.01 | – | $382,535.93 | |
| 111 | 2036-02-01 | 5% | $382,535.93 | $2,908.02 | $1,577.55 | $1,330.47 | – | $381,205.46 | |
| 112 | 2036-03-01 | 5% | $381,205.46 | $2,908.02 | $1,572.06 | $1,335.96 | – | $379,869.50 | |
| 113 | 2036-04-01 | 5% | $379,869.50 | $2,908.02 | $1,566.55 | $1,341.47 | – | $378,528.03 | |
| 114 | 2036-05-01 | 5% | $378,528.03 | $2,908.02 | $1,561.02 | $1,347.00 | – | $377,181.03 | |
| 115 | 2036-06-01 | 5% | $377,181.03 | $2,908.02 | $1,555.46 | $1,352.56 | – | $375,828.47 | |
| 116 | 2036-07-01 | 5% | $375,828.47 | $2,908.02 | $1,549.88 | $1,358.14 | – | $374,470.33 | |
| 117 | 2036-08-01 | 5% | $374,470.33 | $2,908.02 | $1,544.28 | $1,363.74 | – | $373,106.59 | |
| 118 | 2036-09-01 | 5% | $373,106.59 | $2,908.02 | $1,538.66 | $1,369.36 | – | $371,737.23 | |
| 119 | 2036-10-01 | 5% | $371,737.23 | $2,908.02 | $1,533.01 | $1,375.01 | – | $370,362.22 | |
| 120 | 2036-11-01 | 5% | $370,362.22 | $2,908.02 | $1,527.34 | $1,380.68 | – | $368,981.54 | |
| 121 | 2036-12-01 | 5% | $368,981.54 | $2,908.02 | $1,521.65 | $1,386.37 | – | $367,595.17 | |
| 122 | 2037-01-01 | 5% | $367,595.17 | $2,908.02 | $1,515.93 | $1,392.09 | – | $366,203.08 | |
| 123 | 2037-02-01 | 5% | $366,203.08 | $2,908.02 | $1,510.19 | $1,397.83 | – | $364,805.25 | |
| 124 | 2037-03-01 | 5% | $364,805.25 | $2,908.02 | $1,504.43 | $1,403.59 | – | $363,401.66 | |
| 125 | 2037-04-01 | 5% | $363,401.66 | $2,908.02 | $1,498.64 | $1,409.38 | – | $361,992.28 | |
| 126 | 2037-05-01 | 5% | $361,992.28 | $2,908.02 | $1,492.83 | $1,415.19 | – | $360,577.09 | |
| 127 | 2037-06-01 | 5% | $360,577.09 | $2,908.02 | $1,486.99 | $1,421.03 | – | $359,156.06 | |
| 128 | 2037-07-01 | 5% | $359,156.06 | $2,908.02 | $1,481.13 | $1,426.89 | – | $357,729.17 | |
| 129 | 2037-08-01 | 5% | $357,729.17 | $2,908.02 | $1,475.24 | $1,432.78 | – | $356,296.39 | |
| 130 | 2037-09-01 | 5% | $356,296.39 | $2,908.02 | $1,469.34 | $1,438.68 | – | $354,857.71 | |
| 131 | 2037-10-01 | 5% | $354,857.71 | $2,908.02 | $1,463.40 | $1,444.62 | – | $353,413.09 | |
| 132 | 2037-11-01 | 5% | $353,413.09 | $2,908.02 | $1,457.45 | $1,450.57 | – | $351,962.52 | |
| 133 | 2037-12-01 | 5% | $351,962.52 | $2,908.02 | $1,451.46 | $1,456.56 | – | $350,505.96 | |
| 134 | 2038-01-01 | 5% | $350,505.96 | $2,908.02 | $1,445.46 | $1,462.56 | – | $349,043.40 | |
| 135 | 2038-02-01 | 5% | $349,043.40 | $2,908.02 | $1,439.43 | $1,468.59 | – | $347,574.81 | |
| 136 | 2038-03-01 | 5% | $347,574.81 | $2,908.02 | $1,433.37 | $1,474.65 | – | $346,100.16 | |
| 137 | 2038-04-01 | 5% | $346,100.16 | $2,908.02 | $1,427.29 | $1,480.73 | – | $344,619.43 | |
| 138 | 2038-05-01 | 5% | $344,619.43 | $2,908.02 | $1,421.18 | $1,486.84 | – | $343,132.59 | |
| 139 | 2038-06-01 | 5% | $343,132.59 | $2,908.02 | $1,415.05 | $1,492.97 | – | $341,639.62 | |
| 140 | 2038-07-01 | 5% | $341,639.62 | $2,908.02 | $1,408.89 | $1,499.13 | – | $340,140.49 | |
| 141 | 2038-08-01 | 5% | $340,140.49 | $2,908.02 | $1,402.71 | $1,505.31 | – | $338,635.18 | |
| 142 | 2038-09-01 | 5% | $338,635.18 | $2,908.02 | $1,396.50 | $1,511.52 | – | $337,123.66 | |
| 143 | 2038-10-01 | 5% | $337,123.66 | $2,908.02 | $1,390.27 | $1,517.75 | – | $335,605.91 | |
| 144 | 2038-11-01 | 5% | $335,605.91 | $2,908.02 | $1,384.01 | $1,524.01 | – | $334,081.90 | |
| 145 | 2038-12-01 | 5% | $334,081.90 | $2,908.02 | $1,377.73 | $1,530.29 | – | $332,551.61 | |
| 146 | 2039-01-01 | 5% | $332,551.61 | $2,908.02 | $1,371.41 | $1,536.61 | – | $331,015.00 | |
| 147 | 2039-02-01 | 5% | $331,015.00 | $2,908.02 | $1,365.08 | $1,542.94 | – | $329,472.06 | |
| 148 | 2039-03-01 | 5% | $329,472.06 | $2,908.02 | $1,358.71 | $1,549.31 | – | $327,922.75 | |
| 149 | 2039-04-01 | 5% | $327,922.75 | $2,908.02 | $1,352.33 | $1,555.69 | – | $326,367.06 | |
| 150 | 2039-05-01 | 5% | $326,367.06 | $2,908.02 | $1,345.91 | $1,562.11 | – | $324,804.95 | |
| 151 | 2039-06-01 | 5% | $324,804.95 | $2,908.02 | $1,339.47 | $1,568.55 | – | $323,236.40 | |
| 152 | 2039-07-01 | 5% | $323,236.40 | $2,908.02 | $1,333.00 | $1,575.02 | – | $321,661.38 | |
| 153 | 2039-08-01 | 5% | $321,661.38 | $2,908.02 | $1,326.50 | $1,581.52 | – | $320,079.86 | |
| 154 | 2039-09-01 | 5% | $320,079.86 | $2,908.02 | $1,319.98 | $1,588.04 | – | $318,491.82 | |
| 155 | 2039-10-01 | 5% | $318,491.82 | $2,908.02 | $1,313.43 | $1,594.59 | – | $316,897.23 | |
| 156 | 2039-11-01 | 5% | $316,897.23 | $2,908.02 | $1,306.86 | $1,601.16 | – | $315,296.07 | |
| 157 | 2039-12-01 | 5% | $315,296.07 | $2,908.02 | $1,300.25 | $1,607.77 | – | $313,688.30 | |
| 158 | 2040-01-01 | 5% | $313,688.30 | $2,908.02 | $1,293.62 | $1,614.40 | – | $312,073.90 | |
| 159 | 2040-02-01 | 5% | $312,073.90 | $2,908.02 | $1,286.97 | $1,621.05 | – | $310,452.85 | |
| 160 | 2040-03-01 | 5% | $310,452.85 | $2,908.02 | $1,280.28 | $1,627.74 | – | $308,825.11 | |
| 161 | 2040-04-01 | 5% | $308,825.11 | $2,908.02 | $1,273.57 | $1,634.45 | – | $307,190.66 | |
| 162 | 2040-05-01 | 5% | $307,190.66 | $2,908.02 | $1,266.83 | $1,641.19 | – | $305,549.47 | |
| 163 | 2040-06-01 | 5% | $305,549.47 | $2,908.02 | $1,260.06 | $1,647.96 | – | $303,901.51 | |
| 164 | 2040-07-01 | 5% | $303,901.51 | $2,908.02 | $1,253.26 | $1,654.76 | – | $302,246.75 | |
| 165 | 2040-08-01 | 5% | $302,246.75 | $2,908.02 | $1,246.44 | $1,661.58 | – | $300,585.17 | |
| 166 | 2040-09-01 | 5% | $300,585.17 | $2,908.02 | $1,239.59 | $1,668.43 | – | $298,916.74 | |
| 167 | 2040-10-01 | 5% | $298,916.74 | $2,908.02 | $1,232.71 | $1,675.31 | – | $297,241.43 | |
| 168 | 2040-11-01 | 5% | $297,241.43 | $2,908.02 | $1,225.80 | $1,682.22 | – | $295,559.21 | |
| 169 | 2040-12-01 | 5% | $295,559.21 | $2,908.02 | $1,218.86 | $1,689.16 | – | $293,870.05 | |
| 170 | 2041-01-01 | 5% | $293,870.05 | $2,908.02 | $1,211.90 | $1,696.12 | – | $292,173.93 | |
| 171 | 2041-02-01 | 5% | $292,173.93 | $2,908.02 | $1,204.90 | $1,703.12 | – | $290,470.81 | |
| 172 | 2041-03-01 | 5% | $290,470.81 | $2,908.02 | $1,197.88 | $1,710.14 | – | $288,760.67 | |
| 173 | 2041-04-01 | 5% | $288,760.67 | $2,908.02 | $1,190.82 | $1,717.20 | – | $287,043.47 | |
| 174 | 2041-05-01 | 5% | $287,043.47 | $2,908.02 | $1,183.74 | $1,724.28 | – | $285,319.19 | |
| 175 | 2041-06-01 | 5% | $285,319.19 | $2,908.02 | $1,176.63 | $1,731.39 | – | $283,587.80 | |
| 176 | 2041-07-01 | 5% | $283,587.80 | $2,908.02 | $1,169.49 | $1,738.53 | – | $281,849.27 | |
| 177 | 2041-08-01 | 5% | $281,849.27 | $2,908.02 | $1,162.32 | $1,745.70 | – | $280,103.57 | |
| 178 | 2041-09-01 | 5% | $280,103.57 | $2,908.02 | $1,155.12 | $1,752.90 | – | $278,350.67 | |
| 179 | 2041-10-01 | 5% | $278,350.67 | $2,908.02 | $1,147.89 | $1,760.13 | – | $276,590.54 | |
| 180 | 2041-11-01 | 5% | $276,590.54 | $2,908.02 | $1,140.64 | $1,767.38 | – | $274,823.16 | |
| 181 | 2041-12-01 | 5% | $274,823.16 | $2,908.02 | $1,133.35 | $1,774.67 | – | $273,048.49 | |
| 182 | 2042-01-01 | 5% | $273,048.49 | $2,908.02 | $1,126.03 | $1,781.99 | – | $271,266.50 | |
| 183 | 2042-02-01 | 5% | $271,266.50 | $2,908.02 | $1,118.68 | $1,789.34 | – | $269,477.16 | |
| 184 | 2042-03-01 | 5% | $269,477.16 | $2,908.02 | $1,111.30 | $1,796.72 | – | $267,680.44 | |
| 185 | 2042-04-01 | 5% | $267,680.44 | $2,908.02 | $1,103.89 | $1,804.13 | – | $265,876.31 | |
| 186 | 2042-05-01 | 5% | $265,876.31 | $2,908.02 | $1,096.45 | $1,811.57 | – | $264,064.74 | |
| 187 | 2042-06-01 | 5% | $264,064.74 | $2,908.02 | $1,088.98 | $1,819.04 | – | $262,245.70 | |
| 188 | 2042-07-01 | 5% | $262,245.70 | $2,908.02 | $1,081.48 | $1,826.54 | – | $260,419.16 | |
| 189 | 2042-08-01 | 5% | $260,419.16 | $2,908.02 | $1,073.95 | $1,834.07 | – | $258,585.09 | |
| 190 | 2042-09-01 | 5% | $258,585.09 | $2,908.02 | $1,066.38 | $1,841.64 | – | $256,743.45 | |
| 191 | 2042-10-01 | 5% | $256,743.45 | $2,908.02 | $1,058.79 | $1,849.23 | – | $254,894.22 | |
| 192 | 2042-11-01 | 5% | $254,894.22 | $2,908.02 | $1,051.16 | $1,856.86 | – | $253,037.36 | |
| 193 | 2042-12-01 | 5% | $253,037.36 | $2,908.02 | $1,043.50 | $1,864.52 | – | $251,172.84 | |
| 194 | 2043-01-01 | 5% | $251,172.84 | $2,908.02 | $1,035.82 | $1,872.20 | – | $249,300.64 | |
| 195 | 2043-02-01 | 5% | $249,300.64 | $2,908.02 | $1,028.09 | $1,879.93 | – | $247,420.71 | |
| 196 | 2043-03-01 | 5% | $247,420.71 | $2,908.02 | $1,020.34 | $1,887.68 | – | $245,533.03 | |
| 197 | 2043-04-01 | 5% | $245,533.03 | $2,908.02 | $1,012.56 | $1,895.46 | – | $243,637.57 | |
| 198 | 2043-05-01 | 5% | $243,637.57 | $2,908.02 | $1,004.74 | $1,903.28 | – | $241,734.29 | |
| 199 | 2043-06-01 | 5% | $241,734.29 | $2,908.02 | $996.89 | $1,911.13 | – | $239,823.16 | |
| 200 | 2043-07-01 | 5% | $239,823.16 | $2,908.02 | $989.01 | $1,919.01 | – | $237,904.15 | |
| 201 | 2043-08-01 | 5% | $237,904.15 | $2,908.02 | $981.10 | $1,926.92 | – | $235,977.23 | |
| 202 | 2043-09-01 | 5% | $235,977.23 | $2,908.02 | $973.15 | $1,934.87 | – | $234,042.36 | |
| 203 | 2043-10-01 | 5% | $234,042.36 | $2,908.02 | $965.17 | $1,942.85 | – | $232,099.51 | |
| 204 | 2043-11-01 | 5% | $232,099.51 | $2,908.02 | $957.16 | $1,950.86 | – | $230,148.65 | |
| 205 | 2043-12-01 | 5% | $230,148.65 | $2,908.02 | $949.11 | $1,958.91 | – | $228,189.74 | |
| 206 | 2044-01-01 | 5% | $228,189.74 | $2,908.02 | $941.04 | $1,966.98 | – | $226,222.76 | |
| 207 | 2044-02-01 | 5% | $226,222.76 | $2,908.02 | $932.92 | $1,975.10 | – | $224,247.66 | |
| 208 | 2044-03-01 | 5% | $224,247.66 | $2,908.02 | $924.78 | $1,983.24 | – | $222,264.42 | |
| 209 | 2044-04-01 | 5% | $222,264.42 | $2,908.02 | $916.60 | $1,991.42 | – | $220,273.00 | |
| 210 | 2044-05-01 | 5% | $220,273.00 | $2,908.02 | $908.39 | $1,999.63 | – | $218,273.37 | |
| 211 | 2044-06-01 | 5% | $218,273.37 | $2,908.02 | $900.14 | $2,007.88 | – | $216,265.49 | |
| 212 | 2044-07-01 | 5% | $216,265.49 | $2,908.02 | $891.86 | $2,016.16 | – | $214,249.33 | |
| 213 | 2044-08-01 | 5% | $214,249.33 | $2,908.02 | $883.55 | $2,024.47 | – | $212,224.86 | |
| 214 | 2044-09-01 | 5% | $212,224.86 | $2,908.02 | $875.20 | $2,032.82 | – | $210,192.04 | |
| 215 | 2044-10-01 | 5% | $210,192.04 | $2,908.02 | $866.81 | $2,041.21 | – | $208,150.83 | |
| 216 | 2044-11-01 | 5% | $208,150.83 | $2,908.02 | $858.40 | $2,049.62 | – | $206,101.21 | |
| 217 | 2044-12-01 | 5% | $206,101.21 | $2,908.02 | $849.94 | $2,058.08 | – | $204,043.13 | |
| 218 | 2045-01-01 | 5% | $204,043.13 | $2,908.02 | $841.46 | $2,066.56 | – | $201,976.57 | |
| 219 | 2045-02-01 | 5% | $201,976.57 | $2,908.02 | $832.93 | $2,075.09 | – | $199,901.48 | |
| 220 | 2045-03-01 | 5% | $199,901.48 | $2,908.02 | $824.38 | $2,083.64 | – | $197,817.84 | |
| 221 | 2045-04-01 | 5% | $197,817.84 | $2,908.02 | $815.78 | $2,092.24 | – | $195,725.60 | |
| 222 | 2045-05-01 | 5% | $195,725.60 | $2,908.02 | $807.16 | $2,100.86 | – | $193,624.74 | |
| 223 | 2045-06-01 | 5% | $193,624.74 | $2,908.02 | $798.49 | $2,109.53 | – | $191,515.21 | |
| 224 | 2045-07-01 | 5% | $191,515.21 | $2,908.02 | $789.79 | $2,118.23 | – | $189,396.98 | |
| 225 | 2045-08-01 | 5% | $189,396.98 | $2,908.02 | $781.06 | $2,126.96 | – | $187,270.02 | |
| 226 | 2045-09-01 | 5% | $187,270.02 | $2,908.02 | $772.29 | $2,135.73 | – | $185,134.29 | |
| 227 | 2045-10-01 | 5% | $185,134.29 | $2,908.02 | $763.48 | $2,144.54 | – | $182,989.75 | |
| 228 | 2045-11-01 | 5% | $182,989.75 | $2,908.02 | $754.63 | $2,153.39 | – | $180,836.36 | |
| 229 | 2045-12-01 | 5% | $180,836.36 | $2,908.02 | $745.75 | $2,162.27 | – | $178,674.09 | |
| 230 | 2046-01-01 | 5% | $178,674.09 | $2,908.02 | $736.84 | $2,171.18 | – | $176,502.91 | |
| 231 | 2046-02-01 | 5% | $176,502.91 | $2,908.02 | $727.88 | $2,180.14 | – | $174,322.77 | |
| 232 | 2046-03-01 | 5% | $174,322.77 | $2,908.02 | $718.89 | $2,189.13 | – | $172,133.64 | |
| 233 | 2046-04-01 | 5% | $172,133.64 | $2,908.02 | $709.86 | $2,198.16 | – | $169,935.48 | |
| 234 | 2046-05-01 | 5% | $169,935.48 | $2,908.02 | $700.80 | $2,207.22 | – | $167,728.26 | |
| 235 | 2046-06-01 | 5% | $167,728.26 | $2,908.02 | $691.70 | $2,216.32 | – | $165,511.94 | |
| 236 | 2046-07-01 | 5% | $165,511.94 | $2,908.02 | $682.56 | $2,225.46 | – | $163,286.48 | |
| 237 | 2046-08-01 | 5% | $163,286.48 | $2,908.02 | $673.38 | $2,234.64 | – | $161,051.84 | |
| 238 | 2046-09-01 | 5% | $161,051.84 | $2,908.02 | $664.16 | $2,243.86 | – | $158,807.98 | |
| 239 | 2046-10-01 | 5% | $158,807.98 | $2,908.02 | $654.91 | $2,253.11 | – | $156,554.87 | |
| 240 | 2046-11-01 | 5% | $156,554.87 | $2,908.02 | $645.62 | $2,262.40 | – | $154,292.47 | |
| 241 | 2046-12-01 | 5% | $154,292.47 | $2,908.02 | $636.29 | $2,271.73 | – | $152,020.74 | |
| 242 | 2047-01-01 | 5% | $152,020.74 | $2,908.02 | $626.92 | $2,281.10 | – | $149,739.64 | |
| 243 | 2047-02-01 | 5% | $149,739.64 | $2,908.02 | $617.51 | $2,290.51 | – | $147,449.13 | |
| 244 | 2047-03-01 | 5% | $147,449.13 | $2,908.02 | $608.07 | $2,299.95 | – | $145,149.18 | |
| 245 | 2047-04-01 | 5% | $145,149.18 | $2,908.02 | $598.58 | $2,309.44 | – | $142,839.74 | |
| 246 | 2047-05-01 | 5% | $142,839.74 | $2,908.02 | $589.06 | $2,318.96 | – | $140,520.78 | |
| 247 | 2047-06-01 | 5% | $140,520.78 | $2,908.02 | $579.50 | $2,328.52 | – | $138,192.26 | |
| 248 | 2047-07-01 | 5% | $138,192.26 | $2,908.02 | $569.89 | $2,338.13 | – | $135,854.13 | |
| 249 | 2047-08-01 | 5% | $135,854.13 | $2,908.02 | $560.25 | $2,347.77 | – | $133,506.36 | |
| 250 | 2047-09-01 | 5% | $133,506.36 | $2,908.02 | $550.57 | $2,357.45 | – | $131,148.91 | |
| 251 | 2047-10-01 | 5% | $131,148.91 | $2,908.02 | $540.85 | $2,367.17 | – | $128,781.74 | |
| 252 | 2047-11-01 | 5% | $128,781.74 | $2,908.02 | $531.09 | $2,376.93 | – | $126,404.81 | |
| 253 | 2047-12-01 | 5% | $126,404.81 | $2,908.02 | $521.28 | $2,386.74 | – | $124,018.07 | |
| 254 | 2048-01-01 | 5% | $124,018.07 | $2,908.02 | $511.44 | $2,396.58 | – | $121,621.49 | |
| 255 | 2048-02-01 | 5% | $121,621.49 | $2,908.02 | $501.56 | $2,406.46 | – | $119,215.03 | |
| 256 | 2048-03-01 | 5% | $119,215.03 | $2,908.02 | $491.63 | $2,416.39 | – | $116,798.64 | |
| 257 | 2048-04-01 | 5% | $116,798.64 | $2,908.02 | $481.67 | $2,426.35 | – | $114,372.29 | |
| 258 | 2048-05-01 | 5% | $114,372.29 | $2,908.02 | $471.66 | $2,436.36 | – | $111,935.93 | |
| 259 | 2048-06-01 | 5% | $111,935.93 | $2,908.02 | $461.61 | $2,446.41 | – | $109,489.52 | |
| 260 | 2048-07-01 | 5% | $109,489.52 | $2,908.02 | $451.53 | $2,456.49 | – | $107,033.03 | |
| 261 | 2048-08-01 | 5% | $107,033.03 | $2,908.02 | $441.40 | $2,466.62 | – | $104,566.41 | |
| 262 | 2048-09-01 | 5% | $104,566.41 | $2,908.02 | $431.22 | $2,476.80 | – | $102,089.61 | |
| 263 | 2048-10-01 | 5% | $102,089.61 | $2,908.02 | $421.01 | $2,487.01 | – | $99,602.60 | |
| 264 | 2048-11-01 | 5% | $99,602.60 | $2,908.02 | $410.75 | $2,497.27 | – | $97,105.33 | |
| 265 | 2048-12-01 | 5% | $97,105.33 | $2,908.02 | $400.45 | $2,507.57 | – | $94,597.76 | |
| 266 | 2049-01-01 | 5% | $94,597.76 | $2,908.02 | $390.11 | $2,517.91 | – | $92,079.85 | |
| 267 | 2049-02-01 | 5% | $92,079.85 | $2,908.02 | $379.73 | $2,528.29 | – | $89,551.56 | |
| 268 | 2049-03-01 | 5% | $89,551.56 | $2,908.02 | $369.30 | $2,538.72 | – | $87,012.84 | |
| 269 | 2049-04-01 | 5% | $87,012.84 | $2,908.02 | $358.83 | $2,549.19 | – | $84,463.65 | |
| 270 | 2049-05-01 | 5% | $84,463.65 | $2,908.02 | $348.32 | $2,559.70 | – | $81,903.95 | |
| 271 | 2049-06-01 | 5% | $81,903.95 | $2,908.02 | $337.76 | $2,570.26 | – | $79,333.69 | |
| 272 | 2049-07-01 | 5% | $79,333.69 | $2,908.02 | $327.17 | $2,580.85 | – | $76,752.84 | |
| 273 | 2049-08-01 | 5% | $76,752.84 | $2,908.02 | $316.52 | $2,591.50 | – | $74,161.34 | |
| 274 | 2049-09-01 | 5% | $74,161.34 | $2,908.02 | $305.84 | $2,602.18 | – | $71,559.16 | |
| 275 | 2049-10-01 | 5% | $71,559.16 | $2,908.02 | $295.10 | $2,612.92 | – | $68,946.24 | |
| 276 | 2049-11-01 | 5% | $68,946.24 | $2,908.02 | $284.33 | $2,623.69 | – | $66,322.55 | |
| 277 | 2049-12-01 | 5% | $66,322.55 | $2,908.02 | $273.51 | $2,634.51 | – | $63,688.04 | |
| 278 | 2050-01-01 | 5% | $63,688.04 | $2,908.02 | $262.64 | $2,645.38 | – | $61,042.66 | |
| 279 | 2050-02-01 | 5% | $61,042.66 | $2,908.02 | $251.73 | $2,656.29 | – | $58,386.37 | |
| 280 | 2050-03-01 | 5% | $58,386.37 | $2,908.02 | $240.78 | $2,667.24 | – | $55,719.13 | |
| 281 | 2050-04-01 | 5% | $55,719.13 | $2,908.02 | $229.78 | $2,678.24 | – | $53,040.89 | |
| 282 | 2050-05-01 | 5% | $53,040.89 | $2,908.02 | $218.74 | $2,689.28 | – | $50,351.61 | |
| 283 | 2050-06-01 | 5% | $50,351.61 | $2,908.02 | $207.65 | $2,700.37 | – | $47,651.24 | |
| 284 | 2050-07-01 | 5% | $47,651.24 | $2,908.02 | $196.51 | $2,711.51 | – | $44,939.73 | |
| 285 | 2050-08-01 | 5% | $44,939.73 | $2,908.02 | $185.33 | $2,722.69 | – | $42,217.04 | |
| 286 | 2050-09-01 | 5% | $42,217.04 | $2,908.02 | $174.10 | $2,733.92 | – | $39,483.12 | |
| 287 | 2050-10-01 | 5% | $39,483.12 | $2,908.02 | $162.83 | $2,745.19 | – | $36,737.93 | |
| 288 | 2050-11-01 | 5% | $36,737.93 | $2,908.02 | $151.50 | $2,756.52 | – | $33,981.41 | |
| 289 | 2050-12-01 | 5% | $33,981.41 | $2,908.02 | $140.14 | $2,767.88 | – | $31,213.53 | |
| 290 | 2051-01-01 | 5% | $31,213.53 | $2,908.02 | $128.72 | $2,779.30 | – | $28,434.23 | |
| 291 | 2051-02-01 | 5% | $28,434.23 | $2,908.02 | $117.26 | $2,790.76 | – | $25,643.47 | |
| 292 | 2051-03-01 | 5% | $25,643.47 | $2,908.02 | $105.75 | $2,802.27 | – | $22,841.20 | |
| 293 | 2051-04-01 | 5% | $22,841.20 | $2,908.02 | $94.20 | $2,813.82 | – | $20,027.38 | |
| 294 | 2051-05-01 | 5% | $20,027.38 | $2,908.02 | $82.59 | $2,825.43 | – | $17,201.95 | |
| 295 | 2051-06-01 | 5% | $17,201.95 | $2,908.02 | $70.94 | $2,837.08 | – | $14,364.87 | |
| 296 | 2051-07-01 | 5% | $14,364.87 | $2,908.02 | $59.24 | $2,848.78 | – | $11,516.09 | |
| 297 | 2051-08-01 | 5% | $11,516.09 | $2,908.02 | $47.49 | $2,860.53 | – | $8,655.56 | |
| 298 | 2051-09-01 | 5% | $8,655.56 | $2,908.02 | $35.69 | $2,872.33 | – | $5,783.23 | |
| 299 | 2051-10-01 | 5% | $5,783.23 | $2,908.02 | $23.85 | $2,884.17 | – | $2,899.06 | |
| 300 | 2051-11-01 | 5% | $2,899.06 | $2,911.02 | $11.96 | $2,899.06 | – | $0.00 |
What does a $500,000 mortgage at 5% cost?
Over 25 years with semi-annual compounding, the monthly payment is $2,908.02 and total interest is $372,409.00. After a 5-year term, $442,537.91 is still owing at renewal.
Switching to accelerated bi-weekly payments of $1,454.01 cuts total interest to $311,972.64.
How do I build an amortization schedule?
- 1
Convert the rate
Periodic rate = (1 + annual rate ÷ compounding periods) ^ (compounding periods ÷ payments a year) − 1. Canadian fixed-rate mortgages compound twice a year.
- 2
Find the payment
Payment = loan × i ÷ (1 − (1 + i)^−n), where n is the number of payments over the amortization.
- 3
Split each payment
Interest = opening balance × periodic rate, rounded to the cent. Principal = payment − interest, plus any prepayment.
- 4
Roll the balance forward
Closing balance = opening balance − principal. Adjust the last payment so the balance ends at exactly zero.
Frequently asked questions
Why does compounding change my mortgage payment?
Canadian fixed-rate mortgages compound semi-annually by law. On $500,000.00 at 5% over 25 years the monthly payment is $2,908.02 with semi-annual compounding and $2,922.95 with monthly compounding.
How much do accelerated bi-weekly payments save?
Paying half the monthly payment every two weeks adds the equivalent of one extra monthly payment a year. In the example it saves $60,436.36 of interest and pays the mortgage off on 2048-05-22 instead of 2051-12-01.
Can I open the schedule in Excel?
Yes. The Excel export is a real .xlsx workbook with a summary sheet, the full payment schedule with totals formulas, and a year-by-year sheet.
Where do these numbers come from?
Calculations use decimal arithmetic, rounding interest to the cent each payment. Your lender's figures can differ slightly because of its own rounding and payment dates.