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. Prepare a schedule of net cash provided by operating activities. Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire...? 1 FILE HOME INSERT PAGE LAYOUT Calibri 11 Α' Α' 34 Paste BIU points Clipboard Б Font E36 X fx eBook A B с FORMULAS DATA % REVIEW VIEW Alignment Number Conditional Format as Cell Formatting Table Styles Styles D Cells Editing E F G H 1 The following information is for FloorCo, Inc. for the year just ended: 2 Print 3 End of year Beginning of year References 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 liabilities 9,500 11,200 14 Income taxes payable 27,000 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 naine or losses during the year Sign In = | v 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 26 27 FloorCo, Inc. Operating Activities Section of the Statement of Cash Flows 28 Net income 29 Adjustments to reconcile net income to net cash provided by operations: Depreciation 30 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 38 39 40 41 Net cash provided by operating activities READY Attempt(s) 3/3 Sheet1 回 Π + 100% Hint Show Mo
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. Prepare a schedule of net cash provided by operating activities. Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire...? 1 FILE HOME INSERT PAGE LAYOUT Calibri 11 Α' Α' 34 Paste BIU points Clipboard Б Font E36 X fx eBook A B с FORMULAS DATA % REVIEW VIEW Alignment Number Conditional Format as Cell Formatting Table Styles Styles D Cells Editing E F G H 1 The following information is for FloorCo, Inc. for the year just ended: 2 Print 3 End of year Beginning of year References 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 liabilities 9,500 11,200 14 Income taxes payable 27,000 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 naine or losses during the year Sign In = | v 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 26 27 FloorCo, Inc. Operating Activities Section of the Statement of Cash Flows 28 Net income 29 Adjustments to reconcile net income to net cash provided by operations: Depreciation 30 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 38 39 40 41 Net cash provided by operating activities READY Attempt(s) 3/3 Sheet1 回 Π + 100% Hint Show Mo
Chapter10: Financial Statements And Reports
Section: Chapter Questions
Problem 1.6C
Related questions
Question

Transcribed Image Text: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.
Prepare a schedule of net cash provided by operating activities.
Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire...?
1
FILE
HOME
INSERT
PAGE LAYOUT
Calibri
11
Α' Α'
34
Paste
BIU
points
Clipboard Б
Font
E36
X
fx
eBook
A
B
с
FORMULAS
DATA
%
REVIEW
VIEW
Alignment Number Conditional Format as Cell
Formatting Table Styles
Styles
D
Cells Editing
E
F
G
H
1 The following information is for FloorCo, Inc. for the year just ended:
2
Print
3
End of year
Beginning of
year
References
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 liabilities
9,500
11,200
14
Income taxes payable
27,000
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 naine or losses during the year
Sign In = |
v

Transcribed Image Text: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
26
27
FloorCo, Inc.
Operating Activities Section of the Statement of Cash Flows
28 Net income
29 Adjustments to reconcile net income to net cash provided by operations:
Depreciation
30
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
38
39
40
41
Net cash provided by operating activities
READY
Attempt(s) 3/3
Sheet1
回
Π
+
100%
Hint
Show Mo
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Recommended textbooks for you

Auditing: A Risk Based-Approach to Conducting a Q…
Accounting
ISBN:
9781305080577
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
South-Western College Pub

Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning

Auditing: A Risk Based-Approach to Conducting a Q…
Accounting
ISBN:
9781305080577
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
South-Western College Pub

Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning