IRR, MOIC and carried interest on an $8.4 billion take-private, from exit value to the LP's net

The Clearwater Analytics buyout built up from the exit: the exit multiple and EBITDA, the bridge to exit equity, the management pool, each investor's return, and what the LPs keep after fees and carry.

Compound Research · Updated Oct 22, 2026 · 11 min read

Short answer

On the outside-in case, the Clearwater take-private exits in 2030 at the 25.0x multiple paid on $636 million of next-year EBITDA: $15.9 billion of enterprise value and $13.6 billion of equity, a 21.1% IRR and 2.37x on $5.74 billion invested. After an illustrative management pool, the sponsors make 19.8%; after 2% fees and 20% carry, the LPs net 15.0% and 1.85x. On management's plan, 32.4% gross becomes 24.7% net.

Try this prompt free
On this page (10)
  1. 1. The exit assumptions
  2. 2. From exit EBITDA to the sponsors' proceeds
  3. 3. Should the model assume a management incentive plan?
  4. 4. Returns by investor
  5. 5. When to sell
  6. 6. The fund's waterfall
  7. 7. Gross to net
  8. 8. The LP's view: TVPI, DPI and the J-curve
  9. 9. Computing the IRR in Excel
  10. 10. FAQ

Permira and Warburg Pincus took Clearwater Analytics private on June 25, 2026, at $24.55 a share, with $5.74 billion of equity. The LBO model builds the deal on management’s plan and on an outside-in case. This page follows the equity from exit to the LPs: what the business is sold for, what is left for equity, who gets it, and what the fund’s investors keep.

  • MOIC: cash returned divided by cash invested, with no time value.
  • IRR: the annual rate at which the equity cash flows net to zero, so it rewards a shorter hold.
  • Carried interest: the general partner’s share of the fund’s profit, paid through its distribution waterfall.
  • TVPI and DPI: the LP’s distributions plus remaining value, and distributions alone, each over capital paid in.
Prompt“Using the LBO model in this data room, build the sponsor's returns from the exit: the exit multiple and EBITDA, exit enterprise value, net debt and exit equity, a value-creation bridge, an illustrative management incentive pool, each equity investor's proceeds, IRR and MOIC by exit year on dated cash flows, and a European and an American carried interest waterfall with clawback to the LP's net MOIC, IRR, TVPI and DPI. Label every assumption.”

The exit assumptions

Both cases sell at the end of 2030, 4.5 years after close, at the multiple paid: 25.0x next-year EBITDA on the outside-in case and 24.8x on management’s plan. The cases differ in the EBITDA the multiple is applied to: $636 million against $897 million.

CWAN Returns and Fund Waterfall.xlsx
BCD
1$MOutside-in caseManagement plan
2Exit date31-Dec-3031-Dec-30
3Hold from the 25-Jun-26 close4.5 years4.5 years
4FY2030 revenue1,4801,810
5FY2030 adjusted EBITDA (pre-SBC)573764
6FY2030 EBITDA margin38.8%42.2%
7Next-year (FY2031) EBITDA, the exit metric636897
8Exit multiple: EV / next-year EBITDA25.0x24.8x
9Memo: entry multiple, TEV / FY2026 EBITDA25.0x24.8x
LBO Inputs
Exit assumptions at a FY2030 exit, millions. Each case exits at the multiple paid on its own 2026 EBITDA, so neither assumes the next buyer pays more. From Compound's LBO Inputs tab, copied from the LBO model.

The exit metric is next-year (2031) EBITDA because the entry multiple was struck on next-year (2026) EBITDA; pricing both ends on the same basis keeps a growing business from earning a return from the change in basis alone. Holding the multiple flat is the conservative choice for a business bought at 25x: a buyer in 2030 paying less is the main risk to the return, which the sensitivity analysis prices.

From exit EBITDA to the sponsors’ proceeds

On the outside-in case, $636 million at 25.0x is a $15.9 billion enterprise value; $2.3 billion of net debt leaves $13.6 billion of equity, 2.37x the $5.74 billion invested and a 21.1% IRR. After the management pool, the sponsors keep $13.0 billion: 2.26x and 19.8%.

