comps-analysis

Construct comparable company valuation workbooks with Excel formulas and statistical benchmarking.

1|Updated Jul 31, 2026
One-click install
npx skills add https://github.com/icyzh/hermes-web --skill comps-analysis-icyzh
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/icyzh/hermes-web/tree/main/optional-skills/finance/comps-analysis
Command: npx skills add https://github.com/icyzh/hermes-web --skill comps-analysis-icyzh

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill solves the challenge of creating consistent, audit-ready comparable company valuation models by automating the structural setup and statistical benchmarking of financial data.

Core Features & Use Cases

  • Institutional Structure: Generates standardized Excel workbooks with professional formatting, clear headers, and transparent formula-based calculations.
  • Statistical Benchmarking: Automatically calculates medians, quartiles, and ranges for valuation multiples and operating metrics to identify market outliers.
  • Use Case: An investment analyst needs to compare the valuation of three SaaS companies; this skill builds the workbook, pulls the necessary metrics, and highlights the 75th percentile multiples for the pitch deck.

Quick Start

Use the comps-analysis skill to build a valuation workbook for the provided list of technology companies using the latest available market data.

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 valuation models in Excel with statistical benchmarking?

You can build comparable company valuation models by generating standardized Excel workbooks that calculate medians, quartiles, and ranges for operating metrics to identify market outliers and ensure auditability.

Can I automate M&A evaluation workbook creation using openpyxl?

Yes, you can automate M&A evaluation workbook creation using openpyxl to programmatically generate professional Excel spreadsheets with clear headers and transparent formula-based calculations.

Does this approach calculate median and quartile ranges for investment banking pitch decks?

Yes, this approach automatically calculates medians, quartiles, and ranges for valuation multiples and operating metrics, specifically highlighting percentiles needed for investment banking pitch decks.

How do I ensure strict data source hierarchy for audit-ready financial modeling?

You ensure audit-ready financial modeling by generating standardized workbooks with professional formatting, transparent formula-based calculations, and strict adherence to data source hierarchy for compliance.

What is the best way to compare SaaS company valuation multiples?

The best way to compare SaaS company valuation multiples is building standardized workbooks that pull necessary metrics and apply statistical benchmarking to highlight percentile multiples for analysis.

Are there limitations when generating sector-specific financial modeling workbooks?

Sector-specific financial modeling workbooks require openpyxl for programmatic spreadsheet generation and rely on strict data source hierarchy, meaning accurate output depends entirely on input data quality.