Financial Planning – Case Study

Prashant and Srividya Nair are a salaried couple staying in the central suburbs of Mumbai. Prashant works as a programmer for an IT firm, while Srividya works in the administration department of an FMCG company. The family comprises of 6 members, Prashant & Srividya, their 2 kids and Prashant’s parents.

Name Age Relationship Health History
Prashant Nair 38 Self Healthy
Srividya 35 Wife Healthy
Dinesh Nair 74 Father High BP.
Lakshmi Nair 70 Mother High BP, Diabetes
Asha 7 Daughter Healthy
Vineet 5 Son Healthy

Their inflows, outflows & Networth details are given below.

Inflows
Monthly Yearly
Prashant 64500 774000
Srividya 21000 252000
85500 1026000
Outflows
Household expenses 27500 330000
Life insurance 5333.33 64000
Total Outflow 32833.3 394000
Investments
PPF 5833.33 70000
Surplus 46833.3 562000
Networth
Self Occupied home 4200000
Savings Account 550000
PPF (both accounts) 400000
EPF (both accounts) 445000
Stocks & Mutual funds 200000
Loans -0
Networth 5795000

Srividya has decided to discontinue working after 1 year to concentrate on her children’s education. Both the kids are going to school and grand parents take the responsibility of looking after them during the day, in the absence of Prashant & Srividya. Prashant would like to continue working in the IT industry and the family’s financial goals are enumerated below.

INSURANCE

Inspite of paying an annual premium of Rs. 64000, Prashant is covered for a sum assured of Rs. 12 lakhs while Srividya is covered for Rs. 400000. Prashant’s Employer provides group floater mediclaim cover of Rs. 300000 for the family of 4, excluding the parents. Parents are not covered by any form of medical insurance.

FINANCIAL GOALS

The following are the financial goals as enumerated by Prashant and Srividya in present value terms.

  1. Educational funding of Asha – Rs. 1 lakh each year from age 17 to 20 and Rs. 3 lakhs at her age of 21 years
  2. Educational funding of Vineet – Rs. 1 lakh each year from age 17 to 20 and Rs. 3 lakhs at his age of 21 years
  3. Marriage funding of Asha – Rs. 4 lakhs at her age of 26 years
  4. Marriage funding of Vineet at his age of 27 years
  5. Retirement in the year 2031 when Prashant turns 58 years old.

Sr. Financial Goal Today’s cost Approximate Year Inflation
No. Category:- Responsibilities No. of Years Adjusted Cost
Rs. to Goal Rs.
1 Daughters Education’
1.2 Required at Age 17 Years Rs.100,000.00 10 2021 Rs.259,374
1.3 Required at Age 18 years Rs.100,000.00 11 2022 Rs.285,312
1.4 Required at Age 19 years Rs.100,000.00 12 2023 Rs.313,843
1.5 Required at Age 20 years Rs.100,000.00 13 2024 Rs.345,227
1.6 Required at Age 21 years Rs.300,000.00 14 2025 Rs.1,139,250
Rs.700,000.00 Rs.2,343,005
2 Son’s Education
2.2 Required at Age 17 Years Rs.100,000.00 13 2024 Rs.345,227
2.3 Required at Age 18 years Rs.100,000.00 14 2025 Rs.379,750
2.4 Required at Age 19 years Rs.100,000.00 15 2026 Rs.417,725
2.5 Required at Age 20 years Rs.100,000.00 16 2027 Rs.459,497
2.6 Required at Age 21 years Rs.300,000.00 17 2028 Rs.1,516,341
Rs.700,000.00 Rs.3,118,540
3 Marriage of Daughter Rs.400,000.00 19 2029 Rs.2,446,364
4 Marriage of son Rs.400,000.00 22 2032 Rs.3,256,110
5 Retirement at Age 58years
Expenses considered Rs.252,000.00 20 2027 Rs.1,070,458
Corpus required 20 Rs.22,953,250

Assumptions

  • General inflation (retirement) – 7.5%
  • Educational & Marriage inflation – 10%
  • Expected annual increase in salary – 5%
  • Returns on Equity & Equity mutual funds – 12%
  • Returns on PPF – 8%
  • Returns on EPF – 8.5%
  • Retirement corpus growth 1.87% (adjusted to inflation)

PROJECTIONS AND RECOMMENDATIONS.

A. CONTINGENCY FUND:

  1. The family should maintain a contingency fund of Rs. 83000 (rounded off). Rs. 15000 to maintained as cash at home and the rest in his savings account linked with FD.
  2. Considering Prashants parents health status and the fact that they don’t have any medical cover, Rs. 300000 to be maintained in a bank FD as a back up for their unforeseen medical expenses.

The above allocation can be managed from the savings account balance

B. INSURANCE

1. Accident: Prashant should take an accident policy of 25 lakhs with a TTD (Total temporary benefit) of 7.5 lakhs. The premium will come to around Rs. 3500.

2. Health: Prashant and Srividya should take an individual cover of Rs. 5 lakhs each and Rs. 2 lakhs for their daughters, the premium for which will be approximately

Rs. 15500.

3. Life: As per the expense replacement method there is a shortfall of Rs. 80 lakhs of life insurance cover which should be covered by Term plan for a period of 25 years at an approximate cost of Rs. 20000 p.a.

C. FINANCIAL GOALS

  1. For Daughters educational requirement starting from 17th to 21st year of her age, SIP in Equity Diversified Mutual fund to be started for an amount of Rs. 6750
  2. For Son’s educational requirement starting from his 17th to 21st year an sip of Rs. 5750 to be started in a Diversified Equity mutual fund.
  3. Daughter’s Marriage requirement can be funded by starting an SIP of Rs. 3000 in a diversified MF.
  4. Son’s marriage can be funded by an SIP of Rs. 2500 in a Nifty Index MF.
  5. The retirement expenses at age 58 will be Rs. 10, 70,458 per year for which a corpus of Rs. 2, 29, 53,250 is required which can sustain till the age of 85 years.

A major part of the corpus can be easily funded by PF, PPF & Gratuity benefits which will altogether fetch Rs. 1, 59, 15,000 at retirement. The shortfall of Rs. 70, 38,000 can be achieved by starting an SIP of Rs. 7250 in an Index Mutual fund.

D. RECOMMENDED CASH FLOW

Total inflow 85500 1026000
Outflows
Household expenses 27500 330000
Life insurance 7000 84000
Accident & Mediclaim 1583.33 19000
PPF 5833.33 70000
SIPS 25250 303000
Total Outflow 67166.7 806000
Surplus 18333.3 220000

The surpluses can be maintained in savings bank and can be used to fund the SIPs for next year when Srividya won’t be working.

2 thoughts on “Financial Planning – Case Study”

  1. In the case study for retirement corpus the year given is 2027. It should be beyond that. For academic purpose I was redoing the calculations.

    Thanks.
    R.Masilamani,
    CFP.

Comments are closed.

Scroll to Top