Black-Scholes
Calculator
While Shareworks Financial Reporting makes it dead easy for private companies to complete the option valuation process, we provide this Black-Scholes calculator to demonstrate a method that non-public companies find useful if their plan administration needs are minimal. This calculator can be used to determine “fair value” under ASC 718.
TOOL
Instructions
for Using the Black-Scholes Calculator
The Black-Scholes calculator is on the right. Enter the values in the cells according to the instructions to the top.
P.S. One input that may be tough to judge is the first one — the fair market value of the underlying shares as of the grant date. If you find yourself needing a 409A valuation, be sure to check out Shareworks Valuation Services.
1
2
3
4
5
6
7
8
How it works
Is your company ready to move beyond spreadsheets?
Take a look at how easy it is to value your options using Shareworks Financial Reporting.
.
in Shareworks Financial Reporting
Input your own assumptions…
Or let Shareworks calculate them using your plan data.
You can even calculate peer volatility right in the platform.
Request a demo
LEGAL INFORMATION
This Black-Scholes calculator is being provided to you on an “as is” basis without any express or implied warranties, including the implied warranty of merchantability or fitness for a particular purpose. It is the user’s responsibility to determine whether the calculations that are included are appropriate for your purposes or not. This is only one example of a calculation that may be done in many different ways. It is being provided for informational or educational purposes only. This file may not be shared with any third party and may only be used by the person who received it from Solium Capital ULC. In no event shall Solium Capital ULC. be liable for any monetary damages, including any incidental, special, or consequential damages. By using this spreadsheet, you are agreeing to be bound by the legal limitations set forth above. If you do not agree, stop using this spreadsheet and delete it from your system.
P.S. One input that may be tough to judge is the first one — the fair market value of the underlying shares as of the grant date. If you find yourself needing a 409A valuation, be sure to check out Solium Analytics.
Fair market value
1
Enter the exercise price of the option.
Exercise price
2
Enter the expected term of the option grant as calculated by SAB 110.
Expected term
3
Enter the interest rate.
Interest rate
4
Assuming the company does not have any dividends, leave this cell at 0.
Dividend rate
5
Enter the volatility based on an appropriate number of public peer companies.
Volatility:
6
The values in the next two cells are part of the calculation, so do not change these values.
7
Fair value
8
After inputting the values you entered into the above cells, the fair value per share of the option displays.
