Black Scholes in Excel

This is thanks to the awesome Espen Haug, author of Derivative Models on Models, and a well known figure in the quantitative finance community.

The Black Scholes formula




And here's how it can be done in Excel.