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:
🔥Secure your future with our Robo-advisory tool trusted by over 3,500 investors and advisors. From effortless retirement planning to funding your children’s biggest dreams, turn your financial goals into reality. 🔥
Subscribe for money management solutions via email! (Link takes you to our email sign-up form) Join 32,000+ readers in our community.
👉 New Tool Alert! NaviPlan: A Privacy-Focused Multi-asset Tracker and Goal Planner 👈
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
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)
Use our Robo-advisory Tool to create a complete financial plan! More than 3,000 investors and advisors use this! Use the discount code robo25 for 20% off. Plan your retirement (early, normal, before, and after), plus non-recurring financial goals (such as child education) and recurring financial goals (such as holidays and appliance purchases). The tool helps anyone aged 18 to 80 plan for retirement, plus six non-recurring and four recurring financial goals, with a detailed cash flow summary.
🔥Join our community of 9000+ users! 🔥Avail massive discounts on our courses + freefincal investor circle!
Track your mutual funds and stock investments with our Google Sheet!
We also publish monthly equity mutual funds, debt and hybrid mutual funds, index funds, ETF screeners, as well as momentum and low-volatility stock screeners.
You can follow our articles on Google News
We have over 1,000 videos on YouTube!
Podcast: Let's Get RICH With PATTU! Every single Indian CAN grow their wealth!
You can watch podcast episodes on the OfSpin Media Friends YouTube Channel
- 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 personalised investment advice. We can write a detailed article without mentioning your name if you have a generic question.
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 14 years of experience publishing news analysis, research and financial product development.
Connect with him via Twitter(X) LinkedIn YouTube
Our flagship course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! More than 3,500 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 conditions! Watch the first lecture for free! One-time payment! No recurring fees! Lifelong access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
Increase your income by getting people to pay for your skills! More than 900 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 seeking more clients through online visibility, or a salaried individual looking for side or passive income, we will show you how to do it by showcasing your skills and building a community that trusts and pays you. (Watch the 1st lecture for free). One-time payment! No recurring fees! Lifelong access to videos!
Our 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 a side income via content writing. It is available at a 50% discount for Rs. 500 only!
We publish monthly mutual fund screeners and momentum, low-volatility stock screeners.
About freefincal & its content policy
Freefincal is a News Media organisation 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: To get in touch, please use our contact form. (Sponsored posts or paid collaborations will not be entertained.)Connect with us on social media
Our publications
You Can Be Rich Too with Goal-Based Investing
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want
Your Ultimate Guide to Travel
