In: Finance
Given the following:
Call Option: Strike Price = $60, expiration costs $6
Put Option: Strike Price = $60, expiration costs $4
In excel, show the profit from a straddle for this. What range of stock prices would lead to a loss for this?
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Range of stock price for loss = $50 to $70