What is an EMI?
EMI stands for Equated Monthly Installment — the fixed amount you send your lender every month until the loan is paid off. Each payment is split between interest (calculated on the current outstanding balance) and principal (which chips away at what you owe). The EMI itself never changes, but the interest-to-principal ratio shifts every month.
The Formula
EMI = P × r × (1 + r)n / ((1 + r)n − 1)
Where P is the principal loan amount, r is the monthly interest rate (annual rate ÷ 12 ÷ 100), and n is the total number of monthly installments (years × 12). The same formula powers every mortgage, auto loan, and personal loan calculator you have ever used.
Worked Example: $30,000 auto loan at 6.9% for 60 months
Let's plug in a realistic US auto loan. P = 30,000, annual rate = 6.9%, so r = 0.069 / 12 = 0.00575, and n = 60 months. Working the formula: (1.00575)60 ≈ 1.4113. EMI = 30,000 × 0.00575 × 1.4113 / 0.4113 ≈ $592.90 per month. Over 60 months you pay $35,574 total — meaning about $5,574 in interest. Now compare a ₹10,00,000 home loan at 8.5% for 20 years (n = 240): EMI works out to about ₹8,678, and total interest paid over 20 years is roughly ₹10.83 lakh — more than the original principal.
When to Use This Calculator
- Home loans / mortgages: compare 15-year vs 20-year vs 30-year tenures side by side.
- Auto loans: figure out whether the dealer's monthly quote matches the math.
- Personal loans: check the true cost of a "quick" loan before signing.
- Education loans: model repayment after the moratorium ends.
- Refinancing decisions: see how much you save if rates drop 1% and you refi.
Mistakes to Avoid
- Confusing APR with flat rate: a "flat 5%" personal loan is roughly equivalent to a 9–10% reducing-balance APR. Always ask for the reducing-balance rate.
- Forgetting processing fees: a 1–2% origination fee raises your effective cost noticeably on short loans.
- Ignoring prepayment penalties: some lenders charge 2–4% of outstanding principal if you close early. Read the sanction letter.
Frequently Asked Questions
What is the difference between EMI and a simple-interest loan payment?
Both produce fixed monthly payments, but EMI is calculated on the reducing balance — so as you pay down principal, less of each payment goes to interest. Flat/simple-interest loans charge interest on the original balance the whole term, which is significantly more expensive.
Should I choose a longer or shorter EMI tenure?
Shorter tenure = higher monthly payment but far less total interest. A 15-year mortgage typically costs 40–50% less in total interest than a 30-year one at the same rate. Pick the shortest tenure whose EMI still fits comfortably under 40% of your take-home pay.
Can I calculate EMI in Excel?
Yes — use =PMT(rate/12, years*12, -principal). For our example: =PMT(0.069/12, 60, -30000) returns $592.90. The negative sign on principal is an Excel cash-flow convention.
Is the EMI amount fixed for the entire loan?
On a fixed-rate loan, yes — the EMI is locked. On a floating-rate loan, banks usually keep the EMI constant and adjust the tenure instead when rates change, so you finish earlier or later than expected.