Financial statement analysis example: what five years of filings say about a take-private price

An associate reads Clearwater Analytics' income statement, balance sheet and cash flow statement before its take-private, one ratio at a time in Compound, and tests what the statements say about the price.

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

Short answer

Financial statement analysis reads a company's income statement, balance sheet and cash flow statement together, through ratios and trends, to judge growth, profitability, cash conversion and leverage. Compound spread Clearwater Analytics' FY2021 to FY2025 filings: organic revenue grew 18.8% in 2025, the 33.9% adjusted EBITDA margin falls to 15.5% once stock pay is charged, and free cash flow was $164M. At the $24.55 take-private price, that is a 2.0% free cash flow yield.

Try this prompt free
On this page (8)
  1. 1. How to analyze financial statements: spread the three statements first
  2. 2. Revenue growth analysis: organic against acquired
  3. 3. Profitability ratios: adjusted EBITDA margin after stock pay
  4. 4. Cash flow analysis: how much EBITDA turns into cash
  5. 5. Balance sheet analysis: what the 2025 acquisitions added
  6. 6. Leverage ratios and return on invested capital
  7. 7. Financial ratio analysis against the $24.55 price
  8. 8. FAQ
CWAN Financial Statement Analysis FY2021-FY2025 (Compound, 2026-10-22).xlsx
G19fx=G18/F12-1
BCDEFG
920212022202320242025
19Organic revenue growth20.0%19.2%22.7%18.8%
39Adjusted EBITDA margin28.8%26.7%28.8%32.2%33.9%
59FCF / Adjusted EBITDA(2.3%)61.9%74.6%47.4%66.2%
107Net debt / Adjusted EBITDA (x)(2.8x)(2.5x)(2.5x)(1.6x)2.9x
99ROIC, adjusted61.5%55.2%64.2%11.4%
ISBSCFSAnalysisAcquisitions
Ask: “Spread Clearwater's three statements for FY2021 to FY2025 from its 10-Ks and 10-Q, cite every figure, and build the ratio and trend analysis.” The key ratios from a real Compound run, unedited apart from the excerpt. Clearwater Analytics is a real public company, and every figure cites its filing.

You are the associate on a private equity team that covers financial software. Permira and Warburg Pincus agreed on December 20, 2025 to take Clearwater Analytics (NYSE: CWAN) private at $24.55 a share, about $8.4 billion of transaction value. The deal closed in June 2026, and it is now the reference point for the next vertical software take-private your partner will look at.

Your job is to read Clearwater’s own statements, five years of them, and say what they support at that price. This page takes the analysis one step at a time, each step run in Compound on the 10-Ks and the latest 10-Q. The answer at the end: the growth holds up, but at $24.55 the buyers get a thin cash return today and pay for growth to come. Figures in the text are rounded, in $M. The tables show Compound’s exact figures.

Financial statement analysis is the read of the three statements together. The income statement shows revenue, costs and profit for a period. The balance sheet shows what the company owns and owes on one date. The cash flow statement shows the cash that came in and went out. Ratios join them: a margin divides one income statement line by revenue, a return divides profit by the capital on the balance sheet, and cash conversion divides cash flow by profit.

How to analyze financial statements: spread the three statements first

The first step puts five years of statements into one workbook, as reported, and proves that every total ties.

Prompt to try

“Spread [company]'s income statement, balance sheet and cash flow statement for the last five fiscal years from its 10-Ks, plus the latest 10-Q, citing every figure to its filing and printed page. Build the totals as formulas, tie them to the reported figures, and rebuild adjusted EBITDA from the company's own reconciliation.”

Compound read the FY2022, FY2023 and FY2025 10-Ks and the Q3 2025 10-Q. Each hard-coded figure in the IS, BS and CFS tabs cites its document and page. Every total is a live formula. The balance sheet balances, the cash flow statement ends on the balance sheet’s cash, and adjusted EBITDA rebuilt from net income matches the company’s figure in every year.

