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.
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.
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
VANCOUVER, British Columbia, Nov. 21, 2024 (GLOBE NEWSWIRE) — Central 1 Credit Union (Central 1) today reported third quarter performance reflecting steady financial results across business lines, consistent with plans and expectations. “Our stable third quarter results were in line with our expectations,” said Sheila…
HAMILTON, Bermuda — Aspen Insurance Holdings Limited (“Aspen” or the “Company”) has priced an underwritten public offering of 8,000,000 Depositary Shares (the “Depositary Shares”), each of which represents a 1/1,000th interest in a share of the Company’s newly designated 7.00% Perpetual Non-Cumulative Preference Shares (the…
TORONTO — Postmedia Network Canada Corp. (“Postmedia” or the “Company”) today released financial information for the three months and year ended August 31, 2024. “While we continue to operate in a challenging advertising marketplace dominated by large, foreign media platforms, Postmedia achieved some important milestones…
