In: Finance
(Please include a table with at least 50 data points for the graph. Graph the value of your portfolio as a function of the relevant stock price. Graph for stock prices between 100 and 140.)
Short Call option payoff = -Max(current stock price -strike price,0)
Long put option payoff =Max(Strike price - current stock price,0)
Strike price = $115
Assume both call and put option has same price which offset each other
Value of the portfolio = payoff on call option + payoff on put option + payoff on long one share
Graph:

| Share price | Payoff on short call option | Payoff on long put option | 
Payoff on long one share (assume current price $100)  | 
Portfolio Value | 
| 100 | 0 | 15 | 0 | 15 | 
| 101 | 0 | 14 | 1 | 15 | 
| 102 | 0 | 13 | 2 | 15 | 
| 103 | 0 | 12 | 3 | 15 | 
| 104 | 0 | 11 | 4 | 15 | 
| 105 | 0 | 10 | 5 | 15 | 
| 106 | 0 | 9 | 6 | 15 | 
| 107 | 0 | 8 | 7 | 15 | 
| 108 | 0 | 7 | 8 | 15 | 
| 109 | 0 | 6 | 9 | 15 | 
| 110 | 0 | 5 | 10 | 15 | 
| 111 | 0 | 4 | 11 | 15 | 
| 112 | 0 | 3 | 12 | 15 | 
| 113 | 0 | 2 | 13 | 15 | 
| 114 | 0 | 1 | 14 | 15 | 
| 115 | 0 | 0 | 15 | 15 | 
| 116 | -1 | 0 | 16 | 15 | 
| 117 | -2 | 0 | 17 | 15 | 
| 118 | -3 | 0 | 18 | 15 | 
| 119 | -4 | 0 | 19 | 15 | 
| 120 | -5 | 0 | 20 | 15 | 
| 121 | -6 | 0 | 21 | 15 | 
| 122 | -7 | 0 | 22 | 15 | 
| 123 | -8 | 0 | 23 | 15 | 
| 124 | -9 | 0 | 24 | 15 | 
| 125 | -10 | 0 | 25 | 15 | 
| 126 | -11 | 0 | 26 | 15 | 
| 127 | -12 | 0 | 27 | 15 | 
| 128 | -13 | 0 | 28 | 15 | 
| 129 | -14 | 0 | 29 | 15 | 
| 130 | -15 | 0 | 30 | 15 | 
| 131 | -16 | 0 | 31 | 15 | 
| 132 | -17 | 0 | 32 | 15 | 
| 133 | -18 | 0 | 33 | 15 | 
| 134 | -19 | 0 | 34 | 15 | 
| 135 | -20 | 0 | 35 | 15 | 
| 136 | -21 | 0 | 36 | 15 | 
| 137 | -22 | 0 | 37 | 15 | 
| 138 | -23 | 0 | 38 | 15 | 
| 139 | -24 | 0 | 39 | 15 | 
| 140 | -25 | 0 | 40 | 15 | 
| 141 | -26 | 0 | 41 | 15 | 
| 142 | -27 | 0 | 42 | 15 | 
| 143 | -28 | 0 | 43 | 15 | 
| 144 | -29 | 0 | 44 | 15 | 
| 145 | -30 | 0 | 45 | 15 | 
| 146 | -31 | 0 | 46 | 15 | 
| 147 | -32 | 0 | 47 | 15 | 
| 148 | -33 | 0 | 48 | 15 | 
| 149 | -34 | 0 | 49 | 15 | 
| 150 | -35 | 0 | 50 | 15 | 
Excel formula:
