Please use Microsoft Corp for your financial statement analysis;

Download latest two years of annual financial statements of Microsoft Corp from its website or fromwww.sec.govIdentify Microsoft's industry or a major competitor (similar size) for comparison purposes for similar periods. (you may refer Nasdaq.com or other similar source to find competitors)

Calculate the ratios for both Microsoft Corp and those of the industryORa major competitor and compare the ratios with either the company's industry or their major competitor.Identify and commenton how Microsoft Corp is performing in comparison to its industry and/or their major competitor.Your ratio calculations should be in MS Excel,using the formulas

Link to statements but they are also screenshot below:

https://www.sec.gov/Archives/edgar/data/789019/000156459019027952/msft-10k_20190630.htm#ITEM_8_FINANCIAL_STATEMENTS_AND_SUPPLEM

Income Statements

(In millions, except per share amounts) Year Ended June 30, 2019 2018 2017 Revenue: Product 66,069 $ 64.497 $ 63,811 Service and other 59,774 45,863 32,760 Total revenue 125,843 110,360 96,571 Cost of revenue: Product 16,273 15,420 15,175 Service and other 26,637 22,933 19,086 Total cost of revenue 42,910 38,353 34,261 Gross margin 82,933 72,007 62,310 Research and development 16,876 14,726 13,037 Sales and marketing 18,213 17,469 15,461 General and administrative 4,885 4,754 4,481 Restructuring 306 Operating income 42,959 35,058 29,025 Other income, net 729 1,416 876 Income before income taxes 43,688 36,474 29,901 Provision for income taxes 4,448 19,903 4,412 Net income 39,240 16,571 $ 25,489 Earnings per share: Basic 5.11 2.15 3.29 Diluted 5.06 2.13 3.25 Weighted average shares outstanding: Basic 7,673 7,700 7,746 Diluted 7,753 7,794 7,832 Refer to accompanying notes