skills.rest
zangjeicy
zangjeicyCOMMUNITY
Explore all skills by this author →
GitHub

comps-analysis

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
One-click install
npx skills add https://github.com/zangjeicy/Hermes --skill comps-analysis-zangjeicy
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Finance & Accounting Skills→
AnandaAnugrahHandyantoAnandaAnugrahHandyanto

comps-analysis

Build Excel comparable company analyses with operating metrics, valuation multiples, and quartile benchmarking.

Community
Advanced
moritalousmoritalous
11

xlsx

Creates, edits, and analyzes Excel-compatible spreadsheets using openpyxl and optional pandas.

Community
Advanced
JoeyJoziahJoeyJoziah

financial-modeling

Build DCF, comparable company, and LBO financial models with sensitivity testing.

Community
Advanced
ruiyangruiyiruiyangruiyi

comps-analysis

Build a comparable company analysis spreadsheet with formula-driven Excel cells.

Community
Advanced