Verified:GitHub

comps-analysis

Name: comps-analysis
Availability: InStock
Author: zangjeicy

Builds Excel comparable analysis models integrating operating metrics and valuation multiples with automated statistics and audit trails.

Updated Jul 13, 2026

Search Tags:#benchmarking #finance #excel #modeling #valuation #investment-banking

Ready to run

npx skills add https://github.com/zangjeicy/Hermes --skill comps-analysis-zangjeicy

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/zangjeicy/Hermes/tree/main/optional-skills/finance/comps-analysis
Command: npx skills add https://github.com/zangjeicy/Hermes --skill comps-analysis-zangjeicy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This skill solves the challenge of manually aggregating and formatting financial data for peer benchmarking, ensuring consistency, auditability, and professional presentation in valuation models.

Core Features & Use Cases

Automated Benchmarking: Generates structured Excel models comparing operating metrics and valuation multiples across peer sets.
Institutional Rigor: Enforces formula-based calculations, clear audit trails, and statistical depth (quartiles/medians) rather than hardcoded values.
Use Case: Use this for IPO pricing, M&A target evaluation, or sector-wide performance reviews where accuracy and professional formatting are required for investment committees.

Quick Start

Use the comps-analysis skill to build a valuation model for the cloud software sector using the latest data from the S&P Kensho MCP.

Frequently Asked Questions about comps-analysis

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

FAQPage Schema

How do I build a comparable company analysis model in Excel with automated benchmarking?▼

To build a comparable company analysis model in Excel, you need to aggregate peer operating metrics and valuation multiples into structured spreadsheets with automated statistical calculations like quartiles and medians for accurate benchmarking.

What is the best way to ensure auditability and formula transparency in valuation modeling?▼

Ensuring auditability in valuation modeling requires using formula-based calculations instead of hardcoded values, maintaining rigorous data source tracking, and applying professional formatting to satisfy investment committee requirements.

Does openpyxl support generating structured Excel models for IPO pricing and M&A evaluation?▼

Yes, openpyxl supports generating structured Excel models for IPO pricing and M&A evaluation by facilitating automated statistical calculations, peer benchmarking, and professional formatting required for sector analysis.

How do I calculate statistical quartiles and medians for peer sets in financial modeling?▼

Calculating statistical quartiles and medians for peer sets in financial modeling involves automating statistical depth across operating metrics and valuation multiples within structured Excel spreadsheets rather than using hardcoded values.

Can I use this comparable company analysis approach for sector-wide performance reviews?▼

Yes, you can use comparable company analysis for sector-wide performance reviews because it facilitates peer benchmarking and sector analysis through automated statistical calculations and structured data source tracking.