How to Conduct A Monte Carlo Analysis in Excel
How to Conduct a Monte Carlo Analysis in Excel, What The Heck is a Monte Carlo Analysis? In the following blog post, I will walk through how you can conduct a Monte Carlo Analysis of returns in Excel. I will use a problem that I call the stock options problem, which walks through two scenarios, one which shows what will happen if you take the stock options on a risk adjusted basis, versus what will happen if you take the more [...]