What this shows: how I build up a revenue forecast (booked + discounted pipeline + topside, by line, market and region) and how I report it to leadership: headline, key findings, variance to prior cycle and last year, and forecast accuracy over time. All data is generated sample data for a made-up firm.
CM = Sales + Debt. Prior column is the 9/28 Q4 FYF. Year-ago is Q4 2025 actual.
Change by region since the last cycle.
Actual revenue by quarter, $M labelled on each bar. Q4 2026 is the 10/19 forecast (lighter bar). Hover a bar for the split.
Rate line is the published federal funds target. Everything else is generated for this demo.
A sample of the deal list. Deals at 50% or above feed the discounted pipeline (gross × probability); deals below 50% are upside and stay out of the base forecast.
Deals by booked date. Revenue = recognized revenue.