Add worksheet #1. Name it Biggest Losses. Have a column named 1985 Opening Price, one column named 2003 closing price. Compute the range of the stocks, then sort them to determine the company with the greatest loss. Pick one company whose share price declined. Do a linear regression on their share prices and extrapolate to 2012. What is the share price today of that company?
Add worksheet #2. Repeat the above process but title the worksheet Biggest Gains
Comments
Leave a comment