CWAN Returns and Fund Waterfall.xlsx
BCD
1$MOutside-in caseManagement plan
2Next-year EBITDA636897
3(×) Exit multiple25.0x24.8x
4Exit enterprise value15,92722,195
5(–) Net debt at exit(2,310)(1,777)
6Exit equity value13,61720,419
7(–) Management incentive pool(630)(1,175)
8Proceeds to the sponsors12,98719,244
9
10Sponsor equity invested5,7375,737
11MOIC, before the pool2.37x3.56x
12IRR, before the pool21.1%32.4%
13MOIC, after the pool2.26x3.35x
14IRR, after the pool19.8%30.7%
Equity Funding
From exit EBITDA to the sponsors' proceeds at a FY2030 exit, millions. Net debt includes the PIK interest accrued to June 2028. The incentive pool is illustrative (next section). Returns are XIRR on the dated cash flows: equity in on June 25, 2026, proceeds out on December 31, 2030. From Compound's LBO Inputs and Equity Funding tabs.

Revenue growth creates 78% of the gain on the outside-in case and margin 17%; debt paydown adds only $315 million, because the free cash flow mostly pays interest.

Outside-in case: from equity invested to the sponsors' proceeds, FY2030 exit

Each driver valued at the 25.0x entry multiple

Equity invested$5.7BRevenue growth+$6.2BMargin expansion+$1.4BDebt paydown, cash and other+$0.3BIncentive pool-$0.6BSponsor proceeds2.26x, 19.8% IRR$13BAxis starts at $4.6B

No multiple change: the exit multiple equals the entry multiple. Other is the $197.9 million of deferred awards assumed at close less $178.1 million of merger costs and financing fees. From Compound's Value Creation tab.

CWAN Returns and Fund Waterfall.xlsx
BCD
1$MOutside-in caseManagement plan
2Sponsor equity invested5,7375,737
3(+) Revenue growth, at entry margin and multiple6,18510,309
4(+) Margin expansion, at entry multiple1,3603,505
5(+) Multiple change––
6(+) Debt paydown and cash build315848
7(+) Deferred awards assumed, less fees2020
8Exit equity value13,61720,419
9(–) Management incentive pool(630)(1,175)
10Proceeds to the sponsors12,98719,244
Value Creation
Where the gain comes from at a FY2030 exit, millions. Each driver is valued at the entry multiple, so multiple change is zero when the exit multiple equals the entry multiple. Deferred awards are the unvested RSU and PSU cash awards the buyer assumed at close, $197.9 million that the sponsors did not fund; they are shown net of the $178.1 million of merger costs and financing fees. From Compound's Value Creation tab.

Should the model assume a management incentive plan?

Yes. The proxy commits the buyer to a management equity program, so a returns model that leaves it out overstates the sponsors’ share: an illustrative 8% of the value created takes $630 million at a 2030 exit on the outside-in case and 1.3 points of IRR.

Management rolled no equity: the executives’ closing Form 4s show every share and award disposed of at $24.55. Shares, options and vested awards were paid in cash at closing; unvested RSUs and PSUs, part of the $197.9 million of such awards company-wide, became cash awards paid as they vest. The merger proxy says only that Parent agreed to set up “a customary long-term equity-based incentive program” for key employees after closing, with its terms not yet determined. The model assumes a pool of 8% of exit equity value above the sponsors’ invested equity, vesting over five years and accelerating on a sale. Because it shares in value above cost, it costs more in the better case: $1.17 billion and 1.7 points of IRR on management’s plan.

CWAN Returns and Fund Waterfall.xlsx
BCDEFG
1Exit at year-endFY2027FY2028FY2029FY2030FY2031*
2Outside-in case
3Exit equity value8,61710,25211,87813,61715,448
4Value above invested equity2,8804,5156,1417,8809,711
5(–) Incentive pool, 8% of value above cost(230)(361)(491)(630)(777)
6Pool, % of exit equity2.7%3.5%4.1%4.6%5.0%
7Sponsor MOIC, after pool1.46x1.72x1.98x2.26x2.56x
8Sponsor XIRR, after pool28.4%24.1%21.5%19.8%18.5%
9Cost to sponsor XIRR (bps)(231)(178)(147)(126)(111)
10
11Management plan
12Exit equity value10,15613,22516,72320,41924,553
13Value above invested equity4,4197,48810,98614,68218,816
14(–) Incentive pool, 8% of value above cost(354)(599)(879)(1,175)(1,505)
15Pool, % of exit equity3.5%4.5%5.3%5.8%6.1%
16Sponsor MOIC, after pool1.71x2.20x2.76x3.35x4.02x
17Sponsor XIRR, after pool42.3%36.7%33.4%30.7%28.6%
18Cost to sponsor XIRR (bps)(336)(254)(206)(172)(148)
Equity Funding
Illustrative management incentive pool, millions: 8% of exit equity value above the sponsors' invested equity, five-year ratable vesting that fully accelerates on a sale. The proxy confirms a post-closing program but sets no terms; these are assumptions. *FY2031 needs FY2032 EBITDA, which the LBO forecast does not reach, so it is extrapolated at FY2031 growth and margin and is indicative. From Compound's Equity Funding tab.

