calculate-loan

01 Loan payments

Property Loan EMI Calculation: Formula and Example

Calculator No. 01-10496 · 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.

A property loan EMI calculator estimates the fixed monthly payment needed to repay a loan over a chosen term at a stated annual interest rate. Enter the loan amount, annual rate and term to see the monthly EMI and the total interest calculated using that payment.

Formula

For a fixed-rate loan with equal monthly payments, the EMI is calculated using the standard amortizing-loan formula:

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 level monthly principal-and-interest payment, in your currency.

The calculator rounds the monthly payment to two decimal places, then estimates total interest as EMI × n − P. This makes the displayed total use the same rounded payment shown as the EMI. The formula assumes a positive annual rate; the calculator’s rate input therefore starts at 0.01%.

Worked Example

Using the defaults above: a property loan of 5,000,000 in your currency, an 8% annual APR and a 20-year term.

  1. Convert the annual rate to a monthly decimal: 8 ÷ 12 ÷ 100 = 0.0066667.
  2. Convert the term to payments: 20 × 12 = 240 months.
  3. Substitute into the formula: EMI = 5,000,000 × 0.0066667 × (1.0066667)240 ÷ [(1.0066667)240 − 1].
  4. The monthly EMI, rounded to two decimal places, is approximately 41,822.35 in your currency.
  5. Total of the rounded payments: 41,822.35 × 240 = 10,037,364.00. Estimated total interest: 10,037,364.00 − 5,000,000 = 5,037,364.00.

These are formula estimates. A lender’s repayment schedule may differ because of payment dates, rounding conventions, rate changes or charges that are outside this calculation.

Assumptions

  • The interest rate stays fixed for the entire term.
  • Payments are equal, made monthly, and the first payment follows one monthly period after borrowing.
  • Interest is calculated monthly using the annual APR divided by 12.
  • The calculation excludes fees, taxes, insurance, mortgage insurance, escrow and other property or loan costs.

What the EMI Shows

An EMI is the scheduled monthly amount for repaying principal and interest under the formula’s assumptions. In the early part of a standard amortizing loan, a larger share of each payment generally goes toward interest because the outstanding principal is higher. As principal is repaid, the interest portion falls and more of each level payment reduces the balance.

EMI is not necessarily the full monthly cost of owning or financing a property. A lender may collect separate amounts, or combine some charges with a payment, depending on the loan arrangement. This calculator does not estimate those items. It also does not determine whether a lender will approve an application or what rate or charges will apply. Use the actual loan amount, rate and term supplied in a lender’s written figures to make a like-for-like arithmetic estimate.

How to Use the Result

  • Loan amount: Enter the principal being borrowed, not the property’s purchase price unless the full price is being financed.
  • Interest rate: Enter the annual rate as a percentage, such as 8 for 8%. Do not enter 0.08 for 8%.
  • Term: Enter years. The formula converts years to monthly payments by multiplying by 12.
  • Compare scenarios: Change one input at a time to see how the calculated EMI responds. A larger principal or rate raises the payment; a longer term usually lowers the monthly payment but increases the number of payments.

Use the same currency and consistent loan assumptions when comparing outputs. The calculator’s money unit is shown as “in your currency” because the arithmetic does not depend on a specific currency. Check whether the amount entered is the actual principal after any down payment and whether the rate is the relevant rate for the loan period.

Common Calculation Mistakes and Limits

A frequent mistake is treating an annual percentage as a monthly rate. For an 8% APR, the monthly decimal in this formula is 8 ÷ 1,200, not 8 or 0.08. Another is entering the term in months when the input asks for years; a 20-year term means 240 monthly payments.

The result also depends on the rate remaining unchanged and on regular monthly payments. If a loan has a variable rate, a changing payment schedule, interest-only periods, a balloon payment or irregular payment dates, this simple formula will not represent every stage of repayment. Fees that are financed into the principal should be included in the amount borrowed if the goal is to estimate payments on that larger balance; separately charged fees are not included automatically.

Rounding can cause small differences between a calculator and a lender’s schedule, especially over a long term. Here the payment is rounded to the nearest cent before total interest is calculated. A lender may instead adjust the final installment or use different day-count and rounding conventions. The displayed total interest is therefore an estimate, not a statement of the exact amount due.

Frequently Asked Questions

How do I calculate property loan EMI manually?
Convert APR to a monthly decimal by dividing the annual percentage by 1,200, and convert years to months by multiplying by 12. Substitute those values and the principal into the EMI formula above.

Does EMI include property taxes and insurance?
No. This calculation covers principal and interest only. Taxes, insurance, fees and other charges are not included unless separately accounted for in a different calculation.

Why does a longer loan term reduce the EMI?
The principal is spread over more monthly payments, which can reduce each payment under the formula. Since interest accrues over a longer period, the total interest can be higher even when the monthly EMI is lower.

Can I use this formula for a variable-rate property loan?
It estimates payments for a rate assumed to remain fixed. If the rate changes, the payment or repayment schedule may also change, so this result cannot forecast later installments.

Why might my lender’s EMI differ from this estimate?
The lender may use different rounding, payment dates, rate terms or included charges. Compare the principal, rate, term and payment assumptions, and refer to the lender’s disclosure for the loan-specific figures.

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

Related

Formula used
in p | Property loan amount | - | 5000000 | 1 | 1000000000
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 Loan payments section →