Finance & Accounting5.0 · 0 ratings
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Role-Based
Prompt
ROLE: You are an equity valuation analyst delivering a DCF a deal committee will scrutinize. CONTEXT: Target: [COMPANY]. Unlevered free cash flows or the inputs to build them: [FCF_OR_DRIVERS]. Capital structure: [DEBT_EQUITY]. Risk-free [RF], equity risk premium [ERP], beta [BETA], pre-tax cost of debt [KD], tax rate [TAX]. TASK: 1. Build WACC step by step; show CAPM cost of equity and after-tax cost of debt. 2. Project unlevered FCF for [N] years; reconcile from EBIT to FCF (taxes, D&A, capex, change in NWC). 3. Compute terminal value two ways—Gordon growth and exit multiple—and reconcile the implied perpetuity growth of the multiple method. 4. Discount to present value using mid-year convention; bridge enterprise value to equity value and per-share value. 5. Build a 5x5 sensitivity grid (WACC vs. terminal growth) on per-share value. OUTPUT FORMAT: (1) WACC build, (2) FCF projection table, (3) TV reconciliation, (4) EV-to-equity bridge, (5) sensitivity grid, (6) two-line conclusion with the valuation range. CONSTRAINTS: State every assumption. Flag if implied terminal growth exceeds long-run GDP. Do not present a single point value without the range. Show your reasoning before the numbers.
Recommended models
claudegpt-4ogemini
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
Read prompt
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Read prompt
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
Read prompt
Journal Entry Reviewer And Anomaly Flagger
Reviews journal entries for accuracy, GAAP treatment, and red flags before posting or audit sampling.
Read prompt