Sample Financial Plan

by Gopal Gidwani on April 18, 2011 · 6 comments

in Financial Planning

Financial Plan for Mr. ABC

Current Details
Mr. ABC is 29 years old. He is married. The couple together is currently drawing a net monthly salary of Rs 80,000. Out of this Mr. ABC sends Rs 15000 every month to his parents. Their current monthly expenses are Rs 22000 (which includes rent of Rs 10,000 a month). So after deducting Rs 37,000 (Rs 15000 for parents + Rs 22000 for expenses and rent) the couple is left with Rs 43,000 per month for their investments and meeting their financial goals.

Current Investments and Insurance
1) Mr ABC has invested in an Endowment Policy which gives him a cover of Rs 10,00,000 since 2006. The half yearly premium for this policy is Rs 6000. The tenure of this policy is 15 years.

2) Mr. ABC has invested in 2 term insurance policies giving him a total sum assured of Rs 56 Lacs (Rs 38 Lacs and Rs 18 Lacs). The annual premium for the 2 policies together is Rs 12000 (Rs 7000 and Rs 5000).

3) Mr. ABC and his wife don’t have any health insurance cover

4) Mr. ABC has taken SIPs of Equity Linked Savings Schemes (ELSS) for tax saving purpose. The monthly investment amount is Rs 3000 (Rs 2000 and Rs 1000).

5) Mr. ABC has liquid cash of Rs 1,08,000 in his Savings Bank Account

6) Mr. ABC has gold jewellery worth Rs 2,00,000.

Financial Goals
Mr. ABC has the following financial goals
1) 3 years from now Mr. ABC wants to buy a house worth Rs 45 lacs. For that he wants to start accumulating the 20% margin money of Rs 10 Lacs from now onwards and fund the remaining amount through a home loan

2) Mr. ABC does not have a kid now. He plans to have a kid 3 years from now. But Mr. ABC wants to start investing for the kid’s education (PG Course) and marriage right now itself. Mr. ABC wants to start building an education fund for the child’s PG Course which will cost Rs 15 lacs at today’s costs.

3)  Mr. ABC want to start building a marriage fund for the child’s marriage which will cost Rs 12 lacs at today’s costs.

4)  Mr. ABC wants to enjoy an annual vacation with family for which he plans to have an annual fund of Rs 50,000

5)  Mr. ABC wants to have a retirement fund of Rs 2 crores when he retires.

Solution
Mr. ABC has been suggested the following Financial Plan to help him meet his Financial Goals

Step 1: Emergency / Contingency Fund
As a first step towards financial planning Mr. ABC is required to build an emergency / contingency fund for any emergencies like job change or job loss or loss of income due to any other reason. The reserve fund should be 3 to 6 times of monthly income. So in case of Mr. ABC this fund should be Rs 2,40,000 (Rs 80,000 X 3) to 4,80,000 (Rs 80,000 X 6). Mr. ABC is advised to have a reserve fund of Rs 3,00,000. He already has cash balance of Rs 1,08,000 in his bank savings account and gold worth Rs 2 Lakhs. He can accumulate the remaining amount and invest this amount in a Flexi Deposit Account (Fixed Deposit cum Savings Account). These bank accounts provide liquidity (customer can withdraw entire money or partial withdrawal anytime) of a savings account and till the time the money is with the bank, they provide high returns of a fixed deposit. Nowadays all banks have a Flexi Deposit product which acts as a Fixed Deposit cum Savings Account. Some of the banks providing this product are:

  • IDBI Bank – Sweep-in Savings Account
  • Axis Bank – Encash 24
  • Union Bank – Union Flexi Deposit
  • HDFC Bank – Super Saver Facility
  • Bank of India – BOI Savings Plus Scheme
  • Oriental Bank of Commerce – Flexi Fixed Deposit Scheme
  • State Bank of India – Multi Option Deposit Scheme
  • Allahabad Bank – Flexi-Fix Deposit
  • Bank of Maharashtra – Mixie Deposit Scheme
  • Corporation Bank – Money Flex
  • United Bank of India – United Bonanza Savings Scheme

Step 2: Insurance
As a 2nd step towards financial planning Mr. ABC should ensure that he has adequate life insurance cover for himself and his wife and health insurance for both of them.
Mr. ABC is 29 years old today. He and his wife have a working life span of 31 years ahead of them. In these 31 years if their annual net income of Rs 9,60,000 (Rs 80,000 X 12) goes on increasing by 5% then the total amount that they will earn in these 31 years will be equal to Rs 6,79,30,358 (Rs 6.80 crores approx). Hence Mr. ABC and wife are advised to take Life Insurance cover of atleast Rs 1 crore each.

