EMI Calculator

Calculate your monthly EMI instantly. Download your full amortization schedule as Excel — free, private, browser-only.

Home Loan Car Loan Personal Loan Excel Download No Data Shared
Loan Details
₹10K₹1 Cr
%
1%36%
1 yr30 yrs
Your EMI Summary

Fill in the loan details and click Calculate EMI

How EMI is Calculated

EMI = P × r × (1+r)ⁿ ÷ [(1+r)ⁿ − 1] where P = principal, r = monthly rate, n = months. Standard reducing-balance method used by all banks.

What's in the Excel File

Your Excel contains a summary sheet (EMI, total interest, total payment) plus a full month-by-month schedule showing principal, interest, and closing balance.

100% Private

All calculations happen in your browser. No data is sent to any server. Your loan details stay on your device.

Tips to Reduce EMI

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.

The EMI Formula, and What Each Part Does

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.

A worked example

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.

Why Your Early EMIs Barely Touch the Principal

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.

What Tenure Actually Costs You

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%.

TenureApproximate EMIApproximate 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.

Prepayment: Cut the EMI or Cut the Tenure

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.

Why Your Actual Outgo Exceeds the EMI

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.

Floating Rates and What This Calculator Assumes

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.

This page explains how instalment arithmetic works and is general educational information, not financial advice. It does not account for your circumstances, and it does not model moratoriums, step-up or step-down schedules, part-disbursement during construction, or mid-term rate changes. Confirm any actual figures with your lender's sanction letter and amortisation schedule.

Your Loan Details Never Leave This Page

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.

Frequently Asked Questions

How is EMI calculated?

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.

Why is most of my early EMI going to interest?

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.

Is it better to reduce the EMI or the tenure when prepaying?

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.

How much does a longer tenure really cost?

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.

Does this calculator handle floating rate loans?

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.

Are my loan details sent anywhere?

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.