Digital Commons Network^™

Implied Binomial Trees In Excel Without Vba, Tom Arnold, Timothy Falcon Crack, Adam Schwartz

Finance Faculty Publications

We implement a Rubinstein-type (1994) implied binomial tree using an Excel spreadsheet, but without using VBA (Visual Basic Application). We demonstrate both the optimization needed to generate implied ending risk-neutral probabilities from a set of actual option prices and the backwards recursion needed to solve for the entire implied tree. By using only standard Excel spreadsheet functions, and not resorting to VBA, this complicated option pricing technique is now immediately transparent to academics, students, and practitioners alike. The intuition gained from our simple spreadsheet can be applied directly to the estimation of more complicated implied trees using more advanced software. …