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