CWAN Financial Statement Analysis FY2021-FY2025 (Compound, 2026-10-22).xlsx
G49fx=SUM(G37:G48)
BCDEFG
620212022202320242025
9Revenue ($M)252.0303.4368.2451.8731.4
11Gross profit ($M)184.2215.6261.0328.8492.1
15Total operating expenses ($M)(155.7)(210.5)(277.8)(316.6)(499.8)
16Income (loss) from operations ($M)28.55.1(16.7)12.2(7.7)
23Net income (loss) ($M)(8.1)(6.7)(23.1)427.61(40.3)
34Total equity-based compensation ($M)36.765.7104.4103.2127.9
49Adjusted EBITDA ($M)72.781.1105.9145.7248.2
51Adjusted EBITDA, as reported72.781.1105.9145.7248.2
52Difference–––––2
  1. 1FY2024 net income includes a one-off tax benefit when the valuation allowance on deferred tax assets was released
  2. 2Adjusted EBITDA rebuilt from net income matches the company's reconciliation in every year
ISBSCFSAnalysisAcquisitions
The income statement as reported, $ millions, with adjusted EBITDA rebuilt from the company's reconciliation. From Compound's IS tab, rows excerpted.

The spread already shows the shape of the business. Revenue nearly tripled in four years, a 30.5% compound annual growth rate. Operating income stayed near zero the whole time, and the one year of large net income, FY2024, came from a tax benefit, not from operations.

Takeaway: the statements tie, so every ratio below rests on figures you can trace to a page. The first question is how much of the growth was bought.

Revenue growth analysis: organic against acquired

The second step splits 2025’s growth into the business Clearwater had and the businesses it bought.

Prompt“Split [company]'s revenue growth into organic and acquired, using the revenue each acquisition contributed as disclosed in the notes. Add pro forma growth and organic recurring revenue, and show the basis for each.”

Clearwater bought Enfusion on April 21, 2025 and Beacon nine days later. The 10-K’s acquisition note discloses what each contributed: $158.9M and $35.6M of 2025 revenue. Compound subtracted both.

CWAN Financial Statement Analysis FY2021-FY2025 (Compound, 2026-10-22).xlsx
G27fx=G26/F23-1
BFG
920242025
12Revenue ($M)451.8731.4
13% growth22.7%61.9%1
17Acquired revenue, disclosed ($M)–194.5
18Organic revenue ($M)451.8536.9
19Organic revenue growth22.7%18.8%2
21Pro forma revenue (Enfusion and Beacon from 1-Jan-2024)708.3817.0
22Pro forma revenue growth15.4%3
23Annualized recurring revenue, period end ($M)474.9841.0
25Acquired ARR (acquired entities)282.0
26Organic ARR ($M)559.0
27Organic ARR growth17.7%
  1. 1Reported growth: 43 of the 62 points are Enfusion and Beacon
  2. 2Organic: revenue less the disclosed acquired revenue, over prior-year revenue
  3. 3Pro forma: both businesses in both years. Growth of the combined company
ISBSCFSAnalysisAcquisitions
Reported, organic and pro forma growth, $ millions. From Compound's Analysis tab, rows excerpted.

Clearwater's 2025 growth depends on what you count

Growth in 2025 on four bases, from the same 10-K

Reported revenueincludes acquisitions61.9%Organic revenue18.8%Organic ARRyear-end17.7%Pro forma revenuecombined company15.4%

Source: Clearwater 10-K FY2025 pp. 47, 85-87. Calculation by Compound, Analysis tab.

Organic revenue grew 18.8%, down from 22.7% in 2024. Organic annualized recurring revenue (ARR) grew 17.7% in the year to December. The earnings call analysis page’s 17.0% is the year to September, so the two agree. Retention backs the organic figure: gross revenue retention has been 98% in every year, and net revenue retention was 113% excluding the acquired businesses. Pro forma growth, 15.4%, is the rate of the business a buyer now owns, since Enfusion grows more slowly than Clearwater’s core: about 13% on its third-quarter run rate.

Takeaway: organic growth is high-teens and backed by retention, but the combined company grew 15.4%, not 61.9%. The next question is whether that growth earns a profit.

Profitability ratios: adjusted EBITDA margin after stock pay

The third step sets the company’s adjusted margin against the costs it adds back.

Prompt“Build [company]'s margin trend for five years: gross, GAAP operating and adjusted EBITDA margin, then stock-based compensation and related payroll taxes as a percentage of revenue, and adjusted EBITDA after them. Explain what drives each change.”

