A cash flow forecast will assist any company in finding out the future balance in their bank account at any given time. Cash forecasting may be required if you are looking to banks or investors for investment, loans or overdrafts. It may also be required for Management on a regular basis to assist them in business decisions. Even if you are a sole trader you may find the forecast a useful tool.
Cash flow forecasts are normally prepared for a period of one year. If your business is struggling financially it may be worth completing a weekly of monthly Cash Flow Forecast. A monthly projection may show a positive balance at the month end, but a weekly projection may show a negative balance for one or two weeks during the month. If you are aware of financial problems it is easier to try and avoid, there are several measurers that you could take including putting more money into the account, extending an overdraft or delaying a payment or purchase.
If you are looking to expand you business in the future, by looking at the cash flow forecast you may be able to decide when the money will be available to do this.
It is different from a Profit and Loss or a Balance sheet as it shows cash which is paid into or taken out of the business in a given month. Some of the differences are:
To prepare a forecast you will need to know several pieces of information these include:
You can then set up a simple excel spreadsheet posting the cash receipts and payments when you expect them to happen. Some of the figures will need to be estimated.
The sample shows that the company started with £10,000 of investment and at the year end £5030 will be in the bank. Therefore if the company hits all its targets within the first year a small amount will be available in the bank.
It is worth spending time each month looking at the forecast and comparing it to the actual cash, this will allow you to spot any differences and adjust any future figures that may be necessary.
Return from Cash Flow Forecast to Accounting Basics Page.