Cash forecasting isn't just about numbers. It's about knowing if your business will survive next month. A good forecast sees trouble coming before it hits. A bad one leaves you blind.
Liquidity buffering works hand in hand with forecasting. Think of it as your company's rainy-day fund. You need the right size buffer, not too big and not too small. Too much cash sitting idle drags down returns. Too little cash means you could miss payroll.
The tables below break down the core methods, tools, and trade-offs. Use them as your practical reference.
Forecasting predicts future cash positions. Buffering protects against forecast errors. They are two sides of the same coin.
Without a forecast, you don't know your buffer need. Without a buffer, even a small forecast miss can cause a crisis.
Core Forecasting Methods
Two main approaches dominate treasury forecasting. One looks at receipts and payments directly. The other starts from the balance sheet and adjusts. Most large firms use both for different time horizons.
A retail chain forecasts daily store sales to project weekend cash needs. That's the direct method in action. They track exactly when money comes in from card processors.
A holding company uses the indirect method for its five-year plan. They start with projected net income and add back depreciation. It gives a rough picture without tracking every transaction.
| Feature | Direct Method | Indirect Method |
|---|---|---|
| Starting Point | Expected cash inflows and outflows | Balance sheet and income statement projections |
| Time Horizon | Short-term (days to weeks) | Medium to long-term (months to years) |
| Granularity | High, by business unit or bank account | Low, consolidated view |
| Best Use Case | Daily liquidity management | Strategic planning and debt covenant testing |
| Complexity | High data requirements | Moderate, relies on accounting logic |
The direct method gives you a sharp, operational snapshot. The indirect method shows the broader trajectory. You'll often hear treasurers talk about using direct methods for the next 30 days and indirect methods for the next year.
Short-Term Forecasting: The 13-Week Roll
A 13-week cash flow forecast (often called a rolling forecast) is the backbone of short-term treasury. It updates every week. You drop the week just passed and add a new week at the end.
This rolling approach keeps your view fresh. It forces you to compare what you predicted against what actually happened each week. That variance analysis improves your model over time.
A manufacturing company runs a 13-week forecast every Monday morning. Week 1 just ended with actuals coming in $50,000 below forecast. The analyst immediately adjusts the remaining 12 weeks. This tight feedback loop catches errors fast.
| Cash Inflow Sources | Cash Outflow Uses |
|---|---|
| Customer collections (AR aging-based) | Payroll and benefits |
| Intercompany settlements | Supplier payments (AP aging-based) |
| Asset sales and refunds | Rent and lease obligations |
| Investment income and maturities | Tax payments and debt service |
A budget is a target. A rolling forecast is a prediction of reality. Budgets are often optimistic. Forecasts must be brutally honest.
Variance is normal. The goal is to reduce the average variance over time, not to hit zero every week.
Liquidity Buffering Strategies
Once you have a forecast, you can size your liquidity buffer. A buffer can be cash in the bank, committed credit lines, or a mix of both. The goal is to survive a stress scenario without needing emergency funding.
Stress scenarios aren't theoretical. One major customer delays payment by 60 days. A factory goes down for two weeks. Your bank suddenly reduces your overdraft line. The buffer covers these gaps.
| Buffer Source | Cost | Reliability in Crisis |
|---|---|---|
| Cash on hand | Opportunity cost (low yield) | Highest, immediately available |
| Committed credit facilities | Commitment fees (basis points) | High, but subject to covenant compliance |
| Uncommitted credit lines | Usually no standby cost | Low, can be withdrawn without notice |
| Commercial paper (CP) backup | Low issuance cost | Volatile, depends on market conditions |
| Intercompany lending | Minimal external cost | Subject to legal and tax constraints |
During the 2020 market shock, many firms found their uncommitted credit lines were pulled by banks overnight. Only committed lines and actual cash proved reliable. This lesson reshaped buffer policies across the industry.
Sizing the Buffer: Risk and Return
How much buffer is enough? A common target is covering operating expenses for a minimum period under stress. Many firms target coverage for 30 to 90 days of outflows. The exact number depends on your access to capital markets and the stability of your sector.
Holding excess cash has a real cost. Investors expect cash to be deployed efficiently. If a company sits on too much idle cash, its return on equity (ROE) suffers. You need a clear policy to justify the buffer size to your CFO and board.
| Metric | What It Measures | Typical Target |
|---|---|---|
| Days Cash on Hand (DCOH) | Cash and equivalents divided by daily operating expenses | 30-90 days (varies by industry) |
| Cash Coverage Ratio | Cash flow from operations to current liabilities | Greater than 0.5x |
| Liquidity Gap | Forecasted inflows minus outflows over a stress period | Zero or positive under stress |
| Credit Headroom | Undrawn committed facilities divided by total debt | At least 15-20% of total debt |
A utility with stable cash flows can target a smaller buffer. A cyclical miner needs a much larger one. Your buffer must match your business volatility.
Always tie the buffer back to a specific, quantified risk scenario. Board members understand stories about "if X happens, we survive Y days."
Technology and Data Integration
Spreadsheets still dominate short-term forecasting in many treasury teams. But manual Excel work burns time and introduces errors. Modern treasury management systems (TMS) or even advanced ERP modules can automate data pulls from bank accounts, accounts payable, and accounts receivable systems.
Direct bank connectivity via SWIFT or APIs gives you real-time or daily balances. That means your forecast starts from an accurate actual position, not an estimate from yesterday's close. Automation frees your team to focus on variance analysis and decision-making instead of data entry.
A tech company implemented a TMS that pulls bank balances at 7 AM every day. Their forecasting accuracy improved from ±15% to ±5%. The treasury analyst now spends mornings analyzing deviations, not typing numbers into spreadsheets.
Key Takeaways
| Key Point | What It Means | Action Item |
|---|---|---|
| Use direct method for short-term | Predicts real cash flows, not accounting profits | Build a 13-week rolling cash flow forecast by bank account |
| Indirect method supports long-term planning | Good for capital structure and debt covenant testing | Update an indirect model quarterly for board reporting |
| Buffer must match risk profile | High volatility businesses need larger buffers | Stress-test your buffer using a customer concentration scenario |
| Cash is king, but committed lines back it up | Committed credit facilities are the second line of defense | Maintain at least 20% of facility capacity as undrawn headroom |
| Automation improves accuracy and speed | Real-time data reduces manual errors and lag | Integrate bank APIs with your TMS or ERP within 12 months |