Advanced

DCF valuation model blueprint with assumptions checklist

Outlines a DCF model structure, key assumptions, and validation checks. Useful for valuation analysts producing defensible valuations for boards, investors, or disputes.

Create a DCF valuation model blueprint for {subject_company}.

Inputs:
- Industry and business description: {business_description}
- Historical financials: {historical_financials}
- Forecast assumptions: {forecast_assumptions}
- WACC inputs (risk-free, beta, ERP, size premium): {wacc_inputs}
- Terminal value approach: {terminal_value_method}
- Non-operating assets/liabilities: {non_operating_items}

Deliver:
1) Model structure (tabs/sections) and required inputs.
2) Step-by-step calculation plan (FCFF, discounting, terminal value).
3) Assumptions checklist and documentation expectations.
4) Sanity checks (implied multiples, margin trends, sensitivity).
5) Output summary template (EV, equity value, per share if applicable).

Do not invent market inputs; request missing data explicitly.

Related Prompts