Use this financial freedom calculator spreadsheet to answer questions like, "When can I retire?" and "When should I retire?" and hopefully understand the difference between them with minimal inputs.
For a given age and life expectancy, along with other standard investment and inflation details, the years to retirement is calculated by determining when the monthly income from the corpus is higher than monthly expenses.
This version is best suited for young earners who are just starting out. An advanced Financial Freedom Calculator More 'experienced' earners and/or those with liabilities can try out the Financial Freedom Calculator.
Here is a screenshot (click on it to enlarge)
The calculator computes the inflation-protected monthly income necessary each year in future from the retirement corpus accumulated. When such an income equals monthly expenses, financial freedom is achieved.
Download the financial freedom Calculator
Get GameChanger (my second book) + Pranav's Travel Training Kit GameChanger (hardcopy is now available for ₹279 (249 +30 for shipping) and the Travel Training Kit is available for immediate download for ₹150.
Register for the Kolkata DIY Investor meet: May 28th2017
Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email Your subscription is successful if you are directed to the "Welcome Page"
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)
 | Buy our New Book!You Can Be Rich With Goal-based Investing A book by P V Subramanyam (subramoney.com) & M Pattabiraman. Read more about the book and pre-order now! |
I believe this calculator projects the age when the monthly returns on investment plus corpus is greater than the monthly expense. It does not consider eating into the corpus during post retirement period.
Their seems to be an error in calculation, for example, if you key in
Total investment till end of this year - 4 cr
Monthly expenses = 2 lacs
Inflation 7%
Post Tax Interest on portfolio = 9%
It returns 13 years.
4cr corpus, 7% inflation and 9% post-retirment return (dont know what you meant) will give monthly income of 2L for about 19Y. So the answer depends on the inputs that you give. If you want income for a longer duration then it will take to retire.
Dear Sir
It would be helpful if you could provide a similar calculator for a middle aged NRI person in 40s. residing in Gulf States. Also a MF recommendation for a NRI in 40s age.
The inputs do not depend on your residential status. I do not provide investment advice.