Sales Revenue and Performance

Model revenue forecasts in three scenarios

How much revenue can you count on this quarter, and how far are you from your target?

Works builds your revenue forecast in commit, most likely and best case scenarios. The commit is the total you sign off each period. The Revenue Forecaster agent multiplies each open deal's value by its chance to close. Pipeline coverage is open deal value divided by your target. You review coverage and the gap to target in a weekly forecast call.

Published Updated

What you get
Revenue forecast model · October to December 2026
Commit signed off
3.0x
pipeline coverage, $849,600 of open deals this quarter against a $283,200 target
12
open deals with a close date this quarter
Contract review · 2 deals $141,600 × 80% = $113,280
Proposal · 3 deals $212,400 × 55% = $116,820
Assessment · 4 deals $283,200 × 40% = $113,280
Discovery · 3 deals $212,400 × 28% = $59,472
Commit, deals at 80% or more $113,280
Most likely, deals at 50% or more $230,100, $53,100 below target
Best case, deals at 20% or more $402,852

You use the commit, the most likely total and the gap to the target in your leadership plan for the quarter.

See it run

A quarter forecast in progress

Quarter in forecast
October to December 2026 · $283,200 target from new clients
Deals updated for the weekly forecast call 9 / 12
Schedule
Every quarter
Snapshot every Monday morning
Run log
  1. You
    “Build the three forecast scenarios for October to December from the deals in HubSpot.”
    Your instruction
  2. Revenue target used Upstream
    The target of $283,200 in first-year value from new clients comes from Define Revenue Targets.
  3. Pipeline review used Upstream
    The stage, value and close date of each open deal come from Manage the Sales Pipeline.
  4. Deal-level forecast used Upstream
    The forecast for the 12 open deals with a close date this quarter comes from Forecast Revenue. Each deal is a monthly contract of $5,900, so $70,800 in the first year.
  5. Three scenarios built Revenue Forecaster
    The Revenue Forecaster agent calculated the chance to close for each stage from four quarters of closed deals in HubSpot. The chances are 28% for Discovery, 40% for Assessment, 55% for Proposal and 80% for Contract review. You chose 80% for the commit, 50% for most likely and 20% for best case. The commit is $113,280, most likely is $230,100 and best case is $402,852.
  6. Coverage and gap calculated Revenue Forecaster
    The Revenue Forecaster agent divided the $849,600 of open deals this quarter by the $283,200 target. Pipeline coverage is 3.0x. You chose 3x as the healthy level. Most likely is $53,100 below the target. You chose to show the gap and the deals that could close sooner.
  7. You
    Your sign-off on the commit needed You
    The weekly forecast call is on Monday mornings with your sales team. Your sales team updated 9 of 12 deals before the first call. Sign off the $113,280 commit after the last three updates.
How it works

Three forecast scenarios, checked against your target

The Revenue Forecaster agent calculates the chance to close for each stage from your past closed deals. The Revenue Forecaster agent multiplies each open deal's value by the chance for its stage. You choose the confidence level for each scenario, for example 80% for the commit. The Revenue Forecaster agent divides your open deal value by your target to get pipeline coverage. You sign off the commit each period. The Revenue Forecaster agent tracks forecast error over time.

What it needs
Your open pipeline and its stages
Your record of recently closed deals
Your revenue target
Your current forecast process, as the starting point
A CRM with deal-level data and stage probabilities set up
Your revenue targets, to calculate the gap to the target
Past win rates by stage, to set the stage probabilities
What you get

A commit each period that leadership can explain from the pipeline, and an early warning when pipeline coverage is low. A record shows forecast error falling over time.

Run sequence

Start to finish

You start from your revenue targets, your pipeline review and your deal-level forecast. Then you and the Revenue Forecaster agent build your forecast model in three parts.

  1. 1
    Three-Scenario Model

    Build the three forecast scenarios

    You choose the confidence level for each scenario
    Revenue Forecaster calculates win rates from closed deals
    Revenue Forecaster multiplies deal values by chance to close
    You + Revenue Forecaster
  2. 2
    Pipeline Coverage by Scenario

    Find the gap to your target

    Revenue Forecaster divides open deal value by target
    You choose the healthy and alarm levels for coverage
    You plan how to reach the target
    Revenue Forecaster + You
  3. 3
    Weekly Forecast Call and Forecast Accuracy Record

    Run a weekly forecast call

    You choose who attends and when the model updates
    Revenue Forecaster tracks forecast error by rep and overall
    You sign off the commit each period
    You + Revenue Forecaster
Before it starts

What Works asks you

A few questions in plain words. The answers set up the run for your business.

What confidence level should each scenario represent: commit, most likely, and best case?
YouCommit 80%, most likely 50%, best case 20%
Which stage probabilities should the forecast use to weight each deal (count it at its chance to close): the CRM defaults or your own rates from past deals?
YouOur own past win rates at each stage
Which pipeline coverage levels do you use to mark a pipeline as healthy enough to reach the target, or as an alarm?
You3x coverage is healthy, and under 2.5x sets off the alarm
When the commit falls short of the target, what should the model do: show the gap, or also suggest where to find it?
YouShow the gap and suggest which deals to close sooner
Who attends the weekly forecast call?
YouReps and managers, and each rep brings the next step and risk for each deal
How do you want to measure forecast accuracy over time: error percentage, or how often you hit the commit?
YouBoth, by rep and overall
Who runs it

