Сравнительный анализ компаний в Excel
★ 7.1 · financial-analysis
comps-analysis is a Claude Code skill that builds institutional-grade comparable company analysis workbooks and writes the output as a .xlsx file using headless openpyxl. The skill structures a full comp sheet — header block, operating metrics, valuation multiples, and statistical benchmarking — with every derived figure written as an Excel formula referencing input cells, never a hardcoded value. Data sourcing follows a strict hierarchy: S&P Kensho, FactSet, and Daloopa MCP connections come first; Bloomberg Terminal and SEC EDGAR filings serve as fallbacks; web search is explicitly prohibited for institutional-grade work. Related skills include excel-author, pptx-author, dcf-model, and lbo-model, making it easy to embed comps into broader investment-banking workflows. It suits analysts and investment teams who need an auditable, automatically recalculating peer comparison for M&A evaluation, sector benchmarking, or portfolio review.
- #excel
- #valuation
- #comps-analysis
- #openpyxl
- #financial-modeling
- #benchmarking
- #investment-banking