Age Year Annual Income at the beginning of the Year Annual Growth Annual Income at End of the Year Total Income of all Years in Lakhs
30 2011 0 0% 960000 9.60
35 2016 1166886 5% 1225230.3 65.30
40 2021 1489275.087 5% 1563738.842 136.39
45 2026 1900734.335 5% 1995771.052 227.11
50 2031 2425872.188 5% 2547165.797 342.90
55 2036 3096095.946 5% 3250900.743 490.69
60 2041 3951490.172 5% 4149064.68 679.30

 

PJ Total Income Growth Sample Financial Plan

Term Insurance: Mr. ABC already has term insurance worth Rs 58 Lacs. He can go for an additional term insurance cover of Rs 50,00,000. He can convert the Endowment Policy into a paid up policy. He is also advised to buy a term policy of 1 crore for his spouse.
For a Term Policy of Rs 50 Lacs for 25 years the annual premium for Mr. ABC (29 Years) will be in the range of Rs 5500 to Rs 6500. Some of the plans that Mr. ABC can choose from are

Name of the Plan Annual Premium
MetLife MetProtect Plan Rs 5150
Aegon Religare iTerm Plan Rs 5250
ICICI Prudential iProtect Plan Rs 5350
Kotak ePreferred Term Plan Rs 5763

 
* The above premiums have been calculated from the respective company website. In case of the 1st three plans the premiums are exclusive of service tax whereas in case of Kotak ePreferred Term Plan the website does not specify whether the premium is inclusive or exclusive of service tax.
A term plan of Rs 1 crore for Mr. ABC’s spouse for 25 years will cost Rs 10,000 or so per annum.

Health Insurance
Mr. ABC is advised to go for a Family Floater Plan for a cover of Rs 3,00,000 to start with and in the later stages this cover can be increased to Rs 5,00,000 or more. Mr. ABC can choose from the below 2 plans:

a)      Apollo Munich Easy Health Plan (Standard): For a Family Floater cover of Rs 3,00,000 for 2 adults the premium is Rs 4924 (inclusive of service tax). Maternity benefit is available in ‘Exclusive’ variant and after a waiting period of 4 years. Under the Apollo Munich Easy Health Plan (Exclusive) the premium for Rs 4,00,000 cover is Rs 7280 (inclusive of service tax).

b)     Max Bupa HeartBeat Silver: For a Family Floater cover of Rs 3,00,000 for 2 adults the premium is Rs 7193 (inclusive of service tax).

Both the companies offer life long renewal and also there is no loading in case of claims. The difference is Apollo Munich follows an age slab-wise method of charging premium. So as long as the person is in a particular age slab the premium remains same and when the person moves from one age slab to another age slab the premium increases as per the new age slab. The premiums for all age slabs are put upfront by Apollo Munich on their brochures and on their website in writing. Max Bupa does not follow the age slab method of premium. They increase the premium every year on renewal. But how much will they increase the premium every year on renewal is not specified.

Step 3: Child Education Fund
Mr. ABC plans to have a kid 2 years from now but he plans to start saving for the kid’s education (PG Course) from now itself. If the kid is planned 2 years from now the money for the kid’s PG Course will be required 22 years from now when the kid turns 20 years old. Mr. ABC wants to build a Child Education Fund at today’s costs of Rs 15 lacs. If the course costs Rs 15 lacs today and education costs increase at the rate of 10% every year (inflation) the same course will cost a whopping Rs 1.22 crores (Rs 1,22,10,412) 22 years from now in the year 2032.

If Mr. ABC wants to accumulate Rs 1.22 crores in 22 years (Year 2032) from now he will have to start with an investment of Rs. 83,176 (Rs 6,931 monthly) in the 1st year from the Year 2011 beginning and go on increasing the annual investment amount by 5% every year (compounded) with the 5% increase in his annual income. The annual return expected is 12%.

