LBO model example: an $8.4 billion take-private

The purchase price, financing, debt and returns of Clearwater Analytics' take-private, on management's plan and on an outside-in case.

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

Short answer

On an outside-in case built from Clearwater Analytics' own record, the $24.55 take-private returns a 21.1% IRR and 2.4x MOIC on a 2030 exit at the 25x forward multiple paid; management's plan gives 32.4%. The gap is growth: the outside-in case reaches $1.48 billion of 2030 revenue against management's $1.81 billion.

Try this prompt free
On this page (8)
  1. 1. The purchase price
  2. 2. Sources and uses
  3. 3. Ownership at close
  4. 4. Management's plan against the outside-in case
  5. 5. Deleveraging
  6. 6. Returns
  7. 7. Sensitivities
  8. 8. FAQ

Permira and Warburg Pincus took Clearwater Analytics private on June 25, 2026, at $24.55 a share. The merger proxy prints management’s forecast to 2030 and the financing terms. This model runs the deal twice: on management’s plan, and on an outside-in case built only from what Clearwater had reported. The operating history comes from the three-statement model.

Three things decide the return. Organic growth matters most: every 2 points a year moves the IRR by about 3.5 points, and Clearwater’s core ARR grew 17.7% in 2025 while the acquired base grew 8.5%. Exit multiple comes next, because the sponsor paid 25x forward EBITDA and the model assumes the next buyer pays the same. Margin matters least of the three: 2 points move the IRR about 2 points, and the Enfusion and Beacon integration is where the expansion has to come from.

Prompt“Build an LBO model of [company]'s take-private from the merger proxy: a purchase price build from the share and award counts, sources and uses from the commitment letters, management's forecast and an outside-in case from the company's own record, the term loan with its margin, floor, PIK and step-downs, cash taxes, a cash sweep, returns by exit year for both cases with a returns bridge, and IRR sensitivities to entry and exit multiple, growth and margin. Cite every input.”

The purchase price

The $24.55 offer buys 311.1 million fully diluted shares for $7.64 billion; with existing debt net of cash, enterprise value is $8.38 billion, 25.0x outside-in 2026 EBITDA and 29.9x the last twelve months. $7.44 billion is paid at closing; $198 million of unvested awards is paid in cash as they vest.

CWAN LBO Model.xlsx
BCDEF
1Shares (M)$MPaid at closingPaid as vested
2Offer price per share$24.55
3Class A shares288.67,0867,086–
4OpCo units exchanged into Class A4.5111111–
5RSUs8.521012683
6PSUs at maximum performance4.098–98
7Options, net shares (7.6M at $9.09)4.8117117–
8Enfusion awards committed at signing0.717–17
9Equity purchase price311.17,6387,440198
10(+) Existing debt825
11(–) Cash, March 31, 2026(82)
12Transaction enterprise value8,382
13
14TEV / FY2026E adjusted EBITDA, Management24.8x
15TEV / FY2026E adjusted EBITDA, Outside-in25.0x
16TEV / LTM March 2026 adjusted EBITDA29.9x
LBO Output
Purchase price build, millions. Share and award counts at December 15, 2025 from the merger proxy (DEFM14A, pp. 20 and A-10), with the Enfusion awards from the SC 13E-3 exhibits; options by the treasury stock method at a $9.09 weighted average strike; RSUs released before closing from the Q1 2026 10-Q; debt and cash from the Q1 2026 10-Q. From Compound's LBO Output tab.

The share and award counts are from the merger agreement’s capitalization representation at December 15, 2025 (proxy Annex A); the agreement sets how each class is paid, and when:

  • Class A shares, 288.6 million, each converted into $24.55 in cash.
  • OpCo units, 4.5 million, exchanged one for one into Class A just before closing; the paired Class B shares are canceled for nothing, so they are counted once.
  • RSUs, 8.5 million, each converted into a $24.55 cash award. Vested RSUs and directors’ RSUs are paid at closing; unvested ones keep their vesting schedule and are paid in cash as they vest. About 5.1 million vested before closing and were paid as shares; 3.4 million are paid later.
  • PSUs, 4.0 million, counted at the maximum performance level, which the merger agreement deems achieved (110% of target on the executives’ Form 4s). All are unvested, so all are paid as they vest.
  • Options, 7.6 million at a $9.09 weighted average strike, cashed out at the $24.55 offer less the strike. That cash equals 4.8 million shares at the offer (7.6 million × ($24.55 − $9.09) / $24.55), the treasury stock method. Using the average strike assumes every option is in the money; any option struck above $24.55 is canceled for nothing. Options are paid at closing whether vested or not.
  • Enfusion awards, 0.7 million, $16.7 million of awards promised before signing, which the merger agreement treats like RSUs; the model treats them as unvested.

The split between closing and later matters for the financing. By May 4, 2026, Class A and Class B shares had risen 5.3 million from December to 298.5 million, mostly as RSUs vested and were released as shares (Q1 2026 10-Q); those holders were paid at closing like any other shareholder. The awards still unvested at closing, $198 million, are not funded at close: the company pays them in cash over about three years, out of the stock-based compensation the model already treats as a cash cost. Equity granted after December 20, 2025, such as the executives’ February 2026 RSUs, is outside the count; the proxy leaves its treatment to the company and Parent, so the model treats it as post-closing compensation.

Sources and uses

Equity is two-thirds of the capital: $5.74 billion against a $2.7 billion term loan, which is 9.6x trailing EBITDA but 32% of sources. The closing 8-K reports about $7.4 billion paid to shareholders and about $5.7 billion of equity; the model’s $7.44 billion and $5.74 billion are within that rounding.

CWAN LBO Model.xlsx
BCD
1$MAmount% of total
2Sources
3Term loan2,70031.7%
4Delayed-draw term loan ($500M)––
5Revolver ($325M)––
6Balance sheet cash821.0%
7Sponsor equity5,73767.3%
8Total sources8,519100.0%
9
10Uses
11Equity consideration paid at closing7,44087.3%
12Refinance existing debt8259.7%
13Minimum cash750.9%
14Company merger costs (proxy estimate)1241.5%
15Financing fees and OID (2.0% of term loan)540.6%
16Total uses8,519100.0%
17
18Memo: awards paid in cash as they vest198
LBO Output
Sources and uses at close, June 25, 2026, millions. Debt and equity from the commitment letters described in the merger proxy; merger costs are the company's estimate in the proxy; financing fees and minimum cash are the model's assumptions. Awards paid as they vest are part of the purchase price but not of the cash needed at closing. From Compound's LBO Output tab.
  • Term loan, $2.7 billion, sized in the amended debt commitment letter of January 21, 2026 and fully drawn at close. Priced at SOFR + 4.50% with a 0.50% floor; up to half the margin, plus 0.25%, can be paid in kind until June 2028, and the model assumes it is. The margin steps down 0.25% once first-lien net leverage is at or below 7.50x. Seven-year maturity, no amortization, 1% prepayment premium in the first year.
  • Delayed-draw term loan, $500 million, for acquisitions and capex after close, on the same terms, available until December 2028. Undrawn; the model assumes no further acquisitions.
  • Revolver, $325 million, of which $81 million is usable at close, with a 0.50% fee on undrawn commitments. Undrawn in both cases.
  • Equity, $5.9 billion committed across four letters (Permira $2.58 billion, Warburg Pincus $1.83 billion, Francisco Partners and Temasek $750 million each), funded at $5.74 billion, leaving $168 million undrawn.
  • Merger costs, $124.1 million, the company’s own estimate in the proxy, of which $105.8 million is financial advisory fees. The buyers’ own fees are not disclosed; financing fees and OID are assumed at 2.0% of the term loan.

Ownership at close

Permira holds 44% and Warburg Pincus 31%; management rolls no equity, so its upside after close comes only through an incentive program whose size has not been set.

CWAN LBO Model.xlsx
BCD
1$MEquity fundedOwnership
2Permira2,504.243.6%
3Warburg Pincus1,775.530.9%
4Francisco Partners728.712.7%
5Temasek728.712.7%
6Management rollover––
7Total equity5,737.0100.0%
LBO Output
Pro forma ownership at close, millions. The four equity commitment letters in the merger proxy (DEFM14A) total $5.9 billion; the model funds $5.74 billion and cuts each letter pro rata, an assumption since the proxy leaves the split to the sponsors. No rollover per the officers' closing Form 4s. Ownership is before the post-closing management incentive program.
  • No rollover. The consortium raised a rollover with the CEO, Sandeep Sahai, on the day of signing; he declined to discuss it then, and the proxy records no further talks. The executive officers’ Form 4s filed at close show every share, RSU, PSU and option cashed out at $24.55 and nothing left held; Sahai alone sold 1.4 million shares.
  • Management incentive program. Parent agreed to set up “a customary long-term equity-based incentive program” for key employees after close; the proxy says its terms, including who participates, have not been determined. The model shows returns before any dilution from it.
  • Cash retention. Separately, a cash retention program pays half at close and half a year later; the five named executives’ awards total $12.6 million.

Management’s plan against the outside-in case

