This paper presents and explains finite difference methods for pricing options and shows how these methods may be implemented in Excel. We cover both the explicit and the implicit finite difference methods. Each uses a numerical approximation to the partial differential equation and boundary condition to convert the differential equation to a difference equation. The difference equation can be solved using Excel and this solution is a numerical approximation to the option price. This paper explains how we obtain the difference equation from the differential equation and shows the reader how to implement and solve the difference equation using Excel.

Distribution License

Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.

paper_version_12.pdf (2695 kB)
pdf version of the file without the identifiying information

implicit finite difference method.xlsx (21 kB)
spreadsheet file 1 for implicit fd method

explicit_fd and implicit_fd_v2.xlsx (50 kB)
spreadsheet file 2 for implicit and expliict fd methods