Retirement Planning. Create a workbook that has the past 4 years' worth of monthly data for the S&P500, or for an index fund based on it. Allow the user to choose a year in which they plan to retire, and an amount they plan to invest in an index fund today. Create an appropriate forecasting model for future prices. Then create a simulation model to determine the value of the investment at the person's retirement date. Replicate 300 times. Report to the user an expected value of their investment on their retirement date, and show a histogram of the investment values at retirement obtained from the simulation.

This is finance problems doing it in excel. Really need help wth this

Save it as Macro enabled excel file.