Williams Companies Financial Model
Oil and Gas Company Financials Example (Free Excel Download)
The Williams Companies, Inc. (WMB) is a premier midstream natural gas infrastructure company that gathers, processes, and transports approximately one-third of the natural gas consumed in the United States.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the dividend sustainability, cash flow generation, and equity valuation of Williams Companies to determine if the stock is an attractive income-generating investment for an infrastructure-focused portfolio.
The Williams Companies, Inc. (WMB) is a premier midstream natural gas infrastructure company that gathers, processes, and transports approximately one-third of the natural gas consumed in the United States. The company operates a 33,000-mile pipeline network, anchored by the Transco pipeline system, which delivers natural gas from the Gulf Coast to the Northeast and Southeast.
Business segments include:
- Transmission, Power & Gulf (~45% of Adjusted EBITDA): Interstate natural gas pipelines (including Transco) and offshore Gulf of Mexico gathering/transportation, plus recent power innovation investments.
- Northeast G&P (~30% of Adjusted EBITDA): Gathering and processing operations in the Marcellus and Utica shale plays.
- West (~20% of Adjusted EBITDA): Gathering, processing, and treating operations in the Rockies, DJ Basin, and Haynesville.
- Gas & NGL Marketing Services (~5% of Adjusted EBITDA): Wholesale marketing, trading, and risk management of natural gas and natural gas liquids.
The business model is highly asset-heavy and relies on fee-based, long-term take-or-pay contracts and regulated tariffs, providing significant cash flow visibility. Williams holds a dominant competitive position as the largest volume transporter of natural gas in the US. Recent major events include the late 2024 Crowheart upstream acquisition, the mid-2025 Saber Midstream acquisition in the Haynesville, a 2025 strategic investment in Cogentrix Energy (power innovation), and a major capital commitment to Woodside Energy's Louisiana LNG project.
The downloadable Williams Companies financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsWilliams Companies financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $12.78B | $17.77B | $12.00B | $12.63B | $14.90B |
| Operating and maintenance expenses | $1.55B | $1.82B | $1.98B | $2.18B | $2.28B |
| Operating income | $2.63B | $3.02B | $4.31B | $3.34B | $4.20B |
| Net income | $1.52B | $2.05B | $3.18B | $2.23B | $2.62B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Williams Companies
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Transmission, Power & Gulf
- Segment Name: Transmission, Power & Gulf (renamed from Transmission & Gulf of Mexico in 2025).
- Revenue Driver Formula: Contracted Capacity (MMDth/d) x Regulated Tariff Rate x 365 days.
- Historical Growth Rate: 5-8% CAGR.
- Key Growth Levers: Transco expansion projects, new deepwater Gulf of Mexico tie-backs, and power generation integration (Cogentrix).
- Pricing Dynamics: Regulated by the Federal Energy Regulatory Commission (FERC); highly stable take-or-pay contracts.
- Revenue Recognition: Recognised over time as capacity is provided, regardless of actual volumetric throughput (reservation charges).
- Seasonality: Relatively stable, though winter heating demand can drive minor volumetric upside.
Northeast G&P
- Segment Name: Northeast G&P.
- Revenue Driver Formula: Gathered Volumes (Bcf/d) x Gathering Fee ($/Mcf).
- Historical Growth Rate: 3-5% CAGR.
- Key Growth Levers: Producer drilling activity in the Marcellus and Utica shales; debottlenecking projects.
- Pricing Dynamics: Long-term acreage dedication contracts with fee-based structures; some exposure to minimum volume commitments (MVCs).
- Revenue Recognition: Recognised as volumes are physically gathered and processed.
- Seasonality: Minor weather-related disruptions in winter.
West
- Segment Name: West.
- Revenue Driver Formula: Gathered/Processed Volumes (Bcf/d) x Blended Fee ($/Mcf).
- Historical Growth Rate: 8-12% CAGR (boosted by acquisitions).
- Key Growth Levers: Integration of the DJ Basin acquisitions (Cureton, Rocky Mountain Midstream) and Haynesville expansion (Saber Midstream).
- Pricing Dynamics: Fee-based contracts, though historically this segment had slightly more commodity price exposure than the Northeast.
- Revenue Recognition: Recognised upon delivery of gathering, processing, and treating services.
- Seasonality: Minimal.
Gas & NGL Marketing Services
- Segment Name: Gas & NGL Marketing Services.
- Revenue Driver Formula: Marketed Volumes x Commodity Margin (Realised Price less Product Cost).
- Historical Growth Rate: Highly volatile (can swing 50%+ year-over-year).
- Key Growth Levers: Geographic basis differentials, storage optimisation, and NGL fractionation spreads.
- Pricing Dynamics: Spot and short-term forward market pricing.
- Revenue Recognition: Point in time upon physical delivery or financial settlement of derivatives.
- Seasonality: Strongest in Q1 and Q4 due to winter heating demand volatility.
Cost Structure
Variable Costs / COGS
- Breakdown: Product costs (purchased natural gas and NGLs for the marketing segment), fuel, and power for compressor stations.
- Gross Margin Range: Not a primary metric for midstream companies; focus is on Adjusted EBITDA. Product costs scale linearly with Marketing segment revenues but are largely passed through in the fee-based segments.
- Key Input Costs: Electricity and natural gas (used as compressor fuel).
Operating Expenses
- Operating & Maintenance (O&M): The largest cash expense. Includes labour, maintenance materials, pipeline integrity management, and property taxes. Typically runs at 25-30% of service revenues.
- SG&A: Corporate overhead, IT, and administrative headcount. Runs at approximately 5-7% of total revenues.
- Depreciation & Amortisation: Extremely high due to the capital-intensive pipeline network. Typically 15-20% of total revenues.
- Stock-Based Compensation: Minor, typically under 1% of revenue.
- Restructuring / Impairments: Occasional non-cash impairments (e.g., $212 million in 2025 related to Mid-Continent asset sales).
Margin Profile
- Adjusted EBITDA Margin: Typically 65-70% of service revenues.
- Margin Trend: Expanding slightly due to operating leverage on Transco expansions and synergies from recent DJ Basin and Haynesville acquisitions.
- Segment Margins: Transmission, Power & Gulf operates at the highest margins (75%+), while Marketing operates at very low, volatile margins.
Balance Sheet Structure
- Total Assets: Approximately $50 billion to $55 billion.
- Key Asset Categories: Property, Plant, and Equipment (PP&E) makes up the vast majority of assets (pipelines, compressor stations, processing plants).
- Goodwill & Intangibles: Significant (15-20% of assets) due to a history of acquisitions including MountainWest, Cureton, and Saber Midstream.
- Working Capital Profile:
- DSO: 30-45 days.
- DPO: 30-45 days.
- Net Working Capital: Generally neutral to slightly negative. The company does not rely on working capital to fund growth.
- PP&E: Depreciated over 20 to 50 years. Maintenance capex is a small fraction of total gross PP&E, while growth capex drives the balance sheet expansion.
- Right-of-Use Assets: Immaterial relative to the massive owned PP&E base.
Capital Expenditure & Investment
- Capex as % of Revenue: Highly variable based on project backlog; typically 25-40%.
- Maintenance vs. Growth: Maintenance capex is strictly controlled ($850 million to $950 million guided for 2026). Growth capex is substantial ($6.1 billion to $6.7 billion guided for 2026, driven by the Woodside LNG and Cogentrix investments).
- Major Programmes: Transco corridor expansions, deepwater Gulf of Mexico tie-backs, Louisiana LNG infrastructure, and power innovation projects.
- M&A Pattern: Serial acquirer of bolt-on regional gathering systems (DJ Basin, Haynesville) and strategic adjacencies (Cogentrix power).
Debt & Capital Structure
- Total Debt: Approximately $28 billion to $32 billion.
- Debt/EBITDA Ratio: Target is approximately 4.0x for 2026 (increased from 3.55x in 2025 due to heavy growth capex funding).
- Credit Rating: Investment grade (BBB / Baa2).
- Key Debt Instruments: Long-term senior unsecured notes, supported by a multi-billion dollar revolving credit facility.
- Maturity Profile: Well-laddered with average maturities exceeding 10 years.
- Interest Rate Profile: Predominantly fixed-rate bonds.
- Share Repurchases: Not a primary capital return vehicle; cash is directed to dividends and growth capex.
- Dividend Policy: Highly active. 2026 dividend set at $2.10 per share (up 5% from 2025). Payout ratio is managed against Available Funds From Operations (AFFO), with a coverage ratio typically between 2.2x and 2.5x.
Cash Flow Characteristics
- Operating Cash Flow (OCF): $5.898 billion in 2025.
- OCF / Net Income: Typically 2.0x to 2.5x due to massive non-cash D&A and deferred taxes.
- Available Funds From Operations (AFFO): The critical midstream cash flow metric. $5.858 billion in 2025.
- Major Non-Cash Items: D&A, unrealised gains/losses on commodity derivatives, and equity earnings from investees.
- Capex Intensity: Very high. Free cash flow after growth capex is often negative during major build cycles, requiring debt funding.
- Cash Tax Rate: Very low compared to the statutory rate due to accelerated depreciation (MACRS) on pipeline assets.
Sheet Structure
- Assumptions: Macro drivers (Henry Hub pricing), segment volume growth rates, tariff escalators, and capex guidance.
- Volumes & Rates: Operating statistics including Transco contracted capacity (MMDth/d), Northeast gathering volumes (Bcf/d), and West gathering volumes.
- Revenues: Segment-level revenue build for Transmission, Power & Gulf; Northeast G&P; West; and Gas & NGL Marketing Services.
- O&M & EBITDA: Segment-level O&M expenses, corporate SG&A, proportional EBITDA from equity investees, and the consolidated Adjusted EBITDA bridge.
- Capex & PP&E: Split between maintenance capex and growth capex, PP&E roll-forward, and depreciation schedule.
- Income Statement: Consolidated GAAP view from Service Revenues down to Net Income Attributable to Williams.
- Balance Sheet: Standard asset and liability line items, highlighting PP&E, Goodwill, and Long-Term Debt.
- Cash Flow & AFFO: OCF calculation, working capital changes, and the specific bridge to Available Funds From Operations (AFFO) and Dividend Coverage Ratio.
- Debt Schedule: Tranche-level debt tracking, interest expense calculation, and Debt/Adjusted EBITDA leverage ratio monitoring.
- DCF Valuation: Unlevered free cash flow calculation, WACC assumptions, terminal value, and implied share price.
Key Financial Relationships
- `Transmission, Power & Gulf Revenue = Prior Year Revenue * (1 + Tariff Escalator) + Revenue from New Projects Placed in Service`
- `Northeast G&P Revenue = Northeast Gathered Volumes (Bcf/d) * Northeast Average Fee ($/Mcf) * 365`
- `West Revenue = West Gathered Volumes (Bcf/d) * West Average Fee ($/Mcf) * 365`
- `Total Service Revenues = Transmission, Power & Gulf Revenue + Northeast G&P Revenue + West Revenue`
- `Adjusted EBITDA = Total Service Revenues + Product Sales - Product Costs - O&M Expenses - SG&A + Proportional EBITDA of Equity Investees`
- `Depreciation Expense = Beginning Gross PP&E * Blended Depreciation Rate (approx. 3-4%)`
- `Interest Expense = Average Total Debt * Weighted Average Interest Rate`
- `Available Funds From Operations (AFFO) = Cash Flow from Operations - Changes in Working Capital - Maintenance Capex - Preferred Dividends`
- `Dividend Coverage Ratio = AFFO / Total Common Dividends Paid`
- `Leverage Ratio = Total Debt / Adjusted EBITDA`
Cross-Sheet Dependencies
- The Volumes & Rates sheet drives the Revenues sheet.
- The Revenues and O&M & EBITDA sheets feed directly into the Income Statement and the Cash Flow & AFFO sheet.
- The Capex & PP&E sheet dictates the PP&E balance on the Balance Sheet and the Depreciation expense on the Income Statement.
- The Cash Flow & AFFO sheet determines the funding gap, which feeds the Debt Schedule to calculate required borrowing.
- The Debt Schedule calculates Interest Expense, creating a circular reference with the Income Statement and Cash Flow & AFFO sheet (requires an iterative calculation toggle).
Sign Convention
- Revenues, Volumes, and Asset balances are entered as positive numbers.
- Expenses (O&M, SG&A, Interest) are entered as positive numbers in their specific schedules but subtracted in the Income Statement and EBITDA bridges.
- Capital Expenditures and Dividends Paid are entered as negative numbers in the Cash Flow statement to represent outflows.
- Debt paydowns are negative; debt issuances are positive.
Things Most Likely to Go Wrong
- Failing to distinguish between Modified EBITDA and Adjusted EBITDA. Modified EBITDA includes unrealised derivative mark-to-market swings, which must be excluded to calculate true Adjusted EBITDA.
- Mishandling equity-method investees. Williams includes proportional EBITDA from joint ventures (like Appalachia Midstream and Cogentrix) in its Adjusted EBITDA, but these do not flow through consolidated revenue.
- Applying a standard Free Cash Flow yield valuation. Midstream companies are valued on AFFO and Dividend Yield; deducting massive growth capex will make the company look artificially cash-flow negative.
- Ignoring the 2025 segment renaming. The model must use "Transmission, Power & Gulf" rather than the legacy "Transmission & Gulf of Mexico" to reflect the Cogentrix integration.
- Overestimating Marketing segment margins. This segment is highly volatile and should be modelled with conservative, cycle-average margins rather than recent peak figures.
- Miscalculating the Leverage Ratio. The covenant calculation uses Adjusted EBITDA, not GAAP Operating Income or Net Income.
- Forgetting to deduct Maintenance Capex when calculating AFFO. Growth capex is excluded from AFFO, but maintenance capex must be subtracted.
- Double-counting the Crowheart and Saber Midstream acquisitions. Ensure historical growth rates are normalised for these inorganic additions before projecting future organic growth.
Validation Checks
- Adjusted EBITDA must reconcile to the 2026 guidance midpoint of $8.2 billion.
- Leverage Ratio (Total Debt / Adjusted EBITDA) should hover around the 4.0x management target for 2026; flag if it exceeds 4.25x.
- Dividend Coverage Ratio (AFFO / Dividends Paid) must remain above 2.0x (historically 2.3x to 2.4x).
- Maintenance Capex should be strictly bound between $850 million and $950 million for 2026.
- Growth Capex should reflect the elevated $6.1 billion to $6.7 billion guidance for 2026.
- Total Assets must equal Total Liabilities plus Equity in every forecast period.
- Effective tax rate should remain low (typically under 15% cash tax rate) due to MACRS depreciation benefits.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| 2026 Adjusted EBITDA Target | 8,200 | $ Millions | Midpoint of management's 2026 guidance (Feb 2026). |
| 2026 Growth Capex | 6,400 | $ Millions | Midpoint of 2026 guidance ($6.1B - $6.7B) driven by LNG and power projects. [1] |
| 2026 Maintenance Capex | 900 | $ Millions | Midpoint of 2026 guidance ($850M - $950M). [1] |
| 2026 Annual Dividend per Share | 2.10 | $ / Share | Management declared 5% increase for 2026. [1] |
| Target Leverage Ratio | 4.0 | x | Management guidance for 2026 (up from 3.65x in 2025). [1] |
| Transmission, Power & Gulf Rev Growth | 6.0 | % | Reflects Transco expansions and new Gulf volumes. |
| Northeast G&P Volume Growth | 3.0 | % | Mature basin with steady, low-single-digit growth. |
| West Volume Growth | 8.0 | % | Higher growth driven by recent Haynesville and DJ Basin acquisitions. |
| O&M as % of Service Revenue | 28.0 | % | Historical average; reflects fixed-cost nature of pipelines. |
| SG&A as % of Total Revenue | 6.0 | % | Historical average. |
| Blended Interest Rate on Debt | 5.2 | % | Based on current weighted average cost of fixed-rate debt. |
| Effective Tax Rate | 22.0 | % | GAAP tax rate (cash taxes will be significantly lower). |
| WACC | 7.5 | % | Standard midstream discount rate reflecting stable regulated cash flows. |
| Terminal EV/EBITDA Multiple | 10.5 | x | Long-term historical average for large-cap midstream peers. |
Data Sources & Benchmarks
- Filings: SEC EDGAR for WMB 10-K and 10-Q filings; Williams Investor Relations website for earnings presentations and non-GAAP reconciliations.
- Key Peers: Kinder Morgan (KMI), ONEOK (OKE), Energy Transfer (ET), Enterprise Products Partners (EPD).
- Industry Data: US Energy Information Administration (EIA) for natural gas production and consumption forecasts; Federal Energy Regulatory Commission (FERC) for tariff rate case filings.
- Consensus Estimates: Bloomberg or FactSet for forward EBITDA and AFFO estimates.
Sources
Do more with the Williams Companies model
Frequently asked
What does Williams Companies (WMB) do?+
Williams Companies is a premier midstream natural gas infrastructure company that gathers, processes, and transports approximately one-third of the natural gas consumed in the United States. Its extensive 33,000-mile pipeline network, anchored by the Transco system, delivers natural gas across various regions.
How does Williams Companies generate revenue?+
Williams Companies generates revenue primarily through fee-based, long-term take-or-pay contracts and regulated tariffs from its highly asset-heavy infrastructure. This business model provides significant cash flow visibility across its Transmission, Power & Gulf, Northeast G&P, West, and Gas & NGL Marketing Services segments.
What are the key capital expenditure assumptions for Williams Companies?+
Capital expenditure for Williams Companies is highly variable, typically ranging from 25-40% of revenue, driven by a substantial project backlog. While maintenance capex is controlled, growth capex is significant, fueled by major programs like Transco corridor expansions and LNG infrastructure.
What is the purpose of the financial model for Williams Companies?+
The financial model for Williams Companies evaluates the dividend sustainability, cash flow generation, and equity valuation of the company. Its primary goal is to determine if WMB stock represents an attractive income-generating investment for an infrastructure-focused portfolio.
Can I download a financial model for Williams Companies (WMB)?+
Yes, a downloadable Excel financial model is available for Williams Companies (WMB). This general corporate model provides a forecast horizon from FY2026 to FY2030, allowing users to analyze future financial performance.
What are the main assumptions regarding Williams Companies' net working capital?+
Williams Companies typically maintains a neutral to slightly negative net working capital profile. The company does not rely on working capital to fund growth, with key metrics like Days Sales Outstanding and Days Payables Outstanding generally ranging from 30-45 days.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Oil and Gas Company Financial Models
Browse another company in the same sector.
APA
APA Corporation is an independent energy company that explores for, develops, and produces natural gas, crude oil, and natural gas liquids (NGLs).
Baker Hughes
Baker Hughes Company is a global energy technology firm that provides solutions to energy and industrial customers worldwide.
ConocoPhillips
ConocoPhillips is the world's largest independent exploration and production (E&P) company, focused exclusively on the upstream segment of the oil and gas industry after spinning off its downstream operations in 2012.
Coterra
Coterra Energy is a premier, diversified independent oil and natural gas exploration and production (E&P) company based in Houston, Texas.
Chevron
Chevron Corporation is a premier global integrated energy company engaged in every aspect of the oil, natural gas, and geothermal energy industries.
Devon Energy
Devon Energy Corporation is a leading independent oil and natural gas exploration and production company focused entirely on onshore operations in the United States.
EOG Resources
EOG Resources is one of the largest independent crude oil and natural gas exploration and production (E&P) companies in the United States.
EQT
EQT Corporation is the largest natural gas producer in the United States, operating primarily in the Appalachian Basin across the Marcellus and Utica shales.
Explore more Energy financial model templates.
