EMI Formula: How To Calculate EMI With Example (2024)

While you can easily choose and apply for different loans, prior knowledge of how much you need to borrow can help to avoid facing payment defaults. Since failing to pay EMIs on time can harm your financial record, it is imperative to find an instalment amount that suits your financial capabilities.

In this regard, using an EMI calculator can be of great help. This type of online application will allow you to assess your monthly payment obligation that aligns with your ability to pay back the loan.

What is the EMI Formula to calculate monthly EMIs?

When applying for a loan from a financial institution, you must pay an EMI or Equated monthly instalment. However, estimating how much you can actually afford to repay per month can be a challenging process.

The basic formula that works in calculating EMI is as follows:

E = P x R x (1+r)^n/((1+r)^N – 1, where

E = Equated Monthly Instalment

‘P’ stands for principal amount

‘R’ denotes applicable rate of interest

‘N’ stands for the loan term or tenure

By using this formula, you can easily calculate the monthly instalment of your loan. However manual calculations are more prone to errors leading to a wrong decision. In such a case, an EMI calculator comes into play.

Formula for Online Emi Calculators

The mathematical formula mentioned above is considered and used by the entire financial industry for calculating the EMI for any loan amount. The online EMI calculator is adjustable; you can calculate the EMI payable by entering the values as per your preference.

Online EMI calculators also work on the basis of this formula:

EMI = [P x R x (1+R)^N]/[(1+R)^N-1].

So to get a comprehensive understanding of these variables, let's discuss them in detail:

  • R represents ‘rate of interest’. It is the interest rate that a lending institution charges for a loan. This rate of interest may vary depending on the lender; higher the rate of interest, higher will be the EMI amount.
  • P denotes your principal amount. It is the loan amount that you borrow from a lender. The lower the amount you borrow, the lower will be the EMI and vice versa.
  • N indicates the loan tenure. It is the time within which you must repay the loan amount. This loan amount is inversely proportional to the EMI. This signifies that the longer your loan tenure, the lower will be the EMI and vice versa.

These are the factors on which your EMI amount depends. You can alter these values in the EMI calculator as per your loan details or preference.

EMI Calculation Formula with Example

After learning about each variable, let's get a clear idea of how this calculator works.

Suppose you have availed a loan of Rs 10 lakh to build a house. The lending institution has offered a loan with an annual interest rate of 7.2% for a tenure of 10 years.

As per the formula, the monthly loan repayment amount will be:

P x R x (1+R)^N / [(1+R)^N-1] where,

N is 10 years or 120 months

R is 7.2% = 7.2/12/100 = 0.006

EMI = Rs 10,00,000 * 0.006 * (1 + 0.006)120 / ((1 + 0.006)120 – 1) = Rs 11,714.

Hence, you will be paying the EMI of Rs 11,714 every month for 10 years. Some lending institutions may show you the break up between the principal amount and interest rates to help you assess your EMI payments.

Factors affecting your monthly EMI amount

With the current market rates, tenure and other factors, both the number of EMIs and the amount can change. The principal factors that can have an impact on your loan amount, as well as EMI, are as follows:

  • Fixed or floating rate of interest on loans

The kind of interest paid on the loan is an important factor in determining your monthly EMI amount. For instance, in case of a loan with a fixed rate of interest, EMI payments remain constant throughout the tenure. Whereas the interest rate on loans with floating rates fluctuates in accordance with market rates.

  • Pre-closing or partial payments

It is another factor that affects your EMI payments. The principal amount of the loan gets reduced every time you make partial payments towards the loan. This leads to a reduction of the total interest that must be paid.

In most cases, if you are making a partial payment, you will be given an option of keeping the tenure or the EMI amount the same. Your loan duration or tenure will decrease if the EMI is kept same. In a similar way, your monthly payment obligation will reduce if the tenure stays the same.

It is clear that all varying factors complicate the process of calculating your monthly EMI manually. In such a scenario, an online EMI calculator enables you to calculate the repayment amount seamlessly. Hence, you get to save a lot of time, resulting in a hassle-free and convenient experience.

Final Word

Before applying for any loan, it is imperative to calculate your repayment amount to ensure that the EMI payments won’t strain your finances. This article has discussed the EMI calculator formula in detail, which can help you understand how the repayment amount is calculated. As a result, you can manage your finances most efficiently.

Frequently Asked Questions

  1. Are EMI calculators accurate?

Yes, the automatically fed formula into the calculator’s system helps to compute EMIs of any loan within a few seconds. It reduces the errors associated with lengthy calculations.

  1. What are the advantages of using an EMI calculator?

You can use EMI calculators anytime, anywhere. Using an EMI calculator gives you the liberty to make various adjustments and also helps you to compare different loan principal amounts and their EMIs effortlessly.

  1. What is an ideal EMI?

There is no such major thumb rule for an ideal EMI; it depends on your repayment or financial capacity. However, it is advisable not to exceed 40% of your salary.

  1. What are the different types of EMI calculators?

There are different types of EMI calculators. This includes a personal loan EMI calculator, car loan EMI calculator, home loan EMI calculator, education loan EMI calculator and Loan against Property EMI calculator. Therefore, you can use these calculators depending on your loan type.

EMI Formula: How To Calculate EMI With Example (2024)

FAQs

EMI Formula: How To Calculate EMI With Example? ›

Examples of Equated Monthly Installment (EMI)

How is EMI calculated with an example? ›

For example, If a person avails a loan of ₹10,00,000 at an annual interest rate of 7.2% for a tenure of 120 months (10 years), then his EMI will be calculated as under: EMI= ₹10,00,000 * 0.006 * (1 + 0.006)120 / ((1 + 0.006)120 - 1) = ₹11,714. Calculating the EMI manually using the formula can be tedious.

How to calculate EMI in Excel with example? ›

To calculate EMIs and interest for Personal Loans using Excel, input the loan amount, annual interest rate and loan tenure into separate cells. Then, use the formula =PMT(B2/12, B3, B1) in the EMI cell where B2 is the interest rate, B3 is the tenure and B1 is the loan amount.

How to calculate EMI on simple calculator? ›

all you need are the details like the amount borrowed, interest rate, and loan tenure to calculate your monthly EMI. the formula for calculation is: EMI = [p x r x (1+r)^n]/[(1+r)^n-1]

What is the formula for calculating monthly installment? ›

EMI = [P x R x (1+R) ^N]/ [(1+R) ^ (N-1)], where –
  1. P is the principal amount.
  2. R is the rate of interest.
  3. N is the loan tenure.

What is a EMI calculator? ›

An EMI calculator can help borrowers estimate their monthly payments of loans based on the principal amount, interest rate, tenure, and other factors.

What is the full form of EMI with example? ›

EMI stands for Equated Monthly Instalment. Essentially, an EMI is a fixed payment amount made by a borrower to a lender on a specified date each month. This instalment includes both the principal loan amount and the interest accrued over the loan tenure.

How to calculate monthly installments in Excel? ›

=PMT(1.5%/12,3*12,0,8500)

The rate argument is 1.5% divided by 12, the number of months in a year. The NPER argument is 3*12 for twelve monthly payments over three years. The PV (present value) is 0 because the account is starting from zero.

How to calculate principal and interest from EMI? ›

How to Calculate Principal Amount From EMI Using Excel Sheet
  1. To get the principal component in a particular month type: =PPMT(I,x,n,-p)
  2. To get the interest component in a particular month: =IPMT(I,x,n,-p)
  3. Also, you can calculate your EMI by typing: =PMT (I,n,-p)

How to calculate loan EMI step by step? ›

Online EMI calculators also work on the basis of this formula: EMI = [P x R x (1+R)^N]/[(1+R)^N-1]. So to get a comprehensive understanding of these variables, let's discuss them in detail: R represents 'rate of interest'.

How to calculate interest by EMI? ›

E = P*r*(1+r)^n/((1+r)^n-1) where,
  1. E is EMI.
  2. P is the principal loan amount,
  3. r is the rate of interest calculated monthly, and.
  4. n is the tenure/ duration in months.

How do you calculate monthly interest? ›

For example, if you currently owe $500 on your credit card throughout the month and your current APR is 17.99%, you can calculate your monthly interest rate by dividing the 17.99% by 12, which is approximately 1.49%. Then multiply $500 x 0.0149 for an amount of $7.45 each month.

How is EMI divided in principal and interest? ›

EMI = (Principal + Interest)/Period in Months. Thus, you can apply the interest rate to the principal amount to determine the interest amount due over the entire tenure of the loan. Then add the principal amount with interest determined and divide that sum with the loan period in months.

What is the formula for calculating EMI in Excel? ›

In a new cell, type "=PMT(interest rate/12, loan tenure*12, -loan amount)" without quotes. The PMT function calculates the EMI. Press Enter, and the cell will show the EMI amount.

What is the formula for calculating interest on a loan? ›

To calculate interest rates, use the formula: Interest = Principal × Rate × Tenure. This equation helps determine the interest rate on investments or loans. What are the advantages of using a loan interest rate calculator?

How does EMI work on a credit card? ›

Tenures for credit card EMIs range from three to 18 months. You will have a lower credit limit, as the bank will reduce your limit by the amount of your EMI. Your minimum payment due every month will be higher, by the amount of your EMI. Try to settle the outstanding amount, including your EMI, in full every month.

Top Articles
Latest Posts
Article information

Author: Twana Towne Ret

Last Updated:

Views: 5498

Rating: 4.3 / 5 (64 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Twana Towne Ret

Birthday: 1994-03-19

Address: Apt. 990 97439 Corwin Motorway, Port Eliseoburgh, NM 99144-2618

Phone: +5958753152963

Job: National Specialist

Hobby: Kayaking, Photography, Skydiving, Embroidery, Leather crafting, Orienteering, Cooking

Introduction: My name is Twana Towne Ret, I am a famous, talented, joyous, perfect, powerful, inquisitive, lovely person who loves writing and wants to share my knowledge and understanding with you.