Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel SIM: Prepare the Operating Activities Section of a Statement of Cash Flows using the Indirect Method Does it need to be typed in by

Excel SIM: Prepare the Operating Activities Section of a Statement of Cash Flows using the Indirect Method

Does it need to be typed in by a formula? Please help.

image text in transcribed

image text in transcribed

Prepare a schedule of net cash provided by operating activities. XD X Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire... ? INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME Sign In Calibri 11 - A % 34 points Paste B I U Alignment Number Cells A Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font . E36 V eBook A D E F G H B 1 The following information is for FloorCo, Inc. for the year just ended: 2 Print References 3 Beginning of 4 End of year 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 S 94,500 17 18 Accumulated depreciation 19 total credits $ 45,000 20 21 Floor Camnany did not record any mains or losses during the wear Calibri A A % Paste B I I U Alignment Number Cells Editing 1 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font E36 foc . 34 D F G H points eBook Print A B E 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 Decrease in accrued liabilities 36 Increase in income taxes payable 37 Net cash provided by operating activities 38 39 References 40 41 Sheet1 READY @ + 100% Attemptis 312 Mist Show Me

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Executive Roadmap To Fraud Prevention And Internal Control Creating A Culture Of Compliance

Authors: Joel T. Bartow, Martin T. Biegelman

2nd Edition

1118004582, 9781118004586

More Books

Students also viewed these Accounting questions

Question

What purpose worksheet serve to accountants

Answered: 1 week ago

Question

10-9 How have social technologies changed e-commerce?

Answered: 1 week ago