About the Home Loan EMI Calculator
Calculate the monthly EMI, total interest, and full amortization schedule for a home loan, model a one-time prepayment to see the effect on tenure and interest, and export the complete monthly schedule as CSV.
₹
Home Loan EMI Calculator
Calculate EMI, interest, amortization, and prepayment impact.
Monthly EMI
₹22,493
Total interest
₹28,98,355
Total payment
₹53,98,355
Cumulative principal vs. interest paid
Amortization schedule (yearly)
Swipe horizontally to view the full schedule →
| Year | Principal paid | Interest paid | Closing balance |
|---|---|---|---|
| ₹46,818 | ₹2,23,100 | ₹24,53,182 | |
| ₹51,210 | ₹2,18,708 | ₹24,01,973 | |
| ₹56,013 | ₹2,13,904 | ₹23,45,959 | |
| ₹61,268 | ₹2,08,650 | ₹22,84,691 | |
| ₹67,015 | ₹2,02,903 | ₹22,17,676 | |
| ₹73,302 | ₹1,96,616 | ₹21,44,374 | |
| ₹80,178 | ₹1,89,740 | ₹20,64,197 | |
| ₹87,699 | ₹1,82,219 | ₹19,76,497 | |
| ₹95,926 | ₹1,73,992 | ₹18,80,571 | |
| ₹1,04,924 | ₹1,64,993 | ₹17,75,647 | |
| ₹1,14,767 | ₹1,55,151 | ₹16,60,880 | |
| ₹1,25,533 | ₹1,44,385 | ₹15,35,347 | |
| ₹1,37,309 | ₹1,32,609 | ₹13,98,038 | |
| ₹1,50,189 | ₹1,19,728 | ₹12,47,849 | |
| ₹1,64,278 | ₹1,05,640 | ₹10,83,570 | |
| ₹1,79,689 | ₹90,229 | ₹9,03,882 | |
| ₹1,96,545 | ₹73,373 | ₹7,07,337 | |
| ₹2,14,982 | ₹54,936 | ₹4,92,355 | |
| ₹2,35,149 | ₹34,769 | ₹2,57,207 | |
| ₹2,57,207 | ₹12,711 | ₹0 |
AI insight
Get a brief, general explanation of what these results mean. This is educational information, not personalized financial advice.
How the result is produced
The EMI uses the reducing-balance formula `E = P × r × (1+r)^n / ((1+r)^n - 1)`, where `P` is principal, `r` is monthly interest, and `n` is the number of months. Optional prepayments rebuild the remaining schedule.
Example: Enter a ₹50 lakh loan, annual rate, and tenure to compare the monthly EMI, total interest, and cumulative principal-versus-interest schedule.
Limitations and review notes
The estimate does not include lender fees, insurance, floating-rate resets, penalties, rounding rules, or every prepayment policy. Confirm the repayment schedule and terms with the lender.
How to use it
- 1. Enter the loan amount, interest rate, and tenure.
- 2. Optionally enable a one-time prepayment with the month and amount.
- 3. Review EMI, total interest, and the cumulative principal/interest chart.
- 4. Expand a year in the amortization table for monthly detail, or download the full CSV.
FAQ
How is the EMI calculated?
Using the standard reducing-balance EMI formula based on loan amount, annual interest rate, and tenure in months.
How does the one-time prepayment work?
A lump-sum prepayment is applied in the month you choose, reducing the outstanding principal. The EMI stays the same, so the loan tenure shortens and total interest drops.
Can I download the full amortization schedule?
Yes. Download the complete month-by-month schedule as a CSV file from the amortization table.
Related tools
View category →Compound Interest CalculatorAICompare compounding frequency, principal, rate, and time.₹compound interest · calculator · investmentIncome Tax CalculatorAICompare Indian old and new tax regime estimates.₹income tax · calculator · indiaHRA CalculatorEstimate HRA exemption using salary, rent, and city type.₹hra · house rent allowance · tax
Was this useful?