skills.rest
SethyPagna
SethyPagnaCOMMUNITY
Explore all skills by this author →
GitHub

comps-analysis

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

Updated May 14, 2026
Search Tags:#benchmarking#financial modeling#excel#valuation#comps#peer analysis
One-click install
npx skills add https://github.com/SethyPagna/Secretary-Jarvis --skill comps-analysis-sethypagna
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/SethyPagna/Secretary-Jarvis/tree/main/src/capabilities/optional-skills/finance/comps-analysis
Command: npx skills add https://github.com/SethyPagna/Secretary-Jarvis --skill comps-analysis-sethypagna

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill turns manual peer benchmarking into a structured comparable company analysis, helping you compare valuation, profitability, growth, and efficiency across public companies in a consistent Excel workbook.

Core Features & Use Cases

  • Operating Benchmarking: Organizes revenue, growth, margins, and other operating metrics so peer performance is easy to compare.
  • Valuation Analysis: Calculates market cap, enterprise value, and core trading multiples such as EV/Revenue, EV/EBITDA, and P/E.
  • Statistical Context: Adds median and quartile statistics to show where a company sits relative to its peer set.
  • Use Cases: Ideal for investment banking comps, public-market screening, IPO pricing support, sector benchmarking, and outlier detection.

Quick Start

Use the comps-analysis skill to build a peer comparison workbook for the companies and metrics I provide, with source-cited inputs and formula-driven valuation and statistics sections.

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 peer valuation?▼

It organizes revenue, growth, and profitability metrics alongside valuation multiples like EV/Revenue and P/E, applying median and quartile statistics to show where a company sits relative to its peer set.

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

It provides statistical context through median and quartile statistics, showing where a target company sits relative to its peer set in terms of growth, profitability, and enterprise value multiples.

Can I calculate EV/EBITDA and enterprise value cross-references for a peer group?▼

These valuation calculations are formula-driven and rely on source-cited inputs, ensuring that your operating benchmarking and statistical context remain transparent and auditable.

Does this comparable company analysis tool require manual formula setup in Excel?▼

This removes the need for manual formula setup, directly producing a structured comps workbook with operating metrics, valuation multiples, and peer statistics for investment banking workflows.

What is the best way to compare public company valuation multiples for sector screening?▼

This approach ensures consistent peer benchmarking across public companies, allowing you to compare valuation, profitability, growth, and efficiency metrics without manual formatting errors.

What operating metrics and valuation multiples are included in peer comps analysis?▼

The workbook adds median and quartile statistics to these metrics, providing the statistical context needed for corporate development, equity research, and sector comparison workflows.

Related Skills

Explore More Finance & Accounting Skills→
ruiyangruiyiruiyangruiyi

comps-analysis

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

Community
Advanced
MuzeWinterMuzeWinter
1

comps-valuation

Build source-backed trading-comps valuation outputs for investment banking workflows.

Community
Advanced
zangjeicyzangjeicy

comps-analysis

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

Community
Advanced
modelscopemodelscope
4.4k

Creating Financial Models

Build financial valuation models with DCF, sensitivity analysis, and Monte Carlo simulations in Excel.

Official
Advanced