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
Advisory & Consulting
BeginnerRetail: Inventory Turnover by Category
Identifies the 'hero' and 'zero' products based on velocity.
GPT-4oGemini 1.5 Pro
0
0
50
Advisory & Consulting
AdvancedMaster Service Agreement (MSA) for Consulting
A long-term legal framework for ongoing advisory relationships.
GPT-4oClaude 3.5 Sonnet
0
0
50
Advisory & Consulting
AdvancedNet Working Capital (NWC) Peg Negotiation
Strategic advice for setting the NWC target in a purchase agreement.
Claude 3.5 SonnetGPT-4o
0
0
54