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|
The BankBazaar home loan EMI calculator is not only simple and easy to use but also free. You don’t have to sign up to use the tool. You can just visit the site and start using the home loan calculator. All you have to do is enter 3 main components to calculate your home loan EMIs:
You are also given the option to include home loan prepayment in the EMI calculation. You can opt for monthly and yearly amortisation schedules. The amortisation table presents you with details such as outstanding balances after each EMI payment, interest payment, and principal repayment. The details will be presented in the form of tables and charts to make it easier for anyone to understand. The home loan calculator is also available on the BankBazaar mobile app.
Home loan amortisation schedule presents you with the following details:
With the amortisation table, you get to know exactly when your loan repayment comes to an end.
Formula for home loan EMI calculation:Equated Monthly Installment (EMI) = P x r x (1+r)^n/((1+r)^n -1)
EMI : 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 installments 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
|Home Loan Tenure||Opening Balance||Principal The Paid For the Year||Interest Paid For the Year||Closing Balance|
While computing the Home loan EMI, taking inflationary and deflationary scenarios of floating interest rate into account, you will be better prepared to meet the outcome. Depending on the EMI, you can opt for prepayment of your home loan.
Paying EMIs every month can be hard on your bank account. You have to prepare a monthly budget to save money after paying your bills, EMIs, and meeting any unexpected financial requirements. Fortunately, the government of India offers tax benefits to Indian nationals on home loan repayments to incentivise home loans. The following are the various tax benefits you can get with regards to home loan repayments:
Tax deduction is applicable only if the home loan is used to purchase or construct a home. You can claim tax benefits only when the construction is completed or you have taken possession of the home. There is no tax benefit for property under construction. Tax deduction is not applicable to a home loan taken for repair, reconstruction or renovation.
If you have a lump sum amount of money, you can use it to make part payment on your home loan. Part payment made towards principal repayment can bring down your EMI or reduce your loan tenure. Lower EMI means that you can save on interest payments. For part payments to make that much of an impact on your EMI, the part payment has to be significantly large. You make more than one part payment. However, not all banks allow part payments.
Home loan EMI is fixed but there are certain circumstances under which it can change such as:
When deciding on a housing loan, you must consider whether you want to opt for a floating rate or fixed rate loan. The loan amount and loan tenure can be determined by you, the borrower, but the rate of interest on your home loan is determined by the bank based on the RBI's policies and rules.
Therefore, it is advisable to use home loan calculator and while doing so, one must keep two scenarios in mind. The rate of interest can either increase or decrease during the loan tenure. Accordingly, your home loan EMI will also change. Borrowing a home loan is a long-term commitment that can span years. In the case of a floating rate loan, when there is a decrease in home loan interest rate, you will benefit. In the case of a fixed rate loan, as the rate of interest is fixed throughout the loan tenure, even if the home loan rates are slashed you will not benefit from it. When you take the effort to determine how much EMI you will have to pay under these 2 circumstances prior to borrowing a home loan, you have the opportunity to change your loan amount and loan tenure to make the EMI more affordable to you.
Using an excel spreadsheet to calculate your home loan EMI is a simple method. 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 cashflow 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)
In order to calculate your home loan EMI using the mathematical formula, you would require to know the loan amount, the rate of interest per month, and the total number of EMIs payable. The formula to calculate EMI is as follows.
EMI = [P x R x (1+R)^N]/[(1+R)^N-1], where P = the principal amount, r = the rate of interest per month, N = total number of monthly instalments.
Thanks to technology integrated in finance, it is easy to calculate the EMI on a particular loan. Simply visit a site that allows you to use a EMI calculator, enter the basic details of your loan. The site will then mention the total EMI you have to pay towards the loan. Some calculators will also break down the principal and interest aspect of the EMI.
Now that you understand how to calculate EMI, ensure that you understand the financial outflow you need to endure in order to pay off the loan. If the EMI is going to be a burden to you, reconsider your loan option.
For partly disbursed home loans, you can make pre-EMI payments, wherein you are only paying interest payments until the full loan amount is disbursed.
Regular EMI consists of both the interest payment and principal repayment. Regular EMI commences only after the full loan amount is disbursed.
The following are the benefits of paying pre-EMI:
No. This home loan repayment calculator is 100% free to use and no specified conditions exist to qualify for its usage. As a visitor to BankBazaar.com, you can access the page directly and compute your housing loan EMIs.
You should be able to get this information from the loan related documents issued by your bank. Alternatively, you can search for this detail on the bank's official website, or by personally contacting the bank's customer support department.
Immediately below the EMI calculation, you can see details of your housing loan EMI breakup, Your Amortization Details (Yearly/Monthly), a graphical representation of the amortization details associated with your house loan.
Well, it makes sense to do so even though our calculator is accurate. There may be slight changes, owing to the way your bank calculates the EMI. Also, your installment may include other monetary components which you were probably not aware of, while using the tool. Therefore, make sure to cross check before making critical decisions.
Yes, you can use find this calculator available on our apps.
Tap the left hand top navigation – Finance Tools >> Locate the EMI Calculator. Bankbazaar mobile apps are available on both Android and iOS platforms.
Home loan processing fee is a fee payable to the bank or lender that provides you with a home loan. This fee is typically a percentage of the total loan amount, or a fixed amount, depending on the lender. It is collected during the initial payment of the loan and is mostly used for administrative charges.
Home loan prepayment is a process wherein the home loan borrower pays over and above the expected repayment amount during a particular month. This yields several benefits like reducing the overall interest payable, reducing the tenure of the loan, etc.
Home loans are qualified for tax benefits under three different sections of the Income Tax Act. . An individual with a home loan can avail tax rebates and ease the tax burden he/she pays annually. Tax benefits can be availed on both the principal and interest amount of the home loan.
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.
HDFC has announced that their retail prime lending rate (RPLR) will be increased by 20 basis points. As of April 1st, the RPLR will go up to 16.35%. The rate of interest on home loans of up to Rs.30 lakh has been increased to 8.45% p.a. For home loans that range from Rs.30 lakh – Rs.75 lakh, the rate of interest will now be 8.60% p.a. All loans above Rs.75 lakh will attract a rate of 8.70% p.a. However, for female borrowers, the rate of interest is 5 basis points lower than that of male borrowers. For loans up to Rs.30 lakh, the rate of interest is now 8.40%, while loans that range from Rs.30 lakh – Rs.75 lakh will attract an interest rate of 8.55%. All loans above Rs.75 lakh for women borrowers will attract an interest rate of 8.65% p.a.
11 April 2018
There are various ways of reducing your home loan burden and one such way could be option for a home loan balance transfer. When you transfer the home loan from one bank to another for better terms and conditions, you can save a great deal in the long run. You intend to opt for a home loan balance transfer when you realize that a different lender can offer you better perks and lower rates of interest with your home loan. When you transfer the home loan, your previous lender’s debt is settled by your new lender and a new account is opened with the new lender. You will to repay the loan (outstanding) to the new lender at the new rate of interest. Some of the other ways to reduce home loan burden include using your annual bonus wisely and opting for a longer home loan tenure. When you get a bonus from your employer, use to make extra payments towards your monthly instalments. This is substantially bring down the amount that you need to repay, in turn making things easier for you in the long run. Also, you may choose for a longer tenure with your home loan. You will have to pay lesser amount every year if you choose a home loan tenure of 30 years instead of 20 years. However, you must understand that when you choose a longer tenure you pay lesser every month but in turn pay more interest over the whole loan tenure.
29 March 2018
Banks across India have begun to increase their interest rates hinting towards a change in the home loan rates. This is going to be a first in the last two years when rates are being revised. State Bank of India, the country's largest lender and ICICI Bank, a major banking corporation in the private sector have increased their lending rates by up to almost 20 bps. This move is being considered to be a move that will rise equated monthly instalments for car and home loans for its customers. The interest garnered on home loans is connected to the MCLR of the bank. With an increase in the MCLR, the home loan rates will mostly also rise. However, if the banks reduce the margin or the mark-up in the loans, the rates will continue to remain the same.
The deposit rates of Punjab National Bank and the SBI have been increased by almost 50 bps throughout various projects. According to a recent notification, SBI, that has more than a fifth of the country’s banking assets has increased the main one-year MCLR to 8.15% from 7.95%. This I the first increase in the one-year MCLR since this concept was launched for the new lending rate system last year.
9 March 2018
According to the report from the government, there are high chances of borrowers defaulting on home loan EMIs even as the government policies give huge thrust to affordable housing. Crif Highmark said in a report that in November 2017, 2.33% of the home loans under Rs.25 lakh were not repaid on time.
Home loans under Rs.10 lakh, 4% of the borrowers do not pay the EMIs on time. Since the government expects to meet its target of housing for all in 2020, a slew of sops were given to the affordable housing sector, which includes addition in the priority sector lending, introduction of tax benefits under section 80-IA, and concessions on long-term capital gains tax provisions.
The 90-day overdue for the affordable housing sector stood at 1.36% for March 2016 and has been rising since. New Delhi, Uttar Pradesh, and Tamil Nadu have the highest stress in the housing finance sector, while Kolkata, Chennai, and Ghaziabad have the highest stress in affordable housing segment.
5 March 2018
Property prices have been increasing presently and the bandwidth on the yearly deduction of tax on home loan interest is currently Rs.2 lakh. The finance ministry may however consider reducing the threshold from Rs.2 lakh to Rs.1.5 lakh.
Additionally, the fresh amendment of limiting the loss on house property up to Rs.2 lakh from all properties whether it is self-occupied or rented seems to be impractical considering high prices of the property and interest rates as well. This has also discouraged many salaried class people to invest in more than one property and seems to have impacted real estate investors significantly.
9th January 2018
State Bank of India (SBI) reduced its base rate and benchmark prime lending rates (BPLR) at the start of the year for its existing patrons. The base rate was cut by 30 basis points and these changes are effective from January 1.
In addition to this, the bank also issued a statement saying that it would extend its current waiver on processing fee for home loan till Saturday, March 31. This benefit can be enjoyed by new customers and also by those who are switching their loans to SBI from other banks.
The revised base rate now stands at 8.65 percent while the BPLR is 13.40 percent.
This move is set to benefit more than 8 million customers and other banks are expected to follow the suit.
2nd January 2018
Home loan growth recently witnessed one of the largest falls in the last five years, as per the data revealed by the Centre for Monitoring Indian Economy. Between April-October 2017, home loan expansion fell by 32.7 percent in comparison to 2016.
In the same term last year, home loan growth was falling by 4.27 percent.
Even though the interest rates have been cut down, buyers are not paying any heed to the appeal owing to a slow execution of the recently launched Real Estate (Regulatory and Authority) Act across the country. Moreover, the dilemma over how the Goods & Service Tax (GST) will affect the housing prices has also contributed to the recent slump in the housing industry.
The first few months of the year were also reeling from the effect of demonetisation, which led to a drop in supply and demand in the overall market.
28th December 2017
In a recent interview, R Varadarajan, the MD of Repco Home Finance and Nidhesh Jain of Investec Capital Services, stated that in the affordable housing finance sector they are expecting huge demand as a number of private companies are coming forward. They are hopeful that by FY19 the affordable housing sector will see lots of improvements. According to Nidhesh Jain, Housing finance sector has shown consistent 20% growth without any issues related to quality of assets and the duo are quite hopeful about this sector. HDFC Ltd. tops their preference in this sector.
Talking about the bank interest rates, Repco MD said that the bank funds are available at cheaper rate now than before. He further added that the yields of bonds have increased by 53 basis points and became 7.19% in Q3FY18. As per his anticipation, the cost of funds for NBFCs (Non-banking financial companies) might get affected by the hardening of bond yields. The duo also said that their cost of fund has decreased recently as most of the banks in India has slashed their MCLR.
15th December 2017
With the country’s apex bank deciding to keep the policy rates unchanged, the Equated Monthly Installments (EMIs) on home loans and cars loans are unlikely to come down in the near future. In the wake of the decision, officials from banks like Bank of Baroda, State Bank of India and others have come forward with statements stating that there won’t be any change in the existing rates. The Managing Director, Global Markets, State Bank of India stated that while the lending rates can still go down considering banks lower their deposit rates but to expect deduction in marginal cost-based lending rates (MCLR) is limited.
13th December 2017
Housing and auto loans have seen an increase in defaults over the period of two years. In other words, borrowers have failed to pay off the loan on a timely basis. Two-wheeler and gold loans have however seen a reduction in defaults.
Defaults in the PSU banks have shown an increment, which can be linked to the higher percentage of home, loans within this sector. For other non-banking financial institutions and private banks, defaults showed a downward trend even though these organizations showed a higher disbursement rate in the last few years. The retail lending of these banks also grew from around 14% to 19% since 2014.
29th November 2017