Please wright the cell formula for each answer

C 1 The following information is for Floorco, Inc. for the year just ended: 2 3 4 00 Beginning of End of year year 5 Current assets: 6 Cash $ 75,000 $ 90,000 7 Accounts receivable 158,000 140,000 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 Income taxes payable 27,000 24,000 15 16 Net income $ 94,500 17 Accumulated depreciation 19 total credits $ 45,000 14 18 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. 22 23 Prepare a schedule of net cash provided by operating activities. 24 25 $ 94,500 30 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: Depreciation 31 Increase in accounts receivable Increase in inventory Decrease in prepaid expenses 34 Decrease in accounts payable Decrease in accrued liabilities 36 Increase in income taxes payable 37 Net cash provided by operating activities 32 33 35 38 39 40