How to Build a Cash Flow Forecast in 2026

Cash flow forecasting is an essential tool for any business aiming to maintain liquidity amid 2026's economic challenges, including persistent inflation, supply chain disruptions, and volatile interest rates. Unlike the income statement, which measures profitability, cash flow assesses your real ability to pay bills and invest without excessive borrowing. A 2025 Banque de France study shows that 28% of business failures stem from cash flow shortages, highlighting the need for rigorous forecasting.

This intermediate tutorial guides you step by step to build a reliable model, from theoretical basics to advanced applications like probabilistic scenarios. Think of your business like an airplane: the budget is the planned flight path, but cash flow is the actual fuel that prevents a forced landing. Using concrete examples from industrial SMEs, you'll learn to incorporate historical data, project flows, and make real-time adjustments. By the end, you'll have a reusable, actionable framework to bookmark and apply.

• Basic knowledge of analytical accounting (current assets/liabilities).
• Proficiency in Excel or Google Sheets (SUMIF, VLOOKUP formulas).
• Access to historical data: balance sheet, cash receipts/payments ledger for 12-24 months.
• Basic probability concepts for scenarios (normal distribution of customer payment delays).

Start by breaking down cash flow into its main inflows and outflows, like the gears in a hydraulic machine where each input feeds the reservoir.

Inflows:

• Customer receipts (80% of revenue for a typical SME).
• Grants/subsidies (e.g., France 2030 plan).
• New loans or refinancing.

• Supplier payments (average delays 45-60 days).
• Salaries and payroll taxes (fixed monthly).
• CAPEX investments (e.g., €50k machine purchase).
• Taxes and dividends.

Use a summary table:

Two main approaches dominate: direct method (ideal for operations) and indirect method (tied to the income statement).

• Direct: Project each flow individually. Advantage: short-term precision (1-6 months). E.g., average customer delay 45 days → receipts forecast = current month invoices + 2/3 of prior month.
• Indirect: Start from net income + depreciation - change in working capital. Useful for >12 months, but sensitive to accounting assumptions.

Numeric example (direct method):

• Month M+1: €200k invoices (50-day delay) → €180k receipts.
• €90k salaries, €100k suppliers → -€10k balance.

Test both on 3 historical months: <10% variance validates the method.

Model over 12-24 months with columns: Month, Receipts, Payments, Balance, Cumulative, Alert Threshold.

Recommended Excel structure:

1. 'Historical' sheet: Import ledger.
2. 'Assumptions' sheet: Revenue growth +5%, customer delays 40 days, supplier inflation +3%.
3. 'Forecast' sheet: Dynamic formulas =Assumptions!B2 * Historical!C5.

Example table (months 1-3):

Advance to three scenarios: base (60% probability), pessimistic (30%), optimistic (10%). Use Excel data tables (Data → What-If Analysis → Scenario Manager).

Assumptions per scenario:

• Base: Revenue +4%, customer delays 45 days.
• Pessimistic: Revenue -2%, customers 60 days, inflation +5%.
• Optimistic: Revenue +8%, customers 35 days.

Real-world example: For our SARL, pessimistic scenario shows €100k overdraft in Q3 → Action plan: automated customer reminders, supplier negotiations.

Scenario checklist:

• Assign probabilities (total 100%).
• Calculate expected value: Σ(Scenario_i * Prob_i).

Forecasts aren't set in stone: review monthly with actuals vs. forecast (variance %).

Process:

1. Day 5: Collect actual receipts.
2. Calculate variances: If >15%, adjust assumptions.
3. KPI: Actual cash / Forecasted >95%.

Case study: A mid-sized manufacturer (€50M revenue) cut overdrafts 30% by shifting from annual to monthly reviews with a synced Power BI dashboard.

Automate alerts: Email CEO if cumulative < -€20k.

• Granularity by flow type: Separate recurring customers (90% reliable) from one-offs.
• Conservative assumptions: Add 10% buffer to outflows, -5% to inflows.
• Macro integration: Adjust for ECB inflation (2.5% in 2026) and Euribor rates.
• Cross-department collaboration: Sales provides customer pipeline, Purchasing confirms supplier delays.
• Light automation: VBA scripts for monthly refresh, avoiding manual entry.

• Ignoring seasonal working capital: E.g., retail Christmas stock buildup → January cash hole (traps 40% of SMEs).
• Overly optimistic assumptions: +20% revenue without validated pipeline leads to false positives.
• No variance analysis: Static forecasts miss shocks (e.g., transport strike +15-day delays).
• Forgetting hidden CAPEX: Unexpected €20k maintenance wipes out cumulative.

Dive deeper with:

• Pro tools: Finary or Spendesk for AI-predictive dashboards.
• IFRS 9 standards: Credit risk provisions for customers.
• Advanced training: Our Cash Management Courses at Learni.
• Reading: "Corporate Treasury" (Dunod, 2025); Bpifrance 2026 reports.