Forward Revenue Model

Next four quarters from the three books that exist today — 38 reps · 505 open opportunities · 441 renewal contracts · synthetic data

Bookings: capacity vs pipeline, with coverage

$0M$9M$19M2026Q32.3x cov2026Q41.7x cov2027Q10.5x cov2027Q20.8x cov ■ capacity ■ raw pipeline ■ weighted pipeline
Coverage = raw pipeline ÷ capacity, against a 3.0× planning floor. 2027Q1 is the flag that matters: thin coverage two quarters out is a pipeline-generation problem visible before it becomes a bookings miss — the entire point of running this weekly.

ARR build — next four quarters

QuarterBeginning $MNew ExpansionChurnEnding $M New sourced fromGross ret (Q)
2026Q3$46.0+$4.9+$0.6−$0.7$50.8pipeline89.9%
2026Q4$50.8+$4.1+$0.6−$0.9$54.6pipeline84.6%
2027Q1$54.6+$7.1+$0.7−$0.8$61.6capacity88.5%
2027Q2$61.6+$7.4+$0.8−$1.0$68.7capacity84.1%
Near-in quarters source new business from stage-weighted pipeline (evidence); far-out quarters from capacity × 82% historical attainment (the pipe that will exist hasn't been generated yet). Mixing the two on purpose, and saying so, beats pretending either is a forecast on its own.

Renewal book by quarter

QuarterBook Risk-wtd keptGross ret
2026Q3$6.9M$6.2M89.9%
2026Q4$6.2M$5.2M84.6%
2027Q1$6.7M$6.0M88.5%
2027Q2$6.5M$5.5M84.1%

Largest at-risk renewals

ContractSegmentQuarter HealthARR
N0417enterprise2027Q2yellow$299,855
N0376enterprise2027Q2red$298,755
N0242enterprise2027Q1yellow$298,233
N0317enterprise2027Q1red$296,254
N0430enterprise2027Q2red$287,546
N0191enterprise2026Q4red$275,347
N0164enterprise2026Q4red$248,094
N0077enterprise2026Q3yellow$218,167
N0033enterprise2026Q3red$208,430
N0393enterprise2027Q2red$195,095