Finance

EMI Calculator — Calculate Loan EMI Online Free

Calculate monthly EMI for home, car, and personal loans. Full amortization schedule, prepayment planner, CSV export, and loan presets — free for India.

Also searched as: loan emi calculator · home loan emi calculator · equated monthly installment calculator · loan amortization calculator · mortgage calculator

AmortizationPrepaymentCSV ExportFree
₹10,00,000
8.5%
Monthly EMI
8,678
240 months · Interest ₹10,82,776
Principal
10,00,000
Total Interest
10,82,776
Total Payment
20,82,776
Principal
10,00,000
Interest
10,82,776

Amortization Schedule

MonthEMIPrincipalInterestPrepayBalance
18,6781,5957,0839,98,405
28,6781,6067,0729,96,799
38,6781,6187,0619,95,181
48,6781,6297,0499,93,552
58,6781,6417,0389,91,912
68,6781,6527,0269,90,260
78,6781,6647,0149,88,596
88,6781,6767,0039,86,920
98,6781,6886,9919,85,232
108,6781,7006,9799,83,533
118,6781,7126,9679,81,821
128,6781,7246,9559,80,098
138,6781,7366,9429,78,362
148,6781,7486,9309,76,614
158,6781,7616,9189,74,853
168,6781,7736,9059,73,080
178,6781,7866,8939,71,295
188,6781,7986,8809,69,496
198,6781,8116,8679,67,685
208,6781,8246,8549,65,862
218,6781,8376,8429,64,025
228,6781,8506,8299,62,175
238,6781,8636,8159,60,312
248,6781,8766,8029,58,436
258,6781,8896,7899,56,547
268,6781,9036,7769,54,644
278,6781,9166,7629,52,728
288,6781,9306,7489,50,798
298,6781,9436,7359,48,855
308,6781,9576,7219,46,898
318,6781,9716,7079,44,927
328,6781,9856,6939,42,942
338,6781,9996,6799,40,943
348,6782,0136,6659,38,929
358,6782,0276,6519,36,902
368,6782,0426,6369,34,860
378,6782,0566,6229,32,804
388,6782,0716,6079,30,733
398,6782,0866,5939,28,647
408,6782,1006,5789,26,547
418,6782,1156,5639,24,432
428,6782,1306,5489,22,302
438,6782,1456,5339,20,156
448,6782,1606,5189,17,996
458,6782,1766,5029,15,820
468,6782,1916,4879,13,629
478,6782,2076,4729,11,422
488,6782,2226,4569,09,200
498,6782,2386,4409,06,962
508,6782,2546,4249,04,708
518,6782,2706,4089,02,438
528,6782,2866,3929,00,152
538,6782,3026,3768,97,850
548,6782,3186,3608,95,532
558,6782,3356,3438,93,197
568,6782,3516,3278,90,845
578,6782,3686,3108,88,477
588,6782,3856,2938,86,092
598,6782,4026,2768,83,691
608,6782,4196,2598,81,272
618,6782,4366,2428,78,836
628,6782,4536,2258,76,383
638,6782,4716,2088,73,912
648,6782,4886,1908,71,424
658,6782,5066,1738,68,919
668,6782,5236,1558,66,395
678,6782,5416,1378,63,854
688,6782,5596,1198,61,295
698,6782,5776,1018,58,717
708,6782,5966,0838,56,122
718,6782,6146,0648,53,508
728,6782,6336,0468,50,875
738,6782,6516,0278,48,224
748,6782,6706,0088,45,554
758,6782,6895,9898,42,865
768,6782,7085,9708,40,157
778,6782,7275,9518,37,430
788,6782,7465,9328,34,683
798,6782,7665,9128,31,918
808,6782,7855,8938,29,132
818,6782,8055,8738,26,327
828,6782,8255,8538,23,502
838,6782,8455,8338,20,657
848,6782,8655,8138,17,791
858,6782,8865,7938,14,906
868,6782,9065,7728,12,000
878,6782,9275,7528,09,073
888,6782,9475,7318,06,126
898,6782,9685,7108,03,158
908,6782,9895,6898,00,169
918,6783,0105,6687,97,158
928,6783,0325,6477,94,127
938,6783,0535,6257,91,073
948,6783,0755,6037,87,999
958,6783,0975,5827,84,902
968,6783,1195,5607,81,784
978,6783,1415,5387,78,643
988,6783,1635,5157,75,480
998,6783,1855,4937,72,295
1008,6783,2085,4707,69,087
1018,6783,2315,4487,65,857
1028,6783,2535,4257,62,603
1038,6783,2765,4027,59,327
1048,6783,3005,3797,56,027
1058,6783,3235,3557,52,704
1068,6783,3475,3327,49,357
1078,6783,3705,3087,45,987
1088,6783,3945,2847,42,593
1098,6783,4185,2607,39,175
1108,6783,4425,2367,35,732
1118,6783,4675,2117,32,266
1128,6783,4915,1877,28,774
1138,6783,5165,1627,25,258
1148,6783,5415,1377,21,717
1158,6783,5665,1127,18,151
1168,6783,5915,0877,14,560
1178,6783,6175,0617,10,943
1188,6783,6425,0367,07,301
1198,6783,6685,0107,03,632
1208,6783,6944,9846,99,938

