Free Loan Calculator

A working loan calculator with three things most online calculators skip: a complete amortization schedule (every month, exportable as CSV), prepayment modeling (recurring monthly or one-shot lump sum) with the exact interest savings and months saved, and side-by-side comparison of two offers so you can see EMI vs total interest vs total cost at a glance.

Prepayment options
Loan A
Monthly EMI
$1,663
Total interest
$348,772
Total paid
$598,772
Closes in
360 months
Full amortization schedule (360 rows)
MonthEMIPrincipalInterestPrepaymentBalance
1$1,663$205$1,458-$249,795
2$1,663$206$1,457-$249,589
3$1,663$207$1,456-$249,382
4$1,663$209$1,455-$249,173
5$1,663$210$1,454-$248,963
6$1,663$211$1,452-$248,752
7$1,663$212$1,451-$248,540
8$1,663$213$1,450-$248,327
9$1,663$215$1,449-$248,112
10$1,663$216$1,447-$247,896
11$1,663$217$1,446-$247,679
12$1,663$218$1,445-$247,460
13$1,663$220$1,444-$247,241
14$1,663$221$1,442-$247,020
15$1,663$222$1,441-$246,797
16$1,663$224$1,440-$246,574
17$1,663$225$1,438-$246,349
18$1,663$226$1,437-$246,123
19$1,663$228$1,436-$245,895
20$1,663$229$1,434-$245,666
21$1,663$230$1,433-$245,436
22$1,663$232$1,432-$245,205
23$1,663$233$1,430-$244,972
24$1,663$234$1,429-$244,737
25$1,663$236$1,428-$244,502
26$1,663$237$1,426-$244,265
27$1,663$238$1,425-$244,026
28$1,663$240$1,423-$243,787
29$1,663$241$1,422-$243,545
30$1,663$243$1,421-$243,303
31$1,663$244$1,419-$243,059
32$1,663$245$1,418-$242,813
33$1,663$247$1,416-$242,567
34$1,663$248$1,415-$242,318
35$1,663$250$1,414-$242,069
36$1,663$251$1,412-$241,817
37$1,663$253$1,411-$241,565
38$1,663$254$1,409-$241,311
39$1,663$256$1,408-$241,055
40$1,663$257$1,406-$240,798
41$1,663$259$1,405-$240,539
42$1,663$260$1,403-$240,279
43$1,663$262$1,402-$240,018
44$1,663$263$1,400-$239,754
45$1,663$265$1,399-$239,490
46$1,663$266$1,397-$239,223
47$1,663$268$1,395-$238,956
48$1,663$269$1,394-$238,686
49$1,663$271$1,392-$238,415
50$1,663$272$1,391-$238,143
51$1,663$274$1,389-$237,869
52$1,663$276$1,388-$237,593
53$1,663$277$1,386-$237,316
54$1,663$279$1,384-$237,037
55$1,663$281$1,383-$236,756
56$1,663$282$1,381-$236,474
57$1,663$284$1,379-$236,190
58$1,663$285$1,378-$235,905
59$1,663$287$1,376-$235,618
60$1,663$289$1,374-$235,329
61$1,663$291$1,373-$235,038
62$1,663$292$1,371-$234,746
63$1,663$294$1,369-$234,452
64$1,663$296$1,368-$234,157
65$1,663$297$1,366-$233,859
66$1,663$299$1,364-$233,560
67$1,663$301$1,362-$233,260
68$1,663$303$1,361-$232,957
69$1,663$304$1,359-$232,653
70$1,663$306$1,357-$232,346
71$1,663$308$1,355-$232,039
72$1,663$310$1,354-$231,729
73$1,663$312$1,352-$231,417
74$1,663$313$1,350-$231,104
75$1,663$315$1,348-$230,789
76$1,663$317$1,346-$230,472
77$1,663$319$1,344-$230,153
78$1,663$321$1,343-$229,832
79$1,663$323$1,341-$229,510
80$1,663$324$1,339-$229,185
81$1,663$326$1,337-$228,859
82$1,663$328$1,335-$228,531
83$1,663$330$1,333-$228,201
84$1,663$332$1,331-$227,869
85$1,663$334$1,329-$227,535
86$1,663$336$1,327-$227,199
87$1,663$338$1,325-$226,861
88$1,663$340$1,323-$226,521
89$1,663$342$1,321-$226,179
90$1,663$344$1,319-$225,835
91$1,663$346$1,317-$225,489
92$1,663$348$1,315-$225,141
93$1,663$350$1,313-$224,791
94$1,663$352$1,311-$224,439
95$1,663$354$1,309-$224,085
96$1,663$356$1,307-$223,729
97$1,663$358$1,305-$223,371
98$1,663$360$1,303-$223,011
99$1,663$362$1,301-$222,648
100$1,663$364$1,299-$222,284
101$1,663$367$1,297-$221,917
102$1,663$369$1,295-$221,549
103$1,663$371$1,292-$221,178
104$1,663$373$1,290-$220,805
105$1,663$375$1,288-$220,429
106$1,663$377$1,286-$220,052
107$1,663$380$1,284-$219,672
108$1,663$382$1,281-$219,290
109$1,663$384$1,279-$218,906
110$1,663$386$1,277-$218,520
111$1,663$389$1,275-$218,132
112$1,663$391$1,272-$217,741
113$1,663$393$1,270-$217,348
114$1,663$395$1,268-$216,952
115$1,663$398$1,266-$216,555
116$1,663$400$1,263-$216,155
117$1,663$402$1,261-$215,752
118$1,663$405$1,259-$215,347
119$1,663$407$1,256-$214,940
120$1,663$409$1,254-$214,531
121$1,663$412$1,251-$214,119
122$1,663$414$1,249-$213,705
123$1,663$417$1,247-$213,288
124$1,663$419$1,244-$212,869
125$1,663$422$1,242-$212,448
126$1,663$424$1,239-$212,024
127$1,663$426$1,237-$211,597
128$1,663$429$1,234-$211,168
129$1,663$431$1,232-$210,737
130$1,663$434$1,229-$210,303
131$1,663$436$1,227-$209,866
132$1,663$439$1,224-$209,427
133$1,663$442$1,222-$208,986
134$1,663$444$1,219-$208,542
135$1,663$447$1,216-$208,095
136$1,663$449$1,214-$207,645
137$1,663$452$1,211-$207,193
138$1,663$455$1,209-$206,739
139$1,663$457$1,206-$206,282
140$1,663$460$1,203-$205,822
141$1,663$463$1,201-$205,359
142$1,663$465$1,198-$204,894
143$1,663$468$1,195-$204,426
144$1,663$471$1,192-$203,955
145$1,663$474$1,190-$203,481
146$1,663$476$1,187-$203,005
147$1,663$479$1,184-$202,526
148$1,663$482$1,181-$202,044
149$1,663$485$1,179-$201,559
150$1,663$487$1,176-$201,072
151$1,663$490$1,173-$200,582
152$1,663$493$1,170-$200,088
153$1,663$496$1,167-$199,592
154$1,663$499$1,164-$199,093
155$1,663$502$1,161-$198,592
156$1,663$505$1,158-$198,087
157$1,663$508$1,156-$197,579
158$1,663$511$1,153-$197,068
159$1,663$514$1,150-$196,555
160$1,663$517$1,147-$196,038
161$1,663$520$1,144-$195,518
162$1,663$523$1,141-$194,995
163$1,663$526$1,137-$194,470
164$1,663$529$1,134-$193,941
165$1,663$532$1,131-$193,409
166$1,663$535$1,128-$192,874
167$1,663$538$1,125-$192,336
168$1,663$541$1,122-$191,794
169$1,663$544$1,119-$191,250
170$1,663$548$1,116-$190,702
171$1,663$551$1,112-$190,151
172$1,663$554$1,109-$189,597
173$1,663$557$1,106-$189,040
174$1,663$561$1,103-$188,480
175$1,663$564$1,099-$187,916
176$1,663$567$1,096-$187,349
177$1,663$570$1,093-$186,778
178$1,663$574$1,090-$186,205
179$1,663$577$1,086-$185,628
180$1,663$580$1,083-$185,047
181$1,663$584$1,079-$184,463
182$1,663$587$1,076-$183,876
183$1,663$591$1,073-$183,285
184$1,663$594$1,069-$182,691
185$1,663$598$1,066-$182,094
186$1,663$601$1,062-$181,493
187$1,663$605$1,059-$180,888
188$1,663$608$1,055-$180,280
189$1,663$612$1,052-$179,669
190$1,663$615$1,048-$179,053
191$1,663$619$1,044-$178,435
192$1,663$622$1,041-$177,812
193$1,663$626$1,037-$177,186
194$1,663$630$1,034-$176,557
195$1,663$633$1,030-$175,923
196$1,663$637$1,026-$175,286
197$1,663$641$1,023-$174,645
198$1,663$644$1,019-$174,001
199$1,663$648$1,015-$173,353
200$1,663$652$1,011-$172,701
201$1,663$656$1,007-$172,045
202$1,663$660$1,004-$171,385
203$1,663$664$1,000-$170,722
204$1,663$667$996-$170,054
205$1,663$671$992-$169,383
206$1,663$675$988-$168,708
207$1,663$679$984-$168,029
208$1,663$683$980-$167,346
209$1,663$687$976-$166,658
210$1,663$691$972-$165,967
211$1,663$695$968-$165,272
212$1,663$699$964-$164,573
213$1,663$703$960-$163,870
214$1,663$707$956-$163,162
215$1,663$711$952-$162,451
216$1,663$716$948-$161,735
217$1,663$720$943-$161,016
218$1,663$724$939-$160,292
219$1,663$728$935-$159,563
220$1,663$732$931-$158,831
221$1,663$737$927-$158,094
222$1,663$741$922-$157,353
223$1,663$745$918-$156,608
224$1,663$750$914-$155,858
225$1,663$754$909-$155,104
226$1,663$758$905-$154,345
227$1,663$763$900-$153,583
228$1,663$767$896-$152,815
229$1,663$772$891-$152,043
230$1,663$776$887-$151,267
231$1,663$781$882-$150,486
232$1,663$785$878-$149,701
233$1,663$790$873-$148,911
234$1,663$795$869-$148,116
235$1,663$799$864-$147,317
236$1,663$804$859-$146,513
237$1,663$809$855-$145,704
238$1,663$813$850-$144,891
239$1,663$818$845-$144,073
240$1,663$823$840-$143,250
241$1,663$828$836-$142,423
242$1,663$832$831-$141,590
243$1,663$837$826-$140,753
244$1,663$842$821-$139,911
245$1,663$847$816-$139,063
246$1,663$852$811-$138,211
247$1,663$857$806-$137,354
248$1,663$862$801-$136,492
249$1,663$867$796-$135,625
250$1,663$872$791-$134,753
251$1,663$877$786-$133,876
252$1,663$882$781-$132,994
253$1,663$887$776-$132,106
254$1,663$893$771-$131,214
255$1,663$898$765-$130,316
256$1,663$903$760-$129,413
257$1,663$908$755-$128,504
258$1,663$914$750-$127,591
259$1,663$919$744-$126,672
260$1,663$924$739-$125,747
261$1,663$930$734-$124,818
262$1,663$935$728-$123,883
263$1,663$941$723-$122,942
264$1,663$946$717-$121,996
265$1,663$952$712-$121,044
266$1,663$957$706-$120,087
267$1,663$963$701-$119,124
268$1,663$968$695-$118,156
269$1,663$974$689-$117,182
270$1,663$980$684-$116,202
271$1,663$985$678-$115,217
272$1,663$991$672-$114,226
273$1,663$997$666-$113,229
274$1,663$1,003$661-$112,226
275$1,663$1,009$655-$111,217
276$1,663$1,014$649-$110,203
277$1,663$1,020$643-$109,182
278$1,663$1,026$637-$108,156
279$1,663$1,032$631-$107,124
280$1,663$1,038$625-$106,085
281$1,663$1,044$619-$105,041
282$1,663$1,051$613-$103,990
283$1,663$1,057$607-$102,934
284$1,663$1,063$600-$101,871
285$1,663$1,069$594-$100,802
286$1,663$1,075$588-$99,727
287$1,663$1,082$582-$98,645
288$1,663$1,088$575-$97,557
289$1,663$1,094$569-$96,463
290$1,663$1,101$563-$95,363
291$1,663$1,107$556-$94,256
292$1,663$1,113$550-$93,142
293$1,663$1,120$543-$92,022
294$1,663$1,126$537-$90,896
295$1,663$1,133$530-$89,763
296$1,663$1,140$524-$88,623
297$1,663$1,146$517-$87,477
298$1,663$1,153$510-$86,324
299$1,663$1,160$504-$85,164
300$1,663$1,166$497-$83,998
301$1,663$1,173$490-$82,824
302$1,663$1,180$483-$81,644
303$1,663$1,187$476-$80,457
304$1,663$1,194$469-$79,263
305$1,663$1,201$462-$78,063
306$1,663$1,208$455-$76,855
307$1,663$1,215$448-$75,640
308$1,663$1,222$441-$74,418
309$1,663$1,229$434-$73,189
310$1,663$1,236$427-$71,952
311$1,663$1,244$420-$70,709
312$1,663$1,251$412-$69,458
313$1,663$1,258$405-$68,200
314$1,663$1,265$398-$66,934
315$1,663$1,273$390-$65,662
316$1,663$1,280$383-$64,381
317$1,663$1,288$376-$63,094
318$1,663$1,295$368-$61,798
319$1,663$1,303$360-$60,496
320$1,663$1,310$353-$59,185
321$1,663$1,318$345-$57,867
322$1,663$1,326$338-$56,542
323$1,663$1,333$330-$55,208
324$1,663$1,341$322-$53,867
325$1,663$1,349$314-$52,518
326$1,663$1,357$306-$51,161
327$1,663$1,365$298-$49,796
328$1,663$1,373$290-$48,423
329$1,663$1,381$282-$47,043
330$1,663$1,389$274-$45,654
331$1,663$1,397$266-$44,257
332$1,663$1,405$258-$42,852
333$1,663$1,413$250-$41,439
334$1,663$1,422$242-$40,017
335$1,663$1,430$233-$38,587
336$1,663$1,438$225-$37,149
337$1,663$1,447$217-$35,702
338$1,663$1,455$208-$34,247
339$1,663$1,463$200-$32,784
340$1,663$1,472$191-$31,312
341$1,663$1,481$183-$29,831
342$1,663$1,489$174-$28,342
343$1,663$1,498$165-$26,844
344$1,663$1,507$157-$25,338
345$1,663$1,515$148-$23,822
346$1,663$1,524$139-$22,298
347$1,663$1,533$130-$20,765
348$1,663$1,542$121-$19,222
349$1,663$1,551$112-$17,671
350$1,663$1,560$103-$16,111
351$1,663$1,569$94-$14,542
352$1,663$1,578$85-$12,963
353$1,663$1,588$76-$11,376
354$1,663$1,597$66-$9,779
355$1,663$1,606$57-$8,173
356$1,663$1,616$48-$6,557
357$1,663$1,625$38-$4,932
358$1,663$1,634$29-$3,298
359$1,663$1,644$19-$1,654
360$1,663$1,654$10-$0

