Home Loan EMI Calculator

Calculate your monthly housing loan EMI, total interest payable, prepayment savings, and Section 24(b) tax deductions.


₹ 50,00,000
8.50%
Current benchmark floating rates: SBI (8.40%–9.15%), HDFC (8.50%–9.40%), ICICI (8.60%–9.50%).
20 Years (240 Months)
Optional Prepayment Simulator No Prepayment
Monthly Home Loan EMI

₹ 43,391

Payable monthly for 240 installments
Principal Loan ₹ 50,00,000 48.0% of Total
Total Interest ₹ 54,13,879 52.0% of Total
Total Outflow ₹ 1,04,13,879 Principal + Interest
Principal: 48.0% (₹ 50,00,000) Interest: 52.0% (₹ 54,13,879)
Annual Tax Benefit Potential (Old Regime) Sec 24(b) + Sec 80C
Interest Deduction (Sec 24b): ₹ 2,00,000 max Principal Deduction (Sec 80C): ₹ 1,50,000 max
Potential annual tax savings of up to ₹ 1,09,200/year (at 30% slab rate + 4% cess).

Year-by-Year Home Loan Amortization Schedule

Reducing Balance Method
Year Opening Balance (₹) Principal Paid (₹) Interest Paid (₹) Total Annual EMI (₹) Closing Balance (₹) Loan Paid %

How Home Loan EMI Works in India: The Financial Mechanics


A Home Loan Equated Monthly Installment (EMI) is a fixed monthly cash outflow that a borrower pays to a financial lender (a commercial bank or Housing Finance Company like SBI, HDFC Bank, ICICI Bank, or LIC Housing Finance) to service and extinguish a housing loan.

Every monthly installment consists of two distinct components:

  • Interest Component: The fee charged by the lender for using their capital, calculated strictly on your outstanding principal balance for that specific month.
  • Principal Repayment Component: The portion of your EMI that directly knocks down your outstanding loan balance.

In India, all floating-rate retail home loans sanctioned by scheduled commercial banks are pegged to external benchmarks—primarily the Reserve Bank of India's Repo Rate (EBLR / RLLR). Whenever the RBI adjusts the benchmark repo rate, your floating interest rate moves accordingly, automatically adjusting your remaining repayment tenure or monthly EMI installment.

Bank Spread vs Benchmark: Your effective home loan interest rate is expressed as: Effective Interest Rate = RBI Repo Rate + Bank Spread / Margin. For example, if the Repo Rate is 6.50% and the bank spread based on your CIBIL score is 2.00%, your effective interest rate is 8.50% p.a.

The Mathematical Formula Behind Home Loan EMI Calculations


Indian banking institutions compute monthly housing loan installments using the standard Reducing-Balance Amortization Formula:

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

Where the mathematical variables are defined as:

  • P (Principal Loan Amount): The total capital borrowed from the bank (e.g. ₹50,00,000).
  • r (Monthly Periodic Interest Rate): The annual percentage rate divided by 12 and then divided by 100. For an 8.50% annual rate: r = 8.5 ÷ 12 ÷ 100 = 0.00708333.
  • n (Tenure in Total Months): The loan duration multiplied by 12. For a 20-year home loan: n = 20 × 12 = 240 months.

Step-by-Step Worked Example: ₹50 Lakh Home Loan at 8.5% for 20 Years

  1. Monthly Interest Rate (r): 8.50 ÷ 1200 = 0.00708333
  2. Compounding Factor (1 + r)n: (1 + 0.00708333)240 = 5.42115
  3. Numerator Calculation: ₹50,00,000 × 0.00708333 × 5.42115 = 1,92,008.2
  4. Denominator Calculation: 5.42115 − 1 = 4.42115
  5. Final Monthly EMI: 1,92,008.2 ÷ 4.42115 = ₹43,391 per month

