PromptSharpPrompt LibraryFinance › DCF assumption interrogation + sensitivity map

Financial Analysis & ModelingFREE

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.

How to use this prompt

  1. Copy the full prompt above with the Copy button.
  2. Fill in your inputs. Replace each bracketed placeholder with your specifics: [COMPANY]
  3. Paste into ChatGPT, Claude, or Gemini and run. Read the reality guardrail below before you act on the output.

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.

Get a prompt like this every day

The PromptSharp Finance ships one desk-ready prompt every weekday — free on the web today. Free forever. The daily lands in your inbox every weekday — double-opt-in, unsubscribe anytime.

Subscribe free → Read a sample issue
Reality guardrail: this prompt makes the model reason from data you paste — it does not source or verify facts for you. Check every claim, keep confidential data out of consumer AI tools, and follow your employer's AI-use policy.

Frequently asked

When should I use this prompt?

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

Why does this prompt work?

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.

Related Finance prompts

Finance

Three-statement driver interrogation + model sanity-check

You have a working model (or a target's historicals) and want a fast, structured challenge of the assumptions before it goes to a …

Finance

WACC build interrogation

Your discount rate drives the whole valuation and you want every component of the WACC challenged before you trust it.…

Finance

Relative-value pair thesis + risk legs

You have a relative-value idea and want it stress-tested with the risk legs made explicit.…

Finance

Earnings-quality & forensic red-flag screen

Before you trust a holding's reported numbers, you want a structured forensic screen for the accounting red flags that matter.…

Finance

Unit-economics & cohort model review

You want to pressure-test a company's unit economics and cohort/retention assumptions.…

Finance

Scenario & sensitivity table design

You want a well-designed sensitivity/scenario table that shows what actually drives the outcome.…

Finance

Credit / debt-capacity & covenant-headroom model review

You need to know whether a business can carry its debt and how much headroom it has before covenants bite.…

All Finance free prompts

The PromptSharp Finance page — five full free prompts plus today's issue.

PromptSharp Daily — free

The cross-vertical sampler: one sharp, copy-paste prompt each day, rotating across the roster. Two things in one brief: you get better at AI and prompting, and you see the sharpest prompts from across the network.

Double-opt-in. Unsubscribe anytime. No spam, ever.

Better together
Make prompts remember you: Brainfile

Even a sharp prompt starts from zero unless your AI knows you. Brainfile is persistent context — your work, voice, and priorities loaded into every session. Brainfile is the memory; PromptSharp is the playbook. Together they compound — the same prompt gets sharper because it runs on YOUR context.

Set up your brainfile →

Want both? The All-Access + Brainfile annual bundle covers the pair.

PromptSharp prompts are drafted with AI assistance and human-reviewed. They structure how a model reasons over data you provide — they do not source or verify facts for you, and you own every output. Nothing here is financial, legal, tax, or investment advice. Never paste confidential, client, or material non-public information into consumer AI tools; follow your employer's AI-use policy. © 2026 PromptSharp.