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 business tool 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
People using this tool also downloaded
Black-Scholes Excel Pricing Model
A mini Black-Scholes Excel model, just hit and go!997Discussfree
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.399DiscussDividend Adjusted Model to value Long Term Options
A dividend-adjusted model for valuing long term options.135DiscussHow to Due Diligence in 10 Easy Steps
Learn how do to a due diligence in 10 easy steps.253Discussfree
by Ryan Barnes
Cash Flow Statement Excel Template
This is a highly professional, ready-to-use Cash Flow Statement template for analyzing your company's financials.38Discussfree
by Someka
Financial Planning for SaaS Startups
How to create a financial plan for an early stage SaaS company.217Discussfree
by Nikos Moraitakis
Balance Sheet Excel Template
This is a ready-to-use Balance Sheet Excel Template to use for your business's financials.28Discussfree
by Someka
All in One Private Equity Model
Used by Investment Professionals at Private Equity and IB Firms5,5352$180.00
by John Swan
Dummy Cap Table & Returns Analysis - Round B
Example Pro Forma Cap Table for a Series B company (three tranches of A, plus warrants)1,055Discussfree
by Lindsay Meyer
An Introduction to Leverage Analysis
A quick and informative video on leverage analysis.74Discuss
More tools from Prof. Richard L. Smith
Integrated Financial Statement Template
A simple Full Pro Forma Financial Statement for Entrepreneurs761DiscussEntrepreneur's Cost of Capital Template
Estimate the statistical parameters for determining an entrepreneur's cost of capital494DiscussValuation - Investor's & Entrepreneur's partial commitment
Calculate the Net Present Value (NPV) for the Entrepreneurs Commitment when Partial444DiscussValuation Partial Commitment of the Entrepreneur
Learn how to value an entrepreneur's partial commitment to a venture390DiscussSustainable Growth Template
Understand the links between the Starting Balance Sheet, Year 1 Income Statement and Ending Balance Sheet212DiscussPresent Value of Entrepreneur's Wealth and Commitment
Calculate how much your entrepreneurial investment is worth in your total projected wealth over your career194DiscussWorking Capital Policy Template
See how working capital policies are established and how they influence financial needs165Discuss
Discussion feed for Option Value With Black-Scholes Formula
The user community and author are here to help. Go ahead!
Eloquens Authorschool