Question

In: Finance

Comparing Operating Characteristics Across Industries: Followings are selected income statement and balance sheet data companies in...

  1. Comparing Operating Characteristics Across Industries: Followings are selected income statement and balance sheet data companies in different industries.

$millions

Sales

Cost of Goods Sold

Gross

Profit

Net Income

Total Assets

Total Liabilit.

Stockholders’ Equity

Target Corp

73785

51997

21788

3363

40262

27305

12957

Nike Inc

32376

17405

14971

3760

21396

9138

12258

Harley-Davidson

5995

3620

2375

752

9991

8151

1840

Cisco System

49247

18287

30960

10739

58067

58067

63585

a)   Compute the following ratios for each company:

Gross Profit/ Sales

Net Income/ Sales

Net Income/ Stockholders’ Equity

Liabilities/ Stockholders’ Equity

Target Corp

Nike Inc

Harley-Davidson

Cisco System

b)   Comment on any differences among the companies’ gross profit-to-sale ratios and net income as a percentage of sales. Do differences in the companies’ business models explain the differences observed?

c)   Which company reports the highest ratio of net income to equity? Suggest one or more reasons for this result.

d)   Which company has financed itself with the highest percentage of liabilities to equity? Suggest one or more reasons for this result on such debt levels.

Solutions

Expert Solution

a)

Gross Profit/ Sales Net Income/ Sales Net Income/ Stockholders’ Equity Liabilities/ Stockholders’ Equity
Target Corp 29.53% 4.56% 25.96% 2.11
Nike Inc 46.24% 11.61% 30.67% 0.75
Harley-Davidson 39.62% 12.54% 40.87% 4.43
Cisco System 62.87% 21.81% 16.89% 0.91

b) We can observe differences between Gross Profit/Sales and Net Income/Sales. Gross profit/ Sales is gross profit margin, it is the margin considering cost of goods sold. Net income/Sales is net profit margin considering the COGS, Finance cost, operational expenses, this is more stringent measure of profitability. Difference being large in the case of Target Corp and Nike Inc, as these are mostly run through retail chains, their operating expenses will be high. Cisco system being a software company will have low COGS and gross profit margin will be high. Harley Davidson is providing better net profit margin in comparison to Nike Inc even when gross profit margin is less.

c)Harley Davidson is reporting highest Net Income/ Stockholders’ Equity, ROE. Every company requires funds to grow. The cash for investment can come from retained earnings, issuing new equity, or borrowing. In the first two cases, the ROE will capture this use of capital to grow. In the latter case, the debt used for growth will improve returns, but won’t affect the total equity. That will make the ROE look better than if no debt was used. Harley-Davidson makes extensive use of debt to improve its returns, because it has a relatively high Liabilities/ Stockholders’ Equity of 4.43. That is the reason for impressive ROE.

d) Harley Davidson is reporting highest Liabilities/ Stockholders’ Equity, debt to equity ratio. The company is using debt to finance all major investments, this is to retain good return on equity.


Related Solutions

