Clearwater Analytics Holdings, Inc. (CWAN)

Import this data to Google Sheets with:

=jivedata("CWAN","financials")

Full statements spill as a table. For one cell: =jivedata("CWAN","Revenue") or =jivedata("CWAN","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

Clearwater Analytics Holdings, Inc.

CWAN • CIK 0001866368

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenue from Contract with Customer, Excluding Assessed Tax	$368,168	$451,803	$731,368	$825,732
Cost of Revenue	$107,127	$122,987	$239,220	$280,977
Gross Profit	$261,041	$328,816	$492,148	$544,755
Operating Income (Loss)	$-16,745	$12,234	$-7,686	$-5,778
Interest Income (Expense), Nonoperating, Net	—	$8,621	$-45,664	$-60,004
Other Nonoperating Income (Expense)	$1,874	$2,263	$3,678	$4,019
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$-22,866	$-30,063	$-49,672	$-61,763
Income Tax Expense (Benefit)	$217	$-457,648	$-9,418	$-11,777
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$-23,083	$427,585	$-40,254	$-49,986
Net Income (Loss) Attributable to Noncontrolling Interest	$-1,456	$3,207	$-1,447	$-1,893
Net Income (Loss) Attributable to Parent	$-21,627	$424,378	$-38,807	$-48,093
Research and Development Expense	$123,925	$150,558	$196,228	$215,878
Selling and Marketing Expense	$60,365	$67,254	$149,180	$175,790
General and Administrative Expense	$93,496	$98,770	$154,426	$158,865
Operating Expenses	$277,786	$316,582	$499,834	$550,533
Weighted Average Number of Shares Outstanding, Basic	199,691,873	219,316,625	271,323,558	328,988,148
Weighted Average Number of Shares Outstanding, Diluted	199,691,873	254,362,539	271,323,558	320,100,195
Share-based Payment Arrangement, Expense	$104,447	$103,201	$127,896	$132,759

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Property, Plant and Equipment, Net	$15,349	$14,797	$26,607	$30,454
Operating Lease, Right-of-Use Asset	$22,554	$24,797	$34,300	$51,639
Contract with Customer, Asset, after Allowance for Credit Loss, Noncurrent	$6,439	$7,013	$13,017	$11,044
Debt Issuance Costs, Noncurrent, Net	$533	$339	$3,467	$3,268
Deferred Income Tax Assets, Net	—	$602,500	$695,998	$702,300
Other Assets, Noncurrent	$4,907	$3,340	$5,336	$4,816
Intangible Assets, Net (Excluding Goodwill)	$26,132	$30,868	$687,578	$660,650
Goodwill	$45,338	$70,971	$1,270,056	$1,268,440
Long-term Investments	$21,495	$30,301	$0	$0
Assets	$558,743	$1,169,572	$3,031,929	$3,026,855
Notes Payable, Noncurrent	$45,828	$43,164	$814,643	$798,399
Operating Lease, Liability, Noncurrent	$16,948	$17,655	$22,555	$40,228
Other Liabilities, Noncurrent	$5,518	$1,470	$2,296	$3,194
Liabilities	$149,086	$139,341	$1,000,837	$972,293
Stockholders' Equity Attributable to Noncontrolling Interest	$55,328	$21,976	$9,360	$5,062
Stockholders' Equity, Including Portion Attributable to Noncontrolling Interest	—	$1,030,231	$2,031,092	$2,054,562
Cash and Cash Equivalents, at Carrying Value	$221,765	$177,350	$91,245	$81,507
Short-term Investments	$74,457	$78,139	$0	$0
Accounts Receivable, after Allowance for Credit Loss, Current	$92,091	$106,151	$167,348	$169,630
Prepaid Expense and Other Assets, Current	$27,683	$23,006	$36,977	$43,107
Assets, Current	$415,996	$384,646	$295,570	$294,244
Accounts Payable, Current	$3,062	$2,934	$4,096	$1,630
Accrued Liabilities and Other Liabilities	$49,535	$62,983	$112,249	$78,605
Contract with Customer, Liability, Current	—	—	$21,860	$28,027
Notes Payable, Current	$2,750	$2,750	$8,000	$8,000
Operating Lease, Liability, Current	$6,551	$8,350	$15,138	$14,210
Liabilities, Current	$80,792	$77,052	$161,343	$130,472
Additional Paid in Capital	$532,507	$725,174	$1,754,387	$1,784,861
Accumulated Other Comprehensive Income (Loss), Net of Tax	$2,909	$-1,113	$7,089	$2,777
Retained Earnings (Accumulated Deficit)	$-181,331	$283,946	$259,963	$261,564
Stockholders' Equity Attributable to Parent	—	$1,008,255	$2,021,732	$2,049,500
Unbilled Contracts Receivable	$46,595	$46,316	$55,782	$61,472
Billed Contracts Receivable	$45,805	$59,995	$113,249	$110,056
Accounts Receivable, Allowance for Credit Loss, Current	$309	$160	$1,683	$1,898
Prepaid Expense, Current	$11,225	$12,834	$22,322	$23,542
Contract with Customer, Asset, after Allowance for Credit Loss, Current	$4,644	$5,047	$4,593	$6,450
Income Taxes Receivable, Current	$4,382	$687	$1,447	$1,692
Other Receivables, Net, Current	$1,692	$1,493	$1,050	$1,827
Other Assets, Current	$959	$1,104	$5,476	$8,958
Property, Plant and Equipment, Gross	$33,620	$37,662	$54,669	$54,669
Accumulated Depreciation, Depletion and Amortization, Property, Plant, and Equipment	$18,271	$22,865	$28,062	$27,100
Capitalized Computer Software, Gross	$500	$500	$500	$500
Depreciation	$5,700	$6,500	$9,900	$9,900
Deposits Assets, Noncurrent	$1,290	$1,551	$3,285	$3,285
Income Taxes Receivable, Noncurrent	—	$336	$1,083	$1,083
Interest Payable, Current	$622	$550	$11,267	$1,200
Accrued Bonuses, Current	$11,808	$16,034	$32,235	$7,718
Accrued Professional Fees, Current	—	—	$17,604	$9,719
Accrued Sales Commission, Current	$3,415	$3,204	$6,997	$3,906
Accrued Income Taxes, Current	$456	$403	$1,562	$1,512
Other Liabilities, Current	$5,293	$10,237	$13,105	$15,808
Asset Retirement Obligation	$161	$160	$265	$261
Deferred Income Tax Liabilities, Net	$5,356	$1,310	$756	$726

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$-23,083	$427,585	$-40,254	$-49,986
Net Cash Provided by (Used in) Operating Activities	$84,602	$74,321	$175,896	$169,071
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Including Disposal Group and Discontinued Operations	$785	$-1,420	$713	$-2,045
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$-28,959	$-44,415	$-86,105	$-193,652
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Including Disposal Group and Discontinued Operations	$221,765	$177,350	$91,245	$-102,407
Depreciation, Depletion and Amortization	$9,929	$12,181	$85,541	$111,952
Payments to Acquire Property, Plant, and Equipment	$5,624	$5,259	$11,554	$16,526
Payments to Acquire Intangible Assets	—	—	$10,239	$10,239
Share-based Payment Arrangement, Noncash Expense	$104,447	$103,201	$127,896	$132,759
Payments to Acquire Held-to-maturity Securities	$3,004	$3,009	$4,686	$0
Amortization of Acquisition Costs	$4,763	$5,265	$11,487	$13,258
Payments to Acquire Debt Securities, Available-for-sale	$124,178	$114,572	$0	$0
Amortization of Debt Issuance Costs	$280	$280	$2,770	$3,655
Proceeds from Sale of Debt Securities, Available-for-sale	$5,950	$0	$89,479	$0
Gain (Loss) on Extinguishment of Debt	$0	—	$-419	$-419
Proceeds from Maturities, Prepayments and Calls of Debt Securities, Available-for-sale	$31,801	$107,417	$23,716	$7,516
Accounts Receivable, Credit Loss Expense (Reversal)	—	—	$2,165	$2,381
Payments to Acquire Businesses, Net of Cash Acquired	$0	$40,121	$1,074,754	$1,074,754
Deferred Income Tax Expense (Benefit)	$-1,665	$-460,032	$-12,607	$-15,857
Accretion (Amortization) of Discounts and Premiums, Investments	$1,474	$2,185	$284	$0
Net Cash Provided by (Used in) Investing Activities	$-95,055	$-55,648	$-988,127	$-1,094,092
Realized Investment Gains (Losses)	$89	$35	$112	$0
Proceeds from Stock Options Exercised	$4,738	$248	$168	$168
Payment, Tax Withholding, Share-based Payment Arrangement	$20,784	$55,301	$33,749	$11,595
Payments for Repurchase of Common Stock	$0	—	$18,054	$18,054
Proceeds from Debt, Net of Issuance Costs	—	—	$924,475	$924,475
Repayments of Debt	$2,749	$2,750	$154,063	$170,375
Proceeds, Issuance of Shares, Share-based Payment Arrangement, Excluding Option Exercised	—	—	$6,636	$6,636
Payment for Contingent Consideration Liability, Financing Activities	$2,900	$4,685	$0	$0
Net Cash Provided by (Used in) Financing Activities	$-19,291	$-61,668	$725,413	$733,414
Interest Paid, Excluding Capitalized Interest, Operating Activities	$3,454	$3,464	$31,142	$51,568
Income Taxes Paid, Net	$2,432	$1,979	$3,486	$4,057
Capital Expenditures Incurred but Not yet Paid	$435	$38	$210	$348
Increase (Decrease) in Accounts Receivable	$19,298	$13,648	$11,148	$8,350
Increase (Decrease) in Prepaid Expense and Other Assets	$-1,151	$-5,627	$11,159	$12,661
Increase (Decrease) in Deferred Policy Acquisition Costs	—	—	$17,036	$20,049
Increase (Decrease) in Accounts Payable	$-115	$269	$-1,341	$-2,881
Increase (Decrease) in Accrued Liabilities and Other Operating Liabilities	$1,204	$11,627	$22,449	$-5,251
Increase (Decrease) in Other Noncurrent Liabilities	—	—	$463	$1,332

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("CWAN","financials")

Full statements spill as a table. For one cell: =jivedata("CWAN","Revenue") or =jivedata("CWAN","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.