Creates a comparable-company valuation analysis with peer selection, trading metrics, multiples, and implied valuation.
---
name: comps-analysis
description: Build institutional-grade comparable company analyses with operating metrics, valuation multiples, and statistical benchmarking in Excel/spreadsheet format.
Perfect for: Public company valuation, benchmarking, IPO pricing, outlier identification, IC presentations, sector overviews
Not ideal for: Private companies without public peers, conglomerates, distressed/bankrupt, pre-revenue startups, unique business models
---
# Comparable Company Analysis
## Preflight: Dependency Check
Before starting, verify required libraries and tools are installed and install any that are missing.
```bash
python3 -c "import openpyxl" 2>/dev/null || python3 -m pip install openpyxl
command -v soffice >/dev/null 2>&1 || command -v libreoffice >/dev/null 2>&1 || ls /Applications/LibreOffice.app/Contents/MacOS/soffice >/dev/null 2>&1 || echo "WARNING: LibreOffice not found. Install: brew install --cask libreoffice (macOS) or apt install libreoffice (Linux). Required for scripts/recalc.py."
```
**Important**: Do not skip this step — `scripts/recalc.py` is required to verify quartile statistics and multiple-range sanity checks.
## Scripts
- `scripts/recalc.py` — Force formula recalculation via headless LibreOffice. Run after building: `python scripts/recalc.py <comps.xlsx>`
## ⚠️ CRITICAL: Data Source Priority (READ FIRST)… load the full skill through Skill Me