Create an Excel spreadsheet or use the project template to show your computations for the first 16 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)
11. Debt to assets ratio (Total liabilities divided by total assets)
12. Times interest earned ratio (net income + interest expense + income tax expense divided by interest expense)
13. Dividend yield (dividend share of common stock divided by market share of common stock)
14. ROE (Return on common stockholders' equity) (net income - preferred dividends divided by average common stockholders' equity)
15. Free cash flow (Net cash provided by operating activities minus capital expenditures minus cash dividends)
16. Price-earnings ratio (For the purpose of this ratio, look up the market price per share as of September 28, 2017 for Apple Inc. and for Alphabet, Inc. use December 29, 2017) (Market price per share of common stock divided by earnings per share)