prepare a schedule of net cash provided by operating activities.

wuestions must be entered using a formula

Prepare a schedule of net cash provided by operating activities. 35 Sign in X 5. Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire... ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Calibri 11 A A % M Cell Cells Paste BIU- A Alignment Number Conditional Format as Editing Formatting Table Styles Clipboard Font Styles E35 fo - F G H B D E 1 The following information is for FloorCo, Inc. for the year just ended: 2 4 End of year es 3 Beginning of year 5 Current assets: 6 Cash s 75.000 $ 90.000 7 Accounts receivable 158,000 140,000 8 Inventory 285,000 246,000 9 Prepaid expenses 11,000 16,000 10 11 Current liabilities 12 Accounts payable 284,000 302,000 13 Accrued liabilities 9.500 11.200 14 Income taxes payable 27,000 24,000 15 16 Net income $ 94,500 17 18 Accumulated depreciation 19 total credits $ 45.000 20 21 Floor Company did not record any cains or losses during the year, 10 Sign In 3 5.3.3 Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW .8 Calibri - 11 A A % BIU- A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Paste Clipboard Font E35 > B E F H D 45,000 total credits $ 19 20 21 Floor Company did not record any gains or losses during the year. 22 23 Prepare a schedule of net cash provided by operating activities. 24 25 FloorCo, Inc. 26 Operating Activities Section of the Statement of Cash Flows 27 28 Net income 29 Adjustments to reconcile net income to net cash provided by operations: 30 Depreciation Increase in accounts receivable Increase in inventory 33 Decrease in prepaid expenses Decrease in accounts payable Decrease in accrued liabilities 36 Increase in income taxes payable 37 Net cash provided by operating activities 38 39 31 32 34 35 40 41