Create a simple cash flow statement covering a period of twelve months that accounts for the following variables: beginning cash balance, net cash collections, net cash outflows, net inflows and outflows for period, ending cash balance.

Any numbers and needs to be in an excel format