Before you learn how to calculate loan EMI, it helps to understand what those three letters actually stand for. EMI — Equated Monthly Instalment — is the fixed monthly payment you pay your lender every single month until your loan is fully repaid. Mortgage, car loan, personal loan, student loan: nearly all of them run on EMIs.
Why “equated”? Because the number never changes, even though what’s inside it does. In your early payments, most of the EMI is interest and only a sliver touches the principal. Over time the split quietly flips — more principal, less interest — until the last payment wipes the balance to zero. This slow flip is called amortisation, and it is the single most important thing to understand about your loan.
Here is the practical question every borrower asks: “What will my monthly payment be?” Banks are happy to tell you — after you sit through the sales pitch. But running the numbers yourself first means you walk in knowing exactly what you can afford and spotting a bad offer before it costs you thousands.
Table of Contents
The EMI Formula (The Only One You Need)
Every EMI on the planet is built from this formula:
EMI = P × r × (1 + r)^n ÷ ((1 + r)^n − 1)
Let us decode each piece in plain English:
- P = the principal, the amount you borrow. Not the price of the house — the amount left after your down payment.
- r = the MONTHLY interest rate. This is where mistakes happen: take the annual rate and divide by 12. A 6% annual rate means r = 0.06 ÷ 12 = 0.005.
- n = the number of monthly payments. A 30-year mortgage means n = 360. A 5-year car loan means n = 60.
- (1 + r)^n = the “growth factor” — how much one unit of currency would grow over the loan’s life at that rate.
The formula looks intimidating, so here is the intuition: it solves for the fixed monthly payment whose total future value exactly pays off the loan plus all its interest. You will never compute that exponent by hand on a calculator app — but understanding what each input does is how you compare loan offers like a professional.
How to Calculate Loan EMI by Hand: Example 1 — The Mortgage
Let us walk through a real mortgage, slowly. You borrow $200,000 at 6% annual interest for 30 years.
Step 1 — Find r: 0.06 ÷ 12 = 0.005.
Step 2 — Find n: 30 × 12 = 360.
Step 3 — Compute the growth factor: (1.005)^360 ≈ 6.0226. (Use your phone’s scientific calculator — it handles this instantly.)
Step 4 — Plug in: EMI = 200,000 × 0.005 × 6.0226 ÷ (6.0226 − 1) = 1,000 × 6.0226 ÷ 5.0226 = 1,000 × 1.1991 ≈ $1,199.10 per month.
So your mortgage payment is $1,199.10 every month for 30 years. Total paid: $1,199.10 × 360 = $431,676. Subtract the $200,000 you borrowed and you have paid $231,676 in interest — more than the loan itself. That is the true price of borrowing over three decades, and it is exactly why comparing offers matters.
Example 2 — The Car Loan
A $25,000 car at 8% annual interest over 5 years.
Step 1 — r = 0.08 ÷ 12 = 0.006667.
Step 2 — n = 5 × 12 = 60.
Step 3 — (1.006667)^60 ≈ 1.4899.
Step 4 — EMI = 25,000 × 0.006667 × 1.4899 ÷ 0.4899 = 166.67 × 3.0419 ≈ $507 per month.
Total paid: $507 × 60 = $30,420 — meaning $5,420 in interest. Now compare that to a 3-year term at the same rate: EMI jumps to about $783, but total interest falls to roughly $3,173. Shorter tenure = higher payment, but you keep over $2,200 that would otherwise have gone to the bank. This trade-off is the heart of every loan decision.
Example 3 — The Personal Loan
$10,000 at 12% annual interest over 3 years.
Step 1 — r = 0.12 ÷ 12 = 0.01.
Step 2 — n = 3 × 12 = 36.
Step 3 — (1.01)^36 ≈ 1.4308.
Step 4 — EMI = 10,000 × 0.01 × 1.4308 ÷ 0.4308 = 100 × 3.3213 ≈ $332.13 per month.
Total: $332.13 × 36 = $11,957 — about $1,957 in interest. Notice something important here: the interest RATE doubled compared to the mortgage example (12% vs 6%), but the interest PAID is far smaller, because the term is short and the principal is small. Rate, tenure, and principal pull in three directions at once — which is precisely why learning how to calculate loan EMI yourself beats guessing every time.
Calculating EMI in Excel and Google Sheets
Doing exponents by hand gets old fast. One spreadsheet function replaces the entire formula: PMT.
= −PMT(rate ÷ 12, nper, pv)
For our mortgage example, type:
=-PMT(6%/12, 360, 200000)
Result: $1,199.10. Identical. The minus sign is just cosmetic — PMT returns a negative number by convention (it is money leaving your pocket), so the leading minus flips it to a friendly positive.
Build yourself a tiny comparison sheet: put loan amounts down column A, rates across row 1, tenures in a dropdown — and you have a loan-offer scanner that beats any bank’s brochure. Want the full amortisation schedule (month-by-month principal/interest split)? Use the IPMT and PPMT functions on each row, or simply let our free EMI calculator generate it for you.
Working Backwards: How Much Loan Can You Afford?
Flip the question around. Instead of asking how to calculate loan EMI on a given loan, ask: what loan can a given EMI buy? Lenders do exactly this when they pre-approve you.
The affordability rule of thumb is the 28/36 rule: spend no more than 28% of gross monthly income on housing payments, and no more than 36% on all debt combined (housing + car + cards + student loans).
Say you earn $6,000 a month and have no other debts. Housing budget: 28% of $6,000 = $1,680. Now reverse the formula:
Max Loan = EMI × ((1 + r)^n − 1) ÷ (r × (1 + r)^n)
At 6% over 30 years, the multiplier works out to about 166.8, so: 1,680 × 166.8 ≈ $280,000. That is roughly the largest mortgage your payment can carry — before the down payment. Banks pad their numbers with fees and insurance, so always leave yourself a cushion.
Rate vs. Tenure: What Actually Changes Your EMI
This is where borrowers leave serious money on the table. Watch the same $200,000 mortgage at three different rates (30-year term):
| Annual rate | Monthly EMI | Total interest paid |
|---|---|---|
| 5% | $1,073.62 | $186,503 |
| 6% | $1,199.10 | $231,676 |
| 7% | $1,330.71 | $279,056 |
Two percentage points of rate difference cost an extra $257 a month — $92,553 over the life of the loan. That is why negotiating even a quarter-point off your rate is worth real effort.
Now watch tenure at a fixed 6% rate:
| Tenure | Monthly EMI | Total interest paid |
|---|---|---|
| 30 years | $1,199.10 | $231,676 |
| 15 years | $1,687.71 | $103,788 |
The 15-year loan costs $489 more per month but saves you $127,888 in interest. Neither choice is “right” — it depends on your cash flow. But now you can quantify the trade-off instead of feeling it.
The Interest Trap: Early Payments Are Almost All Interest
Here is the part lenders rarely volunteer. On that 6% mortgage, your first $1,199 payment splits into roughly $1,000 of interest and just $199 of principal. For the first several years, you are mostly renting money, not buying a house.
This is why extra payments early in a loan are so powerful. Paying an additional $200 a month from year one attacks the principal while interest is at its peak — shaving years off the loan and tens of thousands off the interest. The math is unforgiving in the other direction too: skipping payments or paying only interest extends the trap indefinitely.
Common Mistakes to Avoid
- Forgetting to divide the annual rate by 12. Plugging 0.06 in as r instead of 0.005 produces a nonsense EMI — and people do it constantly.
- Confusing flat rate with reducing-balance rate. Some lenders quote a “flat” rate charged on the original principal for the whole term. A 6% flat rate costs roughly the same as an 11% reducing-balance rate. Always ask which one is being quoted.
- Ignoring fees and insurance. Origination fees, mortgage insurance, and closing costs raise your true cost — the APR, not the headline rate, is the honest number.
- Borrowing the maximum you are approved for. Approval is the bank’s risk calculation, not your budget. Stick to the 28/36 rule.
- Paying only the minimum on credit cards. That is an EMI with an absurd rate and no end date — the balance barely moves.
- Not checking prepayment penalties. Some loans charge you for paying early, which kills the extra-payment strategy above. Read the fine print.
Calculate Your EMI Instantly (Free Tool)
You now know exactly how the math works — how to calculate loan EMI by hand, in a spreadsheet, and backwards from your budget — and that puts you ahead of most borrowers. For everyday use, skip the exponents and let our free EMI calculator do it: enter the loan amount, rate, and tenure, and get your monthly payment, total interest, and full amortisation schedule in seconds. Compare it with our percentage calculator guide when you are weighing rate differences or down-payment percentages — small percent shifts move big money.
Frequently Asked Questions
How do I calculate loan EMI in Excel or Google Sheets?
Use the PMT function: =-PMT(annual_rate/12, number_of_payments, loan_amount). For a $200,000 loan at 6% over 360 months: =-PMT(6%/12, 360, 200000) gives $1,199.10. The minus sign just flips PMT’s negative result to a positive number.
What is the exact EMI formula?
EMI = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where P is the principal, r is the monthly interest rate (annual rate ÷ 12), and n is the number of monthly payments.
How can I reduce my EMI?
Four levers: a larger down payment (smaller principal), a lower interest rate (negotiate or improve your credit score), a longer tenure (lower EMI but more total interest), and lump-sum prepayments early in the loan (attack the principal while interest is highest).
Is EMI the same as the interest rate?
No. The interest rate is the price of borrowing; the EMI is your fixed monthly payment, which repays both principal and interest. Two loans with the same rate can have very different EMIs if their tenures differ.
What is the difference between a flat rate and a reducing-balance rate?
A reducing-balance rate charges interest only on the outstanding principal — this is the standard behind the EMI formula. A flat rate charges interest on the original loan amount for the entire tenure, making the true cost roughly double the quoted number. Always confirm which one a lender is quoting.
Does paying extra EMI actually save money?
Yes — significantly. Extra payments go straight to principal, which shrinks every future interest calculation. An extra $200/month on a 6% mortgage from year one can cut years off the loan and save tens of thousands in interest. Just confirm your loan has no prepayment penalty first.
That is how to calculate loan EMI: one formula, three inputs (principal, monthly rate, number of payments), and the discipline to divide the annual rate by 12. With the worked examples, the spreadsheet shortcut, and the rate-vs-tenure tables, you can now price any loan offer in minutes — and spot the expensive ones before you sign. For the instant answer anytime, our free EMI calculator is one click away.