use excel to answer the questions, use the attachment for the data
Assignment 4: Protective put strategy
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 (www.nasdaq.com) 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 priceas 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)