skills.rest
ldzhhxx
ldzhhxxCOMMUNITY
Explore all skills by this author →
GitHub

comps-analysis

Generate Excel comparable company analyses with valuation metrics and benchmarking.

1|1|Updated May 9, 2026
Search Tags:#Excel#openpyxl#valuation#investment banking#comparable company analysis
One-click install
npx skills add https://github.com/ldzhhxx/Hermes_offline_v2 --skill comps-analysis-ldzhhxx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/ldzhhxx/Hermes_offline_v2/tree/main/hermes-agent/optional-skills/finance/comps-analysis
Command: npx skills add https://github.com/ldzhhxx/Hermes_offline_v2 --skill comps-analysis-ldzhhxx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the process of building institutional-grade comparable company analyses, saving time and ensuring accuracy in Excel.

Core Features & Use Cases

  • Comparable Company Analysis: Generates Excel/spreadsheet analyses with operating metrics, valuation multiples, and statistical benchmarking.
  • Data Source Priority: Ensures use of verified, institutional-grade data from sources like S&P Kensho MCP, FactSet MCP, or Daloopa MCP.
  • User Customization: Allows for user preferences and explicit formatting choices to be applied to the analysis template.
  • Use Case: Ideal for public-company valuation, IPO pricing, sector benchmarking, or outlier detection in investment banking.

Quick Start

Use the 'comps-analysis' skill to generate a comparable company analysis for Microsoft, Alphabet, and Amazon using S&P Kensho MCP data.

Frequently Asked Questions about comps-analysis

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

FAQPage Schema
How do I automate comparable company analysis in Excel?▼

You can automate comparable company analysis in Excel by using openpyxl to generate institutional-grade sheets with operating metrics, valuation multiples, and statistical benchmarking. This process eliminates manual spreadsheet formatting and calculation errors.

What is comparable company analysis and when do I need it?▼

Comparable company analysis is a relative valuation method that benchmarks public companies using operating metrics and valuation multiples. You need it for public-company valuation, IPO pricing, sector benchmarking, or outlier detection in investment banking.

Can I use pandas and openpyxl to build a valuation spreadsheet with statistical benchmarking?▼

Yes, this approach uses pandas for data handling and openpyxl to build the Excel valuation spreadsheet. It structures operating metrics, valuation multiples, and statistical benchmarking directly into the formatted workbook.

What data sources do I need for institutional-grade comparable company analysis?▼

Institutional-grade comparable company analysis requires verified data from sources like S&P Kensho MCP, FactSet MCP, or Daloopa MCP. Ensuring data source accuracy is a mandatory step before generating the final Excel benchmarking report.

Does this comparable company analysis tool allow formatting customization?▼

Yes, the comparable company analysis tool allows user preferences and explicit formatting choices to be applied to the Excel template. This ensures the generated operating metrics and valuation multiples meet specific presentation standards.

What is the best way to generate a comps analysis for public-company valuation?▼

The best way to generate a comps analysis for public-company valuation is automating the Excel build with openpyxl. This ensures institutional-grade accuracy when calculating operating metrics, valuation multiples, and statistical benchmarking.

Related Skills

Explore More Finance & Accounting Skills→
hck717hck717

valuation-analysis

Construct valuation models and price targets using DCF, multiples, and scenario analysis.

Community
Advanced
brittaniebuffiecsubrittaniebuffiecsu
1

comps-analysis

Automate comparable company analyses in Excel with openpyxl.

Community
Advanced
RheasilviaRheasilvia

comps-analysis

Generate Excel comparable company valuation workbooks with operating metrics and statistical benchmarks.

Community
Advanced
brainbytes-devbrainbytes-dev
2

precedent-transactions

Compile comparable M&A deals and generate an implied valuation range.

Community
Advanced