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

文章基本信息

  • 标题:Connecting Binomial and Black-Scholes Option Pricing Models: A Spreadsheet-Based Illustration
  • 本地全文:下载
  • 作者:Yi Feng ; Clarence C. Y. Kwan
  • 期刊名称:Spreadsheets in Education
  • 印刷版ISSN:1448-6156
  • 出版年度:2012
  • 卷号:5
  • 期号:3
  • 出版社:Faculty of Information Technology, Bond University
  • 摘要:

    The Black-Scholes option pricing model is part of the modern financial curriculum, even at the introductory level. However, as the derivation of the model, which requires advanced mathematical tools, is well beyond the scope of standard finance textbooks, the model has remained a great, but mysterious, recipe for many students. This paper illustrates, from a pedagogic perspective, how a simple binomial model, which converges to the Black-Scholes formula, can capture the economic insight in the original derivation. Microsoft ExcelTM plays an important pedagogic role in connecting the two models. The interactivity as provided by scroll bars, in conjunction with Excel's graphical features, will allow students to visualize the impacts of individual input parameters on option pricing.

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