Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Help Save Chapter 12 Statement of Cash Flow Excel Prepare a schedule of net cash

ID: 2330348 • Letter: H

Question

Help Save Chapter 12 Statement of Cash Flow Excel Prepare a schedule of net cash provided by operating activities |q: FILE +-e*. . ? ;Prepare the Operating Activities Section of a Statement of Cash Flows using the hirect. - Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIE points Alignment Number Conditional Format as Cel Cells Editing Formatting Table Styles B 1 u . ·A" Clipboard The following information is for FloorCo,Inc. for the year just ended: A1 : 1 The followng information is for FloorCo, Inc. for the year just ended: Beginning of End of yearear 5 Current assets: 6 Cash 7 Accounts receivable 8Inventory 9 Prepaid expenses 10 11 Current liabilities 285,000140,000 06,000 75,000 90,000 158,000246.000 11.000

Explanation / Answer

FloorCo. Inc.

Operating activities section of the statement of cashflows

Net income 94500 Adjustments to reconcile net income to net cash provided by operations : Depreciation 45000 Increase in accounts receivable (18000) Increase in inventory (39000) Decrease in prepaid expenses 5000 Decrease in accounts payable (18000) Decrease in accrued liabilities (1700) Increase in income taxes payable 3000 (23700) Net cash provided by operating activities 70800