The even lower stress retirement calculator!

This post is a sequel to the low-stress retirement calculator  published a few months ago. With this calculator, you can reduce the total retirement corpus required by about 10%-12% for normal retirement (age 60)  and the monthly investment required by 20-30%.  The reduction could be even more significant in the case of early retirement.

How is this possible?

Most retirement calculators (including all of mine published thus far) use a single rate of return post-retirement. Instead of this, why not use a bucket strategy?

Instead of this, why not use a bucket strategy?

Here, the retirement corpus is invested in different buckets of varying volatility. Expenses for the first (say) 5 years are met with by creating an income ladder (typically with fixed deposits on paper. Short-term debt funds will make this easier).

Meanwhile, the rest of the corpus grows at different rate of returns. The amount necessary to create income ladders between years 6-15 grow in low-risk instruments, while the rest if the amount grows in more volatile instruments.

This method has been explained in detail in the following posts:

In the present calculator, I have married the low-stress retirement calculator with Inflation-protected Income Simulator

I have resisted the temptation to do this several times earlier. However, I find that many young earners are put off with retirement planning when they see the corpus required and the monthly investment necessary.

Therefore to alleviate their stress, such a union of accumulation (pre-retirement) and distribution (post-retirement) strategies seemed necessary.

I hope this tool is able to help to achieve that.

A word of caution.  The calculator has two sheets. One is the input sheet and another for the income ladder calculation. I suggest that young earners far from retirement do not change the conservative inputs in the income ladder sheet.

Here is a screenshot (click on it to study the inputs and the 39% reduction in stress!)low-stress-retirement-calculator

 

Download the even lower stress retirement calculator!

Excel 2007 version (.xlsx)

Excel 2002 version (.xls)

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

book-footer

Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete  the entire comment or remove the links before approving them.

21 thoughts on “The even lower stress retirement calculator!

  1. anil padaki

    Dear pattu sir,
    I have to invest Rs 300000 in my grand daughters name. She is now one yr. The amount should be help full for education and marriage also.this will be goal based investment for twenty years. Kindly guide me where to invest.
    Anil padaki

    Reply
  2. anil padaki

    Dear pattu sir,
    I have to invest Rs 300000 in my grand daughters name. She is now one yr. The amount should be help full for education and marriage also.this will be goal based investment for twenty years. Kindly guide me where to invest.
    Anil padaki

    Reply
  3. Mayuram Murali

    Dear Mr. Pattu : I have one doubt. For an investment of say18 Lakhs for Bucket 5 ( required after 20 years later) if you are investing in equity based MF, how to invest - as lumpsum at the start of ur retirement or some kind of stp. Provide your viewpoint please.

    Reply
  4. Mayuram Murali

    Dear Mr. Pattu : I have one doubt. For an investment of say18 Lakhs for Bucket 5 ( required after 20 years later) if you are investing in equity based MF, how to invest - as lumpsum at the start of ur retirement or some kind of stp. Provide your viewpoint please.

    Reply
  5. Mayuram Murali

    Dear Mr. Pattu : I have one doubt. For an investment of say18 Lakhs for Bucket 5 ( required after 20 years later) if you are investing in equity based MF, how to invest - as lumpsum at the start of ur retirement or some kind of stp. Provide your viewpoint please.

    Reply
  6. Srinivasan

    A small suggestion to factor in other income sources

    Thanks a lot for the hard work done in creating the template for the bucket strategy. There seems to be no formulaic way to do this. I have an early retirement goal and used to discount the typical retirement corpus calculation by 20%. The excel gives a far more precise amount, and also lays out the investment plan. A suggestion: The inputs sheet can be modified to include calculations for 'other income' during retirement - say rent, defined pension, etc.

    Reply
  7. Srinivasan

    A small suggestion to factor in other income sources

    Thanks a lot for the hard work done in creating the template for the bucket strategy. There seems to be no formulaic way to do this. I have an early retirement goal and used to discount the typical retirement corpus calculation by 20%. The excel gives a far more precise amount, and also lays out the investment plan. A suggestion: The inputs sheet can be modified to include calculations for 'other income' during retirement - say rent, defined pension, etc.

    Reply
  8. sundararajan

    Thanks for the calculator. I compared this with bucket strategy simulator. I assume to follow bucket strategy simulator / calculator for the buckets 3 to 7 for this one. ie for each bucket from 3 on wards, one should invest in different mf categories. Also, one should follow the same guidelines to move around the bucket when one is close to that bucket age or ROI reaches or well beyond for that bucket. Correct me if I am not right.
    Even though this calculator is very good to plan by 5 years period with several buckets, I think bucket strategy simulator gives rough estimate of how long that money lasts based on returns from mf.
    For example, I ran both calculators for Rs 70k per month for 40 years, both gave the same amount as corpus required. But for the same returns, this told that money will last for all the 40 years, but bucket strategy simulator gave only upto 37 years. Yes, bucket strategy simulator. gives different amount each time, but one should consider the lowest so that plan ahead.
    Once again, it took a while to play around both, can't imagine how much time and effort that you put to create these. Thank you for your efforts.

    Reply
  9. sundararajan

    Thanks for the calculator. I compared this with bucket strategy simulator. I assume to follow bucket strategy simulator / calculator for the buckets 3 to 7 for this one. ie for each bucket from 3 on wards, one should invest in different mf categories. Also, one should follow the same guidelines to move around the bucket when one is close to that bucket age or ROI reaches or well beyond for that bucket. Correct me if I am not right.
    Even though this calculator is very good to plan by 5 years period with several buckets, I think bucket strategy simulator gives rough estimate of how long that money lasts based on returns from mf.
    For example, I ran both calculators for Rs 70k per month for 40 years, both gave the same amount as corpus required. But for the same returns, this told that money will last for all the 40 years, but bucket strategy simulator gave only upto 37 years. Yes, bucket strategy simulator. gives different amount each time, but one should consider the lowest so that plan ahead.
    Once again, it took a while to play around both, can't imagine how much time and effort that you put to create these. Thank you for your efforts.

    Reply
  10. shankha

    Hi,
    I used your calculator with the provided data. I change a little. I found majorly 9-12 thousand per month needs to be invested in Equity Market.

    I have 3 years exp with UTI opp. fund (G) for 1000/~ SIP and get good results after 3 years.
    36000 -> 56000 return

    My home loan EMI will be completed with in 4 months. Hence I can invest 9-12 thousand to reach the goal as per your calculator for 15-20 yrs.

    now how can i invest this 12000 thousand per month ?
    In a single long trem Equity oriented MF ?
    Or
    6000 + 6000 to 2 different fund

    Or 4000 + 5000+ 3000 to 3 MFs

    what will be suggested ?

    Thank you
    shankha

    Reply
  11. shankha

    Hi,
    I used your calculator with the provided data. I change a little. I found majorly 9-12 thousand per month needs to be invested in Equity Market.

    I have 3 years exp with UTI opp. fund (G) for 1000/~ SIP and get good results after 3 years.
    36000 -> 56000 return

    My home loan EMI will be completed with in 4 months. Hence I can invest 9-12 thousand to reach the goal as per your calculator for 15-20 yrs.

    now how can i invest this 12000 thousand per month ?
    In a single long trem Equity oriented MF ?
    Or
    6000 + 6000 to 2 different fund

    Or 4000 + 5000+ 3000 to 3 MFs

    what will be suggested ?

    Thank you
    shankha

    Reply

Do let us know what you think about the article