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 | $31,385 | $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 | 8,057 | 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,934 | 7,026 | 6,562 | |
Provision for income taxes | 2,380 | 2,028 | 1,841 | |
Net income inc. noncontrolling interest | 5,554 | 4,998 | 4,721 | |
Less: Net income attributable to NCI | 8 | 42 | 62 | |
Net income attributable to 3M | $5,546 | $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 | $2,086 | $2,185 | |
Marketable securities--current | 251 | 1,572 | |
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,407 | 12,724 | |
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 | $33,139 | $31,630 | |
Liabilities | |||
Current liabilities | |||
Short-term debt & current portion of LT debt | $2,332 | $239 | |
Accounts payable | 1,827 | 2,095 | |
Accrued payroll | 644 | 732 | |
Accrued income taxes | 332 | 435 | |
Other current liabilities | 2,404 | 2,884 | |
Total current liabilities | 7,539 | 6,385 | |
Long-term debt | 8,753 | 6,705 | |
Pension and postretirement benefits | 3,520 | 3,843 | |
Other liabilities | 1,580 | 1,555 | |
Total liabilities | 21,392 | 18,488 | |
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 | $33,139 | $31,630 |
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 ______________%
Asset turnover _______________
Financial leverage _______________
ROA ______________________%
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%)
______________________%
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%)
______________________%
3M Company
Ratio analysis :
Sl no | Formula | Calculation($) | ||
a1 | Profit margin | net income / net sales | 5,546/31,385 | 17.67% |
a2 | Assets turnover | net sales / average total assets |
31,385/ (33,139+31,630)/2 = 31,385/32,384.5 |
0.969 times |
a3 | Financial leverage | average total assets/ average equity |
32,384.5/(11,747+13,142)/2 = 32,384/12,444.5 |
2.602 times |
a4 | Return on assets | (net income + interest)/ average total assets | (5,546+123)/32,384.5 | 17.51% |
b | Return on equity | Profit margin × assets turnover × financial leverage | 17.67% × 0.969 × 2.602 | 44.55% |
c | Adjusted return on assets | {net income + pre-tax interest*(1-tax)}/ average assets | (5,546+123(1-0.37))/32,384.5 | 17.36% |
Get Answers For Free
Most questions answered within 1 hours.