Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
