Module 11   Personal Finance (Part 1)Chapter 5

The retirement problem (Part 2)

View chapters →

5.1 – Assumptions

We are at an exciting point now. The previous chapter helped us estimate (roughly) the corpus required for one to retire comfortably, without drastically changing the post-retirement lifestyle.

One can argue that certain aspects were overlooked while estimating the post-retirement corpus, which is ok for now because this helps us determine the retirement corpus on a conservative basis.

The idea, of course, is to understand personal finance so well that we can plugin things as we progress and eventually get the corpus number right.

In the previous chapter, we figured that we need roughly 7Cr by retirement; in this chapter, we address the technique to generate the same. It must be quite evident to you by now that to create the retirement corpus by the target retirement year; we need to make investments starting today.

The investments that we make today should ideally spread across multiple assets. This is called the multi-asset portfolio, which includes – fixed deposits, gold, real estate, equities, cash, and cash equivalents. The overall growth that you experience will then be an aggregate across all these assets.

Let me explain a bit more before we get back to the retirement problem. Assume your net worth is distributed across multiple assets –

  • 50% of your net worth is invested in real estate
  • 10% of your net worth is in the fixed deposit
  • 10% of your net worth is from gold
  • 15% of your net worth is in equities
  • Cash is 15%

The numbers assigned are all arbitrary, to drive the concept, so don’t sweat over it πŸ™‚

Now, each of these assets grows at a specific rate. Needless to say that the growth rates differ for each of these assets. The question is, what is the overall growth given this portfolio of assets?

To answer this, we need to have an expected growth rate for each of these assets.

My long term (10 plus years) growth expectation (CAGR) from these assets are as follows –

  • Real estate – 8-10%
  • Fixed Deposit – 6-7%
  • Gold – 8-9%
  • Equities – 10-11%
  • Cash – 0% (in fact cash de grows if you consider inflation)

You can develop your own opinion on the growth rates for these assets by looking at the long-term trends and by developing an idea on their future performance. But here is an advise, when you work with predictions/projections of any sort in personal finance, always keep the number on a conservative basis.

For example, frankly, I know equities, in the long run, will do much better than 11% CAGR, but I’ll work with a 10-11% range. The advantage here is that you build a future based on conservative assumption, anything better is only a bonus.

Anyway, the overall portfolio growth in the sum product of the weight of each asset and the expected return. Therefore –

= (50% * 10% + 10% * 7% + 10% * 9% + 15% * 11% + 15% * 0) * 100

= 8.25%

So as you can see, the combined (diversified) portfolio with multi-assets, generates an overall return of 8.25%.

Of course, change in asset allocation has an impact on portfolio growth. We have discussed this multiple times, won’t get into that discussion now.

By the way, check this to know how people generally divide their net worth across a diverse set of assets –

The infographic above mainly talks about the HNI and above category; however, if you walk into any financial planning firm, you are likely to get a somewhat similar diversification plan.

While a multi-asset portfolio is highly desirable, we won’t get into that discussion just yet. This is slightly complex, and we are too early in this module to talk about it.

For the retirement problem, we will make one fundamental assumption. The assumption is that we will look at only equity for building the retirement corpus. The exposure to equity is in the form of making systematic investments in a growth-oriented equity mutual fund.

If you do not understand β€˜systematic investments in a growth-oriented equity mutual fund’, then do not worry. Going forward in this module, we will discuss this in detail.

Since equity is the only asset we are dealing with in this retirement problem, we need to assign an expected growth rate to this asset. I think a 10-11% CAGR is a fair expectation, especially when the holding period is long, i.e. more than ten plus years.

So let’s work with this number for now.

5.2 – The setup

A quick recap of the retirement problem, before we proceed. In the previous chapter, we figured that we need funds to the tune of 7Crs to lead a comfortable retired life. We call this a retirement corpus. We defied β€˜comfortable’ by ensuring we have at least Rs.50,000/- per month for the 20 years post-retirement.

The next step is to figure out how one can generate a retirement corpus. Remember, we are starting our journey to save for retirement today, and we have 25 years to build this corpus. Twenty-five years is 300 months.

