Arthgyaan

Supporting everyone's personal finance journey

Low-stress retirement planning calculations: worked out example

This article shows a simple retirement and review plan that anyone can follow in a step-by-step manner.

Low-stress retirement planning calculations: worked out example


Posted on 03 Aug 2022
Author: Sayan Sircar
11 mins read
📢Join 3500+ readers on WhatsApp and get new post notifications!

This article shows a simple retirement and review plan that anyone can follow in a step-by-step manner.

Low-stress retirement planning calculations: worked out example

📚 Topics covered:

Retirement is the hardest problem in finance

“nastiest, hardest problem in finance.” - William Sharpe, Nobel Prize winner in Economics, regarding the withdrawal stage of retirement

Retirement planning becomes difficult for many people because of the sheer number of assumptions and decisions that go into it:

  • how much to invest (is it 50% of my take home? is 20% enough? am I investing enough? and the variations of the same)
  • how to start investing: sometimes, the first step is the hardest, given the number of assumptions: how long will retirement last, will there be enough money, what about children and their needs etc
  • where to invest: there are 10,000+ mutual funds, 5,000+ stocks and other options like RBI bonds, NCD, ULIPs, provident funds, FD etc. The sheer number of choices is overwhelming
  • once you start investing, how should you check and review your plan to know if you are on track or not

In this article, we will follow up on our previous post: A low-stress step-by-step guide to creating a retirement portfolio, covering the exact sequence of steps to create a retirement portfolio, review it and manage it until retirement.

Using the following numbers, we will use the comprehensive goal-based investing calculator to find out the SIP amount:

  • 25 years to retirement
  • 40 years in retirement
  • 10L/year lifestyle expenses in retirement in today’s money, i.e. approx ₹80,000/month
  • 7% inflation before and after retirement
  • 11% and 4% post-tax equity and debt returns respectively (equity return is 3% above inflation, debt return is 3% below inflation) i.e. the same numbers as this post on lifetime returns for retirement
  • 10% increment of the SIP amount with a yearly review

The investor has ₹30L in assets currently held in a mix of NPS, provident funds and mutual funds tagged to retirement

In this article, we have considered only the retirement goal. In reality, you will have multiple goals which you need to do together: children’s college or marriage, house purchase, vehicles, early retirement etc. We have a series of case studies that cover a few such cases:

Expense structuring

(click to open in a new tab)
Case Study 03 Aug 22 Expense Calculation

We will use this retirement expense estimation tool to calculate today’s expenses and determine how much to spend in retirement.

To know how much you can invest for goals (the investible surplus), you need to classify and figure out approximately the major monthly expense heads under the three main buckets below. Some of these will persist in retirement while the rest will reduce or disappear completely. Some of these, like medical expenses or travel, may increase.

  • mandatory: rent/EMI, food, school fees, domestic help, electricity/mobile bills etc
  • variable/discretionary: entertainment, transport, clothes, anything discretionary
  • save-to-spend: these are used for the sinking fund that is used to pay for hefty annual expenses like insurance premiums, festival gifts and travel by saving for them every month

We have assumed that the lifestyle in retirement will be 20% better, as an aspirational value, compared to today. This assumption bumps up the retirement corpus from ₹8.33 lakhs to ₹10 lakhs.

Here is a simple way to estimate the retirement corpus: How much money do you need for retirement?

Did you know that we have a private Facebook group which you can join for free and ask your own questions? Please click the button below to join.

Derivation of investment amounts

(click to open in a new tab)
Case Study 03 Aug 22 Model Output

The table shows the SIP amount for the goal. Investors have two approaches to investing:

Model output

We use the Arthgyaan Goal-based investing calculator to formulate the investment model with all the above assumptions and goals.

We use the Arthgyaan Goal-based investing calculator to formulate the investment model with all the above assumptions and goals. There is a link to download a pre-filled copy of the Google sheet via the button below.

Important: You must be logged into your Google Account on a laptop/desktop (and not on a phone) to access the sheet.

Once you get your sheet, you can access video tutorials in the howto tab.

Here are some tutorials on using the tool (click the image below)
Goal-based-investing tool playlist