Annual Investment Plan Growing @ 5% pa (Compounded)
Year Sr. No. Year Balance C/F from Previous Year Annual Investment during Year Total Fund Value at the end of the Year (12% return)
1 2011 0.00 83176.74 93157.95
2 2012 93157.95 87335.58 202152.75
3 2013 202152.75 91702.36 329117.72
4 2014 329117.72 96287.47 476453.81
5 2015 476453.81 101101.85 646862.34
6 2016 646862.34 106156.94 843381.59
7 2017 843381.59 111464.79 1069427.95
8 2018 1069427.95 117038.03 1328841.89
9 2019 1328841.89 122889.93 1625939.63
10 2020 1625939.63 129034.42 1965570.94
11 2021 1965570.94 135486.14 2353183.94
12 2022 2353183.94 142260.45 2794897.72
13 2023 2794897.72 149373.47 3297583.74
14 2024 3297583.74 156842.15 3868956.99
15 2025 3868956.99 164684.26 4517678.20
16 2026 4517678.20 172918.47 5253468.27
17 2027 5253468.27 181564.39 6087236.58
18 2028 6087236.58 190642.61 7031224.69
19 2029 7031224.69 200174.74 8099167.37
20 2030 8099167.37 210183.48 9306472.95
21 2031 9306472.95 220692.65 10670425.47
22 2032 10670425.47 231727.29 12210411.09

PJ Child Education Fund Sample Financial Plan

Step 4: Child Marriage Fund
Mr. ABC plans to get his child married when he / she turns 23 years old. Mr. ABC plans to start saving and investing for the kid’s marriage from now itself. The marriage is planned in the year 2035. According to Mr. ABC a normal wedding as on today costs Rs. 12 lacs and wants to start investing accordingly. If the marriage costs Rs. 12 lacs as on today and if the marriage costs go on increasing at the rate of 10% (inflation) every year then the same marriage 25 years down the line will cost a staggering Rs. 1.30 crores (Rs 1,30,01,647.13).

If Mr. ABC wants to accumulate Rs 1.30 crores in 25 years (2035) from now he will have to start with an investment of Rs 59690 (Rs 4974 monthly) in the 1st year from the year 2011 beginning and go on increasing this investment by 5% every year (compounded). The annual return on investment expected is 12%.

Annual Investment Plan Growing @ 5% pa (Compounded)
Year Sr. No. Year Balance C/F from Previous Year Annual Investment during Year Total Fund Value at the end of the Year
1 2011 0.00 59690.00 66852.80
2 2012 66852.80 62674.50 145070.58
3 2013 145070.58 65808.23 236184.26
4 2014 236184.26 69098.64 341916.84
5 2015 341916.84 72553.57 464206.86
6 2016 464206.86 76181.25 605234.68
7 2017 605234.68 79990.31 767451.98
8 2018 767451.98 83989.82 953614.82
9 2019 953614.82 88189.32 1166820.64
10 2020 1166820.64 92598.78 1410549.75
11 2021 1410549.75 97228.72 1688711.89
12 2022 1688711.89 102090.16 2005698.29
13 2023 2005698.29 107194.66 2366440.10
14 2024 2366440.10 112554.40 2776473.84
15 2025 2776473.84 118182.12 3242014.67
16 2026 3242014.67 124091.22 3770038.60
17 2027 3770038.60 130295.78 4368374.52
18 2028 4368374.52 136810.57 5045807.30
19 2029 5045807.30 143651.10 5812193.41
20 2030 5812193.41 150833.66 6678590.32
21 2031 6678590.32 158375.34 7657401.53
22 2032 7657401.53 166294.11 8762539.12
23 2033 8762539.12 174608.81 10009605.68
24 2034 10009605.68 183339.25 11416098.33
25 2035 11416098.33 192506.22 13001637.09

 

PJ Child Marriage Fund Sample Financial Plan

Step 5 Others
Here in this section Mr. ABC primarily has to take care of 3 things

  • Annual Child School Expenses
  • Home Loan Margin Fund
  • Annual Vacation Fund

Here is the plan for each of the above 3

a) Annual Child School Expenses: Mr. ABC expects to have a baby 2 years from now in 2013. In 2015 when the baby turns 3 years old it is expected to start going to school in Pre-Nursery. The annual education cost assumed is Rs 50,000 which is expected to go on increasing by 5% every year. Mr. ABC will have to fund this cost every year from his annual salary cash flows.

