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
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
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.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Qualify inbound consulting leads before scheduling a discovery call
Review vague prospective client inquiries and draft a polite qualifying response that checks budget, scope, and timeline before you share your calendar link.
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.
Follow up on a ghosted freelance proposal politely
Check in on silent prospects without sounding desperate, passive-aggressive, or pushy. Perfect for following up one to two weeks after sending a proposal.
Address retainer scope creep before sending renewal terms
Identify unbilled tasks from your past term and write a polite correction email. Use this before renewal to reset boundaries without alienating clients.
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.
Evaluate legacy client accounts for rate hikes or exits
Audit underpriced legacy clients to decide whether to raise rates, trim scope, or offboard them cleanly. Use it during annual reviews or when client capacity maxes out.
- Plan ninety-day outreach targets for pipeline gaps
- Quarterly pipeline review checklist and agenda
- Restructure a shrinking retainer without losing margin
- Summarize retainer outcomes delivered ahead of renewal talks
- Turn client interview notes into a case study
- Uncover client budget and timeline constraints