Cell: +1 (985) 805-5163

Protective put strategy

Can you help me understand this Excel question?

Don't use plagiarized sources. Get Your Custom Essay on
Protective put strategy
Just from $9/Page or 300 words
Order Now

You have purchased 100 shares of Apple Inc. stock and plan to hold them until June 2020. You set up a bottom line in the investment: you don’t want to lose more than $20 per share and you decide to use options to realize the goal.

  • On Nov 22, 2019, you go to Nasdaq ( to look for the options that mature in June 2020. The information is in the excel file attached.
  • What is the current stock price of Apple Inc. on Nov 22, 2019? (1 point)
  • You decide to use the protective put strategy to achieve your goal. Briefly describe what’s protective put strategy? (1 point)
  • Create an excel table in the format given to you to calculate the profits of protective put using each of the option available (use the last price as the price of the option). (5 points)
  • How will you construct your portfolio? Which option will you choose and why? (1 points)
  • Draw the graph of the profit of your portfolio with options you selected. (2 points)

Due by Dec 3, 2019, noon

Looking for a similar assignment? Get help from our nursing qualified experts!

Order Now

Open chat
Get help
You can now contact our live agent via whatsapp! ping +1 ( 681) 249-1107.
You will get plagiarism free custom written paper