Related questions
Compute the DuPont Disaggregation of ROE
Refer to the
FACEBOOK INC.
Consolidated Statement of Income
For Year Ended December 31, $ millions 2018
Revenue $57,449
Costs and expenses
Cost of revenue 10,966
Research and development 11,884
Marketing and sales 7,846
General and administrative 5,062
Total costs and expenses 35,758
Income from operations 21,691
Interest and other income (expense), net 2,059
Income before provision for income taxes 23,750
Provision for income taxes 3,249
Net income $20,501
FACEBOOK INC.
Consolidated Balance Sheet
At December 31, $ millions 2018 2017
Current assets
Cash and cash equivalents $11,630 $8,079
Marketable securities 31,095 35,243
Accounts receivable, net 9,198 5,832
Prepaid expenses and other current assets 1,779 1,020
Total current assets 53,702 50,174
Property and equipment, net 24,683 15,332
Intangible assets, net 1,294 1,884
Goodwill 19,912 19,832
Other assets 2,576 2,135
Total assets $102,167 $89,357
Current liabilities
Accounts payable $820 $380
Partners payable 2,152 2,001
Accrued expenses and other current liabilities 5,509 2,892
Deferred revenue and deposits 1,758 98
Total current liabilities 10,239 5,371
Other liabilities 6,190 6,417
Total liabilities 16,429 11,788
Common stock and additional paid-in capital 42,906 42,195
Accumulated other comprehensive loss (760) (227)
Total stockholders' equity 85,738 77,569
Total liabilities and stockholders' equity $102,167 $89,357
a. Compute return on equity (ROE).
Numerator Denominator ROE
Answer 1
Net income
Answer 2
Revenue
Answer 3
20,501,000
Answer 4
57,449,000
35.69
b. Apply the DuPont disaggregation into return on assets (ROA) and financial leverage.
Numerator Denominator ROA
Answer 5
Revenue
Answer 6
Average assets
Answer 7
20,501,000
Answer 8
102,167,000
20.07
Numerator Denominator FL
Answer 9
Average assets
Answer 10
Average equity
Answer 11
57,449,000
Answer 12
68,174,000
0.84
Ratio Number
ROA Answer 13
0.3007
FL Answer 14
2.2725
ROE
0.68
***ROE may be different from ROE calculation in part a due to rounding
c. Calculate the profitability and productivity components of ROA.
Numerator Denominator PM
Answer 15
Net income
Answer 16
Average equity
Answer 17
20,501,000
Answer 18
30,000,000
68.34
Numerator Denominator AT
Answer 19
Net income
Answer 20
Average equity
Answer 21
57,449,000
Answer 22
102,167,000
0.56
d. Confirm the full DuPont disaggregation: ROE = PM × AT × FL.
Ratio Number
PM Answer 23
0.356
AT Answer 24
0.563
FL Answer 25
1.191
ROE
0.24
***ROE may be different from ROE calculation in part a. due to rounding
Step by stepSolved in 2 steps with 4 images
- Refer to the balance sheets and income statement below for Facebook Inc. FACEBOOK INC. Consolidated Statement of Income For Year Ended December 31, $ millions 2018 Revenue $53,325 Costs and expenses Cost of revenue 9,355 Research and development 10,273 Marketing and sales 7,846 General and administrative 3,451 Total costs and expenses 30,925 Income from operations 22,400 Interest and other income (expense), net 448 Income before provision for income taxes 22,848 Provision for income taxes 3,249 Net income $19,599 FACEBOOK INC. Consolidated Balance Sheet At December 31, $ millions 2018 2017 Current assets Cash and cash equivalents $10,019 $8,079 Marketable securities 31,095 33,632 Accounts receivable, net 7,246 5,832 Prepaid expenses and other current assets 1,779 1,020 Total current assets 50,139 48,563 Property and equipment, net 24,683 13,721 Intangible assets, net 1,294 1,884 Goodwill 18,301 18,221 Other…arrow_forwardAnalysis and Interpretation of Ratios When RNOA Exceeds ROE Refer to the balance sheets and income statement below for Facebook Inc. FACEBOOK INC. Consolidated Statement of Income For Year Ended December 31, $ millions 2018 Revenue $55,838 Costs and expenses Cost of revenue 9,355 Research and development 10,273 Marketing and sales 7,846 General and administrative 3,451 Total costs and expenses 30,925 Income from operations 24,913 Interest and other income (expense), net 448 Income before provision for income taxes 25,361 Provision for income taxes 3,249 Net income $22,112 FACEBOOK INC. Consolidated Balance Sheet At December 31, $ millions 2018 2017 Current assets Cash and cash equivalents $10,019 $8,079 Marketable securities 31,095 33,632 Accounts receivable, net 7,587 5,832 Prepaid expenses and other current assets 1,779 1,020 Total current assets 50,480 48,563 Property and equipment, net 24,683 13,721 Intangible…arrow_forwardP3-45. Compute the DuPont Disaggregation of ROE Refer to the balance sheets and income statement below for Facebook Inc. FACEBOOK INC. Consolidated Statement of Income For Year Ended December 31, $ millions 2018 Revenue.. $55,838 Costs and expenses Cost of revenue Research and development . Marketing and sales. General and administrative.. 9,355 10,273 7,846 3,451 Total costs and expenses. . 30,925 Income from operations Interest and other income (expense), net. 24,913 448 Income before provision for income taxes Provision for income taxes. 25,361 3,249 Net income. $22,112arrow_forward
- Forecast an Income Statement Following is the income statement for Medtronic PLC for the year ended April 29, 2016. Consolidated Statements of Income Apr. 29, 2016 Net sales $29,721 Costs and expenses Cost of products sold 9,214 Research and development expense 2,224 Selling, general, and administrative expense 9,469 Special charges (gains), net 70 Restructuring charges, net 290 Certain litigation charges, net 26 Acquisition-related items 283 Amortization of intangible assets 1,931 Other expense, net 107 Operating profit 6,107 Interest expense, net 955 Income from operations before income taxes 5,152 Provision for income taxes 979 Net income $4,173 Use the following assumptions to prepare a forecast of the company's income statement for FY2017. Net sales increase 18% Cost of products sold 31.7% of net sales Research and development expense 7.7% of net sales Selling, general, and administrative expense 32.8% of net sales…arrow_forwardPresented below is the 2018 income statement and comparative balance sheet information for Tiger Enterprises.TIGER ENTERPRISESIncome StatementFor the Year Ended December 31, 2018($ in thousands)Sales revenue $7,000Operating expenses:Cost of goods sold $3,360Depreciation 240Insurance 100Administrative and other 1,800Total operating expenses 5,500Income before income taxes 1,500Income tax expense 600Net income $ 900Balance Sheet Information ($ in thousands) Dec. 31, 2018 Dec. 31, 2017Assets:Cash $ 300 $ 200Accounts receivable 750 830Inventory 640 600Prepaid insurance 50 20Plant and equipment 2,100 1,800Less: Accumulated depreciation (840) (600)Total assets $3,000 $2,850Liabilities and Shareholders’ Equity:Accounts payable $ 300 $360Payables for administrative and other expenses 300 400Income taxes payable 200 150Note payable (due 12/31/2019) 800 600Common stock 900 800Retained earnings 500 540Total liabilities and shareholders’ equity $3,000 $2,850Required:Prepare Tiger’s statement of…arrow_forwardwhat is the return in assets for each year?arrow_forward
- Subject: accountingarrow_forwardPreparation of Ratios The financial statements for Venus Industries follow: Venus IndustriesConsolidated Income Statements(in thousands, except per share data) Year ended December 31, 2023 2022 2021 Revenues $4,578,041 $3,864,324 $3,003,610 Costs and expenses: Cost of goods sold $2,227,189 $2,089,089 $2,005,691 Selling and administrative 922,261 836,212 664,061 Interest 29,744 32,966 30,472 Other expenses (income) 1,475 2,141 (43) Total costs and expenses $3,180,669 $2,960,408 $2,700,181 Income before income taxes $1,397,372 $903,916 $303,429 Income taxes 229,500 192,600 174,700 Net income $1,167,872 $711,316 $128,729 Venus IndustriesConsolidated Balance Sheets (in thousands) December 31, ASSETS 2023 2022 Current assets: Cash and equivalents $291,284 $260,050 Accounts receivable, less allowance for doubtful accounts of $19,447 and $20,046 807,530 596,018 Inventories 592,986 512,917 Deferred income taxes 26,378 28,355…arrow_forwardDirect Computation of Nonoperating ReturnBalance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years Ended December 31 ($ millions) 2018 2017 Net sales $32,765 $31,657 Operating expenses Cost of sales 16,682 16,055 Selling, general and administrative expenses 7,602 6,626 Research, development and related expenses 1,821 1,870 Gain on sale of businesses (547) (586) Total operating expenses 25,558 23,965 Operating income 7,207 7,692 Other expense, net* 207 144 Income before income taxes 7,000 7,548 Provision for income taxes 1,637 2,679 Net income including noncontrolling interest 5,363 4,869 Less: Net income attributable to noncontrolling interest 14 11 Net income attributable to 3M $5,349 $4,858 * Interest expense, gross is $350 million in 2018 and $322 million in 2017. 3M COMPANY Consolidated Balance Sheets At December 31 ($ millions) 2018 2017 Current assets…arrow_forward
- The condensed income statement and comparative balance sheet of Donald Corporation as of December 31, 2022 and 2021, are provided below. Other financial data is also given. DONALD CORPORATIONCondensed Income StatementYear Ended December 31, 2022 Revenues $ 671,500 Costs and Expenses Cost of Goods Sold 428,600 Salaries Expense 124,600 Depreciation Expense 14,600 Advertising Expense 14,500 Utilities Expense 17,600 Total Costs and Expenses $ 599,900 Net Income Before Income Taxes 71,600 Income Taxes Expense 17,900 Net Income After Income Taxes $ 53,700 DONALD CORPORATIONComparative Balance SheetDecember 31, 2022 and 2021 Assets 2022 2021 Cash $ 72,600 $ 67,000 Accounts Receivable (Net) 55,050 51,600 Merchandise Inventory 48,600 53,400 Prepaid Advertising 7,600 9,400 Property, Plant, and Equipment 120,000 96,000 Less: Accumulated…arrow_forwardAnalysis and Interpretation of ProfitabilityBalance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years ended December 31 ($ millions) 2018 2017 Net sales $32,765 $31,657 Operating expenses Cost of sales 16,682 16,055 Selling, general and administrative expenses 7,602 6,626 Research, development and related expenses 1,821 1,870 Gain on sale of businesses (547) (586) Total operating expenses 25,558 23,965 Operating income 7,207 7,692 Other expense, net* 207 144 Income before income taxes 7,000 7,548 Provision for income taxes 1,637 2,679 Net income including noncontrolling interest 5,363 4,869 Less: Net income attributable to noncontrolling interest 14 11 Net income attributable to 3M $ 5,349 $ 4,858 *Interest expense, gross $350 million in 2018 and $322 million in 2017. 3M COMPANY Consolidated Balance Sheets At December 31 ($ millions, except per share amount) 2018 2017…arrow_forwardPreparing Common Size Statements The financial statements for Venus Industries follow: Venus IndustriesConsolidated Income Statements(in thousands, except per share data) Year ended December 31, 2023 2022 2021 Revenues $4,578,041 $3,864,324 $3,003,610 Costs and expenses: Cost of goods sold $2,227,189 $2,089,089 $2,005,691 Selling and administrative 922,261 836,212 664,061 Interest 29,744 32,966 30,472 Other expenses (income) 1,475 2,141 (43) Total costs and expenses $3,180,669 $2,960,408 $2,700,181 Income before income taxes $1,397,372 $903,916 $303,429 Income taxes 229,500 192,600 174,700 Net income $1,167,872 $711,316 $128,729 Venus IndustriesConsolidated Balance Sheets (in thousands) December 31, ASSETS 2023 2022 Current assets: Cash and equivalents $291,284 $260,050 Accounts receivable, less allowance for doubtful accounts of $19,447 and $20,046 826,977 616,064 Inventories 592,986 512,917 Deferred income taxes 26,378…arrow_forward
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education