In: Finance
Income statements and balance sheets follow for E.I. DuPont de Nemours and Company. Refer to these financial statements to answer the requirements.
|
E. I. du Pont de Nemours and Company Consolidated Income Statements For The Year Ended December 31, |
||
|
($ millions) |
2016 |
2015 |
|
Net sales |
$ 24,594 |
$ 25,130 |
|
Cost of goods sold and other operating charges |
15,155 |
15,571 |
|
Selling, general and administrative expenses |
4,319 |
4,615 |
|
Research and development expense |
1,641 |
1,898 |
|
Other (income) expense, net (non-operating) |
(708) |
(697) |
|
Interest expense |
370 |
342 |
|
Employee separation/asset related charges(income), net |
552 |
810 |
|
Income from continuing operations before income taxes |
3,265 |
2,591 |
|
Provision for income taxes on continuing operations |
744 |
696 |
|
Income from continuing operations after income taxes |
2,521 |
1,895 |
|
Income from discontinued operations after income taxes |
4 |
64 |
|
Net income |
2,525 |
1,959 |
|
Less: Net income attributable to noncontrolling interests |
12 |
6 |
|
Net income attributable to DuPont |
$ 2,513 |
$ 1,953 |
|
E. I. du Pont de Nemours and Company Consolidated Balance Sheets As of December 31, |
||
|
($ millions) |
2016 |
2015 |
|
Assets |
||
|
Cash and cash equivalents |
$ 4,605 |
$ 5,300 |
|
Marketable securities |
1,362 |
906 |
|
Accounts and notes receivable, net |
4,971 |
4,643 |
|
Inventories |
5,673 |
6,140 |
|
Prepaid expenses |
506 |
398 |
|
Total current assets |
17,117 |
17,387 |
|
Net property, plant and equipment |
9,231 |
9,784 |
|
Goodwill |
4,180 |
4,248 |
|
Other intangible assets |
3,664 |
4,144 |
|
Investment in affiliates |
649 |
688 |
|
Deferred income taxes |
3,308 |
3,799 |
|
Other assets |
1,815 |
1,116 |
|
Total assets |
$39,964 |
$41,166 |
Table continued next page
Table continued
|
E. I. du Pont de Nemours and Company Consolidated Balance Sheets—continued As of December 31, |
||
|
(in millions) |
2016 |
2015 |
|
Liabilities and equity |
||
|
Accounts payable |
$ 3,705 |
$ 3,398 |
|
Short-term borrowings and capital lease obligations |
429 |
1,165 |
|
Taxes payable |
101 |
173 |
|
Other accrued liabilities |
4,662 |
5,580 |
|
Total current liabilities |
8,897 |
10,316 |
|
Long-term borrowings and capital lease obligations |
8,107 |
7,642 |
|
Other liabilities |
12,333 |
12,591 |
|
Deferred income taxes |
431 |
417 |
|
Total liabilities |
29,768 |
30,966 |
|
Common stock, $0.30 par value |
285 |
288 |
|
Preferred stock, without par value – cumulative |
237 |
237 |
|
Additional paid-in capital |
11,190 |
11,081 |
|
Reinvested earnings |
14,924 |
14,510 |
|
Accumulated other comprehensive loss |
(9,911) |
(9,396) |
|
Common stock held in treasury |
(6,727) |
(6,727) |
|
Total DuPont stockholders’ equity |
9,998 |
9,993 |
|
Noncontrolling interests |
198 |
207 |
|
Total equity |
10,196 |
10,200 |
|
Total liabilities and stockholders’ equity |
$39,964 |
$41,166 |
Required
a. Compute net operating profit after tax (NOPAT) for 2016 and 2015. Assume that combined federal and state statutory tax rate is 37% for both years.
b. Compute net operating assets (NOA) for 2016 and 2015.
c. Compute return on net operating assets (RNOA) for 2016 and 2015. Net operating assets are $13,239 million in 2014.
a). Solution
Net operating profit after tax (NOPAT) = Income from continuing operations before tax * (1 - Tax rate).
Year 2016
Net operating profit after tax (NOPAT) = 3265 * (1 - 0.37) = $ 2065.95
Year 2015
Net operating profit after tax (NOPAT) = 2591 * (1 - 0.37) = $ 1632.33
|
Net operating profit after tax (NOPAT) for the Year 2015 |
$ 1632.33 |
|
Net operating profit after tax (NOPAT) for the Year 2016 |
$ 2065.95 |
b). Solution :- Net Operating Assets (NOA) = Operating assets - Operating liabilities.
Year 2016
Operating assets = (Total assets - Non-Operating Assets )
= ( Total assets - ( Cash + Marketable Securities + Loan Receivables ) )= (39964 - (4605 + 1362 + 0) = $ 33,997
Operating liabilities = (Total liabilities - Short-term borrowings - Long-term borrowings)
= (29768 - 429 - 8107)
= $ 21232.
Thus,, Net Operating Assets (NOA) = $ 33,997 - $ 21232 = $ 12,765.
Year 2015
Operating assets = (Total assets - Non-Operating Assets )
= (Total assets - (Cash + Marketable Securities + Loan Receivables ) ) = (41166 - (5,300 + 906 + 0) ) = $ 34960.
Operating liabilities = (Total liabilities - Short-term borrowings - Long-term borrowings)
= (30966 - 1165 - 7642)
= $ 22159.
Thus, Net Operating Assets (NOA) = 34960 - 22159 = $ 12801.
|
Net Operating Assets (NOA) for the Year 2015 |
$ 12,765 |
|
Net Operating Assets (NOA) for the Year 2016 |
$ 12,801 |
c). Solution :- Return on net operating assets (RNOA) = (Net income / Average net operating assets).
Year 2016
Return on net operating assets (RNOA) = 2525 / ( $ 12,765 + $ 12,801) / 2
= 2525 / (25,566 / 2)
= 2525 / 12783
= 0.197528 i.e., 19.75 %
Year 2015
Return on net operating assets (RNOA) = 1959 / ( $ 12,765 + $ 12,801) / 2
= 1959 / (25,566 / 2)
= 1959 / 12783
= 0.15325 i.e., 15.325 %
|
Return on net operating assets (RNOA) for Year 2015 |
15.325 % |
|
Return on net operating assets (RNOA) for Year 2016 |
19.75 % |