Total Cash Outflow: Across 240 months, you will repay a total of ₹1,04,13,879 (₹1.04 Crores). This comprises your original principal of ₹50,00,000 and total interest of ₹54,13,879 (interest exceeds the borrowed principal by over ₹4.1 Lakhs).

The Front-Loaded Interest Trap: Why Early EMIs Barely Touch Your Principal


Many first-time homebuyers are astonished to find that after paying regular EMIs for 3 full years, their outstanding loan principal has barely declined. This is not a clerical error—it is the direct mathematical result of the front-loaded amortization curve:

Years 1 to 5: The Interest-Heavy Phase

Because interest is billed against the massive opening principal balance, up to 70% to 75% of every single monthly EMI payment in the initial 5 years goes towards interest. For a ₹50L loan, in Month 1, ₹35,417 goes towards interest and only ₹7,974 reduces your principal!

Years 15 to 20: The Principal Acceleration Phase

As the outstanding principal drops below ₹20 Lakhs, the monthly interest charge plummets. In the final 5 years, over 80% of your EMI goes directly towards knocking out the remaining principal balance.

3 High-Impact Home Loan Prepayment Strategies: Save Lakhs in Interest


Because 100% of any lump-sum prepayment goes directly towards reducing your principal balance, strategic part-payments in the early years create massive compounding interest savings:

Prepayment Strategy Action Plan Tenure Reduction Interest Saved (on ₹50L / 20-Yr Loan)
1. The "1 Extra EMI Per Year" Strategy Pay 13 EMIs a year instead of 12 (pay 1 extra EMI every December or during annual bonus season). Cuts tenure by ~4.5 Years Saves ~₹12.5 Lakhs
2. The "5% Annual EMI Step-Up" Strategy Increase your monthly EMI amount by just 5% every year as your salary increases. Cuts tenure from 20 to ~11.5 Years Saves ~₹24.8 Lakhs
3. Annual Lump-Sum Part-Payment Prepay ₹1,00,000 every year whenever you receive performance bonuses or tax refunds. Cuts tenure by ~6.5 Years Saves ~₹18.2 Lakhs
Zero Prepayment Penalty: As per Reserve Bank of India (RBI) mandates, banks cannot charge any penalty on prepaying floating-rate individual home loans. Prepay whenever you have surplus funds!

The 30%–40% FOIR Rule: How Much Home Loan Can You Afford?


When you apply for a housing loan, banks calculate your Fixed Obligation to Income Ratio (FOIR) to verify that your monthly EMI does not jeopardize your financial stability:

FOIR = ( Total Monthly Debt EMIs ÷ Net Monthly Take-Home Salary ) × 100

The Golden Rules of Home Loan Affordability:

  • Conservative Rule (Recommended): Your home loan EMI should ideally not exceed 30% to 35% of your take-home monthly salary.
  • Maximum Bank Limit: Most leading banks permit a maximum FOIR of 45% to 50% across all combined liabilities (car loans, credit cards, and home loan).
  • Example: If your household take-home income is ₹1,50,000 per month, your maximum comfortable home loan EMI is ₹45,000 to ₹55,000 per month, which supports a loan of approximately ₹50 Lakhs to ₹60 Lakhs at current interest rates.

Tax Benefits on Home Loans in India (Old Tax Regime)


Homeowners filing taxes under the Old Tax Regime can claim significant deductions under two separate sections of the Income Tax Act:

1. Section 24(b) - Interest Deduction (Up to ₹2,00,000/year):

You can deduct up to ₹2,00,000 per financial year on the interest portion repaid for a self-occupied residential property. For a let-out (rented) property, there is no upper ceiling on interest deduction against rental income, though overall loss from house property is capped at ₹2 Lakhs per year.

2. Section 80C - Principal Repayment (Up to ₹1,50,000/year):

The principal repayment portion of your EMI qualifies for deduction under Section 80C up to a limit of ₹1,50,000 per year (shared with EPF, PPF, ELSS, SSY, and life insurance premiums). Stamp duty and registration charges paid during property purchase also qualify under 80C in the year of purchase.

