Please use Excel formulas to complete

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