Question
-Airline -Railway - Drug Manufacturing major - -commercial banking - regional -consumer electronics -discount general - merchandise retail -electric utility -restaurant (fast food) chain -wholesale
-Airline -Railway -
Drug Manufacturing major -
-commercial banking - regional
-consumer electronics
-discount general - merchandise retail
-electric utility
-restaurant (fast food) chain
-wholesale food distribution
-grocery store chain
-internet retailing
-advertising agency services
-software application development
Company 4- Airline
Company 5- Advertising Agencies
Company 9- Consumer electronics
Company 10- Drug Manufacturing major
Company 1- Electric Utility
Company- 2- Grocery Store Chain
Company 3- Software application development
I need 6,7, 8, 11, 12 and 13 - Missing this
Selected Financial Data for 13 Companies (Balance sheet amounts are percentage of total assets) 9 9.28.19 Year end Assets: Cash Accts. Receivable Inventory Other CA Total Current Assets 12.31.19 1.7% 2.1% 0.6% 2.9% 7.4% 2 2.1.20 3.5% 3.8% 15.7% 1.2% 24.1% 3 11.29.19 20.1% 7.4% 4 12.31.19 6.6% 2.9% 3.1% 1.0% 13.7% 5 12.31.19 16.1% 29.2% 4.7% 4.4% 54.5% 6 12.31.19 5.1% 2.6% 0.7% 0.2% 8.6% 7 2.1.20 6.0% 0.0% 21.0% 3.1% 30.2% 8 12.31.19 24.4% 9.2% 9.1% 0.0% 42.8% 10 12.31.19 12.4% 8.0% 7.1% 5.1% 32.6% 29.7% 6.8% 1.2% 10.4% 48.1% 11 6.29.19 2.9% 23.3% 17.9% 1.3% 45.3% 12 12.31.19 3.1% 64.0% 0.0% 22.6% 13 12.31.19 1.9% 4.7% 0.1% 0.8% 7.5% 0.0% 3.8% 31.3% 66.7% 0.0% Net PP&E Goodwill Intangibles & oth Total Assets 75.6% 0.8% 16.3% 100.0% 63.4% 6.8% 5.8% 100.0% 6.2% 51.5% 11.0% 100.0% 72.9% 6.8% 6.6% 100.0% 7.7% 35.2% 2.6% 100.0% 84.1% 0.0% 7.3% 100.0% 3.2% 43.4% 6.6% 7.2% 100.0% 11.0% 0.0% 40.9% 100.0% 17.8% 23.0% 26.6% 100.0% 25.1% 21.7% 7.9% 100.0% 1.7% 2.5% 6.1% 100.0% 78.8% 5.6% 8.1% 100.0% 100.0% Liabilities: Accts. Pay. ST Debt Other Total Current Liabilities 2.0% 5.4% 3.4% 10.8% 14.0% 5.7% 11.8% 31.5% 1.0% 15.2% 23.3% 39.4% 3.4% 4.8% 22.3% 30.5% 43.9% 2.3% 13.4% 59.7% 2.7% 0.6% 2.3% 5.6% 23.2% 0.4% 10.3% 33.9% 20.9% 6.4% 11.7% 39.0% 13.7% 3.0% 14.5% 31.2% 4.4% 4.3% 17.6% 26.3% 24.0% 0.2% 9.7% 34.0% 75.0% 0.8% 1.4% 2.1% 0.1% 5.4% 7.6% 31.9% 25.9% 68.6% 41.1% 8.4% 81.1% 4.8% 5.1% 49.3% 48.1% 21.5% 100.2% 25.4% 2.3% 87.4% 43.1% 20.3% 69.0% 31.8% 6.7% 72.3% 28.1% 5.4% 72.4% 27.1% 14.9% 73.3% 26.9% 15.9% 69.2% 45.2% 6.7% 85.9% 8.8% 1.4% 87.5% 98.7% 11.0% 117.3% 0.3% 12.0% 19.1% 31.4% -0.1% -25.9% 44.9% 18.9% 0.0% -19.8% 70.5% 50.7% 100.0% 0.0% 6.6% -6.8% -0.2% 0.0% 2.9% 28.0% 31.0% 100.0% 0.0% 14.7% 13.0% 27.7% 100.0% 0.0% 14.1% 13.4% 27.6% 100.0% 0.0% 13.3% 13.4% 26.7% 100.0% 0.1% -17.2% 47.9% 30.8% 100.0% 0.2% -39.7% 53.6% 14.1% 100.0% 100.0% 100.0% 100.0% LT Debt Other Total Liabilities Equity:Noncontrolling Int. Net Contr. Cap Ret. Inc. + OCI Total Equity Total Liab. & Equity ROS Asset Turnover ROA Financial Leverage ROE Current ratio Receivables collection Inventory Turnover Gross margin Dividend payout Revenue growth R & D ratio CFFO (millions) 11.5% 0.22 2.5% 3.19 7.9% 0.68 36 3.1 77.5% 64.2% 1.9% 0.37% 3,134 1.4% 2.70 3.7% 5.28 19.4% 0.76 5 13.5 22.1% 29.3% 0.4% NA 4,024 26.4% 0.54 14.2% 1.97 28.0% 0.79 50 93.8% 0.0% 23.7% 17.28% 4,422 3.7% 0.76 2.8% -508.43 -1428.8% 0.45 14 N/A N/A 10.6% 2.8% N/A 3,815 1.9% -14.0% 24.7% 12.6% 100.0% 9.0% 0.56 5.0% 7.94 39.7% 0.91 191 NA 42.1% -2.2% 1,856 27.9% 0.31 8.7% 3.22 28.1% 1.52 30 22.9% 10.4% 4,850 4.2% 1.83 7.7% 3.62 27.7% 0.89 0 6.1 28.9% 40.5% 3.7% 7,117 4.1% 1.25 5.1% 3.63 18.7% 1.10 27 8.1 -3.2% 0.0% 20.5% 12.81% 38,514 21.2% 0.77 16.3% 3.74 61.1% 1.54 32 35.3 32.2% 25.6% -2.0% 6.23% 69,391 21.0% 0.55 11.7% 3.25 37.9% 1.24 53 2.4 69.9% 57.9% 10.7% 21.08% 13,440 2.8% 3.35 9.3% 7.08 66.0% 1.33 25 15.1 19.0% 46.3% 2.4% N/A 2,411 0.0% 1.0% 11.5% 12.5% 100.0% 24.7% 0.06 1.4% 7.99 11.4% NA 4040 N/A N/A 31.1% 22.8% N/A 1,824 0.0% -123.5% 106.2% -17.3% 100.0% 28.6% 0.44 12.7% -5.79 -73.4% 0.98 39 155.2 17.6% 59.5% 0.2% N/A 8,122 Selected Financial Data for 13 Companies (Balance sheet amounts are percentage of total assets) 9 9.28.19 Year end Assets: Cash Accts. Receivable Inventory Other CA Total Current Assets 12.31.19 1.7% 2.1% 0.6% 2.9% 7.4% 2 2.1.20 3.5% 3.8% 15.7% 1.2% 24.1% 3 11.29.19 20.1% 7.4% 4 12.31.19 6.6% 2.9% 3.1% 1.0% 13.7% 5 12.31.19 16.1% 29.2% 4.7% 4.4% 54.5% 6 12.31.19 5.1% 2.6% 0.7% 0.2% 8.6% 7 2.1.20 6.0% 0.0% 21.0% 3.1% 30.2% 8 12.31.19 24.4% 9.2% 9.1% 0.0% 42.8% 10 12.31.19 12.4% 8.0% 7.1% 5.1% 32.6% 29.7% 6.8% 1.2% 10.4% 48.1% 11 6.29.19 2.9% 23.3% 17.9% 1.3% 45.3% 12 12.31.19 3.1% 64.0% 0.0% 22.6% 13 12.31.19 1.9% 4.7% 0.1% 0.8% 7.5% 0.0% 3.8% 31.3% 66.7% 0.0% Net PP&E Goodwill Intangibles & oth Total Assets 75.6% 0.8% 16.3% 100.0% 63.4% 6.8% 5.8% 100.0% 6.2% 51.5% 11.0% 100.0% 72.9% 6.8% 6.6% 100.0% 7.7% 35.2% 2.6% 100.0% 84.1% 0.0% 7.3% 100.0% 3.2% 43.4% 6.6% 7.2% 100.0% 11.0% 0.0% 40.9% 100.0% 17.8% 23.0% 26.6% 100.0% 25.1% 21.7% 7.9% 100.0% 1.7% 2.5% 6.1% 100.0% 78.8% 5.6% 8.1% 100.0% 100.0% Liabilities: Accts. Pay. ST Debt Other Total Current Liabilities 2.0% 5.4% 3.4% 10.8% 14.0% 5.7% 11.8% 31.5% 1.0% 15.2% 23.3% 39.4% 3.4% 4.8% 22.3% 30.5% 43.9% 2.3% 13.4% 59.7% 2.7% 0.6% 2.3% 5.6% 23.2% 0.4% 10.3% 33.9% 20.9% 6.4% 11.7% 39.0% 13.7% 3.0% 14.5% 31.2% 4.4% 4.3% 17.6% 26.3% 24.0% 0.2% 9.7% 34.0% 75.0% 0.8% 1.4% 2.1% 0.1% 5.4% 7.6% 31.9% 25.9% 68.6% 41.1% 8.4% 81.1% 4.8% 5.1% 49.3% 48.1% 21.5% 100.2% 25.4% 2.3% 87.4% 43.1% 20.3% 69.0% 31.8% 6.7% 72.3% 28.1% 5.4% 72.4% 27.1% 14.9% 73.3% 26.9% 15.9% 69.2% 45.2% 6.7% 85.9% 8.8% 1.4% 87.5% 98.7% 11.0% 117.3% 0.3% 12.0% 19.1% 31.4% -0.1% -25.9% 44.9% 18.9% 0.0% -19.8% 70.5% 50.7% 100.0% 0.0% 6.6% -6.8% -0.2% 0.0% 2.9% 28.0% 31.0% 100.0% 0.0% 14.7% 13.0% 27.7% 100.0% 0.0% 14.1% 13.4% 27.6% 100.0% 0.0% 13.3% 13.4% 26.7% 100.0% 0.1% -17.2% 47.9% 30.8% 100.0% 0.2% -39.7% 53.6% 14.1% 100.0% 100.0% 100.0% 100.0% LT Debt Other Total Liabilities Equity:Noncontrolling Int. Net Contr. Cap Ret. Inc. + OCI Total Equity Total Liab. & Equity ROS Asset Turnover ROA Financial Leverage ROE Current ratio Receivables collection Inventory Turnover Gross margin Dividend payout Revenue growth R & D ratio CFFO (millions) 11.5% 0.22 2.5% 3.19 7.9% 0.68 36 3.1 77.5% 64.2% 1.9% 0.37% 3,134 1.4% 2.70 3.7% 5.28 19.4% 0.76 5 13.5 22.1% 29.3% 0.4% NA 4,024 26.4% 0.54 14.2% 1.97 28.0% 0.79 50 93.8% 0.0% 23.7% 17.28% 4,422 3.7% 0.76 2.8% -508.43 -1428.8% 0.45 14 N/A N/A 10.6% 2.8% N/A 3,815 1.9% -14.0% 24.7% 12.6% 100.0% 9.0% 0.56 5.0% 7.94 39.7% 0.91 191 NA 42.1% -2.2% 1,856 27.9% 0.31 8.7% 3.22 28.1% 1.52 30 22.9% 10.4% 4,850 4.2% 1.83 7.7% 3.62 27.7% 0.89 0 6.1 28.9% 40.5% 3.7% 7,117 4.1% 1.25 5.1% 3.63 18.7% 1.10 27 8.1 -3.2% 0.0% 20.5% 12.81% 38,514 21.2% 0.77 16.3% 3.74 61.1% 1.54 32 35.3 32.2% 25.6% -2.0% 6.23% 69,391 21.0% 0.55 11.7% 3.25 37.9% 1.24 53 2.4 69.9% 57.9% 10.7% 21.08% 13,440 2.8% 3.35 9.3% 7.08 66.0% 1.33 25 15.1 19.0% 46.3% 2.4% N/A 2,411 0.0% 1.0% 11.5% 12.5% 100.0% 24.7% 0.06 1.4% 7.99 11.4% NA 4040 N/A N/A 31.1% 22.8% N/A 1,824 0.0% -123.5% 106.2% -17.3% 100.0% 28.6% 0.44 12.7% -5.79 -73.4% 0.98 39 155.2 17.6% 59.5% 0.2% N/A 8,122Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started