Your analysis will consider KO, LUV, JPM and HD. Use the template to record answers to each of the cells in column D for each company. I suggest having a separate Excel worksheet for each company within the workbook.

Using a multiples approach based on an industry median P/E, report the predicted price per share for each company and rank the companies from most attractive to least attractive. Attractiveness is measured by the difference between the market price per share and the price predicted from the industry P/E. Please report in this format with commas separating the answers. If a company has an unreported P/E then note that.

Company A, Predicted Price, Actual Price, Actual Price Predicted Price

Company B, Predicted Price, Actual Price, Actual Price Predicted Price

Company C, Predicted Price, Actual Price, Actual Price Predicted Price

Company D, Predicted Price, Actual Price, Actual Price Predicted Price