BFF5915 – Hedging Assignment single worksheet 代写
100%原创包过,高质量代写&免费提供Turnitin报告--24小时客服QQ&微信：273427
BFF5915 – Hedging Assignment
BFF5915 – Hedging Assignment single worksheet 代写
Due date: 5pm Friday 13 October 2017
Instruction:
This is an individual assessment. Each student receives their individualised assignment in the
form of a uniquely generated Excel file with one single worksheet “Sheet1”
Record your answers in the same worksheet. The assignment will be auto‐marked so you must
record your answers in the designated cells of the worksheet. Failure to comply with this
requirement may result in your answers not being picked up meaning a zero mark.
Direct all queries to Hedging Assignment Forum in Moodle.
Marked to total of 10, which accounts for 10% of overall assessment for the unit.
To submit your assignment, go to the unit’s site in Moodle, click on “Hedging Assignment”
under “Assessments and Exams” and follow the instruction to upload your Excel file (and
nothing else). Do not change the name of the Excel file.
1 mark deducted per day for late submission without prior consent from myself
You should be able to finish this assignment after lecture 9.
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 (6x0.25=1.5 marks).
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. (18x0.25=4.5 marks).
c. What is the objective of the strategy employed in your portfolio? Write the answer (A, B, C or
D) in cell B14 (0.25 mark).
A. Income
B. Insurance
C. Long volatility
D. Short volatility
d. Compute the portfolio’s value and write the answer in cell B15 (0.25 mark).
e. Compute the portfolio’s delta and write the answer in cell B16 (0.25 mark).
f. Compute the portfolio’s gamma and write the answer in cell B17 (0.25 mark).
g. Compute the portfolio’s vega and write the answer in cell B18 (0.25 mark). 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 (0.25 mark).
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 (0.5 mark).
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 (2x0.25=0.5 mark).
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 (0.25 mark).
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 (2x0.25=0.5 mark).
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 (0.25 mark).
n. Compute the delta of a bull spread using calls with strikes of 55 and 60. Write the answer in
cell B29 (0.25 mark).
o. Compute the gamma of a butterfly spread using calls with strikes of 50, 55 and 60. Write the
answer in cell B30 (0.25 mark).
Note:
‐ After opening the Excel file for the first time, widen column A of sheet “Sheet1” to completely
see the questions.
‐ Use 4 decimal places for delta, gamma, vega, volatility.
‐ Use 2 decimal places for portfolio values and cash flows.
‐ Round the number of shares and options to the nearest 1.
‐ Use “‐ “ for short positions. Example: ‐10 means short 10 shares/options. 10 means long 10
shares/options.
‐ Make sure your answer is worksheet “Sheet1” in the file. Do not use this worksheet for
anything else apart from recording the answer. Do not insert rows or columns in this
worksheet. If you want to perform calculations, use other worksheets.
‐ Make sure your answers to calculation questions are numeric, not text.
‐ Put‐call parity suggests the implied volatilities for a European call and a European put on the
same asset, with the same maturity and the strike price, should be the same. Since the option
prices provided are expressed with only 2 decimal points, you may get very slightly different
implied volatilities for the call and the put. That difference is normal.
BFF5915 – Hedging Assignment single worksheet 代写
