Calculate your Home Loan EMI & Total Interest Due
Monthly amount paid to your Home Loan provider
Your debt repayment schedule in regular instalments over a period of time.
|Year||Principal Paid(A)||Interest Paid(B)||Total Payment (A+B)||Outstanding Loan Balance||Pre-payment|
BankBazaar’s Home Loan EMI Calculator follows a step-by-step process to find out your EMI. Here’s how you can use it:
The table below gives you a breakdown of loan repayment for a loan amount of Rs 30 Lakh, tenure of 15 years, interest rate of 8.6% and a total processing fee of Rs 10,500 (at 0.35%):
|2019||₹ 58,779||₹ 1,49,248||₹ 29,41,220|
|2020||₹ 1,07,861||₹ 2,48,760||₹ 28,33,360|
|2021||₹ 1,17,511||₹ 2,39,109||₹ 27,15,849|
|2022||₹ 1,28,025||₹ 2,28,597||₹ 25,87,824|
|2023||₹ 1,39,478||₹ 2,17,138||₹ 24,48,344|
|2024||₹ 1,51,960||₹ 2,04,660||₹ 22,96,385|
|2025||₹ 1,65,556||₹ 1,91,064||₹ 21,30,830|
|2026||₹ 1,80,368||₹ 1,76,251||₹ 19,50,463|
|2027||₹ 1,96,505||₹ 1,60,113||₹ 17,53,957|
|2028||₹ 2,14,088||₹ 1,42,533||₹ 15,39,870|
|2029||₹ 2,33,242||₹ 1,23,378||₹ 13,06,627|
|2030||₹ 2,54,110||₹ 1,02,506||₹ 10,52,516|
|2031||₹ 2,76,845||₹ 79,772||₹ 7,75,670|
|2032||₹ 3,01,617||₹ 55,004||₹ 4,74,053|
|2033||₹ 3,28,604||₹ 28,016||₹ 1,45,450|
|2034||₹ 1,45,449||₹ 3,141||₹ 0|
|Loan Amount||Rs. 30,00,000|
|Total Interest Due||Rs. 23,49,294|
|Processing Fee||Rs. 10,500|
|Total Amount Payable||Rs. 53,59,794|
In the above example, if you make a prepayment of Rs. 5,00,000 after paying 60 instalments:
You will Save an amount of Rs. 5,40,429 in interest Loan tenure will be reduced by 35 months
Interest: Rs. 23,49,294 EMI tenure: 15 years
Interest: Rs. 18,08,865 EMI tenure: 12 years 1 month
Outstanding Principal: Rs. 23,86,607 EMI: Rs. 29,718
You should get your results in a few seconds. This will show you how much you’re expected to repay every month. In addition to this, the results will also show you how much interest you will pay over the period of your loan. You will also get a loan repayment table clearly indicating how much interest and principal you will pay back each month.
This table is designed to show you every detail of your loan repayment schedule. It shows you the following components:
If you plan on prepaying any part of your loan, the prepayment analysis will also show you how much you owe over your chosen tenure, with and without the prepayment. This way you get to see how you can benefit from making advance payments.
Formula for Home Loan EMI Calculation:
E: Equated Monthly Installment,
P: Principal or loan amount,
r: Interest rate per month (the annual interest rate is divided by 12 to get the monthly interest rate), and
n: Number of monthly instalments or loan tenure in months.
*This formula doesn’t include the home loan processing fee charged by the bank.
Mr. Patra borrowed a home loan amount of Rs.3,500,000 (Principal amount or P) from a reputed bank. The rate of interest (R) associated with the loan stands at 8.65% p.a. The tenure of the loan (N) is 360 months for 30 years.
After you apply the formula to calculate your home loan EMI, the monthly instalment amount comes up to Rs.27,285.
P = 3,500,000
R = 8.65%
N = 30 years or 360 Months
Interest Rate Applied = 8.65%
Monthly EMI = Rs 27,285
EMI Paid For the Year = Rs 27,285 * 12= Rs 327,419
Calculation of home loan EMI is a simple method using an excel spreadsheet. In order to do so, three variable of a housing loan is utilised, namely, rate of interest, period, and loan amount. It must be noted that the rate of interest should be calculated on a monthly basis.
For example, if the rate of interest is 12%, it should be calculated as 12%/12 = 1%. The period represents the total number of EMI payable.
In order to calculate EMI, click on the “=” symbol, type ‘PMT(the rate of interest, period, loan amount)’, and click enter. The excel sheet will the produce an amount in a negative value. This indicates the cash flow that the borrower will have to incur. This is the EMI that a home loan borrower would have to pay.
For example if your loan amount is Rs.5 lakh for 2 years at 12% p.a., the formula to calculate EMI is as follows.
=PMT(12%/12, 24, 500000)
There are many advantages of using the EMI calculation tool provided by BankBazaar. They are listed below:
When calculating your EMI, the calculator includes all the parameters that impact it. Let’s take a look at the various factors that impact your monthly repayments:
Your housing loan EMI is usually a fixed amount. But there are certain circumstances under which it can change. Let’s take a look at some of these instances:
Flexible EMIs: If you have opted for flexible EMIs such as in the case of step-up or step-down property loans, then there will be a change in your loan EMIs. In the case of step-up loans, your EMI will gradually increase over the tenure. In the case of step-down loans, your EMIs will decrease as time passes.
Partly Disbursed Loan: In the case of partly disbursed loans, the pre-EMIs will increase with each disbursement.
Loan Prepayment: Prepayments impact your EMIs as well. You can either choose to reduce the EMI for the same loan tenure or reduce the loan tenure and keep the EMIs constant. The latter is more beneficial since you will pay lesser interest.
Rise in the floating interest rate: Whenever the repo rate changes, the floating rate of interest also changes. If the floating rate increases, the lender will normally increase the loan tenure while keeping your EMI the same. If the new tenure exceeds the maximum period permitted, then the bank may increase your EMI.
Usually, people follow their EMI payment schedule. But if you have extra money, you can use it to pay off parts of your loan before they are due. This is known as prepayment.
When you prepay a portion of your loan, the amount goes towards reducing the outstanding principal. This benefits you because as your outstanding principal reduces, your interest charges will also reduce. Also, you will be able to repay the loan a lot faster.
In some cases, the lender will disburse the loan amount in stages. When this happens, you have to start paying your EMI only when you get the final amount and the whole loan has been disbursed. Till this date, you have to pay only the interest applicable on the partly disbursed amounts. This is known as pre-EMI.
Once the loan gets fully disbursed, the pre-EMIs will stop and you have to start paying your regular EMIs.
For Example, if you are borrowing a loan of Rs.40 lakh at an interest rate of 10.5% for a period of 20 years for a property under construction. The bank will usually disburse the loan amount in the following manner:
|Amount Disbursed||Rs.10 lakh||Rs.10 lakh||Rs.10 lakh||Rs.10 lakh|
|Stage||On agreement||On completion of the initial phase||On completion of the next phase||On completion of the final phase and possession|
As per the table, you will be paying a pre-EMI of Rs.2,36,250 i.e., (26250 x 3) + (17500 x 3) + (8750 x 6) as interest for the amount disbursed by the bank. You will have to begin paying your EMI of Rs.39,935 for the next 20 years after the final loan amount has been disbursed.
However, a wiser option would be to opt for a full EMI payment as it ensures that you have already paid down a portion of the remaining loan amount at the time of possession.
Taking a loan to buy a house can be expensive, but it also has certain benefits, especially when it comes to taxes. The government offers tax reliefs via the Income Tax Act, 1961 on the EMIs you pay every year. These are as follows:
No, you don’t have to sign up or pay any fee to use the EMI calculator. It is completely free of charge and can be accessed by all.
Yes, this calculator is available on the BankBazaar mobile app. Open the menu on the left top corner of the app. Scroll down till you see “Finance Tools”. You will find the EMI calculator in this section.
An EMI calculator gives results based on the inputs you give it. That being said, the results may sometimes vary with what your lender gives you. This is because the lender may also factor in other costs and charges.
When you take a loan, it needs to be repaid in a certain manner. How you repay the loan is called amortisation. BankBazaar’s EMI calculator gives you the amortisation schedule of your loan as soon as you calculate your EMI.
The repayments on your loan are calculated on the basis of the principle of reducing balance. The interest rate is applied based on the amount of principal outstanding. Initially, the principal is high. So, the interest amount is also high. As your principal amount reduces, the interest charges also reduce proportionately.
Yes, there are a number of ways in which you can ease the pressure your home loan puts on you.
The interest loans offered by banks in India change from time to time. Visit our home loan page to know more about the best rates available right now.
Yes, you can. But this depends on the nature of your relationship with the joint applicant. Banks usually don’t offer such loans if you’re applying along with a friend or a non-blood relative.
Display of any trademarks, tradenames, logos and other subject matters of intellectual property belong to their respective intellectual property owners. Display of such IP along with the related product information does not imply BankBazaar’s partnership with the owner of the Intellectual Property or issuer/manufacturer of such products.
Reserve Bank of India (RBI) today cut the repo rates by further 0.25%. The repo rate stands at 5.15% as compared to 5.40% previously.
Despite the RBI cutting rates, the lending rates still looks to be on the higher side. Hence, RBI directed the lenders to lend their loan products at interest rate linked to the RBI repo rate from October 1. This means that if a customer is looking to avail a home loan then he/she will be offered one at repo linked lending rate (RLLR).
Interestingly the post office small savings interest rate for the October – December quarter or the 3rd quarter of the financial year 2019-20 was kept unchanged by RBI. Recently, the interest rate on EPF was set at 8.65% and approved by the Ministry of Labour.
8th Oct 2019
Home loan is a great borrowing option for individuals who want to buy a home without exhausting their capital. Several banks and NBFCs offer home loans to the eligible borrowers at a low-interest rate. However, many times the applicants face rejection while applying for a home loan. The lenders check various factors like income, age, credit score, repayment capacity etc. of the applicant before approving a loan request. However, there are certain ways to increase the approval chances. Paying higher down payment, applying with a co-borrower having a good credit history, and choosing a longer loan tenure are some tips to reduce rejection. Moreover, by reducing one's FOIR to 40% to 50% and building a robust credit score can also help to improve the chances of a home loan application approval. One should also avoid applying for multiple home loans within a short period of time to increase his/her creditworthiness.
14 January 2019