Debt schedule example: the $2.7 billion term loan behind a take-private

Every term of the loan that financed Clearwater Analytics' take-private, rolled forward a year at a time: PIK, cash sweep, the springing covenant and the financing choices, on management's plan, an outside-in case and a downside.

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

Short answer

The $2.7 billion term loan behind Clearwater Analytics' take-private starts at 9.6x trailing EBITDA, has no amortization and no maintenance covenant, and lets the sponsor pay half the margin in kind until June 2028. On an outside-in case, cash interest cover is 2.1x in 2026, and leverage reaches 4.2x by 2030 only because the sponsor chooses to sweep excess cash into the loan. In a downside with growth 3 points and margin 1.5 points lower each year, cash interest cover bottoms at 2.0x and the covenant is never tested.

Try this prompt free
On this page (7)
  1. 1. The terms
  2. 2. The schedule
  3. 3. Leverage and coverage
  4. 4. The covenant
  5. 5. Financing scenarios
  6. 6. A true downside
  7. 7. FAQ

Permira and Warburg Pincus financed the $8.4 billion take-private of Clearwater Analytics with $5.7 billion of equity and a $2.7 billion first-lien term loan from a group of private credit lenders. This page rolls that loan forward from the June 25, 2026 close, on the outside-in case and on management’s plan from the LBO model.

A lender reading the schedule would flag five things:

  • Leverage at close is 9.6x LTM March 2026 adjusted EBITDA of $280.5 million (9.4x first-lien net), and still 7.9x first-lien net at the end of 2026.
  • Cash interest cover is 2.1x in 2026 and 2.4x in 2027 and 2028. Counting the interest paid in kind, it is 1.5x and 1.7x.
  • $134.5 million of PIK interest accrues by June 2028, so total debt stays above the $2.7 billion funded until 2028.
  • No paydown is required. The loan has no amortization, and the excess cash flow sweep falls to zero once first-lien net leverage is at or below 7.50x, which the outside-in case reaches by the end of 2027. Every dollar repaid is the sponsor’s choice.
  • The one financial covenant is out of reach. It sits on the revolver, at 15.00x, and is tested only when net revolver usage exceeds $260 million.

A downside does not break the loan; it stops it from deleveraging. With growth 3 points and margin 1.5 points below the outside-in case every year, total debt stays above the $2.7 billion funded through 2029, and the downside section shows where the tests are missed.

Prompt“Build a debt schedule for [company]'s buyout from the debt commitment letter and the merger proxy: a term sheet tab with every term cited, each tranche rolled forward by year with PIK interest, the excess cash flow sweep and an optional sweep, the revolver as the plug, interest on average balances with a circularity switch, leverage, coverage and covenant headroom for each case, scenarios for paying the PIK in cash, drawing the delayed draw for an add-on, and SOFR up and down 100bp, and a downside operating case stressed with PIK paid in cash and SOFR up 200bp. Cite every term.”

The terms

The $3.5 billion package is one first-lien term loan with no amortization, a delayed draw for acquisitions and a revolver. The only financial covenant sits on the revolver.

CWAN Debt Schedule.xlsx
BCDE
1Term loanDelayed-draw term loanRevolver
2Size
3Commitment ($M)2,700500325
4Drawn at close ($M)2,700––
5Usable at close ($M)––81
6
7Pricing (% a year)
8Margin over SOFR4.50%4.50%4.50%
9SOFR floor0.50%0.50%0.50%
10Margin after step-down4.25%4.25%4.25%
11PIK portion of margin, to Jun-282.50%2.50%–
12Fee on undrawn–0.50%0.50%
13Fee on undrawn after year 1–1.00%–
14Fee on undrawn at ≤ 7.00x––0.25%
15
16Leverage tests (first-lien net leverage, x)
17Margin steps down at or below7.50x7.50x7.50x
18Draws allowed at or below–8.00x–
19Sweep falls to 25% at or below7.75x7.75x–
20Sweep falls to 0% at or below7.50x7.50x–
21Maximum, revolver covenant––15.00x
22
23Repayment and covenant terms
24Excess cash flow sweep (% of ECF)50%*50%*–
25AmortizationNoneNoneNone
26AvailabilityAt closeTo Dec-28Revolving
27MaturityJun-33Jun-33Jun-33
28Soft call (1%), months1212–
29Covenant trigger: net revolver use ($M)––260
Term Sheet
Debt terms from the amended and restated debt commitment letter (January 21, 2026) and the merger proxy (DEFM14A, pp. 95-99). Leverage tests are on first-lien net leverage: first-lien debt less cash, over adjusted EBITDA; every facility is first lien. The base excess cash flow sweep percentage and the fees sit in documents that are not filed; the model assumes 50% and 2.0% of the term loan. From Compound's Term Sheet tab.