Returns by investor

Four investors fund the $5.74 billion, Permira 44% and Warburg Pincus 31%. With no rollover and one class of equity, each earns the same 2.26x and 19.8% after the pool on the outside-in case; Permira’s $2.50 billion returns $5.67 billion.

CWAN Returns and Fund Waterfall.xlsx
BCDEF
1$MEquity fundedShareOutside-inManagement
2Permira2,504.243.6%5,6698,400
3Warburg Pincus1,775.530.9%4,0195,956
4Francisco Partners728.712.7%1,6492,444
5Temasek728.712.7%1,6492,444
6Management rollover––––
7Total5,737.0100.0%12,98719,244
8MOIC, each investor (after the pool)2.26x3.35x
9IRR, each investor (after the pool)19.8%30.7%
Equity Funding
Equity by investor, millions. The four equity commitment letters in the merger proxy (DEFM14A) total $5,905.0 million; the model funds $5,737.0 million, against approximately $5.7 billion in the closing 8-K, and cuts each letter pro rata, an assumption since the proxy leaves the split to the sponsors. Outside-in and Management columns are each investor's proceeds at a FY2030 exit after the illustrative management incentive pool, pro rata to funded equity. No rollover per the executives' closing Form 4s. From Compound's Equity Funding tab.

The model funds $5.74 billion of equity and pays $7.44 billion to shareholders at closing, against about $5.7 billion and $7.4 billion in the closing 8-K. The equity price is $7.64 billion; the gap is $197.9 million of unvested RSU and PSU cash awards that the merger agreement pays as they vest after closing, so the company, not the sponsors’ equity, funds them, inside the stock-based compensation the model already treats as a cash cost.

When to sell

MOIC keeps rising but each extra year earns less: on the outside-in case the year to 2029 returns 15.9% on the equity left in and the year to 2030 returns 14.6%, below the 21.1% the deal earns to 2030.

CWAN Returns and Fund Waterfall.xlsx
BCDEFG
1Exit at year-endFY2027FY2028FY2029FY2030FY2031*
2Outside-in case
3Exit equity value8,61710,25211,87813,61715,448
4Value added in the year2,8801,6351,6261,7391,831
5MOIC1.50x1.79x2.07x2.37x2.69x
6XIRR, close to exit30.7%25.9%23.0%21.1%19.7%
7Marginal IRR of the extra year30.7%18.9%15.9%14.6%13.4%
8
9Management plan
10Exit equity value10,15613,22516,72320,41924,553
11Value added in the year4,4193,0693,4983,6964,134
12MOIC1.77x2.31x2.91x3.56x4.28x
13XIRR, close to exit45.7%39.3%35.5%32.4%30.1%
14Marginal IRR of the extra year45.7%30.1%26.4%22.1%20.2%
Deal Returns
Returns by exit year, millions. The marginal IRR is the return on the equity value left in for one more year: exit value in the year over exit value a year earlier; FY2027 runs from close. *FY2031 needs FY2032 EBITDA, which the LBO forecast does not reach, so it is extrapolated at FY2031 growth and margin and is indicative. From Compound's Deal Returns tab.

Marginal IRR of holding one more year

Return on the equity left in for the year ending at each exit

Management planOutside-in caseManagement FY202830.1%Outside-in FY202818.9%FY2028Management FY202926.5%Outside-in FY202915.9%FY2029Management FY203022.1%Outside-in FY203014.6%FY2030Management FY2031*20.2%Outside-in FY2031*13.5%FY2031*

FY2031 is indicative (extrapolated FY2032 EBITDA). From Compound's Deal Returns tab.

On management’s plan the marginal year stays above 20% through 2031, so the case for holding rests on which plan the sponsor believes. On the outside-in case, every year after 2027 earns less than a 20% target on the equity left in, which argues for an earlier sale if a buyer pays the same multiple.

The fund’s waterfall

On the outside-in case, $12.99 billion of proceeds pays the LPs $11.65 billion and the GP $1.33 billion of carry, exactly 20% of the fund’s profit. Deal by deal, the GP would take $115 million more at exit and return it through the clawback.

CWAN Returns and Fund Waterfall.xlsx
BCD
1$MEuropeanAmerican
2Outside-in case
3Distributable proceeds, after the pool12,98712,987
4Tier 1: return of capital to LPs6,3135,737
5Tier 2: 8% preferred return to LPs2,5252,387
6Tier 3: 100% GP catch-up631597
7Tier 4: residual, 80% LP / 20% GP3,5174,266
8LP distributions11,65211,537
9GP carry, before clawback1,3351,450
10(–) Clawback at fund wind-up–(115)
11GP carry, after clawback1,3351,335
12Paid-in capital (deal equity and fees)6,3136,313
13
14Management plan
15Distributable proceeds, after the pool19,24419,244
16Tier 1: return of capital to LPs6,3135,737
17Tier 2: 8% preferred return to LPs2,5252,387
18Tier 3: 100% GP catch-up631597
19Tier 4: residual, 80% LP / 20% GP9,77410,523
20LP distributions16,65816,543
21GP carry, before clawback2,5862,701
22(–) Clawback at fund wind-up–(115)
23GP carry, after clawback2,5862,586
24Paid-in capital (deal equity and fees)6,3136,313
Fund Waterfall
Distribution waterfall at a FY2030 exit, millions, with the deal as the fund's only investment. Illustrative LPA terms: 2% management fee, 8% compounding preferred return, 100% GP catch-up, 80/20 carry. European returns paid-in capital and fees first; American returns each deal's capital and preferred return, then a clawback trues the GP up to whole-fund carry. From Compound's Returns Output tab.
  • European (whole-fund): LPs get back all paid-in capital, including the $576 million of management fees, and an 8% preferred return on it before the GP’s catch-up starts.
  • American (deal-by-deal): each deal returns its own capital and preferred return first, so fees are not repaid before carry. The GP is paid earlier and owes the excess back at fund wind-up through the clawback.
  • Fund terms, all illustrative: a 2% fee on $6.37 billion of commitments through a five-year investment period, then on invested capital; an 8% preferred return compounding from each contribution; a 100% catch-up; 80/20 above it. The deal is treated as the fund’s only investment, so the American clawback returns the GP exactly to the European result.

Gross to net

The 21.1% gross IRR becomes 15.0% for the LPs on the outside-in case: carry takes 286 basis points, fees 194 and the incentive pool 126. On management’s plan, 32.4% becomes 24.7%.

CWAN Returns and Fund Waterfall.xlsx
BCD
1FY2030 exitMOICXIRR
2Outside-in case
3Gross, deal (before the pool)2.37x21.1%
4Gross, after the incentive pool2.26x19.8%
5LP, net of fees, before carry2.06x17.9%
6LP net, European1.85x15.0%
7LP net, American, before clawback1.83x14.7%
8(–) Incentive pool (bps)(126)
9(–) Management fees (bps)(194)
10(–) Carried interest (bps)(286)
11Gross-to-net spread(0.53x)(606)
12
13Management plan
14Gross, deal (before the pool)3.56x32.4%
15Gross, after the incentive pool3.35x30.7%
16LP, net of fees, before carry3.05x28.8%
17LP net, European2.64x24.7%
18LP net, American, before clawback2.62x24.5%
19(–) Incentive pool (bps)(172)
20(–) Management fees (bps)(186)
21(–) Carried interest (bps)(413)
22Gross-to-net spread(0.92x)(772)
Fund Waterfall
Gross to net at a FY2030 exit. Each step is a separate dated cash flow series run through XIRR; the spread splits the gross-to-LP-net gap by step. From Compound's Fund Waterfall and Returns Output tabs.

Carry takes a larger share of the spread in the better case, 413 of 772 basis points on management’s plan, because it is a share of profit; fees are fixed in dollars and cost less as the return rises.

The LP’s view: TVPI, DPI and the J-curve

The LP pays in $6.31 billion before seeing a dollar back: TVPI rises on marks from 0.99x at close to 1.64x by 2029 on the outside-in case, but DPI stays at zero until the 2030 exit realizes 1.85x.

