Home Loan Transfer Calculator: Base Rate To MCLR Switch

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

Create a "from start to finish" financial plan with this free robo advisory software template


Free Apps for your Android Phone

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)

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. 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. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

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 thoughts on “Home Loan Transfer Calculator: Base Rate To MCLR Switch

  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

Do let us know what you think about the article