Forecast quarterly consulting revenue with conversion rates

Calculate stage-weighted quarterly revenue forecasts to protect against cash flow surprises. Use this before setting next quarter's financial targets.

You getPipeline Forecast Table, quarter Forecast Totals and pipeline Gap Analysis

Prompt

Prompt
Act as a freelance financial operations advisor. Calculate a realistic stage-weighted revenue forecast for the upcoming quarter using the deal list and conversion rates pasted below.

- Multiply each deal's contract value by its stage probability percentage to establish weighted revenue.
- Group deals into Best Case (100% value), Weighted Forecast (probability-adjusted), and Committed Floor (closed or 80%+ probability only).
- Highlight the projected shortfall against the stated quarterly revenue target.
- Note that this is financial planning analysis, not formal accounting advice.

Output format:
1. Pipeline Forecast Table (columns: Deal Name, Raw Value, Stage, Probability %, Weighted Value)
2. Quarter Forecast Totals (Committed Floor, Weighted Forecast, Unweighted Best Case)
3. Pipeline Gap Analysis (shortfall relative to target, raw pipeline multiplier needed)
4. Immediate Revenue Risk Actions

Here are my quarterly target and pipeline deals:

Example output

Example for: $60,000 quarterly target with four deals at various stages

  1. Pipeline Forecast Table
Deal NameRaw ValueStageProbability %Weighted Value
Alpha Retail Audit$20,000Contract Out85%$17,000
Beacon Strategy Retainer$30,000Proposal Sent50%$15,000
Cobalt Discovery$12,000Scoping Call25%$3,000
Delta Tech Advisory$15,000Lead Qualified10%$1,500
  1. Quarter Forecast Totals
  • Committed Floor (80%+ deals): $17,000
  • Weighted Forecast: $36,500
  • Unweighted Best Case: $77,000
  1. Pipeline Gap Analysis
  • Stated Target: $60,000
  • Projected Shortfall (against Weighted Forecast): $23,500
  • Pipeline Multiplier: At a 40% aggregate conversion rate, you need $58,750 in fresh raw pipeline to safely close this $23,500 shortfall.
  1. Immediate Revenue Risk Actions
  • Push Alpha Retail to signature by Friday to lock in the committed floor.
  • Schedule a proposal review walkthrough with Beacon Strategy rather than waiting for an offline email reply.
  • Source at least 4 qualified discovery calls over the next 10 days to backfill early-stage pipeline.
Written by AI from this prompt. Your results will vary.

Paste your quarterly target revenue, list of current deals, their raw values, and stages into ChatGPT, Claude, or Gemini. As a follow-up, ask the model how many discovery calls you must book this month to fill the identified gap.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Freelancing & Consulting
Freelancing & Consulting

Turn messy notes into a discovery call brief

Convert unorganized research, emails, or scratchpad thoughts into a one-page prep brief before your discovery call. Ideal for independent consultants preparing on short notice.

Freelancing & Consulting

Audit consulting pipeline for stalled deals

Spot fake pipeline confidence, identify stagnant proposals, and categorize deals into revive or purge lists. Use this during your quarterly business review.