Last Updated on December 29, 2021 at 5:59 pm
I have been tracking the amount invested for my goals in the same Excel sheet for the last ten years (2011 to 2020). These are some lessons from the journey. This sheet is only for tracking the amount invested and not its current market value.
Between 2010-11, my retirement planning cash flow projection was in place, and it was scary to look at. The monthly investment was lesser than what the calculator said (with unrealistic fixed asset allocation!). More importantly, I had to set the annual increase in investments to 10%.
That is if I invest Rs. 10,000 each month in one next, the next year it would be 10% more and so on. This was the only way to reduce the gap between the initial investment required and the initial investment made.
The catch was future investments quickly increased. At 10% a year, the investment would double every seven years or increase by 50% every 4-5 years. If our income does not grow as fast or our expenses grow faster, we cannot increase our investments by 10% a year.
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! 🔥
This uncertainty is common, but we can only invest what we can. What matters is, starting early; investing as much as possible; increasing the investment as much as a possible and yearly review.
If I look back the investments made it in the initial years, it seems trivially small. That is the power of non-linear growth (just trying to avoid the compounding word!). We shall only consider the invested amount and how it has increased year to year. The status of their market value is reported here: How my retirement portfolio has performed in 2020: personal finance audit.
Take the case of NPS – this is a mandatory deduction where I have little control (and have not made any manual investments). From 2011, this is the rate at which NPS contributions have increased from Dec to Dec. These include two pay commissions and a promotion. Data for the year 2016 is missing, probably lost that file due to a hard disk crash. An investment of Rs. 1000 in 2011 has gradually increase to an investment of Rs. 3200 in 2020 – MF guys would call this a step-up SIP.
| Year | NPS |
| 2012 | 17% |
| 2013 | 14% |
| 2014 | 12% |
| 2015 | 18% |
| 2017 | 7% |
| 2018 | 24% |
| 2019 | 33% |
| 2020 | 3% |
This is quite incredible and should be more or less the same for all central govt employees. The catch is the pay grade. It increases non-linearly and is not populated at the top.
It is like the question I like to pose: Two friends A and B start investing simultaneously. Twenty years later, A’s return after tax (CAGR) is 13% and B’s 8%. Who is the better investor? It is tempting to assume it is A, but it all depends on the investment made. A may have got more returns, but B the higher corpus. So returns alone do not give you the full picture. The investment made matters – in this case, it is the paygrade from which the NPS deduction is made.
While corporate employees might salivate at these growth numbers, most central govt employees would tell it is peanuts – but that is how it is. Also see: How my salary has grown over the years. The increase has already slowed down and will be the same for the next few years due to the pandemic.
The growth in the invested amount for NPS, Retirement (NPS + PPF + equity MF, excluding direct equity) and my son’s future portfolio (equity MF + PPF) is shown below.
Observations and lessons
- The amount we invest is more important (and the time over which it is invested) that the return we get.
- We cannot plan for our long-term goals without assuming investment will increase in future. A 10% year on year investment is a bit optimistic but just about manageable.
- Even that rate of increase would look daunting initially, but we will have to put our head down and keep investing (with a plan + yearly reviews)
- There were months I could not invest, and there were years I could not increase the investment. It is essential to keep track of these and make up for it later.
- The sheet I use for tracking the investment amount (not market value) is available here: How tracking investments instead of expenses changed my life!
- If there is one reason for my financial independent status, it is disciplined tracking and systematic increase in investments without worrying about returns.
- Naturally, not all of us have the same income levels and cash outflow (expenses + debt) and not all of us can invest at the same pace, and some of us may get financial independent decades later or not at all. Despite all this, try, we must and fill our cups as much as we can without cribbing about opportunities others got clueless about their personal circumstances.
- We can only deal with the cards we are dealt with. Hard work and toil without expectation is known to change the deck.
- I have seen this baffling argument: If my cup is never going to be full, then it might as well be empty. Surely this deserves an award!
- Each time our salary increases, it is essential to ensure expenses do not increase at the same pace or at least a faster speed. That is just a fancy way of saying live with your means.
- A mountaineer must plan but cannot be looking up to see “how much more” every few minutes. Big journeys begin with small steps. The problem is, in a 1000-step journey, we expect results five steps later.
- If you are a young earner reading this, track your invested amount more frequently than their market value; keep expenses at bay; increase investments at least 5% a year; Wait a decade to see the difference!
🔥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)