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.

Related pages

sum of squared deviations formulastandard deviation of a sample calculatoretf short s&pwhat is the formula for calculating standard deviationfeatures of derivative marketweighted averages formulavix call optionss&p 500 vix short-term futuresblack scholes normal distributionmacd signal line crossovergeorge soros vs warren buffettcalculate population mean from sample meanarithmetic in excelblack scholes assumptionvix fundshortcut standard deviation formulaimplied volatility term structureparametric var formulaexample of skewnessblack scholes calculationnatural log function in excelgreek calculator optionsjohn hull futures options and other derivativesfree float factor calculationstandard deviation finance formulahow to calculate option deltasquaring negativesvix index cboehow to calculate sample standard deviation in excelipath s&p 500what are some components of waccnormal distribution excel templatevix futures tickercboe historyvxx optionaapl stock historymean deviation calculatorarithmetic mean of grouped datavxx inversederiving square rootsbook on options tradingcontinuous compounded returnblack scholes stock option calculatorbull spread using callsvariance of grouped data formulawhat is a long straddleinstrict valuefxe etfdelta gamma vegablack scholes put calculatorcboe delayeddef varianceexcel stdev ifstandard deviation calculator with mean and sample sizeblack scholes formula explainedprotective collar optionvar parametricthe black scholes merton modelvix s&pvix historical chartipath vixgeorge soros fund holdingsworking out standard deviation in excelrealized volatility formulaexcel skewnessweighted average share price calculationstandard deviation frequency calculatorvix callarithmetic made easystd deviation definitionbarclays etnssma vs emamacd parametershow to calculate rsi in stock marketcalculating the variance in excelvix etf leverageddownload yahoo finance data into excelrsi settingsput option black scholesvix historical chartlist of leveraged etf