Decision Tree and Microsoft Excel Approach for Option Pricing Model

Abstract

AbstractThe following sections are included:Call and Put OptionsOne-Period Option Pricing ModelTwo-Period Option Pricing ModelUsing Microsoft Excel to Create the Binomial Option TreesBlack–Scholes Option Pricing ModelRelationship between the Binomial Option Pricing Model and the Black–Scholes Option Pricing ModelDecision Tree Black–Scholes CalculationSummaryQuestions and ProblemsAppendex 18A: Excel VBA Code — Binomial Option Pricing ModelBibliography