The same carry rate costs more when it is charged on each winning fund separately instead of on the net gain of the programme.
With five funds of $20.00 million each, returning 2.20x, 1.80x, 1.30x, 0.80x and 0.60x, a 5% carry is $1.70 million pooled on the $34.00 million net gain and $2.30 million fund by fund on the three winners’ $46.00 million. The structure costs the investor $0.60 million more, 0.60% of commitments; if the worst fund returns 0.20x the difference reaches $1.00 million.
| Fund | Commitment | Net multiple | Proceeds | Gain or loss |
|---|---|---|---|---|
| Fund A | 20.00 | 2.20x | 44.00 | 24.00 |
| Fund B | 20.00 | 1.80x | 36.00 | 16.00 |
| Fund C | 20.00 | 1.30x | 26.00 | 6.00 |
| Fund D | 20.00 | 0.80x | 16.00 | -4.00 |
| Fund E | 20.00 | 0.60x | 12.00 | -8.00 |
| Programme | 100.00 | 1.34x | 134.00 | 34.00 |
The fund of funds charges 5% carried interest. To isolate the point, no preferred return is applied: with a hurdle the amounts change, the comparison does not.
A pooled calculation charges carry on the net gain of the programme, so the losing funds reduce the base.
Pooled carry = carry rate × max(0, sum of gains − sum of losses)
Excel: =Rate*MAX(0,SUM(GainLoss))
The gains are 46.00 and the losses 12.00, so the net gain is 34.00 and the carry is 0.05 × 34.00 = $1.70 million.
A fund-by-fund calculation charges carry on each profitable fund separately and ignores the losses of the others.
Fund-by-fund carry = carry rate × sum of the positive gains
Excel: =Rate*SUMIF(GainLoss,">0")
The three winners gained 24.00 + 16.00 + 6.00 = 46.00, so the carry is 0.05 × 46.00 = $2.30 million.
| Basis | Carry | Net proceeds | Net multiple |
|---|---|---|---|
| Pooled | 1.70 | 132.30 | 1.323x |
| Fund by fund | 2.30 | 131.70 | 1.317x |
| Difference | 0.60 | −0.60 | −0.006x |
The fund-by-fund basis costs $0.60 million more, 0.60% of commitments and 35.3% more carry than the pooled basis. The losses of 12.00 are 26.1% of the gains and the extra carry is the same share of the carry on the gains: 0.05 × 12.00 = 0.60.
Fund E now loses 16.00 instead of 8.00. The pooled net gain falls to 26.00 and the pooled carry to $1.30 million; the fund-by-fund carry stays at $2.30 million because the winners are unchanged. The gap widens from 0.60 to $1.00 million: under a fund-by-fund basis the investor pays carry on gains the programme has already lost.
Pooled carry applies the rate to the net gain of the whole programme, so losses reduce the base. Fund-by-fund carry applies it to each profitable fund separately. In the example the first is $1.70 million and the second $2.30 million.
The carry rate times the losses of the losing funds. At 5% on $12.00 million of losses the extra cost is $0.60 million, or 0.60% of commitments.
Only if it is enforced and secured: it returns carry paid in excess at the end of the programme, but it depends on the manager still holding the cash or on a guarantee.
Run the numbers yourself: the free distribution waterfall model splits fund profits between investors and the manager in Excel, with preferred return, catch-up and carried interest. For a closed-end fund with up to eight assets, fees and a European or American waterfall, see the Real Estate Fund Model, Pro Edition ($129).
The free companion files for The Fund of Funds Investor rebuild Larkspur Private Markets Fund IV, the fictional $600 million fund of funds, with its primaries, secondaries, co-investments, second layer of fees and carry, J-curve and gross and net returns. The carry comparison in this article uses invented funds and is not in them. No account and no email address.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: private equity and private markets → · All 1908 articles →