calculate-loan

05 Mortgage and home equity

Housing Loan EMI Calculator: Formula and Example

Calculator No. 05-0164 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

Calculate a housing loan EMI by entering the principal, annual interest rate and loan term; the calculator returns the estimated monthly payment and total interest. It uses a fixed-rate monthly-payment formula, so it does not include charges such as taxes, insurance or lender fees.

Formula

A level-payment loan EMI is the amount that, when paid each month, covers that month’s interest and repays part of the principal so the balance reaches zero at the end of the term. The formula is:

EMI = P × r × (1 + r)n ÷ [(1 + r)n − 1]

  • P is the amount borrowed, in your currency.
  • r is the monthly interest rate as a decimal: annual APR ÷ 12 ÷ 100.
  • n is the number of monthly payments: loan term in years × 12.
  • EMI is the monthly payment, in your currency.

The calculator uses the equivalent expression P × r ÷ [1 − (1 + r)−n] and rounds the monthly EMI to two decimal places. Total interest is then calculated as the rounded EMI multiplied by the number of payments, minus the principal. A lender’s final schedule can differ because of its rounding and payment conventions.

Worked Example

Using the calculator’s default values—principal of 2,000,000 in your currency, APR of 8%, and a 20-year term:

  1. Convert the annual rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066666667.
  2. Find the number of payments: n = 20 × 12 = 240.
  3. Substitute: EMI = 2,000,000 × 0.0066666667 ÷ [1 − (1.0066666667)−240].
  4. Round the monthly result to two decimal places: EMI = 16,728.64 in your currency.
  5. Calculate total interest using the rounded payment: 16,728.64 × 240 − 2,000,000 = 2,014,873.60 in your currency.

The total of the monthly payments is 4,014,873.60 in your currency; 2,000,000 repays principal and 2,014,873.60 is estimated interest under these assumptions.

Assumptions

  • The interest rate remains fixed for the full term.
  • There is one payment each month, made at the end of the period.
  • Interest compounds monthly at the annual APR divided by 12.
  • The estimate excludes lender fees, taxes, insurance, private mortgage insurance, escrow and other charges; none are calculator inputs.

How to Use and Read the Estimate

Enter the amount actually borrowed, not necessarily the home’s purchase price. If a down payment or other funds reduce the amount financed, use the resulting loan principal. Enter the annual rate as a percentage—for example, enter 8 for 8%, not 0.08—and enter the term in years. The calculated EMI is a principal-and-interest payment estimate. It is not automatically the full amount due for housing each month.

The separate total-interest result describes the interest implied by the fixed-rate formula over all scheduled payments. It is not the total cost of owning a home. Add relevant costs from your own loan and housing documents to understand cash outflow; this calculator cannot infer them. The result also does not establish whether a lender will approve a loan or what rate or fees it will offer.

EMI is often used to mean “equated monthly instalment.” In a standard fixed-rate amortizing loan, the payment stays level while the mix changes: early payments generally contain more interest, and later payments contain more principal. This happens because interest is calculated on the outstanding balance, which declines as principal is repaid. A level EMI therefore does not mean the same amount of principal is repaid every month.

What Changes the EMI

  • Principal: A larger amount borrowed increases the payment when rate and term are unchanged.
  • Interest rate: A higher entered APR increases the scheduled payment and, generally, the interest paid over the same term.
  • Loan term: A longer term spreads repayment across more months, usually lowering the scheduled payment but extending the time interest accrues. Compare total interest as well as EMI when considering different terms.

For example, the worked example’s 240 payments each include both interest and principal. Dividing the principal alone by 240 would give 8,333.33 per month, but that is not the EMI: it ignores interest. The amortizing formula accounts for the interest accruing on the remaining balance throughout the repayment period.

Common Calculation Mistakes and Limits

  • Mixing up annual and monthly rates: The formula needs a monthly rate. Divide an annual percentage rate by 1,200 to convert it to a monthly decimal.
  • Using the wrong term unit: Convert years to months by multiplying by 12. A 20-year term means 240 payments, not 20.
  • Confusing EMI with the full housing payment: Taxes, insurance, escrow and other costs may be billed separately or included in a lender’s payment collection. They are not represented here.
  • Rounding intermediate values: Rounding the monthly rate or powers too early can cause small differences. The calculator rounds the EMI to two decimals and uses that rounded payment to compute total interest.
  • Assuming every loan is fixed-rate: A variable or adjustable rate may change, so one fixed-rate calculation cannot forecast later payments. A changing balance, extra payments, missed payments, fees financed into the principal or a different payment schedule can also alter the actual schedule.

Use the result as a mathematical estimate, not as a lender quote or a complete budget. For a rate, fees, payment dates or an amortization schedule specific to a proposed loan, use the figures and terms supplied by the lender.

Frequently Asked Questions

How do I calculate housing loan EMI manually?
Convert APR to a monthly decimal by dividing by 1,200, convert the term to months, then apply EMI = P × r × (1 + r)n ÷ [(1 + r)n − 1]. P is the principal, r the monthly rate and n the number of payments.

Does EMI include property taxes and home insurance?
Not in this calculator. It estimates scheduled principal and interest only. Check the loan documents to see whether other charges are collected separately or included in a payment.

Why does more of an early EMI go toward interest?
Interest for each period is based on the outstanding principal. The balance is largest near the start, so the interest portion is larger; as principal falls, the interest portion generally falls too.

Will my actual housing loan EMI match this result?
It may differ if the lender uses different rounding, payment timing or compounding, or if the rate, financed amount, fees or payment schedule changes. Compare the estimate with the lender’s disclosed figures.

What happens to EMI if the loan term increases?
For the same principal and fixed rate, a longer term generally lowers the scheduled monthly payment because repayment is spread over more months. It also means interest accrues for longer, so total interest can be higher.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

Formula used
in p | Loan amount | - | 2000000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 20 | 0.0833 | 50
out pmt | Monthly EMI | - | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | - | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Mortgage and home equity section →