The low-stress retirement calculator (hopefully!)

The first time someone uses a retirement calculator, they are in for a couple of rude shocks!

  • The corpus required for financial independence post-retirement, taking inflation into account typically would be a few crores (if not several!)
  • Therefore the monthly investment required is typically equal to monthly expenses or even more!

Becuase of this I get more bricks than bouquets for my retirement calculators 🙁

With an aim to lower user stress here is an alternative version which explicitly accounts for three types of current  and future investments:

  • equity investments
  • taxable debt investments (fds, debt funds, gold, etc.)
  • tax-free debt investment (PPF, EPF)

It also takes into account future EPF contributions.

The corpus necessary for financial independence is reduced by the expected future value of current investments and future EPF contributions. This (hopefully!) would look a lot less daunting.

The sheet then asks you the intended asset allocation for future investments an annual increase in monthly investment.

The monthly investment required in each asset class and the expected future value at the time of retirement are calculated.

freefincal-retirement-calculator

 

My aim is to make a visual retirement tracker (like the visual SIP tracker) with this sheet as the basis.

I have annotated the inputs following a suggestion by Raghavendra Paripati. This tool was made after discussions with Aparna. Check out her presentation: An Introduction To Personal Finance For Young Earners

Do let me know if any additional features are necessary.

Update: Download the even lower stress retirement calculator!

Download the low-stress retirement calculator

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.

36 thoughts on “The low-stress retirement calculator (hopefully!)

  1. John Galt

    Pattu: I assume the EPF contribution input to the excel includes both employer and employee contributions. Please confirm. Would also be good to clarify this in the next version of the excel calculator. Thanks for your awesome work!

    Reply
  2. John Galt

    Pattu: I assume the EPF contribution input to the excel includes both employer and employee contributions. Please confirm. Would also be good to clarify this in the next version of the excel calculator. Thanks for your awesome work!

    Reply
      1. John Galt

        Pattu: You are not entirely correct; EPS is 8.33% of the employer's contribution - subject to max of Rs. 541 (from Sep 2014, max cap has been raised to Rs. 1250). So assuming a much higher salary than Rs. 15000 p.m., the EPF share from Employer's Contribution will also be significant.

        Reply
  3. B

    Dear Pattu Ji,

    It is a fact that those who know the figures (like all of us)...like retirement, child marriage, child education etc are always conscious and "under stress". they also feel insecure....

    vs

    those who do not know these figures....are always enjoying life and happy ....

    ofcourse,,, they may be only delaying the stress... but the fact is they are enjoying their life....and people also think they are more successful (though earning 1/4th of us)....as they buy costly mobiles... cars...houses etc...

    all the best to them..

    Reply
  4. B

    Dear Pattu Ji,

    It is a fact that those who know the figures (like all of us)...like retirement, child marriage, child education etc are always conscious and "under stress". they also feel insecure....

    vs

    those who do not know these figures....are always enjoying life and happy ....

    ofcourse,,, they may be only delaying the stress... but the fact is they are enjoying their life....and people also think they are more successful (though earning 1/4th of us)....as they buy costly mobiles... cars...houses etc...

    all the best to them..

    Reply
  5. JIG

    This is only a retirement. If gonna think about education and marriage, i will have to forget about living a life... Means More Stress... Better live me the current moment of my life.:) 🙂

    Reply
  6. JIG

    This is only a retirement. If gonna think about education and marriage, i will have to forget about living a life... Means More Stress... Better live me the current moment of my life.:) 🙂

    Reply
  7. rajanikant v gajjar

    Resp sir
    unfortunately financial literacy & FINANCIAL data awareness,& readiness is so poor with us,that you need to develop still simpler retirement calculator,sure it may not be very perfect.
    in my opinion,inputs should be as less possible.
    keep inflation 8% fixed,return on investment 9% fixed,no variables to be offered.
    from expenses & age related details & current retirement dedicated LUMP SUM investments,corpus at retirement needed should be calculated.
    PLEASE THINK FROM PERSPECTIVES OF AVERAGE COMMON MAN-AAM AADMI

    Reply
  8. rajanikant v gajjar

    Resp sir
    unfortunately financial literacy & FINANCIAL data awareness,& readiness is so poor with us,that you need to develop still simpler retirement calculator,sure it may not be very perfect.
    in my opinion,inputs should be as less possible.
    keep inflation 8% fixed,return on investment 9% fixed,no variables to be offered.
    from expenses & age related details & current retirement dedicated LUMP SUM investments,corpus at retirement needed should be calculated.
    PLEASE THINK FROM PERSPECTIVES OF AVERAGE COMMON MAN-AAM AADMI

    Reply
  9. Sudhindra Aithal

    Hi,
    Thanks for an excellent blog. I have been following your blog and your discussions in FB for over a year now.
    I had a question related to low stress retirement calculator. When I change my retirement age from 60 to 45, the Total corpus reduces. I have kept my "age to live" constant. Why does it reduce? I would expect it to increase considering I have lesser years to earn.

    Reply
    1. pattu

      Thank you. Excellent observation! If you retire early, you will have lower expenses initially, while the corpus will have more time to compound if invested. Hence the total corpus required will be lower.

      Reply
      1. Sudhindra Aithal

        Thanks for the reply. I am still not able to understand.

        In both scenarios(retiring at 45 and at 60), the corpus if invested will grow from age 45. When I retire at 45, I am withdrawing from the corpus whereas when I retire at 60, I am adding to the corpus(from age 45 to 60). Both have to last till age 90. So the corpus for retirement age 45 must be bigger. Thank you for your patience to explain 🙂

        Reply
        1. pattu

          We are calculating the corpus that will last from age 45 to 90 (say) and from age 60 -90.
          The initial withdrawals for age 45 is much lower and the corpus can grow relatively untouched for longer. Hence 45 requires lower corpus. Here we do not consider the investment me make but only the investment needed! I will write a detailed post on this tomorrow. Thanks for the nice idea!

          Reply
          1. Sudhindra Aithal

            I think I get it now. My mistake was to assume that in both scenarios, at age 45 the corpus would be the same. Once I realized my mistake, your explanation made sense. Thanks again and will look forward to the post 🙂

  10. Sudhindra Aithal

    Hi,
    Thanks for an excellent blog. I have been following your blog and your discussions in FB for over a year now.
    I had a question related to low stress retirement calculator. When I change my retirement age from 60 to 45, the Total corpus reduces. I have kept my "age to live" constant. Why does it reduce? I would expect it to increase considering I have lesser years to earn.

    Reply
    1. pattu

      Thank you. Excellent observation! If you retire early, you will have lower expenses initially, while the corpus will have more time to compound if invested. Hence the total corpus required will be lower.

      Reply
      1. Sudhindra Aithal

        Thanks for the reply. I am still not able to understand.

        In both scenarios(retiring at 45 and at 60), the corpus if invested will grow from age 45. When I retire at 45, I am withdrawing from the corpus whereas when I retire at 60, I am adding to the corpus(from age 45 to 60). Both have to last till age 90. So the corpus for retirement age 45 must be bigger. Thank you for your patience to explain 🙂

        Reply
        1. pattu

          We are calculating the corpus that will last from age 45 to 90 (say) and from age 60 -90.
          The initial withdrawals for age 45 is much lower and the corpus can grow relatively untouched for longer. Hence 45 requires lower corpus. Here we do not consider the investment me make but only the investment needed! I will write a detailed post on this tomorrow. Thanks for the nice idea!

          Reply
          1. Sudhindra Aithal

            I think I get it now. My mistake was to assume that in both scenarios, at age 45 the corpus would be the same. Once I realized my mistake, your explanation made sense. Thanks again and will look forward to the post 🙂

  11. SA

    HI Pattu.. First of all thanks for the awesome blog - its eye opener.Looking tat numbers you remain focussed. Dont we need to consider investments in real estate here? May be look for reverse mortgage too as safety margin?

    Reply
  12. Ganesh

    This is amazing. You have outdone yourself with this calculator (that itself is saying something)!! Thanks again.

    Reply
  13. Ramakrishna

    Sir, What does " Monthly investment required" in sheet 3 represent? Is it the amount that is required to meet the retirement goal or is it the additional amount required over the existing investments? ( though there is no cell where we give details of present monthly investments apart from PF). Got a bit confused. TIA, Ramakrishna. P.S: Online version looks wonderful. Looking forward to seeing more of your calculators online as well.

    Reply
      1. Ramakrishna

        Thank you. Another doubt - you have given the split up of the investment required. Does this include the PF amount/month given earlier in sheet 2? You have this "Tax-free Debt" included in the split up of the total monthly investment required.

        Reply
  14. Mr. Satarawala

    Pattu ji

    Excellent effort as usual. Really like it.

    Since 2001 I am paying premiums in the original Jeevan Suraksha (Table No. 122) which guarantees a monthly pension when I am 57 till death. LIC closed this version of Jeevan Suraksha (Table No. 122) plan in 2002 as it was not possible to sustain the specified guaranteed monthly pension.

    Would it be a good idea to incorporate data fields for pension received from a guaranteed deferred Annuity plan in your excel file ?

    Thanks for a providing a great calculator.

    Reply

Do let us know what you think about the article