4 OPTION STRATEGY ANALYZER 10e B 9 10 General Inputs: 11 Asset price when transaction is initiated necessary only if buying or selling the asset) 12 #of units of asset (>0 buy, 0 buy, 0 = sell) 100 23 Time to expiration when position closed 24 Risk-free rate (rc) 25 Volatility ( ) 26 Dividend yield (c) 27 28 Output: Option value and profit at close of position for asset price chosen above 29 30 Value at close of position 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 31 Profit at close of position -1 350.00 0.00 0.00 32 33 Overall profit at close of position -1.350.00 Asset NA NA NA 0 NA NA NA 125.0000 0.00 0.00 0.00 0.00 Data Table for Graph Results Option 6 0.00 0.00 Asset 0.00 0.00 0.00 0.00 0.00 Option 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 Asset price at end of holding period Profitabilty of Each component of the Strategy Option 1 Option 2 Option 3 Option 4 85.00 -1 350.00 0.00 0.00 0.00 86.63 -1.350.00 0.00 0.00 0.00 88.27 -1,350.00 0.00 0.00 0.00 89.90 -1,350.00 0.00 0.00 0.00 91.53 -1 350.00 0.00 0.00 0.00 93.16 -1 350.00 0.00 0.00 0.00 94 80 -1.350.00 0.00 0.00 0.00 96.43 -1.350.00 0.00 0.00 0.00 98 06 -1,350.00 0.00 0.00 0.00 99.69 1,350.00 0.00 0.00 0.00 101.33 -1 350.00 0.00 0.00 0.00 102.96 -1,350.00 0.00 0.00 0.00 104.59 -1.350.00 0.00 0.00 0.00 106.22 -1.350.00 0.00 0.00 0.00 107.86 -1.350.00 0.00 0.00 0.00 109.49 -1 350.00 0.00 0.00 0.00 111.12 -1.350.00 0.00 0.00 0.00 112.76 -1.350.00 0.00 0.00 0.00 114.39 -1,350.00 0.00 0.00 0.00 116.02 -1.350.00 0.00 0.00 0.00 11765 -1.350.00 0.00 0.00 0.00 119.29 -1,350,00 0.00 0.00 120.92 -1.350.00 0.00 0.00 0.00 122.55 -1 350.00 0.00 0.00 0.00 124.18 -1 350.00 0.00 0.00 0.001 125 82 -1 268,37 0.00 0.00 0.00 127 45 -1 105.10 0.00 0.00 0.00 129.08 -941.84 0.00 0.00 0.00 130.71 -778.57 0.00 0.00 0.001 132.35 -615.31 0.00 0.00 0.00 133.98 .452.04 0.00 0.00 0.00 135.61 288.78 0.00 0.00 0.00 137.24 -125.51 0.00 0.00 0.00 138.88 37.76 0.00 0.00 0.00 140.51 201.02 0.00 0.00 0.00 142.14 364 29 0.00 0.00 0.00 143.78 527.55 0.00 0.00 0.00 145.41 690.82 0.00 0.00 0.00 147 04 854 08 0.00 000 0.00 148.67 1.01735 0.00 0.001 0.00 150 31 1.180.61 0.00 0.00 0.001 151,94 1.343 88 0.00 0.00 0.00 15357 1.507.14 0.00 0.00 0.00 155 20 1.67041 0.00 0.00 0.00 155.84 1833,67 0.00 0.00 0.001 158.47 1.996.94 0.00 0.00 0.00 160.10 2.160.20 0.00 0.00 0.00 161.73 2.323.47 0.00 0.00 0.00 163.37 2.486.73 0.00 0001 0.00 165.00 2.650.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 Overall -1.350.00 -1,350.00 -1.350.00 -1,350.00 -1.350 00 -1.350.00 -1.350.00 -1.350.00 -1 350.00 1.350.00 -1.350.00 -1.350.00 -1.350.00 -1.350.00 -1,350.00 -1.350 00 -1.350.00 -1.350.00 -1 350.00 -1.350.00 -1.350.00 -1,350.00 -1 350.00 -1.350.00 -1,350.00 -1,268 37 -1.105.10 -941 84 -778,57 -615 31 -452 04 288.78 -125.51 37.76 201.02 364 29 52755 690.82 854 08 1,017 35 1.180.61 1,343 88 1.507.14 1.670.41 1.833 67 1.996.94 2.100.20 2.323 47 2.486.73 2,650.00 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 The information to the left is a table of the profit for a range of 50 asset prices at expiration between your specified maximum and minimum. Two graphs are provided on accompanying worksheet tabs. One is called Component Graph, which contains graphs of the profits of all of the options and the underlying asset used in the strategy, as well as the overall profit. Because graphs of all of the components can look cluttered, another tab called Overall Graph is also provided, which shows only the overall profit. Note: It is not possible to design a spreadsheet that will provide perfectly displayed graphs for all conceivable option strategies. Some graphs may have unusual curved lines or kinks. These result from ticks not centered precisely on the exercise prices. If this occurs, you may wish to try different maximum and minimum prices. Strategy Inputs Instructions Abou Component Graph Overall Graph Profit from Strategy Overall and by Component 5,000 4,000 3.000 2,000 1.000 0 TO YOU YYYYY 1964 17 -1,000 -2,000 -3,000 -4,000 4 OPTION STRATEGY ANALYZER 10e B 9 10 General Inputs: 11 Asset price when transaction is initiated necessary only if buying or selling the asset) 12 #of units of asset (>0 buy, 0 buy, 0 = sell) 100 23 Time to expiration when position closed 24 Risk-free rate (rc) 25 Volatility ( ) 26 Dividend yield (c) 27 28 Output: Option value and profit at close of position for asset price chosen above 29 30 Value at close of position 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 31 Profit at close of position -1 350.00 0.00 0.00 32 33 Overall profit at close of position -1.350.00 Asset NA NA NA 0 NA NA NA 125.0000 0.00 0.00 0.00 0.00 Data Table for Graph Results Option 6 0.00 0.00 Asset 0.00 0.00 0.00 0.00 0.00 Option 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 Asset price at end of holding period Profitabilty of Each component of the Strategy Option 1 Option 2 Option 3 Option 4 85.00 -1 350.00 0.00 0.00 0.00 86.63 -1.350.00 0.00 0.00 0.00 88.27 -1,350.00 0.00 0.00 0.00 89.90 -1,350.00 0.00 0.00 0.00 91.53 -1 350.00 0.00 0.00 0.00 93.16 -1 350.00 0.00 0.00 0.00 94 80 -1.350.00 0.00 0.00 0.00 96.43 -1.350.00 0.00 0.00 0.00 98 06 -1,350.00 0.00 0.00 0.00 99.69 1,350.00 0.00 0.00 0.00 101.33 -1 350.00 0.00 0.00 0.00 102.96 -1,350.00 0.00 0.00 0.00 104.59 -1.350.00 0.00 0.00 0.00 106.22 -1.350.00 0.00 0.00 0.00 107.86 -1.350.00 0.00 0.00 0.00 109.49 -1 350.00 0.00 0.00 0.00 111.12 -1.350.00 0.00 0.00 0.00 112.76 -1.350.00 0.00 0.00 0.00 114.39 -1,350.00 0.00 0.00 0.00 116.02 -1.350.00 0.00 0.00 0.00 11765 -1.350.00 0.00 0.00 0.00 119.29 -1,350,00 0.00 0.00 120.92 -1.350.00 0.00 0.00 0.00 122.55 -1 350.00 0.00 0.00 0.00 124.18 -1 350.00 0.00 0.00 0.001 125 82 -1 268,37 0.00 0.00 0.00 127 45 -1 105.10 0.00 0.00 0.00 129.08 -941.84 0.00 0.00 0.00 130.71 -778.57 0.00 0.00 0.001 132.35 -615.31 0.00 0.00 0.00 133.98 .452.04 0.00 0.00 0.00 135.61 288.78 0.00 0.00 0.00 137.24 -125.51 0.00 0.00 0.00 138.88 37.76 0.00 0.00 0.00 140.51 201.02 0.00 0.00 0.00 142.14 364 29 0.00 0.00 0.00 143.78 527.55 0.00 0.00 0.00 145.41 690.82 0.00 0.00 0.00 147 04 854 08 0.00 000 0.00 148.67 1.01735 0.00 0.001 0.00 150 31 1.180.61 0.00 0.00 0.001 151,94 1.343 88 0.00 0.00 0.00 15357 1.507.14 0.00 0.00 0.00 155 20 1.67041 0.00 0.00 0.00 155.84 1833,67 0.00 0.00 0.001 158.47 1.996.94 0.00 0.00 0.00 160.10 2.160.20 0.00 0.00 0.00 161.73 2.323.47 0.00 0.00 0.00 163.37 2.486.73 0.00 0001 0.00 165.00 2.650.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 Overall -1.350.00 -1,350.00 -1.350.00 -1,350.00 -1.350 00 -1.350.00 -1.350.00 -1.350.00 -1 350.00 1.350.00 -1.350.00 -1.350.00 -1.350.00 -1.350.00 -1,350.00 -1.350 00 -1.350.00 -1.350.00 -1 350.00 -1.350.00 -1.350.00 -1,350.00 -1 350.00 -1.350.00 -1,350.00 -1,268 37 -1.105.10 -941 84 -778,57 -615 31 -452 04 288.78 -125.51 37.76 201.02 364 29 52755 690.82 854 08 1,017 35 1.180.61 1,343 88 1.507.14 1.670.41 1.833 67 1.996.94 2.100.20 2.323 47 2.486.73 2,650.00 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 The information to the left is a table of the profit for a range of 50 asset prices at expiration between your specified maximum and minimum. Two graphs are provided on accompanying worksheet tabs. One is called Component Graph, which contains graphs of the profits of all of the options and the underlying asset used in the strategy, as well as the overall profit. Because graphs of all of the components can look cluttered, another tab called Overall Graph is also provided, which shows only the overall profit. Note: It is not possible to design a spreadsheet that will provide perfectly displayed graphs for all conceivable option strategies. Some graphs may have unusual curved lines or kinks. These result from ticks not centered precisely on the exercise prices. If this occurs, you may wish to try different maximum and minimum prices. Strategy Inputs Instructions Abou Component Graph Overall Graph Profit from Strategy Overall and by Component 5,000 4,000 3.000 2,000 1.000 0 TO YOU YYYYY 1964 17 -1,000 -2,000 -3,000 -4,000