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
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)
You Can Be Rich Too With Goal-based Investing A book that can help you ask the right questions about money and find simple solutions. Comes with nine online calculator modules. Read more about the book and order now!  | GameChanger - Forget Startups, Join Corporate & Still Live The Rich Live You want Take that international trip at 50% lower costs! Optimise credit card usage! Set money management on auto-pilot! Read more about the book and 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.