Build a bottom-up revenue forecast
Use to forecast revenue from the actual pipeline and funnel rather than a wishful target.
You build defensible bottom-up revenue forecasts.
Business model and motion: {{model}}
Funnel or pipeline data (volumes, conversion rates, deal size): {{funnel}}
Sales cycle length and seasonality: {{timing}}
Existing customer base and churn: {{base}}
Task: 1) Forecast new revenue by walking the funnel: inputs times conversion times deal size, by month or quarter. 2) Add or subtract expansion and churn from the existing base. 3) Produce a most-likely forecast plus a conservative and a stretch case, stating what changes between them. 4) Identify the single assumption the forecast is most sensitive to. 5) List the leading indicators to watch monthly to know if we are tracking ahead or behind.
Format: a funnel-driven build, the three cases, then the sensitivity and indicators. Show the math and label assumptions; do not back-solve to a target.Click the copy button in the top right of the block to grab the full prompt.
Replace each placeholder below with your own values before you run the prompt.
- {{model}}
- {{funnel}}
- {{timing}}
- {{base}}
Related prompts
You are a seasoned strategy advisor who has helped {{stage}} companies pick what to do and what to ignore. Company context: - What we do: {{what_we_do}} - Target customer: {{custom...
Act as an OKR coach. Help me write OKRs for the {{team}} team for {{quarter}}. Inputs: - Company priority this quarter: {{company_priority}} - What this team owns: {{team_scope}} -...
You are a pitch coach who has reviewed hundreds of decks for {{stage}} rounds. My startup: - Product: {{product}} - Problem we solve: {{problem}} - Traction so far: {{traction}} -...
Help me plan a {{duration}} meeting titled "{{meeting_title}}". Context: - Purpose / decision to be made: {{purpose}} - Attendees and their roles: {{attendees}} - Pre-reads availab...
You are an executive assistant who writes crisp recaps. Below are raw notes from a meeting. Raw notes: """ {{raw_notes}} """ Produce a structured recap: 1. TL;DR in 2 sentences. 2....
Conduct a SWOT analysis for {{subject}}. Context: - What it is: {{description}} - Market and main competitors: {{market}} - Stage and resources: {{resources}} For each quadrant giv...
0 Comments
Loading discussion...