df1ef9f0-3138-4b76-8be9-a0e40bc4ccef/claude-plugin/skills/valuation/SKILL.md
Perform fair value analysis for PE/VC portfolio companies — comparable company analysis, precedent transactions, DCF modeling, ASC 820 / IFRS 13 fair value hierarchy classification, and valuation reconciliation. Ensures compliance with accounting standards.
npx skillsauth add ganoro/equiforte-workspaces-local-2 df1ef9f0-3138-4b76-8be9-a0e40bc4ccef/claude-plugin/skills/valuationInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Perform fair value analysis during the COMPUTE phase of the ACSR lifecycle.
Every valuation must be classified:
| Level | Inputs | Examples | |-------|--------|----------| | Level 1 | Quoted prices in active markets | Public stock price, exchange-traded securities | | Level 2 | Observable inputs other than Level 1 | Comparable company multiples, recent transactions | | Level 3 | Unobservable inputs | DCF with internal projections, fund manager estimates |
Most PE/VC investments are Level 3. Always state the level.
### Comparable Company Analysis for [Company Name]
**Subject Company Metrics (as of [date])**:
- LTM Revenue: [amount] [currency]
- LTM EBITDA: [amount] [currency]
- Revenue Growth: [X.X%]
- EBITDA Margin: [X.X%]
**Selected Comparables**:
| Company | EV/Revenue | EV/EBITDA | Revenue Growth | EBITDA Margin |
|---------|-----------|-----------|----------------|---------------|
| [Comp 1] | X.Xx | X.Xx | X.X% | X.X% |
| [Comp 2] | X.Xx | X.Xx | X.X% | X.X% |
| [Comp 3] | X.Xx | X.Xx | X.X% | X.X% |
| **Median** | **X.Xx** | **X.Xx** | **X.X%** | **X.X%** |
| **Mean** | **X.Xx** | **X.Xx** | **X.X%** | **X.X%** |
**Selected Multiple**: [X.Xx] EV/EBITDA (state rationale for selection vs. median)
**Adjustments**:
- Size discount: [X%] (subject is smaller/less liquid)
- Growth premium/discount: [X%] (growth differential)
- Control premium: [X%] (if applicable)
**Implied Enterprise Value**: [amount] [currency]
**Less: Net Debt**: [amount]
**Equity Value**: [amount]
**Fund Ownership**: [X%]
**Fair Value of Fund's Interest**: [amount] [currency]
Same structure as comparables but using transaction multiples. Note:
### DCF Analysis for [Company Name]
**Projection Period**: [X] years
**Terminal Value Method**: [Exit multiple / Gordon Growth]
| Year | Revenue | EBITDA | FCF | Discount Factor | PV of FCF |
|------|---------|--------|-----|-----------------|-----------|
| 1 | | | | | |
| 2 | | | | | |
| ... | | | | | |
| TV | | | | | |
**Key Assumptions**:
- Revenue CAGR: [X.X%] — Confidence: [level]
- EBITDA Margin (terminal): [X.X%]
- WACC: [X.X%] (Risk-free: X.X%, ERP: X.X%, Beta: X.X, Size premium: X.X%)
- Terminal Exit Multiple: [X.Xx] EV/EBITDA OR Terminal Growth Rate: [X.X%]
**Sensitivity Analysis**:
| WACC \ Exit Multiple | X.Xx | X.Xx | X.Xx |
|---------------------|------|------|------|
| X.X% | | | |
| X.X% | | | |
| X.X% | | | |
Per ASC 820 guidance, calibrate current valuation to entry price:
When using multiple methods, reconcile:
| Method | Implied Fair Value | Weight | Weighted Value | |--------|-------------------|--------|----------------| | Comparable Companies | [amount] | [X%] | [amount] | | Precedent Transactions | [amount] | [X%] | [amount] | | DCF | [amount] | [X%] | [amount] | | Concluded Fair Value | | 100% | [amount] |
State rationale for weighting.
tools
MANDATORY workspace file-writing rules for the containerized agent environment. Triggers whenever files are created, written, saved, or generated. All deliverables MUST go to output/ subdirectory. Absolute paths like /home/user/ will fail.
development
Use this skill whenever a user wants to research a portfolio company and generate an ILPA-compliant Portfolio Company Metrics (PortCo) report. Triggers include: any mention of "ILPA", "portfolio company report", "PortCo template", "PE fund reporting", "GP reporting", "LP reporting", "buyout company metrics", "growth equity metrics", or when a user asks to "research a company for private equity", "compute KPIs for a portco", "generate fund performance metrics", or "fill out a portfolio company template". Also triggers when a user provides a company name and asks for financial analysis in a PE/VC context, including requests for EBITDA multiples, IRR, MOIC, ownership metrics, or debt analysis. Output formats supported: Excel (.xlsx), PowerPoint (.pptx), or PDF report.
tools
Generate Excel workbooks (XLSX) from structured financial data using openpyxl. Creates formatted spreadsheets with multiple tabs for fund performance, portfolio data, cash flows, and waterfall calculations. Includes formulas, conditional formatting, and charts. Always read the design-system skill first.
tools
Generate PowerPoint presentations (PPTX) from structured report data using python-pptx. Creates professional PE/VC presentations with consistent formatting, charts, and tables. Handles board decks, LP summaries, and IC presentations. Always read the design-system skill first.