Internal Analysis

Internal Analysis

Choose a publicly traded company. For this company and the company’s main competitor create a Table/Chart AND a graph in Excel reporting the following information for 2016-2018: Gross Revenues (sales), Gross Profits, Net Profits, Net Profit Margin and Stock Price. In addition to the table and a graph, write a 1 or 2 paragraph summary of its financial health. Calculate the percent changes for each variable. Also, assess whether the company appears to have a competitive advantage — why or why not? If it does have an advantage, do you think it is sustainable?