/comps — Comparable Company Analysis
Comparable company analysis (often just called “comps”) is the most intuitive valuation method in finance: find companies similar to your target and see what the market is paying for them. If Salesforce trades at 25x EBITDA and your target company has similar growth and margins, then maybe your target should trade at a similar multiple. Comps provide a market-based valuation anchor that complements intrinsic methods like DCF.
This command builds an institutional-grade comps sheet in Excel with operating metrics, valuation multiples, and statistical benchmarking — the standard deliverable that investment banking analysts produce for deal teams, IC presentations, and client pitches.
For a deep dive into comps methodology (peer selection, multiples interpretation, industry-specific metrics), see the Comps Analysis Skill page.
Command Syntax
What It Produces
- Excel file (.xlsx) — The comps analysis with operating statistics, valuation multiples, and statistical summary
- Written summary — Peer group rationale, key insights, and median multiples
Workflow
Clarify the Analysis Purpose
Claude asks key questions because a comps sheet for an IC presentation looks different from one for a quick reference. This step ensures the right level of detail.
Identify Peer Group
Claude selects 4-6 comparable companies based on similar business model, scale, industry, and geography. Good peer selection is the foundation of useful comps.
Gather Data
Using available MCP sources (S&P Global, FactSet, Daloopa preferred), Claude pulls operating metrics and valuation data for each peer.
Build the Analysis
Operating Statistics section with company data and statistical summary (Max, 75th, Median, 25th, Min), plus Valuation Multiples section with the same statistical treatment.
Industry-Specific Metrics
| Industry | Additional Metrics |
|---|---|
| Software/SaaS | ARR, Net Dollar Retention, Rule of 40 |
| Retail | Same-store sales, Inventory Turns |
| Financials | ROE, ROA, Efficiency Ratio |
| Manufacturing | Asset Turnover, CapEx/Revenue |
| Healthcare | R&D/Revenue, Pipeline Value |
How to Customize for Your Firm
skills/comps-analysis/SKILL.md to add firm-specific peer selection rules, preferred metrics, or formatting conventions.
Related
- Comps Analysis Skill — Full Finance 101 explanation, methodology, formula patterns, and best practices
/dcfCommand — Build a DCF that uses comps to inform assumptions