Showing first 120 months. Download CSV for full schedule.

How to Use

Step-by-step guide to get the most from this tool

  1. 1

    Choose a loan preset or enter details

    Select Home, Car, or Personal loan preset, or manually set loan amount, interest rate, and tenure.

  2. 2

    Configure prepayments (optional)

    Open Advanced Options to add lump-sum or monthly prepayments and choose reduce-tenure or reduce-EMI mode.

  3. 3

    Review EMI and schedule

    See monthly EMI, total interest, pie chart breakdown, and scrollable amortization table.

  4. 4

    Export or share

    Download the full schedule as CSV or copy a shareable link with your inputs.

Features

What makes this tool stand out

📅

Amortization schedule

Month-by-month principal, interest, and balance breakdown.

💸

Prepayment planner

Model lump-sum and recurring prepayments with tenure or EMI reduction.

🏠

Loan presets

Quick-start templates for home, car, and personal loans.

📥

CSV export

Download the complete schedule for Excel or Google Sheets.

🔗

Shareable URL

Copy a link with your loan parameters pre-filled.

📊

Visual breakdown

Pie chart showing principal vs total interest paid.

Related Tools

More free utilities you might find useful

Frequently Asked Questions

Quick answers to common questions

What is EMI?+

EMI (Equated Monthly Instalment) is a fixed payment made each month to repay a loan. Each EMI covers both principal and interest on the outstanding balance using the reducing balance method.

How is EMI calculated?+

EMI = [P × R × (1+R)^N] / [(1+R)^N − 1], where P is principal, R is monthly interest rate (annual rate ÷ 12), and N is tenure in months.

What is the difference between EMI in advance and arrears?+

EMI in arrears is paid at the end of each month (standard for most loans). EMI in advance is paid at the start of the month, resulting in a slightly lower EMI amount.

How do prepayments reduce my loan?+

Prepayments reduce outstanding principal. You can choose to reduce tenure (same EMI, loan ends sooner) or reduce EMI (same tenure, lower monthly payment). Reducing tenure saves more total interest.

Can I download the amortization schedule?+

Yes. Click Download CSV to export the full month-by-month schedule with principal, interest, prepayment, and balance columns.

Is there a prepayment penalty on home loans?+

RBI guidelines prohibit prepayment penalties on floating rate home loans from banks. Fixed rate loans may have penalties — check your loan agreement.

Which loan preset should I use?+

Use Home Loan for mortgages (typically 8–9% for 15–30 years), Car Loan for vehicle finance (9–12% for 3–7 years), or Personal Loan for unsecured credit (11–18% for 1–5 years).

Does this calculator work for all banks?+

Yes. The reducing balance EMI formula is standard across Indian banks and NBFCs. Actual EMI may differ slightly due to processing fees, insurance, or rounding.