首页    期刊浏览 2024年07月05日 星期五
登录注册

文章基本信息

  • 标题:Geometric Brownian Motion, Option Pricing, and Simulation: Some Spreadsheet-Based Exercises in Financial Modeling
  • 本地全文:下载
  • 作者:Kevin D. Brewer ; Yi Feng ; Clarence C. Y. Kwan
  • 期刊名称:Spreadsheets in Education
  • 印刷版ISSN:1448-6156
  • 出版年度:2012
  • 卷号:5
  • 期号:3
  • 出版社:Faculty of Information Technology, Bond University
  • 摘要:

    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.

国家哲学社会科学文献中心版权所有