# Question

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 put options. A European put option 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 option. For example, suppose you 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 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 your profit would be $3.50 2 $1.00 = $2.50 per share.

a. Build a model to calculate the profit of this European put option.

b. Construct a data table that shows the profit per share for a share price in six months between $10 and $30 per share in increments of $1.00.

a. Build a model to calculate the profit of this European put option.

b. Construct a data table that shows the profit per share for a share price in six months between $10 and $30 per share in increments of $1.00.

## Answer to relevant Questions

Consider again Problem 13. The point of purchasing a European option is to limit the risk of a decrease in the per-share price of the stock. Suppose you purchased 200 shares of the stock at $28 per share and 75 six-month ...Use the spreadsheet model constructed to answer Problem 1 to answer this problem. a. Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from ...The real value of Lindsay's account after 30 years of investing will depend on inflation over that period. In the Excel function 5NPV(rate, value1, value2, …), rate is called the discount rate, and value1, value2 etc. are ...CHB, Inc. is a bank holding company that is evaluating the potential for expanding into the state of Ohio. State law permits establishing branches in any county that is adjacent to a county in which a PPB (principal place of ...The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units. Product is shipped to regional distribution centers located in Boston, Atlanta, and Houston. Because of an anticipated increase ...Post your question

0