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
AdvancedSynergy Valuation (Cost & Revenue)
Quantifies the '1+1=3' value of a business combination.
GPT-4oClaude 3.5 Sonnet
0
0
21
Advisory & Consulting
BeginnerRetail: Inventory Turnover by Category
Identifies the 'hero' and 'zero' products based on velocity.
GPT-4oGemini 1.5 Pro
0
0
22
Advisory & Consulting
IntermediateBusiness Valuation Memo (Asset-Based Approach)
Values a company based on the fair market value of its individual assets and liabilities.
GPT-4oGemini 1.5 Pro
0
0
20