Toronto Metropolitan University
Browse

Geometric Brownian Motion, Option Pricing, and Simulation: Some Spreadsheet-Based Exercises in Financial Modeling

Download (602.61 kB)
journal contribution
posted on 2023-11-22, 20:37 authored by Kevin D. Brewer, Yi FengYi Feng, Clarence C. Y. Kwan

 This paper presents some Excel-based simulation exercises that are suitable for use in financial modeling courses. Such exercises are based on a stochastic process of stock price movements, called geometric Brownian motion, that underlies the derivation of the Black-Scholes option pricing model. Guidance is provided in assigning appropriate values of the drift parameter in the stochastic process for such exercises. Some further simulation exercises are also suggested. As the analytical underpinning of the materials involved is provided, this paper is expected to be of interest also to instructors and students of investment courses. 

History

Language

English

Usage metrics

    Accounting & Finance

    Categories

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC