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

Subscribe to newsletter

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.

Subscribe to newsletter https://harbourfrontquant.beehiiv.com/subscribe Newsletter Covering Trading Strategies, Risk Management, Financial Derivatives, Career Perspectives, and More

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


To download the accompanying Excel workbook or Python program for this post:
1. Subscribe to the newsletter. If you're already a subscriber, go to the next step
2. Once subscribed, refer a friend
After completing these steps, you’ll gain access to the file for this post, along with files for a dozen other posts.

Subscribe to newsletter https://harbourfrontquant.beehiiv.com/subscribe Newsletter Covering Trading Strategies, Risk Management, Financial Derivatives, Career Perspectives, and More

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 NEWSNorth Star Network acquires leading casino affiliate Bojoko
North Star Network acquires leading casino affiliate Bojoko

NAXXAR, Malta, Feb. 18, 2025 (GLOBE NEWSWIRE) — North Star Network and Bojoko are delighted to announce the digital sports media group’s acquisition of the leading iGaming affiliation as NSN looks to take a decisive step into the casino space. The deal, which includes all…

Stay up-to-date with the latest news - click here
LATEST NEWSBOE’s Bailey Says Trump Tariffs Cause Unwelcome Bond Volatility
BOE’s Bailey Says Trump Tariffs Cause Unwelcome Bond Volatility

Bank of England Governor Andrew Bailey said he’d like to see less volatility in bond markets, much of which he puts down to a flurry of announcements around US tariffs.

Stay up-to-date with the latest news - click here
LATEST NEWSMedtronic earnings beat by $0.03, revenue fell short of estimates
Medtronic earnings beat by $0.03, revenue fell short of estimates
Stay up-to-date with the latest news - click here
LATEST NEWSUgoWork to showcase cutting-edge lithium-ion solutions and industry insights at ProMat 2025
UgoWork to showcase cutting-edge lithium-ion solutions and industry insights at ProMat 2025

Driving efficiency and cost savings in material handling QUEBEC, Feb. 18, 2025 (GLOBE NEWSWIRE) — UgoWork™, a leading provider of lithium-ion energy solutions for the material handling industry, is set to make an impact at ProMat 2025, March 17-20 at McCormick Place, Chicago, IL. Visit…

Stay up-to-date with the latest news - click here
LATEST NEWSAmerican Lamprecht Enhances Visibility for Air and Ocean Shipments Using Descartes Solution
American Lamprecht Enhances Visibility for Air and Ocean Shipments Using Descartes Solution

ATLANTA, Georgia and AMERSFOORT, The Netherlands, Feb. 18, 2025 (GLOBE NEWSWIRE) — Descartes Systems Group (Nasdaq:DSGX) (TSX:DSG), the global leader in uniting logistics-intensive businesses in commerce, announced that Illinois-based freight forwarder American Lamprecht is providing its customers with real-time visibility into the location and status…

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

Leave a Reply