How a loan EMI is calculated
Published · Updated
An EMI, or equated monthly instalment, is the fixed amount you pay each month until a loan is repaid. It looks simple, but it hides a split: every payment covers the interest that has built up and pays off a little of the loan itself. Knowing how that split works shows why a few extra payments can save so much.
Try it now: Loan EMI Calculator, Compound Interest Calculator.
What is the EMI formula?
The EMI is P × i × (1 + i)^n ÷ ((1 + i)^n − 1). P is the amount borrowed. i is the interest rate for one payment period, which for monthly payments is the yearly rate divided by 12 and by 100. n is the number of payments. An equivalent way to write it is P × i ÷ (1 − (1 + i)^−n), and with a zero rate the loan is simply divided into equal parts.
How do I calculate an EMI by hand?
Work out the monthly rate, the number of payments and the growth factor, then divide, as in the six steps below. All you need is a calculator with a power key (usually marked x^y or ^). Take a small loan so the numbers are easy to follow: 100,000 borrowed at 12 percent a year, repaid over 1 year in monthly instalments.
| Step | What to do | Result |
|---|---|---|
| 1. Monthly rate (i) | Yearly rate ÷ 12 ÷ 100: 12 ÷ 12 ÷ 100 | 0.01 |
| 2. Number of payments (n) | Years × 12: 1 × 12 | 12 |
| 3. Growth factor | (1 + i)^n: 1.01 to the power 12 | 1.126825 |
| 4. Top of the fraction | P × i × growth factor: 100,000 × 0.01 × 1.126825 | 1,126.825 |
| 5. Bottom of the fraction | Growth factor − 1: 1.126825 − 1 | 0.126825 |
| 6. EMI | Top ÷ bottom: 1,126.825 ÷ 0.126825 | 8,884.88 |
How can I check my EMI answer?
You can test the result without a calculator that knows loans. In month 1 the interest is the whole balance times the monthly rate: 100,000 × 0.01 = 1,000. The rest of the 8,884.88 pays off the loan, which is 7,884.88, so the balance falls to 92,115.12. Repeat that for 12 months and the balance should reach zero. The total paid is 106,618.53, so the interest is 6,618.53, about 6.6 percent of the amount borrowed. The last payment is 8,884.85, a few cents lower, because the payments are rounded to the cent along the way.
How do I calculate an EMI in Excel?
Excel and Google Sheets have a function that does the whole formula. Enter =PMT(12%/12, 12, -100000) and it returns 8,884.88. The three inputs are the monthly rate, the number of payments and the amount borrowed, which is written as a negative number so that the answer comes out positive. For a different loan, change the rate, the 12 payments and the amount. The calculator on this site gives the same figure and also shows the full schedule. The loan EMI calculator gives the same figure and the full schedule.
What mistakes give the wrong EMI?
Most wrong answers come from one of these slips. The figures use the same 100,000 loan.
| Mistake | What you get | Correct |
|---|---|---|
| Using the yearly rate as i (0.12 instead of 0.01) | 16,144 | 8,884.88 |
| Using years for n (1 instead of 12) | 101,000 | 8,884.88 |
| Rounding the growth factor to 1.13 | 8,692.31 | 8,884.88 |
How many digits should I keep?
The growth factor is the part that is easy to round too early. Keep at least six decimal places until the final division, as in the steps above. Fees are another gap: a processing fee, insurance or other charges are not part of the EMI formula, so they are not in the result. Add them separately when you compare the true cost of two loans.
What does a 30-year loan EMI look like?
Borrow 100,000 at 6 percent a year for 30 years. The monthly rate is 6 ÷ 12 ÷ 100 = 0.005 and there are 360 payments, so the EMI is 599.55. Over the whole loan you pay 215,838.45, of which 115,838.45 is interest, more than the amount you borrowed. The last payment is 600.00, a few cents higher, because it clears the rounding left by the earlier ones.
Why are early EMI payments mostly interest?
Each month the interest is the remaining balance times the monthly rate, and whatever is left of the payment reduces the balance. At the start the balance is at its highest, so the interest is too:
| Payment | Interest | Principal | Balance after |
|---|---|---|---|
| 1 | 500.00 | 99.55 | 99,900.45 |
| 180 (halfway) | 356.46 | 243.09 | 71,048.97 |
| 360 (last) | 2.99 | 597.01 | 0.00 |
When does the principal overtake the interest?
The payment never changes, but the interest falls as the balance falls, so the principal share grows. In this loan the principal first exceeds the interest at payment 223, after more than 18 years. That slow start is why paying off a loan early in its life saves far more than paying it off late.
Does a shorter loan cost less interest?
Borrow 500,000 at 10 percent for 5 years and the EMI is 10,623.52. The total interest is 137,411.38, about 27 percent of the amount borrowed, compared with about 116 percent in the 30-year example, even though the rate is higher. The longer you take, the more interest has time to build.
What does an extra EMI payment do?
Take 200,000 at 5 percent for 30 years. The EMI is 1,073.64 and the total interest is 186,513.24 over 360 payments. Add 200 to every payment and the loan is cleared after 256 payments, which is 21 years and 4 months. The interest falls to 125,351.80, so you save 61,161.44 and 104 payments. The extra money goes straight to the balance, so every later month’s interest is smaller. The compound interest guide explains why early money matters most.
What is the difference between a flat rate and a reducing balance rate?
Some lenders quote a flat rate, where interest is charged on the original amount for the whole term. A reducing-balance rate charges it only on what you still owe. A flat rate looks lower than a reducing-balance rate for the same loan, so to compare offers, ask for the reducing-balance rate or the annual percentage rate.
Here is the same 100,000 loan for 1 year at 12 percent, quoted both ways. With a flat rate the interest is 100,000 × 12% × 1 = 12,000, so you repay 112,000 and the EMI is 112,000 ÷ 12 = 9,333.33. With a reducing-balance rate the EMI is 8,884.88 and the interest is 6,618.53. The flat rate costs 5,381.47 more, because you keep paying interest on money you have already repaid. Put another way, a flat 12 percent here is about the same as a reducing-balance rate of 21.5 percent.