文章基本信息

标题：Connecting Binomial and Black-Scholes Option Pricing Models: A Spreadsheet-Based Illustration
本地全文：下载
作者：Feng, Yi ; Kwan, Clarence C. Y.
期刊名称：Spreadsheets in Education (eJSiE)
印刷版ISSN：1448-6156
出版年度：2012
卷号：5
期号：3
页码：2
出版社：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.
关键词：binomial option pricing model; Black-Scholes formula; Bernoulli trials