All companies
Warner Bros. Discovery logo
CommunicationsWBD

Warner Bros. Discovery (WBD) Financial Forecast Calculator

Interactive 5-year forecast and DCF for Warner Bros. Discovery. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from Warner Bros. Discovery’s most recent SEC filings.

Revenue FY30
$102.82B
from $41.32B
FCF FY30
$36.26B
Margin 35.3%
Enterprise value
$481.50B
11.7× LTM revenue
Equity value
$447.31B
Net debt $34.19B
Revenue & free cash flow - history and 5-year forecast
Line (area)
Bars
Historicals from SEC EDGAR (grey). Forecast years (color) update live as you move the sliders.

Assumptions

Revenue growth (annual)
20.0%
-10.0%baseline 20.0%40.0%
Gross margin
54.4%
5.0%baseline 54.4%90.0%
Capex % of revenue
3.1%
0.0%baseline 3.1%30.0%
WACC (discount rate)
9.00%
4.0%baseline 9.0%18.0%
Terminal growth
2.50%
0.0%baseline 2.5%5.0%

Need this as an Excel model?

Keep iterating on the Warner Bros. Discovery forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Frequently asked

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.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview