Requesting input/assistance in matching the industries to the ratios given the financial data

Ratio	Industry	Reasoning
1. Return on sales
2. Asset turnover
3. Return on assets
4. Financial leverage
5. Return on equity
6. Current ratio
7. Inventory turnover
8. Receivables collection
9. Revenue Growth
10. Gross Margin
11. Dividend payout
12. R&D ratio

Transcribed Image Text:

Year end Assets: Cash Accts. Receivable Inventory Other CA Total Current Assets Net PP&E Goodwill Intangibles & oth Total Assets Liabilities: Accts. Pay. ST Debt Other Total Current Liabilities LT Debt Other Total Liabilities Equity:Noncontrolling Int. Net Contr. Cap. Ret. Inc. + OCI Total Equity Total Liab. & Equity ROS Asset Tumover ROA Financial Leverage BOE ROE Curren Current ratio pecivables collection Inventory Tumover Gross margin Dividend payout Revenue growth R & D ratio CFFO (millions) 1 2 3 4 5 6 2.3.18 12.01.17 12.31.17 12.31.17 12.31.17 2.3.18 4.1% 4.4% 17.6% 3.9% 29.9% 56.6% 7,9% 5.6% 100.0% 15.7% 9.6% 12.8% 38.2% 32.3% 10.9% 81.4% -0.1% -25.8% 44.5% 18.6% 100.0% 1.6% 3.30 5.1% 5.39 27.6% 0.78 0.78 6 5 146 14.6 22.0% 23,2% 6.3% N/A 15.9% 8.4% 0.0% 3,413 25.6% 49.9% 6.4% 40.1% 3.6% 100.0% 0.8% 0.0% 23.5% 24.3% 12.9% 4.6% 41.8% 0.0% -6.9% 65.1% 58,2% 100.0% 23.2% 0.50 11.7% 1.72 20.0% 2.05 61 61 N/A 91.9% 0.0% 10.5% 3.4% 2.6% 1.3% 17.8% 66.5% 8.0% 7.8% 100.0% 3.3% 5.0% 20.9% 29.1% 4.5% 0.82 3.7% 13.09 48.9% 0.61 15 43.8% 19.7% 19.4% 7.0% 92.4% 87.4% N/A N/A 24.7% 16.76% 1,470 4,744 Data source: Created by author using company 10-Ks filed with the SEC. 10.3% 5.0% 15.2% 32.4% 4.5% 4.5% 56.6% N/A 2.8% 88.9% 64.2% 37,5% 0.0% 0.0% 3.6% 3.2% 5.8% 100.0% 100.0% 100.0% 46.4% 0.0% 14.1% 60.6% N/A N/A 1.2% 2.7% 5.8% 1.0% 1.0% 22.2% 0.4% 3.2% 32.2% 5.4% 47.3% -0.9% 7.1% 48.0% 0.32 0.61 4.4% 15.3% 7.91 2.43 34.5% 37.2% 0.93 1.01 193 31 N/A 2.4% 0.1% 22.2% 0.7% 2.9% 10.9% 5.3% 33.8% 2,024 33.0% 20.5% 58.8% N/A N/A 12,9% 10.4% N/A 29.0% 7.1% 70.0% 2.2% 0.0% 0.0% 0.0% 3.1% 15.1% 14.9% 0.0% 0.0% 0.2% 0.5% 11.1% -10.6% 9.6% 14.3% -32.7% -3.5% 21.0% 38.0% 14.9% 26.2% 11.5% 46.1% 7.6% 12.6% 41.2% 30.0% 35.7% 25.9% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 6.2% 21,1% 13.9% 3,472 4.1% 1.84 7.5% 3.33 25.1% 0.95 2 2 2 5.9 28.8% 45.6% 3.3% N/A 7 12.31.17 23.6% 10.0% 12.2% 0.0% 45.8% 6,923 26.4% 0.1% 17.7% 44.2% 18.8% 15.9% 78.9% 8 9 9.30.17 12.31.17 19.8% 17.9% 4.8% 10.1% 9.9% 1.3% 8.5% 4.8% 34.3% 42.7% 37.2% 24.6% 10.2% 22.1% 6.8% 8.1% 100.0% 100.0% 100.0% 100.0% 9.0% 19.6% 1.5% 9.7% 55.2% 28.0% 1.7% 1.35 2.3% 4.74 10.9% 104 1.04 13.1% 1.7% 3.1% 8.2% 12.1% 20.9% 26.9% 32.3% 22.1% 19.6% 64.3% 74.1% 25.9% 11.5% -0.9% 21.1% 0.61 0.51 12.9% -0.5% 2.80 3.86 36.1% -1.7% 1.20 1.28 27 27 7.0 56% 0.0% 30.8% 12.72% 18,434 63,598 28 28 1.32 72 73 10 7.1.17 14 1.4 201 29.1 38.5% 73.5% 26.4% -1074.5% 6.3% 7.8% 5.05% 23.09% 5,616 4.9% 22.6% 16.9% 0.9% 45.2% 22.4% 3.0% 9.0% 34.3% 43.1% 8.6% 86.1% 2.1% 3.12 6.4% 7.20 46.4% 400 1.32 26 26 15.0 19.1% 61.2% 9.9% N/A 2,176 11 12 13 12.31.17 12.31.17 12.31.17 1.4% 64.2% 0.0% 11.1% 0.9% 4.3% 18.1% 100.0% 71.0% 2.2% 2.7% 10.7% 0.0% 86.6% 0.0% 6.7% 6.7% 13.4% 100.0% 18.3% 0.05 1.0% 7.46 7.5% N/A 4270 N/A N/A 53.1% 5.4% N/A 4,635 7.3% 5.8% 0.2% 2.4% 15.8% 66.4% 78.2% 7.0% 0,9% 10.8% 13.6% 100.0% 100.0% 2.7% 0.0% 5.8% 8.6% 87.4% 13.7% 109.7% 22.8% 0.68 15.4% -10.34 -158.9% 0.0% 0.0% -146.2% 10.8% 136.5% 21.2% -9.7% 32.1% 100.0% 100.0% 1.84 23 32 126 18.2% 59.5% -7.3% N/A 1.8% 2.3% 0.7% 2.6% 7.4% 5,551 2.7% 2.7% 4.8% 10.2% 30.6% 27.1% 67.9% 12.7% 0.25 3.2% 3.12 9.9% 0.72 33 21 3.1 76.9% 52.7% -0.3% 0.39% 3,367 Year end Assets: Cash Accts. Receivable Inventory Other CA Total Current Assets Net PP&E Goodwill Intangibles & oth Total Assets Liabilities: Accts. Pay. ST Debt Other Total Current Liabilities LT Debt Other Total Liabilities Equity:Noncontrolling Int. Net Contr. Cap. Ret. Inc. + OCI Total Equity Total Liab. & Equity ROS Asset Tumover ROA Financial Leverage BOE ROE Curren Current ratio pecivables collection Inventory Tumover Gross margin Dividend payout Revenue growth R & D ratio CFFO (millions) 1 2 3 4 5 6 2.3.18 12.01.17 12.31.17 12.31.17 12.31.17 2.3.18 4.1% 4.4% 17.6% 3.9% 29.9% 56.6% 7,9% 5.6% 100.0% 15.7% 9.6% 12.8% 38.2% 32.3% 10.9% 81.4% -0.1% -25.8% 44.5% 18.6% 100.0% 1.6% 3.30 5.1% 5.39 27.6% 0.78 0.78 6 5 146 14.6 22.0% 23,2% 6.3% N/A 15.9% 8.4% 0.0% 3,413 25.6% 49.9% 6.4% 40.1% 3.6% 100.0% 0.8% 0.0% 23.5% 24.3% 12.9% 4.6% 41.8% 0.0% -6.9% 65.1% 58,2% 100.0% 23.2% 0.50 11.7% 1.72 20.0% 2.05 61 61 N/A 91.9% 0.0% 10.5% 3.4% 2.6% 1.3% 17.8% 66.5% 8.0% 7.8% 100.0% 3.3% 5.0% 20.9% 29.1% 4.5% 0.82 3.7% 13.09 48.9% 0.61 15 43.8% 19.7% 19.4% 7.0% 92.4% 87.4% N/A N/A 24.7% 16.76% 1,470 4,744 Data source: Created by author using company 10-Ks filed with the SEC. 10.3% 5.0% 15.2% 32.4% 4.5% 4.5% 56.6% N/A 2.8% 88.9% 64.2% 37,5% 0.0% 0.0% 3.6% 3.2% 5.8% 100.0% 100.0% 100.0% 46.4% 0.0% 14.1% 60.6% N/A N/A 1.2% 2.7% 5.8% 1.0% 1.0% 22.2% 0.4% 3.2% 32.2% 5.4% 47.3% -0.9% 7.1% 48.0% 0.32 0.61 4.4% 15.3% 7.91 2.43 34.5% 37.2% 0.93 1.01 193 31 N/A 2.4% 0.1% 22.2% 0.7% 2.9% 10.9% 5.3% 33.8% 2,024 33.0% 20.5% 58.8% N/A N/A 12,9% 10.4% N/A 29.0% 7.1% 70.0% 2.2% 0.0% 0.0% 0.0% 3.1% 15.1% 14.9% 0.0% 0.0% 0.2% 0.5% 11.1% -10.6% 9.6% 14.3% -32.7% -3.5% 21.0% 38.0% 14.9% 26.2% 11.5% 46.1% 7.6% 12.6% 41.2% 30.0% 35.7% 25.9% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 6.2% 21,1% 13.9% 3,472 4.1% 1.84 7.5% 3.33 25.1% 0.95 2 2 2 5.9 28.8% 45.6% 3.3% N/A 7 12.31.17 23.6% 10.0% 12.2% 0.0% 45.8% 6,923 26.4% 0.1% 17.7% 44.2% 18.8% 15.9% 78.9% 8 9 9.30.17 12.31.17 19.8% 17.9% 4.8% 10.1% 9.9% 1.3% 8.5% 4.8% 34.3% 42.7% 37.2% 24.6% 10.2% 22.1% 6.8% 8.1% 100.0% 100.0% 100.0% 100.0% 9.0% 19.6% 1.5% 9.7% 55.2% 28.0% 1.7% 1.35 2.3% 4.74 10.9% 104 1.04 13.1% 1.7% 3.1% 8.2% 12.1% 20.9% 26.9% 32.3% 22.1% 19.6% 64.3% 74.1% 25.9% 11.5% -0.9% 21.1% 0.61 0.51 12.9% -0.5% 2.80 3.86 36.1% -1.7% 1.20 1.28 27 27 7.0 56% 0.0% 30.8% 12.72% 18,434 63,598 28 28 1.32 72 73 10 7.1.17 14 1.4 201 29.1 38.5% 73.5% 26.4% -1074.5% 6.3% 7.8% 5.05% 23.09% 5,616 4.9% 22.6% 16.9% 0.9% 45.2% 22.4% 3.0% 9.0% 34.3% 43.1% 8.6% 86.1% 2.1% 3.12 6.4% 7.20 46.4% 400 1.32 26 26 15.0 19.1% 61.2% 9.9% N/A 2,176 11 12 13 12.31.17 12.31.17 12.31.17 1.4% 64.2% 0.0% 11.1% 0.9% 4.3% 18.1% 100.0% 71.0% 2.2% 2.7% 10.7% 0.0% 86.6% 0.0% 6.7% 6.7% 13.4% 100.0% 18.3% 0.05 1.0% 7.46 7.5% N/A 4270 N/A N/A 53.1% 5.4% N/A 4,635 7.3% 5.8% 0.2% 2.4% 15.8% 66.4% 78.2% 7.0% 0,9% 10.8% 13.6% 100.0% 100.0% 2.7% 0.0% 5.8% 8.6% 87.4% 13.7% 109.7% 22.8% 0.68 15.4% -10.34 -158.9% 0.0% 0.0% -146.2% 10.8% 136.5% 21.2% -9.7% 32.1% 100.0% 100.0% 1.84 23 32 126 18.2% 59.5% -7.3% N/A 1.8% 2.3% 0.7% 2.6% 7.4% 5,551 2.7% 2.7% 4.8% 10.2% 30.6% 27.1% 67.9% 12.7% 0.25 3.2% 3.12 9.9% 0.72 33 21 3.1 76.9% 52.7% -0.3% 0.39% 3,367

Answer rating: 100% (QA)

Lets analyze the given financial ratios for each industry 1 Return on Sales ROS Highest Drug manufac... View the full answer