skills.rest
executiveusa
executiveusaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

comps-analysis

Build spreadsheet-ready comparable company analyses with valuation multiples and quartile benchmarks.

1|Updated May 16, 2026
Search Tags:#investment analysis#valuation multiples#comparable companies#financial benchmarking#excel modeling#operating metrics#quartile statistics
One-click install
npx skills add https://github.com/executiveusa/Cheggie-trade-V2 --skill comps-analysis-executiveusa
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/executiveusa/Cheggie-trade-V2/tree/main/core/financial-skills/plugins/vertical-plugins/financial-analysis/skills/comps-analysis
Command: npx skills add https://github.com/executiveusa/Cheggie-trade-V2 --skill comps-analysis-executiveusa

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It helps you quickly produce a comparable company analysis that turns peer financials into valuation multiples and benchmarking statistics you can present confidently.

Core Features & Use Cases

  • Comparable company modeling: Builds an Excel/spreadsheet structure for operating metrics (growth, margins, EBITDA) and valuation multiples (EV/Revenue, EV/EBITDA, P/E).
  • Statistical benchmarking: Automatically adds distribution context using quartiles (25th/50th/75th) plus min/max for key comparable metrics.
  • Institutional data discipline: Enforces a strict data-source hierarchy (prefer MCP sources, otherwise use institutional sources) and requires transparent, auditable inputs via comments.

Use cases: M&A and investment underwriting, IPO/funding pricing support, peer-group benchmarking, and identifying over/under-valued targets versus a defined universe.

Quick Start

Use the comps-analysis skill to generate an Excel comparable company analysis for a set of public peers using your chosen reporting period and units, with formulas and quartile benchmarks ready for review.

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 with valuation multiples and quartile benchmarking?▼

A comparable company analysis structures peer financials into operating metrics and valuation multiples, adding quartile statistics for benchmarking. The Skill generates a spreadsheet-ready layout with formula-driven metrics and documented input sourcing for institutional review.

How do I calculate EV/Revenue and EV/EBITDA multiples for a peer group in a spreadsheet?▼

Calculating EV/Revenue and EV/EBITDA multiples requires organizing peer operating metrics and valuation data into a structured Excel layout. The Skill builds formula-driven multiples alongside growth, margins, and EBITDA metrics for a defined public peer universe.

What's the best way to benchmark operating metrics against a peer group using quartile statistics?▼

Quartile benchmarking applies 25th, 50th, and 75th percentiles plus min/max ranges to key operating metrics. The Skill automatically adds this distribution context to comparable company analyses for identifying over or under-valued targets.

Can I use MCP data providers to source financial inputs for an Excel comparable company analysis?▼

MCP data providers are the preferred source for financial inputs in a comparable company analysis. The Skill enforces a strict data-source hierarchy that prefers MCP providers over web search, requiring transparent and auditable inputs via cell comments.

Does this comparable company analysis approach work for M&A support and IPO pricing?▼

Comparable company analysis applies directly to M&A underwriting, IPO pricing, and funding support workflows. The Skill produces institutional-grade peer comps with verified metrics and documented sourcing suitable for investment presentations.

Why do valuation multiples in my Excel model lack transparent input sourcing?▼

Transparent input sourcing requires documenting where peer financial data originates within the spreadsheet. The Skill enforces institutional data discipline by requiring cell comments that trace inputs back to MCP or institutional sources for auditability.

Related Skills

Explore More Finance & Accounting Skills→
RheasilviaRheasilvia

comps-analysis

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

Community
Advanced
AnandaAnugrahHandyantoAnandaAnugrahHandyanto

comps-analysis

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

Community
Advanced
ruiyangruiyiruiyangruiyi

comps-analysis

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

Community
Advanced
SethyPagnaSethyPagna

comps-analysis

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

Community
Advanced