When it comes to any loan, it is very important to understand what will be your EMI (Equated Monthly Installment), how long you will have to pay the EMIs and what is the interest rate at which you pay interest on your principal amount.
In this article, we will see how you can calculate Home Loan EMI, based on the loan interest rate and tenure. You can also download the Home Loan EMI calculator using the download link mentioned at the bottom of this article.
WATCH this Home Loan EMI Calculator Video:
WATCH: All Excel Calculators Videos
Most of us have a dream to own our own house. But at the same time, it is important to understand few things about the home loan that we opt for while buying a new house.
What is Home Loan EMI?
- EMI stands for Equated Monthly Installment
- It includes repayment of the principal amount and payment of the interest on the outstanding amount of your home loan
- A longer loan tenure helps in reducing the EMI, but increases the interest amount you pay on your home loan
- Opt for higher home loan EMI to reduce your interest amount and tenure
- Basically, maximum EMI allowed will be 50% of your monthly income
Things to Know about Home Loan EMI:
- There are 2 parts of your EMI: Principal amount & Interest Amount
- Interest Amount is high initially during your Home Loan tenure
- Principal amount is less initially during your Home Loan tenure
- High interest amount is already taken at the initial home loan period from your EMIs
- You should pre pay most of your principal amount if you want to decrease maximum interest amount in your Home Loan
- You can easily calculate your Home loan EMI using excel calculator as we can see in above video
- Pre pay your home loan principal amount initially as much as you can to decrease interest amount that you have to pay throughout your loan tenure
- Increase in home loan tenure will increase the interest amount you'll pay throughout your home loan tenure
Importance of Loan Interest Rate:
- It is very important to know the interest rate of loan
- Compare the interest rates from various banks and financial institutions before applying for loan
- Know the difference between fixed and floating interest rates
- Go for floating interest rates to get benefits of interest rates decrease
- You interest amount in every EMI depends on this Interest rate
- More interest rate, more interest amount that you pay on your loan. Less interest rate, less interest amount you pay.
You may also like: [VIDEO] PPF Excel Calculator | Public Provident Fund Calculator | PPF Interest Calculation
How Home Loan Calculator helps you?
- Using an excel home loan calculator can help you know your monthly EMI
- You can provide the home loan tenure and loan interest rate in order to know how much interest you'll pay
- You can also check the decrease in principal amount if you pre pay some of the principal amount
- Home Loan calculator will help you plan your other goals according to your monthly EMIs and pre payments
Watch How to Calculate New Income Tax FY 2021-22:
How to decrease Home Loan Interest?
- You can easily decrease the home loan interest amount by pre paying your principal amount
- Home Loan interest amount is calculated based on your outstanding principal amount remaining
- So in order to decrease the interest that you'll pay, you need to decrease your outstanding principal amount
- The sooner you decrease your outstanding principal amount at the initial stages of loan tenure, more interest you'll be saving
You can watch this below video to see how Home Loan Prepayments will help save Home Loan interest using Excel Examples. With Home Loan Prepayment of Rs. 1 Lac, you can save up to Rs. 68,442 in your entire Home Loan Tenure. Watch this video to see the calculation in excel.
Home Loan Prepayment Calculation Video:
Home Loan Calculator Example
Loan Amount: Rs. 30,00,000
Interest rate: 6.95%
Tenure: 8 Years (96 Months)
Home Loan EMI Calculator - Principal Low & Interest High - First Month |
As can be seen from above screenshot, you pay total of Rs. 39,19,348.31 during your entire Home Loan tenure.
Principal Amount = Rs. 30,00,000
Interest Amount = Rs. 9,19,348.31
Also, we can see that the interest amount is high initially, and it decreases with time. The highest (Rs. 17,375) in the first month
Whereas, principal amount is less initially, and it increases with time. The lowest (Rs. 23,451.54) in the first month.
Here is another screenshot after the end of Loan Tenure. As can be seen, principal amount is highest and interest amount is the lowest in the last month.
Home Loan EMI Calculator - Principal High & Interest Low - Last Month |
Save 30 Lakhs of Home Loan Interest on 40 Lakhs of your Home Loan, HOW? WATCH THIS
Tax Savings using Home Loan:
- You can also Save income tax if you are paying home loan EMIs
- The principal amount you pay can be claimed under Section 80C (Maximum Rs. 1,50,000) to save your Income Tax
- The interest amount you pay can be claimed under Section 24 (Maximum Rs. 2,00,000) to save your Income Tax
Other Tax Savings investments include Public Provident Fund, National Savings Certificate, Employee Provident Fund and many other that helps you Save your Income Tax.
Watch This Video to know How to Save Income Tax:
WATCH: All Excel Calculators Videos
You can also Download my Android App - FinCalC to calculate your Income Tax and decide whether to choose Old or New Slab Rates while calculating Income Tax.
Screenshots from FinCalC App - Income Tax Calculator Android App |
Link to Download App - CLICK HERE
You can use below link to download Home Loan EMI Calculator using Excel.
Some more videos to Watch:
Frequently Asked Questions (FAQs)
Q. What does an EMI mean?
Ans. EMI refers to the ‘Equated Monthly Installment’ which is the amount you will pay on a specific date each month till the loan is repaid in full. The EMI comprises of the principal and interest components which are structured in a way that in the initial years of your loan, the interest component is much larger than the principal component, while towards the latter half of the loan, the principal component is much larger.
Q. What is a Home loan and how does it work?
Ans. Home loans are availed either for purchase of an under-construction or a ready property from a developer, purchase of a resale property, to construct a housing unit on a plot of land, to make improvements and extensions to an already existing house and to transfer your existing home loan.
Q. When can I make a home loan application?
Ans. You can apply for a Home Loan whilst you are working abroad, to plan for your return to India in the future. You can apply at any time once you have decided to purchase or construct a property, even if you have not selected the property or the construction has not commenced.
Q. When does my home loan EMIs start?
Ans. EMI's begins from the month subsequent to the month in which disbursement of the loan is done. For loans for under-construction properties EMI usually begins after the complete home loan is disbursed but customers can choose to begin their emi’s as soon as they avail their fist disbursement and their emi’s will increase proportionately with every subsequent disbursement. For resale cases, since the whole loan amount is disbursed in one go, emi on the whole loan amount start from the subsequent to the month of disbursement
Q. How does your home loan repayment work?
Ans. A home loan is usually repaid through Equated Monthly Instalments (EMI).The EMI comprises of the principal and interest components which are structured in a way that in the initial years of your loan, the interest component is much larger than the principal component, while towards the latter half of the loan, the principal component is much larger.
I'd love to hear from you if you have any queries about Personal Finance and Money Management.
Download our Free Android App - FinCalC to Calculate Income Tax and Interest money on Savings Account.
Follow the Blog and Subscribe to YouTube Channel to stay updated about Personal Finance and Money Management topics.
___
26 Comments
Did not find any excel
ReplyDeleteExcel link is at the bottom of article
DeleteNot seeing
Deletehttps://drive.google.com/file/d/1OvK_p-3PpMqrsvJp79WOtRRKUjsCDhzH/view?usp=sharing
Deletenot found any Excel link at the bottom of article
ReplyDeletecould u pls send it over email - bhagat25yoesh@gmail.com
https://drive.google.com/file/d/1OvK_p-3PpMqrsvJp79WOtRRKUjsCDhzH/view?usp=sharing
DeleteExcel to lock he?
ReplyDeletedownload karke changes karo
DeleteWhere is exel link?
ReplyDeleteChutya banata hay no excel
Deletehttps://drive.google.com/file/d/1OvK_p-3PpMqrsvJp79WOtRRKUjsCDhzH/view?usp=sharing
DeleteThe information your share is very useful to me and many people are looking for them just like me! Thanks for your sharing! and I find it very helpful
ReplyDeleteEcwon
Live Casino Games The Real Treasure Of Thrills
With ecwon enjoy live online casino
Play ECWON Online Betting Malaysia
Why betting casino games are entertaining?
How to win the betting games in a casino?
Thanks for your personal marvelous posting ! I truly enjoyed
ReplyDeleteWhy select ECWONSG Singapore Online Casino for playing?
Ecwonsg2 the Best Option to Visit & Play Online Gambling Games
ECWON Design User-Friendly Online Gambling Games
How Earn Money from Live Casino Games
Live games and online betting at Ecwonsg casino
Latest Updates in casino sites
Ecwonsg2
Hi everyone, I saw comments from people who had already got their loan from Anderson Loan Finance. Honestly, I thought it was a scam, and then I decided to make a request based on their recommendations. A few days ago, I confirmed in my personal bank account amounting to $15,000 dollars which I applied for. This is really a good news and I am so very happy that I advise all those who need a real loan and who are sure to reimburse to apply through their email (text or call) +1 719 629 0982. There are sincere loan lenders! They are capable to lend you a loan. Contact Mr Anderson E-mail: andersonraymondloanfinance@gmail.com
ReplyDeletePhone: +1 719 629 0982
E-mail: andersonraymondloanfinance@gmail.com
Office address is (68 Fremont Ave Penrose CO, 812400).
not found any Excel link at the bottom of article
ReplyDeletecould u pls send it over email -ravindras278@gmail.com
Excel link
ReplyDeletehttps://drive.google.com/file/d/1OvK_p-3PpMqrsvJp79WOtRRKUjsCDhzH/view?usp=sharing
Not found link
ReplyDeletehttps://drive.google.com/file/d/1OvK_p-3PpMqrsvJp79WOtRRKUjsCDhzH/view?usp=sharing
DeleteHi everyone, I am Adorjan Adelmo from Yasinya village Ukraine and I just want to say a very resounding thanks to Pedro Financial loan services for their sincerity, Openness, Transparency, Truthfulness, Love and support during and after getting loan funds from them. I have been through a lot in the hands of in life and time won’t permit me to say all that I went through in the year of pandemic but God answered my prayers through the support and love from pedro Financial loan services who embraced me and understood me despite my initial doubt and unseriousness and with his good heart and love I am now a home owner through his 3% interest rate loan funds and I have vow to spread this news and also tell the world that there are still genuine and few good online loan firms out there that can assist and also revive a dry bone like I was.
ReplyDeleteDon’t fail to listen and read this testimony because this is a true life changing experience and anyone that needs this kind of turn around should not hesitate or doubt this because I have proven and I swear to God in Heaven that this story is real and also the story of my experience with them .
Contact them today for Consolidated loan, business loan, home loan, car loan, personal loan.
Email: pedroloanss@gmail.com
Please update cell H1, it does not have formula.
ReplyDeletei cannot do chages in it
ReplyDeleteI have perused your article, As a financial management company of high reputation, Capital Fund International has provided fund.
ReplyDeleteHi everyone, My name is Jennifer from New Jersey , I saw comments from people who had already got their loan from Anderson Loan Finance. Honestly, I thought it was a scam, and then I decided to make a request based on their recommendations. A few days ago, I confirmed in my personal bank account amounting to $15,000.00 dollars which I applied for. This is really a good news and I am so very happy that I advise all those who need a real loan and who are verry sure to reimburse to apply through their email (text or call) +1 719 629 0982. There are sincere loan lenders! They are capable to lend you a loan. Contact Mr Anderson E-mail: andersonraymondloanfinance@gmail.com
ReplyDeletePhone: +1 719 629 0982
E-mail: andersonraymondloanfinance@gmail.com
Office address is (68 Fremont Ave Penrose CO, 812400)....
Thanks
ReplyDeleteAstral city
Great !!!
ReplyDeletecan ho pho dong quan 2
A real estate agent that can assist me with the sale of my home was something I was looking for. Then I discovered Casanova Brooks, who is one of the finest real estate agents in the area, and he assisted me in selling my home quickly and for the best possible price. If you are interested in selling or purchasing a piece of real estate, you can also get in touch with him. It comes highly recommended!
ReplyDelete