Comparing Operating Characteristics Across Industries Following are selected income statement and balance sheet data for companies...
Comparing Operating Characteristics Across Industries Following are selected income statement and balance sheet data for companies in different industries. $ millions Sales Cost of Goods Sold Gross Profit Net Income Assets Liabilities Stockholders' Equity Target Corp. $73,785 $51,997 $21,788 $3,363 $40,262 $27,305 $12,957 Nike, Inc. 32,376 17,405 14,971 3,760 21,396 9,138 12,258 Harley-Davidson 5,995 3,620 2,375 752 9,991 8,151 1,840 Cisco Systems 49,247 18,287 30,960 10,739 121,652 58,067 63,585 (a) Compute the following ratios for each company. Round all answers...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing retailer in the high-end market) and TJX Companies (clothing retailer in the value-priced market). (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (example: 0.2345 = 23.5%). Income Statement ($ millions) ANF TJX Sales $3,469 $21,942 Cost of goods sold 1,257 Answer% 16,040 Answer% Gross profit 2,212...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing in the high-end market) and TJX Companies (clothing retailer in the value priced market), for the fiscal year ended January 30, 2016. (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (ex: 0.2345 = 23.5%) Income Statement ($ thousands) ANF TJX Sales $3,518,680 $30,944,938 Cost of goods...
INCOME STATEMENT AND BALANCE SHEET FOR 2015 SELECTED U.S. INDUSTRIES FOR 2015 (Figures in $ millions)...
INCOME STATEMENT AND BALANCE SHEET FOR 2015 SELECTED U.S. INDUSTRIES FOR 2015 (Figures in $ millions) Food Pharmaceuticals Oil and Coal Computers and Peripherals Food Stores Income Statement Data: Sales $ 676.7 $ 396.8 $ 1,049.2 $ 206.1 $ 463.7 Cost of goods sold 614.2 328.9 990.6 166.3 439.8 Balance Sheet Data: Inventory $ 64.1 $ 52.4 $ 49.5 $ 8.8 $ 25.1 Accounts receivable 51.4 60.6 73.2 20.2 5.7 Accounts payable 41.8 39.2 76.3 28.3 21.6 Note: Cost of...
Comparing Cash Flows Across Retailers Following are selected accounts from the income statement and the statement...
Comparing Cash Flows Across Retailers Following are selected accounts from the income statement and the statement of cash flows for several retailers, for their fiscal years ended in 2016. $ millions: Sales Net Income Operating Investing Financing Macy’s . . . . . . . . . . . . . . . . . . . . . . $ 27,079 $ 1,072 $ 1,984 $ (1,092) $ (2,029) Home Depot Inc.. . . . . . . ....
A. Use the following selected balance sheet and income statement data for Mattel Inc. (in $...
A. Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands) to compute a) return on equity, b) profit margin (PM), c) asset turnover (AT), and d) financial leverage (FL) for fiscal 2016. Show that ROE = PM × AT × FL. (in thousands) 2016 2015 Net sales $5,456,650 $5,702,613 Operating income 619,233 640,922 Interest expense 95,118 85,270 Net income 318,022 369,416 Total assets 6,493,794 6,535,143 Total liabilities 4,086,012 3,901,889
Selected data derived from the income statement and balance sheet of National Beverage Co. for a...
Selected data derived from the income statement and balance sheet of National Beverage Co. for a recent year are as follows: 1 Income statement data (in thousands): 2 Net income $49,311.00 3 Gain on disposal of property 1,188.00 4 Depreciation expense 11,580.00 5 Other items involving noncash expense 1,383.00 6 Balance sheet data (in thousands): 7 Increase in accounts receivable 1,746.00 8 Decrease in inventory 990.00 9 Increase in prepaid expenses 605.00 10 Decrease in accounts payable and other current...
Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands)...
Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands) to compute a) return on equity, b) profit margin (PM), c) asset turnover (AT), and d) financial leverage (FL) for fiscal 2013. Show that ROE = PM × AT × FL. (in thousands) 2013 2012 Net sales $6,484,892 $6,420,881 Operating income 1,168,103 1,021,015 Interest expense 5,555 6,841 Net income 903,944 776,464 Total assets 6,439,626 6,526,785 Total liabilities 3,188,067 3,459,741
Selected data derived from the income statement and balance sheet of National Beverage Co. for a...
Selected data derived from the income statement and balance sheet of National Beverage Co. for a recent year are as follows: 1 Income statement data (in thousands): 2 Net income $43,993.00 3 Depreciation expense 10,651.00 4 Losses on inventory write-down and fixed assets 7.00 5 Other noncash items (187.00) 6 Balance sheet data (in thousands): 7 Increase in accounts receivable 5,679.00 8 Increase in inventory 7,509.00 9 Increase in prepaid expenses 2,239.00 10 Decrease in accounts payable and other current...
The following table shows income statement and balance sheet data for five U.S. industries in 2017....
The following table shows income statement and balance sheet data for five U.S. industries in 2017. INCOME STATEMENT AND BALANCE SHEET FOR 2017 SELECTED U.S. INDUSTRIES FOR 2017 (Figures in $ billions) Food Pharmaceuticals Oil and Coal Computers and Peripherals Food Stores Income Statement Data: Sales $ 679.9 $ 440.5 $ 815.0 $ 229.0 $ 487.2 Cost of goods sold 609.1 365.4 770.8 215.7 464.0 Balance Sheet Data: Inventory $ 80.8 $ 69.8 $ 57.2 $ 24.3 $ 40.9 Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT