Play the role of financial analyst and summarize a comparison of each company's performance for each main category of liquidity, solvency, profitability, conclusion.

You all get the chance to play the role of financial analyst below. The summary should be a comparison of each company's performance for each major category of ratios listed below. Focus on major differences as you compare each company's performance. A nice way to conclude is to state which company you feel is the better investment and why. Liquidity: Solvency: Profitability: Conclusion: Apple Inc 9/30/2017 Alphabet Inc 12/31/2017 Earnings per Share of Common Stock (basic-common) As given in the income statement $9.27 $18.27 Current Ratio 5.14 Current assets Current liabilities $128.645 - $100,814 1.28 $124,308 - $24,183 Gross Profit Rate 38.50% Gross profit Net sales 588.180- $229,234 565.272 - $110.855 58.90% Profit Margin 21.10% 11.40% Net Income Net sales $48.351 - $229,234 $12,662 - $110.855 6 90% Return on Assets (ROA) Net income Average total assets $48 351 $348,503 = 13.90% $12062 S182 396 Debt to assets ratio 22.70% Total Liabilities Total Assets $241 272 $375,319 64.30% $44.793 $197.295 Times Interest Earned Ratio 28.6 250.5 Net income interest expense income tax expense interest expense 588,412 $2,323 27 302 109 Dividend Yield Dividend per share of common stock (Yahoo Finance 9/30/2017) Market price per share of common stock (Yahoo Finance (929/2017) $240 $38.53 = 620% $0.00 $1,053.40 0.00% Return on Common Stockholders Equity (ROE) = 38.90% 8.70% Net income-preferred dividends Average common stockholders' equity 48 351 131,148.00 12 882 145,769.00 Free cash flow $35.135.000 $23.907 $23.907 Net cash provided by operating activities minus capital expenditures minus cash dividends $1.324 in ons in thousands Price-Earnings Ratio 4 58 Market price per share of common stock as of 9/30/2017 for Apple Inc and 12/31/2017 for Alphabet Inc $8.53 Earnings per share 59.21 51.053 40 51827 Inventory Turnover 404 896 Cost of goods sold Average inventory $141048 $3,494 $45 583 $509 Days in Inventory lah 385 days Inventory burnover 365 404 385 896 days days Accounts Receivable Turnover Net Credit Sales 5229234 Average net accounts receivable $16,814 13.6 S110,855 $16237 6.8 Average Collection Period 11 = 365 365 days Accounts receivable turnover 385 13.6 27 days 53 days Asset turnover 0.61 Net sales Average total assets $229 234 = $348,503 0.66 $110,856 $182 396