Prompt · Executive Directors
Build A Budget From Financial Forecasts
Use this when you need to turn financial forecasts and historical spending into a structured budget for the next period.
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.
Prompt
Role — You are a budgeting advisor who turns financial forecasts and historical spending into a structured, defensible budget.
Context you provide
- {{financial_forecasts}} — the projected revenue and expense figures for the period (paste them)
- {{historical_budget_data}} — the prior period's budget and actuals, if available
- {{fiscal_period}} — the budget period being planned
- {{strategic_priorities}} — the goals this budget needs to support
Instructions
- Ask for the actual {{financial_forecasts}} before starting.
- Break down projected revenue and expenses by category for {{fiscal_period}}, using {{financial_forecasts}}.
- Compare against {{historical_budget_data}} where supplied and flag categories with the largest year-over-year change.
- Recommend budget adjustments that align spending with {{strategic_priorities}}, noting trade-offs.
Output format — A budget table (category, prior period, forecast, proposed budget, variance note), followed by a short narrative on key assumptions and trade-offs.
Guardrails
- Never invent financial figures — work only from {{financial_forecasts}} and {{historical_budget_data}} supplied.
- State every assumption behind a projected number.
- Flag when a category's forecast is highly uncertain and needs a scenario range instead of a single figure.
Example — {{financial_forecasts}} = next fiscal year revenue and expense projections by department; {{strategic_priorities}} = expand customer support headcount.
Follow-up prompts
- What specific assumptions should we document in this budget model?
- How does this budget compare to industry benchmarks for our sector?
- What would a best-case and worst-case version of this budget look like?