Question

In: Accounting

Operating Section of Statement of Cash Flows (Indirect Method) Assume following are the income statement and...

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

Solutions

Expert Solution

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.


Related Solutions

Operating Section of Statement of Cash Flows (Indirect Method) Assume following are the income statement and...
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)...
Create the “Operating Section”of the statement of cash flows using the indirect method(ONLYTHE OPERATING SECTION). Place...
Create the “Operating Section”of the statement of cash flows using the indirect method(ONLYTHE OPERATING SECTION). Place your answer on this page(operating section only, indirect method).
Prepare the Cash flows from operating activities section of the statement of cash flows, using the indirect method.
Demers Inc. reported the following data:ParticularsAmount$Net income490,000Depreciation expense52,000Gain on Disposal of equipment26,500Decrease in accounts receivable32,400Decrease in accounts payable12,350Prepare the cash flows from operating activities section of the statement of cash flows using the indirect method
Prepare the cash flows from operating activities section of Mansfield's statement of cash flows using the indirect method.
Net income of Mansfield Company was $45,000. The accounting records reveal depreciation expense of $80,000 as well as increases in prepaid rent, salaries payable, and income taxes payable of $60,000, $15,000, and $12,000, respectively. Prepare the cash flows from operating activities section of Mansfield's statement of cash flows using the indirect method.
Which of the following would NOT be reported in the Operating Section of the Statement of Cash Flows when using the Indirect Method?
Which of the following would NOT be reported in the Operating Section of the Statement of Cash Flows when using the Indirect Method?Dividends receivedInterest paid on a noteLoss on sale of equipmentDividends paid
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the current year was $123,300. Depreciation recorded on store equipment for the year amounted to $20,300. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $47,100 $42,860 Accounts receivable (net) 33,770 31,670 Inventories 46,110 48,220 Prepaid expenses 5,180 4,070 Accounts payable (merchandise creditors) 44,130 40,550 Wages payable...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the current year was $313,300. Depreciation recorded on equipment and a building amounted to $93,700 for the year. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $78,330 $81,460 Accounts receivable (net) 99,320 100,520 Inventories 195,830 173,180 Prepaid expenses 10,890 11,490 Accounts payable (merchandise creditors) 87,490 90,910...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the current year was $126,900. Depreciation recorded on store equipment for the year amounted to $20,900. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $48,220 $44,360 Accounts receivable (net) 34,570 32,780 Merchandise inventory 47,210 49,910 Prepaid expenses 5,300 4,210 Accounts payable (merchandise creditors) 45,180 41,960 Wages...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the current year was $261,800. Depreciation recorded on equipment and a building amounted to $78,300 for the year. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $71,730 $74,600 Accounts receivable (net) 90,950 92,060 Inventories 179,330 158,600 Prepaid expenses 9,970 10,520 Accounts payable (merchandise creditors) 80,120 83,250...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the current year was $235,000. Depreciation recorded on equipment and a building amounted to $70,300 for the year. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $63,450 $66,620 Accounts receivable (net) 80,450 82,210 Inventories 158,630 141,630 Prepaid expenses 8,820 9,390 Accounts payable (merchandise creditors) 70,870 74,350...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT