Question: Please answer the following question a in attachment and use four decimal places for implied volatility and record the answer in Excel, also please show

Please answer the following question "a" in attachment and use four decimal places for implied volatility and record the answer in Excel, also please show the calculation process.

Your portfolio: A stock is currently trading at 55. You hold a portfolio of the following instruments: 0 Long 200 shares of stock 0 Long 200 puts with a strike of 50 and maturity of three months (T=13/52) 0 Short 200 calls with a strike of 60 and maturity of three months (T=13/52) All of the options are European options and each option is on 1 share. This portfolio information and information on interest rate and dividend are contained in the attached Excel file (rows 1-4). Prices of various options (including the ones held in your portfolio) are listed in the Excel file (see rows 6-12). Requirements: a. Based on the option prices, compute their implied volatility using the Black-Scholes model. Record your answers (in Sheet1) in range D7:D12 (6x0.25=1.5 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
