Valuing an American Option Using Binomial Tree-Derivative Pricing in Excel

Follow us on LinkedIn

In a previous post, we provided an example of pricing American options using an analytical approximation. Such a pricing model is fast and accurate enough for risk management purposes. However, sometimes more accurate results are required. For this purpose, the binomial (lattice) model can be used. Wikipedia describes the binomial tree model as follows,

In finance, the binomial options pricing model (BOPM) provides a generalizable numerical method for the valuation of options. The binomial model was first proposed by Cox, Ross and Rubinstein in 1979. Essentially, the model uses a “discrete-time” (lattice based) model of the varying price over time of the underlying financial instrument…

The binomial pricing model traces the evolution of the option’s key underlying variables in discrete-time. This is done by means of a binomial lattice (tree), for a number of time steps between the valuation and expiration dates. Each node in the lattice represents a possible price of the underlying at a given point in time.

Valuation is performed iteratively, starting at each of the final nodes (those that may be reached at the time of expiration), and then working backwards through the tree towards the first node (valuation date). The value computed at each stage is the value of the option at that point in time.

Derivative Pricing in Excel Binomial Tree Lattice

We utilized the lattice model previously to price convertible bonds. In this post, we’re going to use it to value an American equity option. We use the same input parameters as in the previous example. Using our Excel workbook, we obtain a price of $3.30, which is smaller than the price determined by the analytical approximation (Barone-Andesi-Whaley) approach.

Derivative Pricing in Excel Binomial Tree Workbook

American option valuation in Excel using Binomial Tree

Related post: Valuation of European and American Options-Derivative Pricing in Python

Further questions

What's your question? Ask it in the discussion forum

Have an answer to the questions below? Post it here or in the forum

LATEST NEWSLophos Holdings Inc. Celebrates Successful Conclusion of Inaugural Annual General Meeting, Confirms Board Members and Stock Options Plan
Lophos Holdings Inc. Celebrates Successful Conclusion of Inaugural Annual General Meeting, Confirms Board Members and Stock Options Plan

VANCOUVER, British Columbia, March 28, 2024 (GLOBE NEWSWIRE) — Lophos Holdings Inc. (CSE: MESC) (“Lophos” or the “Company“) is pleased to announce all matters presented for approval at the annual general meeting of the shareholders of the Company held earlier today March 28, 2024 (the…

Stay up-to-date with the latest news - click here
LATEST NEWSSome cancer patients can find it hard to tell family and friends about their diagnosis: ‘You’re dealing with this all alone’
Some cancer patients can find it hard to tell family and friends about their diagnosis: ‘You’re dealing with this all alone’

Not everyone is eager to share upsetting medical news, even with loved ones

Stay up-to-date with the latest news - click here
LATEST NEWSBattle for Disney board seats heats up as votes come in, Blackwells sues
Battle for Disney board seats heats up as votes come in, Blackwells sues
Stay up-to-date with the latest news - click here
LATEST NEWSExcellon Closes Debenture Restructuring
Excellon Closes Debenture Restructuring
Stay up-to-date with the latest news - click here
LATEST NEWSLiberty Gold Reports Year-End 2023 Financial and Operating Results
Liberty Gold Reports Year-End 2023 Financial and Operating Results

VANCOUVER, British Columbia, March 28, 2024 (GLOBE NEWSWIRE) — Liberty Gold Corp. (TSX:LGD; OTCQX:LGDTF) (“Liberty Gold” or the “Company”), is pleased to announce its financial and operating results for the fiscal year ended December 31, 2023. All amounts are presented in United States dollars unless…

Stay up-to-date with the latest news - click here

Leave a Reply