Client name : joe slick

Age : 24

Years until retirement:

Years in retirement:

Inflation assumption :

Return during savings:

Return during retirement:

Current income :

Current retirement savings:

Annuals contribution to retirement:XXXXX

First half of years to retirement:

Second half of years to retirement:

A. How much will your client have on day he she retires : 398,492.15

b. How much will client being able to with draw each year of retirement if he/she want equal payments every year and wants to leave nothing too Hiers?

32,348.78

C. Using the assumed rate of inflation what is the annual amount drawn the first year, (solution b) worth today

17,910.74

D. How much for a client be able to withdraw each year of retirement, if client wants to leave an amount equal to 20% of starting amount on Day retires (so 20% of part a) to heirs upon his death which he assumes will be the last day of his projected retirement

32,254.90

E. Now create a worst-case scenario for your client you are now halfway to saving for retirement assume the returns for the first half of the savings. Or 2% less than assumed above in the Klein only put away half of what was assumed. How much of a kind have to now save per year to save to the original amount found in part and is suing the rate goes back to the assumed return during savings? 21,175.55

How do you do E on excel I have all other answers except for that one!!!