FP&A and Cash Forecasting: How Much Can Your Business Afford to Commit?
Connecting operating plans, cash availability and the deadline for management action.
Two new hires and an equipment purchase get the go-ahead. Sales are progressing, margins look reasonable, and the annual plan is on track. Then a major customer delays payment by four weeks. The hires and equipment now compete with payroll and supplier bills.
What was missing was a view of how low cash would fall between approving the spend and earning it back.
Financial Planning & Analysis (FP&A) should make that exposure visible before the business commits. It connects operating assumptions to financial outcomes, tests alternatives and helps management decide what to fund, what to sequence and when to intervene.
Cash forecasting puts a practical limit on those plans: how much can the business commit while retaining enough liquidity to get through a credible downside?
That often brings the discussion down to a date: when do you need to act for the response to protect cash in time?
1. Bring cash into the decision before approving the spend
An income statement helps management assess profitability. A cash forecast shows when receipts and payments become available or due. Both are needed to judge affordability.
A sale can increase profit while its cash remains in receivables. Inventory absorbs funding before the finished product is sold. Equipment requires payment on a different schedule from depreciation. Debt principal repayment consumes cash without appearing as an operating expense. ACCA’s explanation of cash flow statements sets out why profit must be adjusted for non-cash items and working-capital movements to understand cash generation.
Before approving a material proposal, FP&A should answer two questions: does it make commercial sense, and how will the business fund it?
For a new contract, that means examining the margin alongside customer deposits, delivery milestones, supplier payments and collection timing. For recruitment, it means comparing the start of payroll with the time needed for additional capacity to produce collected revenue.
A project worth doing may still need revised payment terms, staged investment or additional financing before it gets the go-ahead.
The practical question is: at the lowest cash point created by this decision, what resources will remain available to the business?
2. Connect the weekly forecast to the wider FP&A plan
Start with two connected views: a near-term cash schedule and a monthly financial plan. Add detail where the decision calls for it, especially when cash movements are volatile.
| View | What it contains | Decision it supports |
|---|---|---|
| Weekly, rolling 13-week cash forecast | Expected receipts and payments, opening cash and closing cash | Collections, payment scheduling and near-term funding |
| Monthly, rolling 12–18-month financial plan | Linked P&L, balance sheet and cash flow, built from operating drivers | Hiring, investment, growth pace and financing requirements |
BDC recommends a rolling 13-week cash forecast, updated at the beginning of each week, to improve visibility beyond the monthly budget. Thirteen weeks is a practical starting point; businesses with volatile liquidity may also need daily detail around payment peaks.
The weekly model typically uses the direct approach: cash expected in, cash expected out. The monthly model connects revenue, costs, receivables, inventory, payables, investment and financing.
The two views should reconcile over their shared period. If expected receipts differ, finance should identify whether the gap comes from invoice timing, collection behaviour, scope or a stale assumption. A difference can be informative; an unexplained difference weakens the decision.
Treasury and FP&A bring complementary knowledge. Treasury understands bank positions, payment flows and funding mechanics. FP&A connects those flows to commercial plans and operating choices. AFP highlights the benefits of combining these perspectives in scenario modeling and strategic forecasting.
In a smaller company, the same person may handle treasury and FP&A. They still need both views to work from the same assumptions.
For implementation detail, Build a practical cash forecasting process.
Can your business fund its next growth decision?
Flyn & Co. helps founders and finance leaders connect operating forecasts, cash requirements and management decisions. Build a clearer view of what you can commit, where liquidity tightens and when to act.
3. Measure the cash trough, not just the closing balance
Consider an illustrative business starting a 13-week period with 300 K EUR of unrestricted cash. Management sets a minimum operating cash buffer of 150 K EUR.
Under the base forecast, weekly closing cash reaches a low of 185 K EUR in week 7 and finishes week 13 at 260 K EUR.
Now assume a 90 K EUR customer receipt moves from week 5 to week 9. All other cash flows remain unchanged. There is no change to revenue recognition, and no financing costs or penalties are assumed.
| Measure | Base forecast | Delayed customer receipt |
|---|---|---|
| Opening cash | 300 K EUR | 300 K EUR |
| Lowest weekly closing cash | 185 K EUR | 95 K EUR |
| Week of lowest cash | Week 7 | Week 7 |
| Minimum cash buffer | 150 K EUR | 150 K EUR |
| Headroom at the lowest point | +35 K EUR | −55 K EUR |
| Week 13 closing cash | 260 K EUR | 260 K EUR |
Both forecasts end the quarter with 260 K EUR. Only one stays above management’s minimum cash buffer throughout the period.
In this example, the maximum gap against the chosen buffer is 55 K EUR. That is the amount needed to restore the buffer at the lowest weekly closing point, before any additional uncertainty allowance, fees or intraweek cash requirements.
It is not a 55 K EUR shortfall against zero cash. The business remains cash-positive in the weekly forecast, but breaches the protection management intended to preserve.
That distinction matters when deciding whether to arrange funding, accelerate collections or defer discretionary investment. It also prevents a positive bank balance from being mistaken for cash available to spend.
4. Work backwards from the cash constraint to the decision deadline
In the delayed-payment scenario, the first weekly closing balance below the buffer occurs in week 5.
Now suppose a funding option takes three weeks to execute, from starting the process to receiving usable funds. To protect the week 5 closing position, management needs to start by the end of week 2. An earlier cash low within the week would bring that deadline forward.
The general logic is simple:
Latest action date = date cash protection is needed − implementation lead time.
The lead time must include internal approval, documentation and execution. A financing discussion is not available liquidity, and an unsigned customer promise is not a receipt.
FP&A should maintain a short action register alongside the forecast:
| Possible action | What must be tested | Accountable owner |
|---|---|---|
| Bring forward a customer receipt | Agreed payment date, any discount and customer acceptance | Commercial lead and receivables team |
| Reschedule equipment expenditure | Contract flexibility, deposits and operational consequences | Operations lead |
| Draw an existing credit facility | Available amount, conditions and actual drawdown timing | Finance or treasury |
| Stage a recruitment plan | Cash saved by start date and effect on delivery capacity | Business lead and HR |
Keep the forecast before management action visible. Then show a separate view incorporating approved actions, their costs and their implementation dates.
It is easy to make a forecast look comfortable by assuming every proposed response will work. Count funding once, and put each deferred payment back into the week when it will actually be paid.
5. Test the operating assumptions that can change affordability
A useful downside scenario has an operational explanation. Start with a specific exposure: a concentrated customer, a delayed project milestone, a seasonal stock build or a supplier deposit.
Then trace the consequences through the model.
Lower sales may eventually reduce purchases, but committed orders can keep cash outflows high for several weeks. Higher sales can require inventory and staff before collections arrive. A customer deposit can improve early cash while creating future delivery obligations.
Three tests are particularly useful before approving a material commitment:
- Collection test: what happens if the largest expected receipts arrive later?
- Execution test: what happens if delivery slips while payroll and supplier obligations continue?
- Commitment test: what happens if the company must honour expenditure already contracted before it can reduce costs?
The monthly plan should capture the wider effects on margin, working capital and financing. The weekly forecast should identify the dates at which those effects become cash constraints.
Scope also matters. Cash held in another entity, currency or restricted account may be unavailable for the payment in question. Show unrestricted cash separately from undrawn committed facilities and test whether those facilities can actually be accessed. Avoid counting the same funding in both categories.
The minimum buffer should reflect the company’s payment profile, volatility and financing access. A universal percentage of revenue offers little help when payroll and customer concentration differ substantially between businesses.
Related reading: Connect operating drivers to the financial plan.
6. Build a review that changes decisions
The weekly cash review should begin with the previous forecast and actual bank movements. Reconcile opening cash, explain material receipt and payment differences, update assumptions and extend the forecast by another week.
Separate timing differences from permanent changes. A delayed receipt belongs in a later period if collection remains credible. A cancelled order or irrecoverable balance requires a different treatment.
Review receipts and payments separately. An unexpectedly late customer receipt can be hidden by an equally late supplier payment, leaving net cash apparently accurate while both underlying assumptions are wrong.
Preserve forecast versions and compare like-for-like horizons. A next-week forecast should be assessed separately from one prepared several weeks earlier. Focus attention on errors that could change a decision, especially around the projected cash trough.
By the end of the review, management should be able to name the lowest forecast cash balance, when it occurs and the gap against the agreed buffer. The actions coming up for a decision need a named owner and a credible cash effect.
The monthly FP&A review then addresses the broader implication: does the operating plan still justify the commitments being made? Repeated cash pressure may call for changes to customer terms, pricing, inventory policy or the investment sequence.
Cash forecasting earns its place in FP&A when it changes a decision early enough to improve the outcome. The test is practical: can management explain what it can afford to commit, which assumptions matter and how much time is left to act?
Related reading: Build a monthly review around decisions.
One final word : Stay tuned for more insights on Finance, Investing, Real Estate & Startups.
More posts...
Airbnb, Booking and Expedia: Who Captures the Value of Travel?
Airbnb, Booking and Expedia: Who Captures the Value of Travel? How travel platforms turn demand into revenue – and what their economics mean for hospitality
Preparing a Board for a Difficult Quarter
How to explain a performance miss and secure decisions while the business still has room to act.
SaaS Financial Planning: How to Turn ARR Growth Into Cash and Enterprise Value
SaaS Financial Planning: How to Turn ARR Growth Into Cash and Enterprise Value ARR growth tells you whether a SaaS company is getting bigger. It
Budget 2027: Build a Plan Your Business Can Actually Use
The strongest budgets make assumptions explicit, quantify the cash impact and define how management will respond.
Why Bordeaux Wine Estates Need a 24-Month Cash Model
Why Bordeaux Wine Estates Need a 24-Month Cash Model Bordeaux’s wine industry is adjusting to lower volumes, shifting consumption, weaker exports and structural vineyard contraction.
Fractional CFO vs. Full-time CFO: Which One Should an SME Choose?
Fractional CFO or full-time CFO? Learn which option makes more sense for SMEs, growing businesses, and founder-led companies that need financial leadership without overbuilding the finance function.