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

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 NEWSInvestor group bans carbon removal from CO2 reduction plans
Investor group bans carbon removal from CO2 reduction plans

LONDON — An investor group committed to climate change and controlling $11 trillion in assets has banned members from counting carbon removal schemes towards their emissions reduction targets before 2030, amid increasing scrutiny of the fast-growing market for carbon offsets. The Net Zero Asset Owner…

Stay up-to-date with the latest news - click here
LATEST NEWSUK grocery price inflation rises to record 16.7% -Kantar
UK grocery price inflation rises to record 16.7% -Kantar

LONDON — British grocery inflation hit a record 16.7% in the four weeks to Jan. 22, dealing another blow to consumers battling an escalating cost-of-living crisis, industry data showed on Tuesday. Market researcher Kantar said grocery inflation was at its highest since it started tracking…

Stay up-to-date with the latest news - click here
LATEST NEWSFrance eked out 0.1% growth in Q4 as energy crisis eased
France eked out 0.1% growth in Q4 as energy crisis eased

PARIS — France managed to eke out meager growth in the final quarter of 2022 as falling energy imports and firm business investment offset a pullback in consumer spending, preliminary gross domestic product (GDP) figures released on Tuesday showed. The euro zone’s second-biggest economy grew…

Stay up-to-date with the latest news - click here
LATEST NEWSAegir Insights Welcomes Ørsted as a Client for its Offshore Wind Market Intelligence and Investment Analytics
Aegir Insights Welcomes Ørsted as a Client for its Offshore Wind Market Intelligence and Investment Analytics

COPENHAGEN, Denmark — Aegir Insights, a sector leader in offshore wind intelligence and investment solutions, is proud to welcome Ørsted A/S (Ørsted), the world’s largest offshore wind developer, as a client. Aegir Insights provides a competitive edge to offshore wind investors by combining deep industry…

Stay up-to-date with the latest news - click here
LATEST NEWSBlack Friday, holiday sales spur demand at South Africa's Shoprite
Black Friday, holiday sales spur demand at South Africa's Shoprite
Stay up-to-date with the latest news - click here

Leave a Reply