Suppose you think Apple stock is going to appreciate substantially in value in the next year. Say the stock’s current price, S0, is $120, and a call option expiring in one year has an exercise price, X, of $120 and is selling at a price, C, of $18. With $14,400 to invest, you are considering three alternatives. a. Invest all $14,400 in the stock, buying 120 shares. b. Invest all $14,400 in 800 options (8 contracts). c. Buy 100 options (one contract) for $1,800, and invest the remaining $12,600 in a money market fund paying 6% in interest over 6 months (12% per year).

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding