comps-analysis

Build comparable company analysis spreadsheets with valuation multiples and peer statistics in Excel.

Updated Jun 5, 2026
One-click install
npx skills add https://github.com/xu1713/openhorse --skill comps-analysis-xu1713
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/xu1713/openhorse/tree/main/openhorse/openhorse/optional-skills/finance/comps-analysis
Command: npx skills add https://github.com/xu1713/openhorse --skill comps-analysis-xu1713

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve? Building institutional-grade comparable company analyses in Excel is slow and error-prone: analysts must gather peer financials, compute margins and multiples with live formulas, and add statistical benchmarking, all while maintaining audit trails and consistent formatting. ## Core Features & Use Cases - Structured Excel Output: Generates .xlsx comps models via headless openpyxl with operating metrics, valuation multiples, and quartile statistics (Max, 75th, Median, 25th, Min) computed as live formulas, never hardcoded values. - Data Source Discipline: Enforces a source hierarchy (financial-data MCPs first, then SEC EDGAR and filings), requires cell comments citing every hardcoded input, and flags unsourced numbers instead of fabricating them. - Metric Selection Framework: Provides industry-specific guidance (SaaS Rule of 40, bank ROE, retail inventory turns) and a 5-10 metric rule to keep analyses focused. - Use Case: Ask for a comps analysis of Microsoft, Alphabet, and Amazon as of Q4 2024, and receive a formatted Excel workbook with EV/Revenue, EV/EBITDA, P/E multiples, peer quartile statistics, and a documented methodology section. ## Quick Start Build a comparable company analysis in Excel for Microsoft, Alphabet, and Amazon using LTM financials with valuation multiples and peer statistics.

Frequently Asked Questions about comps-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a comparable company analysis in Excel with Python?

Use openpyxl to write formula strings like =E7/C7 into cells rather than computed values, so margins and multiples update when inputs change. Structure the workbook with an operating metrics section, a valuation multiples section, and quartile statistics rows using MEDIAN and QUARTILE functions.

What valuation multiples should a comps analysis include?

Core multiples are EV/Revenue, EV/EBITDA, and P/E, plus Market Cap and Enterprise Value. Add industry-specific metrics only when relevant, such as Rule of 40 for SaaS or ROE for financial services, and keep the total near 5-10 metrics.

Which financial data sources are best for comps analysis?

Structured financial-data MCPs such as S&P Kensho, FactSet, or Daloopa are preferred for verified, auditable figures. If unavailable, use SEC EDGAR filings and company IR pages, and cite every hardcoded input with a cell comment naming the exact source.

Why should comps models use formulas instead of hardcoded values?

Hardcoded margins or multiples become silently wrong when an input changes. Writing Excel formulas that reference input cells keeps the model live, auditable, and automatically recalculating, which is essential for institutional-grade analysis.

When should a company be excluded from a peer comp set?

Exclude companies with different business models, mismatched fiscal periods, or negative EBITDA being valued on EBITDA multiples. Three truly comparable companies produce more reliable statistics than six questionable ones.