* The base sweep percentage is set in a precedent credit agreement that is not filed; 50% is the model’s assumption.

The incurrence terms do more work than the covenant. Below 7.25x first-lien net leverage, which the outside-in case reaches at the end of 2027, the term sheet allows unlimited dividends to the sponsor. The loan can grow by the greater of $350 million and 100% of EBITDA without a ratio test, and by more at 8.00x first-lien net leverage or below. EBITDA for these tests can include planned synergies of up to 35% of Consolidated EBITDA.

The schedule

PIK interest accrues only until the option ends in June 2028, three fiscal years, and adds $134.5 million, so the term loan is still above the $2.7 billion funded at the end of 2027. From 2027, every dollar of paydown is the sponsor’s optional sweep.

CWAN Debt Schedule.xlsx
BCDEFGHI
1$MCloseFY26EFY27EFY28EFY29EFY30EFY31E
2Rates
3Term SOFR, held flat (%)3.5%3.5%3.5%3.5%3.5%3.5%
4Applicable margin (%)4.50%4.50%4.25%4.25%4.25%4.25%
5Share of year with PIK elected (%)100%100%48%0%0%0%
6Cash interest rate (%)5.78%5.78%6.75%7.78%7.78%7.78%
7PIK rate, to Jun-28 (%)2.50%2.50%1.15%–––
8
9Cash available for debt service
10FCF before interest89227271318364413
11(–) Cash interest and fees(83)(163)(188)(204)(193)(177)
12(+) Interest income on cash133333
13(+) Opening cash above the $75M minimum–8––––
14Cash available for debt service87485117174238
15
16Term loan
17Opening balance2,7002,7352,7292,6752,5582,385
18(+) PIK interest (option ends Jun-28)356831–––
19(–) Required excess cash flow sweep––––––
20(–) Optional prepayment–(74)(85)(117)(174)(238)
21Closing balance2,7002,7352,7292,6752,5582,3852,147
22Cash interest81158182204192176
23
24Delayed draw and revolver
25Delayed draw: drawn–––––––
26Delayed draw: undrawn, available to Dec-28500500500500–––
27Revolver: drawn–––––––
28Revolver: undrawn325325325325325325325
29
30Debt and leverage
31Total debt, including PIK2,7002,7352,7292,6752,5582,3852,147
32(–) Cash(75)(83)(75)(75)(75)(75)(75)
33Net debt2,6252,6522,6542,6002,4832,3102,072
34Total debt / adjusted EBITDA (x)9.6x8.2x6.9x5.9x5.0x4.2x3.4x
35First-lien net leverage (x)9.4x7.9x6.7x5.7x4.8x4.0x3.3x
Debt Schedule
Outside-in case, millions; fiscal years to December, FY2026 from the June 25 close. Interest on average balances; leverage on adjusted EBITDA before stock-based compensation, LTM March 2026 at close. From Compound's Debt Schedule tab.

The term loan pays SOFR plus 2.25% in cash while the PIK is elected and capitalizes the other 2.25% plus a 0.25% step-up. That step-up costs $6.75 million a year on the funded loan before compounding, the price of deferring cash interest in the two tightest years. The margin steps down to 4.25% from 2028, once first-lien net leverage at the end of 2027 is 6.7x.

The required sweep never takes cash. In 2027, cash available for debt service is $74 million, below the $119 million threshold (the greater of $105 million and 30% of EBITDA), and from 2028 the sweep percentage is zero. The model sweeps all cash above the $75 million minimum from 2027, after the 1% soft call ends, rising from $74 million in 2027 to $174 million in 2030. Net debt reaches $2,310 million by 2030 on the outside-in case and $1,777 million on management’s plan, the same as the LBO model.

