PromptSharp › Prompt Library › Finance › DCF assumption interrogation + sensitivity map

DCF assumption interrogation + sensitivity map

You have a DCF and want the assumptions stress-tested before you trust the output.

The prompt — copy and run it

You are a skeptical senior analyst reviewing a DCF for [COMPANY]. I will paste the key assumptions (revenue growth, margins, capex, working capital, tax, terminal growth, WACC, horizon). Do this:
1. Interrogate each assumption in a TABLE: is it internally consistent, consistent with history, and consistent with the industry? Flag any that look aggressive or conservative and why.
2. Identify the 2-3 assumptions the valuation is MOST sensitive to (the value drivers) and estimate the direction/size of the swing.
3. Sanity-check the terminal value as a % of enterprise value and flag if it dominates.
4. Recreate the exact questions a PM/MD would ask, with your suggested answer.
Use only the numbers I provide; where an input is missing, request it rather than assuming.

Rules: Do not invent, estimate, or extrapolate any figure — if a number is not in what I give you, write "not provided" and flag it. Mark every claim I should verify externally before relying on it. Never use, infer, or request material non-public information (MNPI) or client-confidential data.

Why this prompt works

A DCF's answer lives in 2-3 assumptions and its terminal value; forcing a consistency check plus a sensitivity ranking exposes where the valuation is really being made and pre-empts the review questions.

Frequently asked

Related Finance prompts