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
Black-Scholes Excel Pricing Model
A mini Black-Scholes Excel model, just hit and go!4,963Discussadd_shopping_cartfree
by Gia Hy Le Pham
Black-Scholes converted for Binomial Tree
Converts the standard deviation input in the Black-Scholes model to up and down movements in the binomial tree.3,215Discussadd_shopping_cartfree
by Aswath Damodaran
Black-Scholes Option Price Excel Calculator
Call and put options price calculator that uses the Black-Scholes model for option pricing1,638Discussadd_shopping_cartDividend Adjusted Model to value Long Term Options
A dividend-adjusted model for valuing long term options.355Discussadd_shopping_cartfree
by Aswath Damodaran
Option Trading on Index - Put Call Ratio
PCR-OPTION Trading Excel Model Template.23Discussadd_shopping_cart$49.00
by Hitesh Khanna
Actual vs Potential Dividends
Compares the dividends paid to what a firm could have paid, by estimating the free cash flow to equity244Discussadd_shopping_cartfree
by Aswath Damodaran
Valuing a Natural Resource Option
This model calclulates the value of natural resource option.208Discussadd_shopping_cartfree
by Aswath Damodaran
Estimating the Illiquidity Discount
This model can be used to estimate illiquiduty discounts for firms173Discussadd_shopping_cartfree
by Aswath Damodaran
Private Equity Fund Model (Fund Raise, Investor Cash flows)
Private Equity Cash flow Model to be used at the time of fund raising activities2906add_shopping_cart$100.00
by Anuj Verma
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_cartfree
by Richard L. Smith
Integrated Financial Statement Template
A simple Full Pro Forma Financial Statement for Entrepreneurs1,391Discussadd_shopping_cartfree
by Richard L. Smith
Sustainable Growth Template
Understand the links between the Starting Balance Sheet, Year 1 Income Statement and Ending Balance Sheet350Discussadd_shopping_cartfree
by 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_cartfree
by Richard L. Smith
Valuation - Investor's & Entrepreneur's partial commitment
Calculate the Net Present Value (NPV) for the Entrepreneurs Commitment when Partial1,074Discussadd_shopping_cartfree
by Richard L. Smith
Valuation Partial Commitment of the Entrepreneur
Learn how to value an entrepreneur's partial commitment to a venture6292add_shopping_cartfree
by Richard L. Smith
Entrepreneur's Cost of Capital Template
Estimate the statistical parameters for determining an entrepreneur's cost of capital791Discussadd_shopping_cartfree
by Richard L. Smith
Discussion feed for Option Value With Black-Scholes Formula
The user community and author are here to help. Go ahead!
- Very glad this model is available, this is one of the most tedious calculations and it really does simply finding your option values with simply giving the inputs. Thank you Professor Richard!
