please show formulas too!

Prepare a schedule of net cash provided by operating activities, All answers must be entered as a formula. Click OK to begin OK KH 5. Prepare the Operating Activities Section of a Statement of Cash Flows using the Indirect...? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sige 0 X Calibri - - 11 - AA % M Paste BIU- A Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard 21 Font A1 : X fo The following information is for FloorCo, Inc. for the year just ended: C D E F G B 1 The following information is for FloorCo, Inc. for the year just ended: UN 2 3 4 Beginning of year End of year $ 75,000 $ 158,000 285,000 11,000 90,000 140,000 246,000 16,000 5 Current assets: 6 Cash 7 Accounts receivable 8 Inventory 9 Prepaid expenses 10 11 Current liabilities 12 Accounts payable 13 Accrued liabilties 14 Income taxes payable 284,000 9,500 27,000 302,000 11,200 24,000 15 16 Net income $ 94,500 17 Saved D A B E 1 The following information is for FloorCo, Inc. for the year just ended: 2 F G 3 ma End of year od 4 Beginning of year 5 Current assets: 6 Cash $ 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 liabiities 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 gains or losses during the year. 22 23 Prepare a schedule of net cash provided by operating activities, Sheet1 1 1 * ? Prepare a statement of cash flows using the indirect method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW 5 x FILE HOME INSERT Sign in X Calibri - 11 Paste BIU- A %6 A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font