Adjusted EBITDA is the company’s own profit measure. Clearwater’s adds back interest, taxes, depreciation and amortization, and also stock-based compensation, its payroll taxes and transaction costs. Stock pay is the largest of those add-backs, and it is a real cost: shareholders bear it through dilution, and a private owner has to replace it with cash or an equity pool.

CWAN Financial Statement Analysis FY2021-FY2025 (Compound, 2026-10-22).xlsx
G49fx=G48/G12
BCDEFG
920212022202320242025
33Gross margin73.1%71.1%70.9%72.8%67.3%1
37Operating margin (GAAP)11.3%1.7%(4.5%)2.7%(1.1%)
38Adjusted EBITDA ($M)72.781.1105.9145.7248.2
39Adjusted EBITDA margin28.8%26.7%28.8%32.2%33.9%
44Equity-based compensation ($M)36.765.7104.4103.2127.9
45% of revenue14.6%21.6%28.4%22.8%17.5%
46SBC and related payroll taxes, Adj. EBITDA add-back ($M)36.766.5108.1111.0134.5
47% of revenue14.6%21.9%29.4%24.6%18.4%
48Adjusted EBITDA less SBC and payroll taxes ($M)36.014.6(2.2)34.7113.7
49% margin14.3%4.8%(0.6%)7.7%15.5%2
  1. 1Gross margin fell 5.5 points in the year Enfusion and Beacon came in
  2. 2After stock pay and its payroll taxes, less than half the adjusted margin is left
ISBSCFSAnalysisAcquisitions
Margins and stock pay, $ millions. From Compound's Analysis tab, rows excerpted.

Clearwater's margin on three definitions

Percentage of revenue, FY2021 to FY2025

-10.0%0.0%10.0%20.0%30.0%40.0%FY2021FY2023FY2025Adjusted EBITDA marginAfter SBC and payroll taxesGAAP operating margin

Source: Clearwater 10-K FY2025, FY2023 and FY2022. Calculation by Compound, Analysis tab.

The adjusted margin rose five points, from 28.8% to 33.9%. Stock pay peaked at 28.4% of revenue in 2023 and fell to 17.5% in 2025, which is real progress. Even so, adjusted EBITDA after stock pay and its payroll taxes is $113.7M, a 15.5% margin, and the GAAP operating margin is still below zero. The gap between the adjusted and GAAP lines is mostly stock pay, then the amortization of what Clearwater bought and the deal costs.

Takeaway: the adjusted margin rose, but GAAP profit did not, and charging stock pay halves the margin. The next question is how much of the profit turns into cash.

Cash flow analysis: how much EBITDA turns into cash

The fourth step measures free cash flow against adjusted EBITDA, with and without the cash Clearwater spends on its own stock awards.

Prompt“Measure [company]'s cash conversion for five years: cash from operations, capex including capitalized software, free cash flow, free cash flow over adjusted EBITDA, and the same after taxes paid on net share settlement. Flag one-off items in operating cash flow and show working capital days.”
CWAN Financial Statement Analysis FY2021-FY2025 (Compound, 2026-10-22).xlsx
G59fx=G56/G38
BCDEFG
920212022202320242025
54Cash from operations ($M)3.458.084.674.3175.9
55Purchases of property, equipment and software(5.0)(7.8)(5.6)(5.3)(11.6)
56Free cash flow ($M)(1.7)50.279.069.1164.3
57FCF margin(0.7%)16.6%21.5%15.3%22.5%
59FCF / Adjusted EBITDA(2.3%)61.9%74.6%47.4%166.2%
50Taxes paid on net share settlement2.23.220.855.333.7
60FCF less taxes on net share settlement ($M)(3.9)47.158.213.8130.6
61% of Adjusted EBITDA(5.3%)58.0%54.9%9.4%52.6%2
63TRA payments within CFO (expense less liability change)–(0.6)8.472.00.0
64CFO before TRA payments / Adjusted EBITDA4.6%70.8%87.8%100.5%70.9%
68Days sales outstanding (AR / revenue)73879186843
69DSO on pro forma revenue75
  1. 1FY2024 cash flow carried $72.0M of payments under the tax receivable agreement, which settled that year. Before them, cash from operations was 100.5% of adjusted EBITDA
  2. 2Paying the tax on vesting awards in cash cuts conversion to 53%
  3. 384 days is inflated by the acquisitions closed in April. On full-year pro forma revenue it is 75
