Arthgyaan

Supporting everyone's personal finance journey

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

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

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


05 Jun 2021 - Contact Sayan Sircar
3 mins read

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

Calculation of SIP amount

Table of Contents

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>This article uses the Arthgyaan Have vs Needs Framework to invest a large lump sum amount in your portfolio per your financial goals.</p>
How to invest a lump sum amount for your goals?
2 / 3
<p>This article shows you how the concept of indexation lowers the capital gains tax you pay when you sell debt mutual funds.</p>
Pay lower capital gains taxes for debt mutual funds: understand how indexation works
3 / 3
<p>This article lets you calculate if you should break your old FD and create a new one at higher interest rates after adjusting for premature breakage penalty.</p>
Should you break your FD and create a new one at new higher rates?

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.


Goal-based-investing plan

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:

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

Previous and next articles:

<p>Walk-through: Get SIP amount for single payment goal</p>
Set Goals Calculator
How do you get from goal to SIP amount: Part 1

Walk-through: Get SIP amount for single payment goal

Published: 4 June 2021

4 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

7 MIN READ


Latest articles:

<p>This article shows a way to decide what to do when stock markets reach all-time or lifetime highs. Should investors buy more or sell to book profits?</p>
Market Movements
The stock market has reached an all-time high. Should you buy or sell?

This article shows a way to decide what to do when stock markets reach all-time or lifetime highs. Should investors buy more or sell to book profits?

Published: 30 November 2022

4 MIN READ


<p>This article uses the Arthgyaan Have vs Needs Framework to invest a large lump sum amount in your portfolio per your financial goals.</p>
Portfolio Construction Mutual Funds
How to invest a lump sum amount for your goals?

This article uses the Arthgyaan Have vs Needs Framework to invest a large lump sum amount in your portfolio per your financial goals.

Published: 27 November 2022

5 MIN READ


Topics you will like:

Asset Allocation (17) Basics (8) Behaviour (10) Budgeting (9) Calculator (13) Case Study (3) Children (9) Choosing Investments (28) FAQ (3) FIRE (9) Gold (6) Health Insurance (4) House Purchase (13) Insurance (12) International Investing (8) Life Stages (2) Loans (10) Market Movements (8) Mutual Funds (14) NPS (5) NRI (4) News (5) Pension (6) Portfolio Construction (36) Portfolio Review (22) Retirement (29) Review (7) Risk (6) Safe Withdrawal Rate (5) Set Goals (26) Step by step (8) Tax (16)

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.

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 How do you get from goal to SIP amount: Part 2 first appeared on 05 Jun 2021 at https://arthgyaan.com


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