Last Updated on February 12, 2022 at 6:27 pm
Here is a simple formula to check your progress to financial freedom. It can tell you how long you need to be a salaried employee and shift the focus of portfolio review from returns to the corpus worth and, in the case context of retirement, how long would it last. It will work in any spreadsheet application, but with any formula depends on what we put it and how much we appreciate the calculation.
Retirement planning is about answering two questions. One, for a given inflation assumption before and after retirement, and a given overall after-tax portfolio return after return, what is the corpus required upon retirement. A corpus from which we can draw an income each month or each year. This income should grow with inflation each year. The rest of the corpus is assumed to increase at the rate of return assumed and drops to zero only in the year we expect to die.
To appreciate the importance of inflation, here is a simple example: How should I invest to get Rs. one lakh a month pension? This is a step-by-step guide for doing the above calculation: Find out how much you need to retire in 15 mins: build your own calculator!
So the first question is, how much corpus do I need for financial independence after retirement? Even for an actual middle-class existence, this can run into crores! Being a crorepati is not a dream; it is an obligation! See: What is the value of one crore in 2021?
Join 32,000+ readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! (Link takes you to our email sign-up form)
🔥Enjoy massive discounts on our robo-advisory tool & courses! 🔥
The results can be frightening, which is why we cannot hope to compensate for the shortfall by additional returns. This is why a second income is important! Why you have to start now!
The second question is, with this corpus as a target and for an after-tax overall portfolio return assumption, how much should I inevst? Of course, this is not an independent question, but it helps separate the financial planning process this way.
Please note: When we use the word “retire”, it only means “quitting your regular job”, or “no longer necessary to work every day”. This is not the same as “stop working”. A smart “retiree” should have both passive and active forms of income at retirement. There would be no compulsion to work actively, that is all. Retirement should not be confused with ceasing all activity and annoying the spouse full time.
The following must only be considered as a thumb rule. A rigorous calculation with a variety of inputs is recommended with our robo advisory tool.
So what is this formula?
=NPER(real return,-income,corpus,,1)
- Real Return = (1+ return)/(1+inflation)-1
- return here refers to the post-tax return on the overall retirement corpus after retirement.
- Inflation here refers to inflation after retirement.
- Income refers to the amount required to manage expenses in the first year of retirement. This is equal to current expenses that will persist in retirement after considering inflation between now and retirement. Note there is a negative sign before income in the formula to represent withdrawals.
- This amount will be withdrawn each year from the corpus. Withdrawals each year will increase at the rate of inflation assume in the real return calculation.
- The rest of the corpus will grow at the rate of return assumed in the real return calculation.
- Corpus refers to the retirement corpus.
- The input between the two commas is optional. If left empty, it is assumed the yearly withdrawals will reduce the corpus to zero. If you set some value here, the yearly withdrawals will reduce the corpus to that value.
- The “1” refers to the withdrawals made at the start of the year.
NPER tells you how long a retirement corpus would last (when it would go to zero) if yearly withdrawals are made from it. The withdrawals increase at some rate of inflation, and the rest of the corpus grows at some rate of return. So the answer you get will be in years because that is the frequency of assumed withdrawal.
You can use NPER in two different ways.
- NPER(real return,-future retirement income reqd, corpus expected at the time of retirement,,1)
- This is essentially a recheck of the basic retirement calculator. If you entered such a basic calculator that you will retire by age 55 and hope to live up to age 85, then NPER will give you 30 (years) as the answer. That it tells you the duration of your retirement.
- NPER(real return,-current income required,current corpus,,1)
- This will tell you how soon can you retire, or it will tell you, if you retire now, how long you can be financially independent.
NPER(real return,-current income required,current corpus,,1)
Let us call this NPER(current). This version would tell you how close (or I should say far) away from financial freedom. Like most formulae, the assumptions matter and the manner of calculation matters.
The idea of allowing a corpus to grow while you withdraw from it is acceptable for a young earner. As we grow older, we appreciate the need for regular income after retirement. We also need to appreciate the importance of varying asset allocation. So the withdrawal process assumed in NPER is rather approximate for retirement planning.
Who should not use NPER(Current)?
- Those who have just started investing for retirement should not bother with NPER. They will get the answer as 0 or 0.0001 years.
- Those who are close to financial freedom or those who have already achieved financial freedom should not use it. For example, if I use NPER(current) with my equity MF corpus + direct equity corpus + PPF + NPS, I get 71 years as the answer. I cannot make the mistake of thinking, “Hey, I am 46, my wife is 44, and we can be financially independent until ~ age 100+”.
- A more rigorous calculation with the robo advisory template taking into account pension income from NPS (80% of the corpus has to be annuitized before age 60 as of now), passive income, dividend income, retirement benefits, guaranteed income for the first 15 years and rest in low-, medium- and high-risk buckets yields a very different answer! It does not change the FIRE status, but the margin of achievement is quite different: 20% more than required and not about 50% more as NPER(current) suggested.
Who should use NPER(current)
- Those who have been investing for retirement with or without planning for a few years can use NPER(current) once a year. It will tell them how far or how close they are. Since market returns are non-linear, FIRE status will look far and suddenly change overnight. I have seen my NPER(current) double from 5 years to 10 years in a quick span of time. As it increases, we get confidence because we know we are on the right track. Of course, patience is key (clarification for millennials: this means good things will take time).
In summary, NPER is a simple measure to appreciate “where we are” in our journey to financial independence. If we appreciate the underlying assumptions, we can use it as a thumb rule for financial freedom.
🔥Enjoy massive discounts on our courses, robo-advisory tool and exclusive investor circle! 🔥& join our community of 7000+ users!
Use our Robo-advisory Tool for a start-to-finish financial plan! ⇐ More than 2,500 investors and advisors use this!
Track your mutual funds and stock investments with this Google Sheet!
We also publish monthly equity mutual funds, debt and hybrid mutual funds, index funds and ETF screeners and momentum, low-volatility stock screeners.
- Do you have a comment about the above article? Reach out to us on Twitter: @freefincal or @pattufreefincal
- Have a question? Subscribe to our newsletter using the form below.
- Hit 'reply' to any email from us! We do not offer personalized investment advice. We can write a detailed article without mentioning your name if you have a generic question.
Join 32,000+ readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! (Link takes you to our email sign-up form)
About The Author
Dr M. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. He has over ten years of experience publishing news analysis, research and financial product development. Connect with him via Twitter(X), Linkedin, or YouTube. Pattabiraman has co-authored three print books: (1) You can be rich too with goal-based investing (CNBC TV18) for DIY investors. (2) Gamechanger for young earners. (3) Chinchu Gets a Superpower! for kids. He has also written seven other free e-books on various money management topics. He is a patron and co-founder of “Fee-only India,” an organisation promoting unbiased, commission-free investment advice.Our flagship course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! ⇐ More than 3,000 investors and advisors are part of our exclusive community! Get clarity on how to plan for your goals and achieve the necessary corpus no matter the market condition is!! Watch the first lecture for free! One-time payment! No recurring fees! Life-long access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
Our new course! Increase your income by getting people to pay for your skills! ⇐ More than 700 salaried employees, entrepreneurs and financial advisors are part of our exclusive community! Learn how to get people to pay for your skills! Whether you are a professional or small business owner who wants more clients via online visibility or a salaried person wanting a side income or passive income, we will show you how to achieve this by showcasing your skills and building a community that trusts and pays you! (watch 1st lecture for free). One-time payment! No recurring fees! Life-long access to videos!
Our new book for kids: “Chinchu Gets a Superpower!” is now available!
Must-read book even for adults! This is something that every parent should teach their kids right from their young age. The importance of money management and decision making based on their wants and needs. Very nicely written in simple terms. - Arun.Buy the book: Chinchu gets a superpower for your child!
How to profit from content writing: Our new ebook is for those interested in getting side income via content writing. It is available at a 50% discount for Rs. 500 only!
Do you want to check if the market is overvalued or undervalued? Use our market valuation tool (it will work with any index!), or get the Tactical Buy/Sell timing tool!
We publish monthly mutual fund screeners and momentum, low-volatility stock screeners.
About freefincal & its content policy. Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on mutual funds, stocks, investing, retirement and personal finance developments. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than three million readers a year (5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified with credible and knowledgeable sources before publication. Freefincal does not publish paid articles, promotions, PR, satire or opinions without data. All opinions will be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
- Twitter @freefincal
- Subscribe to our YouTube Videos
- Posts feed via Feedburner.
Our publications
You Can Be Rich Too with Goal-Based Investing
Published by CNBC TV18, this book is meant to help you ask the right questions and seek the correct answers, and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now.Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want
This book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at a low cost! Get it or gift it to a young earner.Your Ultimate Guide to Travel
This is an in-depth dive into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, and how travelling slowly is better financially and psychologically, with links to the web pages and hand-holding at every step. Get the pdf for Rs 300 (instant download)