Data Analytics Group Assignment Each group needs to select two companies in the same industry and obtain the two most recent annual reports for each company.
The group needs to submit a write-up that includes the following components.
• Illustrate the two companies’ EPS and financial ratios using figures. Design your figures in a way that is easy to understand and refer to these figures in your discussion of each category of ratios. Each group needs to make the following judgments. o Whether to prepare a separate figure for each ratio or to include more than one ratio, from the same category of ratios, in one figure, o For each ratio / category of ratios: whether to prepare separate figures for the two companies or to include both companies in the same figure. Notes: • The annual reports for both companies should be for 2016 and 2017, or 2015 and 2016 if the 2017 report is not yet available for one or both of the companies. • Annual reports can be obtained from each company’s investor relations website or from the SEC’s EDGAR database: (Electronic Data Gathering, Analysis, and Retrieval; http://www.sec.gov/edgar/searchedgar/companysearch.html). • To obtain stock prices at the end of each fiscal year: you can search for the company on “finance.yahoo.com” then click on “Charts” from the top menu to view the daily stock price chart. You can scroll to the date of interest (for example, 12/31/2016, 12/31/2017) to view the stock price for that day. • You should use Excel to calculate the ratios and prepare the figures • The write-up should be written using Word, double-spaced, size 12 Times New Roman font. The exhibits including the ratios, as well as the figures, need to be inserted in the write-up.