The Binomial and Black-Scholes Option Pricing Models: A Pedagogical Review with VBA Implementation

Abstract

In this paper, a pedagogical review of two option pricing models is presented; specifically, the Binomial and the Black-Scholes pricing models. Theoretically these models converge for a very large number of exercise periods within a single option contract by virtue of the central limit theorem being based on the random walk and the Brownian motion processes respectively. This relationship is graphically illustrated by the use of an MS VBA implementation of the models.