Home Loan Transfer Calculator (Mortgage Refinance)

Use this home loan transfer calculator to determine if it is worth refinancing your mortgage, that is, transfer your home loan to a new bank.

When a new home loan offer at a lower interest rate appears, it is tempting to want to shift an existing home loan, because the EMI will decrease for the same duration.

However, this involves costs – exit fees  and processing fees.

Also a lower EMI implies, lesser tax savings.  This is because the interest component decreases, while  the principal component increases, resulting in a net saving after accounting for the extra tax to be paid.

There are two ways to analyse a home loan transfer.

  1. If the net savings per month is use to prepay the home loan, how much quicker will the amortization be completed? Support this is about 2 years. Then then total cost involved in transferring the home loan to a lowe 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.

These options are provided in the home loan transfer calculator. A detailed Excel Home Loan Amortization Schedule Template is also available which allows periodic and aperiodic pre-payments.

This prepayment options are also available in the present calculator, but are hidden for ease use. Once you are comfortable with the sheet, you can unhide columns and play with it.

Do let me know what you think of the sheet and consider sharing it with your contacts.

Screenshots from the Home Loan Transfer Calculator



Download the Home Loan Transfer Calculator

Register for the Hyderabad DIY Investor Workshop Nov 27th 2016

Check out the latest mutual fund returns listing


Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- (Rs. 359/- at Amazon.in). Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

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.

Do more with freefincal!

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.

Do let us know what you think about the article