CONSTRUCTION FINANCIAL FORECASTING SYSTEM — FORWARD-LOOKING VISIBILITY THAT ACTUALLY WORKS.
A cash flow forecast built once and never updated is not a forecast. It is a historical record of what the business looked like on the day it was built. The forecast that functions as a management instrument is updated weekly from actual transactions, connected to the current project schedule so start date slips change the revenue projection automatically, and maintained at two time horizons: 13 weeks for cash management and 24 months for strategic planning. The difference between those two things is the difference between checking a weather forecast from last Tuesday and checking today's.
SPM maintains the 13-week and 24-month financial forecast as a live instrument in every CFOS Executive Financial engagement. It is updated Monday and reviewed in the monthly strategic meeting.
THE DIFFERENCE BETWEEN A ONE-TIME CASH FLOW SPREADSHEET AND A LIVING FINANCIAL FORECAST.
Built Once, Never Updated, Produces False Confidence
Most subcontractors who have attempted cash flow forecasting built a spreadsheet once. It was accurate for about 30 days — until the first project schedule changed, the first GC paid late, and the first new contract was signed that was not in the model. The spreadsheet was never updated because updating it requires rebuilding it. After 60 days it is a historical document masquerading as a forecast. The owner who relies on it is making decisions based on a model of a business that no longer exists. False confidence from a stale forecast is more dangerous than no forecast at all.
Updated Weekly from Actual Transactions and Current Project Schedules
A financial forecast that functions as a management instrument has four properties. It is updated weekly: actual transactions from the prior week replace the projected transactions in the model. It is connected to the project schedule: when a project start date slips, the corresponding revenue projection slips with it automatically. It is forward-looking at two time horizons: 13 weeks for cash management and 24 months for strategic planning. It is owned by the CFO function, not by the owner: the owner reviews it, not produces it. A forecast with these four properties is not a spreadsheet exercise. It is a financial control instrument.
13-Week and 24-Month — Different Decisions, Different Precision
The 13-week cash forecast is used for operational decisions: which weeks need a LOC draw, which collections calls need to happen before a payroll week, whether a vendor payment can be deferred. At 13 weeks, the forecast should be accurate within 10–15% on any given week. The 24-month forecast is used for strategic decisions: whether the business has the working capital to support projected revenue growth, when to increase the LOC, whether a new hire is financially sustainable. At 24 months, the forecast should be directionally accurate within 20–25% on any given month. The precision requirement decreases as the time horizon extends. The decision-making value does not.
THE FOUR COMPONENTS THAT MAKE FORECASTING RELIABLE.
The compounding value: A financial forecasting system that has been operating for 24 months contains two years of actual transaction data, 24 months of billing event history by GC, and a validated working capital model for the business at current revenue. That data produces progressively better strategic decisions — because it is built from what actually happened, not from what was assumed.
FREQUENTLY ASKED.
