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.