Both cases start in the same place, but the outside-in case grows 10% to 14% a year instead of 17% to 18%, and its margin reaches 38.8% instead of 42.2%; by 2030, cash flow before interest is $364 million against $580 million.

CWAN LBO Model.xlsx
BCDEFGH
1$MFY26EFY27EFY28EFY29EFY30EFY31E
2Management plan (merger proxy)
3Revenue9421,1021,3001,5341,8102,100
4% growth28.8%17.0%18.0%18.0%18.0%16.0%
5Adjusted EBITDA (pre-SBC)339419519635764897
6% margin36.0%38.0%39.9%41.4%42.2%42.7%
7Cash flow after tax and capex93260353461580702
8
9Outside-in case
10Revenue9361,0641,1981,3371,4801,627
11% growth (FY26E vs. reported FY25)28.0%13.6%12.6%11.6%10.6%10.0%
12Adjusted EBITDA (pre-SBC)335395453514573636
13% margin35.7%37.2%37.8%38.4%38.8%39.1%
14Cash flow after tax and capex89227271318364413
15
16Outside-in vs. management
17Revenue(5)(38)(102)(196)(331)(473)
18% of management(0.6%)(3.5%)(7.9%)(12.8%)(18.3%)(22.5%)
19Adjusted EBITDA (pre-SBC)(4)(23)(66)(121)(191)(261)
20Margin difference (pp)(0.2)(0.8)(2.1)(3.0)(3.5)(3.6)
21Cash flow after tax and capex(4)(33)(82)(142)(216)(289)
LBO Output
Management's forecast (merger proxy, extended to FY2031 at 16% growth) against the outside-in case built from Clearwater's own record, millions. Cash flow after tax and capex, before interest; FY2026E from the June 25 close. From Compound's LBO Output tab.

The outside-in case starts from 2025 revenue of $817 million pro forma for a full year of Enfusion and Beacon. Organic growth of 14.6% in 2026 blends the 10-K’s two ARR growth rates, 17.7% for the core business and 8.5% for the acquired one, then fades a point a year to a 10% floor. The margin adds Clearwater’s 2021 to 2025 average gain of 1.3 points a year, capturing less of it each year, plus half of the roughly $20 million Enfusion cost target. Stock-based compensation stays at $128 million through 2027 as the unrecognized RSU expense runs off, then grows at half the rate of revenue, and is treated as a cash cost.

Deleveraging

On management’s plan, leverage falls from 8.1x to 2.4x by 2030; on the outside-in case it only reaches 4.2x, and interest coverage stays under 3x through 2030.

Gross leverage by case

Total debt / adjusted EBITDA

ManagementOutside-inManagement FY26E8.1xOutside-in FY26E8.2xFY26Management FY27E6.4xOutside-in FY27E6.9xFY27Management FY28E4.9xOutside-in FY28E5.9xFY28Management FY29E3.6xOutside-in FY29E5.0xFY29Management FY30E2.4xOutside-in FY30E4.2xFY30Management FY31E1.4xOutside-in FY31E3.4xFY31

Adjusted EBITDA before stock-based compensation. From Compound's LBO Output tab.

Interest coverage by case

Adjusted EBITDA / cash interest

ManagementOutside-inManagement FY26E2.1xOutside-in FY26E2.1xFY26Management FY27E2.6xOutside-in FY27E2.4xFY27Management FY28E2.8xOutside-in FY28E2.4xFY28Management FY29E3.4xOutside-in FY29E2.5xFY29Management FY30E4.7xOutside-in FY30E3.0xFY30Management FY31E7.3xOutside-in FY31E3.6xFY31

Adjusted EBITDA before stock-based compensation. From Compound's LBO Output tab.

CWAN LBO Model.xlsx
BCDEFGH
1$MFY26EFY27EFY28EFY29EFY30EFY31E
2Management plan (merger proxy)
3Total debt, including PIK2,7352,6912,5482,2731,8521,269
4(–) Cash877575757575
5Net debt2,6492,6162,4732,1981,7771,194
6Gross leverage (total debt / EBITDA)8.1x6.4x4.9x3.6x2.4x1.4x
7Net leverage (net debt / EBITDA)7.8x6.2x4.8x3.5x2.3x1.3x
8Interest coverage (EBITDA / cash interest)2.1x2.6x2.8x3.4x4.7x7.3x
9
10Outside-in case
11Total debt, including PIK2,7352,7292,6752,5582,3852,147
12(–) Cash837575757575
13Net debt2,6522,6542,6002,4832,3102,072
14Gross leverage (total debt / EBITDA)8.2x6.9x5.9x5.0x4.2x3.4x
15Net leverage (net debt / EBITDA)7.9x6.7x5.7x4.8x4.0x3.3x
16Interest coverage (EBITDA / cash interest)2.1x2.4x2.4x2.5x3.0x3.6x
LBO Output
Debt schedule by case, millions; EBITDA is adjusted EBITDA before stock-based compensation. 100% of excess cash sweeps the term loan from FY2027. From Compound's LBO Output tab.

