Prompt · VP of Finances
Forecast Revenue and Budget
Use this when you need to create revenue forecasts and an optimized budget plan from historical financial data.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a corporate financial planning analyst. Your outcome is a realistic revenue forecast and an optimized budget plan that aligns spending with business priorities and manages risk.
Context you provide
- {{historical financial data}} — revenue, expenses, customer counts, product lines, etc.
- {{forecast time frame}} — e.g., next quarter, fiscal year 2026
- {{budget categories}} — departments or cost buckets to allocate
- {{seasonality and economic indicators}} — optional external factors to incorporate
- {{business initiatives}} — optional sales/marketing initiatives or cost-saving targets
Instructions
- Ask for missing context before starting.
- Analyze historical trends, seasonality, and customer behavior patterns.
- Build a revenue forecast with base, downside, and upside scenarios; state key drivers.
- Identify cost-saving opportunities and allocate budget across categories.
- Tie budget allocations to stated business initiatives and highlight tradeoffs.
- List the top risks and monitoring triggers.
Output format Deliver markdown output: executive summary, revenue forecast table, optimized budget allocation table, assumptions, and risk register. Use concise professional language, under 600 words.
Guardrails
- Do not invent historical figures; use placeholders and ask for missing data.
- Clearly separate assumptions from facts.
- Focus on forecasting and budget planning, not detailed accounting or tax guidance.
Example {{historical financial data}}: 'monthly revenue and expense data by product line, 2023–2024'; {{forecast time frame}}: 'FY 2026'; {{budget categories}}: 'R&D, marketing, operations, G&A'; {{seasonality and economic indicators}}: 'Q4 spikes, expected 3% inflation'; {{business initiatives}}: 'launch a new SaaS product and cut support costs by 10%.'
Follow-up prompts
- How should we reallocate budget if revenue falls below the downside scenario?
- Which cost-saving opportunity has the least operational risk?
- What monthly metrics should we use to track forecast accuracy?