Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started