Question

In: Accounting

Comparing Profitability Ratios for Competitors Selected income statement data for Abbott Laboratories, Bristol-Myers Squibb Company, Johnson...

Comparing Profitability Ratios for Competitors

Selected income statement data for Abbott Laboratories, Bristol-Myers Squibb Company, Johnson & Johnson, GlaxoSmithKline plc, and Pfizer, Inc. is presented in the following table:

($ millions) Abbott
Laboratories
Bristol-
Myers
Squibb
Johnson
&
Johnson
Glaxo
Smith
Kline plc
Pfizer
Sales revenue $20,247 $11,660 $74,331 $35,872 $49,605
Cost of sales 9,218 3,932 22,746 11,418 9,577
SG&A expense 6,530 4,822 21,954 13,466 14,097
R&D expense 1,345 4,534 8,494 5,379 8,393
Interest expense 150 203 533 1,134 1,360
Net income 2,284 2,029 16,323 4,297 9,168

Required
a. Compute the profit margin (PM) and gross profit margin (GPM) ratios for each company. (As a British company, GlaxoSmithKline plc has a statutory tax rate of 26.5% in 2014; assume a statutory rate of 35% for all other companies.)
(Round your answers to one decimal place.)

Abbott
Laboratories
Bristol-
Myers
Squibb
Johnson
&
Johnson
Glaxo
Smith
Kline plc
Pfizer
PM Answer Answer Answer Answer Answer
GPM Answer Answer Answer Answer Answer

b. Compute the research and development (R&D) expense to sales ratio and the selling, general and administrative (SG&A) expense to sales ratio for each company.
(Round your answers to one decimal place.)

Abbott
Laboratories
Bristol-
Myers
Squibb
Johnson
&
Johnson
Glaxo
Smith
Kline plc
Pfizer
R&D ETS Answer Answer Answer Answer Answer
SG&A ETS Answer Answer Answer Answer Answer

Solutions

Expert Solution


Related Solutions

Comparing Profitability and Turnover Ratios for Retail Companies Selected financial statement data for Best Buy Co.,...
Comparing Profitability and Turnover Ratios for Retail Companies Selected financial statement data for Best Buy Co., Inc., The Kroger Co., Nordstrom, Inc., Staples, Inc., and Walgreen Co. is presented in the following table: ($ millions) Best Buy Kroger Nordstrom Staples Walgreen Sales revenue $40,339 $108,465 $13,506 $22,492 $76,392 Cost of sales 31,292 85,512 8,406 16,691 54,823 Interest expense 90 488 138 49 156 Net income 1,233 1,728 720 135 1,932 Average receivables 1,294 1,191 2,489 1,883 2,925 Average inventories 5,275...
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...
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 Operating Characteristics Across Industries: Followings are selected income statement and balance sheet data companies in...
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...
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.. . . . . . . ....
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y720Y620Y5 Total assets$221,000 $199,000 $177,000 Notes payable (8% interest)70,000 70,000 70,000 Common stock28,000 28,000 28,000 Preferred 5% stock, $100 par14,000 14,000 14,000 (no change during year)       Retained earnings70,600 53,100 42,000 The 20Y7 net income was $18,200, and the 20Y6 net income was $11,800. No dividends on common stock were declared between 20Y5 and 20Y7. Preferred dividends...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $320,000 $288,000 $256,000 Notes payable (8% interest) 110,000 110,000 110,000 Common stock 44,000 44,000 44,000 Preferred 6% stock, $100 par 22,000 22,000 22,000 (no change during year) Retained earnings 117,200 80,880 66,000 The 20Y7 net income was $37,640, and the 20Y6 net income was $16,200. No dividends on common stock were...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $255,000 $230,000 $205,000 Notes payable (8% interest) 90,000 90,000 90,000 Common stock 36,000 36,000 36,000 Preferred 5% stock, $100 par 18,000 18,000 18,000 (no change during year) Retained earnings 94,500 68,025 54,000 The 20Y7 net income was $27,375, and the 20Y6 net income was $14,925. No dividends on common stock were...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y720Y620Y5 Total assets$221,000 $199,000 $177,000 Notes payable (8% interest)70,000 70,000 70,000 Common stock28,000 28,000 28,000 Preferred 5% stock, $100 par14,000 14,000 14,000 (no change during year)       Retained earnings70,600 53,100 42,000 The 20Y7 net income was $18,200, and the 20Y6 net income was $11,800. No dividends on common stock were declared between 20Y5 and 20Y7. Preferred dividends...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT