Sales Pipeline: 50 Qualified Leads × 20% Close Rate = SGD 500K Forecast
B2B sales: 100 prospects (5% close rate) = 5 deals. 50 qualified leads (20% close rate) = 10 deals. 20 proposals out (40% close rate) = 8 deals. 5 in negotiation (80% close rate) = 4 deals. Total expected closes: 5 + 10 + 8 + 4 = 27 deals/month = SGD 2.7M revenue (at SGD 100K/deal). Forecast by stage visibility = know revenue before customers decide.
- Sales Pipeline Stages
- Forecasting from Pipeline
- Pipeline Health Indicators
- AskBiz Pipeline Forecasting
- Calculating Weighted Pipeline Value Correctly
Sales Pipeline Stages#
(1) Prospect (cold): contact made, conversation started. 5% close rate. (2) Qualified: need confirmed, budget approved, timeline set. 20% close rate. (3) Proposal: proposal sent, customer reviewing. 40% close rate. (4) Negotiation: terms discussed, deal closing. 80% close rate. Each stage = different close rate.
Forecasting from Pipeline#
Count leads per stage, multiply by historical close rate. Pipeline today: 100 prospects (5% = 5 closes), 50 qualified (20% = 10), 20 proposals (40% = 8), 5 negotiation (80% = 4). Total: 27 closes. At SGD 100K/deal = SGD 2.7M forecast. Close timeline: prospect → close (90 days), qualified → close (45 days). By month: 25% closes this month (SGD 675K), 50% next month, 25% following month.
Pipeline Health Indicators#
(1) Stalled deals: proposals >30 days old without update (red flag, follow up). (2) Win rate by stage: if 40% of proposals close, that's good. If 10%, something wrong (proposal quality, pricing, follow-up). (3) Deal size variance: if 50% of deals are small (SGD 10K), 50% are large (SGD 200K), revenue volatile. Focus: pursue more large deals.
AskBiz Pipeline Forecasting#
Tracks leads by stage, calculates forecast. "100 prospects, 50 qualified, 20 proposals, 5 negotiation. Forecast: SGD 2.7M next 90 days. But: 15% of negotiation stage stalled >30 days (SGD 120K at risk). Recommendation: follow up on stalled deals. Also: proposals at 40% close rate (industry avg 50%). Improve proposal quality = 5 additional closes = +SGD 500K upside."
Calculating Weighted Pipeline Value Correctly#
Weighted pipeline value = Σ (deal value × stage close rate) across every open deal, and it's the number you should report as your forecast, not raw pipeline value. A SGD 500K deal sitting in the prospect stage (5% close rate) contributes SGD 25K to your weighted forecast, not SGD 500K — reporting raw pipeline value to a bank or investor wildly overstates what's actually likely to close. The formula only works if your stage close rates are derived from your own historical data, not industry benchmarks — pull your last 12 months of closed-won and closed-lost deals, group by the stage they were in 90 days before close, and calculate the actual conversion rate per stage for your business. Recalculate these rates quarterly; a sales team that's improved its qualification process will show higher qualified-to-close rates than a stale benchmark assumes.
Worked Example: Spotting the Forecast Gap Before It's Too Late#
A UK B2B services firm targeted SGD 800K in closed revenue for the quarter. Pipeline snapshot at the 6-week mark: 40 prospects (5% = 2 deals, SGD 100K avg = SGD 200K weighted at SGD 10K contribution... more precisely: 40 × 0.05 × SGD 100K = SGD 200K), 15 qualified (0.20 × 15 × SGD 100K = SGD 300K), 8 proposals (0.40 × 8 × SGD 100K = SGD 320K), 2 negotiation (0.80 × 2 × SGD 100K = SGD 160K). Weighted forecast: SGD 200K + 300K + 320K + 160K = SGD 980K, comfortably above the SGD 800K target — except 3 of the 8 proposals had received no customer response in over 25 days, a red flag for stalled deals that historically closed at half the normal proposal-stage rate. Adjusting those 3 deals down to a 20% close rate instead of 40% cut the proposal-stage contribution by SGD 60K, bringing the realistic forecast to SGD 920K — still above target, but the early warning let the sales manager reallocate follow-up effort to the stalled deals three weeks before quarter-end instead of discovering the shortfall too late to act.
Common Mistakes in Pipeline Forecasting#
The first mistake is using industry-average close rates instead of your own historical rates — a business with a strong qualification process might close 35% of qualified leads while the industry average sits at 20%, and using the lower benchmark would systematically undersell your actual pipeline strength (or vice versa, overstating it if your process is weaker than average). The second is not aging deals — a proposal sitting untouched for 45 days should not carry the same close probability as one sent yesterday; apply a decay factor or manually downgrade stalled deals before they distort the forecast. The third is forecasting from total pipeline count without checking deal concentration — if 60% of your weighted forecast sits in two large deals, your forecast is only as reliable as those two outcomes, and a single loss creates a much bigger miss than the weighted average suggests. AskBiz flags deals that have been stalled beyond your typical stage duration so they get downgraded in the forecast automatically rather than continuing to count at full stage-based probability.
People also ask
How do I improve close rate by stage?
Prospect: warm outreach (referral vs cold), qualified targeting. Qualified: demo/trial to confirm. Proposal: clear next steps, follow up in 5 days. Negotiation: authority present, decision driver identified.
What pipeline size is healthy?
3-6x monthly revenue target in pipeline. If target SGD 1M/month, maintain SGD 3-6M pipeline. Less = growth risk, more = too many stalled deals.
Our team combines expertise in data analytics, SME strategy, and AI tools to produce practical guides that help founders and operators make better business decisions.
Forecast Sales From Pipeline (Know Revenue 90 Days Ahead)
AskBiz segments pipeline by stage, predicts revenue by close date. Identifies stalled deals, suggests follow-up actions. Try free.
Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes