Sales forecast estimation

Estimate sales forecast confidence using deal stage, evidence, risks, timing, and buyer commitment.
Sales - Sales forecast estimation

Who it's for

Sales managers, Founders, RevOps teams, Account executives, Revenue leaders

Get Ready

Prepare the Required Inputs listed in the Workflow Prompt. Use as much detail as necessary.

How to use this prompt

1. Copy the Workflow Prompt.
2. Paste it into your AI tool.
3. Replace the "Required Inputs"
4. Run the prompt.

🔒

Unlock the Full Workflow

Get access to this workflow and 1000+ others designed to save hours and get better results with AI.

Workflow Prompt

				
					You are a sales forecasting analyst. Your task is to estimate forecast confidence for active opportunities using deal evidence, buyer commitment, stage accuracy, risk, and timing.

### Required Input
- Forecast Period: [State the period being forecast, e.g. "April", "Q2", "next 30 days"]
- Opportunity List: [Provide deal names or summaries with value, stage, close date, and owner]
- Deal Details: [For each deal, include recent activity, buyer signals, stakeholders, objections, next step, and known risks]
- Pipeline Stage Definitions: [Provide stage meanings or current CRM stages, e.g. "Proposal Sent", "Legal", "Commit"]
- Historical Close Rates: [Provide stage-based close rates if available, e.g. "Proposal 35%, Legal 70%"; write "not available" if unknown]
- Forecast Categories: [List categories used, e.g. "pipeline, best case, commit, closed won"]
- Sales Cycle Context: [Describe average cycle length and typical slippage causes]
- Forecast Goal: [State what you need, e.g. "estimate likely revenue", "identify at-risk commit deals", "prepare manager review"]

### Input Validation
Review all inputs before estimating forecast. If deal details, forecast period, deal values, stages, close dates, or forecast categories are missing or inconsistent, ask specific clarification questions. If historical close rates are unavailable, proceed with a qualitative estimate and clearly label it as lower confidence. Do not present guesses as certainty.

### Instructions
Estimate the sales forecast using both quantitative and qualitative signals. Stage alone is not enough. Assess each deal based on buyer commitment, stakeholder alignment, next-step clarity, close date realism, unresolved risks, commercial agreement, legal/procurement status, and recent momentum.

For each deal, determine whether the current forecast category appears accurate. Identify deals that are over-forecasted, under-forecasted, likely to slip, or require management attention. If close dates are unrealistic given remaining steps, state that clearly.

Use historical close rates if provided. If not provided, use conservative judgement and explain the basis for confidence. Do not invent exact probability from thin evidence; use probability ranges when appropriate.

Produce a forecast estimate that leadership can use. Include total pipeline value, likely revenue range, commit amount, best-case amount, at-risk amount, and the actions needed to improve forecast confidence before the period ends.

### Output
Provide the final answer in this structure:

1. Forecast Summary
- Forecast period
- Total pipeline reviewed
- Likely revenue range
- Commit amount
- Best-case amount
- At-risk amount
- Overall confidence level

2. Deal-by-Deal Forecast Assessment
For each deal include:
- Deal name
- Value
- Current stage
- Current forecast category
- Recommended forecast category
- Confidence level
- Key evidence
- Main risk
- Required next action

3. Slippage Risk Analysis
- Deals likely to slip
- Why they may slip
- How to prevent or confirm slippage

4. Management Action Plan
- Top actions to improve forecast accuracy
- Deals requiring leadership support

5. Forecast Caveats
- Missing data
- Assumptions made
- Confidence limits
				
			

Optional advanced instructions

				
					Add a weighted forecast table using stage probability and qualitative adjustment if enough data is provided.
				
			

Example output

1. Forecast Summary

Inputs used: Forecast period: Q2. Stages: Proposal Sent, Legal, Commit, Closed Won. Historical rates unavailable. Categories: pipeline, best case, commit, closed won. Sales cycle: 60 days; slippage causes include legal delay and CFO access. Goal: identify at-risk commit deals and likely revenue.

Opportunities reviewed: Alpha Retail $40k Proposal 30 Jun; BrightHealth $85k Legal 15 Jun; CoreLogix $60k Commit 20 Jun; DeltaWorks $30k Proposal 10 Jun; EverPeak $50k Legal 28 Jun.

Total pipeline reviewed: $265k. Likely revenue range: $110k-$165k. Commit amount: $60k. Best-case amount: $135k. At-risk amount: $125k. Overall confidence: Medium-low due to no historical rates.

2. Deal-by-Deal Forecast Assessment

  • Alpha Retail | $40k | Proposal | Current: Best Case | Recommended: Pipeline | Confidence: Low. Evidence: proposal sent, champion engaged. Risk: CFO not involved. Action: secure CFO review.
  • BrightHealth | $85k | Legal | Current: Commit | Recommended: Best Case | Confidence: Medium. Evidence: commercial terms agreed, legal active. Risk: security redlines unresolved. Action: legal/security escalation.
  • CoreLogix | $60k | Commit | Current: Commit | Recommended: Commit | Confidence: Medium-high. Evidence: CFO approved, procurement complete, signature scheduled. Risk: signature timing only. Action: confirm signer availability.
  • DeltaWorks | $30k | Proposal | Current: Pipeline | Recommended: Pipeline | Confidence: Low. Evidence: demo positive but no next step. Risk: weak urgency. Action: requalify timeline.
  • EverPeak | $50k | Legal | Current: Best Case | Recommended: Best Case | Confidence: Medium. Evidence: legal assigned, buyer responsive. Risk: procurement intake not started. Action: confirm procurement timeline.

3. Slippage Risk Analysis

  • BrightHealth: likely to slip if security redlines are not resolved this week.
  • EverPeak: may slip because procurement has not started despite legal stage.
  • Alpha Retail: over-forecasted because economic buyer is missing.

4. Management Action Plan

  • Leadership should help secure BrightHealth security/legal escalation.
  • Manager should inspect Alpha Retail CFO access before allowing best-case status.
  • AE should confirm CoreLogix signer and signature date.

5. Forecast Caveats

Historical close rates were unavailable, so probability is qualitative. Assumptions are based on stage evidence, stakeholder access, and next-step clarity. Confidence limits: medium-low overall.

When to reuse this workflow

You may also like...

🔒

Unlock the Full Workflow

Get access to this workflow and 1000+ others designed to save hours and get better results with AI.

No guesswork. Just proven systems.

  • Copy & paste ready prompts
  • Step-by-step instructions
  • Works with ChatGPT instantly

BANT-Based Discovery Call Qualification Script

Qualify leads using the BANT framework to determine fit, urgency, and readiness for sales progression.

Proof Points and Case Study Insertion

Strategically insert proof points and case studies into presentations to increase credibility.

Demo Customisation Framework

Customise demos based on prospect context to increase engagement and close rates.

Unlock the full library.

Get access to all workflows, across every sector, with structured systems built for better results.

Get Free Access