CWAN Returns and Fund Waterfall.xlsx
BCDEFGH
1$MCloseFY2026FY2027FY2028FY2029FY2030
2Outside-in case
3Capital and fees called(5,803)(127)(128)(127)(127)–
4Distributions–––––11,652
5Cumulative net cash flow (J-curve)(5,803)(5,931)(6,058)(6,186)(6,313)5,339
6Residual value to LPs (NAV after accrued carry)5,7376,8907,9219,15010,372–
7DPI0.00x0.00x0.00x0.00x0.00x1.85x
8RVPI0.99x1.16x1.31x1.48x1.64x0.00x
9TVPI0.99x1.16x1.31x1.48x1.64x1.85x
10
11Management plan
12Capital and fees called(5,803)(127)(128)(127)(127)–
13Distributions–––––16,658
14Cumulative net cash flow (J-curve)(5,803)(5,931)(6,058)(6,186)(6,313)10,345
15Residual value to LPs (NAV after accrued carry)5,7377,2339,05411,33813,938–
16DPI0.00x0.00x0.00x0.00x0.00x2.64x
17RVPI0.99x1.22x1.49x1.83x2.21x0.00x
18TVPI0.99x1.22x1.49x1.83x2.21x2.64x
LP View
The LP's position by year to a FY2030 exit, European waterfall, millions. Residual value marks the equity at the LBO's implied value each year, less the incentive pool and the carry a liquidation on that date would pay. From Compound's LP View tab.

LP net TVPI by year

Marked to the LBO's implied equity value until the FY2030 exit, then realized as DPI

Management planOutside-in caseManagement Close1.0xOutside-in Close1.0xCloseManagement FY20261.2xOutside-in FY20261.2xFY2026Management FY20271.5xOutside-in FY20271.3xFY2027Management FY20281.8xOutside-in FY20281.5xFY2028Management FY20292.2xOutside-in FY20291.6xFY2029Management FY20302.6xOutside-in FY20301.8xFY2030

European waterfall, illustrative LPA terms; net of fees, the incentive pool and accrued carry. From Compound's LP View tab.

The J-curve is the cumulative net cash line: fees and capital calls push it down to ($6.31 billion) in 2029, and the single exit distribution lifts it to $5.34 billion on the outside-in case. TVPI does not dip below 1.0x after closing because the residual value is marked to the LBO’s implied equity value each year; a fund carrying the deal at cost until exit would show the J-curve in TVPI as well.

Computing the IRR in Excel

Every IRR on this page is XIRR on the actual dates: equity in on June 25, 2026 and proceeds out at the year-end exit. Excel’s IRR() treats each column as a full year, so it counts the six-month stub to December 2026 as a year and understates the 2030 return by 220 basis points, 18.9% against 21.1%. Without leverage, the deal earns 18.1% on the outside-in case and 27.3% on management’s plan, so the term loan adds 3.0 and 5.2 points.

Methodology. Exit values, debt and the sponsors’ equity come from the LBO model for both cases, each exiting at the multiple paid on its own 2026 EBITDA (25.0x outside-in, 24.8x management), and tie to it with no difference at every exit year. Equity commitments, the treatment of unvested awards, the absence of a management rollover and the incentive program’s existence are from the merger proxy (DEFM14A, April 8, 2026), the executives’ closing Form 4s and the closing 8-K. Everything about the fund, and the incentive pool’s terms, is illustrative and labeled in the workbook: Clearwater’s sponsors do not publish their LPAs. The model was built in Compound; it rebuilds work a deal team or fund could have done and is not the buyers’ or their funds’ numbers.

Returns and fund waterfall workbook (Excel)Compound’s workbook from this run: a one-page Returns Output, the exit build and returns by investor, equity funding, the value creation bridge, the fund waterfall and the LP’s net view.Draft: this template comes from the page's Compound run

FAQ

Why use XIRR rather than IRR in an LBO?
IRR() assumes evenly spaced periods, so a stub between the close and the first year-end counts as a full year and understates the return. XIRR takes each cash flow’s date. Here the gap is 220 basis points at a 2030 exit and 818 at a 2027 exit.
What is the difference between a European and an American waterfall?
A European waterfall pays carry only after LPs have their whole paid-in capital, fees included, and the preferred return across the fund. An American waterfall pays carry deal by deal, so the GP is paid sooner and a clawback at fund wind-up recovers any excess. With one deal, the clawback here is $115 million.
Why is the LP's net return so far below the deal's gross return?
Three layers sit between them: the management incentive pool, which is paid before the fund sees proceeds; management fees, which are called whether or not the deal makes money; and carried interest on the profit. On this deal they take 1.3, 1.9 and 2.9 points of IRR.
What is the difference between MOIC and TVPI?
MOIC measures a deal: proceeds over equity invested. TVPI measures the LP’s position in the fund: distributions plus remaining value over everything paid in, fees included, after carry. Here a 2.37x MOIC is a 1.85x TVPI.
CoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix Research

See this workflow on your own deal