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
Step-by-step guide to get the most from this tool
Select Home, Car, or Personal loan preset, or manually set loan amount, interest rate, and tenure.
Open Advanced Options to add lump-sum or monthly prepayments and choose reduce-tenure or reduce-EMI mode.
See monthly EMI, total interest, pie chart breakdown, and scrollable amortization table.
Download the full schedule as CSV or copy a shareable link with your inputs.
What makes this tool stand out
Month-by-month principal, interest, and balance breakdown.
Model lump-sum and recurring prepayments with tenure or EMI reduction.
Quick-start templates for home, car, and personal loans.
Download the complete schedule for Excel or Google Sheets.
Copy a link with your loan parameters pre-filled.
Pie chart showing principal vs total interest paid.
More free utilities you might find useful
Quick answers to common questions
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.
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.
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.
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.
Yes. Click Download CSV to export the full month-by-month schedule with principal, interest, prepayment, and balance columns.
RBI guidelines prohibit prepayment penalties on floating rate home loans from banks. Fixed rate loans may have penalties — check your loan agreement.
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).
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.
Your data is processed entirely in your browser. Nothing is sent to any server.
| Year | Opening Balance | Principal Paid | Interest Paid | Closing Balance |
|---|---|---|---|---|
| 1 | ₹5,00,000 | ₹9,951 | ₹42,118 | ₹4,90,049 |
| 2 | ₹4,90,049 | ₹10,831 | ₹41,239 | ₹4,79,218 |
| 3 | ₹4,79,218 | ₹11,788 | ₹40,281 | ₹4,67,430 |
| 4 | ₹4,67,430 | ₹12,830 | ₹39,239 | ₹4,54,600 |
| 5 | ₹4,54,600 | ₹13,964 | ₹38,105 | ₹4,40,636 |
| 6 | ₹4,40,636 | ₹15,198 | ₹36,871 | ₹4,25,438 |
| 7 | ₹4,25,438 | ₹16,542 | ₹35,528 | ₹4,08,896 |
| 8 | ₹4,08,896 | ₹18,004 | ₹34,065 | ₹3,90,892 |
| 9 | ₹3,90,892 | ₹19,595 | ₹32,474 | ₹3,71,296 |
| 10 | ₹3,71,296 | ₹21,327 | ₹30,742 | ₹3,49,969 |
| 11 | ₹3,49,969 | ₹23,213 | ₹28,857 | ₹3,26,757 |
| 12 | ₹3,26,757 | ₹25,264 | ₹26,805 | ₹3,01,492 |
| 13 | ₹3,01,492 | ₹27,497 | ₹24,572 | ₹2,73,995 |
| 14 | ₹2,73,995 | ₹29,928 | ₹22,141 | ₹2,44,067 |
| 15 | ₹2,44,067 | ₹32,573 | ₹19,496 | ₹2,11,494 |
| 16 | ₹2,11,494 | ₹35,452 | ₹16,617 | ₹1,76,041 |
| 17 | ₹1,76,041 | ₹38,586 | ₹13,483 | ₹1,37,455 |
| 18 | ₹1,37,455 | ₹41,997 | ₹10,073 | ₹95,458 |
| 19 | ₹95,458 | ₹45,709 | ₹6,360 | ₹49,749 |
| 20 | ₹49,749 | ₹49,749 | ₹2,320 | ₹0 |
| TOTAL | — | ₹5,00,000 | ₹5,41,388 | ₹10,41,388 |
EMI = P × r × (1 + r)ⁿ / ((1 + r)ⁿ − 1)P is the principal loan amount, r is the monthly interest rate (annual rate divided by 12 and then by 100), and n is the total number of monthly installments (loan tenure in years multiplied by 12).
| Symbol | Meaning |
|---|---|
| P | Principal loan amount |
| r | Monthly interest rate (annual rate ÷ 1200) |
| n | Number of monthly installments |