Home Loan Transfer Calculator: Base Rate To MCLR Switch

Last Updated on

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.

  1. 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?
  2. 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:

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
home-loan-transfer-calculator

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

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

Infibeam

Googe Play Books App Store

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
Do share if you found this useful

Create a "from start to finish" financial plan with this unique open-source robo advisory software template


 Don't like ads but want to support the site? Subscribe to the ad-free newsletter! 
You will get the full post-ad-free delivered to your inbox for Rs. 3000 a year. Follow this link to read the terms and sign up! 


About the Author M Pattabiraman author of freefincal.comM. Pattabiraman is the co-author of two books: You can be rich too with goal based investing and Gamechanger. “Pattu” as he is popularly known, publishes unbiased, promotion-free research, analysis and holistic money management advice. Freefincal serves more than one million readers a year with numbers based analysis on topical issues and has more than a 100 free calculators on different aspects of insurance and investment analysis, including a robo advisory template for use by beginners. Contact information: freefincal {at} Gmail {dot} com He conducts free money management sessions for corporates (see details below). Previous engagements include World Bank, RBI, BHEL, Asian Paints.

Content Policy

Freefincal has original unbiased, conflict-of-interest-free,  topical reports, reviews, commentary and analysis on all aspects of personal finance like mutual funds, stocks, insurance etc. All guest authors and contributors to the site also do not have any conflict of interest. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. No promotional content We do not accept sponsored posts and link exchange requests from content writers and agencies. This is our privacy policy Our website is non-profit in nature. The revenue from the advertisement will only be used for hosting charges, domain registration charges, specific plugins necessary for traffic growth and analytics services for search engine optimisation.
Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; where to invest; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. I can do the talk via conferencing software, so there is no cost for your company. If you want me to travel, you need to cover my airfare (I live in Chennai)

Connect with us on social media


Do check out my books


You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingMy first book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now.  It is also available in Kindle format.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You WantGamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantMy second book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a young earner

The ultimate guide to travel by Pranav Surya

Travel-Training-Kit-Cover This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step.  Get the pdf for ₹199 (instant download)

Free Apps for your Android Phone

All calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

3 Comments

  1. Your calculator is good but assuming that no income tax benefit exists for plot/site loans, then the users may get wrong perception. It is better if you mention that this calculator be not used for home/plot loans where there is no income tax benefit.

  2. Sir,

    There is one error in the calculation which is as under:

    1) The limit of Rs. 2 Lakhs for interest calculation has not been taken into account i.e. if in both the old and new interest regimes, if the interest is greater than Rs. 2 Lakhs then there would be no extra tax due to reduced interest. The extra tax utgo is calculated on interest differential which shouldn’t be.

    For eg , if in old interest regime , the interest utgo is 250000 and in new (lower) tax regime , the interest utgo is 220000, the extra tax paid would be nil though the interest has reduced by Rs. 30000 p.a. because both the interests are in excess of limit of Rs. 200000

Leave a Reply

Your email address will not be published. Required fields are marked *