Option Value with Black-Scholes formula

Find the value of puts, calls, and combinations of options using the Black-Scholes formula.

blackcallfinanceoption pricingoption valueputrisk neutralityscholes

Description
The formal evaluation of options exploits the principles of complete markets and the risk-less arbitrage to deduce that investors in options should be neutral to risk.

Hence, the option pricing model below used risk-neutrality as a given and assumes that the risk of the underlying asset is described in a normal distribution.

This is adapted from "An Introduction to Options, Entrepreneurial Finance" by Janet Kilholm SMith, Richard L. Smith and Richard T. Bliss

This business tool includes
1 Excel Model

Prof. Richard L. Smith offers you this business tool for free!

Download for free

Discuss

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


Discussion feed for Option Value With Black-Scholes Formula

The user community and author are here to help. Go ahead!

  • Astrid Flores
    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!
    arrow_drop_uparrow_drop_downReply reply
    please wait...