Hedging Assignment -
Your portfolio: A stock is currently trading at 55. You hold a portfolio of the following instruments:
- Long 200 shares of stock
- Long 200 puts with a strike of 50 and maturity of three months (T=13/52)
- 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.
b. Based on the computed volatilities and information provided, compute delta, gamma and vega of the 6 options. Record your answers in range E7:G12.
c. What is the objective of the strategy employed in your portfolio? Write the answer (A, B, C or D) in cell B14.
A. Income
B. Insurance
C. Long volatility
D. Short volatility
d. Compute the portfolio's value and write the answer in cell B15.
e. Compute the portfolio's delta and write the answer in cell B16.
f. Compute the portfolio's gamma and write the answer in cell B17.
g. Compute the portfolio's vega and write the answer in cell B18. Note: you may see an alternate formula that expresses vega as option price change for 1 percentage point increase in volatility. Do not use that formula, use the one in the lecture note instead.
For the following parts, treat them as independent from one another, unless stated otherwise. That is, all of them pertain to the original portfolio at the original prices.
h. Use delta and gamma to approximate the portfolio's value if the stock price suddenly increases by $3. Write the answer in cell B19.
i. What is the additional share position in order to make the portfolio delta neutral? E.g. -10 means short 10 shares, +15 means long 15 shares. Write the answer in cell B20.
j. What are the positions in the stock and 55-strike call in order to make the portfolio both delta and gamma neutral? Write the answers in cells B22 and B23 respectively.
k. What is the net cash flow of achieving delta and gamma neutrality for the portfolio using the strategy in (j)? Write the answer in cell B24.
l. What are the positions in the stock and 55-strike put in order to make the portfolio both delta and gamma neutral? Write the answers in cells B26 and B27 respectively.
m. What is the net cash flow of achieving delta and gamma neutrality for the portfolio using the strategy in (l)? Write the answer in cell B28.
n. Compute the delta of a bull spread using calls with strikes of 55 and 60. Assume the strategy is on one unit of shares. Write the answer in cell B29.
o. Compute the gamma of a butterfly spread using calls with strikes of 50, 55 and 60. Assume the strategy is on one unit of shares. Write the answer in cell B30.
Attachment:- Assignment File.rar