All answers must be submitted as Excel formula.

Prepare a schedule of net cash provided by operating activities. = Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire... ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW L -AA % A Ce Paste Alignment Number Editing Conditional Format as Cell Formatting* Table Styles Clipboard G Styles F28 X fx =D16 A B D E F 1 The following information is for FloorCo, Inc. for the year just ended: 2 3 4 Beginning of year End of year 5 Current assets: Cash $ 90,000 7 Accounts receivable 140,000 8 Inventory 246,000 9 Prepaid expenses 16,000 10 11 Current liabilities 12 Accounts payable 302,000 13 Accrued liabiities 11,200 14 Income taxes payable 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 www READY Attempt(s) 0/3 Calibri B IU- 11 P. Font 75,000 $ 158,000 285,000 11,000 284,000 9,500 27,000 Cells G H Hint Sign In 100% + Show Me Prepare a schedule of net cash provided by operating activities. XS-2 FILE Paste Clipboard F28 = Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire... ? INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri FEB 11 % B I U - Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Font Styles 1 X fx =D16 A B D E F 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 37 Net cash provided by operating activities 38 39 40 41 Sheet1 E- HOME G READY Attempt(s) 0/3 $ 94,500 G H Hint 6 Sign In X 100% Show Me