Housing Loan EMI Calculator: Formula and Worked Example

This housing loan EMI calculator estimates your monthly payment from the loan amount, annual interest rate and repayment term. Enter those figures to see the monthly EMI and total interest, using a fixed-rate monthly-payment formula; all monetary figures are in your currency.

Formula

For a fixed-rate loan paid monthly, calculate the EMI as:

EMI = round[P × r ÷ (1 − (1 + r)⁻ⁿ), 2]

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

The calculator rounds the monthly payment to two decimal places. It estimates total interest as the rounded EMI multiplied by the number of payments, minus the principal. The rate input is an annual percentage rate; the formula converts it to a monthly rate before calculating.

Worked Example

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

1. Convert the annual rate to a monthly decimal: 8 ÷ 1200 = 0.0066667.
2. Convert the term to monthly payments: 20 × 12 = 240.
3. Substitute into the formula: 200,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)⁻²⁴⁰].
4. Round the monthly payment to two decimal places: 1,672.88 in your currency per month.
5. Calculate estimated total interest using that rounded payment: 1,672.88 × 240 − 200,000 = 201,491.20 in your currency.

The calculation assumes the stated rate and term apply throughout. Lenders may calculate instalments or disclose totals differently because of payment dates, rate changes, fees or other loan terms.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal monthly instalments, made at the end of each monthly period.
• Interest accrues monthly at the annual APR divided by 12.
• The estimate excludes fees, taxes, insurance, mortgage insurance, escrow, and any charges or add-ons not entered in the calculator.

What the EMI Includes—and Excludes

For a standard amortizing housing loan, each scheduled payment covers interest accrued for that period and part of the principal. Early in the repayment schedule, the outstanding balance is larger, so more of a level payment generally goes to interest. As the balance falls, the interest portion declines and more of the payment reduces principal. The precise allocation depends on the lender’s calculation and payment schedule.

The calculator’s EMI is the loan repayment estimate, not necessarily the complete monthly cost of owning a home. A lender may collect separate charges, and ownership costs can include items such as insurance, property-related taxes, maintenance and utilities. Those costs are not included here. Check the lender’s payment breakdown and use actual quoted figures when estimating cash outlay.

How to Use and Read the Estimate

• Loan amount: Enter the principal you expect to borrow, not the property’s full purchase price unless the entire price is being financed.
• Interest rate: Enter the annual percentage rate supplied for the loan offer. Do not enter a monthly rate in this field.
• Loan term: Enter the repayment period in years. The formula converts it into a number of monthly instalments.
• Monthly EMI: Read this as the estimated level payment for principal and interest, in your currency.
• Total interest: This is the sum of the rounded monthly payments over the full term minus the original principal. It is not the total amount paid; add principal to the displayed interest for that estimate.

Use the same currency for the loan amount and the results. The percentage input is expressed as an annual rate, while the formula uses a monthly rate. A small change in the rate or term can affect the payment and total interest, so recalculate if the lender’s final figures differ from your initial assumptions.

Factors That Change the Payment

With the rate and term held constant, a larger principal produces a larger EMI. With principal and rate held constant, a longer term generally lowers each scheduled payment because repayment is spread across more months, but it also means payments continue for longer. In this fixed-rate model, extending the term therefore generally increases the total interest paid.

A higher interest rate generally raises both the monthly payment and the total interest for the same principal and term. These are relationships in the formula, not forecasts of rates or loan offers. Use the rate and fees actually disclosed by the lender rather than assuming a rate from an example or another borrower.

Common Calculation Problems and Limits

• Using the wrong rate units: An annual rate of 8% is entered as 8, not 0.08 or 8 per month. The calculator divides the percentage by 1200.
• Confusing principal with purchase price: If you are borrowing only part of the price, calculate using the loan amount, not the amount you are paying from other funds.
• Expecting a variable-rate forecast: This calculation holds the rate constant. It cannot predict future payment changes on a loan whose rate can change.
• Ignoring rounding and payment conventions: The payment is rounded to two decimal places. Lender statements can differ slightly because of rounding, exact payment dates, daily interest calculations or other contract terms.

The standard EMI formula applies to a fully amortizing loan with equal monthly payments and a positive rate. It does not model a changing balance from extra repayments, missed payments, a balloon amount, payment holidays, fees added to principal, or a rate reset. For a loan with any of these features, the displayed result is a simplified estimate rather than a complete repayment schedule.

Frequently Asked Questions

How do I calculate housing loan EMI?
Convert the annual interest rate to a monthly decimal by dividing the percentage by 1200, convert the term to months, and apply the fixed-payment formula shown above. The calculator carries out those steps and rounds the payment to two decimal places.

Does EMI include principal and interest?
In a standard amortizing loan, the scheduled EMI includes both principal repayment and interest. This estimate excludes separate charges and ownership costs unless they are part of the loan amount entered.

Why can my lender’s EMI differ from this estimate?
The lender may use different payment dates, rounding or interest-accrual conventions, or include loan-specific charges. A changing rate or a different repayment structure also falls outside this fixed-rate calculation. Compare the assumptions and lender disclosure.

Does a longer loan term reduce total interest?
Not generally in this fixed-rate model. A longer term usually spreads repayment across more months and can lower the monthly payment, while increasing the total interest over the full repayment period.

Can I use this calculator for a variable-rate housing loan?
You can use it to estimate a payment at one assumed rate, but it does not forecast rate changes or recalculate a future payment schedule. Treat the result as a snapshot, not a prediction.

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

Related

• QLS Default Interest Rate: What It Means
• PPF Account Interest Rate: How It Is Set
• PPF Interest Rate: Current Rate and How It Works

in p | Loan amount | - | 200000 | 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