How do I calculate my income in 22 years (cell C23)?

Need answers to questions A through F, including the functions I need to input.

PLEASE DO NOT CHANGE FOREMAT ACFI 385 Disbrow Case 1 Example: ALL WORK MUST BE SHOWN FOR CREDIT! Client Name: Age: 21 Enter your clients age Years until retirement: 44 Years in retirement: 25 Inflation assumption: Return during savings: 3.3% 10.0% Return during retirement: 4.0% Annual raises 3.5% Current income: 20,000 Income in 22 yrs. Current retirement savings: In the yellow cells to the left enter your input variables. Your own name or the name of your fictitious client. Then enter the current age of you or your client, the years until you or the client will retire (make sure this is an even number), the estimated number of years you will live in retirement (the current life expectancy is almost 90 - so if you are 20 and going to retire in 30 years, 40 years in retirement would be reasonable). Next you need to assume a rate of inflation and a rate of return during the savings years prior to retirement and during the retirement years. In BB there are historical rates you can use to to base these estates on. Just to mention a few: the long term average rate of inflation is about 3.3% and the long term average return of the S&P 500 is 10%. Also people generally tend to invest more aggressively while they are saving for retirement then while they are in retirement. Then enter yours or your client's current income and the amount already saved for retirement if there is any. Assuming 3.5% raises year over year 15,000 Annual contribution to retirement: First half of years to retirement: Second half of years to retirement: 6,000 0 a How much will your client have on day he/she retires? (15 points) How much will client be able to withdraw each year of retirement if he/she b wants equal payments every year and wants to leave nothing to heirs? (10 points) c Using the assumed rate of inflation, what is the annual amount drawn the first year, (solution b) worth today? (10 points) Comment on your client's ability to live on this amount in retirement. (10 points) 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 day retires (so 20% of part a), to heirs upon his death which he assumes will be the last day of his projected retirement (so this will be a lump sum at the end)? (15 points) e Now create a worst case scenario for your client. You are now 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. (10 points) 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 period? (10 points) f If your client states that saving the amount calculated in part e is much too high an amount to save, comment what else your client could do. (10 points) Next enter the annual contribution you or your client plan to put in for the first half of the years prior to retirement and then the second half. This is because often times people can contribute more as they get older and closer to retirement. Finally answer the questions based on your inputs. For Reference purposes. In the yellow cells to the left enter your input variables. Your own name or the name of your fictitious client. Then enter the current age of you or your client, the years until you or the client will retire (make sure this is an even number), the estimated number of years you will live in retirement (the current life expectancy is almost 90 - so if you are 20 and going to retire in 30 years, 40 years in retirement would be reasonable). Next you need to assume a rate of inflation and a rate of return during the savings years prior to retirement and during the retirement years. In BB there are historical rates you can use to to base these estates on. Just to mention a few: the long term average rate of inflation is about 3% and the long term average return of the S&P 500 is 11%. Also people generally tend to invest more aggressively while they are saving for retirement then while they are in retirement. Then enter yours or your client's current income and the amount already saved for retirement if there is any. Next enter the annual contribution you or your client plan to put in for the first half of the years prior to retirement and then the second half. This is because often times people can contribute more as they get older and closer to retirement. Finally answer the questions based on your inputs