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...
-
Consider the following model: Yt = B1 + B2X2t B3X3t + B4X4t + ut Suppose the error term follows the AR(1) scheme in Eq. (10.6). How would you transform this model so that there is no autocorrelation...
-
A process, including the sensor and control valve, can be modeled by the transfer function: (a) If a proportional-only controller is used, what is the maximum value of controller gain K c that will...
-
Glamis plc manufactures, distributes and retails glassware. The following matters relate to its financial statements for the year ended 31 July 1998: (1) On 25 June 1998, one of the company's...
-
Given the balance sheets and selected data from the income statement of SMG Industries that follow, answer parts (a)(c). a. Calculate the firms operating cash flow (OCF) for the year ended December...
-
Score: 0/120 0/30 answered saved JOT Question 2 4 pt A company has a manufacturing plant that is producing quality jackets. They find that in order to produce 100 jackets in a month, it will cost...
-
Go Times Inc. has current sales of $7,500 (in millions), an operating ratio of 6%, a capital requirement ratio of 40%, a tax rate of 40% and a corporate cost of capital of 8%. Under new management...
-
Suppose ABC firm is considering an investment that would extend the life of one of its facilities for 5 years. The project would require upfront costs of $10.35M plus $23.68M investment in equipment....
-
Draw the layout of a simple thermal power plant and explain the function of its various parts.
-
a. Using difference estimation, calculate the preliminary sample size for a to e from the information provided. Apply the finite correction factor when it is appropriate. b. In general, what is the...
-
Assume you are using interval estimation for the purpose of making an adjusting entry. What would you do if materiality were \($20,000\) and the calculated confidence interval were \($8,000\) ...
-
State Grashofs law.
-
What is meant by the point estimate of the total errors for difference estimation? Calculate the point estimate when there are the following client errors in a sample of 120 items from a population...
-
Question 4 A baguette cost $0.80 in 2010 against $1.10 in 2020. A pack of pasta cost $1.20 in 2010 against $1.60 in 2020. A pack of rice cost $1.10 in 2010 against $1.45 in 2020. A kilogram of...
-
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...
-
Find an Euler circuit beginning and ending at vertex \(g\) in Graph 12 if one exists. Otherwise, explain how you know such an Euler circuit does not exist. Use the graphs and multigraphs in Figure...
-
Which of the following errors would cause a trial balance to have unequal totals? Explain your answers. a. A payment to a creditor was recorded as a debit to Accounts Payable for $129 and as a credit...
-
A student has been asked to use Fleury's algorithm to construct an Euler trail in the given graph. The student decides to begin the trail at vertex \(d\). Is this a good choice, why or why not? Refer...
Study smarter with the SolutionInn App