Toolszie

EMI Calculator

Calculate your monthly Equated Monthly Installment (EMI) for home, personal, and car loans. Includes a prepayment mode and amortization schedule.

Actual Loan Amount:₹40,00,000

An Equated Monthly Installment (EMI) is the fixed payment amount made by a borrower to a lender on a specified date each calendar month. Equated monthly installments are used to pay off both interest and principal each month so that over a specified number of years, the loan is paid off in full.

How to Use

  1. Select your Loan Type (Home, Personal, Car, etc.) to load standard parameters, or manually enter your own.
  2. Enter your total loan amount.
  3. Enter the annual interest rate.
  4. Enter the loan tenure in either months or years.
  5. Optionally, use the Prepayment mode to calculate how extra payments reduce your loan tenure or EMI.

Formula

EMI = [P × R × (1+R)^N] / [(1+R)^N - 1] Where: P = Principal loan amount R = Monthly interest rate (Annual Rate / 12 / 100) N = Number of monthly installments (Tenure)

Home Loan EMI Calculator

A home loan is typically a long-term commitment, often spanning 15 to 30 years. Because of the large principal amounts and long tenures, the total interest paid can sometimes approach or exceed the initial loan amount.

Using our home loan EMI calculator helps you understand your monthly cash outflow. A critical strategy for home loans is making periodic prepayments. Even small prepayments early in the loan tenure can drastically reduce the total interest you pay over the life of the loan.

Personal Loan EMI Calculator

Personal loans are unsecured loans that generally carry higher interest rates and shorter tenures (usually 1 to 5 years). Because they are unsecured, lenders offset the risk by charging a premium.

Our personal loan EMI calculator lets you quickly check if the monthly installment fits within your budget. Keep in mind that prepaying a personal loan often incurs a foreclosure charge, so check your bank's terms before making large prepayments.

Car and Bike Loan EMI Calculator

Vehicle loans (for cars or two-wheelers) usually range from 3 to 7 years. When buying a vehicle, you typically make a down payment, and the remaining amount is financed by the bank.

By subtracting your down payment from the on-road price, you get the actual principal amount to enter into the EMI calculator. Our tool helps you balance a higher down payment against a lower monthly EMI.

Flat Rate vs Reducing Balance EMI

When taking a loan, it is vital to understand the difference between a Flat Interest Rate and a Reducing Balance Interest Rate.

Flat Rate: The interest is calculated on the entire initial principal amount for the entire tenure of the loan, regardless of the principal you have already paid back. This makes the effective interest rate much higher.

Reducing Balance: The interest is calculated only on the outstanding principal balance. As you pay your EMI, the principal decreases, and so does the interest component of your EMI. All standard banks in India (for home, personal, and car loans) use the reducing balance method, which is the standard mathematical model used by our EMI calculator.

EMI Calculation Formula in Excel

If you want to calculate your EMI in an Excel sheet or Google Sheets, you can use the built-in PMT function. The syntax is: =PMT(rate, nper, pv)

rate: The monthly interest rate (Annual Rate / 12).

nper: The total number of monthly payments (Years × 12).

pv: The present value, or the principal loan amount.

For example, for a ₹1,00,000 loan at 10% per annum for 5 years, the formula would be: =PMT(10%/12, 5*12, 100000). Note that Excel will return a negative number (representing cash outflow).

Frequently Asked Questions

What is EMI?

Equated Monthly Installment (EMI) is a fixed payment amount made by a borrower to a lender at a specified date each calendar month. It consists of both principal repayment and interest.

How is EMI calculated?

EMI is calculated using the standard reducing-balance formula: EMI = [P × R × (1+R)^N] / [(1+R)^N - 1], where P is the principal, R is the monthly interest rate, and N is the number of months.

What happens to my EMI when interest rates change?

For floating rate loans (like most home loans), if the bank increases the interest rate, your EMI usually remains the same, but the loan tenure is extended. If the tenure cannot be extended further, the bank will increase your EMI amount.

Is EMI the same throughout a loan?

For fixed-rate loans, the EMI remains identical throughout the tenure. However, the composition changes: in the early years, the EMI consists primarily of interest, while in the later years, it consists primarily of principal.

What is the difference between flat-rate and reducing-balance EMI?

A flat rate calculates interest on the full original principal for the entire tenure, leading to a higher effective cost. A reducing balance calculates interest only on the outstanding principal left each month. Our calculator uses the standard reducing balance method.

How does prepayment affect EMI?

Prepaying a portion of your loan reduces the outstanding principal. Most banks allow you to choose between reducing your monthly EMI (keeping tenure the same) or reducing your overall loan tenure (keeping the EMI the same). Reducing the tenure saves you significantly more money on interest.

Is it better to reduce EMI or loan tenure after prepayment?

Mathematically, reducing the loan tenure while keeping your EMI the same will save you the most money on total interest. You should only choose to reduce the EMI if you are facing cash flow problems.

How is EMI calculated for a home loan?

Home loan EMI is calculated using the standard reducing-balance formula as personal or car loans. The only difference is that home loans typically have much larger principals and longer tenures, making the interest component very high in the early years.

What is included in total EMI interest?

The total EMI interest is simply the sum of all your monthly installments over the entire loan tenure minus the original principal borrowed. It represents the actual cost you paid to borrow the money.

Related Tools