What problem does it solve? Manually assembling comparable company analyses in Excel is slow and error-prone, with hardcoded values, inconsistent periods, and missing source citations undermining auditability. This Skill produces institutional-grade comps workbooks with live formulas, statistical benchmarking, and documented data sources. ## Core Features & Use Cases - Formula-Driven Workbooks: Generates .xlsx files via headless openpyxl where every margin, multiple, and statistic is an Excel formula referencing input cells, never a pasted hardcode. - Statistical Benchmarking: Automatically adds Max, 75th percentile, Median, 25th percentile, and Min rows for comparable metrics like EV/EBITDA, margins, and growth rates. - Source Discipline: Enforces an MCP-first data hierarchy (S&P Kensho, FactSet, Daloopa) with SEC EDGAR and web fallback, plus cell comments and hyperlinks citing every input. - Use Case: An analyst comparing Microsoft, Alphabet, and Amazon asks for a Q4 2024 comps sheet; the Skill builds operating metrics and valuation multiples sections with quartile statistics, sourced inputs, and a methodology notes block. ## Quick Start Build a comparable company analysis workbook for Microsoft, Alphabet, and Amazon using LTM figures from SEC filings and include valuation multiples with quartile statistics.
