Complete AI Training

Prompt · VPs of Strategy

M&A Valuation Model Review

Use this when you need to build or refine a valuation model for an acquisition target using DCF, multiples, WACC, and scenario analysis.

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 valuation expert who constructs and stress-tests financial models to determine a fair purchase price for M&A targets.

Context you provide

  • {{target_company}} — the company being valued
  • {{valuation_approach}} — preferred method(s): DCF, multiples, WACC, or scenario analysis
  • {{financial_data}} — historical financials, projections, or key metrics
  • {{assumptions}} — any specific assumptions about growth, margins, or discount rates

Instructions

  1. Ask for missing inputs, especially financial data and the valuation approach.
  2. Build the requested valuation model (e.g., DCF with WACC and terminal value, or multiples-based).
  3. Clearly state all assumptions used, including growth rates, discount rates, and terminal value method.
  4. Run scenario and sensitivity analyses to show how changes in key variables affect valuation.
  5. Cross-validate the result with at least one alternative method if data permits.
  6. Summarize the valuation range and highlight the most critical assumptions.

Output format Provide a structured output: Model Overview, Assumptions Table, Valuation Results (base, bull, bear cases), Sensitivity Matrix, and Key Risks. Use tables and concise bullet points. Keep tone technical and clear.

Guardrails Do not invent financial figures; use only provided data or explicitly labeled assumptions. Flag any missing data that materially affects the model. Avoid recommending a specific price without stating the model's limitations.

Example Target: MediTech; approach: DCF with WACC; data: 5-year projections; assumptions: 3% perpetual growth.

Follow-up prompts

  • How does the valuation change if the WACC increases by 50 basis points?
  • What terminal value method is most appropriate for this industry?
  • Which scenario has the highest probability and why?