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

standard deviation formula on excelproshares uvxycalculating rate of return in excelfxy etfetf ticker liststandard deviation without calculatoryahoo msftstandard deviation calculator in excelannualizing returnsvelocityshares dailydefinition of sigma in statisticsvix futures marginreturns calculator exceloptions futures and other derivatives solution manualshort strangle option strategydelta otcsharpe formulacalculation of market capitalizationexcel formulas spreadsheetwhat to invest in besides stocksoptions rhocovariance calculator financerho tradingcalculate historical volatilityvix real time quotedelta symbol in excelatr volatilityoptions greek calculatorshort etf s&pcalculating the sharpe ratiovix chartwacc debthow to buy vix optionsexcel formulas standard deviationkohlhagenmaximum profit equationformula for finding average in exceltvix etfstraddle option calculatorciti reverse splitbull call spread payoff diagramformulas of cost accountingkurtosis graphsquare root excel formulavix explainedhow do i trade the vixvix index wikistandard deviation of stock calculatord1 black scholesdelta hedging formulafinding the median in excelrelative value hedge fundvix option pricesquantitative hedge fund strategiesmoneyness optioniron condor calculatorhow to use natural log in excelexcel log formulaacceptable skewness and kurtosishistorical volatility calculationpopulation formula calculatorvolatility etnstandard deviation in excel 2007sharpe ratio calculatorwhat does implied volatility meanlong straddle optionsproshares short vix short-term futures etfrho optionsspx spyoptions greek calculatorreturns calculator excel