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 |

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 |

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 |

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 |

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.

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 }
Dear Sir,
Please give the article for Salary amount of 10,000 to 15,000 salary slab
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.
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
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
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