Skill

Portfolio Monitoring

Ingests Excel/PDF/CSV financials for portfolio companies, extracts KPIs, flags budget variances, checks covenants, and generates board-ready summaries/tables/trends.

monitoring

Install

npx claudepluginhub yuping322/financial-services-plugins-new --plugin private-equity

Tool Access

This skill uses the workspace's default tool permissions.

Preview

description: Track and analyze portfolio company performance against plan. Ingests monthly/quarterly financial packages (Excel, PDF), extracts KPIs, flags variances to budget, and produces summary dashboards. Use when reviewing portfolio company financials, preparing board materials, or monitoring covenant compliance. Triggers on "review portfolio company", "monthly financials", "how is [compan...

SKILL.md

Similar Skills

kotlin-ktor-patterns

Provides Ktor server patterns for routing DSL, plugins (auth, CORS, serialization), Koin DI, WebSockets, services, and testApplication testing.

everything-claude-code

163.2k

deep-research

Conducts multi-source web research with firecrawl and exa MCPs: searches, scrapes pages, synthesizes cited reports. For deep dives, competitive analysis, tech evaluations, or due diligence.

everything-claude-code

163.2k

inventory-demand-planning

Provides demand forecasting, safety stock optimization, replenishment planning, and promotional lift estimation for multi-location retailers managing 300-800 SKUs.

everything-claude-code

163.2k

Stats

Parent Repo Stars6

Parent Repo Forks0

Last CommitFeb 23, 2026

Used By2 plugins

Actions

View Source View Plugin View on GitHub View README

Portfolio Monitoring

Workflow

Step 1: Ingest Financial Package

Accept the user's portfolio company financial package (Excel workbook, PDF, or CSV)
Extract key financials: Revenue, EBITDA, cash balance, debt outstanding, capex, working capital
Identify the reporting period and compare to prior period and budget/plan

Step 2: KPI Extraction & Variance Analysis

Key metrics to track (adapt to the company's sector):

Financial KPIs:

Revenue vs. budget ($ and %)
EBITDA and EBITDA margin vs. budget
Cash balance and net debt
Leverage ratio (Net Debt / LTM EBITDA)
Interest coverage ratio
Capex vs. budget
Free cash flow

Operational KPIs (ask user or infer from data):

Customer count / revenue per customer
Employee headcount / revenue per employee
Backlog / pipeline
Churn / retention rates

Step 3: Flag & Summarize

Green: Within 5% of plan
Yellow: 5-15% below plan — flag for discussion
Red: >15% below plan or covenant breach risk — immediate attention

Output a concise summary:

One-paragraph executive summary ("Company X is tracking [ahead/behind/on] plan...")
KPI table with actual vs. budget vs. prior period
Red/yellow flags with context
Covenant compliance status (if applicable)
Questions for management

Step 4: Trend Analysis

If multiple periods are provided:

Chart key metrics over time (revenue, EBITDA, cash)
Identify trends — accelerating, decelerating, or stable
Compare vs. underwriting case

Important Notes

Always ask for the budget/plan to compare against if not provided
Don't assume sector-specific KPIs — ask what matters for this company
If covenant levels aren't known, ask the user for the credit agreement terms
Output should be board-ready — concise, factual, no fluff