Decision Tree and Microsoft Excel Approach for Option Pricing Model

Abstract

In this chapter, we (i) use the decision-tree approach to derive binomial option pricing model (OPM) in terms of the method used by Rendleman and Barter (RB, 1979) and Cox et al. (CRR, 1979) and (ii) use Microsoft Excel to show how decision-tree model can be converted to Black–Scholes model when the number period increases to infinity. In addition, we develop binomial tree model for American option and trinomial tree model. The efficiency of binomial and trinomial tree methods is also compared. In sum, this chapter shows how binomial OPM can be converted step by step to Black–Scholes OPM.