How to Calculate EMI Manually (Formula + Examples)
!Loan calculation and documents
EMI (Equated Monthly Installment) is the fixed payment you make to a lender every month until your loan is fully repaid. Understanding how EMI is calculated helps you make informed borrowing decisions and even catch errors in loan statements.
In this guide, we'll explain the EMI formula, walk through manual calculations, and provide examples for different loan types. For quick calculations, use our EMI Calculator.
The EMI Formula
The standard EMI formula uses the reducing balance method:
``
EMI = P × r × (1 + r)^n / [(1 + r)^n - 1]
`
Where:
- P = Principal loan amount
- r = Monthly interest rate (Annual rate ÷ 12 ÷ 100)
- n = Loan tenure in months
Breaking Down the Formula
Step-by-Step Calculation
Example 1: Home Loan
Loan Details:- Principal (P): ₹50,00,000
- Annual Interest Rate: 8.5%
- Tenure: 20 years (240 months)
r = 8.5 / 12 / 100 = 0.00708 (or 0.708%)
`
Step 2: Calculate (1 + r)^n
`
(1 + 0.00708)^240 = (1.00708)^240 = 5.447
`
Step 3: Apply the formula
`
EMI = 50,00,000 × 0.00708 × 5.447 / (5.447 - 1)
EMI = 1,92,86,100 / 4.447
EMI = ₹43,370
`
Monthly EMI: ₹43,370
Total Payment: ₹43,370 × 240 = ₹1,04,08,800
Total Interest: ₹1,04,08,800 - ₹50,00,000 = ₹54,08,800
Example 2: Car Loan
Loan Details:
- Principal (P): ₹8,00,000
- Annual Interest Rate: 9%
- Tenure: 5 years (60 months)
Step 1: Monthly rate
`
r = 9 / 12 / 100 = 0.0075
`
Step 2: (1 + r)^n
`
(1.0075)^60 = 1.566
`
Step 3: EMI calculation
`
EMI = 8,00,000 × 0.0075 × 1.566 / (1.566 - 1)
EMI = 9,396 / 0.566
EMI = ₹16,601
`
Monthly EMI: ₹16,601
Total Payment: ₹16,601 × 60 = ₹9,96,060
Total Interest: ₹9,96,060 - ₹8,00,000 = ₹1,96,060
Example 3: Personal Loan
Loan Details:
- Principal (P): ₹3,00,000
- Annual Interest Rate: 14%
- Tenure: 3 years (36 months)
Step 1: Monthly rate
`
r = 14 / 12 / 100 = 0.01167
`
Step 2: (1 + r)^n
`
(1.01167)^36 = 1.518
`
Step 3: EMI calculation
`
EMI = 3,00,000 × 0.01167 × 1.518 / (1.518 - 1)
EMI = 5,315 / 0.518
EMI = ₹10,262
`
Monthly EMI: ₹10,262
Total Payment: ₹10,262 × 36 = ₹3,69,432
Total Interest: ₹3,69,432 - ₹3,00,000 = ₹69,432
EMI Calculation in Excel
You can also use Excel's PMT function:
`excel
=PMT(rate, nper, pv)
=PMT(8.5%/12, 240, -5000000)
`
This returns ₹43,391 (slight difference due to rounding).
Parameters:
- rate: Monthly interest rate (annual/12)
- nper: Number of payments (months)
- pv: Principal amount (negative because it's an outflow)
Flat Rate vs Reducing Balance
Reducing Balance Method (Standard)
- Interest calculated on remaining principal
- Each payment reduces principal, so interest decreases
- Used by most banks for home and car loans
Flat Rate Method
- Interest calculated on original principal throughout
- Actual interest rate is higher than stated
- Sometimes used for personal loans and consumer credit
Example Comparison (₹1,00,000 loan, 12% stated rate, 1 year):
Method Monthly EMI Total Interest Effective Rate Reducing Balance ₹8,885 ₹6,620 12% Flat Rate ₹9,000 ₹12,000 ~21%
Warning: Always ask if the rate is flat or reducing!
Factors That Affect EMI
1. Loan Amount (Principal)
Higher principal = Higher EMI
2. Interest Rate
Higher rate = Higher EMI + More interest paid
Use our Loan Comparison Calculator to compare rates.
3. Loan Tenure
- Longer tenure = Lower EMI but more total interest
- Shorter tenure = Higher EMI but less total interest
Example: ₹50 lakh home loan at 8.5%
Tenure EMI Total Interest 15 years ₹49,236 ₹38.62 lakh 20 years ₹43,391 ₹54.14 lakh 25 years ₹40,260 ₹70.78 lakh 30 years ₹38,446 ₹88.40 lakh
The 30-year option costs ₹50 lakh more in interest vs 15-year!
How Prepayment Reduces Interest
Making extra payments toward principal:
- Reduces outstanding balance
- Lowers interest for remaining tenure
- Can significantly cut total interest paid
Example:
₹50 lakh loan at 8.5% for 20 years
- Regular EMI: ₹43,391
- If you add ₹10,000/month extra:
- New payoff time: ~13 years
- Interest saved: ~₃20 lakh
Use our Amortization Calculator to see prepayment impact.
Amortization Schedule
An amortization schedule shows how each EMI is split between principal and interest:
First few months of a ₹50 lakh loan at 8.5% for 20 years:
Month EMI Interest Principal Balance 1 ₹43,391 ₹35,417 ₹7,974 ₹49,92,026 2 ₹43,391 ₹35,360 ₹8,031 ₹49,83,995 3 ₹43,391 ₹35,303 ₹8,088 ₹49,75,907 ... ... ... ... ... 238 ₹43,391 ₹611 ₹42,780 ₹43,216 239 ₹43,391 ₹306 ₹43,085 ₹131 240 ₹131 ₹1 ₹130 ₹0
Notice: Early payments are mostly interest; later payments are mostly principal.
Quick Mental Estimation
For rough EMI calculations without a calculator:
Rule of Thumb (for 20-year home loans at 8-9%):
`
EMI ≈ Principal × 0.009
``
Example: ₹50 lakh loan
- Estimated EMI = ₹50,00,000 × 0.009 = ₹45,000
- Actual (at 8.5%): ₹43,391
- Reasonable approximation!
Frequently Asked Questions
Does EMI include insurance and processing fees?
No, EMI covers only principal and interest. Insurance premiums and processing fees are usually separate or added to the principal.
What happens if I miss an EMI?
Your account goes into default, late fees apply, and it affects your credit score. Read our detailed guide: What Happens If You Miss EMI Payment.
Can EMI change during the loan tenure?
- Fixed rate loans: EMI stays constant
- Floating rate loans: EMI can change when interest rates change
Is GST charged on EMI?
GST is charged on the interest component of loans (in some countries). In India, no GST on regular bank loan interest, but processing fees may attract GST.
How can I reduce my EMI?
Calculate Your Loan
Use our calculators:
- EMI Calculator - Quick EMI computation
- Loan Comparison Calculator - Compare different loans
- Amortization Calculator - Full payment schedule
- Debt Payoff Calculator - Plan extra payments
Related Articles
Advertisement
📚 Suggested Articles
What Happens If You Miss EMI Payment? (Consequences + Solutions)
Understand penalties and how to recover from missed EMI.
How to Calculate Loan Amortization (With Schedule Example)
Understand loan amortization with step-by-step examples.
Loan Comparison Calculator: How to Choose the Best Loan
Compare different loans by total cost, monthly payment, and APR.