A Practical Guide to Cash Flow Forecasting
Summary
Cash flow forecasting is the process of estimating the flow of cash into and out of a business over a specific period of time. It’s one of a business’s most critical financial planning tools, providing a clear picture of its ability to meet short-term obligations like payroll and supplier payments. Unlike profit, which can be misleading due to non-cash items like depreciation, cash flow is the real-time lifeblood of a company. A robust cash flow forecast helps managers anticipate cash shortages, plan for future investments, and manage working capital effectively.
The Concept in Plain English
Imagine your personal bank account. You get paid (cash in), and you pay bills like rent and groceries (cash out). A cash flow forecast is simply creating a budget for your bank account for the next few months. You’d list all your expected income and all your expected expenses to see if you’ll have enough money at the end of each month. If you see that in three months, a big car repair bill will leave you with a negative balance, you can plan for it now—maybe by saving more in the months before or by arranging a small loan. For a business, it’s the exact same principle, just on a larger scale. “Revenue is vanity, profit is sanity, but cash is king.” A cash flow forecast is how the king stays on the throne.
The Two Main Forecasting Methods
-
The Direct Method: This is the most common method for short-term forecasting (e.g., a rolling 13-week forecast). It involves forecasting specific cash inflows and outflows.
- Cash Inflows: Projections of cash from sales (based on accounts receivable), asset sales, and financing.
- Cash Outflows: Projections of payments for suppliers (accounts payable), payroll, rent, taxes, and loan repayments.
- Best for: Short-term liquidity management.
-
The Indirect Method: This method starts with net income (from the income statement) and adjusts for non-cash items (like depreciation) and changes in working capital (like inventory and accounts receivable) to arrive at a cash flow figure.
- Best for: Long-term strategic planning and valuation, as it’s easier to link to the income statement and balance sheet forecasts.
How to Apply It: A Step-by-Step Guide to the Direct Method
Creating a simple, 13-week cash flow forecast is a powerful management tool.
- Choose a Time Period: A rolling 13-week (one quarter) forecast, updated weekly, is a common best practice.
- Establish a Starting Point: Start with your current cash balance.
- Forecast Cash Inflows:
- Look at your accounts receivable aging report. When are your customers scheduled to pay you?
- Look at your sales pipeline. What new sales do you realistically expect to close and collect cash from in the coming weeks?
- Forecast Cash Outflows:
- Regular, fixed payments: Rent, loan payments, subscriptions.
- Variable payments: Look at your accounts payable. When are supplier invoices due?
- Payroll: Don’t forget payroll taxes and benefits.
- Calculate Net Cash Flow and Ending Balance:
- For each week, calculate:
Net Cash Flow = Total Inflows - Total Outflows. - Then calculate:
Ending Cash Balance = Starting Cash Balance + Net Cash Flow. - The ending balance for one week becomes the starting balance for the next.
- For each week, calculate:
Worked Example: Weekly Forecast
| Week 1 | Amount (£) |
|---|---|
| Starting Cash | 10,000 |
| Inflows: | |
| - Customer A | 5,000 |
| - Customer B | 2,000 |
| Total Inflows | 7,000 |
| Outflows: | |
| - Payroll | -4,000 |
| - Rent | -2,000 |
| - Suppliers | -1,500 |
| Total Outflows | -7,500 |
| Net Cash Flow | -500 |
| Ending Cash | 9,500 |
Risks and Limitations
- Uncertainty: A forecast is only an estimate. Sales can be unpredictable, and customers may not pay on time. It’s wise to run multiple scenarios (best case, worst case, realistic case).
- “Garbage In, Garbage Out”: The forecast is only as reliable as the assumptions and data it is built on.
- Not a Static Document: A forecast is a living document. It must be updated regularly (e.g., weekly) and compared against actual results to improve future accuracy.
- Over-optimism: It’s human nature to be optimistic about sales. Be realistic, or even slightly conservative, in your inflow estimates.
Related Concepts
- Working Capital Management: Cash flow forecasting is the primary tool for managing working capital (Current Assets - Current Liabilities).
- Financial Statement Analysis: Understanding the income statement and balance sheet is necessary for creating an indirect cash flow forecast.
- Burn Rate: For startups, the cash flow forecast is used to calculate the monthly “burn rate” and determine the company’s “runway” (how long until it runs out of cash).