zerouploads

Loan Calculator

Work out the repayment, the total interest and the whole amortisation schedule, including overpayments.

  • Unlimited
  • No signup
  • Private
  • Works offline

Work out loan repayments

Loan details

Principal vs interest over the term

Total £440,344.60

Amortisation schedule

Schedule interval
Every monthly of the loan, split into interest and principal
#PaymentPrincipalInterestBalance
1£1,223.19£313.19£910.00£239,686.81
2£1,223.19£314.38£908.81£239,372.43
3£1,223.19£315.57£907.62£239,056.86
4£1,223.19£316.77£906.42£238,740.09
5£1,223.19£317.97£905.22£238,422.12
6£1,223.19£319.17£904.02£238,102.95
7£1,223.19£320.38£902.81£237,782.57
8£1,223.19£321.60£901.59£237,460.97
9£1,223.19£322.82£900.37£237,138.15
10£1,223.19£324.04£899.15£236,814.11
11£1,223.19£325.27£897.92£236,488.84
12£1,223.19£326.50£896.69£236,162.34
13£1,223.19£327.74£895.45£235,834.60
14£1,223.19£328.98£894.21£235,505.62
15£1,223.19£330.23£892.96£235,175.39
16£1,223.19£331.48£891.71£234,843.91
17£1,223.19£332.74£890.45£234,511.17
18£1,223.19£334.00£889.19£234,177.17
19£1,223.19£335.27£887.92£233,841.90
20£1,223.19£336.54£886.65£233,505.36
21£1,223.19£337.82£885.37£233,167.54
22£1,223.19£339.10£884.09£232,828.44
23£1,223.19£340.38£882.81£232,488.06
24£1,223.19£341.67£881.52£232,146.39
25£1,223.19£342.97£880.22£231,803.42
26£1,223.19£344.27£878.92£231,459.15
27£1,223.19£345.57£877.62£231,113.58
28£1,223.19£346.88£876.31£230,766.70
29£1,223.19£348.20£874.99£230,418.50
30£1,223.19£349.52£873.67£230,068.98
31£1,223.19£350.85£872.34£229,718.13
32£1,223.19£352.18£871.01£229,365.95
33£1,223.19£353.51£869.68£229,012.44
34£1,223.19£354.85£868.34£228,657.59
35£1,223.19£356.20£866.99£228,301.39
36£1,223.19£357.55£865.64£227,943.84
37£1,223.19£358.90£864.29£227,584.94
38£1,223.19£360.26£862.93£227,224.68
39£1,223.19£361.63£861.56£226,863.05
40£1,223.19£363.00£860.19£226,500.05
41£1,223.19£364.38£858.81£226,135.67
42£1,223.19£365.76£857.43£225,769.91
43£1,223.19£367.15£856.04£225,402.76
44£1,223.19£368.54£854.65£225,034.22
45£1,223.19£369.94£853.25£224,664.28
46£1,223.19£371.34£851.85£224,292.94
47£1,223.19£372.75£850.44£223,920.19
48£1,223.19£374.16£849.03£223,546.03
49£1,223.19£375.58£847.61£223,170.45
50£1,223.19£377.00£846.19£222,793.45
51£1,223.19£378.43£844.76£222,415.02
52£1,223.19£379.87£843.32£222,035.15
53£1,223.19£381.31£841.88£221,653.84
54£1,223.19£382.75£840.44£221,271.09
55£1,223.19£384.20£838.99£220,886.89
56£1,223.19£385.66£837.53£220,501.23
57£1,223.19£387.12£836.07£220,114.11
58£1,223.19£388.59£834.60£219,725.52
59£1,223.19£390.06£833.13£219,335.46
60£1,223.19£391.54£831.65£218,943.92
61£1,223.19£393.03£830.16£218,550.89
62£1,223.19£394.52£828.67£218,156.37
63£1,223.19£396.01£827.18£217,760.36
64£1,223.19£397.52£825.67£217,362.84
65£1,223.19£399.02£824.17£216,963.82
66£1,223.19£400.54£822.65£216,563.28
67£1,223.19£402.05£821.14£216,161.23
68£1,223.19£403.58£819.61£215,757.65
69£1,223.19£405.11£818.08£215,352.54
70£1,223.19£406.64£816.55£214,945.90
71£1,223.19£408.19£815.00£214,537.71
72£1,223.19£409.73£813.46£214,127.98
73£1,223.19£411.29£811.90£213,716.69
74£1,223.19£412.85£810.34£213,303.84
75£1,223.19£414.41£808.78£212,889.43
76£1,223.19£415.98£807.21£212,473.45
77£1,223.19£417.56£805.63£212,055.89
78£1,223.19£419.14£804.05£211,636.75
79£1,223.19£420.73£802.46£211,216.02
80£1,223.19£422.33£800.86£210,793.69
81£1,223.19£423.93£799.26£210,369.76
82£1,223.19£425.54£797.65£209,944.22
83£1,223.19£427.15£796.04£209,517.07
84£1,223.19£428.77£794.42£209,088.30
85£1,223.19£430.40£792.79£208,657.90
86£1,223.19£432.03£791.16£208,225.87
87£1,223.19£433.67£789.52£207,792.20
88£1,223.19£435.31£787.88£207,356.89
89£1,223.19£436.96£786.23£206,919.93
90£1,223.19£438.62£784.57£206,481.31
91£1,223.19£440.28£782.91£206,041.03
92£1,223.19£441.95£781.24£205,599.08
93£1,223.19£443.63£779.56£205,155.45
94£1,223.19£445.31£777.88£204,710.14
95£1,223.19£447.00£776.19£204,263.14
96£1,223.19£448.69£774.50£203,814.45
97£1,223.19£450.39£772.80£203,364.06
98£1,223.19£452.10£771.09£202,911.96
99£1,223.19£453.82£769.37£202,458.14
100£1,223.19£455.54£767.65£202,002.60
101£1,223.19£457.26£765.93£201,545.34
102£1,223.19£459.00£764.19£201,086.34
103£1,223.19£460.74£762.45£200,625.60
104£1,223.19£462.48£760.71£200,163.12
105£1,223.19£464.24£758.95£199,698.88
106£1,223.19£466.00£757.19£199,232.88
107£1,223.19£467.77£755.42£198,765.11
108£1,223.19£469.54£753.65£198,295.57
109£1,223.19£471.32£751.87£197,824.25
110£1,223.19£473.11£750.08£197,351.14
111£1,223.19£474.90£748.29£196,876.24
112£1,223.19£476.70£746.49£196,399.54
113£1,223.19£478.51£744.68£195,921.03
114£1,223.19£480.32£742.87£195,440.71
115£1,223.19£482.14£741.05£194,958.57
116£1,223.19£483.97£739.22£194,474.60
117£1,223.19£485.81£737.38£193,988.79
118£1,223.19£487.65£735.54£193,501.14
119£1,223.19£489.50£733.69£193,011.64
120£1,223.19£491.35£731.84£192,520.29
121£1,223.19£493.22£729.97£192,027.07
122£1,223.19£495.09£728.10£191,531.98
123£1,223.19£496.96£726.23£191,035.02
124£1,223.19£498.85£724.34£190,536.17
125£1,223.19£500.74£722.45£190,035.43
126£1,223.19£502.64£720.55£189,532.79
127£1,223.19£504.54£718.65£189,028.25
128£1,223.19£506.46£716.73£188,521.79
129£1,223.19£508.38£714.81£188,013.41
130£1,223.19£510.31£712.88£187,503.10
131£1,223.19£512.24£710.95£186,990.86
132£1,223.19£514.18£709.01£186,476.68
133£1,223.19£516.13£707.06£185,960.55
134£1,223.19£518.09£705.10£185,442.46
135£1,223.19£520.05£703.14£184,922.41
136£1,223.19£522.03£701.16£184,400.38
137£1,223.19£524.01£699.18£183,876.37
138£1,223.19£525.99£697.20£183,350.38
139£1,223.19£527.99£695.20£182,822.39
140£1,223.19£529.99£693.20£182,292.40
141£1,223.19£532.00£691.19£181,760.40
142£1,223.19£534.02£689.17£181,226.38
143£1,223.19£536.04£687.15£180,690.34
144£1,223.19£538.07£685.12£180,152.27
145£1,223.19£540.11£683.08£179,612.16
146£1,223.19£542.16£681.03£179,070.00
147£1,223.19£544.22£678.97£178,525.78
148£1,223.19£546.28£676.91£177,979.50
149£1,223.19£548.35£674.84£177,431.15
150£1,223.19£550.43£672.76£176,880.72
151£1,223.19£552.52£670.67£176,328.20
152£1,223.19£554.61£668.58£175,773.59
153£1,223.19£556.72£666.47£175,216.87
154£1,223.19£558.83£664.36£174,658.04
155£1,223.19£560.94£662.25£174,097.10
156£1,223.19£563.07£660.12£173,534.03
157£1,223.19£565.21£657.98£172,968.82
158£1,223.19£567.35£655.84£172,401.47
159£1,223.19£569.50£653.69£171,831.97
160£1,223.19£571.66£651.53£171,260.31
161£1,223.19£573.83£649.36£170,686.48
162£1,223.19£576.00£647.19£170,110.48
163£1,223.19£578.19£645.00£169,532.29
164£1,223.19£580.38£642.81£168,951.91
165£1,223.19£582.58£640.61£168,369.33
166£1,223.19£584.79£638.40£167,784.54
167£1,223.19£587.01£636.18£167,197.53
168£1,223.19£589.23£633.96£166,608.30
169£1,223.19£591.47£631.72£166,016.83
170£1,223.19£593.71£629.48£165,423.12
171£1,223.19£595.96£627.23£164,827.16
172£1,223.19£598.22£624.97£164,228.94
173£1,223.19£600.49£622.70£163,628.45
174£1,223.19£602.77£620.42£163,025.68
175£1,223.19£605.05£618.14£162,420.63
176£1,223.19£607.35£615.84£161,813.28
177£1,223.19£609.65£613.54£161,203.63
178£1,223.19£611.96£611.23£160,591.67
179£1,223.19£614.28£608.91£159,977.39
180£1,223.19£616.61£606.58£159,360.78
181£1,223.19£618.95£604.24£158,741.83
182£1,223.19£621.29£601.90£158,120.54
183£1,223.19£623.65£599.54£157,496.89
184£1,223.19£626.01£597.18£156,870.88
185£1,223.19£628.39£594.80£156,242.49
186£1,223.19£630.77£592.42£155,611.72
187£1,223.19£633.16£590.03£154,978.56
188£1,223.19£635.56£587.63£154,343.00
189£1,223.19£637.97£585.22£153,705.03
190£1,223.19£640.39£582.80£153,064.64
191£1,223.19£642.82£580.37£152,421.82
192£1,223.19£645.26£577.93£151,776.56
193£1,223.19£647.70£575.49£151,128.86
194£1,223.19£650.16£573.03£150,478.70
195£1,223.19£652.62£570.57£149,826.08
196£1,223.19£655.10£568.09£149,170.98
197£1,223.19£657.58£565.61£148,513.40
198£1,223.19£660.08£563.11£147,853.32
199£1,223.19£662.58£560.61£147,190.74
200£1,223.19£665.09£558.10£146,525.65
201£1,223.19£667.61£555.58£145,858.04
202£1,223.19£670.14£553.05£145,187.90
203£1,223.19£672.69£550.50£144,515.21
204£1,223.19£675.24£547.95£143,839.97
205£1,223.19£677.80£545.39£143,162.17
206£1,223.19£680.37£542.82£142,481.80
207£1,223.19£682.95£540.24£141,798.85
208£1,223.19£685.54£537.65£141,113.31
209£1,223.19£688.14£535.05£140,425.17
210£1,223.19£690.74£532.45£139,734.43
211£1,223.19£693.36£529.83£139,041.07
212£1,223.19£695.99£527.20£138,345.08
213£1,223.19£698.63£524.56£137,646.45
214£1,223.19£701.28£521.91£136,945.17
215£1,223.19£703.94£519.25£136,241.23
216£1,223.19£706.61£516.58£135,534.62
217£1,223.19£709.29£513.90£134,825.33
218£1,223.19£711.98£511.21£134,113.35
219£1,223.19£714.68£508.51£133,398.67
220£1,223.19£717.39£505.80£132,681.28
221£1,223.19£720.11£503.08£131,961.17
222£1,223.19£722.84£500.35£131,238.33
223£1,223.19£725.58£497.61£130,512.75
224£1,223.19£728.33£494.86£129,784.42
225£1,223.19£731.09£492.10£129,053.33
226£1,223.19£733.86£489.33£128,319.47
227£1,223.19£736.65£486.54£127,582.82
228£1,223.19£739.44£483.75£126,843.38
229£1,223.19£742.24£480.95£126,101.14
230£1,223.19£745.06£478.13£125,356.08
231£1,223.19£747.88£475.31£124,608.20
232£1,223.19£750.72£472.47£123,857.48
233£1,223.19£753.56£469.63£123,103.92
234£1,223.19£756.42£466.77£122,347.50
235£1,223.19£759.29£463.90£121,588.21
236£1,223.19£762.17£461.02£120,826.04
237£1,223.19£765.06£458.13£120,060.98
238£1,223.19£767.96£455.23£119,293.02
239£1,223.19£770.87£452.32£118,522.15
240£1,223.19£773.79£449.40£117,748.36
241£1,223.19£776.73£446.46£116,971.63
242£1,223.19£779.67£443.52£116,191.96
243£1,223.19£782.63£440.56£115,409.33
244£1,223.19£785.60£437.59£114,623.73
245£1,223.19£788.58£434.61£113,835.15
246£1,223.19£791.57£431.62£113,043.58
247£1,223.19£794.57£428.62£112,249.01
248£1,223.19£797.58£425.61£111,451.43
249£1,223.19£800.60£422.59£110,650.83
250£1,223.19£803.64£419.55£109,847.19
251£1,223.19£806.69£416.50£109,040.50
252£1,223.19£809.74£413.45£108,230.76
253£1,223.19£812.82£410.37£107,417.94
254£1,223.19£815.90£407.29£106,602.04
255£1,223.19£818.99£404.20£105,783.05
256£1,223.19£822.10£401.09£104,960.95
257£1,223.19£825.21£397.98£104,135.74
258£1,223.19£828.34£394.85£103,307.40
259£1,223.19£831.48£391.71£102,475.92
260£1,223.19£834.64£388.55£101,641.28
261£1,223.19£837.80£385.39£100,803.48
262£1,223.19£840.98£382.21£99,962.50
263£1,223.19£844.17£379.02£99,118.33
264£1,223.19£847.37£375.82£98,270.96
265£1,223.19£850.58£372.61£97,420.38
266£1,223.19£853.80£369.39£96,566.58
267£1,223.19£857.04£366.15£95,709.54
268£1,223.19£860.29£362.90£94,849.25
269£1,223.19£863.55£359.64£93,985.70
270£1,223.19£866.83£356.36£93,118.87
271£1,223.19£870.11£353.08£92,248.76
272£1,223.19£873.41£349.78£91,375.35
273£1,223.19£876.73£346.46£90,498.62
274£1,223.19£880.05£343.14£89,618.57
275£1,223.19£883.39£339.80£88,735.18
276£1,223.19£886.74£336.45£87,848.44
277£1,223.19£890.10£333.09£86,958.34
278£1,223.19£893.47£329.72£86,064.87
279£1,223.19£896.86£326.33£85,168.01
280£1,223.19£900.26£322.93£84,267.75
281£1,223.19£903.67£319.52£83,364.08
282£1,223.19£907.10£316.09£82,456.98
283£1,223.19£910.54£312.65£81,546.44
284£1,223.19£913.99£309.20£80,632.45
285£1,223.19£917.46£305.73£79,714.99
286£1,223.19£920.94£302.25£78,794.05
287£1,223.19£924.43£298.76£77,869.62
288£1,223.19£927.93£295.26£76,941.69
289£1,223.19£931.45£291.74£76,010.24
290£1,223.19£934.98£288.21£75,075.26
291£1,223.19£938.53£284.66£74,136.73
292£1,223.19£942.09£281.10£73,194.64
293£1,223.19£945.66£277.53£72,248.98
294£1,223.19£949.25£273.94£71,299.73
295£1,223.19£952.85£270.34£70,346.88
296£1,223.19£956.46£266.73£69,390.42
297£1,223.19£960.08£263.11£68,430.34
298£1,223.19£963.72£259.47£67,466.62
299£1,223.19£967.38£255.81£66,499.24
300£1,223.19£971.05£252.14£65,528.19
301£1,223.19£974.73£248.46£64,553.46
302£1,223.19£978.42£244.77£63,575.04
303£1,223.19£982.13£241.06£62,592.91
304£1,223.19£985.86£237.33£61,607.05
305£1,223.19£989.60£233.59£60,617.45
306£1,223.19£993.35£229.84£59,624.10
307£1,223.19£997.12£226.07£58,626.98
308£1,223.19£1,000.90£222.29£57,626.08
309£1,223.19£1,004.69£218.50£56,621.39
310£1,223.19£1,008.50£214.69£55,612.89
311£1,223.19£1,012.32£210.87£54,600.57
312£1,223.19£1,016.16£207.03£53,584.41
313£1,223.19£1,020.02£203.17£52,564.39
314£1,223.19£1,023.88£199.31£51,540.51
315£1,223.19£1,027.77£195.42£50,512.74
316£1,223.19£1,031.66£191.53£49,481.08
317£1,223.19£1,035.57£187.62£48,445.51
318£1,223.19£1,039.50£183.69£47,406.01
319£1,223.19£1,043.44£179.75£46,362.57
320£1,223.19£1,047.40£175.79£45,315.17
321£1,223.19£1,051.37£171.82£44,263.80
322£1,223.19£1,055.36£167.83£43,208.44
323£1,223.19£1,059.36£163.83£42,149.08
324£1,223.19£1,063.37£159.82£41,085.71
325£1,223.19£1,067.41£155.78£40,018.30
326£1,223.19£1,071.45£151.74£38,946.85
327£1,223.19£1,075.52£147.67£37,871.33
328£1,223.19£1,079.59£143.60£36,791.74
329£1,223.19£1,083.69£139.50£35,708.05
330£1,223.19£1,087.80£135.39£34,620.25
331£1,223.19£1,091.92£131.27£33,528.33
332£1,223.19£1,096.06£127.13£32,432.27
333£1,223.19£1,100.22£122.97£31,332.05
334£1,223.19£1,104.39£118.80£30,227.66
335£1,223.19£1,108.58£114.61£29,119.08
336£1,223.19£1,112.78£110.41£28,006.30
337£1,223.19£1,117.00£106.19£26,889.30
338£1,223.19£1,121.23£101.96£25,768.07
339£1,223.19£1,125.49£97.70£24,642.58
340£1,223.19£1,129.75£93.44£23,512.83
341£1,223.19£1,134.04£89.15£22,378.79
342£1,223.19£1,138.34£84.85£21,240.45
343£1,223.19£1,142.65£80.54£20,097.80
344£1,223.19£1,146.99£76.20£18,950.81
345£1,223.19£1,151.33£71.86£17,799.48
346£1,223.19£1,155.70£67.49£16,643.78
347£1,223.19£1,160.08£63.11£15,483.70
348£1,223.19£1,164.48£58.71£14,319.22
349£1,223.19£1,168.90£54.29£13,150.32
350£1,223.19£1,173.33£49.86£11,976.99
351£1,223.19£1,177.78£45.41£10,799.21
352£1,223.19£1,182.24£40.95£9,616.97
353£1,223.19£1,186.73£36.46£8,430.24
354£1,223.19£1,191.23£31.96£7,239.01
355£1,223.19£1,195.74£27.45£6,043.27
356£1,223.19£1,200.28£22.91£4,842.99
357£1,223.19£1,204.83£18.36£3,638.16
358£1,223.19£1,209.40£13.79£2,428.76
359£1,223.19£1,213.98£9.21£1,214.78
360£1,219.39£1,214.78£4.61£0.00

