Black-Scholes & Dividends

The Original Black-Scholes Model

The original Black-Scholes option pricing model (Black, Scholes, 1973) assumes that the underlying security does not pay any dividends. In other words, dividends don't enter option price calculation in any way.

Black-Scholes(-Merton) Model Expanded for Dividends

The spreadsheet uses the expanded version of the model (Merton, 1973) that can price options on securities that pay a dividend. The calculation assumes that the underlying security pays a continuous dividend at the rate you set as entry parameter.

Note: If you want the exact original Black-Scholes model, just set dividend yield to zero.