please show formulas

Prepare a schedule of net cash provided by operating activities. 5 X Prepare the Operating Activities Section of a Statement of Cash Flows using the Indirect... ? INSERT PAGE LAYOUT FORMULAS REVIEW VIEW FILE HOME DATA Sign In Calibri -111 Paste BIU- % A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles fx The following information is for Floorco, Inc. for the year just ended: Clipboard Font A1 > B D E F G H 1 The following information is for FloorCo, Inc. for the year just ended: 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 abilities 12 Accounts payable 23 Accrued liabuities 75,000 $ 158,000 285,000 11,000 90,000 140,000 246,000 16,000 284,000 9,500 302,000 11,200 13 Accrued liabiities Income taxes payable 14 9,500 27,000 11,200 24,000 15 7 16 Net income $ 94,500 17 18 Accumulated depreciation 19 total credits $ 45,000 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 31 Increase in accounts receivable 32 Increase in inventory 33 Decrease in prepaid expenses 34 Decrease in accounts payable 35 Decrease in accrued liabilities 36 Increase in income taxes payable nces 19 total credits $ 45,000 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 26 FloorCo, Inc. Operating Activities Section of the Statement of Cash Flows 27 32 28 Net income 29 Adjustments to reconcile net income to net cash provided by operations: 30 Depreciation 31 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 34 35 38