By developing the basic intuition of how Monte Carlo simulation works within an Excel spreadsheet framework, this paper allows the undergraduate student to use Monte Carlo simulation techniques to price European style options without additional sophisticated software. Further, the skills and intuition developed provide the basis for much more complex simulation techniques.
Copyright © 2005 Financial Education Association. This article first appeared in the Journal of Financial Education 31 (Spring 2005): 86-97.
Please note that downloads of the article are for private/personal use only.
Arnold, Tom, and Stephen C. Henry. "An Excel Application for Valuing European Options with Monte Carlo Analysis." Journal of Financial Education 31 (Spring 2005): 86-97.