# Warner Bros. Discovery (WBD) Financial Model

Free Excel 3-statement financial model and company analysis for Warner Bros. Discovery.

- Canonical: https://finamodel.com/companies/warner-bros-discovery
- Industry: Media
- Downloadable model: Yes
- Excel download: https://finamodel.com/company-models/WBD.xlsx

## Model Purpose

This model evaluates Warner Bros. Discovery's standalone equity valuation and cash flow generation capacity to assess the fairness of the proposed $31 per share acquisition by Paramount Skydance, focusing on the critical transition from linear network cash cows to direct-to-consumer streaming profitability.

## Company Overview

Warner Bros. Discovery (WBD) is a premier global media and entertainment company that creates and distributes a portfolio of content, brands, and franchises across television, film, and streaming. The company operates through three segments: Networks (approximately 48% of revenue), Studios (approximately 25% of revenue), and Direct-to-Consumer or DTC (approximately 27% of revenue). While the company generates significant revenue in the United States, it has a massive global footprint with its Max streaming service available in over 70 countries. WBD operates an asset-heavy business model reliant on a vast content library and continuous capital-intensive production, monetised through subscription fees, advertising, theatrical ticket sales, and content licensing. The company competes fiercely with Disney, Netflix, and Universal in a consolidating industry. Recent major events include the 2022 merger of WarnerMedia and Discovery, a massive $9.1 billion non-cash goodwill impairment in the Networks segment in 2024, and a proposed acquisition by Paramount announced in February 2026.

## Revenue Deep Dive



### Networks

- **Segment name:** Networks
- **Revenue driver formula:** (Linear Subscribers x Affiliate Fee per Month x 12) + (Linear Audience x Advertising CPM) + Content Licensing
- **Historical growth rate:** Declining at 4% to 6% annually
- **Key growth levers and headwinds:** Cord-cutting and domestic linear pay TV subscriber declines are severe headwinds, compounded by softness in the domestic linear advertising market.
- **Pricing dynamics:** Contractual affiliate fees negotiated with distributors (often resulting in carriage disputes), while advertising is spot and upfront market-driven.
- **Revenue recognition notes:** Affiliate fees recognised over the contract term; advertising recognised when spots are aired.
- **Seasonality:** Q4 is typically stronger for advertising due to holiday spending and sports programming.

### Studios

- **Segment name:** Studios
- **Revenue driver formula:** (Theatrical Releases x Average Box Office) + (TV Series Produced x Licensing Fee) + Games Revenue
- **Historical growth rate:** Highly volatile, ranging from -10% to +15% depending on the release slate
- **Key growth levers and headwinds:** Hit-driven business dependent on franchise success (e.g., DC Universe, Harry Potter). Strike impacts (WGA/SAG-AFTRA) caused delivery delays in prior years.
- **Pricing dynamics:** Theatrical splits with exhibitors; competitive bidding for TV series licensing.
- **Revenue recognition notes:** Theatrical recognised as films are exhibited; TV licensing recognised when content is delivered and available for use by the licensee.
- **Seasonality:** Summer and holiday quarters typically see higher theatrical revenues.

### Direct-to-Consumer (DTC)

- **Segment name:** Direct-to-Consumer (DTC)
- **Revenue driver formula:** (Average Global DTC Subscribers x Global DTC ARPU x 12) + (Ad-lite Subscribers x Ad ARPU)
- **Historical growth rate:** 5% to 10% annually
- **Key growth levers and headwinds:** International expansion (launches in UK, Germany, Italy) and password sharing crackdowns are key levers, offset by high churn rates and domestic market saturation.
- **Pricing dynamics:** Subscription pricing is highly competitive but increasing; ad-tier pricing relies on programmatic and direct ad sales.
- **Revenue recognition notes:** Subscription revenue deferred and recognised rateably over the month.
- **Seasonality:** Subscriber additions can spike around major premiere events (e.g., House of the Dragon).

## Cost Structure



### Variable Costs / COGS

