Last Updated on September 27, 2023 at 3:53 pm
Use this calculator to check the benefits (if any) associated with switching your home loan. Either from one bank to another or from base rate to MCLR (Marginal Cost of Funds based Lending Rate). This is an updated version of the Home Loan Transfer Calculator (Mortgage Refinance) with an ability to check benefits for (a) same EMI, lower tenure and (b) reduced EMI, same tenure.
With the slashing of the one-year MCLR rate, home loans have got attractive by at least 1%. So it is now time to check if it is beneficial to transfer the loan to a rate. This is not exactly intuitive. The cost and fees have to be accounted for, along with the decrease in tax saving.
There are two ways to analyse a home loan transfer.
- If the net savings per month is used to prepay the home loan, how much quicker will the amortisation be completed? Support this is about 2 years. Then the total cost involved in transferring the home loan to a lower rate has resulted in a pre-closure. Is it worth that, is a question that we need to answer?
- What is the net savings were invested elsewhere? Letting the new home loan run its course? The costs can be recouped in a few years, and at the home loan tenure, one will have a decent corpus from the investment.
Illustration:
Join 32,000+ readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! (Link takes you to our email sign-up form)
🔥Enjoy massive discounts on our robo-advisory tool & courses! 🔥
Consider a 15L outstanding balance on a loan with 20 years remaining and 9.7% (fixed rate). The EMI is 14,178.
If the new rate is 8.25% and total fees for transferring is Rs. 14,000 then
there are two options:
Reduce EMI and keep the term the same
The new EMI is 12,781. We save money each month on the interest component and the principal component. However, some extra tax has to be paid due to lower interest (principal component tax saving is ignored as it is likely to be covered by other 80C sources). Therefore, the sheet calculates the “net savings” for each year and how many years it takes for savings to turn positive (recoup costs). In this case, there is an immediate benefit.
If the extra savings are used to pre-pay the loan systematically, it can be closed 42 months earlier.
There are dual benefits in this case: savings + pre-closure.
Keep EMI the same and reduce tenure
Now the EMI is the same (14,178), but tenure has reduced by 50 months. The interest component is lower (so tax has increased) but principal component has to increase to keep EMI the same. Therefore the net savings is likely to be negative (none) throughout the tenure. That is not a problem if you wish to keep the house for much longer.
In this case, the only benefit is pre-closure.
Please play around with this sheet and share your insights. It will benefit everyone.
Here is a screenshot
Download the updated home loan transfer calculator
Thanks to Mr. Prasanna and Abhishek Singh for useful suggestions.
If you are changing both the tenure, and the emi, then you can use the calculator in this post: How I transferred my home loan from LICHFL to SBI and saved 12 Lakhs!
A detailed Excel Home Loan Amortization Schedule Template is also available which allows periodic and aperiodic pre-payments.
You Can Be Rich Too
My new book with PV Subramanyam, published by CNBC TV 18
The book comes with 9 online calculator modules to create your own financial plan.
It also has detailed selection guides for equity and debt mutual funds.
Amazon
Kindle
Read a Sample Chapter and Buy Now!
What Readers Say
- Simple and powerful This book empowers the reader with the concepts in easy to understand & simple form. Those who have been reading blogs of both authors would know that they are not only good with finance domain but also have a knack of simplifying the methods of investing for their readers. This book by them is a gem of financial knowledge for people who are starting to invest or want to get better at it. The presentation and the thought process with calculators is extremely powerful.The book should be read & calculators used simultaneously to understand the concepts well. The calculators when used with real inputs will show you where you are & where you need to reach for each of your goals. Don’t ignore these numbers.Learnings from Chapters 7 to 11 will help you avoid going off path & saving your money from financially hazardous products. With discipline & right approach suggested here you wouldn’t need a financial advisor to build wealth.
- This is perfect book on personal finance. Very nicely explained about taxation about debt mutual fund. Topics like early investing and asset allocation are very well explained. – Mahesh Deshmukh
- Highly Recommended For anyone who wishes to take control of his/her finance this book is a must read. Very simply put, even an amateur in finance will be able to understand and implement. The author genuinely attempts to inculcate the habit of investing among the people who have the ability to invest but refrain from doing it, either due to lack of time , interest or understanding!. The message from the book is ” Investment done without setting a goal/ objective is like leaving for a trip without knowing the destination, not everytime the end result will be promising. Hence, it’s important to invest in a planned & disciplined manner.” A read is highly recommended ????
- A must book for everyone who wants to take control of personal finance. Nice explanation of how a debt mutual fund works. Bonds trading and indexation benefits in high inflation years were something new I learnt. After reading this book you will be able to easily choose any funds, because you will know what that fund does or how that fund works
🔥Enjoy massive discounts on our courses, robo-advisory tool and exclusive investor circle! 🔥& join our community of 7000+ users!
Use our Robo-advisory Tool for a start-to-finish financial plan! ⇐ More than 2,500 investors and advisors use this!
Track your mutual funds and stock investments with this Google Sheet!
We also publish monthly equity mutual funds, debt and hybrid mutual funds, index funds and ETF screeners and momentum, low-volatility stock screeners.
- Do you have a comment about the above article? Reach out to us on Twitter: @freefincal or @pattufreefincal
- Have a question? Subscribe to our newsletter using the form below.
- Hit 'reply' to any email from us! We do not offer personalized investment advice. We can write a detailed article without mentioning your name if you have a generic question.
Join 32,000+ readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! (Link takes you to our email sign-up form)
About The Author
Dr M. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. He has over ten years of experience publishing news analysis, research and financial product development. Connect with him via Twitter(X), Linkedin, or YouTube. Pattabiraman has co-authored three print books: (1) You can be rich too with goal-based investing (CNBC TV18) for DIY investors. (2) Gamechanger for young earners. (3) Chinchu Gets a Superpower! for kids. He has also written seven other free e-books on various money management topics. He is a patron and co-founder of “Fee-only India,” an organisation promoting unbiased, commission-free investment advice.Our flagship course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! ⇐ More than 3,000 investors and advisors are part of our exclusive community! Get clarity on how to plan for your goals and achieve the necessary corpus no matter the market condition is!! Watch the first lecture for free! One-time payment! No recurring fees! Life-long access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
Our new course! Increase your income by getting people to pay for your skills! ⇐ More than 700 salaried employees, entrepreneurs and financial advisors are part of our exclusive community! Learn how to get people to pay for your skills! Whether you are a professional or small business owner who wants more clients via online visibility or a salaried person wanting a side income or passive income, we will show you how to achieve this by showcasing your skills and building a community that trusts and pays you! (watch 1st lecture for free). One-time payment! No recurring fees! Life-long access to videos!
Our new book for kids: “Chinchu Gets a Superpower!” is now available!
Must-read book even for adults! This is something that every parent should teach their kids right from their young age. The importance of money management and decision making based on their wants and needs. Very nicely written in simple terms. - Arun.Buy the book: Chinchu gets a superpower for your child!
How to profit from content writing: Our new ebook is for those interested in getting side income via content writing. It is available at a 50% discount for Rs. 500 only!
Do you want to check if the market is overvalued or undervalued? Use our market valuation tool (it will work with any index!), or get the Tactical Buy/Sell timing tool!
We publish monthly mutual fund screeners and momentum, low-volatility stock screeners.
About freefincal & its content policy. Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on mutual funds, stocks, investing, retirement and personal finance developments. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than three million readers a year (5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified with credible and knowledgeable sources before publication. Freefincal does not publish paid articles, promotions, PR, satire or opinions without data. All opinions will be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
- Twitter @freefincal
- Subscribe to our YouTube Videos
- Posts feed via Feedburner.
Our publications
You Can Be Rich Too with Goal-Based Investing
Published by CNBC TV18, this book is meant to help you ask the right questions and seek the correct answers, and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now.Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want
This book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at a low cost! Get it or gift it to a young earner.Your Ultimate Guide to Travel
This is an in-depth dive into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, and how travelling slowly is better financially and psychologically, with links to the web pages and hand-holding at every step. Get the pdf for Rs 300 (instant download)