A well-substantiated cash flow forecast often makes the difference between swift approval and an application gathering dust on a financier's desk.
Almost every financing application calls for a cash flow forecast, yet this remains one of the documents business owners struggle with most. Not because the arithmetic is difficult, but because it is challenging to establish assumptions that are both robust and convincing.
This article outlines a concrete structure for a cash flow forecast that financiers take seriously, detailing how to substantiate your assumptions and why scenarios are essential.
What a cash flow forecast is and is not
A cash flow forecast is not a profit and loss account. It is not about your accounting profit, but about when cash actually enters and leaves your bank account. A major order invoiced this month only features in the forecast when you expect the client to actually settle the invoice, not on the invoice date.
Financiers use the cash flow forecast to determine whether you can service the repayments on a new loan alongside your existing liabilities, and whether you can navigate periods of tight liquidity without running into trouble.
The baseline structure
Map this out across at least twelve months, and for long-term financing applications, preferably across the full term of the facility. Financiers want to see not just the first year, but whether you can sustain the commitments over the long haul.
- Opening balance: the actual bank balance at the start of the period
- Projected monthly receipts: split between existing orders and projected new turnover
- Projected monthly expenditure: staff, premises, procurement, tax liabilities, debt repayments
- Month-end closing balance: opening balance plus receipts minus expenditure
- Carried forward into the next month as the new opening balance
Substantiating assumptions rather than guessing
The quality of a cash flow forecast stands or falls on the substantiation of its underlying assumptions. You should only pencil in a turnover growth of, say, 15 per cent next year if you can prove where that growth comes from: a concrete order in the pipeline, a newly signed client contract, or a completed capacity expansion.
Financiers are trained to spot forecasts built on wishful thinking. Therefore, back every assumption with concrete evidence: an order book, a contract, historical figures from your management accounts, or an independent market report.
- Use historical figures as a baseline, not a ceiling
- Tie turnover growth to concrete orders or signed contracts
- Remain conservative regarding prospective clients where contracts are not yet finalised
- Incorporate seasonal trends based on previous years
- Account realistically for taxes and loan repayments, including one-off items
Working with scenarios
A single forecast trajectory often strikes financiers as overly optimistic. You should therefore present at least three scenarios: a base case based on realistic expectations, a downside scenario where, for example, a major client pays late or turnover dips, and optionally an upside scenario.
The downside scenario is often the most critical for a financier: it demonstrates that you can still honour your obligations even during setbacks. That carries far more weight than an optimistic narrative without a stress test.
Worked example: a simple stress test
Suppose your base case reflects a minimum cash balance of € 40,000 in your tightest month. In your downside scenario, you assume that two major clients delay payment by thirty days, representing € 60,000 in deferred receipts for that month.
If your cash position drops below zero as a result, this proves that you require a buffer—for instance, in the form of an overdraft facility with sufficient headroom. These insights provide your financier with precisely the data required to determine an appropriate credit limit.
What to do next
Build your cash flow forecast in a spreadsheet based on your actual bank figures, rather than starting from scratch. Substantiate every assumption with concrete documentation or data, and prepare at least a base case and a downside scenario. Align the forecast with your application for a commercial loan or working capital, and use the financing calculator to verify that your requested funding amount matches your projections.
Frequently asked questions
- What timeframe should my cash flow forecast cover?
- At least twelve months ahead, and for long-term loan applications, preferably across the entire term of the loan, demonstrating to the financier that you can sustainably manage debt service.
- Should I include multiple scenarios?
- Yes, at least a base case and a downside scenario. The downside scenario proves that you can continue meeting your financial obligations even during setbacks such as payment delays.
- What if I lack historical financial figures, for example as a start-up?
- Base your forecast on firm purchase orders, formal quotes, or signed contracts, and remain explicitly conservative with any assumptions lacking concrete evidence. Financiers value realism far more than an excessively rosy picture.