CFO KPIs for the Sales Forecast: What the Pipeline Supports

Funnel Economics gives CFOs KPIs for the sales forecast, straight from Salesforce. They show the expected value of the open pipeline at your own historical stage win rates and the distance between bEFV and rEFV. They also compare earlier forecasts with revenue won. This does not replace planning. It shows what revenue forecasting can rely on and what it cannot.

Which questions do CFOs ask?

Sales reports a forecast, and financial planning builds on it. Five questions help to check that number before it enters the plan. Each has a metric drawn from your own data.

How much of the pipeline can we expect at our own stage win rates?

The sum of open deals is not an expected value. bEFV, the structural expected value, multiplies each opportunity's amount by its stage win rate. The stage win rates come from your own past, per sales rep, opportunity type and stage.

rEFV, the risk-adjusted revenue expectation, additionally weights bEFV by SLA Health, with measured factors per band. SLA Health classifies each open opportunity by its total age in the funnel, measured against the SLA values of the stage. Your organisation sets these SLA values itself. rEFV is an expectation, not a floor.

What does the distance between bEFV and rEFV show?

EVL, the distance between bEFV and rEFV, is expressed in euros but is not a lost amount: it is the distance between two expected values. There is no fixed threshold for it. What is judged is how the share of EVL in bEFV develops against its own history.

How well was the forecast calibrated, and how did the result stand against plan?

EFV Ratio as the check of forecast against result relates the revenue won to rEFV at the start of the period. It says how well the forecast was calibrated, nothing about quota attainment, and can stand beside a missed plan.

A single value says little here. The article on Forecast Integrity, forecast vs actual in sales describes the check against two yardsticks: the plan for the same window and the result of finished windows. Both stand as a series across periods.

cEFV, the calibrated revenue forecast, refers to the end of the period. It is the best case of the forecast range, not the realistic case. cEFV is calculated by the optional add-on Funnel Economics Strategist. Strategist is designed to give a forecast for the executive level as a range of three named cases; in the running quarter, as three standings.

Is the pipeline growing, or only its amount?

A growing pipeline looks like coverage. If rEFV falls over several periods at the same time, the pipeline grows and its expected value does not. That pattern is described in the article on Strategic Decoupling, when the pipeline grows and its expected value falls.

Coverage therefore belongs on the table as a pair. Nominal coverage divides the open pipeline by the gap to target. The Health-Adjusted Coverage Ratio (HACR) puts rEFV in the place of the open pipeline. The finding is the distance between the two values. HACR cannot be added or averaged across levels.

EFV Density, a term of the method for pipeline quality, sets rEFV in relation to the amount of the open pipeline at the end of the period. No tool reports EFV Density.

Does the quarter hang on a few deals?

When a very small number of deals carries a dominant share of a period's expected value, the forecast hangs on them. This is judged against the history of that concentration itself and the number of deals, not against a fixed mark. A counter-calculation shows the same forecast without the concentrated deals. More on this is in the article on Bulk Risk Concentration, concentration risk in the forecast.

Which metrics matter for CFOs?

The table assigns each metric the question it answers.

CFOs need not take a forecast on trust: they can check it against the pipeline's expected value, the distance between bEFV and rEFV and the result of past periods.

How to get started

Funnel Economics is entering its beta phase. During the beta, you start by running it against a Salesforce sandbox.

Funnel Economics Core is a managed package that runs in your Salesforce org. The prerequisite is Salesforce Enterprise Edition; Data Cloud is not required. There, Core calculates bEFV and a simplified rEFV by health status.

Core ships with dashboards for the executive level. They show quota attainment. For dashboard commentary, Core can call a language model. This AI data transfer is off by default and is enabled per org and per user; the package masks personal values before the call.

Funnel Economics Strategist is an optional add-on and not active by default. Strategist requires a per-user authorisation that your Salesforce administrator controls and can revoke. The prepared context then passes through a service we operate to the language model you have chosen, with the names of sales reps and opportunities and record links.

The language model processes the data under your own agreement with the provider. We strongly recommend securing the use of Strategist with an enterprise agreement with that provider, including a data-processing agreement that excludes the use of the data for training. That is a recommendation, not a precondition.

For leadership, Strategist is designed to state age in days, to name any amount beside it for what it is, the distance between two expected values, and to close every diagnosis with two to three options for action.

Discover is meant for trying Funnel Economics before any installation. It is built on a demo org.