C 0E F A put option in finance allows you to sell a share of stock at a given price in the future. There are different types of us consider the European put option which allows you to sell a share of stock at a given price called the exercise price, at a particular point in time after the purchase of the European put option. For example, suppose put options. Let u purchase a six-month European put option for a share of stock with an exercise price of $26. If six months later the stock price per share is $26 or more, the option has no value. If in six months the stock price is lower than $26 per share, then you can purchase the stock and Immediately sell it at the higher exercise price of $26. If for example, the price per share in six months is $22.50, you can purchase a share of the stock for $22.50 and then use the put option to immediately sell the share for $26. Your profit would be the difference, $26- $22.50 $3.50 per share less the cost of the option. If you paid $1.00 per put option, then you profit would be $3.50-$1.00 $2.50 per share Build a model in Excel to calculate the profit the European put option described above. Construct a data table in Excel 2 that shows the profit per share for a share price in six months between $10 and $30 per share in Increments of $1.00 13 Complete the given table below 14 If required, round your answers to two decimal places. For subtractive or negative numbers use a minus sign. s The exercise price is $26, and the cost of option is $1, $2,or $3 $10.00 $11.00 $12.00 $13.00 $14.00 $15.00 $16.00 $17.00 $18.00 $19.00 $20.00 $21.00 $22.00 $23.00 $24.00 $25.00 $26.00 $27.00 $28.00 $29.00