« How do you get SIP amount for early retirement (RE): Part 4 Which funds should I invest in? »

How do you get SIP amount for complete portfolio: Part 5

07 Jun 2021 - Contact Sayan Sircar

Tags: Set Goals ; Calculator

5 mins read

Walk-through: Get SIP amount for all goals together

Calculation of SIP amount

We have already covered

We will now combine all of these together to cover all goals together in the family.

Assumptions made for calculations
After one year of running the SIP
A note on having the pre-requisites in place
All posts in this series

Assumptions made for calculations

when does retirement start
what is the rate at which the cost of goods and services increase with time i.e. inflation rate
how long does the retirement corpus last
what is the annual expenses in the first year of retirement if retirement happened today. Estimation of the expenses in retirement is covered in more detail here
each cash requirement in the future is modelled as a single goal with its own asset allocation and rebalancing plan. This is not a unified portfolio
risk profile is assumed the same for all goals: this is reflected in having the same asset allocation and rebalancing plan for all goals

Length of retirement

Typically for married couples, this is the life expectancy of the younger spouse and could be as 100 years nowadays. We need to adjust the duration of the retirement accordingly. The longer the duration (assumed 40 years in the Excel example), the more savings are needed every month.

Here each year of retirement is modelled as a separate goal. Naturally, once the retirement period ends, there is no money expected to be left for any heirs. If that is needed, please create a separate goal for that using this method.

Expenses estimation and inflation rate

One of the important assumptions will be the expenses in the first year of retirement (22 years from now in the example) assuming the retirement starts immediately. This needs to include expenses like housing, health insurance and travel and will assume no income. If pension or other income is present, then the expenses will be assumed beyond this income.

The model deals with a 36-year-old salaried individual with retirement at age 58 (22 years from now) who is also targeting retiring 5 years earlier. We will assume a figure for annual expenses if traditional retirement happened today (5 lakhs in the example), model it forward by 22 years of inflation (at 7%) and then use the figure to save for each year of early retirement.

These calculations are explained in this Google Sheets workbook.

How to use the sheet

Portfolio over time

All figures in red are assumptions and can be modified as per requirement
Allocate the corpus figures for all goals in column I (this is the total amount of investments you have)
Enter the current corpus figures in the Current asset allocation section for equity holdings and cash in the bank in savings / FD
Ensure that you have enough term insurance. The sheet shows you the minimum coverage amount keeping in mind the present value of goals yet to be saved and lifestyle expenses based on retirement levels for the period income will be present

Increasing SIP every year

A very important part of planning for a long term goal is increasing the monthly SIP amount as income increases. In the example, the increase is assumed to be 10%/year. The model handles rebalancing automatically by showing the amounts to be Invested and Redeemed and over time reduces the amount of equity exposure for each goal so that risk can be managed.

Recent articles:

1 / 3

<p>This article settles the question of which type of capital gain calculation is better - debt-type funds taxed at 20% with indexation vs equity-type at 10%.</p>

Which mutual fund has lower tax - international funds at 20 percent vs domestic at 10 percent?

2 / 3

<p>This article shows that if you decide to retire today, how long will the corpus last realistically based on real rates of return.</p>

How long will your money last if you retire today?

3 / 3

<p>This article shows you a simple set of rules for planning any financial goal: from a month to decades away via three buckets of assets.</p>

How to use the bucket theory to plan for your goals?

❮ ❯

After one year of running the SIP

The following needs to be done in this order:

find the new corpus which is the sum of the current value equity and debt fund values
review the goal parameters (new horizon is 1 year less, review the current cost of the goals to adjust for actual market inflation etc.)
re-balance between the equity and debt fund values as shown in the model

See this detailed post for the process for reviewing.

Our new Goal-based investing tool will help you to create and manage all of your goals in one place. Click the image below to get access:

Arthgyaan creates a system for reaching your financial goals by sharing simple, actionable advice backed by research and analysis.

Your email address will not be shared with anyone and you can unsubscribe anytime.

A note on having the pre-requisites in place

At all times ensure that you have the following in place

an emergency fund with 6-12 months of expenses
a term insurance policy (unless you are retired with no income). The sheet will also show you your minimum term insurance coverage amount
a health insurance policy (separate from the company provided one if any) for 10-15 lakhs as base policy with a 50-100 lakhs super-top up
a personal accident insurance coverage to safeguard against accidents where you do not die but cannot earn
no high-interest debt like credit card or personal loans

All posts in this series

Please see below:

If you liked this article, consider subscribing to new posts by email by filling the form below.

Worked out case studies for goal-based investing

Case study: how this double income recently married family can perform DIY goal-based investment planning

This article shows how a young just-married couple can invest for future goals using the Arthgyaan goal-based investing tool.
Case Study: How should couples in their 40s with a new baby plan their financial future?

Did you welcome a bundle of joy in your 40s? This article will discuss ways of planning the child’s (and your’s financial future)
Case study: how this double income single kid family can perform DIY goal-based investment planning

This article shows how a very typical salaried couple with one child can invest for future goals using the Arthgyaan goal-based investing tool.

Previous and next articles:

<p>Walk-through: Get SIP amount for early retirement (RE)</p>

Set Goals Calculator

How do you get SIP amount for early retirement (RE): Part 4

Walk-through: Get SIP amount for early retirement (RE)

Published: 6 June 2021

5 MIN READ

<p>Once goals are set, use this framework to choose funds</p>

Choosing Investments

Which funds should I invest in?

Once goals are set, use this framework to choose funds

Published: 8 June 2021

3 MIN READ

Latest articles:

<p>We discuss if it is a good idea for conservative NRI investors to create a retirement portfolio in India only with safe and risk-free investment options.</p>

NRI Retirement

Can NRIs retire in India with only safe investment options like a fixed deposit?

We discuss if it is a good idea for conservative NRI investors to create a retirement portfolio in India only with safe and risk-free investment options.

Published: 25 September 2022

8 MIN READ

Tax International Investing

Which mutual fund has lower tax - international funds at 20 percent vs domestic at 10 percent?

This article settles the question of which type of capital gain calculation is better - debt-type funds taxed at 20% with indexation vs equity-type at 10%.

Published: 21 September 2022

5 MIN READ

Topics you will like:

Asset Allocation (17) Basics (7) Behaviour (10) Budgeting (9) Calculator (11) Case Study (3) Children (7) Choosing Investments (24) FAQ (2) FIRE (9) Gold (6) Health Insurance (4) House Purchase (13) Insurance (11) International Investing (8) Life Stages (2) Loans (10) NPS (5) NRI (4) News (5) Portfolio Construction (34) Portfolio Review (20) Retirement (26) Review (7) Risk (6) Safe Withdrawal Rate (3) Set Goals (25) Step by step (6) Tax (15)

Next steps:

1. Email me with any questions.

2. Use our goal-based investing template to prepare a financial plan for yourself
OR
use this quick and fast online calculator to find out the SIP amount and asset allocation for your goals.

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.

Arthgyaan

Supporting everyone's personal finance journey