OPTIONS Binomial
The OptionsBin function in FinTools XL is designed to calculate the theoretical price and sensitivities (the Greeks) of options using the binomial model, a widely utilized method in option pricing that provides a discrete time approach for modeling the stochastic process of underlying asset prices.
Model: The number of iterations in the binomial tree. This determines the number of intervals the option's life will be divided into for the purpose of the model. More steps generally provide a more accurate approximation but increase the computational intensity.
Underlying: The current price of the underlying asset.
Exercise: The price at which the asset can be bought (call) or sold (put) at.
Time: The time to expiration of the option, expressed in years, between the Value Date and the Expiration Date.
Volatility: The annualized volatility of the underlying asset's returns, expressed as a decimal.
Interest Rate: The risk-free interest rate, expressed as a decimal.
Dividend Yield: The annual dividend yield expressed as a percentage of the underlying asset price.
Outputs
Price: Calculates the theoretical price of the option.
Delta: Measures the rate of change of the option price with respect to changes in the underlying asset's price.
Gamma: Measures the rate of change in Delta with respect to changes in the underlying asset's price.
Theta: Measures the sensitivity of the option's price to the passage of time.
Vega: Measures the sensitivity of the option price to changes in the volatility of the underlying asset.
Rho: Measures the sensitivity of the option price to changes in the risk-free interest rate.