Attracted by a combination of long shelf-lives, low-cost, and nostalgia, during the pandemic, Americans increased consumption of processed and packaged foods. This reversal of a broader consumer trend away from these foods towards fresher, healthier options, gave companies like The Kraft Heinz Company (ticker: KHC), Campbells Soup Company (ticker: CPB), and Conagra Brands, Inc. (ticker: CAG) a much needed boost in sales in previously flagging divisions. Whether this change in consumer buying habits is sustainable has beenthe discussion of recent articles (NYTimes; Marketplace). For the following exercise, you will be extracting monthly stock data from Yahoo Finance for each of the three companies listed above, as well as the market proxy, S&P 500 index (ticker: GSPC). For each of the provided tickers (three firms and the S&P500 index), use the Yahoo Finance search bar to pull up the firm/index summary page. Navigate to the Historical Data menu and download monthly historical prices for October 27, 2015 October 27, 2020. Combine each of your downloaded files into a single spreadsheet. You will need to keep the Date and Adjusted Closing Price of each stock.

1. Based on the trendline equation displayed on each chart, what is the for eachfirm?

2. Rank the firms in order of responsiveness to the market (highest to lowest).

3. If you held an equally weighted portfolio of these three stocks, what would the overall portfolio beta be?

4. Use the average monthly return over the past 60 months to forecast an annual expected market return for the next year. The 10-year Treasury bond has a 0.79% yield on 10/27/2020. If we assume this is the risk-free rate, what is the expected return on each asset?

5. If you held an equally weighted portfolio of these three stocks, what would be the overall expected return be?

6. Your roommate has recently taken up day-trading on Robinhood. After reading articles and various posts, your roommate decides to reallocate their entire stock portfolio from a diversified S&P500 index fund to these three companies to take advantage of the change in consumer buying habits. What advice might you give to your roommate? Discuss the shift in the portfolio risk in terms of its two underlying types of total risk.