- Home
- RevOps & Sales Enablement
- Sales Forecasting & Pipeline
Most companies forecast whatever the CEO says.
That's a wish, not a forecast
"We need $5M next year." The number comes down from the top, gets divided by headcount, and has no relationship to what the pipeline can actually produce. A real forecast is built bottom-up from its parts - segmented by territory or product, split into new vs existing business, attributed to channels, then run through the math. We install the components and the rhythm so your number is something the whole company can plan on.
Top-down forecasting by mandate doesn't survive contact with reality
THE PROBLEM
The number is set by ambition, then handed down. Reps sandbag or over-commit. Deals slip every quarter. Revenue hockey-sticks in the last week. Eventually leadership stops trusting the forecast and starts managing by gut, and the board notices.
The fix isn't a better spreadsheet. It's building the forecast the other way around: from the components up, so every number traces back to a real, countable source.
Two ways to arrive at a number
TOP-DOWN ✕
“$5M”
÷ headcount
Rep
Rep
Rep
divide by heads → hope
BOTTOM-UP ✓
Forecast
Sum + Math
Seg
New/exist
Channel
parts → sum → defensible
WHAT A FORECAST IS BUILT FROM
One number, sliced four ways - then the math
A forecast isn't a single figure. It's your pipeline and recurring base, viewed through four lenses, each of which has to add up on its own before the total means anything.
What a forecast is built from
One number, sliced four ways – then the math.
Pipeline
+ recurring base
① Segment
Territory or product line
② New vs Existing
New logos vs renewal + expansion
③ Channel
Inbound · outbound · partner
④ Stage weighting
Probability × value
Coverage
+ weighting
Worst case
Commit
Best case
A range you
can plan on
COMPONENT 1 - SEGMENTATION
Forecast by territory or by product - never as one lump
A blended company-wide number hides where growth and risk actually live. Slicing by territory (or product line) shows which segment is carrying the forecast and which is quietly underwater.
FORECAST CONTRIBUTION BY SEGMENT
Example dashboard
One blended number would have hidden that West is 39% short – and that the gap is concentrated, not company-wide.
COMPONENT 2 - NEW VS EXISTING
The mandatory split: new business vs the existing base
New logos and existing-account revenue behave nothing alike: different cycles, different predictability, different cost. Forecasting them as one number is the most common way a forecast goes wrong. Existing (renewal + expansion) is far more predictable; new business is where the risk and the variance live.
FORECAST SPLIT BY QUARTER
Q1
Q2
Q3
Q4
Why the split is non-negotiable
Different predictability
Existing base forecasts on renewal rates; new business on pipeline conversion
Different cost
New logos cost multiples of expansion revenue to book
Different owners
New = sales; existing = AM/CS. Blending hides who’s accountable
Different risk
A miss in new business needs a totally different fix than a renewal dip
COMPONENT 3 - CHANNEL ATTRIBUTION
Decide where the revenue is supposed to come from
FORECASTED REVENUE BY CHANNEL
Plan vs run-rate
Solid = planned share · faded = actual run-rate
The outbound gap is the story: the plan leans on a channel that’s underperforming. Now it’s a fixable problem, visible in week 2 – not a surprise at quarter-end.
A forecast should name its sources. If 45% of the number is expected from outbound but outbound only produced 15% last quarter, you've found the gap before it becomes a miss - not after.
COMPONENT 4 - THEN THE MATH
Stage weighting and coverage turn pipeline into a number
Only once the slices are in place does the math mean anything: weight each deal by its real stage probability, and check you have enough coverage to hit the number.
| STAGE | PROB. | RAW | WEIGHTED |
|---|---|---|---|
| Discovery | 20% | $400K | $80K |
| Eval | 40% | $300K | $120K |
| Proposal | 60% | $250K | $150K |
| Negotiation | 80% | $180K | $144K |
| Commit | 95% | $120K | $114K |
| Weighted total | $1.25M raw | $608K |
The forecast dashboard your board can read weekly
All four components roll into one view: a scenario range, the gap to quota, and coverage - updated on a rhythm, not reconstructed in a panic before each board call.
PUTTING IT TOGETHER
WHAT WE BUILD
The components and the rhythm
Forecast Model
Built bottom-up: segmented by territory/product, split new vs existing, attributed to channels.
Stage Weighting
Probabilities calibrated on your real historical conversion – not default percentages.
Coverage & Scenarios
Coverage ratios and worst/commit/best ranges that flag a gap while there’s still time.
Review Rhythm
A weekly pipeline-review cadence that inspects deals, catches slippage, and keeps the number honest.
WHY IT MATTERS
A forecast built from parts is a forecast you can act on
Hiring plans, cash management, board confidence, and investor trust all depend on a number that holds. When the forecast is a top-down mandate, a miss is a mystery. When it’s built from segment, new-vs-existing, channel, and the math, a miss tells you exactly which part broke, and you see it coming with weeks to spare. That’s the difference between forecasting as a reporting chore and forecasting as an operating system.
EXPLORE MORE
Related capabilities
COMMON QUESTIONS
Frequently asked questions
Why is bottom-up forecasting better than top-down?
A top-down forecast is a target handed down and divided by headcount – a wish with no link to the pipeline. A bottom-up forecast sums real pipeline by segment, new vs existing, channel, and weighted stage, so every number traces to a countable source and you can see exactly where a gap will appear.
What is pipeline coverage and what’s a healthy ratio?
Pipeline coverage is the ratio of qualified open pipeline to your target (pipeline ÷ quota). A common healthy band is 3-4×, since not every deal closes. Coverage below the band signals the target is at risk while there’s still time to generate or accelerate pipeline.
Why should we split the forecast into new vs existing business?
New logos and existing-account revenue behave nothing alike – different cycles, predictability, cost, and owners. Forecasting them as one number is the most common way a forecast goes wrong. Existing (renewal + expansion) is far more predictable; new business is where the variance and risk live.
Is your forecast a plan or a wish?
Start with a Sales Audit. We'll rebuild your number from the components up: segment, new vs existing, channel, and the math, and install the review rhythm that keeps it honest.
Our Recent Blog Posts
Welcome to our blog, where we explore the latest trends and tips on building sales systems for IT and SaaS.
Finding the right Sales and Support specialists for your team is one of the most crucial responsibilities of every business
From 2020 to 2022, outbound sales (cold outreach via LinkedIn, email, and platforms like Upwork) were the primary lead generation
Stepping into a sales leadership role is an exhilarating yet demanding opportunity. The first 100 days are pivotal in shaping
Growing company revenue is challenging nowadays, so organizations constantly seek ways to improve their sales and marketing performance. One of
Alex is a newly hired Tech Sales Representative at a software development company that offers outsourcing services. He is skilled
Of course, the right sequence requires the founders or the CEO to start with a Corporate Strategy (nice if it





