Category: EMI Guides

Loan lene se pehle sabse bada sawaal hota hai: EMI kaise calculate kare? Bank ya app aapko ek monthly figure bata deta hai, lekin woh number aata kahan se hai, yeh samajhna zaroori hai. Is guide mein hum aasan bhasha mein EMI ka formula, ek home loan aur ek bike loan ka poora example, aur tenure ka asar step-by-step samjhenge. Agar aapko bas jaldi se answer chahiye, toh hamara free EMI calculator use karein.

EMI Kya Hota Hai?

EMI ka full form hai Equated Monthly Instalment. Yeh woh fixed amount hai jo aap har mahine loan khatam hone tak bank ko dete hain. Har EMI ke do hisse hote hain: interest (jo bache hue loan par lagta hai) aur principal (jo aapka asli loan kam karta hai). EMI har mahine same rehti hai, lekin andar ka split badalta rehta hai. Shuru mein zyada paisa interest mein jaata hai, aur aakhri saalon mein zyada paisa principal mein. Isko reducing balance method kehte hain, aur India mein lagbhag sabhi home, car, bike, personal aur education loans isi tarah chalte hain.

EMI Calculate Karne Ka Formula

Sabhi Indian banks yeh standard formula use karte hain:

EMI = P × r × (1 + r)^n ÷ [(1 + r)^n − 1]

• P = principal, yaani loan amount
• r = monthly interest rate = saalana rate ÷ 12 ÷ 100
• n = tenure mahino mein (saal × 12)

Sabse common galti yeh hai ki log saalana rate seedha formula mein daal dete hain. Agar rate 8.5% hai, toh r = 8.5 ÷ 12 ÷ 100 = 0.007083 hoga, 0.085 nahi. Formula ki detailed math aur Excel PMT function ke liye hamari EMI formula guide padhein.

Example 1: ₹25 Lakh Home Loan, 8.5% Par, 20 Saal

Maan lijiye aap ₹25,00,000 ka home loan 8.5% saalana rate par 20 saal ke liye le rahe hain. Chaliye step-by-step calculate karte hain:

1. P = ₹25,00,000
2. r = 8.5 ÷ 12 ÷ 100 = 0.007083
3. n = 20 × 12 = 240 mahine
4. (1 + r)^n = (1.007083)^240 ≈ 5.4412
5. EMI = 25,00,000 × 0.007083 × 5.4412 ÷ (5.4412 − 1) ≈ ₹21,696 (exact ₹21,695.58)

240 mahino mein aap total lagbhag ₹52,06,939 chukayenge, jismein se ₹27,06,939 sirf interest hai. Matlab 20 saal ke loan par interest aapke loan amount se bhi zyada ho jaata hai.

Pehli EMI Ka Split

Pehle mahine ka interest = ₹25,00,000 × 0.007083 = ₹17,708.33. Baaki ₹21,695.58 − ₹17,708.33 = ₹3,987.25 principal mein jaata hai. Yaani pehli EMI ka sirf 18.4% hissa hi aapka loan kam karta hai. Doosre mahine mein interest thoda kam (₹17,680.09) hota hai kyunki balance ghat gaya, aur principal ka hissa badhkar ₹4,015.49 ho jaata hai.

Pehle poore saal mein aap 12 EMI mein ₹2,60,347 dete hain, lekin usmein se lagbhag ₹2,10,591 interest hai aur sirf ₹49,756 principal. Saal ke end mein bhi ₹24,50,244 ka loan baaki rehta hai. Isiliye shuru ke saalon mein kiya gaya prepayment sabse zyada interest bachata hai. Aap hamare home loan prepayment calculator se dekh sakte hain ki ek lump-sum payment kitna bachata hai.

Tenure Badalne Ka Asar

Same ₹25 lakh loan, same 8.5% rate, sirf tenure alag:

Tenure	Monthly EMI	Total Payment	Total Interest
15 saal	₹24,618	₹44,31,328	₹19,31,328
20 saal	₹21,696	₹52,06,939	₹27,06,939
25 saal	₹20,131	₹60,39,203	₹35,39,203

20 se 25 saal karne par EMI sirf ₹1,565 kam hoti hai, lekin interest ₹8,32,264 badh jaata hai. Wahin 15 saal chunne par EMI ₹2,922 zyada hai, par ₹7,75,611 interest bach jaata hai. Apne liye sahi combination dekhne ke liye home loan EMI calculator try karein.

Example 2: ₹1 Lakh Bike Loan, 11% Par, 3 Saal

Ab ek chhota loan dekhte hain. Aap ₹1,00,000 ka bike loan 11% rate par 3 saal ke liye lete hain:

1. P = ₹1,00,000
2. r = 11 ÷ 12 ÷ 100 = 0.009167
3. n = 3 × 12 = 36 mahine
4. (1 + r)^n = (1.009167)^36 ≈ 1.3889
5. EMI = 1,00,000 × 0.009167 × 1.3889 ÷ (1.3889 − 1) ≈ ₹3,274 (exact ₹3,273.87)

