EMI calculator
Enter the loan amount, interest rate and tenure to see your monthly EMI, total interest and total payment instantly, with a yearly or month-by-month amortization schedule – for a home loan, car loan, bike loan or personal loan.
How it is calculated
What is EMI?
An EMI (equated monthly instalment) is the fixed amount you pay the bank every month until the loan is repaid. Each EMI covers the interest on the outstanding balance plus a part of the principal. Because the balance falls every month, the interest portion shrinks and the principal portion grows – which is exactly what the amortization schedule shows.
EMI formula and how to calculate EMI
EMI formula: E = P × r × (1 + r)n ÷ ((1 + r)n − 1), where P is the loan amount, r the monthly interest rate (annual rate ÷ 12 ÷ 100) and n the tenure in months. Banks such as ICICI Bank publish the same formula for their EMI calculators. In Excel or Google Sheets use =PMT(8.5%/12, 240, -1000000).
Worked example: a loan of ₹10,00,000 (10 lakh) at 8.5% for 20 years gives r = 0.085 ÷ 12 = 0.0070833 and n = 240. The EMI is ₹8,678 per month. In the first month ₹7,083 of it is interest (₹10,00,000 × 0.0070833) and ₹1,595 repays principal, leaving ₹9,98,405. Over 240 months you pay about ₹20.83 lakh in total, of which about ₹10.83 lakh is interest.
Quick check: at 8.5% for 20 years the EMI is about ₹868 per ₹1 lakh borrowed – multiply by the number of lakhs for a first estimate.
Home loan, car loan, bike loan and personal loan EMI
The formula is the same for every EMI-based loan; only the typical amount, rate and tenure differ:
| Loan | Amount | Rate | Tenure | EMI | Total interest |
|---|---|---|---|---|---|
| Home loan | ₹25 lakh | 8.5% | 20 years | ₹21,696 | ≈ ₹27.07 lakh |
| Home loan | ₹50 lakh | 8.5% | 30 years | ₹38,446 | ≈ ₹88.40 lakh |
| Education loan | ₹10 lakh | 9% | 7 years | ₹16,089 | ≈ ₹3.51 lakh |
| Car loan | ₹8 lakh | 9% | 5 years | ₹16,607 | ≈ ₹1.96 lakh |
| Personal loan | ₹5 lakh | 11% | 3 years | ₹16,369 | ≈ ₹89,297 |
| Bike loan | ₹1.2 lakh | 10.5% | 24 months | ₹5,565 | ≈ ₹13,563 |
| Loan against property | ₹30 lakh | 10% | 15 years | ₹32,238 | ≈ ₹28.03 lakh |
How rate and tenure change your EMI
On a ₹25 lakh home loan over 20 years, every half percentage point matters: the EMI is ₹20,911 at 8%, ₹21,696 at 8.5% and ₹22,493 at 9%. A longer tenure lowers the EMI but raises the total interest – a ₹50 lakh loan at 8.5% costs ₹43,391 a month and about ₹54.14 lakh interest over 20 years, or ₹38,446 a month and about ₹88.40 lakh over 30 years.
Flat rate vs reducing balance
This calculator uses the reducing balance method: interest is charged only on the amount still outstanding. With a flat rate, interest is charged on the full loan for the whole tenure: EMI = (P + P × flat rate × years) ÷ months. ₹5 lakh at 11% flat for 3 years gives ₹18,472 a month instead of ₹16,369 at 11% reducing – so compare flat-rate offers only after converting them.
Credit card EMI and no-cost EMI
Converting a purchase into EMIs on a credit card follows the same reducing-balance formula. ₹60,000 at 15% p.a. costs ₹10,442 a month over 6 months (≈ ₹2,652 interest) or ₹5,416 a month over 12 months (≈ ₹4,986 interest) – enter the tenure in months. With a no-cost EMI offer the interest is usually offset by a discount on the price, so the instalments add up to roughly the price you would pay upfront. Processing fees and GST come on top and are not included here – check the card issuer's terms.
Assumptions
This loan EMI calculator assumes a fixed interest rate for the whole tenure, monthly instalments starting one month after disbursement and interest rounded to the paisa each month; the last instalment settles any rounding difference. Processing fees, insurance and GST are not included. For floating-rate loans the EMI or the tenure changes when the rate is reset; under RBI rules your lender must tell you about the reset and let you choose between a higher EMI and a longer tenure.
Frequently asked questions
How is EMI calculated?
EMI = P × r × (1 + r)n ÷ ((1 + r)n − 1), with P = loan amount, r = monthly rate (annual rate ÷ 12 ÷ 100) and n = number of months. ₹10 lakh at 8.5% for 20 years gives an EMI of ₹8,678.
What is the EMI for a ₹25 lakh home loan?
At 8.5% interest it is ₹21,696 a month for 20 years or ₹20,131 a month for 25 years. The longer tenure lowers the EMI but raises the total interest from about ₹27.07 lakh to about ₹35.39 lakh.
What is the EMI for a ₹1 lakh loan for 12 months?
At 12% interest the EMI is ₹8,885 and the total interest about ₹6,619. For a tenure in months, switch "Tenure in" to months.
How do I calculate EMI in Excel?
Use =PMT(annual rate/12, months, -loan amount), for example =PMT(8.5%/12, 240, -1000000) = 8,678.23. The calculator gives the same EMI plus the full amortization schedule.
What is the difference between flat and reducing interest rate EMI?
With a reducing rate, interest is charged on the outstanding balance, so it falls every month. With a flat rate, it is charged on the original amount for the whole tenure. ₹5 lakh for 3 years costs ₹16,369 a month at 11% reducing but ₹18,472 at 11% flat.
Is it better to reduce the EMI or the tenure after a prepayment?
Keeping the EMI and shortening the tenure saves more interest, because the balance is repaid faster. Reducing the EMI eases your monthly budget but leaves the loan running longer.
Does the EMI include processing fees or insurance?
No. The calculator shows principal and interest only. Processing fees, loan insurance and GST on charges come on top and are stated in the Key Fact Statement of your lender.
How is EMI calculated on a credit card?
With the same EMI formula on the converted amount. ₹60,000 at 15% p.a. for 12 months gives an EMI of ₹5,416 and about ₹4,986 interest. Processing fees and GST come on top – see the card issuer's terms.
Sources and legal basis
- RBI/2023-24/55, DOR.MCS.REC.32/01.01.003/2023-24: Reserve Bank of India – Reset of Floating Interest Rate on EMI based Personal Loans (EMI, tenor, statements)
- ICICI Bank – Home loan EMI calculator: EMI = [P × R × (1+R)^N] / [(1+R)^N − 1]
As of:
Related tools
- Loan Calculator – Monthly Payment & Amortization Schedule
Loan calculator for monthly payment, total interest and payoff time on personal, car or home loans – with extra payments and an amortization schedule.
- Compound Interest Calculator with Monthly Contributions
Compound interest calculator with monthly contributions, yearly increases and annual, quarterly or monthly compounding – plus a year-by-year growth table.
- German Real Estate Transfer Tax Calculator 2026 (16 States)
German real estate transfer tax calculator 2026: Grunderwerbsteuer for all 16 states instantly, with current rates and deduction for fitted kitchens.
- German VAT Calculator: add or remove 19% / 7% VAT
German VAT calculator: add VAT to a net price or remove it from a gross price at 19%, 7% or a custom rate – rounded to the cent, with formulas.
- Germany Property Closing Costs Calculator 2026
Germany property closing costs calculator: transfer tax by state, notary and land registry fees (GNotKG) and agent commission – every item listed.