Calculate your monthly EMI instantly. Download your full amortization schedule as Excel — free, private, browser-only.
Fill in the loan details and click Calculate EMI
EMI = P × r × (1+r)ⁿ ÷ [(1+r)ⁿ − 1] where P = principal, r = monthly rate, n = months. Standard reducing-balance method used by all banks.
Your Excel contains a summary sheet (EMI, total interest, total payment) plus a full month-by-month schedule showing principal, interest, and closing balance.
All calculations happen in your browser. No data is sent to any server. Your loan details stay on your device.
A longer tenure lowers the EMI but increases total interest paid. Making part-prepayments reduces the principal and saves significant interest over the loan life.
An equated monthly instalment is a single fixed payment that clears both interest and principal over a fixed term. It is derived from the present value of an annuity, and written out it is EMI = P × r × (1+r)^n / ((1+r)^n − 1), where P is the amount borrowed, n is the number of monthly instalments and r is the monthly interest rate.
The detail that trips people up is r. Lenders quote an annual rate, but the formula needs a monthly one, so a quoted 8.5% becomes 0.085 ÷ 12, or roughly 0.00708 per month. Similarly n is months, not years: a twenty-year loan is 240, not 20. Getting either of these wrong produces an answer that is wrong by an order of magnitude, which is usually obvious, or subtly wrong in a way that is not.
Borrow ₹30,00,000 at 8.5% for 20 years. The monthly rate is about 0.708% and there are 240 instalments, which gives an EMI of approximately ₹26,035. Over the full term you pay about ₹62.5 lakh, of which roughly ₹32.5 lakh is interest. In other words the interest slightly exceeds the amount borrowed, which surprises most first-time borrowers and is entirely normal at that rate and tenure.
The instalment stays constant but its composition changes every month. Interest is charged on the outstanding balance, so when the balance is at its largest, at the start, interest consumes most of the payment. As the balance falls the interest portion shrinks and the principal portion grows, slowly at first and then quickly near the end.
In the example above, the first instalment is roughly ₹21,250 interest and only ₹4,785 principal. It takes over a decade before the split crosses the halfway point. This is the single most useful thing to understand about a long loan, because it explains why the outstanding balance after five years of diligent payment feels disappointingly close to where it started, and why prepayments made early are so much more effective than the same amount paid later.
Stretching a loan reduces the monthly instalment and increases the total paid, but not proportionally. The table shows the same ₹30 lakh at 8.5%.
| Tenure | Approximate EMI | Approximate total interest |
|---|---|---|
| 10 years | ₹37,200 | ₹14.6 lakh |
| 15 years | ₹29,540 | ₹23.2 lakh |
| 20 years | ₹26,035 | ₹32.5 lakh |
| 25 years | ₹24,160 | ₹42.5 lakh |
| 30 years | ₹23,070 | ₹53.0 lakh |
Read the last two rows together. Extending from 25 to 30 years lowers the instalment by about ₹1,090 a month but adds roughly ₹10.5 lakh of interest. The relationship flattens out: each extra block of years buys progressively less relief on the monthly figure while adding steadily more to the total. Seeing both columns at once is the point of an EMI calculator.
When you make a lump-sum prepayment most lenders will let you choose between two outcomes. Reducing the instalment keeps the original end date and frees up monthly cash flow. Reducing the tenure keeps the instalment where it is and finishes the loan earlier. The second saves substantially more interest, because interest accrues on time as well as on balance, but it does nothing for your monthly budget.
There is no universally correct choice; it depends on whether the constraint you are managing is cash flow or total cost. What is worth knowing is that lenders often default to reducing the EMI unless you ask otherwise, and that the request usually has to be made in writing at the time of prepayment. Floating rate home loans to individuals generally cannot carry prepayment penalties in India, while fixed rate loans and many personal loans can, so check the sanction letter before planning around it.
The instalment is not the whole cost of a loan. Before disbursement there is typically a processing fee, legal and technical valuation charges, stamp duty on the loan agreement in some states, and often a bundled insurance premium that may be financed into the loan itself. During the loan there can be conversion fees when you renegotiate a rate, and charges for statements or foreclosure letters.
Some of these are unavoidable and some are negotiable, but they belong in any comparison between lenders. A slightly lower headline rate paired with a much larger processing fee can be the worse deal on a short tenure and the better one on a long tenure, which is a calculation worth doing explicitly rather than by instinct.
This calculator models a fixed rate for the full tenure. Most Indian home loans are floating, benchmarked to an external rate that resets periodically. When the benchmark moves, lenders typically hold the instalment steady and adjust the tenure instead, which means a rate rise can silently extend your loan by years without changing anything you see in your bank statement.
It is worth asking your lender for the revised amortisation schedule after any reset, because the tenure change is the part that is easy to miss. Re-running this calculator with the new rate and your current outstanding balance will show you what the remaining term should look like.
Loan amounts, interest rates and tenures say a great deal about your finances, and there is no reason for any of it to be transmitted to run a formula. Everything on this page is computed in your browser using JavaScript that loaded with the page. Nothing you enter is uploaded, saved between visits, or attached to an analytics event, and the downloadable amortisation schedule is assembled on your own device rather than fetched from a server. You can confirm all of this by opening your browser's network tab, or simply by disconnecting from the internet and watching the calculator continue to work.
EMI = P × r × (1+r)^n / ((1+r)^n − 1), where P is the loan amount, r is the monthly interest rate and n is the number of monthly instalments. The two common mistakes are using the annual rate instead of dividing it by twelve, and using years instead of months for n.
Interest is charged on the outstanding balance, which is largest at the start, so early instalments are mostly interest and very little principal. On a ₹30 lakh loan at 8.5% for 20 years, the first instalment is roughly ₹21,250 interest against ₹4,785 principal, and the split only crosses halfway after about a decade.
Reducing the tenure saves considerably more interest because interest accrues over time as well as on balance. Reducing the instalment improves monthly cash flow but keeps the original end date. Lenders often default to reducing the EMI, so state your preference in writing when you prepay.
Each additional block of years lowers the instalment by less and adds more to the total interest. On ₹30 lakh at 8.5%, moving from 25 to 30 years lowers the EMI by around ₹1,090 a month but adds roughly ₹10.5 lakh in interest over the life of the loan.
It models a fixed rate for the full tenure. Most Indian home loans are floating and reset periodically, and lenders usually absorb a rate change by extending the tenure rather than changing the instalment. After a reset, re-run the calculation with your new rate and current outstanding balance to see the revised term.
No. All calculations, including the amortisation schedule you can download, run in your browser on your own device. Nothing is uploaded, stored or logged, and the page keeps working with your internet connection switched off.
We use cookies for analytics and to show ads (Google Analytics & AdSense). Your files are never uploaded — only standard cookies are used. See our Privacy Policy.