Projected Cash Flow Statement
Projected Cash Flow Statement
|Up sales residential||$176,976||$207,528||$226,176|
|Cash from sales||$480,047||$562,920||$613,502|
|Collections of receivables||$183,247||$241,251||$262,930|
SPA & loan & equity
|Total cash in||$792,795||$804,171||$876,432|
|Cost of sales|
|Cost of sales||$102,867||$120,626||$131,465|
|Advertising & promotion||$15,000||$7,500||$7,500|
|Trucks (gas, repairs, etc.)||$45,750||$57,188||$71,484|
|Total cash out||$755,460||$722,252||$798,843|
|Net cash flow||$37,335||$81,919||$86,589|
|Bank balance open||$0||$37, 335||$119,254|
|Bank balance close||$37,335||119,254||$205,843|
This may seem confusing at first so let’s break this down. First, you have to think in terms of cash. That is, when the money lands into your bank account. Remember, accounts receivables are your sales terms (ie: net 30 days, 60 days, 90 days). This is when you estimate when you are going to actually get paid. If you make a sale in January for $100 and your sales terms are net 30 days (credit terms), you will have an estimated cash sale for February in the amount of $100. This is the collection of accounts receivable.
The revenue section is to show total revenue. The section just below it, shows how we get our cash position. This is simply shown as:
Cash from sales (Sales made on the spot) + Accounts Receivables (Your net sales terms or sales on credit) + Collection of Receivables (Collection of cash from sale made on credit) = Total Cash Sales
The exception is the first year. We include all incoming cash and in our first year, we have a cash influx from other sources such as a funding contribution from SPA, a commercial loan from the Bank and our equity contribution. We must include these to show our cash position. This is only for the first year, unless you get other cash grants, loans, or contributions for the following years. Remember, any incoming cash items gets included here.
This includes all outgoing cash items such as purchases, inventory, and other cash costs.
Cost of sales information is included in the income statement, under “cost of sales”. You can include those items here if you choose. For simplicity, I kept them off. All expenses which have been incurred as spent items are included here. Most expensed items will be paid the month they have been incurred, for example, telephone bills.
You will also include interest and principal loan payments here. Since you will be paying off your loans on a monthly basis, they have to be included here.
Remember, all outgoing cash items are included here.
Net cash flow is what you have in your bank account once all your bills have been paid.
Bank balance open and bank balance close
This may seem a little confusing but all you have to remember is that this is the cash you start with at the beginning of the year. At year 1, there is no cash. In year 2, we ended with a cash position of $37,335. Add year one ending cash to the next years ending cash to get our cummulative cash flow. Given as:
Ending cash balance + opening bank balance = Ending bank balance.
It simply tells you what you have in your bank account after each, cumulative year. Go over the sample cash flow statement and study it until it all makes sense. You will use the information in this statement for your projected balance sheet.
Go over this statement with the 12 month cash flow statement for the first year. Find it here.
This will give you an idea of how your cash flow forecast should flow and balance.