80.2K

Verified Solution

Link Copied!

please add the formulas only!!!

Prepare a schedule of net cash provided by operating activities. XH - Prepare the Operating Activities Section of a Statement of Cash Flows using the Indir FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 - ' ' DA Paste BIU % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Clipboard Font A1 X To The following information is for FloorCo, Inc. for the year ju B D E F 3 G 4 End of year Beginning 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 liabiities 14 Income taxes payable 15 284,000 9,500 27,000 302,000 11,200 24,000 16 Net income 94,500 17 18 Accumulated depreciation total credits 19 $ 45,000 20 25 26 $ 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 FloorCo, Inc. 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 45,000 31 Increase in accounts receivable 32 Increase in inventory Decrease in prepaid expenses Decrease in accounts payable Decrease in accrued liabilities 36 Increase in income taxes payable Sheet1 94,500 $ 33 34 35 READY Attempt(s)

Answer & Explanation Solved by verified expert

See Answer