Portfolio Monitoring
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 [company] performing", "covenant check", or "portfolio update".
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
1---2name: portfolio-monitoring3description: Portfolio Monitoring4---5# Portfolio Monitoring67description: 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 [company] performing", "covenant check", or "portfolio update".89## Workflow1011### Step 1: Ingest Financial Package1213- Accept the user's portfolio company financial package (Excel workbook, PDF, or CSV)14- Extract key financials: Revenue, EBITDA, cash balance, debt outstanding, capex, working capital15- Identify the reporting period and compare to prior period and budget/plan1617### Step 2: KPI Extraction & Variance Analysis1819Key metrics to track (adapt to the company's sector):2021**Financial KPIs:**22- Revenue vs. budget ($ and %)23- EBITDA and EBITDA margin vs. budget24- Cash balance and net debt25- Leverage ratio (Net Debt / LTM EBITDA)26- Interest coverage ratio27- Capex vs. budget28- Free cash flow2930**Operational KPIs** (ask user or infer from data):31- Customer count / revenue per customer32- Employee headcount / revenue per employee33- Backlog / pipeline34- Churn / retention rates3536### Step 3: Flag & Summarize3738- **Green**: Within 5% of plan39- **Yellow**: 5-15% below plan — flag for discussion40- **Red**: >15% below plan or covenant breach risk — immediate attention4142Output a concise summary:431. One-paragraph executive summary ("Company X is tracking [ahead/behind/on] plan...")442. KPI table with actual vs. budget vs. prior period453. Red/yellow flags with context464. Covenant compliance status (if applicable)475. Questions for management4849### Step 4: Trend Analysis5051If multiple periods are provided:52- Chart key metrics over time (revenue, EBITDA, cash)53- Identify trends — accelerating, decelerating, or stable54- Compare vs. underwriting case5556## Important Notes5758- Always ask for the budget/plan to compare against if not provided59- Don't assume sector-specific KPIs — ask what matters for this company60- If covenant levels aren't known, ask the user for the credit agreement terms61- Output should be board-ready — concise, factual, no fluff
jadegate