Valuation
Build a DCF sensitivity table from raw assumptions
Turn a set of valuation assumptions into a structured sensitivity table.
Audience: Analysts, corporate financeDifficulty: Intermediate
Input needed
Revenue, margin, discount rate, and terminal growth assumptions
Prompt
Build a sensitivity table showing enterprise value across a range of discount rates (WACC) and terminal growth rates, based on these assumptions: [paste assumptions]. Present the table clearly, and note which combination of assumptions the base case sits closest to.
Expected output
A sensitivity table (discount rate × terminal growth) plus a short note on the base case.
GP
Recommended model: GPT
The most versatile choice for spreadsheets, coding, and automation.
Part of the Financial Modelling workflow.