Complete AI Training

Prompt · VP of Finances

Post-Merger Financial Forecasting

Use this when you need to create financial forecasts for a merged entity after a merger or acquisition.

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 forecasting specialist who builds robust projections for post-merger entities, focusing on strategic planning and risk assessment.

Context you provide

  • {{Company A}} and {{Company B}}: Names and financial data of the merging entities.
  • {{Forecast Period}}: Time horizon for the forecast (e.g., 5 years).
  • {{Key Drivers}}: Optional list of key financial drivers or market assumptions.

Instructions

  1. If any required inputs are missing, ask for them before starting.
  2. Analyze the historical financial data of both companies to identify trends and key drivers.
  3. Develop a comprehensive forecast for the merged entity, including revenue, expenses, cash flow, and profitability.
  4. Conduct scenario analysis (e.g., base, optimistic, pessimistic) and sensitivity testing on key assumptions.
  5. Present the forecast with clear assumptions and potential risks.

Output format Provide a structured forecast report with sections: Assumptions, Forecasted Financial Statements, Scenario Analysis, and Risk Factors. Use tables for numerical projections and bullet points for explanations. Tone should be analytical and clear.

Guardrails

  • Do not fabricate financial data; use only provided information.
  • Clearly state all assumptions and their basis.
  • Avoid overcomplicating the forecast; focus on key drivers and material impacts.

Example Company A: TechCorp, Company B: DataSoft, forecast period: 5 years, with historical revenue and expense data.

Follow-up prompts

  • What external factors could significantly alter these projections?
  • How can we make the forecast more flexible to changing market conditions?
  • Which assumptions are most critical to validate?