How to Calculate EMI by Hand (Formula + Worked Examples)

Suman SharmaSuman Sharma

An EMI (equated monthly instalment) is the fixed amount you pay every month on a reducing-balance loan. Banks will quote you a number. With one formula, you can check it yourself. To skip the arithmetic, use the EMI Calculator.

The formula

EMI = P × r × (1 + r)^n ───────────────── (1 + r)^n − 1
LetterMeaningHow to get it
Pprincipal, the amount borrowede.g. 1,000,000
rmonthly interest rate, as a decimalannual rate ÷ 12 ÷ 100
nnumber of monthly instalmentsyears × 12

The most common mistake is using the annual rate for r. A 12% annual rate is r = 0.01 per month, not 0.12.

Worked example

Loan of 1,000,000 (say NPR 10 lakh) at 12% a year for 5 years.

  1. P = 1,000,000
  2. r = 12 ÷ 12 ÷ 100 = 0.01
  3. n = 5 × 12 = 60
  4. (1 + r)^n = 1.01^60 = 1.816697
  5. Top: 1,000,000 × 0.01 × 1.816697 = 18,166.97
  6. Bottom: 1.816697 − 1 = 0.816697
  7. EMI = 18,166.97 ÷ 0.816697 = 22,244.45

Over 60 months you pay 22,244.45 × 60 = 1,334,667. Total interest: 334,667.

You'll need a calculator with a power key (xʸ) for step 4. In a spreadsheet, =PMT(12%/12, 60, -1000000) gives the same answer.

Where each payment goes

Every month, interest is charged on what you still owe. The rest of the EMI pays down the principal.

MonthOpening balanceInterest (1%)PrincipalClosing balance
11,000,000.0010,000.0012,244.45987,755.55
2987,755.559,877.5612,366.89975,388.66
3975,388.669,753.8912,490.56962,898.10

The EMI stays the same, but the split shifts each month: less interest, more principal. That's why prepaying early saves far more interest than prepaying late.

How tenure changes the total

Same 1,000,000 at 12%:

TenureEMITotal interest
3 years33,214195,715
5 years22,244334,667
7 years17,653482,830
10 years14,347721,651

Going from 5 to 10 years cuts the EMI by about a third and more than doubles the interest.

How the rate changes the EMI

Same 1,000,000 over 5 years:

Annual rateEMI
10%21,247
12%22,244
14%23,268

Each 2 percentage points adds roughly 1,000 a month here, or about 60,000 over the loan. That's why it's worth negotiating the rate, not just the fee. (If "percentage points" vs "percent" is fuzzy, see Percent vs Percentage Points.)

Things the formula doesn't include

  • Processing fees and insurance, which raise the real cost.
  • Floating rates. Many loans, including most home loans in Nepal and India, are linked to a base rate that can change. When it does, the bank changes your EMI or your tenure.
  • Flat-rate loans. Some vehicle and personal loans charge interest on the original amount for the whole term. The formula above doesn't apply, and the real rate is much higher. See Flat Rate vs Reducing Balance.

Quick checklist before you sign

  1. Is the rate reducing balance or flat?
  2. Is it fixed or floating, and what is it linked to?
  3. What are the processing fee and prepayment charges?
  4. Does your EMI calculation match the bank's within a rupee or two?

Frequently asked questions

What is the formula for EMI?

EMI = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where P is the loan amount, r is the monthly interest rate (annual rate ÷ 12 ÷ 100) and n is the number of monthly instalments.

Why does most of my early EMI go to interest?

Interest is charged on the outstanding balance, which is highest at the start. As you repay principal, the interest part of each EMI shrinks and the principal part grows, even though the EMI stays the same.

Is a longer tenure better for EMI?

A longer tenure lowers the monthly EMI but increases the total interest you pay, often by a lot. Pick the shortest tenure whose EMI you can comfortably afford.

Contact

Get in Touch

Want to call me? book a call and I'll respond in the available time slot. I will ignore all soliciting.