Project Problem: Financial Risk Management
Using the provided Excel spreadsheet as template (you can use a different template as well), please plot the profit diagram for each one of your five selected strategies. Recall that to calculate profits you must reduce the option premiums from your overall payoffs (same as we have done in class).
• Include a screenshot of the option chains (list of prices) showing the actual option strikes, expiration and premiums (prices) you are selecting for your project.
• Include a screenshot showing the stock price at that time and the date when you get this information. This date is the date of "formation" of your strategies.
• What are the stock prices that result in your maximum gain and maximum loss? What is the maximum profit and maximum loss?
• Plot profit diagram keeping in mind you can only buy/sell options in contracts controlling 100 shares each. Thus, always make this final adjustment by multiplying by 100 as learned in class. Please use a different sheet for each strategy.
• A sample spreadsheet is attached for your convenience. It is the same solved during class and uploaded to the Module of Week 10, Chapter 8, under Class Notes and Recordings). Notwithstanding:
o Make sure to carefully follow all steps as learned in class when preparing the profit charts.
o You can directly use this Excel spreadsheet for your project. However, please prepare a clean version of these charts removing notes or hints that were added during class.
The response must include a reference list. Using one-inch margins, double-space, Times New Roman 12 pnt font and APA style of writing and citations.