ISBSCFSAnalysisAcquisitions
Cash conversion and receivables, $ millions. From Compound's Analysis tab, rows excerpted.

Free cash flow was $164.3M in 2025, 66% of adjusted EBITDA. Capex is light, 1.6% of revenue, as it usually is for software. The deduction to watch sits in financing cash flow: when employees’ awards vest, Clearwater withholds shares and pays their tax in cash, $33.7M in 2025. That is stock pay coming back as a cash cost, and after it conversion falls to 53%.

Takeaway: cash conversion is solid, not exceptional, at 66% of adjusted EBITDA and 53% after the tax on vesting awards. The next question is what Clearwater spent its cash and its stock on.

Balance sheet analysis: what the 2025 acquisitions added

The fifth step reads the acquisition note to see what Enfusion and Beacon cost and where that cost now sits on the balance sheet.

Prompt“From [company]'s acquisition notes, lay out each deal's consideration in cash and stock, cash acquired, the purchase price allocation, the revenue each contributed and the price over the target's prior-year revenue. Then show what the deals did to goodwill, intangibles, amortization and debt.”
CWAN Financial Statement Analysis FY2021-FY2025 (Compound, 2026-10-22).xlsx
E15fx=E13+E14
BCDE
5EnfusionBeaconTotal
9Cash paid760.5351.31,111.8
10Fair value of CWAN Class A stock issued598.6178.7777.4
11Converted equity awards (pre-combination service)12.81.914.7
12Payment to terminate Enfusion tax receivable agreement30.030.0
13Total consideration ($M)1,401.9531.91,933.9
14Less: cash acquired(22.9)(44.2)(67.1)
15Consideration, net of cash acquired ($M)1,379.1487.71,866.8
17Issue price per CWAN share ($)$21.331$22.74
20Goodwill854.4339.21,193.6
24Identified intangible assets ($M)450.0166.9616.9
26Goodwill and intangibles % of net consideration94.6%103.8%97.0%2
37FY2025 revenue contributed ($M)158.935.6194.5
43FY2024 standalone revenue201.6
45Net consideration / FY2024 revenue (x)6.8x3
  1. 1Shares issued to Enfusion holders at $21.33. The take-private paid $24.55, 15.1% more, eight months later
  2. 297% of what Clearwater paid is goodwill and intangibles
  3. 3Enfusion's price over its revenue in the year before the deal
ISBSCFSAnalysisAcquisitions
Consideration and purchase price allocation, $ millions except per share (10-K FY2025, Note 5). From Compound's Acquisitions tab, rows excerpted.

The two deals cost $1.87B net of cash acquired: $1.11B in cash, mostly borrowed, and $777M in new Clearwater shares. Enfusion alone was 6.8x its 2024 revenue. Almost all of the price went to goodwill and intangible assets, which are now 64.6% of Clearwater’s total assets. Amortization of those intangibles rose to $75.7M in 2025, and the 10-K schedules $106.1M for 2026, a cost that keeps GAAP profit low for years.

Takeaway: the 2025 deals rebuilt the balance sheet around goodwill. The next question is what they did to leverage and to the return on capital.

Leverage ratios and return on invested capital

The sixth step reads the debt the deals added and the return Clearwater now earns on everything it has invested.

CWAN Financial Statement Analysis FY2021-FY2025 (Compound, 2026-10-22).xlsx
G107fx=G106/G38
BCDEFG
920212022202320242025
96Invested capital, excl. cash and DTA ($M)61.2134.0140.5187.92,066.5
99ROIC, adjusted61.5%55.2%64.2%11.4%1
100Goodwill and intangible assets–73.271.5101.81,957.6
104Total debt, carrying value ($M)53.951.248.645.9822.6
105Cash and investments254.6255.6317.7285.891.2
106Net debt (cash) ($M)(200.7)(204.4)(269.1)(239.9)731.4
107Net debt / Adjusted EBITDA (x)(2.8x)(2.5x)(2.5x)(1.6x)2.9x2
109Adjusted EBITDA / interest expense (x)2.8xn.m.22.4x33.7x5.4x
112Liquidity: cash, investments and undrawn revolver ($M)247.2
  1. 1Adjusted ROIC: (adjusted EBITDA less D&A) taxed at 21%, over average invested capital. Excluding goodwill and intangibles it is still 131.9%
  2. 2Net debt of $731.4M against $248.2M of adjusted EBITDA
