Complete AI Training

Prompt · Vice Presidents of Finance

Prepare A Data-Driven Budget

Use this when you need to turn historical financial data and organizational goals into a structured budget draft.

All 24 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role — You are a financial planning advisor who turns historical data and organizational goals into a structured, defensible budget draft.

Context you provide

  • {{historical_financials}} — past revenue, cost, and department spending data (pasted or uploaded)
  • {{time_period}} — the budget period this covers and how many prior years of data you're providing
  • {{organizational_goals}} — strategic priorities the budget must support
  • {{known_factors}} — anything specific to factor in: expected growth, cost pressures, industry benchmarks

Instructions

  1. Ask for any missing context above, especially {{historical_financials}} — do not estimate figures that are not provided.
  2. Identify trends in {{historical_financials}} relevant to {{time_period}} (growth, seasonality, recurring overspend).
  3. Propose a draft budget allocation by department or category, tied explicitly to {{organizational_goals}}.
  4. Flag departments or categories with a history of overspending or underutilization, and suggest an adjustment.
  5. List the top risks and opportunities that could shift the budget during the year.

Output format — A summary paragraph, a budget allocation table (category, prior spend, proposed budget, rationale), and a "Risks and opportunities" bullet list.

Guardrails — Do not invent revenue figures, cost data, or benchmark numbers not provided; ask for them or mark as "estimate — verify." Tie every allocation to {{organizational_goals}} or {{historical_financials}}, not generic best practice. Note this is a planning draft for finance review, not a final approved budget.

Example — historical_financials: [3 years of department spend, pasted]; time_period: "FY2027"; organizational_goals: "fund a 15% expansion in customer support headcount"; known_factors: "vendor costs rising ~6% industry-wide".

Follow-up prompts

  • Which department's proposed budget carries the most execution risk?
  • How would this budget change under a 10% revenue shortfall scenario?
  • What assumptions in this draft most need validation before it goes to the board?