Leverage and coverage

On the outside-in case, cash interest cover stays under 3x through 2030. Management’s plan reaches 4.7x by 2030 on $191 million more EBITDA.

CWAN Debt Schedule.xlsx
BCDEFGHI
1$MCloseFY26EFY27EFY28EFY29EFY30EFY31E
2Outside-in case
3Adjusted EBITDA (pre-SBC)281335395453514573636
4Net debt2,6252,6522,6542,6002,4832,3102,072
5Total debt / EBITDA9.6x8.2x6.9x5.9x5.0x4.2x3.4x
6First-lien net leverage9.4x7.9x6.7x5.7x4.8x4.0x3.3x
7Headroom to the 7.50x step-down (turns)(1.9x)(0.4x)0.8x1.8x2.7x3.5x4.2x
8EBITDA / cash interest2.1x2.4x2.4x2.5x3.0x3.6x
9EBITDA / cash and PIK interest1.5x1.7x2.1x2.5x3.0x3.6x
10Fixed-charge coverage2.0x2.3x2.2x2.3x2.8x3.4x
11Liquidity: cash + undrawn revolver400408400400400400400
12
13Management plan (merger proxy)
14Adjusted EBITDA (pre-SBC)281339419519635764897
15Net debt2,6252,6492,6162,4732,1981,7771,194
16Total debt / EBITDA9.6x8.1x6.4x4.9x3.6x2.4x1.4x
17First-lien net leverage9.4x7.8x6.2x4.8x3.5x2.3x1.3x
18Headroom to the 7.50x step-down (turns)(1.9x)(0.3x)1.3x2.7x4.0x5.2x6.2x
19EBITDA / cash interest2.1x2.6x2.8x3.4x4.7x7.3x
20EBITDA / cash and PIK interest1.5x1.8x2.4x3.4x4.7x7.3x
21Fixed-charge coverage1.9x2.4x2.7x3.2x4.4x6.9x
22Liquidity: cash + undrawn revolver400412400400400400400
23
24Downside: growth (3pp), margin (1.5pp) a year
25Adjusted EBITDA (pre-SBC)281313361403445483521
26Net debt2,6252,6632,6992,6962,6532,5792,470
27Total debt / EBITDA9.6x8.7x7.7x6.9x6.1x5.5x4.9x
28First-lien net leverage9.4x8.5x7.5x6.7x6.0x5.3x4.7x
29Headroom to the 7.50x step-down (turns)(1.9x)(1.0x)0.0x0.8x1.5x2.2x2.8x
30EBITDA / cash interest2.0x2.2x2.1x2.1x2.3x2.6x
31EBITDA / cash and PIK interest1.4x1.5x1.8x2.1x2.3x2.6x
32Fixed-charge coverage1.8x2.0x1.9x1.9x2.1x2.4x
33Liquidity: cash + undrawn revolver400397400400400400400
Credit Stats
Credit statistics by case, millions. EBITDA is adjusted EBITDA before stock-based compensation, standing in for the credit agreement's Consolidated EBITDA; FY2026 coverage is on the post-close stub. Fixed-charge coverage is EBITDA less capex and cash taxes over cash interest; there is no scheduled principal. From Compound's Credit Stats tab.

The covenant

At close, EBITDA could fall 38% before first-lien net leverage reached the 15.00x covenant; by 2027 the cushion is 55%. The covenant is not tested in any year of either case.

EBITDA cushion before the 15.00x covenant would bite

Fall in adjusted EBITDA that takes first-lien net leverage to 15.00x

ManagementOutside-inManagement Close38%Outside-in Close38%CloseManagement FY26E48%Outside-in FY26E47%FY26Management FY27E58%Outside-in FY27E55%FY27Management FY28E68%Outside-in FY28E62%FY28Management FY29E77%Outside-in FY29E68%FY29Management FY30E85%Outside-in FY30E73%FY30Management FY31E91%Outside-in FY31E78%FY31

