Fundamentals & Valuation
comparable-company-analyzer
The Comparable Company Analyzer automates public company peer selection, trading multiple computation, and valuation benchmarking to produce reproducible relative valuation outputs.
Overview
The Comparable Company Analyzer automates public company peer selection, trading multiple computation, and valuation benchmarking to produce reproducible relative valuation outputs.
The Comparable Company Analyzer automates public company peer selection, trading multiple computation, and valuation benchmarking to produce reproducible relative valuation outputs. Key features include industry and size screening, geographic and business-model alignment, and growth/margin profile matching to build a relevant peer universe. It calculates enterprise and price multiples (EV/EBITDA, EV/Revenue, P/E, P/B, PEG), adjusts diluted shares and net debt, and normalizes LTM and NTM metrics with calendarization, non-recurring item and stock-compensation adjustments. Built-in outlier detection and IQR analysis support transparent inclusion/exclusion rationale. Outputs include football-field charts, implied valuation bands, enterprise-to-equity bridges, sensitivity analyses, and presentation-ready benchmark reports. Common use cases are equity research, M&A and fairness opinions, sell-side comps, corporate finance benchmarking, and investor decks, offering consistent, auditable, and time-saving valuation workflows.
Skill.md
How this skill works
The Comparable Company Analyzer automates public company peer selection, trading multiple computation, and valuation benchmarking to produce reproducible relative valuation outputs.
Comparable Company Analyzer
Overview
The Comparable Company Analyzer skill provides comprehensive public company trading analysis capabilities. It enables peer universe selection, trading multiple calculation, and valuation benchmarking through systematic comparable analysis.
Capabilities
Peer Universe Selection
- Industry classification screening
- Size parameter filtering
- Geographic focus alignment
- Business model similarity
- Growth profile matching
- Margin profile comparison
Trading Multiple Calculation
- Enterprise value multiples (EV/EBITDA, EV/Revenue)
- Price multiples (P/E, P/B, PEG)
- Industry-specific metrics
- Adjusted metrics calculation
- Diluted share counts
- Net debt calculation
LTM and NTM Metric Normalization
- Last twelve months calculation
- Next twelve months estimates
- Calendarization adjustments
- Non-recurring item adjustment
- Stock compensation normalization
- Pro forma adjustments
Outlier Identification
- Statistical outlier detection
- Interquartile range analysis
- Company-specific explanation
- Inclusion/exclusion rationale
- Sensitivity to outliers
- Documentation requirements
Football Field Chart Generation
- Multiple methodology ranges
- Implied valuation bands
- Median and mean markers
- Current trading position
- Historical trading context
- Presentation formatting
Equity Value Bridge
- Enterprise to equity value
- Debt deduction
- Cash addition
- Minority interest
- Preferred stock
- Other adjustments
Usage
Trading Comparables Analysis
Input: Target company, selection criteria, market data
Process: Build peer universe, calculate multiples, determine range
Output: Comparable company analysis, implied valuation, benchmark report
Relative Valuation
Input: Target metrics, comparable multiples, adjustments
Process: Apply multiples, bridge to equity value
Output: Valuation range, sensitivity analysis, peer positioning
Integration
Used By Processes
- Comparable Company Analysis
- M&A Financial Due Diligence
- Discounted Cash Flow (DCF) Valuation
Tools and Libraries
- Capital IQ API
- FactSet
- Bloomberg Terminal
- Financial databases
Best Practices
- Document peer selection rationale
- Use consistent data sources across peers
- Adjust for non-recurring items consistently
- Consider trading liquidity in weighting
- Update analysis for market movements
- Cross-check against transaction multiples
Best used for
When to use it
The Comparable Company Analyzer automates public company peer selection, trading multiple computation, and valuation benchmarking to produce reproducible relative valuation outputs.
01 · PRE-MEETING
Prepare a decision brief
Turn scattered evidence into a structured case before an investment committee meeting.
02 · TEAM WORKFLOW
Standardize handoffs
Create consistent research outputs across analysts, portfolio managers, and agents.
03 · LIVE UPDATE
Refresh the thesis
Update scenarios after a new catalyst, KPI release, or earnings result.
Community notes
Built to improve with use.
Feedback will appear here as this skill is used and reviewed.
Discover more
Related skills
View allIndustry Primer
Analyze an industry's structure, profit pools, key players, supply chain, and regime drivers. Use when starting research on an industry, mapping market structure, or framing sector-level opportunity…
Bear Case Builder
Stress test consensus with bearish counter-narratives, failure modes, and probability-severity analysis. Use when building downside cases, short theses, or risk scenarios against a bullish narrative.
Business Model Comp Matching
Match a company to the right peer set by business model, revenue mix, margin structure, and economics. Use when standard comp sets are misleading or when the user asks for more precise peer selection.