Year Child Age School Standard Child School Expenses
2011 - - 0.00
2012 - - 0.00
2013 1 Year - 0.00
2014 2 Years - 0.00
2015 3 Years Pre-School 50000.00
2016 4 Years KG 52500.00
2017 5 Years KG 55125.00
2018 6 Years 1st Standard 57881.25
2019 7 Years 2nd Standard 60775.31
2020 8 Years 3rd Standard 63814.08
2021 9 Years 4th Standard 67004.78
2022 10 Years 5th Standard 70355.02
2023 11 Years 6th Standard 73872.77
2024 12 Years 7th Standard 77566.41
2025 13 Years 8th Standard 81444.73
2026 14 Years 9th Standard 85516.97
2027 15 Years 10th Standard 89792.82
2028 16 Years 11th Standard 94282.46
2029 17 Years 12th Standard 98996.58
2030 18 Years 1st Year College 103946.41
2031 19 Years 2nd Year College 109143.73
2032 20 Years 3rd Year College 114600.92

 
b) Home Loan Margin Fund:
Mr. ABC wants to buy a home valued at Rs 45 Lakhs. For this he will have to make a down payment of 20% margin money which will be around Rs 10 Lacs. From his annual salary cash flow Mr. ABC has to take care of things like his annual living expenses, annual house rent, annual vacation fund, annual insurance premiums (life and health) and at the same time he wants to get started with his investments for child education, child marriage and his retirement. After providing for all the above and the contingency reserve fund; whatever is left Mr. ABC can put in a ‘Home Loan Margin Fund’.

On analysing Mr. ABC cash flows and all his expenses and investments we realise that Mr. ABC will take 5 years to build the ‘Home Loan Margin Fund’ of Rs 10 Lacs. At the end of the 5th year this fund will have a balance of Rs 10,83,494. Mr. ABC can make the 20% down payment and finance the remaining amount through a home loan. Assuming that Mr. ABC will go for a home loan of 35 lacs @ 10% interest for 20 Years; the EMI will work out to Rs 33,496 which will lead to an annual cash outflow of Rs 4,01,952 which Mr. ABC will be able to fund from his annual salary cash flow.

c) Annual Vacation Fund
Mr. ABC wants to go for a vacation every year with his family for which he wants to set aside Rs 50,000 every year. We have assumed that the vacation cost will go on increasing by 5% every year. Mr. ABC can finance his annual vacation from his annual salary cash flows. His vacation fund over the years will look like this

Mr. ABC’s Age Year Vacation Cost
29 2011 50000.00
30 2012 52500.00
31 2013 55125.00
32 2014 57881.25
33 2015 60775.31
34 2016 0.00
35 2017 67004.00
36 2018 0.00
37 2019 73872.00
38 2020 77565.60
39 2021 81443.88
40 2022 85516.07
41 2023 89791.88
42 2024 94281.47
43 2025 98995.55
44 2026 103945.32
45 2027 109142.59
46 2028 114599.72
47 2029 120329.70
48 2030 126346.19
49 2031 132663.50
50 2032 139296.67
51 2033 146261.51
52 2034 153574.58
53 2035 161253.31
54 2036 169315.98
55 2037 177781.78
56 2038 186670.86
57 2039 196004.41
58 2040 205804.63
59 2041 216094.86
60 2042 226899.60

 
In the year 2016 there is no provision made for a vacation as in this year Mr. ABC will be going in for a home loan and the EMI on that will considerably increase his monthly financial outgo and spending money on a vacation in that year will put lot of pressure on his finances. So Mr. ABC can skip the annual vacation in 2016 and in 2018.

In 2018 also if Mr. ABC chooses to go for a vacation his emergency / contingency fund will fall considerably. So it will be better for Mr. ABC to skip the annual vacation in 2018.

We have not provided for vacation post the age of 60 but if Mr. ABC desires to continue with the annual vacations he can do so as he will have sufficiently cash to continue with annual vacations for the next few years post retirement.

Step 6: Retirement Fund
The current monthly expenses of Mr. ABC are Rs 15000. The annual expenses are Rs 1,80,000. The annual expenses are expected to grow at the rate of 7% (inflation) every year. At this rate by the time Mr. ABC retires 31 years down the line; his annual expenses in the 60th year (retirement year) will increase to Rs 14,66,120.

