Binomial OPM, Black-Scholes OPM and Their Relationship: Decision Tree and Microsoft Excel Approach

Abstract

This paper will first demonstrate how Microsoft Excel can be used to create the Decision Trees for the Binomial Option Pricing Model. At the same time, this paper will discuss the Binomial Option Pricing Model in a less mathematical fashion. All the mathematical calculations will be done by the Microsoft Excel program that is presented in this paper. Finally, this paper uses the Decision Tree approach to demonstrate the relationship between the Binomial Option Pricing Model and the Black-Scholes Option Pricing Model.