Question

Today is your 35th birthday and it occurs to you that your current retirement savings may be insufficient to maintain for you the lifestyle to which you have become accustomed. The value of your retirement account today on your 35th birthday is $100,000. You plan to retire on your 65th birthday and to live until the day before your 83rd Your goal is to have a stream of cash payments on your 66th through 82nd birthdays that provides you with $150,000 of consumption annually in terms of today’s purchasing power. Your retirement account earns 10% per year (this is the effective annual rate), and the inflation rate is 2% forever. Ignore the value of your other assets and perform calculations as if deposits, withdrawals, and compounding of interest occur only once a year.

What cash (nominal) balance do you need in your retirement account on your 65th birthday to provide you with your desired retirement spending stream; i.e., what is the PV of all the cash flows at your 65th birthday received between your 66th and 82th birthday?

What constant nominal amount would you have to deposit on each of your 36th through 65th birthdays to ensure that the balance in your account on your 65th birthday is the amount calculated in the previous question? Take into account the $100,000 you already have in your retirement account.

Answer 1

B Calculations Amount 1 Particulars 2 Present Age 3 Contribution Initiation Age 4 Retirement Age 5 Birthday Upto Required 6 Present Income 7 Present Fund 8 Inflation 9 Retirement Fund Interest Rate 150000 100000 0.02 0.1 10 11 Income @65 Years =$B$6*(1+$B$8)^(B4-$B$2) 12 Income Requied in 66th Year =B11*(1+$B$8) 13 PV of Post retirement Fund required (66 to 82) =(B12/($B$9-$B$8))*(1-((1+$B$8)/(1+$B$9))^(B5-B4)) 14 Value of Present Fund @65th Year =$B$7*(1+B9)^(B4-$B$2) 15 Further Fund requied to met PV of Post retirement Fund =B13-B14 16 Annual Contibution Contrbution Required =B15/(((1+$B$9)^((B4-$B$3))-1)/($B$9)) 17 271704.237615503 277138.322367813 2504532.62239677 1744940.22688864 759592.395508121 5110.59438942927

PV a growing Annity: P [ 1 (1+0) M-g L 1 (1+0) / gi growth Rakel Inflation n number of period Remaining. - First Payment reak of Intrest r FV of Ametly p [lu 493" – 7 & Periodic Payment Required Strona er J Scanned with CamScanner

Feel free to ask any Query in Comment Section

Please provide feedback.

Cheers