Skip to content
How-to

How Is Loan EMI Calculated?

Updated

An EMI (equated monthly instalment) is the fixed amount you pay every month until a loan is repaid. Each EMI pays that month's interest first, and the rest reduces what you owe. Here is how banks work it out, with a worked example.

The EMI formula

EMI = P × r × (1 + r)^n ÷ ((1 + r)^n − 1). P is the loan amount, r is the monthly interest rate (the yearly rate divided by 12, then by 100) and n is the number of monthly instalments. It is the same calculation as the PMT function in Excel and Google Sheets.

A worked example

Take a loan of ₹10,00,000 at 9% a year for 20 years. The monthly rate r is 9 ÷ 12 ÷ 100 = 0.0075 and n is 240 months. Putting those into the formula gives an EMI of ₹8,997. Over 20 years you pay ₹21,59,454 in total, of which ₹11,59,454 is interest: more than the amount you borrowed.

Why early EMIs are mostly interest

Interest is charged each month on the amount still owed. In month one of the example, interest is 0.75% of ₹10,00,000, which is ₹7,500, so only ₹1,497 of the ₹8,997 EMI reduces the loan. As the balance falls, the interest part shrinks and the principal part grows, until the last EMIs are almost all principal. The month-by-month table of this split is called the amortisation schedule.

How the tenure changes the cost

A longer tenure lowers the EMI but raises the total interest. For the same ₹10 lakh at 9%, a 15-year loan has an EMI of ₹10,143 and total interest of ₹8,25,614. Stretching it to 25 years cuts the EMI to ₹8,392 but raises the interest to ₹15,17,559.

How the interest rate changes the cost

Small rate differences add up over long loans. At 8.5% the 20-year EMI on ₹10 lakh is ₹8,678 with ₹10,82,866 of interest; at 10% it is ₹9,650 with ₹13,16,164. That 1.5-point gap costs over ₹2.3 lakh. Compare offers on their total cost, including processing fees, not only on the EMI.

Prepayments save interest

Paying extra towards the loan cuts the balance that interest is charged on. In the example, one prepayment of ₹1,00,000 in month 12, keeping the same EMI, ends the loan in 190 months instead of 240 and cuts total interest to about ₹8,05,411, a saving of around ₹3.5 lakh. Most banks don't charge for prepaying a floating-rate home loan taken by an individual; check your loan terms.

Why your bank's figure may differ slightly

Banks round the EMI in different ways and some charge interest by the day, or add interest for the days before the first EMI. The difference is usually a few rupees a month. Floating-rate loans also change when the bank's benchmark rate changes; the bank then adjusts either the EMI or the tenure.

Try your own numbers

The EMI Calculator shows your EMI, total interest and the full schedule grouped by financial year. The Home Loan Prepayment Calculator shows what prepayments save, and the Loan Comparison Calculator compares offers including fees. These are estimates: confirm the final figures with your lender.