Finatune
← Sales & Revenue Operations

Sales Forecast Template

Sales & Revenue Operations

Intermediate25-35 minutes9 inputs
ClaudeChatGPTGemini

Quick Answer

Enter your pipeline by stage and rep with deal values. Paste into Claude or ChatGPT. Get a probability-weighted forecast with coverage ratio analysis and actions to close the gap to target.

What You Get

A bottoms-up sales forecast covering pipeline by stage with probability-weighted value, coverage ratio analysis, rep-level attainment expectations, gap to target, and specific actions to improve forecast attainment.

Who Is This For

Sales leaders building quarterly and annual forecasts, RevOps teams maintaining forecast accuracy, and CFOs validating revenue projections from the sales team.

About This Template

A sales forecast built from pipeline data is more credible than one built from top-down growth assumptions. This template guides sales leaders and RevOps teams through entering their pipeline by stage and rep, then uses AI to produce a bottoms-up forecast with attainment probability, pipeline coverage assessment, and specific actions to close the gap between forecast and target. The output is suitable for sharing with the board and investors as a data-driven revenue commitment.

Fill In Your Details

1
Company NameRequired

Your company name

2
Forecast PeriodRequired

e.g. Q3 2026, FY2027

3
Revenue TargetRequired

e.g. $2,400,000 for Q3

4
Stage 1 Pipeline — Name, Total Value, Deal CountRequired

e.g. Qualified: $4,200,000 across 28 deals (15% close rate)

5
Stage 2 Pipeline — Name, Total Value, Deal CountRequired

e.g. Demo Completed: $2,800,000 across 18 deals (25% close rate)

6
Stage 3 Pipeline — Name, Total Value, Deal CountRequired

e.g. Proposal Sent: $1,600,000 across 12 deals (45% close rate)

7
Stage 4 Pipeline — Name, Total Value, Deal Count

e.g. Verbal Commit: $950,000 across 6 deals (80% close rate)

8
Already Closed Won This PeriodRequired

e.g. $480,000 already closed in Q3 to date

9
Average Sales CycleRequired

e.g. 45 days average from qualified to close

Gather these details then use them to fill in the prompt below.

AI Prompts

1

Generate bottoms-up sales forecast

Paste this prompt into Claude or ChatGPT with your pipeline data filled in.

You are a RevOps analyst building a bottoms-up sales forecast from pipeline data. Using the data below, produce a comprehensive forecast analysis.

Company: [company_name]
Forecast period: [forecast_period]
Revenue target: [revenue_target]
Stage 1 pipeline: [pipeline_stage_1]
Stage 2 pipeline: [pipeline_stage_2]
Stage 3 pipeline: [pipeline_stage_3]
Stage 4 pipeline: [pipeline_stage_4]
Already closed: [closed_won]
Average sales cycle: [avg_sales_cycle]

Produce:
1. Probability-Weighted Forecast — apply stage close rates to calculate expected value from each pipeline stage
2. Total Forecast — already closed plus probability-weighted pipeline
3. Coverage Ratio — total pipeline divided by remaining target (benchmark: 3-4x coverage needed)
4. Forecast vs Target — gap analysis showing how much the forecast is above or below target
5. Pipeline Quality Assessment — are deals in the right stages given the remaining time in the period
6. Attainment Scenarios — best case, base case, and worst case outcomes
7. Actions to Close the Gap — specific actions if forecast is below target

Flag if coverage ratio is below 3x as this indicates high miss risk.

Sample Output

This is an example of what AI produces when you use this template.

Probability-Weighted Forecast

Already closed: $480,000. Stage 4 Verbal Commit ($950,000 at 80%): $760,000. Stage 3 Proposal Sent ($1,600,000 at 45%): $720,000. Stage 2 Demo Completed ($2,800,000 at 25%): $700,000. Stage 1 Qualified ($4,200,000 at 15%): $630,000. Total probability-weighted forecast: $3,290,000. Target: $2,400,000. Forecast versus target: $890,000 above target at weighted value. Base case forecast (Stage 3 and above only): $480,000 plus $760,000 plus $720,000 equals $1,960,000 — $440,000 below target.

Coverage Ratio Assessment

Remaining target: $2,400,000 minus $480,000 closed equals $1,920,000 still to close. Total pipeline: $9,550,000. Coverage ratio: $9,550,000 divided by $1,920,000 equals 4.97x. Coverage is strong at nearly 5x, well above the 3-4x benchmark. However the distribution is concerning: 44 percent of pipeline is in Stage 1 (Qualified) where only 15 percent will close. The critical path is Stage 3 and Stage 4 pipeline of $2,550,000, which at blended 60 percent close rate implies only $1,530,000 in high-confidence revenue. You need to accelerate 3-4 Stage 2 deals to Stage 3 before end of period to hit target with confidence.

Related Resources