Question

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,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

%
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 1

A. Compute the dupont model component measures for profit margin, asset turnover, and financial leverage.

Total Assets Turnover

Sales-to-assets ratio = Sales/Total Assets	2015	2014
Sales	30,674	$31,821
Total Assets	32,898	$31,389
Sales -to-Assets Ratio	0.932	1.014

Proft Margin

Profit Margin=Net Income/Net Sales	2015	2014
Net income	5048	$4956
Net Sales	30,674	31,821
Profit Margin	0.16457	0.15575
Profit Margin	16.46%	15.57%

Financial Leverage=Total Assets/Shareholders Equity	2015	2014
Total Assets = Average assets	32,144	-
Shareholder's Equity	11,747	13,142
Financial leverage	2.74	-
Return on Assets= (Profit Margin x Asset Turnover)	15.34%	15.79%

B. Compute ROE. Confirm that ROE equals ROE computed using the component measures from part a

ROE=(Net Income/ Sales)x(Sales/Average Total Assets) x (Average total Assets/Average Shareholders Equity)=Profit Margin x Asset turnover X Financial leverage Ratio

Profit Margin	16.46%	15.57%
Asset Turnover	0.932	1.014
Financial Leverage	2.74	-
ROE=Profit Margin x Asset Turnover x financial leverage ratio	41.97%	0.00%
ROE	2015	2014
Return on Equity = Net Income/ Shareholder's Equity
Net Income	5048	4956
Shareholder's Equity	11,747	13,142
ROE	0.43	0.38
ROE	42.97%	37.71%

Compute adjusted ROA ( assume a statutory tax rate of 37% and pretax x net interest expense of $123).

ROA

Return on Assessment= Net Income/ total Assets	2015
Net Income = Net Income + after tax Interest expense	5,125
total asset = Average assets	32,144
ROA	0.1594565
ROA	15.95%