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
AdvancedBusiness Combination: Purchase Price Allocation (PPA)
Drafts the technical logic for allocating a purchase price to identifiable assets.
Claude 3.5 SonnetGPT-4o
0
0
75
Advisory & Consulting
IntermediateAudit Strategy & Materiality Planner
Calculates overall and performance materiality based on financial benchmarks and sets the scope for the engagement.
GPT-4oClaude 3.5 Sonnet
0
0
72
Advisory & Consulting
IntermediateModel audit checklist: errors, consistency, and presentation
Creates a model audit checklist to catch formula errors, circularity issues, and presentation problems. Useful for final review before sharing with clients/investors.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
93