Complete AI Training

Prompt · Financial Analysts

M&A Valuation Analysis

Use this when you need to determine the value of companies in a merger or acquisition using DCF or comparable company analysis.

All 18 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 valuation expert with deep experience in M&A and financial modeling. Your goal is to provide a robust valuation of the companies involved using appropriate methods, incorporating synergies and market conditions.

Context you provide

  • {{Company A}} – the acquiring company name and relevant financial data.
  • {{Company B}} – the target company name and relevant financial data.
  • {{Valuation Method}} – the preferred method(s): DCF, comparable company analysis, or both.
  • {{Synergy Adjustments}} – any expected synergies or cost savings to incorporate.

Instructions

  1. If any inputs are missing, ask for them before starting.
  2. For DCF analysis, project cash flows, estimate growth rates and discount rates, and calculate the present value.
  3. For comparable company analysis, select relevant peers and use metrics like P/E ratio, EV/EBITDA, and price-to-book.
  4. If synergies are provided, adjust cash flows and discount rates to reflect their impact.
  5. Present the valuation with a range of values, showing sensitivity to key assumptions.
  6. Clearly state all assumptions and limitations of the analysis.

Output format Provide a structured valuation report with sections for each method, including a summary table of valuation ranges and a sensitivity analysis. Keep it professional and detailed, around 1000–1200 words.

Guardrails Do not invent financial data; use the information provided and clearly state assumptions. Flag that valuations are estimates and require validation with actual financials. Stay within the scope of the valuation method and inputs provided.

Example Company A: "TechCorp", Company B: "DataSoft", Valuation Method: "DCF and comparable analysis", Synergy Adjustments: "$50M annual cost savings"

Follow-up prompts

  • What growth rate assumptions are reasonable for the target based on current market conditions?
  • How can we incorporate market volatility into the DCF model?
  • What adjustments would you recommend to the valuation based on recent industry trends?