I need your help to analyze financial statement and analyze ratio between two companies using 10-k form.

My companies are Apple Inc. and Microsoft Corporation.

10-k form of Apple and Microsoft:

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

https://www.sec.gov/ix?doc=/Archives/edgar/data/320193/000032019319000119/a10-k20199282019.htm

B C D E F G H Financial Accounting Case Template GREEN means that the number is used in a calculation PINK means that the information should be used in your paper YELLOW means that the information might be used in your paper Only enter information in green, pink or yellow cells) Company 1 Company 2 Company name Most recent year end date 10 1 year prior year end date 11 2 years prior year end date 12 Are dollars in thousands, millions or billions? 13 14 Balances from balance sheet: 15 Cash and cash equivalents 16 Receivables, net 17 Allowance for doubtful accounts 18 Marketable securities 19 Inventory 20 Other current assets, if any 21 Total current assets 22 PP&E 23 Total assets 24 25 Accounts payable 26 Total current liabilities 27 Total liabilities 28 Stockholders equity 29 Common stock outstanding 30 Common stock authorized 31 32 33 Totals from income statement: 34 Revenues/Sales 35 Cost of goods sold 36 Interest expense 37 Operating income before interest and taxes (EBIT) 38 Net income 39 Earnings per shareA B C D E F G 39 Earnings per share 40 41 42 43 Data from statement of stockholders' equity: 44 Preferred dividends 45 Dividend per share 46 Treasury stock repurchase 47 48 49 Data from the notes to the financial statements: 50 Accumulated depreciation 51 Common shares authorized 52 Common shares issued & outstanding 53 Number of treasury shares purchased 54 Price per share of treasury stock purchased 55 Number of new common shares issued 56 Amount received on new stock issuance 57 58 Stock price per share Find the stock price for the date closest to the end of the fiscal year used in 59 your calculations. 60B C D E F G H As you enter numbers on the Data Sheet, the division errors will disappear. DO NOT CHANGE THE FORMULAS!!! Liquidity and Efficiency: Current ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A Acid-Test ratio #DIV/O! #DIV/O! N/A #DIV/OL #DIV/O! N/A Accounts Receivable turnover #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A Inventory turnover #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 9 Days' sales uncollected #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 10 Days' sales in inventory #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 11 Total asset turnover #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 12 13 Solvency: 14 Debt ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 15 Equity ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 16 Debt-to-equity ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 17 Times interest earned #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 18 19 Profitability: 20 Profit margin ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 21 Gross margin ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 22 Return on total assets #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 23 Return on common stockholder's equity #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 24 25 Market Prospects: 26 Price-earning ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 27 Dividend yield #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 28 29 Ratio Analysis 30 Ratios to measure ability to pay current liabilities: 31 Current ratio #DIV/O! N/A N/A #DIV/O! N/A N/A 32 Acid test ratio #DIV/O! N/A N/A #DIV/O! N/A N/A 33 34 Ratios to measure turnover and cash conversion cycle: 35 Days' sales uncollected #DIV/O! N/A N/A #DIV/O! N/A N/A 36 Days' inventory outstanding #DIV/O! N/A N/A #DIV/O! N/A N/AA C D E F G H 29 Ratio Analysis 30 Ratios to measure ability to pay current liabilities: 31 Current ratio #DIV/O! N/A N/A #DIV/O! N/A N/A 32 Acid test ratio #DIV/O! N/A N/A #DIV/O! N/A N/A 33 34 Ratios to measure turnover and cash conversion cycle: 35 Days' sales uncollected #DIV/O! N/A N/A #DIV/O! N/A N/A 36 Days' inventory outstanding #DIV/O! N/A N/A #DIV/O! N/A Days' payables outstanding N/A 37 #DIV/O! N/A N/A #DIV/O! N/A 38 Cash conversion cycle N/A #DIV/O! N/A N/A #DIV/O! N/A N/A 39 40 Ratios to measure ability to pay long-term debt: 41 Debt ratio #DIV/O! N/A N/A #DIV/O! N/A N/A 47 Times interest earned ratio #DIV/O! N/A N/A #DIV/O! N/A N/A 43 44 Ratios to measure profitability: 45 Gross margin ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 46 Operating income ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 47 Earnings per share N/A N/A 48 Return on total assets #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 49 50 Ratios to analyze the stock as an investment: 51 Price-earnings ratio #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A 52 Dividend yield #DIV/O! #DIV/O! N/A #DIV/O! #DIV/O! N/A