Fund level calculations

Committed Capital

The sum of all LP investments.

sum(LP investments)

Capital Called

The sum of LP wired amounts.

sum(LP wired amounts)

Invested Capital

The sum of capital invested in the Fund's portfolio companies.

sum(Invested Capital of Fund in portcos)

Realized Value

The sum of the realized or partially realized values of all the Fund's portfolio companies.

sum(portco Realized Values)

Book Value

The sum of NAV values from all portfolio companies. The Total Value of the fund.

sum(NAVs)

Gross Multiple

Takes the sum of the unrealized and realized values and divides by the sum of the total fund Invested Capital.

sum(Book Value+ Realized Value)/Invested Capital

Gross Realized Multiple

Determined by dividing the Realized Value by the Invested Capital.

sum(Realized Value)/ sum(Invested Capital)

DPI

The sum of LP Distributions divided by the Capital Called.

sum(LP Distributions)/ Capital Called

RVPI (A)

Residual Value to Paid in Capital- if GP Carried Interest "kicks in".

(Book Value* (1-carried interest))/ Sum(LP Wires)

RVPI (B)

Residual Value to Paid in Capital- if GP Carried Interest has not "kicked in".

((Distributions left to be distributed until carry)+ ((Book Value-Distributions left to be distributed until carry)* (1-carried interest)))/ sum(LP Wires)

Net TVPI

Total Gain of value.

sum(DPI + RVPI)

Gross IRR

Takes into account the Invested capital, realized Values and Book Value.

XIRR(array of relevant investment dates & Fund Investment wires(*-1), Fund Realized Value and Book Value)

Net IRR

Takes into account the management fees, carried interest and fund expenses.

XIRR (array of relevant dates & LP wires (*-1), LP distributions and LP portion of Book Value, following the provision of the carried interest)