DCF Model Validator and Sensitivity Analyzer
Validate DCF models and stress-test assumptions before stakeholder presentations
What You Can Do
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.
Features
identifies circular references, broken links, and calculation errors in your DCF model
validates revenue growth, margins, WACC, terminal growth, and capex assumptions against industry benchmarks and historical performance
stress-tests key assumptions (WACC, terminal growth, revenue growth, margins) to identify value drivers and ranges
validates bull, base, and bear case scenarios and ensures they align with realistic business outcomes
compares your model assumptions to similar companies and flags outliers requiring justification
ensures all assumptions are documented, sourced, and defensible for stakeholder presentations
reconciles DCF outputs with comparable companies and precedent transaction multiples to identify gaps
Example Output
DCF Model Review Summary
✓ Formula Check: No circular references detected. WACC calculation verified (cost of equity: 10.2%, after-tax cost of debt: 3.8%, 70/30 capital structure).
⚠ Assumption Alert: Terminal growth rate of 3.2% is above long-term GDP growth. Consider reducing to 2.5%–3.0%. Current revenue CAGR (2024–2029) of 8.5% exceeds peer median of 6.2%—document justification.
Sensitivity Analysis Results:
- WACC ±100bps: $85M–$115M valuation range (±18%)
- Terminal growth ±0.5%: $78M–$122M valuation range (±28%)
- Revenue growth CAGR ±2%: $92M–$108M valuation range (±8%)
Key Finding: Terminal growth and WACC are your highest-impact assumptions. Recommend scenario analysis on competitive market share assumptions.
What's Included
- SKILL.md instruction file: Complete DCF validation framework and assumption testing methodology
- DCF Validation Checklist: Step-by-step structural and formula review checklist
- Sensitivity Analysis Template: Pre-built sensitivity table setup for WACC, terminal growth, revenue, and margin assumptions
- Assumption Benchmark Reference: Industry peer multiples and historical data points for comparable companies comparison
- Scenario Analysis Framework: Bull/base/bear case templates with sensitivity outputs for each scenario
Who It's For
- Valuation consultants and investment bankers preparing fairness opinions and purchase price allocations
- Corporate development and M&A professionals reviewing acquisition models before board presentation
- Private equity analysts stress-testing portfolio company valuations and investment returns
- Equity research analysts validating DCF models underlying price targets and investment theses
- CFOs and controllers reviewing internal valuation models for impairment testing or financial reporting
Best For
- Systematic quality assurance of draft DCF models before client or stakeholder presentations
- Comprehensive sensitivity and scenario analysis to identify key value drivers and assumption dependencies
- Assumption validation and benchmarking against industry peers and historical performance
- Error detection and structural integrity review of complex multi-year financial models
- Documentation and defensibility of valuation conclusions in high-stakes M&A or fairness opinion engagements
You might also like
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.
by bigshol
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
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
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
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