skills.rest
kiryteo
kiryteoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/kiryteo/opencode-setup --skill comps-analysis-kiryteo
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Finance & Accounting Skills→
iTzFaisaliTzFaisal

comps-analysis

Analyze comparable company peers into an Excel workbook with operating metrics and valuation multiples.

Community
Advanced
open-nekoopen-neko
11

comps-analysis

Generate comparable company analyses with operating metrics, valuation multiples, and quartile statistics into Excel workbooks.

Official
Advanced
MyHeavenDyfMyHeavenDyf

dcf-valuation

Automate discounted cash flow valuation and generate Markdown reports for public companies.

Community
Intermediate
jwangkunjwangkun
705

china-initiating-coverage

Automate initiation coverage reports for A-share companies with CAS accounting standards.

Community
Advanced