The covenant is tested only when net revolver usage exceeds $260 million; it is not tested in any year of either case. From Compound's Credit Stats tab.

The covenant springs only when revolver drawings net of cash exceed $260 million. With the $75 million minimum cash on the balance sheet, even a fully drawn $325 million revolver stays below that. The test that binds earlier is the delayed draw’s: first-lien net leverage at the end of 2026 is 7.9x, 0.08x inside the 8.00x pro forma test, so an acquisition funded by the delayed draw has to wait for 2027 EBITDA or bring enough EBITDA of its own.

Financing scenarios

None of the financing choices moves the 2030 IRR by more than 0.6 points. What they move is coverage: paying the PIK in cash takes the lowest interest cover from 2.1x to 1.5x and draws $24 million on the revolver.

CWAN Debt Schedule.xlsx
BCDEFGH
1$MAs modeledPIK in cash$500M add-onSOFR +100bpSOFR –100bpSOFR +200bp
2Outside-in case
31L net leverage, FY20304.0x4.0x4.6x4.3x3.8x4.5x
41L net leverage, FY20276.7x6.7x7.4x6.8x6.6x6.9x
5Lowest interest cover2.1x1.5x2.1x1.8x2.5x1.6x
6Lowest fixed-charge cover2.0x1.4x2.0x1.7x2.4x1.5x
7Cash interest and fees, FY26-308329489579776941,129
8PIK interest, FY26-30135–147136133137
9Peak revolver draw–24–6–20
10FY2030 IRR21.1%21.1%21.4%20.8%21.3%20.5%
11
12Management plan (merger proxy)
131L net leverage, FY20302.3x2.3x2.9x2.5x2.2x2.7x
141L net leverage, FY20276.2x6.2x6.9x6.3x6.1x6.5x
15Lowest interest cover2.1x1.5x2.1x1.8x2.5x1.6x
16Lowest fixed-charge cover1.9x1.4x1.9x1.7x2.3x1.4x
17Cash interest and fees, FY26-307778929029146471,058
18PIK interest, FY26-30133–145134132136
19Peak revolver draw–20–2–16
20FY2030 IRR32.4%32.4%32.7%32.2%32.6%32.0%
21
22Downside
231L net leverage, FY20305.3x5.3x5.9x5.7x5.0x6.0x
241L net leverage, FY20277.5x7.4x8.1x7.6x7.4x7.7x
25Lowest interest cover2.0x1.4x1.9x1.7x2.4x1.5x
26Lowest fixed-charge cover1.8x1.3x1.8x1.6x2.2x1.4x
27Cash interest and fees, FY26-308669831,0001,0247231,182
28PIK interest, FY26-30136–150139135139
29Peak revolver draw362317–127
30FY2030 IRR16.3%16.4%16.7%16.0%16.7%15.6%
Scenarios
Financing scenarios, millions. As modeled: PIK elected to June 2028, SOFR flat at 3.53%, delayed draw undrawn; each other column changes one of these. Lowest cover is over FY2026-FY2031, FY2026 on the post-close stub. The add-on is illustrative: the $500 million delayed draw funds an acquisition at 15.0x EBITDA ($33 million run-rate) closing mid-2027, growing 10% a year at 70% cash conversion and exited at 15.0x. SOFR shifts are parallel and permanent. IRR at each case's own exit multiple. In the downloadable workbook, the comparison table is a snapshot of each scenario at these assumptions; change the scenario selector to rerun one live. From Compound's Scenarios tab.

Lowest interest cover by financing scenario, FY2026-FY2031

Adjusted EBITDA / cash interest and fees

ManagementOutside-inManagement, As modeled2.1xOutside-in, As modeled2.1xAs modeledManagement, PIK in cash1.5xOutside-in, PIK in cash1.5xPIK in cashManagement, $500M add-on2.1xOutside-in, $500M add-on2.1x$500M add-onManagement, SOFR +100bp1.8xOutside-in, SOFR +100bp1.8xSOFR +100bpManagement, SOFR –100bp2.5xOutside-in, SOFR –100bp2.5xSOFR –100bpManagement, SOFR +200bp1.6xOutside-in, SOFR +200bp1.6xSOFR +200bp

