# Revenue Pipeline A weighted sales-pipeline forecast: five stages each with their own win probability, baseline open deals and average ACV roll into a monthly weighted pipeline. A quarterly slip analysis pushes a configurable share of late-stage deals from one quarter into the next and reports year-end leakage. Summary ties pipeline to quota coverage and post-slip attainment. - Canonical: https://finamodel.com/templates/revenue-pipeline - Excel download: https://finamodel.com/templates/revenue-pipeline.xlsx - Category: Corporate Finance - Model type: Operating model - Difficulty: Intermediate - Audiences: CFOs & FP&A, Founders & operators, CFOs, Sales leaders, RevOps, FP&A teams - Tags: pipeline, sales forecast, weighted pipeline, slip, quota coverage ## Overview A revenue pipeline model converts a snapshot of open deals into a monthly weighted-pipeline forecast and layers a quarterly slip analysis on top so a CFO, sales leader, or RevOps manager can read coverage against quota and quantify slip leakage in one workbook. The model treats the pipeline as five stages - Lead, Qualified, Proposal, Negotiation, Verbal Commit - each with its own win probability, baseline open deal count, and average ACV. Every monthly forecast cell is a single product of those three drivers, so flexing any one assumption flows through the entire model. The Pipeline sheet builds three parallel sections across 12 monthly columns: deal counts per stage (baseline grown at the Inflow_Growth rate), gross stage value (deals × ACV), and weighted stage value (deals × ACV × win probability). Total rows sum the five stages cell-for-cell and a late-stage row pulls out the Stage 4 + Stage 5 weighted total, which becomes the candidate close pool for the slip analysis. The Slip_Analysis sheet then sums late-stage weighted across the three months in each quarter, multiplies by Slip_Rate to compute slip outflow, pulls the prior-quarter outflow in as slip inflow, and reports the post-slip expected close per quarter. Q4 outflow leaves the planning year and is reported as year-end leakage. The Summary sheet rolls the workbook into a one-page IC view: gross and weighted pipeline at year-end, blended win rate (weighted / gross), pre-slip and post-slip expected close, year-end slip leakage, annual quota, coverage ratio (weighted / quota) and post-slip attainment versus quota. CFOs, sales leaders, RevOps managers, and FP&A teams use this template for quarterly forecast calls, stage-probability calibration, and coverage sizing during the planning cycle. Coverage of 3-4x against annual quota is healthy for enterprise sales motions; SaaS teams often run 4-5x because of higher slip rates and longer cycles. ## What's included - 12-month Pipeline sheet: per-stage deal count, gross value and weighted value across five stages - Five stages with editable win probabilities: Lead, Qualified, Proposal, Negotiation, Verbal Commit - Total open deals, total gross pipeline, total weighted pipeline and a late-stage (S4+S5) line per month - Quarterly Slip_Analysis: pre-slip close, slip outflow, slip inflow from prior quarter, post-slip close, year column - Year-end leakage isolated so Q4 deals pushed into next year are reported separately - Summary with coverage ratio, blended win rate, post-slip attainment and a close-reconciliation check row - 12-month Pipeline sheet with per-stage deal count, gross value and weighted value - Five stages: Lead, Qualified, Proposal, Negotiation, Verbal Commit with editable win probabilities - Slip_Analysis sheet with quarterly pre-slip close, slip outflow, inflow from prior quarter, and post-slip close - Year-end leakage isolated so deals pushed out of Q4 are reported separately - Coverage ratio (weighted pipeline / quota) and post-slip attainment versus quota - Blended win rate and average deal size derived from the gross and weighted totals ## How the Revenue Pipeline Template Forecasts Sales This template helps B2B sales teams build a monthly revenue pipeline forecast. It stages deals from leads through five sales stages, applying conversion and win rates to project closes. The model includes slip analysis, capacity planning, and a summary view. This explanation describes the documented mechanics so you can evaluate whether the approach fits your planning needs. ### Operating drivers and funnel mechanics Monthly lead inflow grows at a configured rate and is adjusted by seasonality, then converts to MQLs, SQLs, and opportunities using stage conversion rates. Opportunities enter the pipeline as Stage 1 deals. - Three deal tiers—SMB, Mid-Market, and Enterprise—have their own average contract values and mix shares, producing a blended ACV. Channel mix and per-channel win multipliers further adjust expected revenue. - Per-stage win rates and dead-deal rates govern deal progression and loss. Sales-cycle days per stage set the pace of advancement, and the model uses a 30-day month for timing calculations. ### Calculation flow through the pipeline The pipeline operates on a true flow basis: each month, opening balances receive entering deals, some deals die, some progress, and the remainder close into the next stage or the next month. For each stage, dead deals depend on opening volume, dead-deal rate, cycle days, and win rate. - Progression follows a similar formula but advances win-rate-conserving deals. Stage 5 progress becomes gross closes. - A slip rate moves a portion of late-stage deals from one quarter into the next, with inflow from the prior period. Net closes are gross closes minus outflow plus inflow, floored at zero, then converted to dollars using blended ACV and channel win multiplier. ### Outputs and performance measures The model produces monthly net closes in both deals and dollars, gross closes, weighted open pipeline, commit and best-case forecasts, and post-slip annual attainment. Coverage compares opening pipeline dollars to annual quota. - Capacity planning shows headcount ramping over five months, productivity-weighted reps, per-rep deal capacity, utilisation, and phased quota. Cohort aging tracks opening pipeline by creation quarter and stage-age distribution at month 12. - Historical actuals calibrate stage win rates. A summary sheet consolidates these outputs with traffic-light indicators for coverage and attainment. Fifteen validation checks verify reconciliation and input ranges, returning PASS or FAIL. ### Practical use and planning applications Teams can use this template for quarterly forecast calls, stage-probability calibration, coverage sizing during planning, and headcount sign-off. The flow mechanic ensures each open deal contributes to expected close in exactly one month, avoiding double-counting. - Coverage and attainment metrics, along with traffic-light formatting, quickly flag whether pipeline is sufficient or quota is realistic. Capacity and quota phasing help assess whether sales headcount can deliver the forecast. - The slip analysis isolates late-stage deal movement and year-end leakage, supporting more accurate quarterly commitments. All inputs are positive, and the model uses native Excel functions for compatibility. The public download is a values-only preview; it does not recalculate live. ## Built for the quarterly forecast call Sales-leadership reviews live and die on one number: how much do we close this quarter, and what is the slip risk. This template surfaces both - pre-slip pipeline, slip outflow per quarter, and a post-slip close that ties straight to quota. ## Designed for RevOps calibration Every stage win probability, deal count, ACV, slip rate and quota is a named-range cell. Flex any one and the weighted pipeline, slip outflow, coverage and attainment recompute across all five sheets so re-calibrating on historical data is a single-cell exercise. ## Audit-friendly mechanics Every formula is one or two operations, every Assumptions row is referenced downstream, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Built for the quarterly forecast call Sales-leadership reviews live and die on one number: how much do we close this quarter, and what is the slip risk. This template surfaces both - pre-slip pipeline, slip outflow per quarter, and a post-slip close that ties straight to quota. ## Designed for RevOps calibration Every stage win probability, deal count, ACV, slip rate and quota is a named-range cell. Flex any one and the weighted pipeline, slip outflow, coverage and attainment recompute across all five sheets so re-calibrating on historical data is a single-cell exercise. ## Audit-friendly mechanics Every formula is one or two operations, every Assumptions row is referenced downstream, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: per-stage win probability, baseline deals, average ACV, inflow growth, slip rate, quota. - Five stages with win probability, baseline open deals and average ACV each - Monthly pipeline inflow growth rate - Quarterly slip rate on late-stage deals - Annual quota for coverage and attainment benchmarks ### Pipeline Monthly deal count, gross value and weighted value per stage with totals and late-stage row. - Period and Quarter rows for downstream slicing - Deal-count block: five stages plus total - Gross-value block: deals × ACV per stage plus total - Weighted-value block: deals × ACV × win prob per stage plus total - Late-stage (Stage 4 + Stage 5) weighted row for slip math ### Slip_Analysis Quarterly view of late-stage close pre and post slip with year-end leakage. - Pre-slip expected close per quarter and year - Slip outflow = pre-slip × slip rate - Slip inflow from prior quarter (zero for Q1) - Post-slip close = pre-slip − outflow + inflow - Year-end leakage = Q4 slip outflow (lost from planning year) ### Summary One-page rollup: pipeline, slip outcomes, plan benchmark and drivers. - Gross and weighted pipeline at M12 plus blended win rate - Pre-slip and post-slip annual close with slip leakage - Annual quota, coverage ratio (weighted / quota), attainment versus quota - Avg deal size at M12 and quarterly slip rate - Close reconciliation check row that resolves to zero ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: per-stage win probability, baseline deals, average ACV, inflow growth, slip rate, quota. - Five stages with win probability, baseline open deals and average ACV each - Monthly pipeline inflow growth rate - Quarterly slip rate on late-stage deals - Annual quota for coverage and attainment benchmarks ### Pipeline Monthly deal count, gross value and weighted value per stage with totals and late-stage row. - Period and Quarter rows for downstream slicing - Deal-count block: five stages plus total - Gross-value block: deals × ACV per stage plus total - Weighted-value block: deals × ACV × win prob per stage plus total - Late-stage (Stage 4 + Stage 5) weighted row for slip math ### Slip_Analysis Quarterly view of late-stage close pre and post slip with year-end leakage. - Pre-slip expected close per quarter and year - Slip outflow = pre-slip × slip rate - Slip inflow from prior quarter (zero for Q1) - Post-slip close = pre-slip − outflow + inflow - Year-end leakage = Q4 slip outflow (lost from planning year) ### Summary One-page rollup: pipeline, slip outcomes, plan benchmark and drivers. - Gross and weighted pipeline at M12 plus blended win rate - Pre-slip and post-slip annual close with slip leakage - Annual quota, coverage ratio (weighted / quota), attainment versus quota - Avg deal size at M12 and quarterly slip rate - Close reconciliation check row that resolves to zero ## Features - **Stage-by-stage weighting:** Every stage carries its own deal count, ACV and win probability as named ranges. Change a single probability and the weighted pipeline, coverage ratio and attainment recompute across the workbook. - **Quarterly slip mechanic:** Late-stage (Stage 4 + Stage 5) deals are summed per quarter, slipped at a configurable rate into the next quarter, and the post-slip close is read against quota. Q4 slip is reported as year-end leakage. - **Coverage and attainment together:** Summary surfaces both the snapshot coverage ratio (weighted pipeline divided by quota) and the post-slip attainment (annual close divided by quota), so under-pipelined and over-pipelined orgs are immediately visible. ## Use cases - **Quarterly forecast call:** Walk the leadership team through pre-slip pipeline, the slip outflow each quarter, and the post-slip annual close - with quota and attainment sitting on the same line. - **Stage-probability calibration:** Compare the modelled blended win rate against historical close rates and adjust per-stage probabilities until the weighted pipeline matches actual conversion. - **Coverage sizing for the planning cycle:** Flex deal counts, ACV and quota until the M12 coverage ratio lands in the 3-5x band that signals a healthy enterprise pipeline. ## Frequently asked questions ### What is a weighted pipeline? A weighted pipeline multiplies each open deal by the historical win probability of the stage it sits in. A $100k deal at Proposal (50% historical win rate) contributes $50k to the forecast; the same deal at Verbal Commit (90%) contributes $90k. Summing across all stages produces the weighted pipeline - the canonical forecast metric for B2B sales orgs. ### How does the slip mechanic work? Each quarter, the model sums late-stage (Stage 4 + Stage 5) weighted value across the three months in that quarter. The Slip_Rate parameter pushes a fraction out as slip outflow; the prior quarter's outflow comes back in as slip inflow. Post-slip close = pre-slip − outflow + inflow. Q4 outflow leaves the planning year entirely and is reported as year-end leakage. ### What coverage ratio should I target? 3-4x weighted pipeline against annual quota is healthy for an enterprise sales motion. SaaS teams often run 4-5x because of higher slip and longer cycles. Coverage below 2x signals an under-built pipeline; coverage above 6x usually means the stage probabilities are too generous. ### Why are the early-stage win probabilities so low? Early-stage deals close at low historical rates because they fall out through discovery, budget reviews, and competitive losses. The defaults (10% Lead, 25% Qualified, 50% Proposal, 75% Negotiation, 90% Verbal Commit) are the canonical B2B-SaaS curve from industry benchmarking. Replace with your own historical close rates per stage for a calibrated forecast. ### How is the pipeline inflow growth applied? All five stage deal counts grow each month at the Inflow_Growth rate, modelling a top-of-funnel that scales with marketing investment. Set Inflow_Growth to 0% for a flat snapshot; 5%+ for an aggressive top-of-funnel build. Each stage's deal count at month m equals baseline × (1 + Inflow_Growth) ^ (m − 1). ## Related templates - [Sales Model](https://finamodel.com/templates/sales-model) - [Sales Rep Forecast](https://finamodel.com/templates/sales-rep-forecast) - [Cohort Retention](https://finamodel.com/templates/cohort-retention)