36 mahino mein total payment lagbhag ₹1,17,859 hoga, yaani ₹17,859 interest. Pehli EMI mein interest sirf ₹916.67 hai aur ₹2,357.21 (lagbhag 72%) principal mein jaata hai. Chhote tenure ke loan mein principal bahut tezi se kam hota hai, isliye interest ka bojh bhi kam rehta hai.

Bike Loan: 1, 2 Ya 3 Saal?

Tenure	Monthly EMI	Total Payment	Total Interest
1 saal	₹8,838	₹1,06,058	₹6,058
2 saal	₹4,661	₹1,11,859	₹11,859
3 saal	₹3,274	₹1,17,859	₹17,859

3 saal ka tenure EMI ko aasan banata hai, lekin 1 saal ke muqable lagbhag teen guna interest lagta hai. Agar budget allow kare toh 2 saal ek achha balance hai. Gaadi ke bade loan ke liye hamara car loan EMI calculator bhi dekhein.

Ek Quick Shortcut: EMI Per Lakh

8.5% par 20 saal ke loan ki EMI har ₹1 lakh par lagbhag ₹867.82 aati hai. Isko loan amount (lakh mein) se multiply karke aap turant andaza laga sakte hain. Jaise ₹25 lakh × ₹867.82 ≈ ₹21,696, jo upar wale answer se match karta hai. Yaad rakhein, rate ya tenure badalte hi per lakh figure bhi badal jaata hai.

EMI Calculate Karte Waqt Common Galtiyan

• Saalana rate ko monthly rate mein convert na karna.
• Tenure saal mein daalna, mahino mein nahi.
• Flat rate aur reducing rate ko same samajhna. Flat rate kam dikhta hai, par asal cost kaafi zyada hoti hai.
• Processing fee, insurance aur GST ko bhool jaana. Yeh EMI mein nahi dikhte, par loan ki total cost badhate hain.
• Sirf EMI dekhna aur total interest ignore karna.

Kitni EMI Afford Kar Sakte Hain?

Ek aam rule yeh hai ki aapki saari EMIs milakar take-home salary ke 40–50% se zyada na hon. Banks bhi isi tarah ka FOIR (Fixed Obligation to Income Ratio) dekhte hain. Aapki salary par kitna home loan mil sakta hai, yeh jaanne ke liye home loan eligibility calculator use karein.

Aksar Pooche Jaane Wale Sawaal (FAQ)

Kya EMI poore loan mein same rehti hai?

Fixed rate loan mein haan. Floating rate loan mein jab bank rate badalta hai, toh aam taur par pehle tenure badla jaata hai, aur kabhi-kabhi EMI bhi.

Shuru ki EMI mein zyada interest kyun jaata hai?

Interest hamesha bache hue balance par lagta hai, jo shuru mein sabse zyada hota hai. Jaise-jaise principal chukta hai, interest kam hota jaata hai.

Kya main mobile par bina formula ke EMI nikal sakta hoon?

Bilkul. EMItotal EMI calculator mein loan amount, rate aur tenure daaliye, aur aapko EMI, total interest aur total payment turant mil jaayega.

Bike loan aur home loan ki EMI ka formula alag hai kya?

Nahi, dono ka formula same hai. Fark sirf loan amount, interest rate aur tenure ka hota hai.

Every bank, NBFC and app in India quotes your loan as a monthly EMI. But how is that number actually worked out? Once you understand the EMI formula, you can check any lender’s quote yourself, compare offers, and see exactly how much interest you will pay. This guide explains the formula in plain language, solves real examples step by step, shows how to calculate EMI in Excel with the PMT function, and compares different tenures. If you just want a quick answer, use our free EMI calculator.

What Is an EMI?

EMI stands for Equated Monthly Instalment. It is a fixed amount you pay every month until the loan is fully repaid. Each EMI has two parts: interest on the outstanding balance, and principal repayment. The EMI stays the same, but the split changes every month. In the beginning most of your EMI goes towards interest; towards the end, most of it reduces the principal. This is called a reducing-balance loan, and it is how almost all home, car, personal and education loans in India work.

The EMI Formula

The standard formula used by Indian banks is:

EMI = P × r × (1 + r)^n ÷ [(1 + r)^n − 1]

• P = principal, the loan amount you borrow
• r = monthly interest rate = annual rate ÷ 12 ÷ 100
• n = tenure in months (years × 12)

The most common mistake is using the annual rate directly. If your loan is at 9% per year, r is 9 ÷ 12 ÷ 100 = 0.0075, not 0.09.

Example 1: ₹10 Lakh Home Loan at 9% for 20 Years

Let us solve one example completely.

