the answer to C. using excel formula

9.13Assume that $10,000 was invested in the stock of General Medical Corporation with the intention of selling after one year. The stock pays no dividends, so the entire return will be based on the price of the stock when sold. The opportunity cost of capital on the stock is 10 percent. a. To begin, assume that the stock sale nets $11,500. What is the dollar return on the stock investment? What is the rate of return? 15 10,000 $1,500.00 11,500 10% b. Assume that the stock price falls and the net is only $9,500 when the stock is sold. What are the dollar return and the rate of return? 100 9,500 -500 10,000 c. Assume that the sales prices remain the same but the stock is held for two years. Now, what are the dollar return and the rate of return