Use this calculator to analyze if you should pre-pay your home loan asap or invest instead. This is now republished after correcting a bug pointed out by Ankush.
I had posted an illustration of prepay vs invest in June but did not post the associated sheet. I have now modified the sheet to include new tax rules. Future changes in rules can also be easily accommodated with user entry.
The money that is free for investments (inevstible surplus) is assumed to grow at some interest rate (can be modified). Whenever there is a need, withdrawals are made from the corpus. This will work best if you use only long-term goals.
1) Details about your home loan and the lump sum you have. An amortization table will be created. Will post the amortization sheet separately.
2) Details about retirement and your other financial goals (preferably long-term, 7Y-plus)
The result would look something like this
Green line: This is how your investible surplus would have grown, had you not taken the loan.
The black dot represents the retirement corpus that you need (taking into account existing corpus)
Blue Line: Growth if you invest the lump sum (fully or partially)
Red line: Growth if you pre-paid the home loan with the lump sum (fully or partially)
The bumps in the lines represent withdrawals for different goals (coloured dots).
The sheet is rather complex. Therefore I request you to please play around with it and let me know if you spot anything funny.
My take: This is not an either-or question. Prep-pay in chunks without neglecting investments. Read more: Illustration: Pre-pay Home Loan or invest
Vinay: I will include your suggestions in the amortization sheet to be posted soon.
Noted: Updated with bug pointed out by Ankush. First published: Nov 13 2014.
Thanks to Mohit Pandey for pointing out an error in the section 24 limit cell.
Thanks to Naveen for pointing out an error in the retirement planner sheet.
Connect with us on social media
- Twitter @freefincal
- Subscribe to our Youtube Videos
- Posts feed via: Feedburner
- We are also on Google Plus and Pinterest
Do check out my books
Get it now. The Kindle edition is only Rs. 199.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You WantMy second book is now only Rs 199 (Kindle Rs. 99) Get it or gift it to a young earner
The ultimate guide to travel by Pranav SuryaThis 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 PhoneAll 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)