Open Access. Powered by Scholars. Published by Universities.®
Physical Sciences and Mathematics Commons™
Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 2 of 2
Full-Text Articles in Physical Sciences and Mathematics
An Excel Application For Valuing European Options With Monte Carlo Analysis, Tom Arnold, Stephen C. Henry
An Excel Application For Valuing European Options With Monte Carlo Analysis, Tom Arnold, Stephen C. Henry
Finance Faculty Publications
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.
Visualizing The Stochastic Calculus Of Option Pricing With Excel And Vba, Tom Arnold, Stephen C. Henry
Visualizing The Stochastic Calculus Of Option Pricing With Excel And Vba, Tom Arnold, Stephen C. Henry
Finance Faculty Publications
Stochastic calculus, part calculus and part statistics, is an integral part of option pricing that can be intimidating. By developing the statistical nature of stochastic processes and introducing Monte Carlo simulation using Microsoft Excel, this paper develops a visualization of how stochastic processes are evaluated using Ito's lemma and integral calculus. Ultimately, the Black-Scholes (1973) option pricing equation is the natural result.