360 payments · 30 years

How this was calculated

payment = P x r / (1 - (1 + r)^-n)

r = 4.55% / 12 = 0.3792%

n = 30 x 12 = 360

payment = 1223.19

Monthly payment

Loan amount
£240,000.00
Total interest
£200,344.60
Total repaid
£440,344.60
Interest as % of loan
83.5%
Payments
360
Final payment
—

If you overpay £100 /mo

Term
-4 yr 4 mo
Interest saved
£33,406.92
Paid off
—

Principal and interest only. Fees, insurance and taxes are not included.

How it works

  1. 01

    Enter the loan

    Enter the amount, the annual rate and the term, then pick monthly, fortnightly or weekly payments.

  2. 02

    Add any overpayment

    A regular extra amount shortens the term and cuts the interest.

  3. 03

    Read the schedule

    The schedule splits every payment into interest and principal. You can download it as a CSV file.

What the payment is made of

A repayment loan splits every payment between interest and principal, the amount you borrowed. The lender charges interest on the balance you still owe. So early payments are mostly interest and bring the debt down slowly. As the balance falls, less interest builds up, and more of the same payment goes to the principal.

An overpayment lowers the balance that future interest is charged on. Paid early, it has longer to cut the cost of the loan than the same amount paid near the end. It shortens the term and lowers the total interest.

