All in excel with formulas please. FIN 4223 homework # 13

Securities Markets (FIN 4233) Stock Market Order Types Homework #13, 10 points due 11:59 p.m. Thursday, 10/25/18 Answer the following questions concerning basic order types Assume that you own 100 shares of ABC Company common stock. You purchased these shares at a per-share price of $20. You wish to sell these shares for a gain of at least $5 per share (not including transactions costs). What order could you place in order to accomplish this? Be specific about the characteristics of this order 2. Refer to the ABC Company common stock from problem #1. You purchased the shares for $20 and wish to make a gain of at least $5 per share AND limit your possible losses to approximately $3 per share (not including transactions costs). What combination of orders could you place that would accomplish both of these goals simultaneously? Be specific about the characteristics of the order or orders Now, assume that you have been researching the common stock of REC Corporation. The current market price of REC is $10 per share, but you think that the price will fall within the next few days and you want to buy REC stock at a price of approximately S7 3. per share. What order could you place that would accomplish this goal? Be specific in describing this order. Refer to the REC Corporation stock from problem #3. approximately $7 per share, but would still be willing to buy the stock even if the price You wish to buy the stock at 4. went up to, say, $12 per share. What combination of orders would allow you to accomplish this? Be specific