Selected income statement data for Abbott Laboratories, Bristol-Myers Squibb Company, Johnson & Johnson, GlaxoSmithKline plc, and Pfizer, Inc. is presented in the following table: Bristol- Johnson Glaxo Аbbott Мyers & Smith ($ millions) Laboratories Squibb Johnson Kline plc Pfizer Sales revenue Cost of sales $38,851 $21,244 $65,030 £27,387 $67,425 15,541 5,598 20,360 7,332 15,085 SG&A expense 12,757 5,160 20,969 8,826 19,468 R&D expense 4,129 3,839 7,548 4,009 9,112 Interest expense 530 145 571 799 1,681 Net income 4,728 5,260 9,672 5,458 10,051 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.) Bristol- Johnson Glaxo Abbott Myers & Smith Laboratories Squibb Johnson Kline plc Pfizer PM GPM % % 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.)

Selected income statement data for Abbott Laboratories, Bristol-Myers Squibb Company, Johnson & Johnson, GlaxoSmithKline plc, and Pfizer, Inc. is presented in the following table: Bristol- Johnson Glaxo Аbbott Мyers & Smith ($ millions) Laboratories Squibb Johnson Kline plc Pfizer Sales revenue Cost of sales $38,851 $21,244 $65,030 £27,387 $67,425 15,541 5,598 20,360 7,332 15,085 SG&A expense 12,757 5,160 20,969 8,826 19,468 R&D expense 4,129 3,839 7,548 4,009 9,112 Interest expense 530 145 571 799 1,681 Net income 4,728 5,260 9,672 5,458 10,051 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.) Bristol- Johnson Glaxo Abbott Myers & Smith Laboratories Squibb Johnson Kline plc Pfizer PM GPM % % 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.)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
a. Prepare a common-sized income statement comparing the results of operations for Dawg Electronics Company with the industry average. If required, round percentages to one decimal place. Dawg Electronics Company Common-Sized Income Statement Dawg Electronics Dawg Electronics Electronics Industry Company Amount Company Percent Average Sales $3,750,000 100.0 % 100.0% Cost of goods sold (2,062,500) 550.0 % (61.0)% Gross profit $1,687,500 45.0 % 39.0% Selling expenses $(1,125,000) 0.3 % (23.0)% Administrative expenses (262,500) 0.7 % (10.0)% Total operating expenses $(1,387,500) 37.0 % (33.0)% Operating income $300,000 8.0 % 6.0% Other revenue and expense: Other revenue 15,000 0.4 % 3.0% Other expense (3,750) 0.1 % (1.0)% Income before income tax $311,250 8.3 % 8.0% Income tax expense (93,750) 25 % (2.5)% Net income $217,500 5.8 % 5.5%
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages. TannenhillCompany ElectronicsIndustryAverage Sales $2,740,000 100 % Cost of goods sold 1,753,600 69 Gross profit $986,400 31 % Selling expenses $602,800 18 % Administrative expenses 219,200 7 Total operating expenses $822,000 25 % Operating income $164,400 6 % Other revenue 54,800 2 $219,200 8 % Other expense 27,400 1 Income before income tax $191,800 7 % Income tax expense 82,200 5 Net income $109,600 2 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. Enter all amounts as positive…
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. TannenhillCompany ElectronicsIndustryAverage Sales $4,000,000 100.0 % Cost of goods sold (2,120,000) (60.0) Gross profit $1,880,000 40.0 % Selling expenses $(1,080,000) (24.0) % Administrative expenses (640,000) (14.0) Total operating expenses $(1,720,000) (38.0) % Operating income $160,000 2.0 % Other revenue and expense: Other revenue 120,000 3.0 Other expense (80,000) (2.0) Income before income tax expense $200,000 3.0 % Income tax expense (80,000) (2.0) Net income $120,000 1.0 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the…
Presented are the income statements of Clyton and Garner heavy equipment manufacturing companies for the current year: Clyton Garner Net sales revenue $487,000 100.00% $500,000 100.00% COGS 400, 100 82.16% 395,000 79.00% Gross Profit 86,900 17.84% 105,000 21.00% Selling/Gen Expenses Income from operations 4.11% 13.74% 10.00% 11.00% 20,000 50,000 66,900 17.100 55,000 Income tax expense 3.51% 16,500 $38,500 3.30% Net Income $49,800 10.23% 7,70% Which company has the better relationship percentage - wise between selling and general expenses compared to net sales revenue? A. Impossible to determine B. Both have the same relationship OC. Garner OD. Clyton
Common-Sized Income Statement Revenue and expense data for the current calendar year for Sorenson Electronics Company and for the electronics industry are as follows. Sorenson Electronics Company data are expressed in dollars. The electronics industry averages are expressed in percentages. SorensonElectronicsCompany ElectronicsIndustryAverage Sales $1,940,000 100 % Cost of goods sold (1,358,000) (76) Gross profit $582,000 24 % Selling expenses $(329,800) (9) % Administrative expenses (116,400) (9) Total operating expenses $(446,200) (18) % Operating income $135,800 6 % Other revenue and expense: Other revenue 38,800 4 Other expense (19,400) (3) Income before income tax $155,200 7 % Income tax expense (58,200) (5) Net income $97,000 2 % a. Prepare a common-sized income statement comparing the results of operations for Sorenson Electronics Company with the industry average. If…
Selected comparative statement data for Oriole Company are presented below. All balance sheet data are as of December 31. 20222021Net sales$1,165,000 $1,125,000Cost of goods sold705,000 645,000Interest expense20,000 15,000Net income154,945 145,000Accounts receivable145,000 125,000Inventory105,000 100,000Total assets785,000 700,000Preferred stock (6%)205,000 200,000Total stockholders’ equity635,000 525,000 Compute the following ratios for 2022. (Round answers to 1 decimal place, e.g. 1.8 or 2.5%) (a)Profit marginenter the profit margin in percentages %(b)Asset turnoverenter the asset turnover in times times(c)Return on assetsenter the return on assets in percentages %(d)Return on common stockholders’ equityenter the return on common stockholders' equity in percentages %
Net Income Planning Selected operating data for Venora Company in four independent situations are shown below. Fill in the blanks for each independent situation. A B C D Sales $410,000 $ 129,000 C. $ 530,000 e. $630,000 Variable expense $ 270,000 a. $57,000 $ 159,000 f. $ 378,000 g. Fixed expense $ 10,000 b. $56,000 $240,000 $270,000 Net income (loss) before tax $130,000 $16,000 $131,000 $(18,000) Units sold 7,000 213,000 x d. Unit contribution margin $20 $9 Contribution margin ratio 0.7 40 × h.
Forecast an Income Statement Following is the income statement for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income before income taxes 5,197 Income tax provision 547 Net income 4,650 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $4,631 Use the following assumptions to prepare a forecast of the company’s income statement for FY2020. Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal…
Vertical Analysis of Income Statement Revenue and expense data for Rogan Technologies Co. are as follows: 20Y8 20Υ7 Sales $572,000 $503,000 Cost of goods sold 366,080 286,710 Selling expenses 80,080 85,510 Administrative expenses 91,520 100,600 Income tax expense 17,160 10,060 a. Prepare an income statement in comparative form, stating each item for both 20Y8 and 20Y7 as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as a positive number. Rogan Technologies Co. Comparative Income Statement For the Years Ended December 31, 20Y8 and 20Y7 20Y8 Amount 20Y8 Percent 20Y7 Amount 20Y7 Percent % % % % Gross profit % % % Total operating expenses % % % Net income