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? ›

The mathematical formula for calculating EMIs is: EMI = [P x R x (1+R)^N]/[(1+R)^N-1], where P stands for the loan amount or principal, R is the interest rate per month [if the interest rate per annum is 11%, then the rate of interest will be 11/(12 x 100)], and N is the number of monthly instalments.

How to calculate EMI with an example? ›

How to calculate EMI with an example? To calculate EMI (Equated Monthly Instalment), you can use the following 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 divided by 12), and n is the loan tenure in months.

What is the formula for EMI simplified? ›

The formula to calculate EMI is P x R x (1+R)^N / [(1+R)^N-1] – where, “P” is the principal loan amount, “N” in tenure in months, and “R” is the prevailing interest rate.

What is the formula for EMI in simple interest? ›

The formula is P x R x T, where P= Principal, R=Rate and T=Time. You might also ask how to calculate EMI in simple interest. The formula for the same is EMI = [p x r x (1+r)^n]/[(1+r)^n-1]. A simple interest calculator for loans works similarly to that of investments.

How to calculate EMI formula Excel? ›

Calculating EMIs with the formula

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.

What is a EMI calculator? ›

An EMI calculator is a financial tool that calculates your Equated Monthly Instalment (EMI) for a loan. The EMI is the amount you pay the lender every month for the loan amount you have borrowed. The EMI calculator takes into account the loan amount, interest rate, and loan tenure to calculate the EMI accurately.

What is the formula for the monthly payment? ›

Monthly Payment = (P × r) ∕ n

Again, “P” represents your principal amount, and “r” is your APR. However, “n” in this equation is the number of payments you'll make over a year. Now for an example. Let's say you get an interest-only personal loan for $10,000 with an APR of 3.5% and a 60-month repayment term.

How to calculate EMI without formula? ›

The EMI amount is calculated by adding the total principal of the loan and the total interest on the principal together, then dividing the sum by the number of EMI payments, which is the number of months during the loan term.

How do you calculate monthly installments? ›

The equation to find the monthly payment for an installment loan is called the Equal Monthly Installment (EMI) formula. It is defined by the equation Monthly Payment = P (r(1+r)^n)/((1+r)^n-1). The other methods listed also use EMI to calculate the monthly payment. r: Interest rate.

How to calculate monthly payment on a loan? ›

The formula is: M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1], where M is the monthly payment, P is the loan amount, i is the interest rate (divided by 12) and n is the number of monthly payments.

What is the logic behind EMI formula? ›

The EMI flat-rate formula is calculated by adding together the principal loan amount and the interest on the principal and dividing the result by the number of periods multiplied by the number of months.

How to calculate simple interest with an example? ›

= (P × R × T)/100 by R × T, we get P = (100 × S.I.)/(R × T). Similarly, we can solve for either R or T. Sometimes, the simple interest formula is written as just SI = PRT where R is the rate of interest as a decimal. i.e., if the rate of interest is 5% then R can be written as 5/100 = 0.05.

How does EMI work? ›

How do EMIs on credit cards work? Some card issuing banks offer customers the option of paying their bills in EMIs (equated monthly installments). The EMI option is applicable on selected purchases or your total outstanding. Some banks may even call you soon after a large transaction offering the EMI option.

How to calculate monthly EMI formula with 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 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 interest? ›

To calculate simple interest at an 11% rate, multiply the principal amount by the interest rate and the time period (in years). The formula is: Simple Interest = Principal × Rate × Time.

How to calculate monthly installment payment? ›

The equation to find the monthly payment for an installment loan is called the Equal Monthly Installment (EMI) formula. It is defined by the equation Monthly Payment = P (r(1+r)^n)/((1+r)^n-1). The other methods listed also use EMI to calculate the monthly payment. r: Interest rate.

What is the formula for calculating EMI on a car? ›

The EMI due each month on your car loan is ascertained with a mathematical formula: EMI Amount = [P x R x (1+R) ^N]/[(1+R) ^N-1], wherein P in principle, R is the rate of interest, and N is the number of instalments.

What is the formula for present value of EMI? ›

The present value formula is PV=FV/(1+i)n, where you divide the future value FV by a factor of 1 + i for each period between present and future dates.

How do you calculate monthly interest? ›

Simply divide your APY by 12 (for each month of the year) to find the percent interest your account earns per month. For example: A 12% APY would give you a 1% monthly interest rate (12 divided by 12 is 1). A 1% APY would give you a 0.083% monthly interest rate (1 divided by 12 is 0.083).

Top Articles
Latest Posts
Article information

Author: Rubie Ullrich

Last Updated:

Views: 6685

Rating: 4.1 / 5 (72 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Rubie Ullrich

Birthday: 1998-02-02

Address: 743 Stoltenberg Center, Genovevaville, NJ 59925-3119

Phone: +2202978377583

Job: Administration Engineer

Hobby: Surfing, Sailing, Listening to music, Web surfing, Kitesurfing, Geocaching, Backpacking

Introduction: My name is Rubie Ullrich, I am a enthusiastic, perfect, tender, vivacious, talented, famous, delightful person who loves writing and wants to share my knowledge and understanding with you.