Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me to use Excel formulas to complete Operating Activities of Floor Company. The following information is for Floor Co, Inc for the year
Please help me to use Excel formulas to complete Operating Activities of Floor Company.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started