1. P = ₹10,00,000
2. r = 9 ÷ 12 ÷ 100 = 0.0075
3. n = 20 × 12 = 240 months
4. (1 + r)^n = (1.0075)^240 ≈ 6.0092
5. EMI = 10,00,000 × 0.0075 × 6.0092 ÷ (6.0092 − 1) ≈ ₹8,997 (₹8,997.26 exactly)

Over 240 months you pay about ₹21,59,342 in total, of which ₹11,59,342 is interest. Yes, the interest is more than the loan itself on a 20-year loan at 9%.

How the First EMI Is Split

In month one, interest = ₹10,00,000 × 0.0075 = ₹7,500. The rest of the EMI, ₹8,997.26 − ₹7,500 = ₹1,497.26, reduces your principal. So in the first month only about 17% of your payment actually cuts the loan. Next month the interest is calculated on the slightly lower balance, so the principal share grows a little every month.

Example 2: ₹5 Lakh Personal Loan at 10.5% for 5 Years

• P = ₹5,00,000, r = 10.5 ÷ 1200 = 0.00875, n = 60
• EMI ≈ ₹10,747
• Total payment ≈ ₹6,44,817
• Total interest ≈ ₹1,44,817

Because the tenure is short, interest is only about 29% of the principal, compared with over 100% in the 20-year example.

Example 3: ₹20 Lakh Home Loan at 8.5% for 20 Years

• P = ₹20,00,000, r = 8.5 ÷ 1200, n = 240
• EMI ≈ ₹17,356
• Total payment ≈ ₹41,65,552
• Total interest ≈ ₹21,65,552

You can verify all three examples in seconds on our free loan EMI calculator.

How to Calculate EMI in Excel (PMT Function)

Excel and Google Sheets have a built-in function called PMT that applies the EMI formula for you. The syntax is:

=PMT(rate/12, months, -principal)

• rate/12: the annual rate as a decimal divided by 12 (9% becomes 9%/12 or 0.09/12)
• months: total number of EMIs
• -principal: the loan amount with a minus sign, so the result shows as a positive number

Step-by-Step Excel Example

1. In cell B1 type the loan amount: 1000000
2. In B2 type the annual rate: 9%
3. In B3 type the tenure in months: 240
4. In B4 type: =PMT(B2/12, B3, -B1)

Excel returns 8,997.26, exactly matching our manual calculation. You can also type it directly as =PMT(9%/12, 240, -1000000).

Extra Excel Formulas

• Total payment: =B4*B3 → ₹21,59,342
• Total interest: =B4*B3-B1 → ₹11,59,342
• Interest in a given month: =IPMT(B2/12, month, B3, -B1)
• Principal in a given month: =PPMT(B2/12, month, B3, -B1)

For month 1, IPMT returns ₹7,500 and PPMT returns ₹1,497.26, matching the split above. Drag these formulas down 240 rows and you have your own amortization schedule.

Tenure Comparison: ₹30 Lakh at 8.5%

Choosing a longer tenure lowers your EMI but sharply increases total interest. Here is a ₹30 lakh home loan at 8.5% across different tenures:

Tenure	Monthly EMI	Total Payment	Total Interest
10 years	₹37,196	₹44,63,485	₹14,63,485
15 years	₹29,542	₹53,17,594	₹23,17,594
20 years	₹26,035	₹62,48,327	₹32,48,327
25 years	₹24,157	₹72,47,044	₹42,47,044
30 years	₹23,067	₹83,04,266	₹53,04,266

Look at the difference between 20 and 30 years. The EMI drops by only about ₹2,968 a month, but you pay roughly ₹20,55,939 more in interest. Going from 20 to 10 years raises the EMI by about ₹11,161 but saves nearly ₹17,84,842 in interest.

Practical Takeaways

• Pick the shortest tenure whose EMI fits comfortably in your budget. A common guideline is keeping all EMIs under 40–50% of take-home pay.
• If you take a long tenure for flexibility, make part-prepayments whenever you can. Early prepayments save the most interest because that is when the outstanding balance is highest.
• Even a small rate difference matters on long loans, so compare lenders before signing.

Common Mistakes When Calculating EMI

• Using the annual rate instead of the monthly rate.
• Entering tenure in years instead of months.
• Confusing flat-rate quotes with reducing-balance rates. A flat rate looks lower but costs much more.
• Ignoring processing fees, insurance and GST, which add to the real cost but are not part of the EMI.

Frequently Asked Questions

Does the EMI change during the loan?

On a fixed-rate loan the EMI stays the same. On a floating-rate loan, when the lender’s rate changes, banks usually adjust the tenure first, and sometimes the EMI.

Why is most of my early EMI going to interest?

Interest is charged on the outstanding balance, which is highest at the start. As you repay principal, interest falls and the principal share rises.

Is the Excel PMT result the same as the bank’s EMI?

Yes, for standard reducing-balance loans PMT uses the same formula. Small differences can come from rounding or the lender’s day-count method.

What is the fastest way to check my EMI?

Enter your loan amount, rate and tenure in the EMItotal EMI calculator to see your EMI, total interest and total payment instantly.