DCF Valuation Framework & Model Documentation
Build defensible DCF models with explicit assumptions for M&A and fairness opinions
What You Can Do
You can build enterprise valuation models grounded in operational drivers rather than arbitrary growth assumptions. This skill guides you through documenting explicit assumptions, projecting cash flows tied to historical performance, calculating WACC, determining terminal value, and performing sensitivity and scenario analysis to quantify defensible valuation ranges. Your models will be audit-ready and capable of withstanding client questioning and legal challenge.
Features
tie all inputs to historical metrics and market data with clear audit trails
project revenue, margins, capital expenditure, and working capital from business fundamentals
determine discount rates using cost of equity, cost of debt, and capital structure inputs
apply perpetuity growth or exit multiple methods with sensitivity to long-term assumptions
quantify valuation impact across base case, upside, and downside scenarios
link income statement projections to cash flow statement and balance sheet changes
structure models for engagement letters, valuation reports, and board presentation deliverables
test model robustness to changes in key drivers, discount rates, and terminal assumptions
Example Output
Example 1: Software Company Acquisition Target
- Revenue projection: Historical CAGR 18%; model 15% year 1–3 (conservative), 10% years 4–5 based on market saturation analysis
- EBITDA margin: Improve from 22% to 28% over 5 years via operating leverage; document SG&A efficiency benchmarks
- WACC: 9.2% (cost of equity 11.5% using CAPM, cost of debt 6%, D/E ratio 0.3)
- Terminal value: 4.5% perpetuity growth rate; sensitivity range 3.5–5.5%
- Valuation range: Base case $245M; upside scenario $310M; downside scenario $195M
Example 2: Fairness Opinion Report Extract
- 5-year free cash flow projections: Years 1–5 aggregate to $87M after capex and tax
- Discount rate sensitivity: DCF value ranges $220M–$280M across WACC 8.5%–10.0%
- Terminal value sensitivity: Value $205M–$290M for perpetuity growth 3%–5%
- Conclusion: $250M proposed transaction price falls within reasonable valuation range
Example 3: Earnout Structure Analysis
- Base case DCF: $180M; earnout triggers if EBITDA exceeds $25M in year 3
- Probability-weighted scenarios: 60% base, 30% upside, 10% downside
- Expected earnout payout: $18M–$32M range depending on operational performance
What's Included
- SKILL.md instruction file: step-by-step DCF construction workflow with assumption documentation checklist
- DCF model template: Excel-ready projection framework with formula structures for 5-year forecasts and terminal value
- Assumption documentation template: assumption log linking each input to historical data source and market research
- WACC calculation worksheet: cost of equity (CAPM), cost of debt, and capital structure inputs with sensitivity
- Sensitivity and scenario analysis grid: one-way and two-way sensitivity tables for key drivers and discount rates
- Fairness opinion checklist: deliverable requirements, peer comparison, and litigation-defensibility review items
Who It's For
- Financial advisors and consultants building acquisition valuations for clients
- M&A professionals preparing fairness opinion reports and engagement letters
- Equity research analysts developing intrinsic value estimates for stock recommendations
- Corporate development teams evaluating internal acquisition targets or partnerships
- Transaction advisors structuring earnout and contingent payment provisions
Best For
- Private company valuations for M&A or shareholder disputes
- Fairness opinion engagements supporting board decisions and shareholder votes
- Structuring earnout, contingent payment, and hold-back provisions in transaction agreements
- Expert witness or litigation support valuations requiring defensible assumptions
- Equity research recommendations requiring intrinsic value analysis and valuation ranges
You might also like
You can synthesize complex financial data into multiple restructuring scenarios—standalone workouts, Chapter 11 plans, 363 asset sales, and liquidation analyses—while quantifying creditor recovery outcomes under each path. The skill generates professional disclosure statements, creditor information packages, and court-compliant financial exhibits that demonstrate your restructuring recommendations to judges, creditors, and management stakeholders with institutional rigor.
by bigshol
Claude systematically audits your API endpoints and generates comprehensive OpenAPI specifications, parameter documentation, error handling guides, and authentication flows. You get developer-ready documentation that ensures clarity, completeness, and consistency across all endpoints. The skill evaluates your existing documentation for gaps and suggests improvements to enhance developer experience.
by bigshol
Turn raw customer research data—interviews, surveys, support tickets, feature requests—into organized, prioritized insights that drive product decisions. This skill identifies recurring themes across enterprise feedback, extracts actionable recommendations, and maps findings to your roadmap strategy, helping you make evidence-based product choices.
by bigshol
Create clear, hierarchical metric frameworks that cascade from strategic goals to tactical KPIs. You'll validate metric definitions against best practices, assign ownership, and generate stakeholder communication plans. The result is a shared language for success across your organization.
by bigshol
You can perform end-to-end DCF validation that identifies formula errors, structural inconsistencies, and unrealistic assumptions before they reach clients or boards. The skill stress-tests key value drivers through sensitivity analysis, benchmarks assumptions against peer and historical data, and prioritizes which variables most impact your valuation conclusion—giving you confidence in your outputs for fairness opinions, M&A transactions, and equity research.
by bigshol
This skill converts hundreds of diligence documents, management responses, and preliminary findings into coherent risk assessments that drive transaction decisions. You can normalize findings across financial, tax, legal, operational, and commercial due diligence streams, assess materiality and probability, link findings to transaction value impact, and prioritize risks by severity and remediability—all within a structured framework that supports deal committee presentations and client decision-making.
by bigshol
Systematically extract actionable insights from developer feedback, forums, and discussions to identify unmet needs and emerging opportunities. You'll analyze sentiment and patterns, create targeted advocacy strategies aligned to community pain points, and develop data-backed content roadmaps that accelerate product adoption and strengthen developer relationships.
by bigshol
This skill accelerates financial due diligence by analyzing multi-year financial statements, normalizing EBITDA and key metrics, extracting transaction risks from footnotes and MD&A, benchmarking valuation multiples, and structuring risk-prioritized diligence programs. You can process historical financials, identify earnings quality issues, flag contingent liabilities, analyze carve-out interdependencies, and synthesize findings into executive summaries—preserving your judgment on commercial strategy while handling the analytical groundwork.
by bigshol