fsi-comps-analysis

Build comparable company analyses and valuation spreadsheets for Chinese equities.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill fsi-comps-analysis-brianping7
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: fsi-comps-analysis
Source: https://github.com/brianping7/volc-financial-services-skill-sets/tree/main/financial-analysis/comps-analysis
Command: npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill fsi-comps-analysis-brianping7

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides a repeatable, audit-trailed workflow to construct institutional-quality comparable company analyses and valuation tables so analysts can produce defensible Excel deliverables without ad-hoc shortcuts.

Core Features & Use Cases

  • Prioritized data-source rules that enforce MCP-first sourcing and avoid unreliable web search results.
  • Standardized spreadsheet structure: operating metrics, valuation multiples, percentile statistics, and cross-checked formulas for transparency.
  • Practical guidance for industry-specific metrics (SaaS, healthcare, industrials, financials) and quality checks (reasonability tests, annotation of hard-coded inputs).
  • Use cases: M&A comps for deal pricing, benchmarking for investment memos, IPO pricing prep, and investment committee presentations.

Quick Start

Build a comps analysis for [Target Company] using MCP sources where available, compute LTM metrics and valuation multiples, add percentile statistics, and export the finished workbook to Excel.

Frequently Asked Questions about fsi-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 for M&A pricing?

Build a comparable company analysis in Excel by applying standardized spreadsheet structures that compute operating metrics, valuation multiples, and percentile statistics. This enforces prioritized data-source rules to produce audit-trailed, institutional-grade deliverables for M&A pricing.

What is the best way to structure a comps valuation spreadsheet for investment committee prep?

The best way to structure a comps valuation spreadsheet is to use standardized tables for operating metrics and valuation multiples, cross-checked formulas for transparency, and percentile statistics. This provides defensible Excel deliverables for investment committee presentations.

Does this comps analysis workflow support A-share and Hong Kong listed companies?

Yes, this comps analysis workflow supports A-share, Hong Kong, and US-listed Chinese companies. It calculates LTM metrics and valuation multiples tailored for tasks like IPO pricing, benchmarking, and M&A deal pricing across these specific markets.

Can I enforce an audit trail when sourcing financial data for valuation modeling?

You can enforce an audit trail by applying prioritized data-source rules that mandate MCP-first sourcing and avoid unreliable web search results. The workflow generates audit-trace annotations to validate all hard-coded inputs within your financial modeling.

How do I calculate industry-specific operating metrics for a comps analysis?

Calculate industry-specific operating metrics by applying practical guidance tailored for SaaS, healthcare, industrials, and financials sectors. The workflow computes LTM metrics and performs reasonability tests to ensure accurate comps analysis outputs.

What data sources are used to generate institutional-grade comparable company analyses?

Institutional-grade comparable company analyses use a prioritized data-source hierarchy that enforces MCP-first sourcing. This approach avoids unreliable web search results and generates audit-trace annotations to ensure defensible valuation outputs.