Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Unidentified Industries Case Introduction Industries differ on both internal and external dimensions. Internal issues such as culture and operating models are often specific to

image text in transcribedimage text in transcribedimage text in transcribed

The Unidentified Industries Case Introduction Industries differ on both internal and external dimensions. Internal issues such as culture and operating models are often specific to industries, while the external issues of the marketplace and competition will vary from industry to industry. Financial accounting provides managers with the tools to quantify these issues, and financial ratio analysis can provide the astute manager with insights into these industry differences. In this case, you are given a list of nine industries and a table of nine sets of common sized statements and financial ratios. Your task is first to consider each industrythe typical operating models of the business, the market and customer factors, and the competitive nature of the industry, and how these characteristics might manifest themselves in the selected financial ratios. Starting with these qualitative issues, then match the industries with the appropriate column of financial information. Please note tha industry characteristic will apply to every company in that industry. Why? Required 1. Match each industry described to a set of financial statement information (company letters A through I); and 2. Write your answers down in bullet point format, three reasons for each industry, addressing why you matched that industry to a particular set of financial information. Industry Retail Stores Pharmaceuticals Home Builders Grocery Stores Semiconductor Manufacturers Electric Utilities Apparel Manufacturers Steel Industry Automobile Manufacturers INCOME STATEMENT Net Sales Cost of Goods Sold Depreciation & Amortization Gross Profit R&D Expense Selling, Gen'l & Admin Exp Other Operating Expense Operating Income Non-Operating Income Interest Expense Pretax Income Taxes Other Income Net Income 100.0% 75.5% 7.2% 17.3% 0.0% 8.9% 0.0% 8.4% (0.8%) 3.5% 4.1% 1.1% 0.0% 3.0% 100.0% 60.4% 11.1% 28.5% 0.0% 1.8% 6.4% 20.2% 0.0% 6.4% 13.8% 5.3% 0.0% 8.5% 100.0% 89.1% 5.7% 5.2% 0.0% 2.3% 9.9% (7.0%) 0.1% 1.1% (8.0%) (1.4%) 0.0% (6.6%) 100.0% 80.9% 0.7% 18.4% 0.0% 10.5% 1.1% 6.8% 0.5% 2.6% 4.7% 1.0% 0.0% 3.7% 100.0% 34.9% 9.1% 56.0% 8.7% 11.1% 0.0% 36.2% 1.9% 0.1% 38.1% 13.3% 0.0% 24.7% 100.0% 75.6% 1.4% 23.0% 0.0% 19.5% 0.0% 3.4% 0.0% 1.2% 2.3% 0.9% 0.0% 1.4% 100.0% 21.4% 7.4% 71.2% 16.2% 27.1% 0.0% 27.9% 3.7% 3.9% 27.6% 6.9% 0.0% 20.7% 100.0% 64.9% 5.3% 29.8% 0.0% 15.4% 1.1% 13.3% (1.5%) 4.2% 7.6% 1.4% 0.0% 6.2% 100.0% 65.7% 3.5% 30.8% 0.0% 27.3% 0.0% 3.4% 2.9% 0.9% 5.5% 2.2% 0.0% 3.3% BALANCE SHEET Assets Cash Receivables Inventories Other Current Assets Total Current Assets Net Property, Plant & Equip Other Long Term Assets Total Assets 10.0% 28.9% 5.4% 0.0% 44.2% 30.4% 25.3% 100.0% 0.2% 7.2% 1.5% 1.2% 10.1% 79.3% 10.6% 100.0% 2.7% 6.1% 19.9% 0.4% 29.1% 47.4% 23.5% 100.0% 1.4% 3.0% 74.9% 12.6% 91.9% 0.0% 8.1% 100.0% 33.7% 15.7% 5.4% 2.8% 57.7% 35.8% 6.6% 100.0% 0.0% 5.6% 29.4% 5.4% 40.4% 52.6% 7.0% 100.0% 6.7% 12.1% 6.2% 2.2% 27.2% 30.1% 42.7% 100.0% 0.7% 6.6% 24.3% 1.5% 33.1% 35.3% 31.6% 100.0% 1.0% 26.4% 26.6% 2.6% 56.7% 42.6% 0.7% 100.0% 0.7% 4.4% Liabilities Short Term Debt Accounts Payable Other Current Liabilities Total Current Liabilities Long Term Debt Other Long Term Liabilities Total Liabilities Stockholders' Equity Minority Interest Preferred Stock Common Shareholders Equity Total Liabilities and Stockholders' Equity 38.4% 6.4% 0.0% 44.8% 0.0% 44.7% 89.5% 8.2% 3.6% 4.4% 16.2% 28.4% 22.2% 66.8% 1.0% 8.0% 9.7% 18.7% 9.7% 52.6% 81.1% 4.5% 10.2% 7.6% 22.3% 38.3% 0.0% 60.6% 1.6% 4.1% 14.8% 20.5% 3.1% 5,4% 28.9% 0.4% 28.3% 17.9% 46.6% 62.8% 10.9% 120.3% 8.5% 5.8% 15.2% 29.5% 17.6% 10.3% 57.4% 7.7% 12.8% 34.1% 11.3% 58.2% 8.0% 11.5% 9.7% 29.1% 12.2% 4.2% 45.5% 0.0% 0.0% 10.5% 100.0% 0.0% 5.4% 27.8% 100.0% 0.0% 0.3% 18.6% 100.0% 0.0% 0.3% 39.1% 100.0% 0.0% 0.0% 71.1% 100.0% 0.0% 0.0% (20.3%) 100.0% 0.0% 0.0% 42.6% 100.0% 0.0% 0.0% 41.8% 100.0% 0.0% 0.0% 54.5% 100.0% 24.74% 0.88 21.73% Exhibit 2: Selected Financial Information KEY RATIOS A Net Profit Margin 3.02% Asset Turnover 0.74 Return on Assets 2.23% Return on Equity 21.19% Current Ratio 0.99 Quick Ratio 0.87 Operating Cash Flow/Current Liabilities 0.19 A/R Days Sales Outstanding 142.62 Inventory Days on Hand 31.99 A/P Days Outstanding 41.89 Financial Leverage 9.49 Total Debt/Common Equity 3.64 Interest Coverage 2.41 Operating Cash Flow/Capital Expenditures 1.88 8.49% -6.60% 0.45 0.92 3.80% -6.04% 11.43% -31.97% 0.62 1.55 0.53 0.49 0.59 0.36 58.69 24.31 17.48 83.69 48.64 35.94 3.01 5.29 1.31 0.57 3.14 NMF 1.75 1.32 3.71% 1.26 4.66% 11.82% 4.13 0.76 -0.19 8.59 266.40 36.60 2.54 1.09 2.64 -14.95 2.81 2.55 1.80 65.18 51.50 48.61 1.41 0.07 302.12 2.89 1.40% 4.32 6.06% -29.85% 0.87 0.24 0.18 4.70 32.27 31.63 -4.93 -3.11 2.89 0.65 20.74% 0.51 10.65% 24.98% 0.92 0.71 0.47 86.30 151.87 192.20 2.35 0.61 7.09 4.49 6.18% 0.96 5.94% 14.20% 2.58 0.69 1.57 24.95 131.34 25.71 2.39 0.83 3.14 11.54 3.31% 1.65 5.46% 10.01% 1.95 1.03 0.32 58.57 85.26 38.73 1.83 0.37 3.89 1.22 MARKET DATA P/E Ratio Equity Beta Fiscal Year End 9.09 11.67 NMF 9.75 23.97 19.86 NMF 15.94 30.22 0.79 0.53 0.79 1.38 1.49 0 .44 1.23 0.26 1.32 December December December December December December December December January The Unidentified Industries Case Introduction Industries differ on both internal and external dimensions. Internal issues such as culture and operating models are often specific to industries, while the external issues of the marketplace and competition will vary from industry to industry. Financial accounting provides managers with the tools to quantify these issues, and financial ratio analysis can provide the astute manager with insights into these industry differences. In this case, you are given a list of nine industries and a table of nine sets of common sized statements and financial ratios. Your task is first to consider each industrythe typical operating models of the business, the market and customer factors, and the competitive nature of the industry, and how these characteristics might manifest themselves in the selected financial ratios. Starting with these qualitative issues, then match the industries with the appropriate column of financial information. Please note tha industry characteristic will apply to every company in that industry. Why? Required 1. Match each industry described to a set of financial statement information (company letters A through I); and 2. Write your answers down in bullet point format, three reasons for each industry, addressing why you matched that industry to a particular set of financial information. Industry Retail Stores Pharmaceuticals Home Builders Grocery Stores Semiconductor Manufacturers Electric Utilities Apparel Manufacturers Steel Industry Automobile Manufacturers INCOME STATEMENT Net Sales Cost of Goods Sold Depreciation & Amortization Gross Profit R&D Expense Selling, Gen'l & Admin Exp Other Operating Expense Operating Income Non-Operating Income Interest Expense Pretax Income Taxes Other Income Net Income 100.0% 75.5% 7.2% 17.3% 0.0% 8.9% 0.0% 8.4% (0.8%) 3.5% 4.1% 1.1% 0.0% 3.0% 100.0% 60.4% 11.1% 28.5% 0.0% 1.8% 6.4% 20.2% 0.0% 6.4% 13.8% 5.3% 0.0% 8.5% 100.0% 89.1% 5.7% 5.2% 0.0% 2.3% 9.9% (7.0%) 0.1% 1.1% (8.0%) (1.4%) 0.0% (6.6%) 100.0% 80.9% 0.7% 18.4% 0.0% 10.5% 1.1% 6.8% 0.5% 2.6% 4.7% 1.0% 0.0% 3.7% 100.0% 34.9% 9.1% 56.0% 8.7% 11.1% 0.0% 36.2% 1.9% 0.1% 38.1% 13.3% 0.0% 24.7% 100.0% 75.6% 1.4% 23.0% 0.0% 19.5% 0.0% 3.4% 0.0% 1.2% 2.3% 0.9% 0.0% 1.4% 100.0% 21.4% 7.4% 71.2% 16.2% 27.1% 0.0% 27.9% 3.7% 3.9% 27.6% 6.9% 0.0% 20.7% 100.0% 64.9% 5.3% 29.8% 0.0% 15.4% 1.1% 13.3% (1.5%) 4.2% 7.6% 1.4% 0.0% 6.2% 100.0% 65.7% 3.5% 30.8% 0.0% 27.3% 0.0% 3.4% 2.9% 0.9% 5.5% 2.2% 0.0% 3.3% BALANCE SHEET Assets Cash Receivables Inventories Other Current Assets Total Current Assets Net Property, Plant & Equip Other Long Term Assets Total Assets 10.0% 28.9% 5.4% 0.0% 44.2% 30.4% 25.3% 100.0% 0.2% 7.2% 1.5% 1.2% 10.1% 79.3% 10.6% 100.0% 2.7% 6.1% 19.9% 0.4% 29.1% 47.4% 23.5% 100.0% 1.4% 3.0% 74.9% 12.6% 91.9% 0.0% 8.1% 100.0% 33.7% 15.7% 5.4% 2.8% 57.7% 35.8% 6.6% 100.0% 0.0% 5.6% 29.4% 5.4% 40.4% 52.6% 7.0% 100.0% 6.7% 12.1% 6.2% 2.2% 27.2% 30.1% 42.7% 100.0% 0.7% 6.6% 24.3% 1.5% 33.1% 35.3% 31.6% 100.0% 1.0% 26.4% 26.6% 2.6% 56.7% 42.6% 0.7% 100.0% 0.7% 4.4% Liabilities Short Term Debt Accounts Payable Other Current Liabilities Total Current Liabilities Long Term Debt Other Long Term Liabilities Total Liabilities Stockholders' Equity Minority Interest Preferred Stock Common Shareholders Equity Total Liabilities and Stockholders' Equity 38.4% 6.4% 0.0% 44.8% 0.0% 44.7% 89.5% 8.2% 3.6% 4.4% 16.2% 28.4% 22.2% 66.8% 1.0% 8.0% 9.7% 18.7% 9.7% 52.6% 81.1% 4.5% 10.2% 7.6% 22.3% 38.3% 0.0% 60.6% 1.6% 4.1% 14.8% 20.5% 3.1% 5,4% 28.9% 0.4% 28.3% 17.9% 46.6% 62.8% 10.9% 120.3% 8.5% 5.8% 15.2% 29.5% 17.6% 10.3% 57.4% 7.7% 12.8% 34.1% 11.3% 58.2% 8.0% 11.5% 9.7% 29.1% 12.2% 4.2% 45.5% 0.0% 0.0% 10.5% 100.0% 0.0% 5.4% 27.8% 100.0% 0.0% 0.3% 18.6% 100.0% 0.0% 0.3% 39.1% 100.0% 0.0% 0.0% 71.1% 100.0% 0.0% 0.0% (20.3%) 100.0% 0.0% 0.0% 42.6% 100.0% 0.0% 0.0% 41.8% 100.0% 0.0% 0.0% 54.5% 100.0% 24.74% 0.88 21.73% Exhibit 2: Selected Financial Information KEY RATIOS A Net Profit Margin 3.02% Asset Turnover 0.74 Return on Assets 2.23% Return on Equity 21.19% Current Ratio 0.99 Quick Ratio 0.87 Operating Cash Flow/Current Liabilities 0.19 A/R Days Sales Outstanding 142.62 Inventory Days on Hand 31.99 A/P Days Outstanding 41.89 Financial Leverage 9.49 Total Debt/Common Equity 3.64 Interest Coverage 2.41 Operating Cash Flow/Capital Expenditures 1.88 8.49% -6.60% 0.45 0.92 3.80% -6.04% 11.43% -31.97% 0.62 1.55 0.53 0.49 0.59 0.36 58.69 24.31 17.48 83.69 48.64 35.94 3.01 5.29 1.31 0.57 3.14 NMF 1.75 1.32 3.71% 1.26 4.66% 11.82% 4.13 0.76 -0.19 8.59 266.40 36.60 2.54 1.09 2.64 -14.95 2.81 2.55 1.80 65.18 51.50 48.61 1.41 0.07 302.12 2.89 1.40% 4.32 6.06% -29.85% 0.87 0.24 0.18 4.70 32.27 31.63 -4.93 -3.11 2.89 0.65 20.74% 0.51 10.65% 24.98% 0.92 0.71 0.47 86.30 151.87 192.20 2.35 0.61 7.09 4.49 6.18% 0.96 5.94% 14.20% 2.58 0.69 1.57 24.95 131.34 25.71 2.39 0.83 3.14 11.54 3.31% 1.65 5.46% 10.01% 1.95 1.03 0.32 58.57 85.26 38.73 1.83 0.37 3.89 1.22 MARKET DATA P/E Ratio Equity Beta Fiscal Year End 9.09 11.67 NMF 9.75 23.97 19.86 NMF 15.94 30.22 0.79 0.53 0.79 1.38 1.49 0 .44 1.23 0.26 1.32 December December December December December December December December January

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Measuring Business Interruption Losses And Other Commercial Damages An Economic Approach

Authors: Patrick A. Gaughan

3rd Edition

1119647916, 9781119647911

More Books

Students also viewed these Accounting questions

Question

How appropriate would it be to conduct additional research?

Answered: 1 week ago

Question

Who are credible sources and opinion leaders for this public?

Answered: 1 week ago

Question

How does or how might your organization affect this public?

Answered: 1 week ago