All solutions must be entered as a formula

Prepare a schedule of net cash provided by operating activities. ? El X Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire... INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME Sign In Calibri 11 AN Paste B IU- % Alignment Number Conditional Format as Cell Formatting* Table Styles Styles Cells Editing Clipboard Font A1 fix The following information is for FloorCo, Inc. for the year just ended: D E 1 The following information is for FloorCo, Inc. for the year just ended: B F H 2 3 4 End of year Beginning of year $ 5 Current assets: 6 Cash 7 Accounts receivable 8 Inventory 9 Prepaid expenses 10 11 Current liabilities 12 Accounts payable 13 Accrued liabiities 75,000 $ 158,000 285,000 11,000 90,000 140,000 246,000 16,000 284,000 9,500 302,000 11,200 Annon Current liabilities Accounts payable Accrued liabiities Income taxes payable 284,000 9,500 27,000 302,000 11,200 24,000 Net income $ 94,500 Accumulated depreciation total credits $ 45,000 Floor Company did not record any gains or losses during the year. Prepare a schedule of net cash provided by operating activities. FloorCo, Inc. Operating Activities Section of the Statement of Cash Flows Net income Adjustments to reconcile net income to net cash provided by operations: Depreciation Increase in accounts receivable Increase in inventory Decrease in prepaid expenses Decrease in accounts payable Sheet1 Net income Adjustments to reconcile net income to net cash provided by operations: Depreciation Increase in accounts receivable Increase in inventory Decrease in prepaid expenses Decrease in accounts payable Decrease in accrued liabilities Increase in income taxes payable Net cash provided by operating activities