Williams Companies Inc
over ten years, 14x exit
| Fiscal year | Operating cash flow | Stock comp | Capex | Free cash flow | Net borrowing | FCFE | Shares (B) | FCF per share | Year-end price | FCF yield |
|---|---|---|---|---|---|---|---|---|---|---|
| 2016 | 3.7 | 0.1 | 2.1 | 1.5 | -1.2 | 0.4 | 0.75 | $2.05 | $31.14 | 6.6% |
| 2017 | 2.6 | 0.1 | 2.4 | 0.0 | -2.2 | -2.2 | 0.83 | $0.05 | $30.49 | 0.2% |
| 2018 | 3.3 | 0.1 | 3.3 | -0.0 | +1.9 | 1.9 | 0.97 | $-0.03 | $22.05 | -0.1% |
| 2019 | 3.7 | 0.1 | 2.1 | 1.5 | -2.2 | -0.7 | 1.21 | $1.22 | $23.72 | 5.2% |
| 2020 | 3.5 | 0.1 | 1.3 | 2.2 | +1.3 | 3.5 | 1.22 | $1.78 | $20.05 | 8.9% |
| 2021 | 3.9 | 0.1 | 1.2 | 2.6 | +0.2 | 2.8 | 1.22 | $2.15 | $26.04 | 8.2% |
| 2022 | 4.9 | 0.1 | 2.3 | 2.5 | +0.3 | 2.8 | 1.22 | $2.07 | $32.90 | 6.3% |
| 2023 | 5.9 | 0.1 | 2.6 | 3.3 | +1.4 | 4.7 | 1.22 | $2.69 | $34.83 | 7.7% |
| 2024 | 5.0 | 0.1 | 2.6 | 2.3 | +1.4 | 3.7 | 1.22 | $1.88 | $54.12 | 3.5% |
| 2025 | 5.9 | 0.1 | 4.9 | 0.9 | +2.6 | 3.5 | 1.22 | $0.75 | $60.11 | 1.2% |
| 9-yr CAGR | 5.4% | 2.7% | 10.1% | -5.7% | n/a | 29.0% | 5.6% | -10.6% | 7.6% | avg 4.8% |
| Fiscal year | Revenue | EBITDA | EBITDA margin | Debt incl. leases | Cash & securities | Market cap | Enterprise value | EV / EBITDA | Net debt / EBITDA |
|---|---|---|---|---|---|---|---|---|---|
| 2016 | 7.5 | 2.5 | 32.7% | 22.6 | 0.2 | 23 | 46 | 18.7x | 9.16x |
| 2017 | 8.0 | 2.7 | 33.2% | 20.4 | 0.9 | 25 | 45 | 16.8x | 7.34x |
| 2018 | 8.7 | 2.5 | 29.1% | 22.4 | 0.2 | 21 | 44 | 17.3x | 8.79x |
| 2019 | 8.2 | 3.6 | 44.3% | 20.2 | 0.3 | 29 | 49 | 13.4x | 5.47x |
| 2020 | 7.7 | 3.9 | 50.8% | 21.5 | 5.3 | 24 | 41 | 10.3x | 4.12x |
| 2021 | 10.6 | 4.5 | 42.1% | 21.7 | 1.7 | 32 | 52 | 11.6x | 4.47x |
| 2022 | 11.0 | 5.0 | 45.8% | 22.0 | 0.2 | 40 | 62 | 12.3x | 4.34x |
| 2023 | 10.9 | 6.4 | 58.5% | 23.4 | 2.2 | 43 | 64 | 10.0x | 3.33x |
| 2024 | 10.5 | 5.6 | 52.9% | 24.8 | 0.1 | 66 | 91 | 16.4x | 4.44x |
| 2025 | 12.0 | 6.7 | 56.5% | 27.3 | 0.1 | 73 | 101 | 14.9x | 4.04x |
| 9-yr CAGR | 5.3% | 11.9% | avg 44.6% | 2.1% | -10.4% | 13.6% | 9.1% | median 14.2x | avg 5.55x |
| Purchase price | 9.5x | 11.5x | 14x median | 15x last FYE | 18.5x |
|---|---|---|---|---|---|
| $54 | 9.6% | 11.7% | 13.8% | 14.6% | 16.9% |
| $64 | 7.4% | 9.5% | 11.6% | 12.3% | 14.7% |
| $71 last close | 6.1% | 8.2% | 10.3% | 11.0% | 13.3% |
| $73 | 5.8% | 7.8% | 9.9% | 10.7% | 13.0% |
| $82 | 4.4% | 6.4% | 8.5% | 9.2% | 11.5% |
Revenue grew 5.3% a year and EBITDA 11.9% a year from FY2016 to FY2025, and free cash flow after stock compensation grew -5.7% a year. The share count rose 5.6% a year, so per-share figures grew more slowly than the totals. Net debt stood at 4.0x EBITDA at the last fiscal year-end. Capital spending rose from 27% of revenue to 41%, which is why free cash flow lagged operating cash flow in the latest year. At 15x EBITDA at the last fiscal year-end against a ten-year median of 14x, the model prices the last close of $71 as a 10.2% ten-year return; the grid shows how that changes if the multiple holds.
From the data: The share count moved 25% in FY2019 with no split on record (a merger, offering or buyback), so per-share figures before and after that year are not on one basis.
- Free cash flow is operating cash flow less stock-based compensation less capital spending. Stock comp is treated as a real cost.
- Net borrowing is the year's change in long-term debt. FCFE adds it back to free cash flow, the classic one-page definition.
- EBITDA is operating income plus depreciation and amortization. Debt includes lease obligations; cash includes short-term investments.
- Market cap uses the fiscal year-end price as traded, restated for later splits but not for dividends; enterprise value adds debt and subtracts cash.
- Share count is the yearly change in shares outstanding over the period; flat or falling clears. Cash margin is the latest free cash flow margin against its three-year average; within two points clears.
- Hurdle price is the present value, at the hurdle rate, of ten years of modeled free cash flow per share plus a year-10 sale at the exit multiple. It is shown as an exhibit: the 2011 to 2021 back-test found that buying below it did not sort winners from losers, so it is not scored.
- Cleared on a check means the number clears the stated rule; Not cleared means it does not. Durable, Holding and First year say how many fiscal years running the company has cleared all four staying-power checks (four or more, two or three, one); Partial and Not cleared count the checks it clears today. All of it is fact about the filings, not a rating of the stock.