skills.rest
LynxLabVN
LynxLabVNOFFICIAL
Explore all skills by this author →
GitHub

comps-analysis

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

Updated Jul 3, 2026
Search Tags:#financial modeling#Excel#valuation#investment analysis#comparable company analysis
One-click install
npx skills add https://github.com/LynxLabVN/office-agent --skill comps-analysis-lynxlabvn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/LynxLabVN/office-agent/tree/main/agent-core/optional-skills/finance/comps-analysis
Command: npx skills add https://github.com/LynxLabVN/office-agent --skill comps-analysis-lynxlabvn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, snpkensho, factset, daloopa, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the process of building institutional-grade comparable company analyses in Excel, providing operating metrics, valuation multiples, and statistical benchmarking to support investment decisions.

Core Features & Use Cases

  • Comparable Company Analysis: Generate comprehensive analyses with operating metrics, valuation multiples, and statistical benchmarking.
  • Excel Integration: Outputs structured Excel/spreadsheet for informed investment decisions.
  • Use Case: Ideal for public-company valuation, IPO pricing, sector benchmarking, or outlier detection.

Quick Start

Activate the skill and provide the necessary data sources and parameters to generate a comparable company analysis in Excel.

Frequently Asked Questions about comps-analysis

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

FAQPage Schema
How do I automate comparable company analysis in Excel?▼

You can automate comparable company analysis in Excel by using this Skill to generate operating metrics, valuation multiples, and statistical benchmarking directly into structured .xlsx files.

What data sources can I use for building valuation multiples and operating metrics?▼

You can use S&P Kensho MCP, FactSet MCP, and Daloopa MCP as data sources for building valuation multiples and operating metrics in your comparable company analysis.

Does comparable company analysis work with openpyxl for Excel file generation?▼

Yes, comparable company analysis requires openpyxl to generate structured .xlsx files, ensuring your operating metrics and valuation multiples are properly formatted in Excel.

Can I use this approach for IPO pricing and sector benchmarking?▼

Yes, comparable company analysis is ideal for public-company valuation, IPO pricing, sector benchmarking, and outlier detection, providing institutional-grade statistical benchmarking for investment decisions.

What is the best way to generate statistical benchmarking for investment analysis?▼

The best way to generate statistical benchmarking for investment analysis is automating comparable company analysis, which structures operating metrics and valuation multiples into Excel for informed decision-making.

Do I need FactSet MCP to perform comparable company analysis?▼

FactSet MCP is supported but not strictly required; you can also use S&P Kensho MCP or Daloopa MCP to source the operating metrics and valuation multiples needed for your analysis.

Related Skills

Explore More Finance & Accounting Skills→
robertbr123robertbr123

comps-analysis

Generate comparable company analysis reports in Excel using openpyxl.

Community
Advanced
PlaidmustachePlaidmustache

comps-analysis

Compare peer companies using operating metrics and valuation multiples in Excel.

Community
Advanced
519lab519lab
2

comps-analysis

Automate comparable company analysis in Excel with operating metrics and valuation multiples.

Official
Advanced
brittaniebuffiecsubrittaniebuffiecsu
1

comps-analysis

Automate comparable company analyses in Excel with openpyxl.

Community
Advanced