For now, we will rely upon investing in an equity mutual fund, in a systematic way to generate this retirement corpus. To solve this problem, we need to make a few assumptions. They are –

  • We have a steady job which pays us a salary every month
  • We are employed until the year of our retirement
  • Our primary savings vehicle is regular investments in equity mutual funds
  • We get yearly hikes in our pay
  • Every year we will increase the investments in equity mutual funds by 10%
  • The increase in savings happens every January

I know many of you may be concerned with these assumptions here, especially about the job and the hikes, but then, that’s an underlying assumption, without which we cannot proceed πŸ™‚

So how do these assumptions translate to action? Here is how it looks –

Let me explain this table. The very first row reads like this –

It is January, and I’m making my very first investment of Rs.5000/- today. I won’t be touching this investment until I retire, which is 25 years away or about 300 months away.

The 2nd row reads similar – Its February, I’m making the 2nd savings installment for the year, i.e. Rs.5000/-. Retirement is now 299 months away.

I want you to recognize the fact that the β€˜months away’ can be looked at from a different perspective. If you realize, these are the number of months during which your money can grow. For example, the very first installment you make has the luxury to build (or compound) for 300 full months. The next month’s savings can grow only for 299 months, 3rd installment has only 298 months to grow. So on and so forth.

Now, the 5th and 6th assumptions state that we are increasing the savings rate by 10% every January. Β This means, if we are starting with Rs.5000/- for year 1, the 2nd year we bump this up by 10%, hence for the 2nd year we invest Rs.5,500/-.

This is how it looks –

The month counting continues the same way. For example, the Rs.5,500/- investment we make in the 2nd year January has only 288 months to grow or compound.

I hope you get this flow for now.

So what happens after you make these investments? Well, as per the assumption, each of these monthly investments we make, grows at 11% CAGR (compounded annual growth rate), for the respective months.

For example, the very first investment that we make, i.e. Rs.5000/- gets to grow at the rate of 11%, for 300 months. So what would be the value of this investment at the end of 300 months?

Well, by now, you should recognize that we can apply the concept of the future value of money and get the answer. The future value of money formula is –

Future value = P*(1+R)^(n)

Where,

Principal (P) = Rs.5000

Growth rate (R) = 11% per annum

Time (n) = 300 months. However, this formula considers time in years. Hence we need to express 300 months in years, therefore 300/12 = 25

= 5000*(1+11%)^(300/12)

=Rs.67,927/-

Let us do this for the 2nd installment as well; everything stays the same except for the time component –

= 5000*(1+11%)^(299/12)

=Rs.67,339/-

This is how the table looks –

Now, if you add up all the future values, you get the corpus accumulated for your retirement. Before I show you the number, what is your guess? Does Rs.5000/- as the starting amount make the cut? Do you think it gives you the target corpus of Rs.7Crs?

If you are doubtful, then you are right. It does not cut the mark. It’s way off the mark –

 

So what should we do? How do we ensure we reach the target retirement corpus? Well, we can do three things –

  • We save for a much longer period, say 30 or 35 years. However, this may not be viable as we won’t have a sustainable source of income for these many years
  • Increase the rate of return, maybe from 11% to 14%, but then is like robbing yourself of your future. So we won’t commit this sin
  • Increase savings, this means a frugal life today for a comfortable and financially independent life tomorrow. This is an option we can work with this.

So from saving Rs.5000 per month, let us bump this up to say Rs.15,000/- per month. Here is how the numbers stack up –

There is a significant improvement, but still not close to the 7Cr mark. We can try this with Rs.20,000/-

As you can see, starting at Rs.20,000/- per month, we get close to the 7 Cr mark, which upon retirement will yield us Rs.50,000/- per month for 20 years.

5.3 – Are you serious?

Saving Rs.20,000/- a month, that too as a starting amount may sound crazy to many, especially for people who are just starting their careers. After all, you’ve just started your career, started seeing a steady cash flow, and you are expected to park the bulk of it for retirement?

How fair is that?

Before it demotivates you any further, let me tell you. It is not all that lousy πŸ™‚

Let me make an assumption here; if you are starting your career now, then probably you are 24 or 25 years old. This means you have a long runway before you retire. Even if you retire by 60, you mostly have 35 years to retire.

Out of these 35 years of service, even if you invest for 30 years, you will be placed much better. You can choose to start with Rs.10,000/- per month. Check the snapshot –

