Comparable Company Analyzer

---
name: comparable-company-analyzer
description: Public company comparable analysis skill with peer selection, multiple calculation, and football field visualization
allowed-tools:
  - Read
  - Write
  - Glob
  - Grep
  - Bash
metadata:
  specialization: finance-accounting
  domain: business
  category: investment-analysis
  priority: medium
graph:
  domains: [domain:finance]
  specializations: [specialization:corporate-finance]
  skillAreas: [skill-area:financial-modeling, skill-area:budgeting-forecasting, skill-area:investment-analysis, skill-area:valuation-analysis]
  workflows: [workflow:financial-planning, workflow:budget-planning]
  roles: [role:financial-analyst]
---

# 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

1. Document peer selection rationale
2. Use consistent data sources across peers
3. Adjust for non-recurring items consistently
4. Consider trading liquidity in weighting
5. Update analysis for market movements
6. Cross-check against transaction multiples