comps-analysis

Set up a header block with title, tickers, and units, then input raw financial data (revenue, EBITDA, market cap) as hardcoded values with source comments. Build all ratios and multiples as formulas referencing those inputs, and add Max, 75th percentile, Median, 25th percentile, and Min statistics rows.

Core multiples are EV/Revenue, EV/EBITDA, and P/E, plus Market Cap and Enterprise Value. Add 2-3 industry-specific metrics such as Rule of 40 for SaaS or ROE for financial services, keeping the total around 5-10 metrics to avoid noise.

Every derived value such as margins, multiples, and statistics must be an Excel formula referencing input cells, never a pre-computed number. Only raw input data like revenue and share price should be hardcoded, and each input needs a cell comment citing its source or explaining the assumption.

Institutional MCP sources like S&P Kensho, FactSet, and Daloopa are preferred for verified financial data with audit trails. If unavailable, use Bloomberg Terminal or SEC EDGAR filings; web search should never be the primary source for institutional-grade analysis.

Comps analysis is not suitable for private companies without public peers, highly diversified conglomerates, distressed or bankrupt companies, pre-revenue startups, or businesses with unique models lacking true comparables. Better to use three perfect comps than six questionable ones.

Errors typically come from negative EBITDA companies in EBITDA multiples, missing data, or incorrect statistic ranges that include blank separation rows. Use IFERROR wrappers, switch to revenue multiples for negative-earnings companies, and verify ranges cover only company data rows.