EMI Calculator: Understand Your Monthly Loan Payment

What Is an EMI?

EMI stands for Equated Monthly Installment. It is a fixed amount you pay to a lender each month to repay a loan, covering both the principal amount borrowed and the interest charged. The EMI is the same every month for the duration of the loan term, which makes budgeting straightforward.

The total amount you pay for a loan depends on three key things: the amount borrowed, the interest rate, and the number of years you take to repay the loan. Because the EMI is fixed, it is important to understand how these three inputs interact to set your monthly obligation.

Sources: Consumer Financial Protection Bureau, CRED, marketfeed, HDFC Bank

The EMI Formula Explained

The standard formula to calculate EMI is: EMI = P × r × (1 + r)^n / ((1 + r)^n - 1). In this formula, P is the principal loan amount, r is the monthly interest rate (the annual rate divided by 12), and n is the number of monthly payments (the loan tenure in months).

The formula assumes a fixed interest rate and a reducing balance method, meaning interest is charged on the outstanding principal each month. This is the most common method used by lenders for fixed-rate loans.

The formula comes from the present value of an annuity, which calculates the constant payment that pays off a loan over a fixed period at a given interest rate.

• P = principal, the amount borrowed
• r = monthly interest rate = annual interest rate / 12
• n = total number of monthly payments = loan tenure in years × 12

Sources: marketfeed, CRED, Butter Money, HDFC Bank

Inputs Needed: Principal, Interest Rate, and Tenure

Three inputs determine your EMI: the principal amount, the interest rate, and the loan tenure. The principal is the total amount you borrow. The tenure is the number of months you have to repay the loan. To get the monthly interest rate, divide the annual rate by 12.

These three inputs affect your EMI in predictable ways. A higher principal increases the monthly payment because you are repaying a larger amount. A higher interest rate increases the monthly payment because more interest accrues on the outstanding balance. A longer tenure reduces the monthly payment by spreading the repayment over more months, but it also increases the total interest paid over the life of the loan.

Sources: HDFC Bank, CRED, Consumer Financial Protection Bureau

Step-by-Step Calculation Example

The monthly rate r is 0.06/12 = 0.005. The number of payments n is 15 × 12 = 180.

Plugging the numbers into the formula: EMI = 200,000 × 0.005 × (1 + 0.005)^180 / ((1 + 0.005)^180 - 1). First, compute (1 + 0.005)^180, which is approximately 2.455. The numerator becomes 200,000 × 0.005 × 2.455 = 2,455. The denominator is 2.455 - 1 = 1.455.

• Tenure = 15 years, so number of payments (n) = 180 months

Sources: marketfeed, HDFC Bank

How to Use a Spreadsheet to Compute EMI

Spreadsheets have built-in functions that make EMI calculation quick. The most common is the PMT function, which stands for payment. In Excel or Google Sheets, you can enter: =PMT(rate, nper, pv) where rate is the monthly interest rate, nper is the number of payment periods, and pv is the present value (the loan amount, entered as a negative number because it's money you receive).

You can change any input to see how the EMI responds.

• Use the PMT function in Excel or Google Sheets.
• Identify the monthly rate (annual rate divided by 12).
• Identify the number of months as nper.
• Identify the loan amount as a negative present value.

Sources: Butter Money

Limitations of the Calculation and When to Consult a Lender

The standard EMI formula provides a good estimate, but it has limitations. It assumes a fixed interest rate for the entire loan term. If you have an adjustable-rate mortgage, your payment may change when the rate adjusts, as the lender recalculates based on the new rate and remaining term.

Also, mortgage calculators and EMI calculators typically estimate only the principal and interest portion of the payment. They often do not include property taxes, homeowners insurance, or other costs such as fees. Using a realistic interest rate is essential; advertised rates often assume excellent credit and a 20% down payment, which may not match your situation.

Because lenders may use different calculation methods or include additional charges, the EMI you actually get can differ from your estimate. Always consult your lender for a precise quote and to understand all components of your monthly payment.

Sources: Consumer Financial Protection Bureau