In: Accounting
Operating Section of Statement of Cash Flows (Indirect
Method)
Assume following are the income statement and balance sheet for
Nike for the year ended May 31, 2012, and a forecasted income
statement and balance sheet for 2013.
Income Statement | ||
---|---|---|
($ millions) | 2012 actual | 2013 Est. |
Revenues | $ 18,627.0 | $ 21,253.0 |
Cost of sales | 10,239.6 | 11,689.0 |
Gross margin | 8,387.4 | 9,564.0 |
Selling and administrative expense | 5,953.7 | 6,801.0 |
Operating profit | 2,433.7 | 2,763.0 |
Interest income, net | 77.1 | 77.1 |
Other (expense) income, net | (7.9) | (7.9) |
Income before income taxes | 2,502.9 | 2,832.2 |
Income taxes | 619.5 | 678.0 |
Net income | $ 1,883.4 | $ 2,154.2 |
Balance Sheet | ||
---|---|---|
($ millions) | 2012 actual | 2013 Est. |
Assets | ||
Cash and equivalents | $ 2,128.9 | $ 3,301.4 |
Short-term investments | 642.2 | 642.2 |
Accounts receivable, net | 2,759.3 | 3,188.0 |
Inventories | 2,438.4 | 2,794.0 |
Deferred income taxes | 227.2 | 259.0 |
Prepaid expenses and other current assets | 643.3 | 680.0 |
Total current assets | 8,839.3 | 10,864.6 |
Property, plant and equipment* | 4,103.0 | 4,613.0 |
Accumulated depreciation | (2,211.9) | (2,556.9) |
Property, plant and equipment, net | 1,891.1 | 2,056.1 |
Goodwill and other current assets | 1,191.9 | 1,152.9 |
Deferred income taxes and other assets | 520.4 | 594.0 |
Total Assets | $ 12,442.7 | $ 14,667.6 |
Liabilities and Equity | ||
Current portion of long-term debt | $ 6.3 | $ 31.3 |
Notes payable | 177.7 | 245.7 |
Accounts payable | 1,287.6 | 1,442.0 |
Accrued liabilities | 1,761.9 | 1,975.0 |
Income taxes payable | 88.0 | 100.0 |
Total current liabilities | 3,321.5 | 3,794.0 |
Long-term debt | 441.1 | 360.8 |
Deferred income taxes and other liabilities | 854.5 | 1,024.0 |
Total liabilities | 4,617.1 | 5,178.8 |
Redeemable preferred stock | 0.3 | 0.3 |
Common stock | 2.8 | 2.8 |
Capital in excess of stated value | 2,497.8 | 2,497.8 |
Accumulated other comprehensive income | 251.4 | 251.4 |
Retained earnings | 5,073.3 | 6,736.5 |
Stockholders' equity | 7,825.6 | 9,488.8 |
Total liabilities and equity | $ 12,442.7 | $ 14,667.6 |
* Gross property, plant and equipment and accumulated
depreciation are inserted in the balance sheet; both are taken from
footnotes to the financial statements.
Prepare the net cash flows from operating activities section of a
forecasted statement of cash flows for 2013 using the indirect
method. Treat current and noncurrent deferred tax assets and
liabilities as operating. Operating expenses (such as Cost of sales
and Selling and administrative expense) for 2013 include estimated
depreciation expense of $339 million and amortization expense of
$39 million. Estimated 2013 retained earnings includes dividends of
$467 million.
Enter answers using one decimal place as shown in the above financial statements.
Use negative signs with answers to show a decrease in cash.
Nike, Inc. STATEMENT OF CASH FLOWS ($ MILLIONS) Forecasted FOR YEAR ENDED May 31, 2013 |
|
---|---|
Net income | $Answer
0.00 points out of 1.00 |
Add (Deduct) Items to Convert Net Income to Cash Basis | |
Depreciation | Answer
0.00 points out of 1.00 |
Amortization | Answer
0.00 points out of 1.00 |
Accounts receivable | Answer
0.00 points out of 1.00 |
Inventories | Answer
0.00 points out of 1.00 |
Deferred Income taxes | Answer
0.00 points out of 1.00 |
Prepaid expenses and other current assets | Answer
0.00 points out of 1.00 |
Deferred income taxes and other assets | Answer
0.00 points out of 1.00 |
Accounts payable | Answer
0.00 points out of 1.00 |
Accrued liabilities | Answer
0.00 points out of 1.00 |
Income taxes payable | Answer
0.00 points out of 1.00 |
Deferred income taxes and other liabilities | Answer
0.00 points out of 1.00 |
Net cash flow from operating activities | $Answer |
The answer has been presented in the supporting sheet. All the parts has been solved with detailed explanation and format. For detailed answer refer to the supporting sheet.