comps-analysis

Aggregate peer metrics into auditable Excel workbooks with provenance-documented data.

31|3|Updated May 7, 2026
One-click install
npx skills add https://github.com/markwang2658/hermes-windows-native --skill comps-analysis-markwang2658
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/markwang2658/hermes-windows-native/tree/main/hermes-agent/optional-skills/finance/comps-analysis
Command: npx skills add https://github.com/markwang2658/hermes-windows-native --skill comps-analysis-markwang2658

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

Build auditable comparable company analyses by aggregating operating metrics and valuation multiples into a single Excel workbook, with transparent data provenance.

Core Features & Use Cases

  • Institutional-grade comps with clear data lineage, quartile analysis, and cross-referenced sources.
  • Use cases include public-company valuation, sector benchmarking, IPO pricing, and outlier detection.

Quick Start

Load the comps-analysis template and begin entering the peer data in the defined structure.

Frequently Asked Questions about comps-analysis

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

FAQPage Schema
How do I build comparable company analysis in Excel with auditable formulas?▼

You can build comparable company analysis in Excel by aggregating peer metrics and valuation multiples into a single workbook with transparent data provenance. The process requires headless openpyxl tooling to generate auditable formulas referencing your source inputs.

What is comparable company analysis and when do I need LTM and YoY inputs?▼

Comparable company analysis is an institutional-grade valuation method aggregating peer operating metrics and multiples. You need LTM and YoY inputs for sector benchmarking, IPO pricing, and outlier detection across a defined peer set.

Can I use openpyxl to automate sector benchmarking and quartile analysis?▼

Yes, openpyxl can automate sector benchmarking by producing auditable Excel workbooks with quartile analysis and cross-referenced sources. This headless approach ensures clear data lineage for your defined peer group.

Does comps-analysis work for IPO pricing and public-company valuation?▼

Comps-analysis is designed for IPO pricing and public-company valuation. It requires provenance-documented data with formulas referencing inputs to ensure institutional-grade outputs for your defined peer set.

How do I structure peer data for comparable company analysis modeling?▼

To structure peer data for comparable company analysis modeling, load the template and enter peer data in the defined structure. Ensure your LTM and YoY inputs are provenance-documented for accurate quartile analysis and outlier detection.

What are the limitations of using openpyxl for institutional-grade comps?▼

Using openpyxl for institutional-grade comps requires a clearly defined peer group and provenance-documented data. Without headless openpyxl tooling and structured LTM inputs, generating auditable Excel workbooks with cross-referenced sources may be constrained.