Question: The Excel file provides real data for call option contracts on SPY with exercise date on 5/2/2022. a. What pattern do implied volatilities follow across

The Excel file provides real data for call option
The Excel file provides real data for call option contracts on SPY with exercise date on 5/2/2022. a. What pattern do implied volatilities follow across exercise prices? Make a graph and describe the pattern. (4 points) Calculate annualized mm based on past daily returns of SPY. (3 points) The current SPY price is $437.97, exercise price is $438, 3-month treasury bill rate is 0.78%, dividend yield is 1.3%, there are 12 days before the exercise date. Calculate the call price based on B-SMerton model. (2 points) . Make a data table showing the BSMerton prices for call options with different exercise prices. Calculate the difference between market price of option and BSMerton prices. Make a graph that shows actual option prices and BSMerton prices for different options. Describe the pattern you observe. (4 points) Black-Scholes-Merton option pricing models assume that the implied volatility (IV) of an option for the same underlying stock and expiration date should be identical, regardless of the strike price. Define function BSMCallVolatility(Stock, Exercise, Time, Interest, Dividend, Target) to calculate the volatility implied by Black-Scholes-Merton model. Set target price=BSMerton price calculated in c. Based on your calculation, are volatilities identical for options with different strike prices under B-SM model? (5 points) Volatility smiles started occurring in options pricing after the 1987 stock market crash. Explain why implied volatility is higherfor deep out-of-the-money and in-the-money options. Why the pattern is not symmetric? In other words, why there is a smirk instead of smile? (5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!