Stock Prices

Create a fourth worksheet within the same Excel file for historical stock prices. (You can name the worksheet Stock Prices.)

 Reference the To Find Historical Stock Prices section of the Mergent Online written instructions to locate the stock prices for your company for the most

recent seven days. In your Excel file, enter those seven prices.

 On the Stock Prices worksheet, use an Excel formula to calculate the stock price’s rate of return over that seven-day period. To do this,

1. Subtract the stock price of the first day from the stock price of the last day.
2. Divide this amount by the stock price from the first day.
3. Multiply by 100 to get the rate of return.

Sample Solution