Joint Home Loan Advantage: If husband and wife take a joint home loan and are co-owners of the property, both can claim individual deductions: ₹2 Lakh each under Section 24(b) and ₹1.5 Lakh each under Section 80C. This unlocks a total household tax deduction of up to ₹7,00,000 every single year!

Pre-EMI vs Full EMI: Choosing the Right Option for Under-Construction Homes


When buying a home under construction, the bank disburses funds in stages as construction progresses. Borrowers generally have two repayment choices:

Feature Pre-EMI Option Full EMI Option (Tranche-Based)
What is paid? Only simple interest on the disbursed loan amount. Both interest and principal repayment from day one.
Principal Reduction Zero principal reduction during construction. Principal starts reducing immediately.
Monthly Cash Flow Lower monthly outflow during construction phase. Higher monthly commitment during construction.
Total Interest Cost Higher total interest paid over the life of the loan. Significantly lower total interest cost over the loan.

Home Loan Overdraft Accounts (SBI Maxgain & BoB Advantage): Park Surplus to Cut Interest


A Home Loan Overdraft Facility (popularized by SBI Maxgain and Bank of Baroda Home Loan Advantage) acts as a high-powered smart savings account:

  • Your home loan is structured as an overdraft current/savings account.
  • Whenever you park surplus savings, emergency funds, or salary in the linked account, the bank computes daily interest only on the net balance: Net Balance = Outstanding Loan Principal - Parked Surplus.
  • You earn an effective 8.50% tax-free yield (by avoiding 8.50% home loan interest) while retaining the absolute freedom to withdraw your money anytime via Net Banking or ATM.

Master Home Loan EMI Comparison Table (at 8.50% p.a.)


Quick reference table showing monthly EMIs and total interest payable across popular Indian property budget brackets:

Loan Amount (₹) 10 Years (120 Mo) 15 Years (180 Mo) 20 Years (240 Mo) 25 Years (300 Mo) 30 Years (360 Mo)
₹ 20,00,000 ₹24,797 / mo ₹19,695 / mo ₹17,356 / mo ₹16,105 / mo ₹15,378 / mo
₹ 30,00,000 ₹37,196 / mo ₹29,542 / mo ₹26,035 / mo ₹24,157 / mo ₹23,067 / mo
₹ 50,00,000 ₹61,993 / mo ₹49,237 / mo ₹43,391 / mo ₹40,261 / mo ₹38,446 / mo
₹ 75,00,000 ₹92,989 / mo ₹73,856 / mo ₹65,087 / mo ₹60,392 / mo ₹57,669 / mo
₹ 1,00,00,000 (1 Cr) ₹1,23,986 / mo ₹98,474 / mo ₹86,782 / mo ₹80,523 / mo ₹76,891 / mo
₹ 1,50,00,000 (1.5 Cr) ₹1,85,978 / mo ₹1,47,711 / mo ₹1,30,174 / mo ₹1,20,784 / mo ₹1,15,337 / mo
₹ 2,00,00,000 (2 Cr) ₹2,47,971 / mo ₹1,96,948 / mo ₹1,73,565 / mo ₹1,61,045 / mo ₹1,53,783 / mo

How to Calculate Home Loan EMI in Microsoft Excel and Google Sheets


You can calculate home loan installments in any spreadsheet using the built-in financial function =PMT():

=PMT( Annual_Interest_Rate / 12, Total_Years * 12, -Loan_Principal_Amount )

Example: For a ₹50,00,000 loan at 8.5% interest for 20 years:

=PMT( 8.5% / 12, 20 * 12, -5000000 )

The formula returns ₹43,391.14 per month. The negative sign on the principal represents a cash outflow.

Frequently Asked Questions


How is Home Loan EMI calculated in India?

Home loan EMI is calculated using the standard reducing balance mathematical formula: EMI = [P × r × (1 + r)^n] ÷ [(1 + r)^n - 1]. In this formula, P is the principal home loan amount, r is the monthly interest rate (annual interest rate divided by 12 and then divided by 100), and n is the total repayment duration in months (loan tenure in years multiplied by 12). Under this reducing-balance method, each monthly EMI payment is split into an interest charge computed on the remaining principal and a principal repayment component that reduces the loan balance.

What is the 30-40% FOIR rule for Home Loan eligibility?

FOIR stands for Fixed Obligation to Income Ratio. Indian banks and Housing Finance Companies (HFCs) like SBI, HDFC, ICICI, and Axis Bank use FOIR to assess your maximum loan eligibility. Financial prudence and bank underwriting norms mandate that your total monthly debt payments (including your proposed home loan EMI and any existing car/personal loan EMIs) should never exceed 40% to 50% of your net monthly take-home salary. This ensures you retain adequate monthly cash flow for household expenses, emergencies, and long-term investments.

Why is up to 75% of initial Home Loan EMIs composed of interest?

Because interest is computed on the outstanding principal balance, which is at its absolute peak on day one of your loan. During the first 5 to 7 years of a 20-year or 30-year home loan, between 65% and 75% of every monthly EMI installment goes strictly towards servicing interest, while only a small fraction pays down the principal balance. As you gradually amortize the principal balance over the years, the monthly interest portion drops and the principal repayment portion accelerates rapidly.

Are there any prepayment or foreclosure penalties on floating rate Home Loans in India?

No. Under Reserve Bank of India (RBI) circulars and National Housing Bank (NHB) regulations, banks and Housing Finance Companies are strictly prohibited from charging any prepayment penalty or foreclosure fees on floating rate home loans sanctioned to individual borrowers, regardless of whether the prepayment is partial or full.

How does the '1 Extra EMI Per Year' prepayment strategy reduce Home Loan tenure?

100% of any prepayment goes directly towards reducing your outstanding principal balance. By paying just 1 additional EMI every calendar year (such as during annual appraisal or Diwali bonus payouts), you eliminate substantial future interest compounding on that principal. On a typical ₹50 Lakh home loan at 8.5% interest for 20 years, making 1 extra EMI each year slashes your repayment tenure by approximately 4.5 years and saves over ₹12.5 Lakhs in total interest outflow.

What are the tax deductions available on Home Loan EMI under Indian tax laws?

Under the Old Tax Regime: (1) Section 24(b) permits an annual deduction of up to ₹2,00,000 on the interest portion repaid for a self-occupied residential property. (2) Section 80C allows a deduction of up to ₹1,50,000 per financial year on the principal repayment portion (subject to the aggregate ₹1.5 Lakh 80C limit). (3) For joint home loans where co-borrowers are also co-owners, both husband and wife can claim up to ₹2 Lakh each under Section 24(b) and ₹1.5 Lakh each under Section 80C, unlocking a combined tax deduction of up to ₹7,00,000 annually.

What is the difference between Pre-EMI and Full EMI for under-construction properties?

When you buy an under-construction home, the bank disburses the loan in tranches linked to construction milestones. 'Pre-EMI' is the simple interest charged on the actual amount disbursed by the bank up to that date; it does not reduce your loan principal. 'Full EMI' begins either upon full disbursement/possession or when the borrower opts for tranche-based full EMI, where payments cover both interest and principal amortization from day one.

What is a Home Loan Overdraft scheme (e.g., SBI Maxgain or BoB Home Loan Advantage)?

A Home Loan Overdraft (such as SBI Maxgain or Bank of Baroda Home Loan Advantage) connects your home loan to a specialized current/savings account. Any surplus funds, emergency savings, or salary deposited into this linked account are subtracted from your outstanding home loan principal for daily interest calculation. You earn effective tax-free savings equal to your home loan interest rate while retaining the complete flexibility to withdraw your parked surplus whenever needed.