Mathematical Finance: Option Pricing using Monte Carlo Simulators

In addition to the Black Scholes Equation and binomial trees another important tool in option pricing is Monte Carlo Simulation. A Monte Carlo Simulator in Excel uses the inbuilt Random function in excel to model uncertainty. The Monte Carlo (MC) Simulator uses standardized mathematical finance equations to simulate the price of an equity, a currency, an exchange rate or a commodity. The prices are then used to calculate payoffs and the payoffs are sampled and averaged over a large enough pool to estimate simulated prices.

Here are introductory course on Monte Carlo Simulation. In addition to option pricing we will also use the same tool in interest rate simulations and multiple other financial simulators to be used later on in our mathematical finance curriculum.

Mathematical Finance: Monte-Carlo (MC) Simulation method– Building Equities, Commodities, Currencies and Interest Rate MC Simulators in Excel

Mathematical Finance: Building your first Monte Carlo (MC) simulator model for simulated equity prices in Excel
Mathematical Finance: Extending MC simulation for currencies and commodities
Mathematical Finance: Monte Carlo (MC) Simulation method: Understanding drift, diffusion and volatility drag


Mathematical Finance: Linking Monte Carlo Simulation, Binomial Trees and Black Scholes Equation



Mathematical Finance: Simulating Interest Rates using trees and Monte Carlo Simulation


If you would like to purchase and download the excel examples covered in this course, please checkout our online mathematical finance course store for handy pdf course cheat sheet downloads and solved excel spreadsheets and templates. If you need an option and derivatives product refresher, please see the introductory and intermediate courses below on Derivatives and Options products






Premium Courses