lev-os Managing Sponsor Portfolio Reporting
Structures portfolio company monitoring with monthly financial packages, KPI dashboards, and management assessment frameworks.
When To Use
- Building or refining monthly/quarterly reporting packages for PE-backed portfolio companies
- Designing KPI dashboards that align sponsor expectations with management visibility
- Creating management assessment frameworks for board reporting cycles
- Standardizing financial reporting across a multi-company portfolio
- Preparing for LP reporting by aggregating portfolio-level performance data
Inputs To Gather
- Fund structure: Fund vintage, investment thesis, hold period targets, and LP reporting cadence
- Portfolio company financials: Monthly P&L, balance sheet, cash flow statement, and bank covenant compliance data
- Budget and forecast: Annual operating plan, rolling forecast, and bridge-to-budget variance data
- Debt schedule: Term loan balances, revolver availability, interest rates, maturity dates, and covenant thresholds
- KPI definitions: Industry-specific operating metrics agreed upon at acquisition (e.g., recurring revenue, churn, same-store sales, backlog)
- Management team roster: Key executives, reporting responsibilities, and incentive plan alignment
- Prior reporting templates: Existing board decks, lender compliance certificates, and LP data requests
Workflow
Define reporting architecture
- Establish reporting tiers: management flash report (weekly), monthly financial package, quarterly board deck, annual LP letter
- Map each tier to its audience (deal team, IC, board, LPs) and required depth
- Set submission deadlines working backward from board/LP dates (e.g., monthly close by Day 5, package delivered by Day 15)
Build the monthly financial package
- Income statement with budget variance and prior-year comparison columns
- Revenue bridge: volume, price/mix, new customer, and churn components
- EBITDA bridge: revenue flow-through, cost savings initiatives, one-time items, add-backs with clear labeling
- Cash flow waterfall: operating cash flow, capex, debt service, revolver draws/paydowns, ending cash
- Net debt and leverage ratio tracking against covenant thresholds [VERIFY covenant definitions per credit agreement]
Design the KPI dashboard
- Select 8-12 KPIs organized by category: growth, profitability, efficiency, liquidity
- For each KPI: define formula, data source, reporting owner, and red/yellow/green thresholds
- Include trailing-twelve-month trend lines and budget-vs-actual sparklines
- Common PE KPIs by sector:
- Software/SaaS: ARR, net revenue retention, CAC payback, Rule of 40
- Healthcare services: same-facility revenue, provider utilization, payor mix
- Industrial/manufacturing: backlog, book-to-bill, gross margin by product line, on-time delivery
- Consumer/retail: same-store sales, average ticket, customer acquisition cost, inventory turns
Structure the management assessment framework
- Quarterly qualitative review covering: strategic initiative progress, organizational changes, competitive landscape shifts, and risk factors
- Management scorecard: rate each executive on execution against 100-day plan or annual goals
- Talent pipeline status: open roles, time-to-fill, key-person risk identification
- Value creation tracker: map each identified lever (revenue growth, margin expansion, multiple expansion) to actual progress
Aggregate for LP and IC reporting
- Roll up individual portco metrics into fund-level dashboards: gross/net IRR, MOIC, DPI, RVPI, TVPI
- Prepare portfolio summary matrix: company name, sector, investment date, invested capital, current valuation, revenue, EBITDA, leverage, status rating
- Draft narrative commentary highlighting material developments, watch-list companies, and follow-on capital decisions
Output
- Monthly financial package template with standardized tabs for P&L, EBITDA bridge, cash flow, debt schedule, and covenant compliance
- KPI dashboard with defined metrics, thresholds, data sources, and visual layout
- Management assessment scorecard with qualitative and quantitative evaluation criteria
- Board deck outline mapping each section to its data source and responsible preparer
- Portfolio roll-up template for IC and LP reporting with fund-level aggregation
Quality Checks
- Verify EBITDA add-backs are consistent with credit agreement definitions and LP reporting methodology [VERIFY]
- Confirm KPI formulas match definitions used in the acquisition model and management incentive plans
- Ensure covenant compliance calculations use the same methodology as the lender compliance certificate [VERIFY]
- Validate that all financial data ties: P&L net income flows to balance sheet retained earnings, cash flow reconciles to ending cash
- Check that reporting deadlines are achievable given the company's close process maturity
- Confirm LP reporting metrics (IRR, MOIC) align with fund LPA requirements and ILPA reporting standards [VERIFY]
- Flag any portco where actuals deviate more than 10% from budget on revenue or 15% on EBITDA for enhanced commentary