Finance · Revenue Modeling

Samso Managed Services · Last Updated · Apr 2026

Revenue Forecasting

A bottoms-up revenue model wired to your acquisition cohorts, retention curves, ARPU mix, and live pipeline - every dollar of forecast is traceable to a customer cohort or an open opportunity, not a top-down assumption.

What the managed workflow does

Builds cohort retention curves

Every acquisition cohort gets a retention curve derived from actuals. Triangles update as new months close. No more averaging across mixed cohorts.

Layers in pipeline-driven new logos

Open pipeline by stage and close date feeds the new-cohort assumption. Stage probability and slip factors are tunable per segment.

Sensitizes the curve

Plus/minus retention scenarios, ARPU mix shifts, and pipeline conversion deltas roll through. Three forecast bands, same source.

Reconciles to bookings

Forecast ARR ties to billing actuals each close. Variance is decomposed into retention drift, expansion, and pipeline misses.

Cohort retention triangle · driving the ARR forecast curve

8 Cohorts · 268 Customers · $1.69M ARR by Q4 '26

RETENTION TRIANGLEBy acquisition cohort × months since acquisitionM1M2M3M4M5M6M7M8Q3 '2418 acq100%94%88%82%78%75%72%70%Q4 '2422 acq100%95%90%85%80%77%74%Q1 '2526 acq100%96%92%87%83%80%Q2 '2530 acq100%96%92%88%84%Q3 '2534 acq100%97%93%89%Q4 '2540 acq100%97%94%Q1 '2646 acq100%98%Q2 '2652 acq100%COHORT-WEIGHTED ARR FORECAST$K · driven by triangle × ARPU × pipeline$300$800$1300$1800Q3'24Q4'24Q1'25Q2'25Q3'25Q4'25Q1'26Q2'26Q3'26Q4'26$1690K8 cohorts · 268 customers · ARR projection $1.69M by Q4 '26

Triangle inputs (per cohort)

≥ 95% retained · cohort core80–94% retained< 80% retainedFuture months · forecast cells

Forecast curve drivers

Actual ARR (closed quarters)Cohort-weighted forecastPipeline-tied add-on cohortsSensitivity · ±10% scenarios

Inputs to the model

  • Acquisition cohorts. Every customer's start month and segment, sourced from billing or CRM closed-won.

  • Retention actuals. Per-cohort dollar retention measured each month - feeds the triangle directly.

  • Pipeline + stage logic. Open opportunities with stage probability and historical slip factors drive the new-cohort assumption.

  • ARPU & expansion. Per-segment starting ARPU and observed expansion rates by tenure month.

Outputs leadership uses

  • Cohort triangle. The retention picture across every cohort - the visual leadership and investors want first.

  • ARR forecast band. Base / bull / bear curves with the same triangle and three pipeline conversion assumptions.

  • Reconciliation memo. Quarterly variance memo decomposing forecast misses into retention, expansion, and new-logo factors.

  • Driver tree. Diagram showing every assumption that moves the forecast - single page, board-ready.

What you get, every week

A defensible forecast

Bottoms-up, cohort-grounded, and tied to live pipeline. No top-down growth-rate assumptions hiding behind the scenes.

Visible retention truth

The triangle shows where retention is strong, where it's degrading, and which cohorts are dragging the average.

Re-forecast in hours

Update one curve or pipeline file and the bands re-roll. Quarterly re-forecasts are a meeting, not a project.

Get Started

Ready to put AI to work for your business?

Book a free discovery call and we'll show you exactly where managed services can save you time and money.

Or email us at support@samso-consulting.com

Send us a message