From Compound's Scenarios tab.

  • PIK paid in cash. Cash interest through 2030 rises from $832 million to $948 million, and the revolver covers the shortfall in 2027. The 2030 IRR stays at 21.1%: paying in cash avoids the 0.25% step-up but leaves less to sweep, and 2030 net debt is only $18 million lower.
  • Add-on on the delayed draw. An illustrative $500 million acquisition at 15.0x EBITDA in 2027 leaves first-lien net leverage at 7.4x pro forma, inside the 8.00x draw test, and at 4.6x in 2030 instead of 4.0x. The IRR rises to 21.4%: the add-on is funded entirely with debt and grows 10% a year, and it is bought and exited at the same 15.0x.
  • SOFR up 100bp. The 2030 IRR falls to 20.8% and the lowest interest cover to 1.8x; the revolver draws $6 million. At +200bp the IRR is 20.5%. The 0.50% floor never binds.

A true downside

In a downside with growth 3 points and margin 1.5 points below the outside-in case every year, the loan holds: cash interest cover bottoms at 1.96x in the 2026 stub, the revolver draws $2.8 million once, and the covenant is never tested. What the downside costs is deleveraging and the incurrence tests.

CWAN Debt Schedule.xlsx
BCDEFGH
1$MFY26EFY27EFY28EFY29EFY30EFY31E
2Adjusted EBITDA (pre-SBC)
3Outside-in case335395453514573636
4Downside313361403445483521
5Downside shortfall(22)(35)(50)(69)(90)(115)
Debt Schedule
Downside operating case against the outside-in case, millions. Growth is 3 points and the adjusted EBITDA margin 1.5 points below the outside-in case in every forecast year; capex, working capital and stock-based compensation are at the outside-in percentages. Drivers from Compound's sensitivity workbook.

By 2030 the downside earns $90 million less EBITDA than the outside-in case, $483 million. The free cash flow after interest is too thin to sweep much, so total debt rises with the PIK to $2,774 million in 2027 and is still $2,728 million in 2029. Leverage falls only because EBITDA grows: from 8.7x gross in 2026 to 5.5x in 2030.

CWAN Debt Schedule.xlsx
BCDEFGH
1$MFY26EFY27EFY28EFY29EFY30EFY31E
2Total debt, including PIK
3Downside2,7382,7742,7712,7282,6542,545
4Downside, PIK paid in cash2,7342,7622,7552,7112,6352,525
5Downside, SOFR +200bp2,7662,8612,9322,9622,9662,942
6First-lien net leverage
7Downside8.5x7.5x6.7x6.0x5.3x4.7x
8Downside, PIK paid in cash8.5x7.4x6.7x5.9x5.3x4.7x
9Downside, SOFR +200bp8.6x7.7x7.1x6.5x6.0x5.5x
10EBITDA / cash interest
11Downside1.96x2.19x2.08x2.07x2.30x2.57x
12Downside, PIK paid in cash1.42x1.60x1.83x2.09x2.31x2.59x
13Downside, SOFR +200bp1.45x1.60x1.51x1.54x1.66x1.80x
14EBITDA / cash and PIK interest
15Downside1.37x1.54x1.79x2.07x2.30x2.57x
16Downside, PIK paid in cash1.42x1.60x1.83x2.09x2.31x2.59x
17Downside, SOFR +200bp1.10x1.23x1.34x1.54x1.66x1.80x
18Revolver drawn, year end
19Downside3–––––
20Downside, PIK paid in cash34625511––
21Downside, SOFR +200bp315794123127104
227.50x margin step-down
23DownsideMissedMetMetMetMetMet
24Downside, PIK paid in cashMissedMetMetMetMetMet
25Downside, SOFR +200bpMissedMissedMetMetMetMet
268.00x delayed-draw test
27DownsideMissedMetMet–––
28Downside, PIK paid in cashMissedMetMet–––
29Downside, SOFR +200bpMissedMetMet–––
307.25x dividend test
31DownsideMissedMissedMetMetMetMet
3215.00x covenant tested
33DownsideNoNoNoNoNoNo
34Downside, PIK paid in cashNoNoNoNoNoNo
35Downside, SOFR +200bpNoNoNoNoNoNo
Scenarios
Downside by year with two financing stresses, millions; FY2026 coverage on the post-close stub. Tests on first-lien net leverage at year end; the delayed draw is available to December 2028. From Compound's Scenarios tab.
  • The incurrence tests are where a downside shows. At the end of 2026 first-lien net leverage is 8.5x, so the margin stays at 4.50% for 2027 and a delayed-draw acquisition is blocked; the 8.00x test is missed by 0.50x. In 2027 the step-down is met by 0.02x, and the 7.25x dividend test is still missed by 0.23x.
  • Paying the PIK in cash costs liquidity, not solvency. Cash interest cover falls to 1.42x in 2026 and the revolver peaks at $62 million in 2027, a fifth of the commitment, before it is repaid by 2030.
  • SOFR up 200bp is the stress that hurts. Cash interest cover is 1.45x in 2026 and only 1.51x in 2028, and 1.10x counting the PIK. The revolver funds the interest every year and reaches $127 million in 2030, so total debt is $2,966 million in 2030, above where it started, and first-lien net leverage is still 6.0x. The step-down is missed again in 2027, at 7.72x.
  • The covenant is still out of reach. In none of the three does net revolver usage approach the $260 million trigger; in 2026 EBITDA could fall another 43% on the downside before first-lien net leverage reached 15.00x.
