Revenue Pipeline
Corporate Finance Financial Model (Free Excel Download)
Forecast sales pipeline by stage, win probability, deal value, slippage, quota coverage, and attainment to prioritize conversion and plan revenue capacity.
professionals from Deloitte
Used by professionals from
About this model
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 every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Revenue Pipeline
- 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
- 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.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
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).
Have more financial modelling questions? Contact us
Related templates
Sales Model
Top-down sales forecast with funnel volume and pipeline coverage analysis.
Sales Rep Forecast
Bottoms-up rep-level forecast with cohort ramp curves and attainment vs an annual target.
Cohort Retention
12-cohort SaaS retention model with logo curve, NRR, and LTV per cohort.
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.
