10. Jaspreet is 40 years old and currently requires Rs.50,000 pm to meet living expenses. He wants to retire at the age of 60 and expects his expenses to be at the same level, adjusted for inflation. He expects to fund 25 years in retirement. He sees inflation at 8% and investment returns in retirement at 9%.
Q10)He wants to know what is the corpus required to provide the retirement income required.
Explanation:
Current Annual Expenses (Rs.50000*12) = Rs.6,00,000
Rate of Inflation = 8%
Period to retirement (60-40) = 20 years
Future value of living expenses at retirement (This is the amount required to meet annual living expenses at the start of retirement at 60 years) [Hint: Use FV function in Excel i.e. FV(Rate,Nper,,PV). =FV(8%,20,,-600000)] = Rs.27,96,574.29
Number of years in retirement to provide for = 25 years
Investment return expected from corpus in retirement = 9%
Inflation adjusted return [((1+9%)/(1+8%))-1] = 0.93%
Corpus required to generate retirement income [Hint: Use PV function in Excel i.e. PV(Rate,Nper,Pmt). = PV(0.93%,25,-2796574.29)] = Rs.6,21,56,919.33