
Last version published: 24/01/2017 15:49
Publication number: ELQ-76537-4
View all versions & Certificate

Option Value with Black-Scholes formula
Find the value of puts, calls, and combinations of options using the Black-Scholes formula.
Prof. Richard L. Smith offers you this Best Practice for free!
download for free
Add to bookmarks
Further information
Required input data:
- Stock Price now
- Exercise Price of Option
- Number of periods to Exercise in years
- Compounded Risk-Free Interest Rate
- Standard Deviation
Produced output:
- Present Value of Exercise Price
- s*t^.5
- d1
- d2
- Delta N(d1) Normal Cumulative Density Function
- Bank Loan N(d2)*PV(EX)
Results:
- Value of Call
- Value of Put
The Option Pricing Model depends on market completeness, continuous trading, normally distributed risk, independence, and other factors to derive option values. When these assumptions are violated (as they usually are for new ventures and for real options), formal valuation approaches can still provide insights, but the actual values of options are less certain. It is common to employ simulation and numerical methods to value options when critical assumptions are not satisfied"
(An Introduction to Options, Entrepreneurial Finance, by Janet Kilholm SMith, Richard L. Smith and Richard T. Bliss)
Reviews
4.5 / 5 (41 votes)- 71%
- 15%
- 10%
- 2%
- 2%
Write a review
- goodgood excel
People using this Best Practice also downloaded
More Best Practices from Prof. Richard L. Smith
Working Capital Policy Template
See how working capital policies are established and how they influence financial needs350Discussadd_shopping_cartfreeby Richard L. Smith
Integrated Financial Statement Template
A simple Full Pro Forma Financial Statement for Entrepreneurs1,391Discussadd_shopping_cartfreeby Richard L. Smith
Sustainable Growth Template
Understand the links between the Starting Balance Sheet, Year 1 Income Statement and Ending Balance Sheet350Discussadd_shopping_cartfreeby Richard L. Smith
Present Value of Entrepreneur's Wealth and Commitment
Calculate how much your entrepreneurial investment is worth in your total projected wealth over your career358Discussadd_shopping_cartfreeby Richard L. Smith
Valuation - Investor's & Entrepreneur's partial commitment
Calculate the Net Present Value (NPV) for the Entrepreneurs Commitment when Partial1,074Discussadd_shopping_cartfreeby Richard L. Smith
Valuation Partial Commitment of the Entrepreneur
Learn how to value an entrepreneur's partial commitment to a venture6292add_shopping_cartfreeby Richard L. Smith
Entrepreneur's Cost of Capital Template
Estimate the statistical parameters for determining an entrepreneur's cost of capital791Discussadd_shopping_cartfreeby Richard L. Smith
Discussion feed for Option Value With Black-Scholes Formula
The user community and author are here to help. Go ahead!