Cash Flow Forecast Horizons: Short, Mid, Long

Three horizons, three jobs

Short horizon (1-4 weeks) is operational. It tells you whether payroll clears, whether the big supplier check should go out today or Friday, and which customer to call about an overdue invoice. Granularity is daily or every-other-day, sourced from bank balances and the AR/AP aging.

Medium horizon (5-13 weeks) is the treasury workhorse. It tells you whether you'll need to draw the line of credit, whether to slow hiring, whether to renegotiate supplier terms. Granularity is weekly, sourced from invoice schedules, payroll calendars, and loan amortization tables.

Long horizon (3-12 months) is strategic. It tells you whether the next planned hire is affordable, whether the equipment purchase makes sense, whether the marketing budget can grow. Granularity is monthly, sourced from the annual plan with assumed conversion of pipeline.

Layering the horizons together

The mistake operators make is using one forecast for everything. A 12-month forecast blurs week-to-week timing into monthly buckets and hides cash crunches. A 4-week forecast misses the slow-building trend that will bite in week 9.

Best practice is to maintain all three, refresh them on different cadences (weekly, monthly, quarterly), and reconcile them at refresh time so assumptions stay consistent across horizons.

Combining horizons in one operating rhythm

Mature finance functions don't pick one horizon — they layer all three. A 13-week direct forecast drives weekly operating decisions and gets refreshed every Monday. A 12-month indirect forecast feeds the annual budget and gets refreshed monthly during the close. A 3-5 year strategic model is rebuilt once a year (often in Q4 for the next fiscal year) and only revisited when something material changes: a fundraise, an acquisition, a recession, a new product line.

The horizons inform each other. Variance in the 13-week is the early warning system for the 12-month; variance in the 12-month forces re-baselining of the 3-5 year. Going the other direction, the long-range model sets the strategic targets that the annual budget is supposed to hit, which the 13-week is supposed to execute on a week-by-week basis.

For a small service business, layering all three is overkill. The pragmatic minimum is a 13-week rolling forecast plus an annual budget refreshed each quarter — that combination catches almost every cash surprise without burying the founder in spreadsheets.

Each horizon needs an owner. The 13-week is usually owned by the controller or CFO; the 12-month by FP&A or the CFO; the 3-5 year by the CEO or board. Assigning unique ownership prevents the documents from drifting out of sync and ensures someone is accountable for the assumptions in each — without that ownership, the long-range model becomes an annual artifact that nobody trusts.