3.
Kumar, 30 years old, with a life expectancy of 75, works as a project manager for a leading Indian corporate in Ahmadabad for the past 7 years. His wife, Swathi, is 29, with a life expectancy of 80, and is a homemaker. They have two children – Rahul (5 years old) and Narendra (2 years old).
Kumar’s monthly salary details:
- Basic Salary: Rs. 30,200
- D.A (part of Salary): 50% of basic salary
- City Compensatory Allowance: Rs. 300
- Children Education Allowance: Rs. 200 per child
- Transport allowance: Rs. 1,000
He pays an annual premium of Rs. 23,900 for his life insurance policies, which include 3 endowment policies and 1 unit-linked policy, providing a total life insurance cover of Rs. 12,00,000. Kumar plans to set aside funds for his children’s higher education expenses, estimated at Rs. 3 lakh each, when they reach the age of 21.
Kumar’s monthly expenditure breakdown:
- Housing expenses (including travel, holidays, and festivals): Rs. 21,000
- Personal loan repayments: Rs. 13,200
- Total: Rs. 34,200
Assumptions for financial planning:
- Risk-Free Rate of Return: 4% p.a.
- Rate of Return on Equity: 15% p.a.
- Rate of Return on Debt (above 5 years): 9% p.a.
- Inflation: 4% per year.
Q)Kumar wants to invest yearly to achieve his goals for his children’s higher education. For accumulation of fund you recommend Kumar to invest in Debt and Equity in the ratio 20:80. What approximate amount should he set aside every year to achieve his said goals. Assume Kumar maintains separate investment accounts for Rahul and Narendra and invests till they turn 21 years of age respectively.
Explanation:
Funds required when Rahul turns 21. Term = 16 years ; Funds required when Narendra turns 21; Term = 19
Funds required – Rahul = FV(4%,16,0,-300000,1) = Rs 5,61,894.37;
Funds required – Narendra = FV(4%,19,0,-300000,1) = Rs 6,32,054.75
Equity = 15% ; Debt = 9% ; Weighted avg return = 80% * 15% + 20% * 9% = 13.8%
Yearly Investment – Rahul = PMT(13.8%,16,0,561894.37,1) = Rs 9,858
Yearly Investment – Narendra = PMT(13.8%,19,0,632054.75,1) = Rs 7,200