Hello All,

I am trying to complete this cash flow computation for the following scenario, but I don't know if I have placed the items correctly. Moreover, how to compute the Net increase (decrease) in cash during the year, or the cash balance at the end of the year. Please help understand and how to go about getting the correct answer.

Scenario:
From the following selected data, compute:

Net cash flow provided (used) by operating activities.
Net cash flow provided (used) by investing activities.
Net cash flow provided (used) by financing activities.
Net increase (decrease) in cash during the year.
The cash balance at the end of the year.
Cash receipts from:
Customers $270,000 Investments by owners 54,000 Sale of building 90,000 Proceeds from bank loan 60,000 Cash payments for: Wages$ 82,000
Utilities 3,000
Rent 36,000
Taxes 67,000
Dividends 20,000
Repayment of principal on loan 40,000
Purchase of land 106,000
Cash balance at beginning of year $386,000 My computations thus far: 1) Operating Activities Customers$270,000
Wages $(82,000) Rent$(36,000)
Utilities. $(3,000) Taxes .$(67,000)
Advertising. $(4,000) Net cash flow provided (used) by operating activities$ 78,000

2) Investing Activities
Sale of Building. $90,000 Purchase of Land .$(106,000)

Net cash flow provided (used) by Investing Activities $16,000 3) Financing Activities Proceeds from bank loan .$ 60,000
Repayment of principle loan.. $(40,000) Dividends .$(20,000)
Investments by owners $54,000 Net cash flow provided (used) by Financing Activities$ 54,000