Question: With the relevant data from Part 1 , use the Black - Scholes formula to calculate and report the value of an otherwise - similar
With the relevant data from Part use the BlackScholes formula to calculate and report the value of an otherwisesimilar Europeanstyle Call option. From this value, use the European PutCall Parity relationship provided on Page to find the value of a Europeanstyle Put option with the same terms. Calculate the difference between your put value here and the put value found in Part and provide two explanations of any difference that you find.
The BlackScholes Model
where:
and:
when:
the current stock price
the striKe exercise price
the timetoexpiration in years
the risk free annual factor,
the standard deviation of the stock's returns year
the cumulative standard normal probability distribution.
EuropeanStyle PutCall Parity Relationship
For a nondividendpaying stock.
Useful Excel Functions
ExP
maxMAx
NORM.DIST TRUE
The symbol indicates a required argument for the function, and the Excel function includes the sign.
Note that the NORM.SDIST function with the logical value of TRUE is for the cumulative standard normal distribution the special case of a mean of zero and standard deviation of one and only requires two arguments. The Excel function NORM.DIST is more general and requires you to specify values for the mean and standard deviation, and the logical value of TRUE for the cumulative distribution. The NORM.DIST function can be used in your BlackScholes calculation instead of NORM.SDIST but then you will need to input the extra arguments, ie NORM.SDIST TRUENORM.DISTTRUE
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
