Portfolio monitoring: The 5 most important KPIs for family offices
Which KPIs truly matter for tracking private equity portfolios — and why spreadsheets are not enough.
## Why KPIs matter in portfolio monitoring
For family offices managing private equity portfolios, having the right KPIs at a glance is not a luxury — it is a necessity.
## 1. Internal Rate of Return (IRR)
The IRR measures the annualized return of an investment, taking into account the timing of cash flows. It is the gold standard for PE performance measurement.
> A common mistake: using Excel's IRR function with annual periods when actual cash flows are irregular.
## 2. Multiple on Invested Capital (MOIC)
MOIC shows how much total value has been generated relative to the capital invested. A MOIC of 2.5x means the investment has returned 2.5 times the original amount.
## 3. Total Portfolio Value (NAV)
The Net Asset Value of the portfolio is the sum of all current valuations.
## 4. Distribution to Paid-In (DPI)
DPI measures realized returns: how much cash has actually been returned to the investor.
## 5. Capital Call Ratio
For fund commitments, the capital call ratio shows how much of the committed capital has been drawn down.
## Why automation matters
Calculating these KPIs manually is not just time-consuming — it is error-prone.