We see that the target retirement corpus is ₹18.76 crores. This is a huge figure but we need to keep in mind that there are 25 years to go. Time is the investor’s friend and as long as these avoidable mistakes are not made, things will be fine.

SIP amount for retirement

(click to open in a new tab)
Case Study 03 Aug 22 SIP Output

Also read
What is MFCentral and why you should be using it?

Where to invest?

For most investors, this is the most critical question. It is a variation of finding the ‘best’ of everything: the best mutual fund, PMS service, insurance policy, etc. However, if you have followed the process until now, you will realise that coming to this stage is the very end of the goal-based investing strategy.

We will keep this simple with some typical investments that the family can follow and should be sufficient for their purpose.

Allowed investments

  • Equity asset class: Index mutual funds. Here is an article that talks about this choice: Which index funds to invest in and why?
  • Debt asset class: Apart from the NPS and provident fund investments already in place, the family can explore debt mutual funds: How to choose a debt mutual fund?
  • Cash asset class: For goals within three years and the emergency fund, a savings bank with sweep FD or a regular FD/RD is sufficient. For purposes beyond three years, please use the same debt funds as per the debt allocation above.

Disallowed investments

  • NPS: The family should not invest any amount in NPS beyond the minimum needed to get a deduction under Section 80CCD, i.e., ₹50,000/year and any amount under Corporate NPS. The logic here is that NPS locks in your money until 60 and requires that you invest 40% of your NPS corpus in an undesirable taxable annuity.
  • Additional investment in Provident fund: Apart from the mandatory investments via EPF, the family should refrain from additional investment in VPF. Given the long time horizon of the goals, a high allocation to equity is critical.
  • Insurance mixed with investment: ULIP, endowment, and related mixed products should be avoided due to high commissions, opaque structure, low returns, and lock-ins.
  • Other options: Cryptocurrencies, P2P loans, direct stocks, and investment real estate/land (except a primary residence) should be avoided.

Portfolio review

As time passes, three things happen:

  • Markets move up and down
  • You invest or remove money from the portfolio
  • Current prices of goals change, or new goals are added/old goals removed

These factors will require a portfolio review exercise every 6-12 months. Then, the process goes through the above steps: goal setting, capturing current asset values, and feeding them into the model to recalculate the numbers. The concept is explained here: Are your investments on track for your goals?

Rebalancing plan

(click to open in a new tab)
Case Study 03 Aug 22 Rebalancing Plan

This section shows the current and target asset allocations for equity, debt and cash. The action on the investor will be to immediately implement the rebalancing plan as shown in the image.

Once you create a portfolio using the method described in this article, you can reach surprisingly large values: How big will your portfolio grow in retirement?.

Related Articles

What's next? You can join the Arthgyaan WhatsApp community

You can stay updated on our latest content and learn about our webinars. Our community is fully private so that no one, other than the admin, can see your name or number. Also, we will not spam you.

For resident Indians 🇮🇳:


For NRIs 🇺🇸🇬🇧🇪🇺🇦🇺🇦🇪🇸🇬:


Share on WhatsApp:

To understand how this article can help you:

If you have a comment or question about this article

The following button will open a form with the link of this page populated for context:

If you liked this article, please leave us a rating

The following button will take you to Trustpilot:

Discover an article from the archives

Previous and next articles:



Latest articles:



Topics you will like:



Next steps:

1. Email me with any questions.

2. Use our goal-based investing template to prepare a financial plan for yourself.

Don't forget to share this article on WhatsApp or Twitter or post this to Facebook.

Discuss this post with us via Facebook or get regular bite-sized updates on Twitter.

More posts...

Disclaimer: Content on this site is for educational purpose only and is not financial advice. Nothing on this site should be construed as an offer or recommendation to buy/sell any financial product or service. Please consult a registered investment advisor before making any investments.

This post titled Low-stress retirement planning calculations: worked out example first appeared on 03 Aug 2022 at https://arthgyaan.com


We are currently at 504 posts and growing fast. Search this site:
Copyright © 2021-2024 Arthgyaan.com. All rights reserved.