Post retirement Mr. ABC is expected to live for another 20 years (life expectancy 80 years). During these 20 years (post retirement) if his annual expenses increase by 5% every year (with expenses at Rs 14.66 lacs in the retirement year) then the present value of Mr. ABC expenses at the beginning of his retirement will be Rs 2,27,34,528 (Rs 2.27 crores). This is the retirement corpus (Rs 2.27 crores) that Mr. ABC needs to sustain his expenses during his retirement years when his annual salary income will stop. During the retirement years Mr. ABC can invest the corpus of Rs 2.27 crore in debt instruments which can give him an annual return of 8%. By the time Mr. ABC turns 80 years old this fund will get exhausted.

To achieve the retirement corpus of Rs 2.27 crores by the age of 60 years, Mr. ABC will have to start with an investment of Rs 48,968 (Rs 4080 monthly) in the 1st year from the year 2011 beginning and go on increasing this investment by 5% every year (compounded). The annual return on investment expected is 12%.

Annual Investment Plan Growing @ 5% pa (Compounded)
Year Sr. No. Year Balance C/F from Previous Year Annual Investment during Year Total Fund Value at the end of the Year
1 2011 0.00 48968.00 54844.16
2 2012 54844.16 51416.40 119011.83
3 2013 119011.83 53987.22 193758.93
4 2014 193758.93 56686.58 280498.98
5 2015 280498.98 59520.91 380822.27
6 2016 380822.27 62496.96 496517.53
7 2017 496517.53 65621.80 629596.06
8 2018 629596.06 68902.89 782318.83
9 2019 782318.83 72348.04 957226.89
10 2020 957226.89 75965.44 1157175.41
11 2021 1157175.41 79763.71 1385371.81
12 2022 1385371.81 83751.90 1645418.56
13 2023 1645418.56 87939.49 1941361.02
14 2024 1941361.02 92336.47 2277741.18
15 2025 2277741.18 96953.29 2659657.81
16 2026 2659657.81 101800.96 3092833.81
17 2027 3092833.81 106891.00 3583691.80
18 2028 3583691.80 112235.55 4139438.63
19 2029 4139438.63 117847.33 4768160.28
20 2030 4768160.28 123739.70 5478927.97
21 2031 5478927.97 129926.68 6281917.21
22 2032 6281917.21 136423.02 7188541.05
23 2033 7188541.05 143244.17 8211599.45
24 2034 8211599.45 150406.38 9365446.52
25 2035 9365446.52 157926.69 10666178.00
26 2036 10666178.00 165823.03 12131841.15
27 2037 12131841.15 174114.18 13782669.97
28 2038 13782669.97 182819.89 15641348.65
29 2039 15641348.65 191960.88 17733306.67
30 2040 17733306.67 201558.93 20087049.48
31 2041 20087049.48 211636.87 22734528.71

PJ Retirement Fund Sample Financial Plan

The below chart gives details of all the investments and expenses of Mr ABC. In short the chart gives a complete snapshot of Mr. ABC’s Financial Planning which we have discussed above in the entire article.

Comprehensive Financial Plan Sample Financial Plan

For any comments on the above article please comment in the below comments section or write to us at
gopal_gidwani@yahoo.com

No related posts.

{ 5 comments… read them below or add one }

Anand Rithi July 26, 2012 at 5:06 am

Dear Sir,

Please give the article for Salary amount of 10,000 to 15,000 salary slab

Reply

Gopal Gidwani July 29, 2012 at 1:22 pm

Hello Mr Anand,
It will be difficult to give a financial plan for different salary slabs. But you can write to me at gopal_gidwani@yahoo.com with your financial goals and I will help you.

Reply

SATYA SURI August 16, 2012 at 7:24 am

Dear Gopal jee,

I am looking for a comprehensive Health Insurance for my family. My age is 37, wife’s age is 36, son is 15 and daughter is 8 years.

I had seleced Max Bupa.. But CONFUSED about HEARTBEAT and FAMILY FIRST ?? and difference between SILVER & GOLD option.

Can you advise me upon that or some other good and best product avaliable..

Thanks & Regards
Satya

Reply

Gopal Gidwani August 20, 2012 at 11:53 am

Hello Mr. Satya,
I am not an expert in health insurance and it will not be right on my part to comment on health insurance policies. I suggest you get in touch with some health insurance expert like MediManage. They will be the right people to guide you on health insurance

Reply

shina afzal December 6, 2012 at 1:45 pm

hi sir, i need your help for making a comprehensive financial plan i m even ready to pay for it.. if you can help me by tommorow’s morning also it is for Australian fiancial planning

Reply

Leave a Comment

Previous post:

Next post: