Cashflow forecasting
This Cashflow forecasting Info Guide offers practical help on how to prepare a Cashflow Forecast.
A Cashflow Forecast is a spreadsheet into which you enter your anticipated cash inflows and cash outflows for the next three months or for the forthcoming year in order to calculate your cash balance, which will be either positive or negative.
TOP
A Cashflow Forecast can also be used to support loan applications.
TOP
Cashflow Forecast Example
|
| |
January |
February |
March |
Total |
|
Cash inflow
|
| Sales (incl VAT) |
30,000 |
50,000 |
75,000 |
155,000 |
| Other receipts |
|
10,000 |
|
10,000 |
| |
| Total inflow |
30,000 |
60,000 |
75,000 |
165,000 |
| |
|
Cash outflow
|
| Purchases (incl VAT) |
15,000 |
25,000 |
30,000 |
70,000 |
| Payroll – net pay |
13,000 |
16,000 |
19,000 |
48,000 |
| PAYE/PRSI |
0 |
4,000 |
5,000 |
9,000 |
| VAT |
0 |
0 |
11,000 |
11,000 |
| Loan repayments |
10,000 |
10,000 |
10,000 |
30,000 |
| Other payments |
|
|
2,000 |
2,000 |
| Total outflow |
38,000 |
55,000 |
77,000 |
170,000 |
| |
|
|
|
|
| Net inflow/outflow |
-€8,000 |
€5,000 |
-€2,000 |
-€5,000 |
| |
| Opening cash balance - start of month |
€0 |
-€8,000 |
-€3,000 |
|
| Closing cash balance - end of month |
-€8,000 |
-€3,000 |
-€5,000 |
|
| |
Remember!
- Forecast as realistically as possible the amounts of cash that you expect to receive into your business and the amounts of cash that you expect to spend for the next three months or for the forthcoming year, in order to get an indication of how much money will be left over.
- Show your forecast on a week-by-week or month-by-month basis. This will help you to spot cashflow problems and take corrective action in good time.
Timing
When forecasting cashflow, it’s the timing of VAT-inclusive cash received or paid that is important, not when the transactions initially take place.
Remember!
A Cashflow Forecast is an essential tool for putting you in control. The more realistic your estimates, the better your Cashflow Forecast will work for you!
top
Keeping on top of your cashflow position requires ongoing monitoring from you or your book-keeper. Your Cashflow Forecast should be a living tool that is rolled on from one week or month to the next with actual information providing the new starting point to project forward.
Weekly / monthly forecast review
- Compare the completed period's forecast figures with the actual cash movements, and revise the cash balance into the next period.
- Update upcoming periods' forecasts in the light of more accurate estimates and changes in the business environment.
- Add future periods so that it becomes a rolling forecast.
top