- **Line-by-line breakdown:** Costs of revenues primarily consist of content amortisation, revenue sharing, theatrical print and advertising (P&A), and distribution costs.
- **Gross margin range:** 39% to 46% over the last 5 years, averaging around 42%.
- **Key input costs and commodity exposures:** Talent costs, production crew labour, and location expenses.
- **How COGS scales with revenue:** Content amortisation is largely fixed in the short term based on historical spend, creating high operating leverage. P&A scales directly with theatrical releases.

### Operating Expenses

- **R&D:** Not material or separately disclosed; technology costs for the Max platform are embedded in SG&A and COGS.
- **SG&A:** Includes marketing, advertising, and general administrative costs. Marketing is highly variable and tied to the release slate and DTC subscriber acquisition campaigns.
- **Depreciation & Amortisation:** Extremely high due to the 2022 merger. Includes acquisition-related amortisation of intangibles and content fair value step-ups.
- **Stock-Based Compensation:** Runs at approximately 1% to 2% of revenue.
- **Restructuring / one-time charges:** Frequent and massive, including a $9.1 billion goodwill impairment in 2024 and billions in ongoing restructuring and integration costs.

### Margin Profile

- **Gross margin:** 39% to 46%
- **Adjusted EBITDA margin:** 20% to 25% (Total Adjusted EBITDA was $9.0 billion on $39.3 billion revenue in 2024, approximately 23%).
- **Margin trend:** Stable at the consolidated level, but underlying mix is shifting. Networks margins are compressing due to revenue declines, while DTC margins are expanding rapidly (swinging from losses to a $677 million profit in 2024).

## Balance Sheet Structure

- **Total assets:** Approximately $100 billion.
- **Key asset categories:** Content library, goodwill, and intangible assets (trademarks, customer relationships).
- **Goodwill & intangibles as % of total assets:** Over 60%, even after the massive 2024 impairment charges.
- **Working capital profile:**
  - **Days Sales Outstanding (DSO):** 60 to 75 days.
  - **Days Inventory Outstanding (DIO):** Not applicable in traditional terms; content is capitalised and amortised.
  - **Days Payable Outstanding (DPO):** 90 to 110 days.
  - **Net working capital as % of revenue:** Typically negative.
  - **Is working capital positive or negative?** Negative. The company benefits from deferred revenue (upfront subscription payments) and extended payable terms with production vendors.
- **PP&E:** Consists of studio facilities, broadcasting equipment, and corporate offices.
- **Right-of-use assets / operating leases:** Material, representing long-term leases for office space and production facilities.

## Capital Expenditure & Investment

- **Capex as % of revenue:** 2% to 3% (Purchases of property and equipment were $948 million in 2024).
- **Maintenance capex vs. growth capex:** Mostly maintenance for broadcasting and studio facilities; growth investment is funnelled into content creation rather than traditional capex.
- **Major capex programmes underway:** Upgrades to the Max streaming platform infrastructure.
- **Capitalised software / development costs:** Material for the DTC platform.
- **M&A pattern:** Transformational. The company is the product of a mega-merger and is currently the target of a proposed $81 billion equity value acquisition by Paramount.

## Debt & Capital Structure

- **Total debt:** $34.6 billion net debt at the end of 2024 (Gross debt approximately $39.5 billion).
- **Debt/EBITDA ratio:** 3.8x net leverage at the end of 2024, with a target of reaching below 3.0x.
- **Credit rating:** BBB- / Baa3 (investment grade, but on the lowest rung).
- **Key debt instruments:** Senior unsecured notes with staggered maturities, term loans, and a revolving receivables programme.
- **Maturity profile:** The company has been actively paying down near-term maturities using free cash flow to smooth the maturity wall.
- **Interest rate profile:** Predominantly fixed-rate bonds, with a weighted average cost of debt around 4.5% to 5.0%.
- **Covenants:** Standard investment-grade covenants; maintaining the rating is critical to avoid step-up interest penalties.
- **Share repurchase programme:** Paused. All free cash flow is currently directed toward debt paydown.
- **Dividend policy:** No dividend.