The first two years are the tightest in either case: coverage starts at 2.1x, and the PIK lifts the term loan to $2.74 billion before the sweep begins in 2027. Cash taxes stay low because Clearwater’s $702 million deferred tax asset shelters income, within the 30% cap on interest deductions.

Returns

At the offer, the outside-in case returns 21.1% and 2.37x by 2030, against 32.4% and 3.56x on management’s plan; at a 22.5% target, a sponsor on the outside-in case would pay $23.59, 4% below the offer.

CWAN LBO Model.xlsx
BCDEF
1Exit at year-endFY2027FY2028FY2029FY2030
2Management
3Exit multiple (NTM EBITDA, = entry)24.8x24.8x24.8x24.8x
4NTM adjusted EBITDA519635764897
5Exit enterprise value12,84515,72218,92122,195
6(–) Net debt at exit(2,616)(2,473)(2,198)(1,777)
7(–) Unpaid deferred awards, after tax(73)(24)––
8Exit equity value10,15613,22516,72320,419
9Sponsor equity invested5,7375,7375,7375,737
10MOIC1.77x2.31x2.91x3.56x
11IRR45.7%39.3%35.5%32.4%
12
13Outside-in
14Exit multiple (NTM EBITDA, = entry)25.0x25.0x25.0x25.0x
15NTM adjusted EBITDA453514573636
16Exit enterprise value11,34412,87614,36115,927
17(–) Net debt at exit(2,654)(2,600)(2,483)(2,310)
18(–) Unpaid deferred awards, after tax(73)(24)––
19Exit equity value8,61710,25211,87813,617
20Sponsor equity invested5,7375,7375,7375,737
21MOIC1.50x1.79x2.07x2.37x
22IRR30.7%25.9%23.0%21.1%
LBO Output
Returns build by exit year at the $24.55 offer, millions. Each case exits at the multiple paid on its own FY2026E EBITDA, applied to next-year EBITDA; no management promote. An exit before the deferred RSU and PSU cash awards finish vesting (June 2029) leaves the unpaid balance, after its tax deduction, to the buyer. From Compound's LBO Output tab.

Almost all the value comes from EBITDA growth in both cases: $7.5 billion of the $7.9 billion gain on the outside-in case, $13.8 billion of $14.7 billion on management’s plan. Debt paydown adds $0.3 billion on the outside-in case, because its cash flow mostly services interest, and $0.8 billion on management’s.

Outside-in returns bridge, FY2030 exit

From sponsor equity in to equity out

Sponsor equity in$5.7BEBITDA growth+$7.5BDebt paydown, awards net of fees+$0.3BEquity out2.37x, 21.1% IRR$13.6BAxis starts at $4.6B

Exit at the 25.0x entry multiple, so multiple change is zero. From Compound's LBO Output tab.

Management plan returns bridge, FY2030 exit

From sponsor equity in to equity out

Sponsor equity in$5.7BEBITDA growth+$13.8BDebt paydown, awards net of fees+$0.9BEquity out3.56x, 32.4% IRR$20.4BAxis starts at $3.5B

Exit at the 25.0x entry multiple, so multiple change is zero. From Compound's LBO Output tab.

CWAN LBO Model.xlsx
BCD
1$MManagementOutside-in
2Sponsor equity in5,7375,737
3(+) EBITDA growth at the entry multiple13,8147,545
4(+) Multiple change––
5(+) Debt paydown and cash build848315
6(+) Deferred awards less fees at entry2020
7Equity out20,41913,617
8MOIC3.56x2.37x
9IRR32.4%21.1%
LBO Output
Returns bridge, FY2030 exit, millions. From Compound's LBO Output tab.

Sensitivities

Growth moves the return most: 2 points of revenue growth a year is worth about 3.5 points of IRR, more than 2 turns of exit multiple (2.6 points) or 2 points of margin (1.9 points).

IRR by exit multiple and revenue growth

Outside-in case, FY2030 exit

Exit multipleRevenue growth vs. case, every year
(4pp)(2pp)Base+2pp+4pp
21.0x8.4%12.1%15.7%19.2%22.6%
23.0x11.2%14.9%18.5%22.0%25.4%
25.0x13.8%17.5%21.1%24.6%28.0%
27.0x16.3%19.9%23.5%27.0%30.5%
29.0x18.5%22.2%25.8%29.3%32.8%

