« How do you get from goal to SIP amount: Part 1 How do you get SIP amount for retirement: Part 3 »

How do you get from goal to SIP amount: Part 2

Posted on 05 Jun 2021
Author: Sayan Sircar

Tags: Set Goals ; Calculator

3 mins read
Get new post notifications on WhatsApp!

Walk-through: Get SIP amount for a goal with multiple payments

Calculation of SIP amount

📚 Topics covered:

Asset allocation and target return for a goal with several payments
After one year of running the SIP
A note on having the pre-requisites in place
All posts in this series

Asset allocation and target return for a goal with several payments

We have already covered

This post will deal with a goal like college education that has multiple payments using the framework built in the three posts linked above.

Assume the target goal is a 4-year college education due to start 10 years from now. The current costs are 5 lakhs per year for course fees and hostel, 3 lakhs for admission and 2 lakhs for industrial training at the beginning of the 4th year (i.e. total 25 lakhs) all expected to increase by 7% a year. Assume 4 lakhs is available today which is allocated to all 4 goals equally.

These are essentially 4 single payment goals:

Goal 1: Admission + Year 1: 8 lakhs in 10 years
Goal 2: Year 1: 5 lakhs in 11 years
Goal 3: Year 1: 5 lakhs in 12 years
Goal 4: Year 4 + training: 7 lakhs in 13 years

Using the single goal model the following SIP amounts are determined and the totals are added up as shown:

Calculation of SIP amount for multiple goals

The 25 lakhs initial cost of the goal is expected to be around 54 lakhs 10 years from now. The initial lump sum amount and SIP amounts are allocated to the four goals. A single set of SIPs are created: equity 6,000 and debt 10,000 along with lump sum investments in equity and debt of 1.5 lakhs and 2.5 lakhs respectively as per asset allocation. Refer to these posts for investing in equity and debt funds.

These calculations are explained in this Google Sheets workbook.

Recent articles:

1 / 3

<p>A quick retirement calculation for a reader query who has a good amount of corpus already saved for retirement.</p>

2 / 3

<p>This article explains the PFRDA announcement about a new default scheme under NPS Tier II for government employee subscribers.</p>

3 / 3

<p>As per SEBI rules, mutual fund investors must have nominees in their folios by 1st October 2023 or explicitly opt out. Otherwise they will face restrictions in selling units.</p>

❮ ❯

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.

After one year of running the SIP

The following needs to be done in this order:

find the new corpus (C) 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
Increase the SIP figure by 10% (or more, the model will tell you)

See this detailed post for the process for reviewing.

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)
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
no high-interest debt like credit card or personal loans

All posts in this series

Please see below:

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.

If you liked this article, please leave us a rating

The following button will take you to Trustpilot:

Discover an article from the archives

Worked out case studies for goal-based investing

Case study: how can this middle aged investor with two children plan for retirement and children's goals?

This article shows how a single-income middle aged couple with two small children reach their retirement and children’s goals.
Case study: can this double income single kid family reach FIRE at 50?

This article shows how a double-income couple with a 2-year old reach their FIRE dream at the age of 50.
Case study: how a family in their mid-30s with a newborn kid can FIRE and invest in real estate?

This article shows how a double-income couple with a newborn child can invest for their future goals of FIRE and real-estate investment.
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 the SIP amount for a single payment goal</p>

Set Goals Calculator

How do you get from goal to SIP amount: Part 1

Walk-through: Get the SIP amount for a single payment goal

Published: 4 June 2021

6 MIN READ

<p>Walk-through: Get SIP amount for retirement goal</p>

Set Goals Calculator

How do you get SIP amount for retirement: Part 3

Walk-through: Get SIP amount for retirement goal

Published: 5 June 2021

5 MIN READ

Latest articles:

<p>This article shows a handy ready reckoner for home loan EMI amounts for all tenures and interest rates along with the amount of principal and interest to be paid.</p>

House Purchase

How much EMI do I have to pay for my home loan?

This article shows a handy ready reckoner for home loan EMI amounts for all tenures and interest rates along with the amount of principal and interest to be paid.

Published: 29 September 2023

1 MIN READ

Retirement Reader Questions

How much money does this 39 year old investor need to invest per month to retire at 58?

A quick retirement calculation for a reader query who has a good amount of corpus already saved for retirement.

Published: 27 September 2023

7 MIN READ

Topics you will like:

Asset Allocation (20) Basics (8) Behaviour (10) Budgeting (11) Calculator (17) Case Study (6) Children (12) Choosing Investments (38) FAQ (6) FIRE (13) Gold (11) Health Insurance (4) House Purchase (17) Insurance (15) International Investing (10) Life Stages (2) Loans (9) Market Movements (13) Mutual Funds (29) NPS (6) NRI (13) News (9) Pension (8) Portfolio Construction (46) Portfolio Review (27) Reader Questions (6) Real Estate (6) Retirement (36) Review (12) Risk (6) Safe Withdrawal Rate (5) Set Goals (27) Step by step (14) Tax (37)

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.