Cash Flow Forecast

A cash forecast is not a P&L on a different template. It tracks when cash actually moves, not when revenue is recognized or expenses are accrued. Precision on timing is the entire point.

Two Horizons, Two Approaches

Run two forecasts in parallel. The 13-week forecast is a bottom-up, week-by-week view of actual cash in and out. It is operational. The 12-month forecast is a top-down driver-based model used for planning and runway. They should agree in the overlapping weeks — if they diverge, the 13-week is right and the 12-month needs recalibration.

13-Week Forecast Structure

For each week, project: collections from customers (use AR aging plus expected new bookings converted with your average days-to-collect), payroll runs (use the exact pay schedule), vendor payments (use AP aging plus expected new invoices), recurring SaaS and fixed costs (pull from your vendor contracts), and any scheduled debt or tax payments. Sum to net cash change per week, accumulate to ending cash balance. Flag any week where ending cash falls below your minimum operating reserve (typically one to two months of fixed costs).

12-Month Forecast Structure

Drive revenue collections from a bookings or ARR model. Drive COGS from a gross margin assumption. Drive opex from a headcount plan (compensation is usually 60 to 75% of opex) plus a non-headcount opex line per department. Capex from the asset plan. Working capital changes from DSO, DPO, and inventory turn assumptions. The 12-month model does not need weekly precision — monthly is sufficient.

Runway Calculation

Runway equals current cash divided by average monthly net cash burn. Use the trailing three-month average burn, not the worst month or the best month. Show three scenarios: base (current trajectory), upside (20% better collections, 10% lower spend), and downside (20% worse collections, flat spend). Board materials should always show the downside runway. If downside runway is under 12 months, that is a fundraising trigger.

Working Capital Levers

Before assuming a fundraise, model the working capital levers: accelerate collections (incentivize early payment, tighten credit terms), extend payables (negotiate net-60 with key vendors), reduce inventory (if applicable), or defer non-essential capex. Each lever should show a dollar and week impact on the 13-week view.

Common Mistakes

Do not use net income as a proxy for cash flow — revenue recognition timing and non-cash charges make this unreliable. Do not forecast collections as a flat percentage of revenue without aging-based validation. Do not show a single-scenario forecast to a board — it signals overconfidence.