I've written before about the two questions most annual plans get wrong: how much pipeline a revenue target actually requires, and when that pipeline needs to exist given the sales cycle. Most companies answer the first question with a rough multiplier and skip the second one entirely, then spend Q4 wondering why a quarter of healthy-looking pipeline didn't close in time.
I built the Pipeline Coverage Calculator to answer both questions properly, in one place, for free, with no signup required.
Quick answers
How much pipeline do I need to hit my ARR target?
Take your net new ARR target, divide by average deal size to get the number of wins needed, then divide by your win rate to get the required number of opportunities. The Pipeline Coverage Calculator runs this backward funnel automatically and segments it by ICP or product line rather than using one blended rate.
What is a pipeline coverage ratio?
Pipeline coverage ratio is the multiple of open pipeline a team needs relative to its remaining quota or target, given a realistic win rate. A 3:1 to 4:1 ratio is common in SaaS, but the right ratio depends on segment-specific win rates rather than a single companywide assumption.
Why does sales cycle length matter for pipeline planning?
Pipeline created too late in the fiscal year cannot mature in time to close, regardless of volume. If a sales cycle averages six months, pipeline intended to close by December 31 needs to exist by June 30. The calculator applies each segment's own cycle length in days to show exactly when pipeline needs to be created.
Can one blended pipeline model work for multiple product lines or customer segments?
Usually not. SMB and enterprise segments on the same product commonly have different deal sizes, win rates, and sales cycle lengths. Averaging them into one model understates the timing need for the slower segment and overstates it for the faster one. The calculator runs each segment separately.
What it actually does
Start with a net new ARR target. The calculator works backward through win rate to tell you exactly how much pipeline that target requires, the same backward-funnel logic I've written about before, except this version doesn't stop at a single blended number.
Instead, it's built around segments. Add a segment for every distinct source, ICP, or product line that has its own economics, SMB versus enterprise, inbound versus outbound, one product line versus another, and give each one its own win rate, average deal size, and share of the mix. The tool auto-balances the segment splits so the mix always totals correctly as you adjust it, and calculates the required pipeline for each segment separately rather than forcing one blended assumption across a business that rarely behaves like one blended motion.
Then it adds the piece most pipeline calculators skip entirely: each segment carries its own sales cycle length, entered in days, defaulting to 90. That cycle length gets applied to produce a month-by-month pipeline creation calendar, showing exactly when pipeline needs to be created in each segment to still close within the fiscal year. An enterprise segment with a longer cycle needs its pipeline built earlier in the calendar than a fast-moving SMB segment on the same product, and the calculator shows that difference explicitly instead of hiding it inside one average.
There's also a rep capacity check built in, so the pipeline target gets reconciled against how much volume the sales team can actually work, not just against what the math on a spreadsheet says should be possible.
Why the segment-by-segment view matters
This is the same point I made writing about sales cycle variance across product lines and ICPs: a single blended cycle length breaks the moment a company sells more than one thing to more than one type of buyer. An SMB deal that closes in six weeks and an enterprise deal on the same product that takes seven months cannot share one pipeline-timing assumption without one of them being systematically wrong.
The calculator makes that variance visible instead of averaging it away. Run your SMB motion and your enterprise motion as two segments, and the tool will show you two different calendars, two different pipeline requirements, and two different points in the year where the clock actually starts. That's the detail that gets missed when a company plans off one blended number, and it's usually the detail that explains why one segment quietly misses its target while the blended company number looks fine on paper until it doesn't.
Built to actually use, not just look at
The calculator isn't a static estimate you read once. It exports to a full Excel workbook, so the model travels with you into the planning conversations where it actually needs to live, board decks, sales capacity planning, budget conversations with finance, without anyone having to rebuild the math from scratch in a new spreadsheet.
It's free and ungated because this is exactly the kind of foundational math a company should be able to run before it ever gets to a budget conversation, not something worth putting behind an email capture. If the exercise of running your own numbers through it surfaces a gap, that's useful information on its own, and it's also exactly the kind of gap my GTM Alignment Diagnostic and Budget Scoping Tool are built to help you work through in more depth.
You can run it yourself at christinecastro.com/pipeline-coverage-calculator.html.