Chapter 8. Ch 08 P08 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functions will be accepted for credit.
Numeric answers in cells will not be accepted.
You have been given the following information on a call option on the stock of Puckett Industries:
a. Using the Black-Scholes Option Pricing Model, what is the value of the call option?
First, we will use formulas from the text to solve for d1 and d2.
Hint: use the NORMSDIST function.
Using the formula for option value and the values of N(d) from above, we can find the call option value.
b. Suppose there is a put option on Puckett's stock with exactly the same inputs as the call option. What is the value of
Put option using Black-Scholes modified formula