4. Adil wants to ensure that his spouse will be able to take care of household expenses that currently amount to Rs.25,000 per month, even in the event of his death. He wants to make this provision for 30 years. Apart from household expenses, he wants to leave a corpus of Rs.10 lakhs for his child’s requirements. He also has an outstanding home loan of Rs.30 lakhs. He has a life insurance of Rs.50 lakhs.
Q4)How much additional life insurance should he take to meet these requirements?
Explanation:
Monthly expense = Rs.25,000
Annual expense (Rs.25000*12) = Rs.3,00,000
Period for which income should be provided = 30 years
Inflation adjusted return [(1+8%)/(1+6%)-1] = 1.89%
Corpus required to provide income for expenses (A) [Hint: Use PV function in Excel i.e. PV(Rate,Nper,Pmt). = PV(1.89%,30,-300000)] = Rs.68,24,711.97
Loan outstanding (B) = Rs.30,00,000
Child’s corpus (C) = Rs.10,00,000
Total (A+B+C=D) = Rs.1,08,24,711.97
Existing life insurance (E) = Rs.50,00,000
Additional Life insurance required (D-E=F) = Rs.58,24,711.97