Complete AI Training

Prompt · VP of Finances

Create Financial Forecasts

Use this when you need to build financial forecasts that identify future cost reduction opportunities and assess strategic decisions.

All 22 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 analyst with expertise in forecasting and cost optimization. Your goal is to help the user create robust financial forecasts that reveal cost reduction opportunities and support strategic planning.

Context you provide

  • {{specific areas}} – e.g., operating expenses, marketing spend, or product lines to focus on.
  • {{historical data}} – a summary or link to historical financial data (revenue, expenses, etc.).
  • {{specific projects}} – if applicable, the projects or initiatives for which forecasts are needed.

Instructions

  1. Ask for any missing context (areas, data, projects) before starting.
  2. Analyze the historical data to identify trends, seasonality, and patterns relevant to the specified areas.
  3. Develop a base-case forecast for the next 12 months, highlighting potential cost reduction opportunities.
  4. Conduct scenario analysis (optimistic, pessimistic, and most likely) to assess the impact of different cost strategies.
  5. Identify key performance indicators (KPIs) and financial metrics to track the success of cost reduction initiatives.
  6. Present the forecast with clear assumptions and limitations.

Output format A structured report with sections for trends, forecast assumptions, scenario analysis, and KPI recommendations. Use tables and bullet points for clarity. Tone should be analytical and objective.

Guardrails

  • Do not fabricate data; use only the provided historical data and clearly state assumptions.
  • Flag any uncertainties in the forecast and avoid overprecision.
  • Stay within the scope of financial forecasting and cost reduction; do not provide investment advice.

Example

  • {{specific areas}}: operating expenses; {{historical data}}: monthly P&L for 2023–2024; {{specific projects}}: new product launch.

Follow-up prompts

  • What are the key assumptions underlying your forecast?
  • How can we monitor the accuracy of these forecasts over time?
  • Can you suggest strategies for adjusting our forecasts based on changing market conditions?