skills.rest
AlexZWANG1
AlexZWANG1COMMUNITY
Explore all skills by this author →
GitHub

comps-analysis

Structure public-company comps data and calculations into an Excel workbook.

Updated Mar 17, 2026
Search Tags:#audit#benchmarking#excel#valuation#comps#comparable-analysis
One-click install
npx skills add https://github.com/AlexZWANG1/Prism --skill comps-analysis-alexzwang1
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/AlexZWANG1/Prism/tree/main/financial-services-plugins/financial-analysis/skills/comps-analysis
Command: npx skills add https://github.com/AlexZWANG1/Prism --skill comps-analysis-alexzwang1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Comps-analysis enables analysts to construct institutional-grade comparable company analyses by combining operating metrics, valuation multiples, and statistical benchmarks into a transparent Excel workbook. It enforces a rigorous structure, standardized inputs, and auditable sources to support investment decisions and governance reviews.

Core Features & Use Cases

  • Structured operating metrics and valuation multiples in an Excel-friendly layout
  • Statistical benchmarking with quartiles (Max, Median, 75th percentile, etc.)
  • Data source guidance, source citations, and notes for audit
  • Industry-specific adaptations (SaaS, Manufacturing, etc.)
  • Template-driven: create templates, reuse, ensure formulas are dynamic

Quick Start

Input your peer data and raw inputs into the template, then review the formulas and outputs section by section to ensure consistency and provenance.

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 audit trails?▼

Building a comparable company analysis in Excel requires structuring operating metrics, valuation multiples, and statistical benchmarks with input-linked formulas and documented data citations to ensure reproducible, auditable outputs for investment committees.

What is the best way to calculate valuation multiples and quartiles for peer benchmarking?▼

Calculating valuation multiples and quartiles for peer benchmarking involves applying standardized inputs to derive statistical benchmarks like median and 75th percentile, organizing the results into an Excel-friendly layout that supports sector comparisons.

Can I use comps analysis templates for both SaaS and traditional manufacturing industries?▼

Comps analysis templates support both SaaS and traditional manufacturing industries by applying industry-specific adaptations to operating metrics and valuation multiples, ensuring relevant sector benchmarking within the structured Excel workbook.

Does comparable company analysis require documented data sources for M&A governance reviews?▼

Comparable company analysis for M&A governance reviews requires documented data sources, source citations, and notes to establish an audit trail, ensuring the structured operating metrics and calculations are transparent and reproducible.

How do I automate institutional-grade comps analysis without losing formula traceability?▼

Automating institutional-grade comps analysis while maintaining formula traceability requires template-driven workbooks with dynamic, input-linked formulas, ensuring structured calculations remain auditable rather than hardcoded.

What are the limitations of using Excel for comps analysis in M&A discussions?▼

Using Excel for comps analysis in M&A discussions requires strict adherence to template-driven structures and input-linked formulas; without standardized inputs and documented source citations, maintaining reproducible audit trails for governance reviews becomes difficult.

Related Skills

Explore More Finance & Accounting Skills→
ruiyangruiyiruiyangruiyi

comps-analysis

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

Community
Advanced
yuping322yuping322
17

fsi-comps-analysis

Build comparable company analyses in Excel with valuation multiples and statistical benchmarks.

Community
Advanced
sheawinklersheawinkler
78

comps-analysis

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

Community
Advanced
NITISH-gitbitNITISH-gitbit

comps-analysis

Generate comparable company analyses in Excel with operating metrics and valuation multiples.

Community
Advanced