casemark/managing-investor-reporting

Managing Investor Reporting

Structures investor communications with performance reporting, capital account statements, and distribution notices.

When To Use

• Preparing quarterly or annual investor letters and performance reports
• Generating capital account statements showing contributions, distributions, and ending balances per LP
• Drafting distribution notices (cash distributions, in-kind distributions, recallable vs. non-recallable)
• Producing fund-level performance summaries (gross/net IRR, TVPI, DPI, RVPI)
• Responding to ad hoc LP data requests or ILPA-format reporting requirements
• Creating capital call notices with allocation schedules by commitment percentage

Inputs To Gather

• Fund documents: LPA/partnership agreement (waterfall terms, reporting obligations, fee provisions, GP clawback thresholds)
• Financial data: Trial balance, NAV statement, investment schedule with fair values, cash flow ledger
• Capital account records: Commitment amounts per LP, drawdown history, distribution history, unfunded commitments
• Performance data: Cash flows by date for IRR calculation, current portfolio valuations, benchmark indices if applicable
• Reporting period: Confirm quarter-end or year-end date; confirm whether interim or audited figures
• Prior reports: Previous period investor letter and capital account statements for consistency checks
• Distribution details (if applicable): Total distribution amount, source (return of capital vs. gain), tax characterization, withholding requirements

Workflow

1. Validate source data

   • Reconcile capital account balances to the general ledger and fund administrator records
   • Confirm NAV per the latest valuation (mark whether audited or estimated) [VERIFY]
   • Check that all contributions and distributions in the period are captured and classified correctly
   • Verify management fee and carried interest calculations against LPA terms

2. Compile performance metrics

   • Calculate gross and net IRR using actual cash flow dates (since-inception and for the reporting period)
   • Compute multiples: TVPI (Total Value / Paid-In), DPI (Distributions / Paid-In), RVPI (Residual Value / Paid-In)
   • Compare to relevant benchmarks (e.g., Cambridge Associates, public market equivalent) if required by side letters or LPA
   • Note any methodology choices (e.g., time-weighted vs. money-weighted returns) [VERIFY]

3. Draft capital account statements

   • Present per-LP opening balance, contributions, distributions, allocation of income/loss, fees, and ending balance
   • Show unfunded commitment remaining for each LP
   • Reflect any LP transfers, secondary sales, or excuse/exclusion provisions applied during the period
   • Ensure pro-rata allocation percentages tie to commitment schedule

4. Prepare investor letter / narrative report

   • Summarize fund-level performance with context on portfolio activity (new investments, exits, write-ups/write-downs)
   • Describe material valuation changes and the drivers behind them
   • Address market conditions relevant to the portfolio
   • Disclose any key-person events, GP clawback exposure, or organizational changes [VERIFY]
   • Include forward-looking commentary on pipeline and deployment pace (with appropriate disclaimers)

5. Draft distribution notice (if applicable)

   • State total distribution amount and per-LP allocation
   • Classify as return of capital, realized gain, or dividend income per the LPA waterfall
   • Specify whether recallable or non-recallable
   • Include wire instructions, record date, and payment date
   • Note tax withholding for ERISA, tax-exempt, or non-US LPs [VERIFY]

6. Review and finalize

   • Cross-check all figures across the letter, capital account statements, and distribution notice for internal consistency
   • Confirm compliance with LPA reporting deadlines (typically 60–90 days post quarter-end) [VERIFY]
   • Verify ILPA reporting template alignment if required by any LP side letters
   • Flag any items requiring GP approval or legal review before distribution

Output

• Quarterly/Annual Investor Letter: Narrative report covering fund performance, portfolio updates, and outlook (typically 3–8 pages)
• Capital Account Statements: Per-LP tabular statements with all activity for the period and cumulative since inception
• Distribution Notice: Formal notice with allocation schedule, classification, and payment details
• Performance Summary Table: Fund-level metrics (IRR, multiples) with vintage year and benchmark comparisons
• Supporting Schedules: Investment schedule with cost basis and fair value, fee calculation detail, cash flow summary

Quality Checks

• All IRR and multiple calculations reconcile to underlying cash flow data and tie to the fund administrator's independent calculations
• Capital account ending balances equal opening balance + contributions − distributions ± income/loss allocation − fees
• Distribution allocations sum to total distribution amount; per-LP amounts match pro-rata share or waterfall provisions
• Narrative statements are consistent with quantitative data (no contradictions between letter and tables)
• Reporting complies with LPA-mandated frequency, content, and delivery requirements [VERIFY]
• Tax characterization of distributions is reviewed against partnership tax returns or estimates [VERIFY]
• Sensitive LP information (commitment sizes, individual returns) is not exposed in materials sent to other LPs