Category: derivatives

  • Binomial option pricing model in Excel

    Binomial option pricing model in Excel

    In this lesson, we’ll learn how to set up the binomial option pricing model in Excel. This will allow us to value both call options and put options. We’ll focus on European options that can be exercised only at the expiry of the contract, rather than American options, which can be exercised before expiry. If…