Most write-ups state the catch-up formula then hardcode the answer. Set it as a solve and it moves on its own when the carry rate does.
The catch-up is not a figure you look up. It is the solution to an equation, and the equation is small enough to write on one line: C ÷ (pref + C) = carry rate. Set it in a cell as a solve rather than as an answer, and it moves on its own the day someone changes the carry rate.
A GP catch-up exists to fix an arithmetic problem created by the preferred return. Once the limited partners have been paid their capital back and then a preferred return on top of it, the general partner has received nothing — and the deal was that the general partner receives a fixed share of profit. The catch-up is the tier that closes that gap before the ordinary split begins.
The common error is to compute the catch-up as the carry rate multiplied by the preferred return. On a $10m preferred at 20% carry, that gives $2.0m. It is wrong, and it is wrong in a direction that costs the general partner money.
The reason is that the catch-up is itself part of the profit being shared. After the catch-up is paid, the general partner has received C, and total profit distributed so far is the preferred plus the catch-up. For the general partner to hold its contractual share of that, you need:
C ÷ (pref + C) = carry rate
On a $10m preferred at 20%: C ÷ ($10m + C) = 0.20, so C = $2.0m + 0.20C, so 0.80C = $2.0m, and C = $2.5m.
Two and a half million, not two. The half million is the catch-up catching up on itself.
A fund has drawn $100m of capital and is distributing $160m. The preferred return accrued is $10m. Carried interest is 20% with a full catch-up.
| Tier | Amount | To LPs | To GP |
|---|---|---|---|
| 1. Return of contributed capital | $100.0m | $100.0m | — |
| 2. Preferred return | $10.0m | $10.0m | — |
| 3. GP catch-up | $2.5m | — | $2.5m |
| 4. Residual split, 80/20 | $47.5m | $38.0m | $9.5m |
| Total | $160.0m | $148.0m | $12.0m |
Total profit is $160m less $100m of capital, or $60m. The general partner has received $12.0m, which is exactly 20% of $60m. That is the test the catch-up exists to pass, and it passes to the dollar.
How to check any waterfall in ten seconds: total profit, multiply by the carry rate, compare with what the general partner actually received. If a full catch-up has cleared, the two must be equal. If they are not, either the catch-up has not cleared or a tier is wrong.
Here is the payoff for setting the catch-up as a solve. Change nothing but the carry rate:
| Carry rate | Catch-up | Residual | Total to GP | GP share of profit |
|---|---|---|---|---|
| 15% | $1.76m | $48.24m | $9.00m | 15.0% |
| 20% | $2.50m | $47.50m | $12.00m | 20.0% |
| 25% | $3.33m | $46.67m | $15.00m | 25.0% |
A model with $2.5m hardcoded in the catch-up cell produces a wrong answer at 15% and at 25%, and produces it silently. Nothing errors. The total still ties to the distribution, because the residual absorbs the difference. Only the split is wrong.
The catch-up is a rounding difference next to the tier above it. A preferred return can be written as a simple annual percentage on contributed capital, or it can compound, and the drafting is not always as clear as the number.
On one worked capital and distribution profile, an 8% preferred return that compounds accrues $37.2m where a flat, non-compounding reading of the same clause gives $10m. That is a $27m difference in a tier that sits entirely ahead of the general partner, on the same document and the same cash flows.
Which is the point worth taking away. The catch-up is the tier people argue about because it is the one with an equation in it. The preferred return is where the money is, and it turns on compounding, on the base it is calculated against, and on whether it accrues on committed or contributed capital.
Every figure above is a live formula in the companion files for The Private Equity Fund Controller Playbook. Change one input and the rest of the sheet answers. They are free, and they need no account and no email address.