CWAN Debt Schedule.xlsx
BCDEF
1IRR, 25.0x exitMOIC, 25.0x exitIRR, case multipleMOIC, case multiple
2Downside14.2%1.83x16.3%1.98x
3Downside, PIK paid in cash14.3%1.83x16.4%1.99x
4Downside, SOFR +200bp13.5%1.77x15.6%1.93x
Scenarios
Sponsor returns at a FY2030 exit on the Downside. The outside-in exit multiple is 25.0x next-year EBITDA; the case multiple is what the $24.55 price represents on Downside EBITDA. From Compound's Scenarios tab.

At the outside-in case’s 25.0x exit, the downside returns 14.2% and 1.83x, and 13.5% with SOFR up 200bp. A lender would read the downside as a covered credit with no deleveraging; a sponsor would read it as a deal below a 15% return.

Methodology. Terms are from the amended and restated debt commitment letter of January 21, 2026 and the merger proxy (DEFM14A, April 8, 2026). Where they are silent, the model’s assumptions are labeled in the workbook: a 50% base excess cash flow sweep, financing fees and OID of 2.0% of the term loan, SOFR held flat at 3.53%, $75 million minimum cash, a 100% optional sweep from 2027, step-downs tested on the prior year-end, and adjusted EBITDA before stock-based compensation standing in for Consolidated EBITDA. The outside-in and management cases are the LBO model’s; the downside uses the drivers of the sensitivity analysis, with cash taxes built the same way. The model was built in Compound; it rebuilds work a lender or deal team could have done and is not the lenders’ or buyers’ model.

Debt schedule workbook (Excel)Compound’s workbook from this run: a Term Sheet tab with every term cited, a tranche-by-tranche Debt Schedule with PIK, cash sweep and a circularity switch, Credit Stats with covenant headroom for three cases, a Scenarios tab with a downside stress and a one-page Debt Output.Draft: this template comes from the page's Compound run

FAQ

Why would a sponsor elect PIK interest on a loan like this?
To protect liquidity in the first two years, when cash interest cover is lowest. Here it costs 0.25% a year more and adds $134.5 million to the loan, but it keeps the lowest cash interest cover at 2.1x instead of 1.5x and the revolver undrawn.
What is a springing covenant?
A maintenance test that applies only when a condition is met, usually revolver usage above a threshold. Term lenders here have no financial covenant at all; their protection is the incurrence tests on debt, dividends and investments, and the leverage-based sweep.
How should a cash sweep be modeled?
Separate the required sweep, set by the credit agreement on excess cash flow above a threshold, from the optional prepayments the sponsor chooses. In this loan the required sweep is zero in every year, so the deleveraging in the model is a policy, not an obligation, and it waits for the 12-month soft call to end.
CoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix Research

See this workflow on your own deal