Create an Excel spreadsheet or use the project template to show your computations for the first 10 ratios listed for Apple Inc. and Alphabet Inc., in 2017. Supporting calculations must be shown either as a formula or as text typed into a different cell.

1. Earnings per share of common stock (as given in the income statement)
2. current ratio (current assets divided by current liabilities)
3. gross profit rate (gross profit divided by net sales)
4. profit margin (net income divided by net sales)
5. inventory turnover (cost of goods sold divided by average inventory)
6. days in inventory (365 days divided by inventory turnover)
7. Accounts receivable turnover (net credit sales divided by average net accounts receivable)
8. average collection period (365 days divided by accounts receivable turnover)
9. Asset turnover (net sales divided by average total assets)
10. Return on Assets (ROA) (net income divided by average total assets)