Starting your career early, gives you two powerful levers to operate – time and money. You can start with a small amount and build on it, eventually, it will yield you a similar result.

What if you are in the middle of your career and you are looking at retirement sometime over the next 10 or 15 years? Well, unfortunately, you do not have many options except to save large chunks of your cash flow.

But remember, this entire conversation is an oversimplification to help us get started. There are many angles to this story. For example, you may acquire property by inheritance, which earns you a rental income for the rest of your life or you can get a huge lump sum amount at retirement, thanks to PF and stuff. This retirement amount gets parked in a savings account or a fixed deposit, which gives you yearly cash flow.

The objective of this module is to help you solve this puzzle so that you can plan your financials efficiently for yourself and your family.

5.4 –Next step

Irrespective of the lump sum cash or a yielding rental property landing up in your lap by retirement, investing in equity is something that you cannot miss. I firmly believe that ‘equity’ as an asset class will outperform all other assets and shine through. Equity has to be a part of your long term portfolio.

The best way to gain exposure to equity is by investing in mutual funds via a systematic investment plan. Of course, there are many other variants and techniques for this.

Given this, over the next few chapters, we will deep dive into mutual funds and get a thorough understanding of mutual fund investing. This discussion will include things like developing a mindset for mutual fund investment, building a mutual fund portfolio, goal-based portfolio, fund analysis, direct vs regular, growth vs dividends, etc.

Once we understand mutual funds, we will steer our way to learn other critical components of personal finance such as life insurance, health insurance, pension funds,Β  EPF, ETFs etc.

So as you can imagine, we have a long learning path ahead πŸ™‚

Key takeaways from this chapter

  • In a multi-asset portfolio, the aggregate portfolio return is the sum product of the asset weight and the asset’s expected returns
  • Equity exposure is a critical component in long term wealth creation
  • Investing small amounts of money regularly leads to a massive retirement corpus

 

 

