comps-analysis

Assemble operating metrics, valuation multiples, and statistical benchmarks into an Excel workbook.

1|Updated Mar 9, 2026

Search Tags:#excel #valuation #financial-modeling #multiples #comps-analysis #comparable

Ready to run

npx skills add https://github.com/kiryteo/opencode-setup --skill comps-analysis-kiryteo

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/kiryteo/opencode-setup/tree/main/skills/comps-analysis
Command: npx skills add https://github.com/kiryteo/opencode-setup --skill comps-analysis-kiryteo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Build institutional-grade comparable company analyses with operating metrics, valuation multiples, and statistical benchmarking in Excel/spreadsheet format.

Core Features & Use Cases

Standardized peer evaluation: consistent metrics (Revenue, Gross Margin, EBITDA) and transparent multiples.
Template-driven outputs: audit-friendly Excel workbooks with built-in formulas and quartile statistics.
Contextual guidance: notes on data sources, methodology, and interpretation for investment decision-making.

Quick Start

Input peer data and run the template to generate a ready-to-use comps workbook.

Frequently Asked Questions about comps-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I build comparable company analysis with valuation multiples in Excel?▼

Comparable company analysis in Excel is generated by inputting standardized peer data into a template-driven workbook, which automatically calculates operating metrics, valuation multiples, and quartile statistics for benchmarking.

What financial metrics are needed for peer benchmarking in a comps workbook?▼

Peer benchmarking requires clearly sourced inputs like revenue and earnings, standardized time frames preferably using LTM data, to derive margins, growth rates, and transparent valuation multiples.

Can I use this comps analysis template for M&A diligence and portfolio monitoring?▼

Yes, this comps analysis template targets investment decision-making, M&A diligence, and portfolio monitoring by assembling operating metrics and statistical benchmarks across industry peers with a consistent data framework.

What is the best way to structure financial modeling data for comparable company analysis?▼

The best way to structure data for comparable company analysis is using standardized time frames with clearly sourced inputs, enabling formula-driven calculations that reference revenue and earnings to derive margins and multiples.

Does the comparable company analysis output include statistical benchmarks and audit trails?▼

Yes, the comparable company analysis output produces an audit-friendly Excel workbook with built-in formulas, quartile statistics, and contextual guidance notes on data sources and methodology for investment decision-making.