From Startup Fortune · · 2m
How to Calculate Sales Cycle Length by Deal Size
Segment sales cycles by deal size to forecast accurately and avoid cash shortages.
In brief
Segment sales cycles by deal size to forecast accurately and avoid cash shortages. Calculating sales cycle length by deal size using median and 75th percentile days improves cash planning and hiring decisions. Originally reported by Startup Fortune.
Why blended sales cycles mislead
A blended average hides the reality that small deals close quickly while large deals take months.
Calculate median and 75th percentile days
For each deal size band, find the median and 75th percentile days from opportunity created to contract signed.
Band minimums for accuracy
Each deal size band needs at least 15 closed deals to be meaningful for forecasting.
The blended average problem
The blended average across all deals is 45 days but the dollar-weighted cycle is 76 days for revenue impact.
Top band cycle length
The top band takes 121 days to close while the bottom band takes 24 days.
Cash timing vs cycle length
Cash timing is separate from cycle length and includes payment terms after contract signing.
Runway check before chasing bands
Runway in months minus band's median cycle minus payment terms must be positive to avoid cash shortages.
Pipeline coverage issue
Top-band pipeline created in last 30 days of a quarter can't close within the same quarter's coverage.
Rebuild forecast by segments
Multiply opportunities opened by win rate and ACV, then shift results by median cycle for accurate forecasting.
Shorten enterprise cycles
Identify the stage holding the wait and fix it for faster enterprise deals.
Security review fix
Send answers before security review requests to reduce wait time for enterprise deals.
Legal process improvement
Send contracts with proposals rather than after verbal agreement to speed up legal review.
Procurement process fix
Ask in first meeting who signs and walk through buying process step by step.
Mutual action plan
Create a shared document listing steps, owners, and dates to track progress.
Band-specific forecasting
Forecast each band separately using median cycle to avoid cash shortages.
Hiring impact of cycle length
A 76-day dollar-weighted cycle means two and a half months of unplanned salary for new reps.
In short
Calculating sales cycle length by deal size using median and 75th percentile days improves cash planning and hiring decisions.
