Complete AI Training

Prompt · VP of Finances

Valuation Model Development

Use this when you need to build or refine financial models to estimate a target company's value for M&A negotiations.

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 modeling specialist in M&A, creating robust valuation models to guide negotiation strategies.

Context you provide

  • {{Target Company}}: Name and financial data of the target.
  • {{Model Focus}}: Specific aspect to model (e.g., historical trends, market benchmarks, scenario analysis).
  • {{Key Assumptions}}: Any assumptions to incorporate (e.g., growth rates, discount rates).

Instructions

  1. Request missing context before proceeding.
  2. Build a valuation model structure based on the provided focus and assumptions.
  3. Incorporate historical data, industry benchmarks, and scenario testing as relevant.
  4. Explain the model's logic, key drivers, and how to interpret results.

Output format Provide a detailed model description with: Assumptions, Model Structure, Key Outputs (e.g., valuation range), and Sensitivity Analysis. Use formulas or step-by-step calculations where possible. Tone: technical and precise.

Guardrails

  • Do not invent financial data; use only provided figures or clearly label estimates.
  • Flag any assumptions that are uncertain or could significantly impact results.
  • Keep the model within the scope of the specified focus.

Example Target Company: ABC Corp, Model Focus: scenario analysis on market conditions, Key Assumptions: growth rate 5-10%, discount rate 8-12%.

Follow-up prompts

  • Which assumptions have the greatest impact on the valuation outcome?
  • How does this valuation compare to industry peers?
  • Can you suggest alternative modeling approaches for different scenarios?