managing-portfolio-company-reporting

# Managing Portfolio Company Reporting

Structures portfolio company monitoring frameworks with KPI tracking, budget-to-actual variance analysis, and management team assessment for PE, VC, and growth equity investors.

## When To Use

- Building or refining a quarterly/monthly portfolio company reporting package
- Preparing for an LP advisory committee meeting or annual meeting with portfolio performance data
- Flagging underperformance, covenant breaches, or management concerns across a fund's portfolio
- Onboarding a new portfolio company into the fund's monitoring framework
- Consolidating cross-portfolio data for fund-level reporting or valuations

## Inputs To Gather

- **Company financials**: Income statement, balance sheet, cash flow statement (current period + prior period + budget/plan)
- **Operating KPIs**: Revenue run-rate, MRR/ARR, customer count, churn, pipeline, headcount, burn rate — as relevant to sector
- **Budget/plan**: Board-approved annual operating plan with monthly or quarterly breakdowns
- **Debt schedule**: Outstanding balances, covenant levels, interest rates, maturity dates, compliance certificate data
- **Cap table snapshot**: Fully diluted ownership, option pool remaining, any recent issuances
- **Management commentary**: CEO/CFO narrative on performance drivers, risks, and outlook
- **Prior period report**: Last reporting cycle's package for trend comparison
- **Investment thesis benchmarks**: Original underwriting assumptions (entry revenue, EBITDA targets, growth rate, exit timeline)

## Workflow

1. **Validate data completeness** — Confirm all financial statements tie (net income flows to retained earnings, cash flow reconciles to balance sheet). Flag any missing line items or periods with [VERIFY].

2. **Build the KPI dashboard**
   - Select 8-12 KPIs relevant to the company's sector and stage (e.g., SaaS: ARR, net dollar retention, CAC payback, Rule of 40; industrial: EBITDA margin, backlog, capacity utilization, working capital days)
   - Present current period, prior period, budget, and variance (both absolute and percentage)
   - Include a trailing 4- or 6-quarter trend chart or sparkline where possible

3. **Perform budget variance analysis**
   - Revenue variance: decompose into volume, price/mix, and timing components
   - EBITDA/margin variance: separate gross margin impact from SG&A/opex deviations
   - Cash flow variance: highlight capex timing, working capital swings, and one-time items
   - Mark any line item deviating >10% from plan for narrative explanation

4. **Assess debt and liquidity position**
   - Calculate covenant compliance ratios (leverage, coverage, minimum liquidity) against thresholds
   - Project runway in months at current burn rate (for growth-stage companies)
   - Note upcoming maturities, required amortization, or revolver availability
   - [VERIFY] covenant definitions — these vary by credit agreement

5. **Evaluate management performance**
   - Compare actuals to the commitments management made in the prior reporting period
   - Track key initiative milestones (product launches, hiring targets, geographic expansion)
   - Note any leadership changes, organizational issues, or talent gaps
   - Rate overall execution as On Track / Watch / Action Required

6. **Compile portfolio-level summary**
   - Rank companies by performance against plan (green/yellow/red or quartile)
   - Aggregate fund-level revenue, EBITDA, and net debt across portfolio
   - Highlight the 2-3 companies requiring IC attention or follow-up

7. **Draft the reporting package**
   - One-page executive summary per company (KPI snapshot + management assessment + key risks)
   - Detailed financials as appendix
   - Fund-level dashboard as lead section for LP or IC consumption

## Output

A structured portfolio company report containing:

- **Executive summary**: One-page per company with traffic-light status, key KPIs vs. plan, and critical issues
- **KPI dashboard**: Standardized metrics table with trend, budget comparison, and variance flags
- **Budget variance narrative**: Explanation of material deviations with management's remediation plan
- **Covenant/liquidity tracker**: Compliance status and headroom for each facility
- **Management scorecard**: Execution rating with supporting evidence from milestone tracking
- **Portfolio roll-up**: Fund-level aggregation with ranking and concentration analysis
- **Action items**: Specific follow-ups for deal teams, with owners and deadlines

## Quality Checks

- All financial data ties across statements; any discrepancy is flagged with [VERIFY]
- Variance calculations are directionally correct (favorable vs. unfavorable labeled accurately)
- KPIs match the sector-appropriate metrics — do not apply SaaS metrics to an industrial company
- Covenant ratios are calculated using the credit agreement's specific definitions, not generic formulas [VERIFY]
- Management assessment is evidence-based, not subjective; tied to specific commitments and outcomes
- Prior period comparisons use consistent accounting treatment (watch for restatements or methodology changes)
- Sensitive compensation or personnel data is excluded unless explicitly requested
- [VERIFY] any valuation-related data points (marks, multiples) against the fund's most recent fair value process