🔥Give Excel SUPERPOWERS with Minty Tools for Excel

An Excel add-in to help you save time and enhance your modeling and analysis.

🔥Give Excel SUPERPOWERS with Minty Tools for Excel

An Excel add-in to help you save time and enhance your modeling and analysis.
🔥Give Excel SUPERPOWERS with Minty Tools for Excel

Understanding the Binomial Option Pricing Model

The Binomial Option Pricing Model is a risk-neutral method for valuing path-dependent options (e.g., American options). It is a popular tool for stock options evaluation, and investors use the model to evaluate the right to buy or sell at specific prices over time.

Under this model, the current value of an option is equal to the present value of the probability-weighted future payoffs.

It is different from the Black-Scholes model, which is more suitable for path-independent options, which cannot be exercised before their due date.

Binomial Option Pricing Model

An investor knows the current stock price at any given moment. They will try to guess the stock price movements in the future. Under this model, we split the time to expiration of the option into equal periods (weeks, months, quarters). Then the model follows an iterative method to evaluate each period, considering either an up or down movement and the respective probabilities. Effectively, the model creates a binomial distribution of possible stock prices.

It’s mostly useful for American-style options, which investors can exercise at any given time. The model also assumes there’s no arbitrage, meaning there’s no buying while selling at a higher price. Having no-arbitrage ensures the value of the asset remains the same, which is a requirement for the Binomial Option Pricing model to work.

Assumptions

When setting up a binomial option pricing model, we need to be aware of the underlying assumptions, to understand the limitations of this approach better.

  • At every point in time, the price can go to only two possible new prices, one up and one down (this is in the name, binomial);
  • The underlying asset pays no dividends;
  • The interest rate (discount factor) is a constant throughout the period;
  • The market is frictionless, and there are no transaction costs and no taxes;
  • Investors are risk-neutral, indifferent to risk;
  • The risk-free rate remains constant.

Advantages and disadvantages

(+) The model is mathematically simple to calculate;

(+) Binomial Option Pricing is useful for American options, where the holder has the right to exercise at any time up until expiration.

(-) A significant advantage is a multi-period view the model provides for the underlying asset’s price and the transparency of the option’s value over time.

(-) A notable disadvantage is that the computational complexity rises a lot in multi-period models.

(-) The most significant limitation of the model is the inherent necessity to predict future prices.

How to Calculate the Model

If we set the current (spot) price of an option as S, then we can have two price movements at any given moment. The price can either go up to S+ or down to S-.

On this basis, we calculate the up(u) and down(d) factors.

Call Options

A call option entitles its holder to purchase the underlying asset or stock at the exercise price PX.

A call option is in-the-money when the spot price is above the exercise price (S > PX).

When we have an up movement, the payoff of the call option is the maximum between zero and the spot price multiplied by the up factor and reduced with the exercise price. To visualize that, here’s the formula:

A downward movement gives a payoff of:

The Binomial model effectively weighs the different payoffs with their respective probabilities and discounts them to the present value.

Put Options

A put option entitles the holder to sell at the exercise price PX.

When the price goes down or up, we calculate a put option as follows:

Binomial Trees

The binomial tree is the best way to represent the model visually. They show the option payoff and probability at different nodes. Nodes outline the paths the price of the underlying asset may take over time.

We can represent a general one-period call option like this.

We can also present it as a formula:

The put option uses the same formula as the call option.

Where:

  • Ï€ is the probability of an up move;
  • r is the discount rate.

To arrive at the probability of an up move we employ the formula:

Where:

  • t is the period multiplier (t = 0.5 for a 6-month period);
  • r is the discount rate;
  • d is the down factor
  • u is the up factor.

In the case of a multi-period option, we can accumulate the additional stages by multiplying the up/down factors for every price movement. If we have an up move, followed by a down move, then we will udS in our formulas.

Sign Up on Substack

Binomial Tree Example

As an example, we can look at a call option with six months till maturity, and build a binomial tree with a period of three months.

