comps-analysis

Builds comparable company analyses with Python and spreadsheet formats.

26|2|Updated Apr 30, 2026
One-click install
npx skills add https://github.com/ViviennaMAO/money_banking_financial_market --skill comps-analysis-viviennamao
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: comps-analysis
Source: https://github.com/ViviennaMAO/money_banking_financial_market/tree/main/financial-services-main/plugins/vertical-plugins/financial-analysis/skills/comps-analysis
Command: npx skills add https://github.com/ViviennaMAO/money_banking_financial_market --skill comps-analysis-viviennamao

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the creation of comprehensive comparable company analyses, allowing for quick and precise valuation of public companies.

Core Features & Use Cases

  • Operating Metrics Analysis: Calculate key financial metrics like revenue growth, gross margin, EBITDA margin, and more.
  • Valuation Multiples: Generate valuation multiples such as EV/Revenue, EV/EBITDA, P/E, and more.
  • Statistical Benchmarking: Compare companies using statistical data like max, median, 75th percentile, and min values for various metrics.
  • Use Case: Utilize this Skill to compare companies in the tech industry, analyzing their performance and valuation against their peers.

Quick Start

Run the 'comps-analysis' skill with the required data and get a professional-grade comparable company analysis.

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 with operating metrics and valuation multiples?

Build a comparable company analysis by running the comps-analysis skill with financial data to calculate operating metrics like revenue growth and generate valuation multiples such as EV/Revenue and EV/EBITDA. It outputs a professional-grade Excel spreadsheet for benchmarking public companies.

Can I calculate statistical benchmarks like median and percentile for public company valuation in Excel?

Yes, you can calculate statistical benchmarks for public company valuation by running this skill with your financial dataset. It computes max, median, 75th percentile, and min values for various operating metrics, formatting the results directly into Excel spreadsheets for peer comparison.

What financial data do I need to perform comparable company analysis and identify valuation outliers?

To perform comparable company analysis and identify valuation outliers, you need access to financial data sources containing public company operating metrics. The skill uses pandas to process this input data, calculating growth and margin profiles to benchmark peers and spot anomalies.

How do I use Python and pandas to automate comparable company analysis for IPO or funding round pricing?

Automate comparable company analysis for IPO or funding round pricing by providing your financial data to this Python-based skill. It leverages pandas to process operating metrics and calculate valuation multiples, handling the benchmarking logic to deliver institutional-grade valuation results.

Does this comparable company analysis tool require Excel or similar software to function?

Yes, this comparable company analysis tool requires Excel or similar spreadsheet software to view and manipulate the final output. The skill processes underlying financial data using Python and pandas, then exports the formatted operating metrics and valuation multiples into spreadsheet formats.