## Cash Flow Characteristics

- **Operating cash flow conversion:** Strong. Cash provided by operating activities was $5.4 billion in 2024.
- **Free cash flow margin:** Approximately 11% ($4.4 billion FCF on $39.3 billion revenue in 2024).
- **Major non-cash items:** $9.1 billion goodwill impairment, $7.5 billion of acquisition-related amortisation and restructuring, and standard content amortisation.
- **Working capital cash flow impact:** Timing of content production spend versus amortisation is the biggest driver of cash flow variance.
- **Capex intensity:** Low for traditional PP&E, but "content capex" (cash spend on content) is massive and must be modelled separately.
- **Cash tax rate vs. GAAP effective tax rate:** Cash taxes are significantly lower than the statutory rate due to massive historical net operating losses (NOLs) and amortisation tax shields from the merger.

## Sheet Structure

1. **Assumptions**: Hardcoded drivers for macroeconomic inputs, segment growth rates, ARPU, margins, and WACC.
2. **Scenarios**: Toggle for Standalone WBD vs. Paramount Acquisition (adjusts debt paydown, synergies, and terminal value).
3. **Income Statement**: Consolidated GAAP income statement mirroring the 10-K, ending in Net Income Available to WBD.
4. **Balance Sheet**: Standard assets, liabilities, and equity, with specific breakouts for Capitalised Content and Deferred Revenue.
5. **Cash Flow Statement**: Indirect method starting from Net Income, adding back massive D&A and impairments, adjusting for working capital and content spend.
6. **Segment Build - Networks**: Revenue split by Distribution, Advertising, and Content. Calculates Networks Adjusted EBITDA.
7. **Segment Build - Studios**: Revenue split by Theatrical, TV, and Games. Calculates Studios Adjusted EBITDA.
8. **Segment Build - DTC**: Revenue split by Subscriber-related, Advertising, and Content. Tracks Global Subscribers and ARPU. Calculates DTC Adjusted EBITDA.
9. **Content Schedule**: Roll-forward of the capitalised content asset (Beginning Balance + Cash Content Spend - Content Amortisation = Ending Balance).
10. **Debt Schedule**: Tranche-by-tranche maturity profile, interest expense calculation, and mandatory vs. optional paydown logic.
11. **DCF & Valuation**: Unlevered free cash flow calculation, terminal value, enterprise value to equity value bridge, and per-share output to compare against the $31 Paramount offer.

## Key Financial Relationships

1. `DTC Subscriber Revenue = Average Global DTC Subscribers x Global DTC ARPU x 12`
2. `Networks Distribution Revenue = Prior Year Distribution Revenue x (1 + Linear Subscriber Decline Rate + Affiliate Fee Pricing Growth)`
3. `Networks Advertising Revenue = Prior Year Advertising Revenue x (1 + Audience Decline Rate + CPM Growth)`
4. `Studios Revenue = Prior Year Studios Revenue x (1 + Slate Release Growth Assumption)`
5. `Total Segment Adjusted EBITDA = Networks Adj EBITDA + Studios Adj EBITDA + DTC Adj EBITDA - Corporate Eliminations`
6. `Content Amortisation = Beginning Capitalised Content Balance x Blended Amortisation Rate`
7. `Ending Capitalised Content = Beginning Capitalised Content + Cash Content Spend - Content Amortisation`
8. `Interest Expense = Average Total Debt Balance x Weighted Average Interest Rate`
9. `Free Cash Flow = Cash Provided by Operating Activities - Purchases of Property and Equipment`
10. `Net Debt = Total Debt - Cash and Cash Equivalents`
11. `Net Leverage Ratio = Net Debt / Total Segment Adjusted EBITDA`
12. `Implied Share Price = (Enterprise Value - Net Debt) / Fully Diluted Shares Outstanding`

## Cross-Sheet Dependencies

