Hello I am struggling with a case study in my Managerial Finance class and was looking for a solution to this problem. The work must also be shown. Assistance would be greatly appreciated.

MUST SHOW WORK Client's name: Age: Years until retirement: Years in retirement: Inflation assumption: Return during savings: Return during retirement: Annual raises: Current Income: Income in 20 years: Current retirement savings: Annual contribution to retirement: First half years to retirement: Second half years to retirement: Kevin Walsh 22 30 30 3.5 9% 6% 3.50% $80,000 $20,000 $15,000 25,000 a How much will your client have on the day he/she retires? b He/she wants equal payments every year and wants to leave nothing to heirs? c Using the assumed rate of inflation,what is the annual amount drawn the first year, (solution b) worth today? Comment on your client's ability to live on this amount in retirement d How much will the client be able to withdraw each year of retirement, if the client wants to leave an amount equal to 20% of the starting amount of the retirement account on the day he retires (20%of a) to heirs upon his death which he assumes will be the last day of his projected retirement e Now create a worst case scenario for your client. You are half way to retirement: Assume the returns for the first half of the savings period are 2% less than assumed above, and the client only put away half of what was assumed. How much will the client have to now save per year to save to the original amount found in part a, assuming the rate goes back to the assumed return during savings pe f If your client states that saving the amount in part e is much too high to save, comment on what else they could do. ings period