Please use Excel and VBA programming to create the following workbook

Retirement Planning. Create an excel 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 persons 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.

Additional constraints: One or more Excel workbooks. All data and calculation cells on your worksheets should be clearly labeled. All the VBA code, including procedures and functions, should be well commented. Use Option Explicit at the top of each module, so that you will have to declare all variables.