The agents behind this workflow

The Revenue Forecaster agent builds the three forecast scenarios. The Compensation and Territory Planner agent sets quotas from your targets and your sales capacity.

Playbook specialist

Compensation and Territory Planner

Owns this area

Designs compensation plans, sets quotas, and plans territories so that pay and targets support the sales strategy.

What it can do
Designs compensation plans that reward the right behaviorSets quotas from targets and capacityBalances and assigns territoriesModels plan cost and quota attainmentLinks pay and targets to the sales strategy
On this workflow

Revenue Forecaster

Builds and weights the revenue forecast, sets stage probabilities from past deals, and tracks forecast accuracy

What it can do
Sets win rates from past closed dealsWeights the pipeline and adds it up into the scenariosCalculates pipeline coverage and the size of the gap to the targetTracks forecast error by rep and overall
Jeanie, your right hand Works Crew

Jeanie leads a core crew of seven that runs your company day to day. They direct the specialist and workflow agents in each playbook, including the ones on this workflow.

Connect your tools

Bring what you already run

Works connects to the apps you already use.

  • Gong The Revenue Forecaster agent connects to Gong.
  • Google Sheets This workflow uses Google Sheets.
  • HubSpot The Revenue Forecaster agent connects to HubSpot.
  • Microsoft Power BI This workflow uses Microsoft Power BI.
  • Salesforce The Revenue Forecaster agent connects to Salesforce.
Other apps you can use
Your CRM

or any CRM you use

Your call recorder
  • Fathom
  • Fireflies
  • Otter.ai
  • Chorus

or any call recorder you use

Your spreadsheet app
  • Microsoft Excel
  • Airtable
  • Smartsheet
  • Zoho Sheet

or any spreadsheet app you use

These are starting points, not a limit. Connect the tools you already use.

Works · AI business OS

One workflow inside your whole business

In Sales, Model Revenue Forecasts is part of the Revenue and Performance work.

Prebuilt playbooks, plus your own
StrategyMarketingSalesCustomer SuccessPartnershipsProducts & ServicesOperationsFinancePeopleLegal & Compliance + Build your own
The Sales playbook
64
Workflows
16
Specialist agents
17
Workflow agents
173
Templates
You're here
Model Revenue Forecasts
One of 64 Sales workflows · run by 1 workflow agent
Templates

What comes with it

Built for this workflow
Forecast Accuracy Tracker XLSX
A sheet where you track the accuracy of your forecast. It opens in Works after you sign up.
Scenario Forecast Model XLSX
A model for your forecast scenarios. It opens in Works after you sign up.
Also included here
Forecast Category Definitions DOCX
Definitions for each group of deals in your forecast. It opens in Works after you sign up.
Revenue Forecast Model XLSX
A model for your revenue forecast. It opens in Works after you sign up.
Quota Allocation Planner XLSX
A sheet where you plan how you divide quotas. It opens in Works after you sign up.
Quota Setting Policy DOCX
The policy for how you set quotas. It opens in Works after you sign up.
Quota Setting Model XLSX
A model you use to set quotas. It opens in Works after you sign up.
Forecast Reconciliation Model XLSX
A model you use to reconcile forecast numbers. It opens in Works after you sign up.
Revenue Gap-to-Target Model XLSX
A model of the gap between your revenue and your target. It opens in Works after you sign up.

Each template opens inside Works after you sign up.

Questions

What people ask

How do the three scenarios differ?

You decide the confidence level that each scenario represents. For example, the commit can be 80%, most likely 50% and best case 20%. The commit is the number you sign off each period. The Revenue Forecaster agent multiplies each deal's value by its stage's chance to close. The Revenue Forecaster agent adds the results into each scenario.

How does the model show the gap to your target?

The Revenue Forecaster agent compares each scenario total with your revenue target. The difference is the gap to the target. The Revenue Forecaster agent also calculates pipeline coverage. Pipeline coverage is the value of your open deals divided by your target. You choose the coverage level that counts as healthy and the level that sets off an alarm.

Who decides when a rep and the model disagree on a deal?

You decide whose call counts toward the commit when a rep and the model disagree. For example, the manager's judgment can win, and you log the reason. Or the model's number can stand. Or the rep's call can stand until a manager reviews the deal.

How do you measure forecast accuracy?

You choose the measure. You can use the forecast error percentage for each period, tracked over time. You can use how often you hit the commit. You can also use both. The Revenue Forecaster agent tracks forecast error by rep and overall. You also choose a forecast error goal for one quarter from now, for example under 10%.

Plan the quarter with three forecast scenarios

Sign up to build your three-scenario revenue forecast model.

Sign Up