Green at or above a 20% IRR, red below; the boxed cell is the outside-in case at the $24.55 offer.

Excel data tables on Compound's LBO Output tab.

On the outside-in case, the deal needs the exit multiple to hold: a 2-turn de-rating takes the IRR to 18.5%, and paying 1 turn more at entry takes it to 19.6%.

IRR by entry and exit multiple

Outside-in case, FY2030 exit

Exit vs. entry multipleEntry multiple
23.0x24.0x25.0x26.0x27.0x
(4.0x)18.8%17.2%15.7%14.2%12.9%
(2.0x)21.7%20.0%18.5%17.0%15.7%
Flat24.3%22.7%21.1%19.6%18.2%
+2.0x26.8%25.1%23.5%22.0%20.6%
+4.0x29.2%27.4%25.8%24.2%22.8%

Green at or above a 20% IRR, red below; the boxed cell is the outside-in case at the $24.55 offer.

Excel data tables on Compound's LBO Output tab.

IRR by exit multiple and EBITDA margin

Outside-in case, FY2030 exit

Exit multipleEBITDA margin vs. case, every year
(4pp)(2pp)Base+2pp+4pp
21.0x11.7%13.7%15.7%17.5%19.2%
23.0x14.5%16.6%18.5%20.3%22.0%
25.0x17.1%19.2%21.1%22.9%24.6%
27.0x19.6%21.6%23.5%25.3%27.0%
29.0x21.8%23.8%25.8%27.6%29.3%

Green at or above a 20% IRR, red below; the boxed cell is the outside-in case at the $24.55 offer.

Excel data tables on Compound's LBO Output tab.

Growth and margin together: missing both by 2 points takes the IRR to 15.6%; beating both by 2 points gives 26.4%.

IRR by revenue growth and EBITDA margin

Outside-in case, FY2030 exit

Revenue growth vs. caseEBITDA margin vs. case
(4pp)(2pp)Base+2pp+4pp
(4pp)9.8%11.9%13.8%15.7%17.4%
(2pp)13.5%15.6%17.5%19.3%21.1%
Base17.1%19.2%21.1%22.9%24.6%
+2pp20.7%22.7%24.6%26.4%28.1%
+4pp24.1%26.1%28.0%29.9%31.6%

Green at or above a 20% IRR, red below; the boxed cell is the outside-in case at the $24.55 offer.

Excel data tables on Compound's LBO Output tab.

The DCF values management’s plan at $19.78 a share with 2.5% perpetual growth after 2035. The LBO clears 20% at $24.55 only because it sells in 2030 at the 25x multiple paid. The sponsor’s return rests on the next buyer valuing Clearwater as a growth software business.

Methodology. The purchase price, financing terms and management’s forecast are from Clearwater’s merger proxy (DEFM14A, April 8, 2026) and the commitment letters it describes; the outside-in case and the historicals are from the 10-K and 10-Q filings and the Enfusion investor presentation. Where the filings are silent, the model’s assumptions are labeled in the workbook: the outside-in growth fade and margin capture, the payout of unvested awards evenly to June 2029, financing fees and OID of 2.0% of the term loan, $75 million minimum cash, SOFR held flat at 3.53%, and management’s plan extended to 2031 at 16% growth. The model was built in Compound; it rebuilds work a deal team could have done and is not the buyers’ model.

The download is Compound’s completed workbook from this run, with Clearwater’s figures and every formula live.

LBO model workbook (Excel)Compound’s workbook from this run: Driver Assumptions with a row per case under each driver, the Model tab with the purchase price, sources and uses, debt waterfall and returns, a one-page LBO Output, and Clearwater’s historical statements.Draft: this template comes from the page's Compound run

FAQ

Why build an outside-in case when management's forecast is in the proxy?
Management’s forecast is the seller’s case, prepared for the sale. An outside-in case built from reported ARR, margins and cost history shows how much of the return depends on the plan being met; here, about 11 points of IRR.
Should an LBO model use LTM or forward EBITDA?
Either, as long as entry and exit use the same basis. A forward exit multiple applied to trailing EBITDA overstates the return of a growing business; this model uses next-year EBITDA at both ends.
Does an LBO need a full three-statement model?
A short-form LBO can run from EBITDA, cash taxes, capex and working capital, as this one does. A full balance sheet earns its place when working capital, deferred taxes or leases move the cash flow enough to change the debt paydown.
CoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix Research

See this workflow on your own deal