154 comments

  1. Kunal G says:

    I have read all of your varsity modules!
    I’m eagerly waiting for the mutual fund education. There are a lot of mutual funds out there and which makes it confusing to know where to park our money into. And how much tax do we have to pay for the interest we receive every year.

  2. Punith says:

    Hi Karthik,

    You have listed the importance of savings and investing your savings in a very effectively manner, The point I wanted to add was we even have PF’s which will also add a significant contribution to our final corpus – Do you like to and any points on the same.

  3. Govil Bhole says:

    The only drawback of Varsity is that you have to wait eagerly for the next chapter. I wish you can start like Binge reading in varsity!! πŸ™‚
    Great content Sir!!

  4. Mohammed Jidin MP says:

    Personal Finance is a much needed subject on wealth creation. Zerodha understood the need for such module and presented it in a simplied manner. Hope this module will covers all the relevant asset classes. Keep going Zerodha.

  5. DILIP says:

    Sir, Thanks a lot for nice explanation.

    There are 2 sheets are already available , however rest are not.

    With Regards,

  6. Satyam says:

    Thanks Sir, for sharing these insightful information. You are doing a great job. Keep going..

  7. Ram says:

    Agreed with Govil, Karthik its like I get up everyday with the expectation that you will upload a new chapter but I have to go with despair every day. Karthik please………….! πŸ™‚

  8. Pritesh Jadhav says:

    Hi Karthik thanks for all the knowledge and wisdom that you are sharing with us.But I would like to ask a naive question With SIPs we are building our retirement corpus or some goal purchase like luxury car after 20 years.But our investments will be attracting LTCG @10% suppose my goal amount is 1Cr in 20 years I can build that at nearly 7K per month at 15% CAGR my total investment will be 16 lakhs which means I will gain 84 lakhs so how is tax calculated on such investment is it calculated yearly or only when I have to do redemption does it mean that at 10% I will be paying 8.4 lakhs on the wealth that I built slowly and working very hard or is there any smart way around.Also how is indexation benefit availed is it applicable for all investments or only selected types of investment??
    And last but not the least thank you team Zerodha you have amazing apps and services varsity,kite,coin and many more😍😍😍

  9. Shiva Teja says:

    May i know how many lessonns there are going to be in this module , also the number of modules you are going to make ?

  10. Sanu says:

    Is there a way to label my mutual fund investments with goals? For e.g. Aditya Birla Sun Life Frontline Equity Fund – Direct Plan – Growth—> House, Nippon India Low Duration Fund–> Vacation etc. This would really help track our investments based on different goals

  11. Vibhor says:

    Hi

    Similar to other modules, can we also have a downloadable pdf available for ‘Personal Finance’ module ?

    Thanks

  12. Abhishek says:

    Hi Sir,

    Any reason on why to increase sip by specifically 10% every year or was it just an example?

  13. Kumar A says:

    Your retirement corpus calculation is not correct. You have not escalated current monthly expenditure 50k with inflation rate to get expected monthly expenditure when person retires. You assumed same expenditure at retirement age and then taken inflation rate for post retirement period. Secondly, post retirement if one invest the retirement corpus in bank @7% then inflation at that bulk amount will be taken care by this bank interest. Thirdly, you are expecting that after life span is over the person will leave a big amount to his nominees. Whereas the value of retirement corpus will be reduce drastically from 7 Cr, if you consider as diminishing balance and will become zero after his demise. For safety life span can be taken 5 year more if felt by anybody.

    • Karthik Rangappa says:

      Kumar, I’m aware of all these points. It is just that I dint want to complicate the retirement problem at the start of the module. The idea is to introduce different concepts and then revisit the problem again for better understanding. For this reason, in the chapter, I’ve mentioned that the solution is an oversimplification.

  14. Abhishek says:

    Hi Sir.
    Can we trust mutual funds for such a long time and put big chunk of our income in such schemes for this long?

    • Karthik Rangappa says:

      Yes, they are all highly regulated entities. So far there have been no bad incidents in the MF industry, so we all hope for the best πŸ™‚

  15. Kumar A says:

    Thanks Karthok. I understand & appreciate your point.

  16. Kumar A says:

    * Karthik

  17. Vivek says:

    Hi Karthik,

    Great work with all the modules. I couldn’t find the link to download the corpus estimation excel sheet. Can you please share the link here.

    Thanks

  18. Vivek says:

    Thanks for your response. I’m looking for the excel file to check the accumulated corpus values with different initial conditions. I understand the PDF will only be published after the completion of the module.

  19. Sumanth says:

    Hi,
    Don’t you think that the corpus of 7Cr will also keep growing year over year? And considering the growth rate of 8.3% illustrated in this chapter (with the asset allocation) will generate 58L annually. Whereas the requirement at the first year of retirement is barely 20L. So, the return of 38L is added back to the corpus of 7Cr. Isn’t it a very conservative (or safe) approach to build such a huge retirement corpus which also seems to be impractical? In my opinion, 3Cr corpus is good enough to generate 25L returns and after expenses of 20L still has a surplus of 5L which goes back to the corpus. Am I wrong in my assumption?

    • Karthik Rangappa says:

      Sumanth, yes, that matters and there are other angles to this as well. I’ve kept it straight forward for now, as we develop more and introduce more concepts, we will reintroduce the retirement problem and rework on it. This chapter is to just kick start the thought process.

  20. Sumanth says:

    Hi Karthik,
    Thank you for the clarification. Look forward to understand the other angles and concepts

  21. Narana says:

    Hi Karthik,
    Most of the expenses (school fees, clothes, shoes, electronics, restaurants, vacations, fuel) go down after retirement. Also inflation is not applicable for every product. If we closely observe, mobile phones, TVs, Laptops, clothing, shoes, cars and for many things , prices have not increased since 2005. Rather reduced. I agree on food inflation but that’s not more than 10%-15% of total costs. So, will it not make sense to calculate retirement requirements taking a inflation of not more than 1%-2%. Even if we are at par with USA in next 20 years, just look at the cost of things in USA. Its not that expensive. If some one is able to buy a house for retirement in 30s and 40s, shouldn’t such retirement targets scare him than help him…..My question is should we reduce the targets for retirement?
    I am in mid 40s and would like to start trading in options . I want to become more of an option writer. Just finished 4 modules on Analysis, Futures and Options . Tonnes of thanks to you. Taking full advantage of COVID situation. I am NIT passout ECE, working in Sales and Marketing. A doubt keeps coming in my mind , whether its a right age to start Option Trading ? Even if I am able to make 1Lacs/month , that would not be able to replace my current income. Suppose I religiously trade in options for next 2-3 years, is it possible to generate a net income of 2L-3L/month after few years? How much investment is needed to generate this level of income ? Will it make sense to sell a flat and plot ( which is any way seems to be dead investment) and put it into options ?
    rgds/Narana

    • Karthik Rangappa says:

      Narana, of course, it makes sense to factor in inflation and a lot of other parameters before factoring in retirement. The one that I’ve put up here is to help start the train of thoughts. We will revisit this topic when we have sufficient knowledge of various components that make up a retirement plan, guess I’ve mentioned it towards the end of the chapter as well.

      As far as options writing is concerned, all one needs is a month like April to wipe out all gains made along the year. Its very tricky and can be really hard to replace your main source of income unless you do it with a ton of capital and have a significant amount of risk management. Selling your property for this is a really bad idea. Even if its a dead investment, your capital is safe, with options, that can also get wiped out in a month πŸ™‚

  22. Narana says:

    Thanks for the advise. I may start with a small capital of 15Lacs for 1 year and then see how it goes.

    • Karthik Rangappa says:

      Good luck, Narana! Hope this works well for you. Let me know if you have any questions with regard to options trading.

  23. Divyam says:

    1)why do u believe equity as a class will outperform all others?I have seen lot of graphs which say the gsec bonds have over 25 years done almost as well or better then nifty?
    2)dor retirement calculation,we should convert all our calculation to money we will require to earn by end of working life-because in 20 years to retirement it can still give significant interest?

    • Karthik Rangappa says:

      1) Over a long period, equities have always outperformed. Of course, this was challenged in recent times when even the 10-year SIPs went -ve.
      2) Yes, but we have no insights into the interest rates, right?

  24. Divyam says:

    Sir,but asa rule we should never extrapolate the past to the future.There has to be independent reasoning to predict future trends?

  25. Gaurang Joshi says:

    I did not get this —-
    = 30% * 10% + 8% * 7% + 8% * 9% + 13% * 11% + 4%* 0
    = 8.3%
    How you got it..Please explain..

    Still the excel sheets used in above chapter are missing…Kindly upload those excel sheets for easy reference…

  26. Shubham says:

    Although, I already know what are these things mentioned in this chapter but i just loved the way you have explained it in so simple language.

  27. Rani says:

    Hello Sir,

    Heartfelt appreciation your superb initiative for spreading financial literacy.

    AS we are talking about retirement problem, what do you think about NPS. NPS also gives 50k additional limit under 80C and can have equity portion upto 75 %.

    Isn’t it must to have in portfolio?

    Are there any drawbacks to it.

  28. Sachidananda Pradhan says:

    I do not get it how did you calculate the total growth rate to be 8.3% ?
    It happens to be 5.71% ?

  29. Avinash says:

    Awesome article,I will try to follow…Thx

  30. Rakshith says:

    Karthik,
    Thanks, it was wonderful article. is it possible to share the excel sheet which you have used in this article or share the path, so I can download?

    Thanks,
    Rakshith

  31. Mohit says:

    Very Nice Article . Thanks
    Not able to find Download option

    • Karthik Rangappa says:

      The download option will be available once the module is complete, Mohit. This is work in progress still.

  32. Akshay Dugar says:

    Hello Mr. Karthik, I searched for the download link. It’s not available.

    I have a question: you’ve advised us to increase the investments by 10% every year.

    This will increase our investment from – Year 1 = 20,000
    To –
    Year 10 – 51,875
    Year 17 – 1,01,090

    Won’t it be challenging to save upwards of 1,00,000 for 3-4 years consecutively? Even after taking the hike in salary into consideration.

    Thank you.

    • Karthik Rangappa says:

      It is, Akshay. I’ll revisit this chapter again when we have introduced more concepts and notes, request you to wait till then πŸ™‚

  33. Aditi says:

    This is a very informative and helpful piece on personal finance in the internet. it addresses the much-confused issue on how to save for retirement. Thanks Varsity for putting up such info.
    Additionally, I have a question on equity growth rate assumed in this article. The 11% p.a. growth assumed for regular MF investments, means by compounding at the end of 300 months it will be giving an absolute return of 1258% {i.e (1+11%)^(300/12)-1}. Similarly, 183% for 10 yr & 68% for 5yr. But, historically such high returns have not been observed and once invested, the amount gets the benefit of time while the returns are unrealised and not reinvested .So, do you think for equities we should go for ‘per annum’ growth assumption or ‘overall/absolute’ historical return rate?

  34. hari says:

    sir, can you mail us/ upload this calculator sheet?

  35. hari says:

    will you be uploading the calculator sheet? is there a place i can find it. i tried to make my own and i think i’ve really messed up on a few formulas (or it’s just a frightening amount…)

  36. HARI says:

    sir, will you be uploading the calculator sheet ?

  37. Janani T M says:

    Hello Karthik,

    I am 25 now. Provided I decide to invest 20,000 every month (with 10% increase every year) for next 25-30yrs, where should I predominantly invest for building this retirement corpus? I understand investing in equity over long term will be beneficial.. But because of this covid situation, aren’t the past 10 year returns for some have been negative? And retirement corpus is a huge sum of money. I am skeptical to invest my hard earned money in something which will eventually eat up everything at last. Can you suggest best investment options for building this retirement corpus?

  38. Janani T M says:

    Thanks for the reply karthik.
    Alternatives I meant, there are options like PPF, VPF, NPS also (of course with limitations like lock-in period, liquidity, less returns compared to equities etc) Let’s assume am not going to touch the money until it’s maturity. So now, what % of investment should I have in these instruments vs equities? For the sake of stability.

  39. Hari says:

    Hi ,
    In section 5.1, the overall portfolio growth as per the assumed allocation comes to 5.71% instead of 8.3%, can you please verify?
    Regards,

  40. Nilkamal says:

    Hi,
    Can you cover expense ratio. And how it will be charged annually with example?

    Thanks

  41. Anish says:

    Hi Sir, great articles about financial education. Can you also cover the topics like how to identify a good IPO.

  42. GUNJAN PANDEY says:

    What is the difference between Equities and private equity (ref. image shown of ideal distribution of investment)

  43. Ashish Gabhane says:

    Hi Karthik,

    The whole series of personal finance is just awesome. Eye opener.
    Very well explained.

    One question, where can I get this calculation excel sheet?

  44. APURVA says:

    Please share the Excel sheet.
    Did we take 5000 pmt or PV? ( as we calculated Sip amt after 25 years?)
    As we calculated by CAGR the answer for 5000 sip would be 5647652 ( as 5000 is in monthly )

  45. Vishwa says:

    Hello Karthik, Great going with this article and it’s need of the hour as well –
    Just one request, I see that this topic is yet to be available of Varsity mobile app.
    Do we know on when it would be updated on the app as well?

  46. Rajeev says:

    Can you pls publish the excel referred to in the above write-up?

  47. Ritesh Bhargava says:

    Hi Karthik ji

    At the outstet thank you for sharing this valuable knowledge on personal finance, MF and other market instruments. I wanted to know your view on rate of return to expect if one invests in value stocks and leave it for 10 plus year horizon. I presume it to be similar as any equity MF (11-12% on conservative basis). Do you agree or have some other perspective which I am missing.

  48. ashok says:

    One of the problems about being conservative at every step of the calculation means that we may make major errors due to the effects of compounding. For example, the retirement problem above assumes a 100% cash holding at the start of the retirement period: that is you hold cash for 20 years between retirement and death thereby giving up the benefits of compounding for 10-20 years. This makes the savings numbers look larger than they need to be, and may frighten some young savers!

  49. Bharath says:

    Sir I’m undergraduate student if I get into work my starting salary would be 15000 I will follow 50% for basic needs, 20% for luxury and 30% of 15000 for savings which is 4500 will it help me starting my investment journey

  50. Bharath says:

    Sir I’m now student can I start investing as low as 100-200 every month or 1k for year

  51. NAVEEN KUMAR says:

    Can you please upload the excel sheet of above explanation. Thanks !

  52. Bhargava Chandra Dusa says:

    What about the tax on retirement corpus?

  53. Bharath says:

    Hi sir
    Sir excel sheet for this chapter

    • Karthik Rangappa says:

      Ah, I seem to have missed it. But its a fairly straightforward sheet, have explained the steps in the chapter itself.

  54. Bharath says:

    Sir what is the function in Excel for months
    Starting from 500 to 1 month
    If I use autofill function it comes like this 500,501,502………..
    Can you guide me in this step

  55. RKS says:

    Oh first cell write 500, in cell below that write 499, you may add one more entry below that for 498. Select all two or three cells depending on how many you wrote. Now with your mouse, clink and hold bottom right corner of your selection.while holding drag your mouse down to cells, your series will be filled up.

  56. Dhairya says:

    Hi Karthik,

    Many thanks for the excellent initiatives you have been taking to empower people towards meeting their financial goals.

    Can you please share the downloadable excel sheet used in the corpus estimation?

    Regards,
    Dhairya Trivedi.

  57. Dhairya says:

    Will be glad if you could do the same. Waiting.

    Thanks.

  58. Dhairya Trivedi says:

    Hi Karthik,

    I have made the excel sheet for the corpus calculator in the above example.
    If you can give me your email id, I can mail it across to you and you can include it in the module for everyone’s benefit( i see a lot of questions asking for the same)
    Or else, my email id is mentioned along with this message, you can send me a mail and I’ll be happy to send you the sheet.

    Thanks,
    Dhairya Trivedi.

    • Karthik Rangappa says:

      Thanks Dhairya. That helps me save some time πŸ™‚

      Maybe you can upload the file on Google drive and share the link for everybody’s benefit? Thanks.

  59. Dhairya Trivedi says:

    https://docs.google.com/spreadsheets/d/1PELKcsCPUk8X7dxsm3gBG8RRjGfhMuuv/edit#gid=1352582989

    The excel file for the corpus calculator is shared in the link above.

    Regards,
    Dhairya.

  60. Abijith B says:

    “but then is like robbing yourself of your future. So we won’t commit this sin” I didn’t get that point. Can anybody help : )

    • Karthik Rangappa says:

      The higher the return expectation, the lower is the investment required per month. But it does not make sense to increase the return as we are better off taking a conservative approch.

  61. Kardam Kapoor says:

    Hi,

    In Chapter 5 you have mentioned that you will discuss about – Life insurance, health insurance, pension funds, EPF, etc. Can you refer me to the chapter number where you have covered them as it is not clear from the Index items.

  62. Ashok says:

    Hi Karthik sir,

    I have a piece of land 2400 square feet in outskirts of Chennai and cash on hand around 25 lakhs. Is it okay to build house in that land using the cash and get then rental income ? Say like constructing 6 one bhk house and get the rental income. I already have one home to live. Also have sip in mutual fund for 10k going on around past 6 years. Have some money into direct stocks. Some money going into retirement account monthly. Is it okay to put money into constructing house for rental income ?

    • Karthik Rangappa says:

      Ashok, I’m not a real estate expert and I really don’t know much about it. Not sure if I’m the right person to take this advice from. If I were you, I’d talk to a good RE expert in the Chennai area and take a call on this.

      Good luck, Ashok.

  63. Krips agua says:

    Hi Karthik,
    I am about to retire in 10 years time. I would like to have some fixed-income (pension) after my retirement. I have looked around all the Annuity plans (HDFC, SBI, ICICI and other financial houses) and found that all of them charges a hefty fees (often 5 to 8% yearly). I have heard that Mr. Nithin (zerodha founder) is about to come up with pension and annuity plans that would charge far less %. Is it really so! Also heard that he has applied to SEBI and other regulatory bodies for permission.
    If it is so Iwould like to put some hefty amount for the annuity plan. Please convey him to pursue the matter faster. I shall be waiting out for his annuity scheme to invest.

    Thanks

    • Karthik Rangappa says:

      Are you sure its 5-8%? That is quite a bit. Our AMC plans will take some time, it’s at the hands of the regulators. We are yet to get the licence.

  64. Sandeep says:

    still dont see those excel files πŸ˜›
    Would love pdf version of this module please πŸ™‚

  65. Keerthi Ramesh says:

    Hello Karthik, First of all, brilliant and easy explanations. Thank you very much for that.

    I was just doing the math and found that , if we start saving 20k Per month with a 10% increment every year, by the time we are saving on 24th year, we are required to save close to 2Lakh per month, am I getting this right? which means saving 24 Lcs to get 50K per month from next year onwards? And also, the returns which we are expecting from the next year, is that not taxed at 10% too? ( with the current tax rules?)

    Regards
    Keerthi

    • Karthik Rangappa says:

      It works out to 1.79L per month or about 21L per year.

      Its 50K for the next several years right? About the tax part, yes there would be 10% capital gains going by current rules.

  66. Gagan says:

    Sir, are we assuming that from the time of retirement, we are going to keep 7cr in form of cash. Won’t it still remain invested. Its still gonna generate something for next 20 years. We would just stop adding to it.

    • Karthik Rangappa says:

      Yes, it will be invested in a return generating instrument. But for simplicity in our understanding, we are going with the total corpus required.

  67. Gagan says:

    Got it. Just read your replies. You kind of overly simplified it.

  68. Varun Agrawal says:

    A small typo, I like to report ” I think a 10-11% CARG is a fair expectation”. I think it should be CAGR, not CARG. Sorry if I am being grammar nazi.

  69. Sopan Mittal says:

    if we are considering that we have 360 weeks instead of 300, then corpos required will be more then 7cr.

  70. Leo Johns says:

    Hi Karthik,

    Please can you verify the equation.
    I have gone through the comments and saw a few others also asking this

    = 30% * 10% + 8% * 7% + 8% * 9% + 13% * 11% + 4%* 0

    = 8.3%

    If you calculate this, the answer is 5.7 %.
    Would really appreciate if you can confirm or am i missing something

    • Karthik Rangappa says:

      Thats right. Btw, I realised another mistake while checking this. I’ll try and fix both, thanks for pointing πŸ™‚

  71. Medha Gangal says:

    Hello Sir,
    In your opinion, do bank fixed deposits still have a place in an investment portfolio, given the very low interest rates? Do they have any real merit except for the psychological security of a conservative investor? Are they not fully replaceable by Liquid funds?
    Thanks in advance

    • Karthik Rangappa says:

      Not really. If your time horizon is 1-2 years and want capital safety, the FDs is still a good option.

  72. Kumari Anita Roy says:

    The requirement of about Rs 7 Cr has been estimated to be in hand in the year 2044 , ie the year of retirement by investing Rs 20000 as monthly SIP in equity (with 10 percent increase in SIP every year) from year 2019 for 25 years. It is noted that Rs 7 Cr for post retirement life is not required in the single year 2044 itself , rather it is required over a long period of 20 years from 2044 to 2063. No doubt Rs 7 Cr estimated in year 2044 will not be parked as cash for next 20 years but definitely the entire amount or major part of it will be invested in suitable instrument or financial institutions to fetch interest or the value to grow . So with this , the person retiring will be leading more comfortable life meaning by he will be getting per month an amount more than present value of Rs 50000 as assumed.

  73. Binoy says:

    Wonderful content sir…please upload the Excel sheets u used to explain the contents if u have uploaded already pls provide the link to download

  74. Inaam says:

    Is there a downloadable corpus estimation excel sheet where we can play around with the numbers?

  75. Anurag says:

    I tried to play around with the sheet and let’s say for a hypothetical retirement amount the total corpus required at the end of the retirement year is 24 crores. Now wouldn’t this amount be invested in somewhere and would be providing a reasonable return (even in let’s say a safe investment). So for such a large corpus the return on the investment would be sizeable and help in the yearly amount required, right?

    • Karthik Rangappa says:

      Thats right. But I’ve not factored that in considering SB accounts in future will yield next to 0 plus to add some conservatism to our calculation.

  76. Anurag Pandey says:

    That makes sense. Also, that money doesn’t necessarily needs to be in SB accounts. With that thought in mind I wanted to ask if you plan to cover investment options for retirees. (Sorry if you have already covered and I may have missed it.) I know a lot of people who may benefit from that and it would also give me an idea of what could be done with the corpus that has been accumulated.

  77. Anonymous Meister says:

    Hey,

    Does this module not assume that we will stop investing our money after retirement?

  78. RAJIV ASHAR says:

    Sir There is time when Equity has given negative return for almost 10 year. Is it true

  79. Krishna says:

    I can’t able to find the excel sheetπŸ˜ͺ

  80. Adarsh says:

    Looking forward to the excel sheet used in the current module. Great content πŸ™‚

Post a comment