Cash Flow Forecast

Demo

Click to play with sound.

---
name: Cash Flow Forecast
description: Builds a rolling 13-week and 12-month cash flow forecast with runway view. Use when managing liquidity, planning for fundraising, preparing board materials, or stress-testing the business under downside scenarios.
---

# 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.
… install to load the full skill