Types
Repayment and interest-only, monthly, fortnightly or weekly.
Rate
Nominal annual rate, divided by the number of payments a year.
Overpayments
A recurring extra amount on top of every payment.
Not included
Fees, insurance and taxes. Add those separately.

Reading APR carefully

The interest field takes the nominal annual rate and divides it across the payments in a year. An advertised APR is for comparing loans, and it can include required fees and the timing of charges. So if you enter an APR here, the payment may not match a lender's quote.

Use the rate in your contract for the payment, then add fees separately when you compare the overall cost. The calculator rounds each amount to the penny or cent every period. The last payment takes up that rounding, as lenders do, so the loan never ends with a few pence still owed.

Frequently asked questions

Does this include fees, insurance or taxes?
No. The result covers principal and interest only. Add arrangement fees, insurance, taxes and any other charges yourself when you compare the total cost of borrowing.
Can I model overpayments?
Yes. Enter a regular amount in Extra payment to see what it does to the term and the total interest. The schedule and the payoff date both update.
Is the schedule downloadable?
Yes. Download the full payment schedule as a CSV file and open it in any spreadsheet.
Does it handle interest-only loans?
Yes. Pick the interest-only type. Each payment then covers interest alone, and the original amount is still due at the end of the term.
Which currencies are supported?
Pounds, US dollars, euros, Australian and Canadian dollars, Indian rupees and Bangladeshi taka. The currency changes the symbol only. The formula is the same for all of them.
Is my financial data sent anywhere?
No. The amounts you type stay in the page, which never sends them anywhere or keeps them between visits.
Browse all calculators