Computational Finance: Building your first Monte Carlo (MC) simulator model for simulated equity prices in Excel


4 mins read time Here is a slightly revised model for calculating the change in price of an equity security. We now add one more component to our generator function. While the first term works off expected return the second term will help us model uncertainty. Since in our world we drive and link uncertainly with volatility, our model also uses a factor proportional to volatility.