Equated Monthly Installments (EMI) form the bedrock of consumer vehicle financing in India. When you sign a 5-year or 7-year auto loan agreement, you commit to paying a fixed sum to the lender on a specified calendar date every single month.
While online calculators perform these calculations in milliseconds, understanding the underlying mathematical mechanics empowers you to verify lender quotes, spot computational errors, and optimize your loan prepayment timing.
The Standard Reducing Balance EMI Formula
Indian commercial banks execute the standard annuity formula for reducing balance loans:
Step-by-Step Manual Calculation Walkthrough
Let's calculate the exact EMI for a popular Indian scenario: financing ₹8,00,000 for a compact SUV at an interest rate of 9.0% p.a. over 5 years (60 months):
1. P = 8,00,000
2. r = 9 ÷ 1200 = 0.0075
3. n = 60
4. (1 + r)^n = (1.0075)^60 ≈ 1.56568
5. Numerator = 8,00,000 × 0.0075 × 1.56568 = 9,394.08
6. Denominator = 1.56568 - 1 = 0.56568
7. EMI = 9,394.08 ÷ 0.56568 = ₹16,607.41 (Rounded to ₹16,607 / month)
Calculating in Microsoft Excel or Google Sheets
If you prefer to model auto loans in your own spreadsheet, use the built-in financial function PMT:
For our ₹8,00,000 loan at 9% for 60 months, type: =PMT(9%/12, 60, -800000) to display ₹16,607.
The Dealership Trap: Flat Rate vs. Reducing Balance
Automobile showroom sales executives often advertise: "Special festival car loan offer at just 5.5% interest rate!"
Beware: this is almost universally a flat interest rate. In a flat-rate structure, interest is calculated on the entire original principal for all 5 years, ignoring the fact that you are repaying the principal every month:
Flat 5.5% Loan Quote
Interest per year = 5.5% of ₹8,00,000 = ₹44,000.
Total Interest over 5 years = ₹2,20,000.
Total Repayment = ₹10,20,000.
Monthly EMI = ₹10,20,000 ÷ 60 = ₹17,000.
Reducing 9.0% Bank Loan Quote
Interest calculated on reducing balance.
Total Interest over 5 years = ₹1,96,420.
Total Repayment = ₹9,96,420.
Monthly EMI = ₹16,607.
Notice the irony: A seemingly "high" 9.0% reducing rate from a bank is actually cheaper than a "discounted" 5.5% flat rate from a dealer, saving you over ₹23,500 in total cash outflow!
How the Amortization Schedule Shifts Over 60 Months
The table below demonstrates how the interest portion drops while the principal portion grows on our ₹8 Lakh loan:
| Period | Opening Balance | Monthly EMI | Interest Part | Principal Part | Closing Balance |
|---|---|---|---|---|---|
| Month 1 | ₹8,00,000 | ₹16,607 | ₹6,000 | ₹10,607 | ₹7,89,393 |
| Month 12 | ₹6,77,261 | ₹16,607 | ₹5,079 | ₹11,528 | ₹6,65,733 |
| Month 24 | ₹5,31,770 | ₹16,607 | ₹3,988 | ₹12,619 | ₹5,19,151 |
| Month 36 | ₹3,72,279 | ₹16,607 | ₹2,792 | ₹13,815 | ₹3,58,464 |
| Month 48 | ₹1,97,422 | ₹16,607 | ₹1,481 | ₹15,126 | ₹1,82,296 |
| Month 60 | ₹16,483 | ₹16,607 | ₹124 | ₹16,483 | ₹0 |
Generate Your Full Month-by-Month Amortization Schedule
Use CarHaven's free Car EMI Calculator to view your complete month-by-month payment schedule with visual principal vs interest charts.
🧮 Open Car EMI Calculator →Related Guides & Research
Explore companion guides to make informed auto financing decisions.
How Much Down Payment Should I Make?
Compare 10%, 20% & 30% down payment scenarios and interest savings.
3-Year vs 5-Year Car Loan: Which is Better?
Comparison of 3-year, 5-year, and 7-year auto loans in India evaluating EMI vs interest.
How to Reduce Car Loan Interest
7 proven negotiation tactics, CIBIL score tiers, and prepayment strategies.