Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

When using the excel (via Connect) you must populate the cells with formulas. You can not just enter the value in the vell absent a

image text in transcribedimage text in transcribed

When using the excel (via Connect) you must populate the cells with formulas. You can not just enter the value in the vell absent a formula. Connect will mark it incorrect.

For example, =B35, =SUM(B5:B9) etc.

Prepare a schedule of net cash provided by operating activities. X $ x B FILE = Prepare the Operating Activities Section of a Statement of Cash Flows using the Indire... ? INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In HOME ES Paste B I U , PP, Cells Editing A, Alignment Number Conditional Format as Cell Formatting* Table Styles Styles Clipboard Font A1 * fc The following information is for FloorCo, Inc. for the year just ended: H A B C D The following information is for FloorCo, Inc. for the year just ended: End of year Beginning of year $ $ 5 Current assets: 6 Cash 7 Accounts receivable Inventory Prepaid expenses 75,000 158,000 285,000 11,000 90,000 140,000 246,000 16,000 11 Current liabilities Accounts payable Accrued liabiities 14 Income taxes payable 284,000 9,500 27,000 302,000 11,200 24,000 16 Net income $ 94,500 18 Accumulated depreciation total credits $ 45,000 23 Prepare a schedule of net cash provided by operating activities. 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: 30 Depreciation 31 Increase in accounts receivable 32 Increase in inventory 33 Decrease in prepaid expenses 34 Decrease in accounts payable 35 Decrease in accrued liabilities Increase in income taxes payable Net cash provided by operating activities

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

Lessons Learned On The Audit Trail

Authors: Richard F.Chambers, CIA, QIAL, CGAP, CCSA, CRMA

1st Edition

0894139037, 978-0894139031

More Books

Students also viewed these Accounting questions