Binomial option pricing model in Excel - part 1

We explain how to implement the binomial option pricing model in Excel to compute the prices of European call options and put options.

00:00 Intro
00:32 Model inputs
01:59 Exercise price
03:10 Stock payoffs
04:01 Bond payoffs
04:48 Call option payoffs
06:37 Call option price
11:39 Put option payoffs

If you'd like to download the Excel spreadsheet used in this tutorial or check out the formulas for the binomial option pricing model, please visit:
www.initialreturn.com/binomial-option-pricing-mode…

Enjoying our content?

Become a member for exclusive videos & posts and early access to upcoming content:
youtube.com/channel/UCshd-qjVDVwSfYi6P7cgAXA/join

Click the link below to subscribe to our channel:
   / @initialreturn  

You can also follow us on X (Twitter):
x.com/initial_return

And, here are our official Facebook, Instagram, and Pinterest pages:
www.facebook.com/initialreturn
www.instagram.com/initialreturn
www.pinterest.com/initialreturn

And, visit our website for free courses, tutorials, and more:
www.initialreturn.com/

#optionstrading #exceltutorial #derivatives