The **Assumptions** sheet feeds the three **Segment Builds** (Networks, Studios, DTC). The Segment Builds calculate Revenue and Adjusted EBITDA, which feed directly into the **Income Statement**. The **Content Schedule** calculates cash content spend (which feeds the **Cash Flow Statement** operating section) and content amortisation (which feeds the **Income Statement** COGS). The **Cash Flow Statement** generates the cash balance and cash available for debt paydown, which feeds the **Debt Schedule**. The **Debt Schedule** calculates interest expense, feeding back into the **Income Statement** (creating a circular reference that requires an iterative calculation or a switch). Finally, the **Income Statement**, **Balance Sheet**, and **Cash Flow Statement** feed the **DCF & Valuation** sheet.

## Sign Convention

- **Revenues, Assets, and Equity:** Entered and displayed as positive numbers.
- **Expenses (COGS, SG&A, Interest):** Entered as positive numbers in their specific schedules, but subtracted in aggregation formulas (e.g., `Gross Profit = Revenue - COGS`).
- **Liabilities and Debt:** Entered and displayed as positive numbers.
- **Cash Flow Statement:** Cash inflows are positive; cash outflows (capex, debt paydown, cash content spend) are negative.

## Things Most Likely to Go Wrong

1. **Content Spend vs. Amortisation:** The model must distinguish between cash spent on content (a cash outflow) and content amortisation (a non-cash income statement expense). Confusing these will break the cash flow conversion logic.
2. **Goodwill Impairments:** WBD took a $9.1 billion non-cash impairment in 2024. The model must exclude this from run-rate operating expenses to avoid artificially depressing future margins.
3. **Acquisition-Related Amortisation:** The $7.5 billion in pre-tax acquisition-related amortisation and restructuring in 2024 must be added back to calculate Adjusted EBITDA, which is the metric management and debt covenants use.
4. **Circularity in Debt Paydown:** Because WBD sweeps all free cash flow to debt paydown, interest expense depends on the debt balance, which depends on cash flow, which depends on interest expense. A circuit breaker toggle is required.
5. **DTC ARPU Blending:** Global ARPU ($7.44) is heavily diluted by international expansion. Domestic ARPU is much higher (~$11.77). The model must account for the mix shift as international subscribers grow faster than domestic.
6. **Corporate Eliminations:** Segment Adjusted EBITDA does not sum perfectly to Total Adjusted EBITDA; the model must include a line for corporate expenses and inter-segment eliminations (e.g., Studios licensing content to DTC).
7. **AT&T SportsNet Exit:** Historical Networks revenue includes regional sports networks that were exited. Forward projections must step down the baseline to account for this.
8. **Tax Shields:** WBD pays very little cash tax compared to its GAAP tax provision due to NOLs and amortisation. The DCF must use the cash tax rate, not the statutory rate, to accurately reflect free cash flow.

## Validation Checks

1. "Total Revenue should equal the sum of Networks, Studios, and DTC revenues less inter-segment eliminations."
2. "Free Cash Flow conversion (FCF / Adjusted EBITDA) should remain in the 45% to 50% range based on management guidance."
3. "Net Leverage (Net Debt / Adjusted EBITDA) should decrease sequentially each year, targeting <3.0x by 2026."
4. "Global DTC Subscribers must hit 150 million by the end of 2026 to align with management's stated clear path."
5. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
6. "Networks Adjusted EBITDA margin should compress slightly year-over-year, reflecting the loss of high-margin linear affiliate fees."
7. "DTC Adjusted EBITDA must remain positive and grow, reflecting the segment's 2024 swing to profitability ($677 million)."
8. "Total Debt balance must not increase; all excess cash flow should be routed to debt reduction."

## Key Assumptions (Default Values)

| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Total Global DTC Subscribers (2024A) | 116.9 | Millions | Actual reported figure for Q4 2024. |
| DTC Subscriber Target (2026E) | 150.0 | Millions | Management's stated target in the 2024 shareholder letter. |
| Global DTC ARPU | 7.44 | USD/Month | Actual reported Q4 2024 blended ARPU. |
| Networks Revenue Growth | -4.0 | % | Reflects ongoing cord-cutting and linear advertising softness. |
| Studios Revenue Growth | 3.0 | % | Normalised growth post-strike recovery. |
| Total Adjusted EBITDA Margin | 23.0 | % | Based on $9.0B EBITDA on $39.3B revenue in 2024. |
| Cash Content Spend as % of Revenue | 45.0 | % | Historical average required to feed the Studios and DTC pipelines. |
| Capex (PP&E) as % of Revenue | 2.5 | % | Based on $948M capex on $39.3B revenue in 2024. |
| Effective Cash Tax Rate | 15.0 | % | Lower than statutory due to historical NOLs and merger tax shields. |
| Weighted Average Interest Rate | 4.8 | % | Blended rate on WBD's fixed-rate senior notes. |
| WACC | 8.5 | % | Standard discount rate for a highly levered media conglomerate. |
| Terminal Growth Rate | 1.0 | % | Conservative long-term growth reflecting linear decline offset by streaming. |
| Paramount Acquisition Offer Price | 31.00 | USD/Share | Announced transaction price in February 2026. |

## Data Sources & Benchmarks

- **Filings:** SEC EDGAR for WBD 10-K (filed February 2025) and Q4 2024 Earnings Release.
- **Investor Relations:** WBD IR website for trending schedules and shareholder letters.
- **Peers for Benchmarking:** The Walt Disney Company (DIS), Netflix (NFLX), Paramount Global (PARA), Comcast (CMCSA).
- **Industry Data:** Nielsen for linear viewership and cord-cutting trends; Antenna for streaming subscriber churn and acquisition data.
- **Consensus Estimates:** FactSet or Bloomberg for forward-looking street estimates on DTC subscriber additions.

## Sources

- Warner Bros. Discovery Q4 2024 Earnings Press Release (February 27, 2025)
- Warner Bros. Discovery 2024 Annual Report on Form 10-K
- Paramount Global Acquisition Announcement Press Release (February 27, 2026)
- Macrotrends WBD Long Term Debt and Margin History
- Simply Wall St WBD Balance Sheet Metrics

## Frequently asked questions

### What is Warner Bros. Discovery's core business?

Warner Bros. Discovery is a leading global media and entertainment company that creates and distributes content across television, film, and streaming platforms. It operates through its Networks, Studios, and Direct-to-Consumer segments, leveraging a vast content library and well-known franchises.

### How does Warner Bros. Discovery generate its revenue?

Warner Bros. Discovery generates revenue through a mix of subscription fees from its Max streaming service, advertising sales, theatrical ticket sales, and content licensing. These revenue streams are diversified across its three main business segments.

### What are some key financial assumptions used in the Warner Bros. Discovery model?

Key assumptions in the Warner Bros. Discovery financial model include a revenue growth rate of 0.2, COGS as 45.6% of revenue, and SGA as 27.1% of revenue. The model also incorporates a tax rate of 16.1% and capital expenditure as 3.1% of revenue.

### What is the primary objective of the Warner Bros. Discovery financial model?

The financial model aims to evaluate Warner Bros. Discovery's standalone equity valuation and its capacity to generate cash flow. A key purpose is to assess the fairness of the proposed $31 per share acquisition by Paramount Skydance.

### Is an Excel financial model available for Warner Bros. Discovery?

Yes, an Excel financial model for Warner Bros. Discovery is available for download. This model provides a forecast horizon from FY2026 through FY2030, allowing for detailed financial analysis.

### What is Warner Bros. Discovery's working capital strategy?

Warner Bros. Discovery typically maintains a negative net working capital profile as a percentage of revenue. This is primarily due to the benefits derived from deferred revenue, which comes from upfront subscription payments, and extended payable terms with its production vendors.

[Interactive forecast calculator](https://finamodel.com/companies/warner-bros-discovery/forecast)