1. Begin by looking at the historical performance of the overall stock market. Typically, on most of the financial websites you can enter S&P 500 and go right to the index’s summary page. You will see a quick summary of the market’s performance over the past 24 hours and 12 months. How has the market performed over the past year?
2. On the summary screen, you should see an interactive chart. Typically, you can chart performance over the last 24 hours, 1 month, 6 months—up to 10 years, or even longer. Select different time periods and watch how the graph changes. On this screen you should also see a menu to select historical prices (historical data). Some websites will not only show daily activity but also weekly or monthly activity. In addition, some websites will allow you to download the data into an Excel spreadsheet.
3. Now let’s take a closer look at the stocks of four companies: Colgate Palmolive (Ticker 5 CL), Campbell Soup (CPB), Motorola Solutions (MSI), and Tiffany & Co (TIF). Before looking at the data, which of these companies would you expect to have a relatively high beta (greater than 1.0) and which of these companies would you expect to have a relatively low beta (less than 1.0)?
4. Select one of the four stocks listed in question 3 by entering the company’s ticker symbol on the financial website you have chosen. On the screen you should see the interactive chart. Select the six-month time period and compare the stock’s performance to the S&P 500’s performance on the graph by adding the S&P 500 to the interactive chart. Has the stock outperformed or underperformed the overall market during this time period?
5. Go back to the summary page to see an estimate of the company’s beta. What is the company’s beta? What was the source of the estimated beta? Realize that if you go to another website, the beta shown could be different due to measurement differences.
6. What is the company’s current dividend yield? What has been its total return to investors over the past year? Over the past 3 years? (Remember that total return includes the dividend yield plus any capital gains or losses.) You will have to go to more than one website to find this information. MSN Money (www.msn .com/en-us/money/markets) gives DPS information over the past 4 years on the detailed Income Statement Financials page. (Be sure to enter the ticker symbol in the quote search box located in the middle of your screen—not the web search box at the top of your screen.) You can use the price information to calculate dividend yield and capital gains yield. Yahoo! Finance provides historical price information.
7. Assume that the risk-free rate is 4% and the market risk premium is 5%. What is the required return on the company’s stock?
8. Repeat the same exercise for each of the three remaining companies. Do the reported betas confirm your earlier intuition? In general, do you find that the higher-beta stocks tend to do better in up markets and worse in down markets? Explain.