Mr-Nobody-Anonymous/All-skills

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