Black-Scholes Excel Pricing Model

Description
2 Black-Scholes Pricing Excel Models (with & without dilution):

INPUTS:
Inputs:
Stock Price (S)
Strike Price (X)
Volatility (s)
Risk-free Rate
Time to expiration (T)
Dividend Yield
# of Options (000)
# Shares Outstanding (000)
Tax Rate

OUTPUTS:
Stock Price (S)
Strike Price (X)
Volatility (s)
Risk-free Rate
Time to expiration (T)
Dividend Yield
# of Options (000)
# Shares Outstanding (000)
Tax Rate

*Note: This spreadsheet requires iterative calculations which may result in circular references.
To correct this problem, go to "Tools" - "Options" - Calculation and check the "iteration" box.