How to use

  1. 01Enter principal, annual rate, and tenure in years.
  2. 02For prepayment scenarios, expand "Prepayment options". Add a recurring monthly extra (paid alongside EMI), a one-time lump sum, or both. Enter the month number when the lump sum is paid.
  3. 03The result card updates instantly. Recurring or lump-sum prepayment shows exactly how much interest you save and how many months earlier the loan closes.
  4. 04Switch to "Compare two loans" to evaluate two offers. The comparison row at the bottom highlights the cheaper option for each metric.
  5. 05Click "Copy schedule CSV" to paste the full month-by-month breakdown into Excel for charting.

FAQ

How is EMI calculated?

The standard reducing-balance EMI formula: EMI = P × r × (1 + r)^n / ((1 + r)^n - 1), where P is principal, r is monthly rate (annual / 12 / 100), and n is total months. The same formula every Indian and Western bank uses.

Does prepayment reduce EMI or tenure?

In this calculator, prepayment reduces tenure while keeping EMI fixed. That is the more common option offered by banks because it produces the highest interest savings. Some banks let you choose to reduce EMI instead, in which case the tenure stays the same and the EMI reduces from the next month.

Why does month 1 interest equal almost the full EMI?

In a fresh loan, the outstanding balance is at its maximum, so interest in the first months consumes most of the EMI. The principal portion grows each month as the balance shrinks. Halfway through a 20-year loan you are paying roughly half interest and half principal. Toward the end, almost the entire EMI is principal.

How much interest can prepayment save?

A lot, if you do it early. ₹5000 extra per month on a ₹50 lakh, 20-year loan at 8.5% saves roughly 4 years and several lakhs of interest. The earlier in the tenure you prepay, the bigger the saving, because you reduce the balance during the high-interest portion of the schedule.

What is a fair comparison between two loans?

Look at total cost paid, not just EMI. A lower EMI with a longer tenure usually means more total interest. The comparison row in the tool flags which loan wins on each metric (EMI, total interest, months to close). Pick based on what you care about most: lowest cash outflow per month or lowest total cost.

Are these results bank-accurate?

The math is the same as banks use for reducing-balance loans. Banks may add small differences for processing fees, GST on fees, late-payment charges, and how they round to paise. The principle is identical and the differences are usually under 0.5%.

More in Productivity