ISBSCFSAnalysisAcquisitions
Invested capital, returns and leverage, $ millions. Invested capital is debt plus equity, less cash and the deferred tax assets. From Compound's Analysis tab, rows excerpted.

At the end of 2024 Clearwater held $239.9M more cash than debt. A year later it owed $731.4M net, 2.9x adjusted EBITDA, and interest coverage had fallen from 33.7x to 5.4x. Liquidity is $247.2M, cash plus an undrawn $156M revolver. Return on invested capital tells the same story from the other side. On the capital it ran with before the deals, Clearwater earned over 60% a year. On the $2.07B it has invested now, it earns 11.4%. The core business still earns very high returns on its tangible capital. What fell is the return on what Clearwater paid for Enfusion and Beacon, which now depends on the integration delivering.

Takeaway: net cash became 2.9x leverage, and the return on capital fell from 64.2% to 11.4%. The last question is what all of this says about $24.55.

Financial ratio analysis against the $24.55 price

The last step sets the statements against the price the buyers paid.

Prompt“Set [company]'s latest fiscal year against the deal price: transaction value over revenue, pro forma revenue, adjusted EBITDA and adjusted EBITDA after stock pay, and the free cash flow yield. Compare the price with the share prices of any recent stock-funded acquisitions.”
CWAN Financial Statement Analysis FY2021-FY2025 (Compound, 2026-10-22).xlsx
G121fx=G56/G116
BG
92025
115Offer price per share ($)$24.55
116Transaction value ($M)8,400.0
117Transaction value / FY2025 revenue (x)11.5x
118Transaction value / FY2025 pro forma revenue (x)10.3x
119Transaction value / Adjusted EBITDA (x)33.8x
120Transaction value / (Adj. EBITDA less SBC) (x)73.9x1
121FCF yield on transaction value2.0%2
122Enfusion share issue price, 21-Apr-2025 ($)$21.33
123Beacon share issue price, 30-Apr-2025 ($)$22.74
124Offer premium to Enfusion issue price15.1%
125Offer premium to Beacon issue price8.0%
  1. 1Adjusted EBITDA less SBC and its payroll taxes, $113.7M
  2. 2$164.3M of 2025 free cash flow on $8.4B
ISBSCFSAnalysisAcquisitions
Take-private price context on FY2025 actuals, $ millions except per share. The ~$8.4B transaction value is the figure the 10-K reports. From Compound's Analysis tab.

On 2025’s actual results, the price is 33.8x adjusted EBITDA and 73.9x once stock pay and its payroll taxes are charged. The free cash flow yield is 2.0%. On management’s 2026 plan, as the valuation page shows, the same price is 24.9x EBITDA, so most of the multiple is paid for growth still to come. One more ratio is easy to miss. Clearwater issued shares to Enfusion’s holders at $21.33 and to Beacon’s at $22.74 in April 2025. The offer is only 15.1% and 8.0% above those prices, so the sellers of both businesses got close to the take-private price for their stock.

Organic growth intact

18.8%

FY2025 organic revenue growth, backed by 98% gross retention. Pro forma growth of the combined company was 15.4%.

Margin after stock pay

15.5%

Adjusted EBITDA margin of 33.9% less stock pay and its payroll taxes. GAAP operating margin was (1.1%).

Cash yield at the offer

2.0%

$164.3M of free cash flow on $8.4B. Conversion is 66% of adjusted EBITDA and 53% after the tax on vesting awards.

Leverage after the deals

2.9x

Net debt over adjusted EBITDA, from net cash a year earlier. Goodwill and intangibles are 64.6% of assets.

Takeaway: the statements support the growth, but at $24.55 the buyers get a 2.0% cash yield today and pay for the plan, which is where the DCF model page picks up.

Compound put the five findings on one page, each with how it bears on the price.