We will set the following assumptions:

To set up our model, we need to calculate some parameters. We expect the price to either go up with 20% or down with 10% within a single time step. Applying the probability formula from above, we arrive at our model variables.

The next step is to construct the binomial tree for our model.

We set up the two time-steps for our period and end up with three positions in time – present, in three months and six months. Using the up and down factors, we can calculate the stock price at each of the nodes.

The next step is to calculate the option value at the terminal date (t=0.50). It equals the maximum of zero and the difference between the current price at t=0.50 and the strike price.

Working backward, we calculate the option value at t=0.25 and the present. We do this by weighing the possible future values with the up and down move probabilities and discounting them with the risk-free rate.

That way, we arrive at the present value of the option, at 6.40 euros.

Delta Portfolio Hedging

Delta Hedging is another approach to the binomial option pricing model. The idea is to build a synthetic hedge portfolio and find the profitability, at which the portfolio provides a risk-free payoff. That way, we can determine the trading value of the portfolio, and from there, the price of the option.

Here are the assumptions for our model:

The next step is to calculate the option payoff at the terminal date. We are looking at a one-period binomial model for the sake of simplicity, and our option value at period one will be.

We can now use the option payoffs to calculate the Hedge Ratio, via the formula:

In reality, we will multiply the hedge ratio by some multiplier to make it a whole number, as we cannot typically trade in fractions of stocks. However, for this example, we will ignore that limitation of the real world.

The next step is to build our portfolio. We will buy stock and then short the option. We calculate the portfolio value in the up and down states and expect these to be the same, because of the risk-free payoff assumption.

As our payoff is risk-free, this means the rate of return of the portfolio is the risk-free rate. Therefore the portfolio today should be worth the present value of the payoff. Using either of the up or down states, we can apply our risk-free discount factor of 10% and arrive at the current value of the payoff at -72.73.

If we adjust our portfolio function for the present we get:

If we change only our assumption of the option type to a call, instead, we will get the same option value, due to the frictionless market and no-arbitrage assumptions.

Conclusion

We can use spreadsheet software like Excel to make the Binomial Option Pricing model calculations easy, but the major limitation of the approach remains – predicting the future prices. Also, as we refine the time step, it gets significantly more tedious to forecast the expected payoffs at the end of each period.

However, the Binomial Option Pricing model has the flexibility to accommodate changing circumstances at different periods and thus is suitable for the evaluation of early-exit strategies. A Binomial Pricing model and a Black-Scholes model generally have similar results, which is a testament to the viability of the Binomial Option Pricing Model.

Please, show your support by sharing this article with colleagues and friends!

Also, don’t forget to download the Excel model below.

Dobromir Dikov

FCCA, FMVA

Hi! I am a finance professional with 10+ years of experience in audit, controlling, reporting, financial analysis and modeling. I am excited to delve deep into specifics of various industries, where I can identify the best solutions for clients I work with.

In my spare time, I am into skiing, hiking and running. I am also active on Instagram and YouTube, where I try different ways to express my creative side.

The information and views set out in this publication are those of the author(s) and do not necessarily reflect the official opinion of Magnimetrics. Neither Magnimetrics nor any person acting on their behalf may be held responsible for the use which may be made of the information contained herein. The information in this article is for educational purposes only and should not be treated as professional advice. Magnimetrics and the author of this publication accept no responsibility for any damages or losses sustained as a result of using the information presented in the publication. Some of the content shared above may have been written with the assistance of generative AI. We ask the author(s) to review, fact-check, and correct any generated text. Authors submitting content on Magnimetrics retain their copyright over said content and are responsible for obtaining appropriate licenses for using any copyrighted materials.

You might also like one of the following articles:

Financial Analysis

Support Startup Growth with Digital Loans

In today’s dynamic and uncertain business environment, startups face numerous challenges. Effective financial planning and analysis (FP&A) processes are essential for startups. FP&A helps startups

Read More »