Mathematical distribution modeling

I need someone to model distributions over a 25 year time period from an annuity invested 100% in the S&P 500 to distributions from an IRA invested 100% in the S&P 500.? The annuity has the following characteristics: ? In the decumulation stage your initial distribution value is set as follows: ? Age? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Payment % 50-59? ? ? ? ? ? ? ? ? ? ? ? 4% 60-69? ? ? ? ? ? ? ? ? ? ? ? 5% 70-79? ? ? ? ? ? ? ? ? ? ? ? 6% 80-90? ? ? ? ? ? ? ? ? ? ? ? 7% ? Your payment will increase by the greater of 5% or actual gain experienced by your account during the year.? IRA distributions will be set to equal the annuity distributions. ? I want to use a Monte Carlo method to pull historic returns.? I want the Monte Carlo to do 1,000 runs.? I will supply the raw data.? I would prefer this be done using? Visual Basic in Excel? if possible. This is? the first? of a number of modelling projects I need to complete over the next six months.