• I need to turn this in by tomorrow, can someone please assist me with the equations to solve this problem. AI must show all work

Case 1 Example: ALL WORK MUST BE SHOWN FOR CREDIT! Client Name Age years until retirement years in retirement inflation assumption return during savings return during retirement current income current retirement savings annual contribution to retirement : first half of years to retirement second half of years to retirement Emmora Rose 35 30 25 4% 12% 10% 60,000 0 2000 600 In the yellow cells to the left enter your input variable name or the name of your fictitious client. Then enter of you or your client, the years until you or the client (Should use an even number) sure this is an even number), the estimated number live in retirement (the current life expectancy is almos are 20 and going to retire in 30 years, 40 years in ret be reasonable). Next you need to assume a rate of rate of return during the savings years prior to retirem the retirement years. In BB there are historical rates to base these estates on. Just to mention a few: the average rate of inflation is about 3% and the long ter return of the S&P 500 is 11%. Also people generally more aggressively while they are saving for retiremen they are in retirement. Then enter yours or your clien income and the amount already saved for retirement a How much will your client have on day he/she retires? $482,665 How much will client be able to withdraw each year of retirement if he/she wants equal payments every year and wants to leave b nothing to hiers? 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 day retires (so 20% of part a), to hiers 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)? e Now create a worst case scenerio for your client. You are now half way to saving for 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. f How much will the client have to now save per year to save to the orginal amount found in part a, assuming the rate goes back to the assumed return during savings period? ### 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. the left enter your input variables. Your own f your fictitious client. Then enter the current age the years until you or the client will retire (make number), the estimated number of years you will e current life expectancy is almost 90 - so if you retire in 30 years, 40 years in retirement would xt you need to assume a rate of inflation and a the savings years prior to retirement and during . In BB there are historical rates you can use to es on. Just to mention a few: the long term tion is about 3% and the long term average 00 is 11%. Also people generally tend to invest while they are saving for retirement then while nt. Then enter yours or your client's current ount 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. Solution for A