Question: (Difficult) Using the principles of the previous question, create a spreadsheet-based algorithm to generate an option portfolio for any target gross payoff profile, such as

(Difficult) Using the principles of the previous question, create a spreadsheet-based algorithm to generate an option portfolio for any target gross payoff profile, such as the one in the previous question. Assume, as in the previous question, that option payoffs are provided for stock prices taken at regular intervals (e.g., intervals of $10). Create a table for the given problem on a spreadsheet and then use solver to find the solution. 


Data in Previous question.

You are interested in creating the following gross payoff profile using an options portfolio: 

(Difficult) Using the principles of the previous question, create a spreadsheet-based algorithm

What options, at what strikes, would you hold in your portfolio? Assume that the desired payoffs are zero for any stock price less than 50 or greater than 160.

Step by Step Solution

3.52 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

This is not hard to do on a spreadsheet and the solution may be obtained using solver The above question has been solved using a spreadsheet and the s... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Derivatives Principles And Practice Questions!