Help compare the financial ratios listed for Apple Inc and Alphabet Inc

profileswilson83
AppleIncandAlphabetInc.xlsx

Companies data summary 2017

Apple Inc.com Alphabet Inc.Com
2017 2017
Net Income 48,351.00 12,662.00
shareholders Equity 134,047.00 152,502.00
Total Assets 375,319.00 197,295.00
Revenue 229,234.00 110,855.00
Current Assets 128,645.00 124,308.00
Current Liabilities 100,814.00 24,183.00
Accounts Receivable 35,673.00 18,705.00
Accounts Payable 97,207.00 4,343.00
Inventories 4,855.00 749.00
Net sales 229,234.00 110,855.00
Cost of Goods sold 141,048.00 45,583.00
Beginning inventory and clossing inventory (stock) 4,855.00 749.00
Total sales 229,234.00 110,855.00
Total liabilities 241,272.00 44,793.00
Earnigs before interest tax expenses 61,344.00 26,178.00
Interest expense 10,157.00 6,915.00
Cash flow from operating activities 64,225.00 37,091.00
Capital expenditure 12,451.00 13,184.00
Annual dividend per share 2.32 18.27
Price per share 0.02 0.27
Earnings per share 2.30 18.00
Stock price 39.65 9.68
Dividents on preffered stock - 0 - 0
Number of outstanding common shares 21,007.00 751.00
Common stock equivalents 4,840.00 1,077.14

Financial ratios

1. Current ratio
2017
apple Inc.com 1.2760628484
alphabet Inc.Com 5.1403051731
2. Accounts receivable turnover ratio
2017
apple Inc.com 6.4259804334
alphabet Inc.Com 5.9264902433
3. Return on equity
2017
apple Inc.com 0.3607018434
alphabet Inc.Com 0.0830284193
4. Return on assets ratio
2017
apple Inc.com 0.1288264117
alphabet Inc.Com 0.0641780076
5. Profit margin
2017
apple Inc.com 0.2109242085
alphabet Inc.Com 0.1142212801
6. Gross Profit margin
2017
apple Inc.com 0.38
alphabet Inc.Com 0.59
7. Asset Turnover ratio
2017
apple Inc.com 47.2160659114
alphabet Inc.Com 148.0040053405
8. Inventory Turnover Ratio
2017
apple Inc.com 29.0521112255
alphabet Inc.Com 60.8584779706
Average collection period
2017
apple Inc.com 28.4003354651
alphabet Inc.Com 30.7939425375
Days in inventory
2017
apple Inc.com 12.5636308207
alphabet Inc.Com 5.9975210056
Debt to asset ratio
2017
apple Inc.com 1.8754868048
alphabet Inc.Com 0.2270356573
Time Interest Earned Ratio
2017
apple Inc.com 6.0395786157
alphabet Inc.Com 3.7856832972
Dividend Yield ratio
2017
apple Inc.com 116
alphabet Inc.Com 0.27
Free cash flow
2017
apple Inc.com 51,774.00
alphabet Inc.Com 23,907.00
Price to earn ratio
2017
apple Inc.com 17.2391304348
alphabet Inc.Com 0.5377777778
Earnings per share of common stock
2017
apple Inc.com 1.87
alphabet Inc.Com 6.93