Compound's one-page Clearwater slide headlined 'Growth is real; cash returns at $24.55 are thin', subtitled that the ~$8.4bn price is 33.8x FY2025 adjusted EBITDA but a 2.0% free cash flow yield: five findings tagged strength, watch, watch, risk and risk, each with a price read, a revenue chart from FY2021 to FY2025 splitting base revenue from Enfusion and Beacon, and a heat-shaded table of organic growth, adjusted EBITDA margin, SBC, FCF conversion, net debt to EBITDA and adjusted ROIC
The findings page from the same run, unedited.

The organic growth rate and the margin after stock pay feed the DCF model and the earnings call analysis, which tests how far management’s plan runs ahead of this record.

Financial statement analysis workbook (Excel)Compound’s workbook from this run, free and without a form: the IS, BS and CFS tabs as reported for FY2021 to FY2025 plus Q3 and LTM, each figure cited to its filing and page, the Analysis tab of ratios and trends, and the Acquisitions tab. It also holds what this page leaves out: operating expense ratios, working capital days, capitalized software and the LTM column. Use it as a financial ratio analysis template: replace the statements with your company’s and the ratios recalculate.Download · Free, no form One-page findings slide (PowerPoint)Compound’s findings page for Clearwater: five findings with their price read, the base and acquired revenue chart and the heat-shaded ratio table.Download · Free, no form

FAQ

What are the main financial ratios?

Five groups cover most of the work. Growth: reported, organic and pro forma revenue growth. Profitability: gross, operating and EBITDA margins. Cash conversion: free cash flow over EBITDA and working capital days such as DSO. Leverage and liquidity: net debt over EBITDA, interest coverage and the current ratio. Returns: return on invested capital or on equity. For a buyer, the ratios that move the price are usually organic growth, margin after stock pay, cash conversion and leverage.

What is the difference between ratio analysis, trend analysis and common-size analysis?

Ratio analysis divides one line by another to compare businesses of different sizes, such as EBITDA over revenue. Trend analysis, also called horizontal analysis, follows a line or ratio across periods. Common-size analysis, or vertical analysis, states every line as a percentage of revenue or of total assets. Most financial statement analysis uses all three, as the Analysis tab here does: the margins are common-size lines, and the five-year columns are the trend.

How do you separate organic growth from acquired growth?

Start from the acquisition note in the 10-K, which usually discloses the revenue each acquired business contributed since closing. Subtract it from reported revenue and divide by last year’s revenue. Then check against pro forma revenue, which the same note often gives as if the deal had closed at the start of the prior year, and against organic ARR if the company reports it. Where a contribution is not disclosed, as for Clearwater’s 2024 Wilshire deal, say so rather than estimate it.

Should adjusted EBITDA add back stock-based compensation?

Companies add it back, and market multiples are usually quoted that way, but a buyer should show both. Stock pay is pay: shareholders bear it through dilution, and a private owner bears it in cash. Clearwater’s adjusted margin of 33.9% becomes 15.5% once stock pay and its payroll taxes are charged. The DCF model page shows what that choice does to value per share.

Can Compound analyze financial statements from 10-Ks and 10-Qs?

Yes. Compound reads the filings, including the notes, and spreads the income statement, balance sheet and cash flow statement into Excel with every figure cited to its document and page. Totals are live formulas that tie to the reported figures, and the ratios and trends are formulas you can audit and extend. It works on several companies at once for a comparison, and on private company accounts in PDF.

What are the limitations of ratio analysis?
Ratios inherit whatever the reported figures include. Clearwater’s 61.9% reported revenue growth is 18.8% organic once acquired revenue is taken out, its FY2024 net income came from a one-off tax benefit, and its adjusted EBITDA margin of 33.9% is 15.5% once stock pay and its payroll taxes are charged. Read the notes before you divide.
How do you analyze a cash flow statement?
Start from cash from operations, subtract capex including capitalized software to get free cash flow, and divide it by adjusted EBITDA to measure cash conversion. Then flag one-off items in operating cash flow and deduct cash costs that sit in financing, such as taxes paid on net share settlement. Clearwater’s $164.3M of 2025 free cash flow is 66% of adjusted EBITDA, and 53% after those taxes.
CoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix Research

See this workflow on your own deal