Advertisement

Mortgage prepayment calculator

Compare a dated prepayment plan with the same mortgage paid without extra amounts.

Calculator

Regular payment before extras
$2,326.42
Interest with prepayments
$261,846.64
Interest saved
$36,079.34
Payments with prepayments
271
Payments without prepayments
300
Years saved
2.4167
Final payment
$1,713.26
Prepayment plan payoff date
2049-05-01
Baseline payoff date
2051-10-01
Prepayment amortization schedule
PaymentDue dateAmount ($)Interest ($)Principal ($)Balance ($)
1.002026-11-012,426.421,649.57776.85399,223.15
2.002026-12-012,426.421,646.36780.06398,443.09
3.002027-01-012,426.421,643.15783.27397,659.81
4.002027-02-012,426.421,639.92786.50396,873.31
5.002027-03-012,426.421,636.67789.75396,083.56
6.002027-04-012,426.421,633.42793.00395,290.56
7.002027-05-012,426.421,630.14796.28394,494.28
8.002027-06-012,426.421,626.86799.56393,694.72
9.002027-07-012,426.421,623.56802.86392,891.87
10.002027-08-012,426.421,620.25806.17392,085.70
11.002027-09-012,426.421,616.93809.49391,276.21
12.002027-10-012,426.421,613.59812.83390,463.38
13.002027-11-017,426.421,610.245,816.18384,647.20
14.002027-12-012,426.421,586.25840.17383,807.03
15.002028-01-012,426.421,582.79843.63382,963.40
16.002028-02-012,426.421,579.31847.11382,116.29
17.002028-03-012,426.421,575.82850.60381,265.68
18.002028-04-012,426.421,572.31854.11380,411.57
19.002028-05-012,426.421,568.79857.63379,553.93
20.002028-06-012,426.421,565.25861.17378,692.76
21.002028-07-012,426.421,561.70864.72377,828.04
22.002028-08-012,426.421,558.13868.29376,959.75
23.002028-09-012,426.421,554.55871.87376,087.88
24.002028-10-012,426.421,550.95875.47375,212.41
25.002028-11-012,426.421,547.34879.08374,333.34
26.002028-12-012,426.421,543.72882.70373,450.64
27.002029-01-012,426.421,540.08886.34372,564.30
28.002029-02-012,426.421,536.42890.00371,674.30
29.002029-03-012,426.421,532.75893.67370,780.63
30.002029-04-012,426.421,529.07897.35369,883.28
31.002029-05-012,426.421,525.37901.05368,982.23
32.002029-06-012,426.421,521.65904.77368,077.46
33.002029-07-012,426.421,517.92908.50367,168.96
34.002029-08-012,426.421,514.17912.25366,256.72
35.002029-09-012,426.421,510.41916.01365,340.71
36.002029-10-012,426.421,506.63919.79364,420.92
37.002029-11-012,426.421,502.84923.58363,497.34
38.002029-12-012,426.421,499.03927.39362,569.96
39.002030-01-012,426.421,495.21931.21361,638.74
40.002030-02-012,426.421,491.37935.05360,703.69
41.002030-03-012,426.421,487.51938.91359,764.78
42.002030-04-012,426.421,483.64942.78358,822.00
43.002030-05-012,426.421,479.75946.67357,875.33
44.002030-06-012,426.421,475.85950.57356,924.76
45.002030-07-012,426.421,471.93954.49355,970.27
46.002030-08-012,426.421,467.99958.43355,011.84
47.002030-09-012,426.421,464.04962.38354,049.46
48.002030-10-012,426.421,460.07966.35353,083.11
49.002030-11-012,426.421,456.08970.34352,112.77
50.002030-12-012,426.421,452.08974.34351,138.44
51.002031-01-012,426.421,448.07978.35350,160.08
52.002031-02-012,426.421,444.03982.39349,177.69
53.002031-03-012,426.421,439.98986.44348,191.25
54.002031-04-012,426.421,435.91990.51347,200.74
55.002031-05-012,426.421,431.83994.59346,206.15
56.002031-06-012,426.421,427.72998.70345,207.46
57.002031-07-012,426.421,423.611,002.81344,204.64
58.002031-08-012,426.421,419.471,006.95343,197.69
59.002031-09-012,426.421,415.321,011.10342,186.59
60.002031-10-012,426.421,411.151,015.27341,171.32
61.002031-11-012,426.421,406.961,019.46340,151.86
62.002031-12-012,426.421,402.761,023.66339,128.20
63.002032-01-012,426.421,398.541,027.88338,100.32
64.002032-02-012,426.421,394.301,032.12337,068.19
65.002032-03-012,426.421,390.041,036.38336,031.81
66.002032-04-012,426.421,385.771,040.65334,991.16
67.002032-05-012,426.421,381.481,044.94333,946.22
68.002032-06-012,426.421,377.171,049.25332,896.96
69.002032-07-012,426.421,372.841,053.58331,843.38
70.002032-08-012,426.421,368.491,057.93330,785.45
71.002032-09-012,426.421,364.131,062.29329,723.17
72.002032-10-012,426.421,359.751,066.67328,656.50
73.002032-11-012,426.421,355.351,071.07327,585.43
74.002032-12-012,426.421,350.931,075.49326,509.94
75.002033-01-012,426.421,346.501,079.92325,430.02
76.002033-02-012,426.421,342.051,084.37324,345.65
77.002033-03-012,426.421,337.571,088.85323,256.80
78.002033-04-012,426.421,333.081,093.34322,163.47
79.002033-05-012,426.421,328.571,097.85321,065.62
80.002033-06-012,426.421,324.051,102.37319,963.25
81.002033-07-012,426.421,319.501,106.92318,856.33
82.002033-08-012,426.421,314.941,111.48317,744.85
83.002033-09-012,426.421,310.351,116.07316,628.78
84.002033-10-012,426.421,305.751,120.67315,508.11
85.002033-11-012,426.421,301.131,125.29314,382.82
86.002033-12-012,426.421,296.491,129.93313,252.89
87.002034-01-012,426.421,291.831,134.59312,118.30
88.002034-02-012,426.421,287.151,139.27310,979.03
89.002034-03-012,426.421,282.451,143.97309,835.06
90.002034-04-012,426.421,277.731,148.69308,686.37
91.002034-05-012,426.421,273.001,153.42307,532.95
92.002034-06-012,426.421,268.241,158.18306,374.77
93.002034-07-012,426.421,263.461,162.96305,211.81
94.002034-08-012,426.421,258.671,167.75304,044.06
95.002034-09-012,426.421,253.851,172.57302,871.49
96.002034-10-012,426.421,249.021,177.40301,694.09
97.002034-11-012,426.421,244.161,182.26300,511.83
98.002034-12-012,426.421,239.291,187.13299,324.69
99.002035-01-012,426.421,234.391,192.03298,132.66
100.002035-02-012,426.421,229.471,196.95296,935.72
101.002035-03-012,426.421,224.541,201.88295,733.83
102.002035-04-012,426.421,219.581,206.84294,527.00
103.002035-05-012,426.421,214.601,211.82293,315.18
104.002035-06-012,426.421,209.611,216.81292,098.37
105.002035-07-012,426.421,204.591,221.83290,876.54
106.002035-08-012,426.421,199.551,226.87289,649.67
107.002035-09-012,426.421,194.491,231.93288,417.74
108.002035-10-012,426.421,189.411,237.01287,180.73
109.002035-11-012,426.421,184.311,242.11285,938.62
110.002035-12-012,426.421,179.191,247.23284,691.38
111.002036-01-012,426.421,174.041,252.38283,439.01
112.002036-02-012,426.421,168.881,257.54282,181.47
113.002036-03-012,426.421,163.691,262.73280,918.74
114.002036-04-012,426.421,158.491,267.93279,650.80
115.002036-05-012,426.421,153.261,273.16278,377.64
116.002036-06-012,426.421,148.011,278.41277,099.23
117.002036-07-012,426.421,142.731,283.69275,815.54
118.002036-08-012,426.421,137.441,288.98274,526.56
119.002036-09-012,426.421,132.121,294.30273,232.26
120.002036-10-012,426.421,126.791,299.63271,932.63
121.002036-11-012,426.421,121.431,304.99270,627.64
122.002036-12-012,426.421,116.051,310.37269,317.26
123.002037-01-012,426.421,110.641,315.78268,001.49
124.002037-02-012,426.421,105.221,321.20266,680.28
125.002037-03-012,426.421,099.771,326.65265,353.63
126.002037-04-012,426.421,094.301,332.12264,021.50
127.002037-05-012,426.421,088.801,337.62262,683.89
128.002037-06-012,426.421,083.291,343.13261,340.75
129.002037-07-012,426.421,077.751,348.67259,992.08
130.002037-08-012,426.421,072.191,354.23258,637.85
131.002037-09-012,426.421,066.601,359.82257,278.03
132.002037-10-012,426.421,060.991,365.43255,912.60
133.002037-11-012,426.421,055.361,371.06254,541.54
134.002037-12-012,426.421,049.711,376.71253,164.83
135.002038-01-012,426.421,044.031,382.39251,782.44
136.002038-02-012,426.421,038.331,388.09250,394.35
137.002038-03-012,426.421,032.611,393.81249,000.53
138.002038-04-012,426.421,026.861,399.56247,600.97
139.002038-05-012,426.421,021.091,405.33246,195.64
140.002038-06-012,426.421,015.291,411.13244,784.51
141.002038-07-012,426.421,009.471,416.95243,367.56
142.002038-08-012,426.421,003.631,422.79241,944.76
143.002038-09-012,426.42997.761,428.66240,516.10
144.002038-10-012,426.42991.871,434.55239,081.55
145.002038-11-012,426.42985.951,440.47237,641.08
146.002038-12-012,426.42980.011,446.41236,194.68
147.002039-01-012,426.42974.051,452.37234,742.30
148.002039-02-012,426.42968.061,458.36233,283.94
149.002039-03-012,426.42962.041,464.38231,819.56
150.002039-04-012,426.42956.001,470.42230,349.15
151.002039-05-012,426.42949.941,476.48228,872.67
152.002039-06-012,426.42943.851,482.57227,390.10
153.002039-07-012,426.42937.741,488.68225,901.42
154.002039-08-012,426.42931.601,494.82224,406.60
155.002039-09-012,426.42925.431,500.99222,905.61
156.002039-10-012,426.42919.241,507.18221,398.43
157.002039-11-012,426.42913.031,513.39219,885.04
158.002039-12-012,426.42906.791,519.63218,365.41
159.002040-01-012,426.42900.521,525.90216,839.51
160.002040-02-012,426.42894.231,532.19215,307.32
161.002040-03-012,426.42887.911,538.51213,768.81
162.002040-04-012,426.42881.561,544.86212,223.95
163.002040-05-012,426.42875.191,551.23210,672.73
164.002040-06-012,426.42868.801,557.62209,115.10
165.002040-07-012,426.42862.371,564.05207,551.06
166.002040-08-012,426.42855.921,570.50205,980.56
167.002040-09-012,426.42849.451,576.97204,403.59
168.002040-10-012,426.42842.941,583.48202,820.11
169.002040-11-012,426.42836.411,590.01201,230.10
170.002040-12-012,426.42829.861,596.56199,633.54
171.002041-01-012,426.42823.271,603.15198,030.39
172.002041-02-012,426.42816.661,609.76196,420.63
173.002041-03-012,426.42810.021,616.40194,804.23
174.002041-04-012,426.42803.361,623.06193,181.17
175.002041-05-012,426.42796.661,629.76191,551.41
176.002041-06-012,426.42789.941,636.48189,914.93
177.002041-07-012,426.42783.191,643.23188,271.71
178.002041-08-012,426.42776.421,650.00186,621.70
179.002041-09-012,426.42769.611,656.81184,964.90
180.002041-10-012,426.42762.781,663.64183,301.25
181.002041-11-012,426.42755.921,670.50181,630.75
182.002041-12-012,426.42749.031,677.39179,953.36
183.002042-01-012,426.42742.111,684.31178,269.06
184.002042-02-012,426.42735.171,691.25176,577.80
185.002042-03-012,426.42728.191,698.23174,879.57
186.002042-04-012,426.42721.191,705.23173,174.34
187.002042-05-012,426.42714.161,712.26171,462.08
188.002042-06-012,426.42707.101,719.32169,742.76
189.002042-07-012,426.42700.001,726.42168,016.34
190.002042-08-012,426.42692.891,733.53166,282.81
191.002042-09-012,426.42685.741,740.68164,542.12
192.002042-10-012,426.42678.561,747.86162,794.26
193.002042-11-012,426.42671.351,755.07161,039.19
194.002042-12-012,426.42664.111,762.31159,276.88
195.002043-01-012,426.42656.841,769.58157,507.31
196.002043-02-012,426.42649.551,776.87155,730.43
197.002043-03-012,426.42642.221,784.20153,946.23
198.002043-04-012,426.42634.861,791.56152,154.67
199.002043-05-012,426.42627.471,798.95150,355.73
200.002043-06-012,426.42620.051,806.37148,549.36
201.002043-07-012,426.42612.611,813.81146,735.55
202.002043-08-012,426.42605.121,821.29144,914.25
203.002043-09-012,426.42597.611,828.81143,085.44
204.002043-10-012,426.42590.071,836.35141,249.10
205.002043-11-012,426.42582.501,843.92139,405.18
206.002043-12-012,426.42574.901,851.52137,553.65
207.002044-01-012,426.42567.261,859.16135,694.49
208.002044-02-012,426.42559.591,866.83133,827.66
209.002044-03-012,426.42551.891,874.53131,953.14
210.002044-04-012,426.42544.161,882.26130,070.88
211.002044-05-012,426.42536.401,890.02128,180.86
212.002044-06-012,426.42528.611,897.81126,283.05
213.002044-07-012,426.42520.781,905.64124,377.41
214.002044-08-012,426.42512.921,913.50122,463.91
215.002044-09-012,426.42505.031,921.39120,542.52
216.002044-10-012,426.42497.111,929.31118,613.21
217.002044-11-012,426.42489.151,937.27116,675.94
218.002044-12-012,426.42481.161,945.26114,730.68
219.002045-01-012,426.42473.141,953.28112,777.40
220.002045-02-012,426.42465.081,961.34110,816.07
221.002045-03-012,426.42457.001,969.42108,846.64
222.002045-04-012,426.42448.871,977.55106,869.10
223.002045-05-012,426.42440.721,985.70104,883.40
224.002045-06-012,426.42432.531,993.89102,889.51
225.002045-07-012,426.42424.312,002.11100,887.40
226.002045-08-012,426.42416.052,010.3798,877.03
227.002045-09-012,426.42407.762,018.6696,858.37
228.002045-10-012,426.42399.442,026.9894,831.38
229.002045-11-012,426.42391.082,035.3492,796.04
230.002045-12-012,426.42382.682,043.7490,752.30
231.002046-01-012,426.42374.252,052.1788,700.14
232.002046-02-012,426.42365.792,060.6386,639.51
233.002046-03-012,426.42357.292,069.1384,570.38
234.002046-04-012,426.42348.762,077.6682,492.73
235.002046-05-012,426.42340.192,086.2380,406.50
236.002046-06-012,426.42331.592,094.8378,311.67
237.002046-07-012,426.42322.952,103.4776,208.20
238.002046-08-012,426.42314.282,112.1474,096.05
239.002046-09-012,426.42305.572,120.8571,975.20
240.002046-10-012,426.42296.822,129.6069,845.60
241.002046-11-012,426.42288.042,138.3867,707.22
242.002046-12-012,426.42279.222,147.2065,560.02
243.002047-01-012,426.42270.362,156.0663,403.96
244.002047-02-012,426.42261.472,164.9561,239.01
245.002047-03-012,426.42252.542,173.8859,065.14
246.002047-04-012,426.42243.582,182.8456,882.30
247.002047-05-012,426.42234.582,191.8454,690.46
248.002047-06-012,426.42225.542,200.8852,489.57
249.002047-07-012,426.42216.462,209.9650,279.62
250.002047-08-012,426.42207.352,219.0748,060.55
251.002047-09-012,426.42198.202,228.2245,832.32
252.002047-10-012,426.42189.012,237.4143,594.91
253.002047-11-012,426.42179.782,246.6441,348.27
254.002047-12-012,426.42170.522,255.9039,092.37
255.002048-01-012,426.42161.212,265.2136,827.16
256.002048-02-012,426.42151.872,274.5534,552.62
257.002048-03-012,426.42142.492,283.9332,268.69
258.002048-04-012,426.42133.072,293.3529,975.34
259.002048-05-012,426.42123.622,302.8027,672.54
260.002048-06-012,426.42114.122,312.3025,360.24
261.002048-07-012,426.42104.582,321.8423,038.40
262.002048-08-012,426.4295.012,331.4120,706.99
263.002048-09-012,426.4285.392,341.0318,365.96
264.002048-10-012,426.4275.742,350.6816,015.28
265.002048-11-012,426.4266.052,360.3713,654.91
266.002048-12-012,426.4256.312,370.1111,284.80
267.002049-01-012,426.4246.542,379.888,904.92
268.002049-02-012,426.4236.722,389.706,515.22
269.002049-03-012,426.4226.872,399.554,115.67
270.002049-04-012,426.4216.972,409.451,706.22
271.002049-05-011,713.267.041,706.220.00
Annual payment breakdown
Payment yearPaid ($)Interest ($)Principal ($)Closing balance ($)
1.0029,117.0419,580.429,536.62390,463.38
2.0034,117.0418,866.0815,250.96375,212.41
3.0029,117.0418,325.5510,791.49364,420.92
4.0029,117.0417,779.2311,337.81353,083.11
5.0029,117.0417,205.2511,911.79341,171.32
6.0029,117.0416,602.2212,514.82328,656.50
7.0029,117.0415,968.6513,148.39315,508.11
8.0029,117.0415,303.0213,814.02301,694.09
9.0029,117.0414,603.6814,513.36287,180.73
10.0029,117.0413,868.9415,248.10271,932.63
11.0029,117.0413,097.0116,020.03255,912.60
12.0029,117.0412,285.9916,831.05239,081.55
13.0029,117.0411,433.9217,683.12221,398.43
14.0029,117.0410,538.7118,578.33202,820.11
15.0029,117.049,598.1919,518.85183,301.25
16.0029,117.048,610.0420,507.00162,794.26
17.0029,117.047,571.8821,545.16141,249.10
18.0029,117.046,481.1522,635.89118,613.21
19.0029,117.045,335.2123,781.8394,831.38
20.0029,117.044,131.2624,985.7869,845.60
21.0029,117.042,866.3526,250.6943,594.91
22.0029,117.041,537.4127,579.6316,015.28
23.0016,271.78256.5016,015.280.00

Advertisement

How this calculator works

Choose when recurring extras begin and when a lump sum is paid. Dates between scheduled payments are applied on the next due date; interest is still calculated in equal payment periods. The annual increase raises the regular scheduled amount after each full payment year. The baseline uses the same frequency and rate without extras, lump sums or growth. Prepayment limits and penalties are excluded.

Formula

Periodic rate i = (1 + r/c)^(c/f) - 1. Due = opening balance × (1 + i). Actual payment = min(due, regular payment × (1 + annual increase)^completed years + eligible extra + eligible lump sum). Interest saved = baseline interest - planned interest.

Worked example

For $1,200 at 0% over twelve monthly payments, regular P&I is $100. A $200 lump sum on the first due date reduces repayment to ten payments. Adding $50 each month instead reduces it to eight payments.

Advertisement

Frequently asked questions

When is a mid-month lump sum applied?

It is applied on the first scheduled due date on or after the entered date. A lender using daily accrual may credit an earlier date differently.

What if I put the lump sum after payoff?

It is not applied because there is no balance left to repay. The schedule shows every payment actually used.

Are prepayment penalties included?

No. Check the agreement's limits and use the mortgage penalty calculator when a proposed payment exceeds them.

Sources

Advertisement