How to Model Venture Fund Returns From Portfolio Outcomes

A venture fund returns model starts with the proceeds each holding could deliver and reconciles those outcomes to the capital investors contribute. It needs separate definitions for investment cost, fund expenses, investor paid-in capital, carried interest and unrealized marks.

Begin with the positions and security economics

For every holding record invested cost, security class, fully diluted ownership, potential additional financing, assumed exit equity proceeds and expected timing. Company enterprise value is not directly a fund distribution. The investor's preferred rights, debt and transaction expenses affect the proceeds it receives.

An illustrative fully realized portfolio

Assume a fictional closed-end fund receives $20M from LPs. It invests $18M into five groups of positions and spends $2M on modeled management fees and fund expenses over its life. Ignore GP commitment, leverage, taxes and recycling in this example. All investments are fully realized, with no unrealized portfolio value remaining.

Group A: $4M invested produces $28M gross equity proceeds. Group B: $4M produces $10M. Group C: $4M produces $5M. Group D: $3M returns $3M. Group E: $3M produces $1M. Total invested cost is $18M and total cash proceeds to the fund are $47M.

The company-level cash proceeds are assumed to be after relevant security waterfalls, debt and transaction costs, but before the fund's carry. The figures are educational scenarios, not actual Treto portfolio results.

Calculate gross investment performance

Gross invested-capital MOIC = $47M fund investment proceeds ÷ $18M invested cost = approximately 2.61x. Group A contributes $28M of $47M proceeds, or about 59.6%, illustrating how portfolio outcomes can concentrate. No claim is made about the probability of any specific result.

Move from gross proceeds to LP distributions

For this simplified whole-fund illustration, all $20M of LP paid-in capital must be returned before carry. Assume a 20% carry on realized profits above that contributed-capital return, no hurdle, no catch-up complication, no interim allocations and sufficient fund liquidity. The carried-interest base is $47M − $20M = $27M, producing $5.4M of illustrative carry.

LP distributions then equal $47M − $5.4M = $41.6M. Because the fund is fully realized, net LP DPI = $41.6M ÷ $20M paid in = 2.08x. RVPI is 0 and net TVPI equals 2.08x on the same LP reporting perimeter. The $2M modeled fees and expenses are already reflected in the $20M paid in against $18M deployed.

Understand why the fund metrics differ

Gross investment MOIC uses $18M of portfolio cost as its denominator. Net LP TVPI uses $20M contributed capital and subtracts the illustrated carry from the proceeds. Mixing those denominators would produce a misleading comparison. The gross versus net returns guide explains other waterfall assumptions.

Build timing into a separate IRR calculation

An annualized internal rate of return requires the actual dates and amounts of LP contributions and distributions. This example supplies cumulative totals without dates and therefore does not imply a specific IRR. IRR in venture capital covers dated cash-flow methodology.

A reusable fund modeling table

For each position, record cost, additional check, current mark or exit proceeds, realization date, rights and source. Aggregate gross investment proceeds, cash held, liabilities, expenses and partner-specific allocations. Reconcile interim RVPI and DPI on consistent paid-in bases. The administrator validates the official fund accounts.

Test sensitivity rather than promising a target

A lower Group A outcome would have a disproportionate impact here. If its $28M proceeds fell to $14M while other groups stayed unchanged, total fund proceeds would fall to $33M. Under the same simplified carry convention, carry would be 20% × ($33M − $20M) = $2.6M, leaving LPs $30.4M or 1.52x DPI. This illustrates concentration risk rather than forecasting an actual result.

Treto's Portfolio workspace can connect company financing events and operating evidence with portfolio decisions. It does not replace the administrator's official net return calculations, carried-interest waterfall or investor reporting.

Questions investors ask

Can fund TVPI equal the average of company investment MOICs?

Company multiples have different capital weights and may exclude fees or carry. Fund TVPI uses distributions plus residual value attributable to the relevant investors over their paid-in capital. The two measures require a consistent reporting basis and cannot be calculated by taking an unweighted average of company MOICs.

Does high TVPI mean investors have received the cash?

TVPI includes distributed proceeds and residual value. DPI measures the distributed component while RVPI describes the remaining reported value. A fully realized illustration has RVPI of zero, but an active fund may have most of its TVPI in unrealized positions.