Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with Excel formulas to compute The following information is for Floor Co, Inc for the year just ended all answers must be entered

Please help with Excel formulas to compute

The following information is for Floor Co, Inc for the year just ended
all answers must be entered as a formula
End of Year Beginning of year
Current Assets:
Cash 75,000 90,000
Accounts receiable 158,000 140,000
Inventory 285,000 246,000
Prepaid expenses 11,000 16,000
Current Liabilities
Accounts payables 284,000 302,000
Accured Liabilities 9,500 11,200
Income Taxes payables 27,000 24,000
Net Income 94,500
Accumulated depreciation
total credits 45,000
Floor company dod not record any gains or losses during the year
complete a schedule of net cash provided by operating activities
Floor Co, Inc.
Operating Activities Section of the Statement of Cash Flows
Net Income
Adjustments to reconcile net income to net cash provided by operations:
Depreciation
Increase in accounts receivable
Increase in Inventory
Decrease in prepaid expenses
Decrease in accounts payable
Decrease in accrued liabilities
Increase in income tax payable
Netcash provided by operating activity

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

Advanced Financial Accounting An IFRS Standards Approach

Authors: Pearl Tan, Chu Yeong Lim, Ee Wen Kuah

4th Edition

9789814821278, 9814821276

More Books

Students also viewed these Accounting questions

Question

What is the value of a vector after a copy?

Answered: 1 week ago