Browse By

Mathematical Finance: Option Pricing using Monte Carlo Simulators in Excel

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.

Option Pricing in Excel using Monte Carlo Simulation Quick Reference Guide


Risk & Treasury Case Studies

2 thoughts on “Mathematical Finance: Option Pricing using Monte Carlo Simulators in Excel”

  1. Pingback: Computational Finance Posts Index
  2. Trackback: Computational Finance Posts Index
  3. Pingback: What do you want to learn today? The lost and found page at LCF | Learning Corporate Finance
  4. Trackback: What do you want to learn today? The lost and found page at LCF | Learning Corporate Finance

Comments are closed.

Comodo SSL