(Implied volatility) The table below gives June option prices for Pfizer (PFE)

on 31 May 2015. On this date, Pfizer’s stock price was $34.75 and the interest rate was 0.10% annually. Compute the implied volatility for all traded puts and calls using the functions CallVolatility and PutVolatility. (If no price is given, the option was not traded.)

Transcribed Image Text:

A B C D 1 2 Stock price PFIZER (PFE) OPTION PRICES, 31 MAY 2015 34.75 345678 3 Current date 31-May-15 4 Interest rate 0.10% Expiration Exercise Call Put 18-Dec-15 30.00 5.00 0.43 18-Dec-15 31.00 3.50 0.60 9 18-Dec-15 32.00 3.05 0.83 10 18-Dec-15 33.00 2.65 1.11 11 18-Dec-15 34.00 1.98 1.72 12 18-Dec-15 35.00 1.52 1.98 13 18-Dec-15 36.00 1.02 3.20 14 18-Dec-15 37.00 0.75 3.25 15 18-Dec-15 38.00 0.50 4.10 16 18-Dec-15 39.00 0.33 17 18-Dec-15 40.00 0.18 6.75