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
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
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'll work with Claude to systematically normalize historical financials, establish explicit forecast drivers tied to business fundamentals, calculate weighted average cost of capital components, and stress-test valuations across bear/base/bull scenarios. Claude identifies hidden assumptions, flags unrealistic projections, and ensures methodological consistency—transforming subjective modeling into auditable, defensible valuations that withstand institutional scrutiny.
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
You conduct comprehensive financial diagnostics that move beyond surface-level metrics to uncover true performance drivers and constraints. The framework systematically layers analysis—identifying what changed, why it changed, what's driving current performance, what benchmarks reveal about competitive position, and which levers will deliver the highest-impact improvements for your specific client. Instead of simply reporting that margins declined, you'll diagnose whether the issue stems from pricing power loss, cost structure misalignment, operational inefficiency, or market conditions, then recommend specific, measurable interventions.
by bigshol
This skill guides you through structured due diligence analysis of acquisition targets by systematically evaluating financial statements, operational metrics, and commercial health. You'll identify material risks across financial, legal, operational, and commercial dimensions, quantify purchase price adjustments (earn-outs, holdbacks, escrow), and develop executive summaries that communicate findings to deal teams and sponsors. Use it to compare multiple targets on a risk-adjusted basis and structure your findings into logical frameworks that support negotiation strategies.
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