Requesting input/assistance in matching the industries to the ratios given the financial data Ratio Industry Reasoning 1.
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Here is my analysis of matching the industries to the ratios given the financial data 1 Return on sales Highest ROS would be in industries with high profit margins like drug manufacturing software dev... View the full answer
Related Book For
International Financial Reporting and Analysis
ISBN: 978-1408075012
5th edition
Authors: David Alexander, Anne Britton, Ann Jorissen
Posted Date:
Students also viewed these finance questions
-
Solve log5 (x 4) +log5 (x+2) State any restrictions. = log(10-28) log 5 . Your answer must be simplified fully
-
Question one. Commonwealth Bank of Australia (CBA) has reported a 99% Value at Risk (VaR) of 3.09% over a 1268 trading period. What does this mean? (3 marks) b. Why do some investors prefer to use...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Demonstrate competency in the behavioral finance you are required to complete the following learning demonstration. 1. Executive summary 2) A numeric example demonstrating violations of expected...
-
Determine the structure of each of the following compounds based on its molecular formula and its IR and 1H NMR spectra. a. C6H12O b. C6H14O QUESTION CONTINUE TO NEXT PAGE c. C10H13NO3 d. C11H14O2...
-
In Problems 4152, find the domain of each function. 1 g(x) = In(x - 5)
-
Upland Metals Company had 20,000,000 shares of \(\$ 0.01\) par value common stock outstanding which had been sold for an aggregate amount of \(\$ 300,000,000\). The company's shares are traded on the...
-
The inverse demand for a homogeneous- product Stackelberg duopoly is P 16,000 4Q. The cost structures for the leader and the follower, respectively, are CL(QL) = 4,000QL and CF (QF) = 6,000QF. a....
-
Thalassines Kataskeves, S.A., of Greece makes marine equipment. The company has been experiencing losses on its bilge pump product line for several years. The most recent quarterly contribution...
-
1. Assume a 30% tax rate, and the Totals per financial statements provided. Complete the following schedule as per Figure 16.4. Assume that the Totals per financial statements (second to bottom row)...
-
Owens parents, who are retired, have gifted Owen $2,500 every December since Ellies birth in 2015, which Owen then immediately contributed to an RESP for Ellie before year-end. i. For tax purposes,...
-
In general, what impacts may a firm's dividend policy, profitability, and capital intensity have on its financing requirements?
-
The three strikes law requires a person who is convicted of a felony offense and who has one or two other previous serious felony convictions to serve a mandatory life sentence in prison, with or...
-
(B) As another option, Mrs. Smith is considering letting her heirs fend for themselves and using her $420,000 to generate $3,300 per month for the rest of her life. 1. If Mrs. Smith manages to...
-
Write a program that gets a string from the user and determines whether the string is a valid social security number in DDD-DD-DDDD format, where the D's are the digits 0 - 9. Your program must...
-
describe why you think it is important to develop a workflow plan for each service period. Explain in details.
-
Putting all your personal information in the cloud means letting go of some control over information like your tax files, personal photos that might not want anyone else to see, term papers you're...
-
The Dow Jones Industrial Average reached a high of $ 7801.63 on December 29, 1997. Recall from Example 18.4 that it reached a high of $ 1003 on November 14, 1972. The Consumer Price Index for...
-
Identify as many examples as possible where the choice of accounting policy could significantly affect the analysis and interpretation of published financial statements.
-
Obtain three sets of published accounts of quoted companies. Look carefully at the consolidated balance sheets and notes thereto and read the 'accounting policies'. Taking each item in the balance...
-
Omega prepares financial statements under International Financial Reporting Standards. In the year ended 31 March 2007 the following transactions occurred: Transaction 1 On 1 April 2006 Omega began...
-
Describe how monopoly regulation influences output, price, economic profit, and efficiency.
-
Describe and explain the inefficiencies of monopoly.
-
Why is pure monopoly rare?
Study smarter with the SolutionInn App