Balance sheets and income statements for 3M Company follow.
3M Company | ||||
---|---|---|---|---|
Consolidated Statements of Income | ||||
For Years Ended Dec. 31 ($millions) | 2015 | 2014 | 2013 | |
Net sales | $30,674 | $31,821 | $30,871 | |
Operating expenses | ||||
Cost of sales | 15,383 | 16,447 | 16,106 | |
Selling, general & administrative expenses | 6,182 | 6,469 | 6,384 | |
Research, development & related expenses | 1,763 | 1,770 | 1,715 | |
Total operating expenses | 23,328 | 24,686 | 24,205 | |
Operating income | 7,346 | 7,135 | 6,666 | |
Interest expense and income | ||||
Interest expense | 149 | 142 | 145 | |
Interest income | (26) | (33) | (41) | |
Total interest expense -net | 123 | 109 | 104 | |
Income before income taxes | 7,223 | 7,026 | 6,562 | |
Provision for income taxes | 2,167 | 2,028 | 1,841 | |
Net income inc. noncontrolling interest | 5,056 | 4,998 | 4,721 | |
Less: Net income attributable to NCI | 8 | 42 | 62 | |
Net income attributable to 3M | $5,048 | $4,956 | $4,659 |
3M Company | |||
---|---|---|---|
Consolidated Balance Sheets | |||
At December 31 ($ millions, except per share amount) | 2015 | 2014 | |
Current assets | |||
Cash and cash equivalents | $1,898 | $1,997 | |
Marketable securities--current | 198 | 1,519 | |
Accounts receivable, net | 4,154 | 4,238 | |
Inventories: | |||
Finished goods | 1,655 | 1,723 | |
Work in process | 1,008 | 1,081 | |
Raw materials and supplies | 855 | 902 | |
Total inventories | 3,518 | 3,706 | |
Other current assets | 1,398 | 1,023 | |
Total current assets | 11,166 | 12,483 | |
Marketable securities--noncurrent | 9 | 15 | |
Investments | 117 | 102 | |
Property, plant and equipment | 23,098 | 22,841 | |
Less: Accumulated depreciation | (14,583) | (14,352) | |
Property, plant and equipment--net | 8,515 | 8,489 | |
Goodwill | 9,249 | 7,050 | |
Intangible assets -net | 2,601 | 1,435 | |
Prepaid pension benefits | 188 | 46 | |
Other assets | 1,053 | 1,769 | |
Total assets | $32,898 | $31,389 | |
Liabilities | |||
Current liabilities | |||
Short-term debt & current portion of LT debt | $2,144 | $186 | |
Accounts payable | 1,774 | 1,907 | |
Accrued payroll | 644 | 732 | |
Accrued income taxes | 332 | 435 | |
Other current liabilities | 2,404 | 2,884 | |
Total current liabilities | 7,298 | 6,144 | |
Long-term debt | 8,753 | 6,705 | |
Pension and postretirement benefits | 3,520 | 3,843 | |
Other liabilities | 1,580 | 1,555 | |
Total liabilities | 21,151 | 18,247 | |
Equity | |||
3M Company shareholders' equity: | |||
Common stock, par value $0.01 per share; | |||
Shares outstanding --2015: 609,330,124; | |||
Shares outstanding --2014: 635,134,594 | 9 | 9 | |
Additional paid-in capital | 4,791 | 4,379 | |
Retained earnings | 36,575 | 34,317 | |
Treasury stock | (23,308) | (19,307) | |
Accumulated other comprehensive income (loss) | (6,359) | (6,289) | |
Total 3M Company shareholders' equity | 11,708 | 13,109 | |
Noncontrolling interest | 39 | 33 | |
Total equity | 11,747 | 13,142 | |
Total liabilities and equity | $32,898 | $31,389 |
a. Compute the DuPont model component measures for profit margin, asset turnover, and financial leverage. Then, compute ROA.
Round profit margin and ROA to two decimal
places (ex: 0.12345 = 12.35%)
Round asset turnover and financial leverage to three
decimal places.
Profit Margin: Answer (16.45% is correct)
Asset turnover: Answer
Financial leverage: Answer
ROA: Answer
b. Compute ROE. Confirm that ROE equals ROE computed using the
component measures from part a (ROE = PM x AT x FL).
Round answer to two decimal places (ex: 0.12345 = 12.35%)
Answer
c. Compute adjusted ROA (assume a statutory tax rate of 37% and
pretax net interest expense of $123).
Round answer to two decimal places (ex: 0.12345 = 12.35%)
Answer
Solution:
1) Profit margin: 16.46%
Asset turnover: 0.954
Financial leverage: 2.59
ROA: 15.7%
Working:
Profit margin = [Net income attributable to company stockholders / Sales] =5048/30674 = 16.46%
Asset turnover = [Sales / Average assets] = 30,674 / [(32898+31389)/2] = 0.954
Financial leverage = [Average assets / Average equity attributable to company stockholders] = [(32898+31389)/2] / [(11,708+13,109) /2] = 2.59
ROA = [Net income attributable to company stockholders / Average assets] = 5048 / [(32898+31389)/2] = 15.7%
2) ROE: 40.67%
ROE = [Net income attributable to company stockholders / Average equity attributable to company stockholders] = 5048 / [(11747+13142)/2] = 40.67%
Confirmation : 16.46% * 0.954 * 2.59 = 40.67%
3) Adjusted ROA: 15.95%
Adjusted ROA = {$5048 + ($123 × [1 - 0.37])} / [(32898+31389)/2]
Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For Years Ended Dec. 31 ($ millions) 2015 2014 2013 Net sales $30,274 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general & administrative expenses 6,182 6,469 6,384 Research, development & related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 6,946 7,135 6,666 Interest expense and income Interest expense 149...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years ended December 31 ($ millions) 2015 2014 2013 Net sales $30,274 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general and administrative expenses 6,182 6,469 6,384 Research, development and related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 6,946 7,135 6,666 Interest expenses and income Interest expense 149 142 145 Interest...
Thanks. Compute and Interpret Measures for DuPont Disaggregation Analysis Use the information below for 3M Company to answer the requirements (perform these computations from the perspective of a 3M shareholder). ($millions) 2015 2014 Sales $30,674 Net income, consolidated 5,056 Net income attributable to 3M shareholders 5,048 Assets 32,898 $31,389 Total equity 11,747 Equity attributable to 3M shareholders 11,708 13,109 13,142 a. Compute return on equity (ROE). Round answer to two decimal places (ex: 0.12345 = 12.35%) X % b. Compute...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2012 2011 2010 Net sales $29,904 $ 29,611 $ 226,662 Operating expenses Cost of sales 15,685 15,693 13,831 Selling, general and administrative expenses 6,102 6,170 5,479 Research, development and related expenses 1,634 1,570 1,434 -- -- -- Total operating expenses 23,421 23,433 20,744 Operating income 6,483 6,178 5,918 Interest expenses and income Interest expense 171 186...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2007 2006 2005 Net sales $24,462 $22,923 $21,167 Operating expenses Cost of sales 12,735 11,713 10,408 Selling, general and administrative expenses 5,015 5,066 4,631 Research, development and related expenses 1,368 1,522 1,274 Loss/(gain) from sale of business (849) (1,074) -- Total operating expenses 18,269 17,227 16,313 Operating income 6,193 5,696 4,854 Interest expenses and income Interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years ended December 31 ($ millions) 2015 2014 2013 Net sales $30,274 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general and administrative expenses 6,182 6,469 6,384 Research, development and related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 6,946 7,135 6,666 Interest expenses and income Interest expense 149 142 145 Interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2010 2009 2008 Net sales $26,662 $23,123 $25,269 Operating expenses Cost of sales 13,831 12,109 13,379 Selling, general and administrative expenses 5,479 4,907 5,245 Research, development and related expenses 1,434 1,293 1,404 Loss/(gain) from sale of business -- -- 23 Total operating expenses 20,744 18,309 20,051 Operating income 5,918 4,814 5,218 Interest expenses and income Interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2010 2009 2008 Net sales $26,662 $23,123 $25,269 Operating expenses Cost of sales 13,831 12,109 13,379 Selling, general and administrative expenses 5,479 4,907 5,245 Research, development and related expenses 1,434 1,293 1,404 Loss/(gain) from sale of business -- -- 23 Total operating expenses 20,744 18,309 20,051 Operating income 5,918 4,814 5,218 Interest expenses and income Interest...
Use the information below for 2018 for 3M Company to answer the requirements (perform these computations from the perspective of a 3M shareholder). Compute Measures for DuPont Disaggregation Analysis Use the information below for 2018 for 3M Company to answer the requirements (perform these computations from the perspective of a 3M shareholder). (5 millions) 2018 2017 Sales $32,765 Net income, consolidated 5.363 Net Income attributable to 3M shareholders 5.349 Assets 36,500 $37.987 9,848 11,622 Equity attributable to 3M shareholders 9.796...
Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2009 2008 2007 Net sales $23,123 $25,269 $24.462 Operating expenses Cost of sales 12.109 13.379 12,735 Selling. general and administrative expenses 4,907 5,245 5.015 Research, development and related expenses 1,293 1,404 1,368 Loss/(gain) from sale of business 23 (849) Total operating expenses 18.309 20,051 18.269 Operating income 4.814 5.218 6.193 Interest expenses and income Interest expense 219 215 210 Interest income...