How To Add Monte Carlo Simulation to your Spreadsheet
Step 1: Adding Random Data. In the Monte Carlo model, instead of a fixed % return, we anticipate that the return will be normally distributed with a mean (average) of % and a standard deviation of %. For each return cell in the spreadsheet (column D), we use the random function NormalValue: D3.