skills.rest
sheawinkler
sheawinklerCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

comps-analysis

Build Excel peer benchmarking analyses with operating metrics and valuation multiples.

78|16|Updated Apr 23, 2026
Search Tags:#excel#valuation#financial-modeling#multiples#comps-analysis#peer-analysis
One-click install
npx skills add https://github.com/sheawinkler/hermes-agent-ultra --skill comps-analysis-sheawinkler
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/sheawinkler/hermes-agent-ultra/tree/main/optional-skills/finance/comps-analysis
Command: npx skills add https://github.com/sheawinkler/hermes-agent-ultra --skill comps-analysis-sheawinkler

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Build institutional-grade comparable-company analyses in Excel that unify operating metrics, valuation multiples, and benchmarking across peer sets. Pairs with excel-author. Use for public-company valuation, IPO pricing, sector benchmarking, or outlier detection.

Core Features & Use Cases

  • Structured template for comps analysis with transparent, formula-driven calculations.
  • Data-source framework prioritizing MCP sources when available; cross-checks against benchmark filings.
  • Output includes operating metrics, valuation multiples, and quartile/statistical context to support decision-making.
  • Use Case: quickly benchmark peers for an IPO pricing memo by generating EV/Revenue and EV/EBITDA multiples with cross-company comparisons.

Quick Start

Open the comps-analysis workbook, input the raw peer data into the designated input cells, and review the automatically calculated metrics and derived statistics.

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 in Excel for IPO pricing?▼

Yes, comparable company analysis includes quartile and statistical context outputs to support outlier detection across peer sets. This benchmarking highlights extreme valuation multiples and operating metric deviations within your sector data.

Do I need MCP data sources for peer benchmarking in Excel?▼

This comparable company analysis uses a structured template with transparent, formula-driven calculations. It unifies operating metrics and valuation multiples across peer sets, prioritizing MCP data sources and cross-checking inputs against benchmark filings.

What's the best way to calculate EV/EBITDA multiples for peer sets?▼

Yes, this peer benchmarking workflow pairs with excel-author and requires a robust data-source framework. You need raw peer operating data and valuation inputs formatted for designated cells to generate unified operating metrics and valuation multiples.

When should I not use Excel for sector benchmarking and valuation multiples?▼

This comparable company analysis uses a structured template with transparent, formula-driven calculations. It unifies operating metrics and valuation multiples across peer sets, prioritizing MCP data sources and cross-checking inputs against benchmark filings.

Related Skills

Explore More Finance & Accounting Skills→
ruiyangruiyiruiyangruiyi

comps-analysis

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

Community
Advanced
nadicodeainadicodeai

comps-analysis

Automate comparable company analysis in Excel with dynamic ratios and multiples.

Official
Advanced
SethyPagnaSethyPagna

comps-analysis

Build comparable company analysis workbooks with valuation multiples and peer statistics in Excel.

Community
Advanced
zangjeicyzangjeicy

comps-analysis

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

Community
Advanced