« Set a goal before looking for what to invest in How do you get from goal to SIP amount: Part 2 »

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

Posted on 04 Jun 2021
Author: Sayan Sircar

Tags: Set Goals ; Calculator

6 mins read

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

How do you get from goal to SIP amount

📚 Topics covered:

Asset allocation and target return for a goal
Find the SIP amount for a goal
After one year of running the SIP
Does this process work in real life?
- Single case of a 15-year goal
- For all maturities
How to implement this process in practice?
A note on having the pre-requisites in place
All posts in this series

Asset allocation and target return for a goal

We have already covered

In this example, we will consider a single payment goal like a foreign vacation, buying a car, kid’s marriage or for the down-payment of a house.

Taking the example of a house down-payment as a goal, let us construct this example:

Asset allocation: equity = 30%, debt = 70% « comes from the risk profile of the goal
Horizon (H): 10 years « the house will be bought after 10 years
Cost today (C): 20 lakhs « the down-payment is for 20 lakhs if bought today
Inflation (I): 5% « the house price is expected to rise at this rate
Lump-sum available (L): 3 lakhs « money available for investment today
Investment return (R): 4.63%/year « the average return over the next 10 years [we will cover getting to this number in a future post]
SIP amount will be increased by 10% every year which keeps the starting amount for the goal lower and let it increase with time

Recent articles:

1 / 3

<p>This article describes how to use the Arthgyaan goal-based investing tool as a calculator to determine if switching to the New Tax Regime makes sense.</p>

2 / 3

<p>This article describes a tweak that investors can implement to plan taxes more efficiently, given that non-equity funds will be taxed at slab rates after 1st April 2023.</p>

3 / 3

<p>This article shows the way forward for investors in debt, gold, hybrid and international funds which have lost indexation benefits on units purchased after 1st April 2023.</p>

❮ ❯

Join our 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.

Find the SIP amount for a goal

Future Value = Current Value * (1 + Inflation) ^ TIme_to_goal

When the house is actually bought, due to 5% inflation over 10 years the down-payment will be higher. Let us call this future value (F)

F = C * (1+I)^H = 20 * (1+0.5)^10 = 32.58 lakhs

So we need to invest monthly an amount of ₹ 12,089 (as per the calculator linked below) in equity and debt. Based on the return expectation of each of the funds chosen and the asset allocation, you can arrive at a return expectation for the investments as per this post: How much returns should you estimate for your goals?.

This is the SIP amount assuming constant investment every year. Typically people increase their investments every year by 10% and the same is assumed here. The starting value of L i.e. 3 lakhs should be invested via this method as per asset allocation (E=30%, Debt=70%) as per the choice of equity and debt funds.

Calculation of SIP amount for multiple goals

Once this is done, the following will be completed:

equity fund allocation of 30% of 3 lakhs = 0.9 lakhs in equity
debt fund allocation of 70% of 3 lakhs = 2.1 lakhs in debt
SIP of 30% of ₹ 12,089 = ₹ 3,627 in equity fund for 12 months
SIP of 70% of ₹ 12,089 = ₹ 8,463 in debt fund for 12 months

These calculations are explained in this Google Sheets workbook which has a few worked-out examples for more goals.

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 house to adjust the down payment etc.)
check the new asset allocation
re-balance between the equity and debt fund values

Repeat the steps in the “Find SIP amount for a goal” section above with these new values. See this detailed post for the process

This article is part of our Series on “How to purchase a home”:

How to calculate the SIP amount for the downpayment of your dream home? « this article
Should you sell your mutual funds to buy a house?
Goal-based investing: check if you can purchase your dream home
Where to save for the downpayment of a home?
Should you stretch to buy your dream home?
What is the best home loan tenure?

Does this process work in real life?

Single case of a 15-year goal

We show this example of a goal for which investment was started in 2007. Every year, the invested amount was increased by 10%, and the asset allocation was made more and more conservative over time. We can see how the equity allocation was reduced to zero as the goal moved closer.

How goal based investing has performed in the past

The key learning here is that the variability between the actual and theoretical portfolios slowly came close to zero over time.

For all maturities

How goal based investing has performed in the past for all maturities

We see that except for goals maturing before 2008, in all other cases, the return has been higher than the theoretical return like this:

Single-goal success ratio

But there has not been a single case where the ending value has been lower than the starting value:

How goal based investing has performed in the past for all maturities

How to implement this process in practice?

We have covered the practical aspects of investing for a goal like this in detail here: How to invest for a single goal using Target Date Funds in India?.

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 the 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:

What's next? You can join our 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.

Discover an article from the archives

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>The purpose of investing is to fulfill a life goal: set that first</p>

Set Goals Calculator

Set a goal before looking for what to invest in

The purpose of investing is to fulfill a life goal: set that first

Published: 3 June 2021

5 MIN READ

<p>Walk-through: Get SIP amount for a goal with multiple payments</p>

Set Goals Calculator

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

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

Published: 5 June 2021

3 MIN READ

Latest articles:

<p>This article compares how the PPF has performed against the SENSEX since 1979 to help investors decide if they should invest a lump sum in PPF in April 2023.</p>

Choosing Investments

SENSEX vs PPF report card 2023: should you invest 1.5 lakhs in PPF in April?

This article compares how the PPF has performed against the SENSEX since 1979 to help investors decide if they should invest a lump sum in PPF in April 2023.

Published: 2 April 2023

5 MIN READ

Tax Calculator

Should you choose the new tax regime from 1st April 2023?

This article describes how to use the Arthgyaan goal-based investing tool as a calculator to determine if switching to the New Tax Regime makes sense.

Published: 1 April 2023

4 MIN READ

Topics you will like:

Asset Allocation (19) Basics (8) Behaviour (10) Budgeting (10) Calculator (15) Case Study (3) Children (11) Choosing Investments (32) FAQ (4) FIRE (11) Gold (6) Health Insurance (4) House Purchase (14) Insurance (14) International Investing (8) Life Stages (2) Loans (9) Market Movements (10) Mutual Funds (25) NPS (5) NRI (5) News (6) Pension (6) Portfolio Construction (42) Portfolio Review (24) Real Estate (4) Retirement (33) Review (11) Risk (6) Safe Withdrawal Rate (5) Set Goals (26) Step by step (9) Tax (22)

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.