Home
cd ../playbooks
Finance & AccountingIntermediate

Comparable Company Analysis Builder

Build institutional-grade comparable company analyses in Excel with operating metrics, valuation multiples, quartile statistics, implied valuation, and professional formatting.

5 minutes
By anthropicSource
#comparable companies#comps analysis#valuation multiples#equity valuation#investment banking

Building a proper comps analysis means gathering consistent data across 8-15 companies, calculating dozens of multiples, handling outliers, and bridging from enterprise value to implied share price — one inconsistent data point or wrong denominator can throw off the entire valuation range.

Who it's for: investment banking analysts, equity research associates, corporate development teams, private equity analysts, valuation professionals

Example

"Build a comps analysis for Salesforce with 10 SaaS peers" → Excel workbook with market data, operating metrics, growth and margin analysis, EV/Revenue, EV/EBITDA, P/E multiples (LTM and NTM), statistics (mean, median, quartiles), and implied valuation range with football field chart

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add fa-comps-analysis
# Comparable Company Analysis Builder

**Important**: This workflow assists with building comparable company analyses but does not constitute financial advice. All analyses should be reviewed by qualified financial professionals before use in valuation decisions.

Build institutional-grade comparable company analyses in Excel with operating metrics, valuation multiples, quartile statistics, and professional formatting.

## Section Structure

A complete comps analysis has the following sections in the output spreadsheet:

| Section | Description |
|---------|-------------|

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Builds institutional-grade comparable company analyses in Excel with a complete workflow: peer group selection, market data gathering, operating metrics, growth and margin analysis, valuation multiples (EV/Revenue, EV/EBITDA, P/E, and more), statistical analysis with quartiles, implied valuation bridging, and a summary football field chart.


Quick Start

Step 1: Create a Project Folder

Create a folder for your comps analysis and place the downloaded template inside as CLAUDE.md.

Step 2: Download the Template

Click Download above, then move the file into your project folder as CLAUDE.md.

Step 3: Start Working

"Build a comps analysis for Snowflake with 10 cloud data peers"
"Create a comparable company analysis for Nike — include athletic wear and footwear companies"
"Comps table for a mid-cap fintech — include implied valuation at median multiples"

Output Sections

Section Description
Header Company names, tickers, share prices, dates
Market Data Diluted shares, market cap, EV bridge
Operating Metrics Revenue, EBITDA, EBIT, Net Income (historical + projected)
Growth & Margins Revenue growth, EBITDA growth, gross/EBITDA/operating margins
Valuation Multiples EV/Revenue, EV/EBITDA, P/E, EV/EBIT (LTM + NTM)
Statistics Mean, Median, 25th/75th percentile, High, Low
Implied Valuation Apply peer multiples to target for EV-to-equity bridge

Industry-Specific Metrics

The template includes guidance for industry-specific multiples: SaaS (EV/ARR, Rule of 40, NRR), Banks (P/TBV, ROE, NIM), REITs (P/FFO, Cap Rate), Retail (EV/Store, Same-Store Sales), Healthcare (EV/Subscriber), and more.

Quality Checklist

  • All share prices as of the same date
  • Diluted share counts use treasury stock method consistently
  • Enterprise value calculation includes all components (Debt, Cash, Preferred, Minority Interest)
  • EBITDA adjustments applied consistently across all comps
  • NM (not meaningful) shown for negative denominators instead of misleading numbers
  • Implied valuation bridges correctly from EV to equity value to per-share

Tips & Best Practices

  • Select 8-15 comparable companies based on industry, business model, size, geography, and growth profile
  • Document inclusion/exclusion rationale for each peer
  • Exclude outliers from statistics (multiples > 2 standard deviations from mean) but keep them in the table with a footnote
  • Use median over mean — it is less sensitive to outliers
  • Calculate multiples for LTM and NTM to show both historical and forward-looking valuations

$Related Playbooks

Finance & Accounting

DCF Model Builder for Equity Valuation

Create institutional-quality discounted cash flow models with WACC calculations, sensitivity analysis, and professional Excel output for equity valuation.

5 minutes
Intermediate
Finance & Accounting

Presentation Deck Number Refresh

Update numbers across an existing presentation deck — quarterly refreshes, earnings updates, comp rolls, and rebased market data — while preserving all formatting.

5 minutes
Beginner
Finance & Accounting

Investment Banking Deck Quality Checker

Comprehensive QC review of pitch decks and client presentations covering number consistency, data-narrative alignment, language polish, and visual formatting.

5 minutes
Beginner
Finance & Accounting

LBO Model Builder for Private Equity

Build leveraged buyout models in Excel with Sources & Uses, operating projections, debt schedules, returns analysis (IRR/MOIC), and sensitivity tables following investment banking standards.

5 minutes
Intermediate
Finance & Accounting

PowerPoint Template Skill Creator

Turn a branded PowerPoint template into a reusable skill that can generate on-brand presentations programmatically, with precise placeholder mapping and layout documentation.

5 minutes
Beginner
Finance & Accounting

Expense Report Generator

Organize business expenses into categorized reports for reimbursement, accounting, and tax preparation.

10 minutes
Intermediate
Finance & Accounting

Expense Tracker & Categorizer

Automate expense tracking, receipt processing, approval workflows, and reimbursement management

10 minutes
Advanced
Finance & Accounting

Personal Finance Manager — AI Budget Tracker from Bank Statements

Import bank statements (CSV or PDF) and get instant spending breakdowns, budget analysis using the 50/30/20 rule, savings recommendations, and interactive charts. All data stays local on your machine.

10 minutes
Beginner
Finance & Accounting

Financial Statement Generator

Generate P&L, balance sheet, and cash flow statements from financial data

10 minutes
Advanced
Finance & Accounting

Grow Sustainably (Without VC)

Evaluate every business decision — spending, hiring, fundraising, scaling — through the lens of profitability and infinite runway. The anti-burnout, anti-blitzscaling operating manual.

5 minutes
Intermediate
Finance & Accounting

Journal Entry Preparer

Prepare journal entries with proper debits, credits, and supporting documentation

10 minutes
Intermediate
Finance & Accounting

Invoice Processing Automation

Automate invoice generation, sending, tracking, and payment reconciliation across accounting platforms

10 minutes
Advanced

Browse all Finance & Accounting playbooks →