OPTIONS XL | Basic | Plus | Adv | ||
---|---|---|---|---|---|
Black-Scholes | Black-Scholes-Merton for pricing European-style options (closed-form solution) | ||||
Binomial (C-R-R) | Binomial lattice for pricing American and Bermudan-style options (dividend capture) | ||||
Options Lattice EB | Binomial & Trinomial methods including suboptimal factor for early exercise | ||||
Option Flexible Lattice EB | Flexible Lattice option pricing with varying volatility, interest and yield rates | ||||
Flexible Monte Carlo SOEB | Monte Carlo option pricing with multiple suboptimal exercise factors and exit rates | ||||
ESPP Valuation | Calculates the fair value of a Employee Stock Purchase Plan with price discount | ||||
SAR Valuation | Calculates the fair value of a Stock Appreciation Right | ||||
Option Expected Value Method | Calculates the probability of a price at each node, applies expected value method | ||||
Forward Start Black-Scholes | Calculates option values using Forward Start method using exercise ratio | ||||
Gram-Charlier | Option pricing assuming non-normal distribution of returns (skewness and kurtosis) | ||||
Equivalent Term Structure | Calculates the equivalent volatility, interest rate and yield rate from a term structure | ||||
ESO Valuation and Attribution | Provides option valuation and cost attribution using straight-line method | ||||
ESO Exercise Behavior | Calculates the moneyness and time to exercise based on historical exercise behavior | ||||
Expected Term | Calculates the expected term based on the SEC formula and other methods | ||||
Expected Volatility | Estimates the expected volatility by weighting historical and implied volatilities | ||||
Volatility Wizard | TheVolatility Wizard can be used for a detailed volatility analysis | ||||
Implied Volatility Matrix | Calculates a matrix of implied volatilities for exchange-traded options | ||||
Historical Volatility Matrix | Calculates a matrix of historical volatilities given a stock symbol | ||||
Peer Group Volatility | Calculates the blended volatility of a peer group | ||||
Treasury Interest Rates | Provides US Treasury rates dating back to 1/1/2000 | ||||
Black-Scholes Illustrated | Illustrates the Black-Scholes calculation from an expected value perspective | ||||
Binomial Lattice Illustrated | Illustrates the calculations per node of Binomial tree (lattice) | ||||
Monte Carlo Illustrated | Simulates the stock price path for the valuation of ESOs and alternative awards | ||||
Volatility Analysis Illustrated | Illustrates the changes in volatility over time | ||||
Black-Scholes-Merton vs. Lattice | Provides a comparison of Black-Scholes-Merton and Lattice models | ||||
Binomial Early Exercise Effect | Binomial option pricing to illustrate the effect of early exercise for dividend capture | ||||
Binomial Iterations | Binomial method with varying iterations | ||||
Legacy ESO Models | Calculates option values using Minimum Value and Growth methods | ||||
EE Salary & Option Analysis | Compares salary only vs salary plus option employee compensation plans | ||||
Option Formula Components | Illustrates the component parts of the Black-Scholes and Binomial formulas | ||||
ESO Standard / Stepped / Strip | Provides an example of two alternative types of ESO awards | ||||
ESO Implied Volatility | Expected volatility based on the implied volatility of exchange-traded options | ||||
UTILITY XL | Basic | Plus | Adv | ||
Historical Volatility | Volatility functions for calculating volatility from historical prices | ||||
Interest Rate Converter | Converts a rate from one type to another (e.g. Bond Equivalent to Continuous) | ||||
Implied Forward Rates | Calculates the implied forward interest rates from the Treasury yield curve | ||||
Skewness | Calculates the degree of asymmetry of a return distribution; B-S=0 | ||||
Kurtosis | Calculates the degree of peakedness of a return distribution; B-S=0 | ||||
Auto Correlation | Calculates the autocorrelation of returns given a range of stock prices | ||||
Volatility Normality | Calculates volatility, skewness and kurtosis from a given range of stock prices | ||||
Historical Data Wizard | Retrieves historical price data from Yahoo! Finance using HistDataWizard | ||||
EXOTICS XL | Basic | Plus | Adv | ||
Alternative ESO: Average Price | Option value based on the average underlying asset price for a predefined period | ||||
Alternative ESO: Barrier Options | Option is price path-dependent; vests only if a certain target price is reached | ||||
Alternative ESO: Lookback | Provides the right to buy an asset at the lowest price attained over the option’s life | ||||
Alternative ESO: Index (Outperformance) | Exercise price varies with an index such as S&P 500 or peer group | ||||
Double Barrier Binomial | Binomial lattice for pricing an option with a double barrier | ||||
Alternative ESOs | Provides example of alternative or non-standard share-based payment awards |