Warner Bros. Discovery, Inc. (WBD) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Warner Bros. Discovery, Inc. (WBD) Bundle
Designed for accuracy, our (WBD) DCF Calculator enables you to evaluate Warner Bros. Discovery, Inc. valuation using real-world financial data, while offering complete flexibility to modify all essential parameters for improved projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 11,144.0 | 10,671.0 | 12,191.0 | 33,817.0 | 41,321.0 | 54,976.5 | 73,144.9 | 97,317.4 | 129,478.3 | 172,267.6 |
| Revenue Growth, % | 0 | -4.24 | 14.24 | 177.39 | 22.19 | 33.05 | 33.05 | 33.05 | 33.05 | 33.05 |
| EBITDA | 4,360.0 | 3,779.0 | 3,655.0 | 41.0 | 6,384.0 | 13,204.3 | 17,567.9 | 23,373.7 | 31,098.1 | 41,375.3 |
| EBITDA, % | 39.12 | 35.41 | 29.98 | 0.12124 | 15.45 | 24.02 | 24.02 | 24.02 | 24.02 | 24.02 |
| Depreciation | 1,347.0 | 1,359.0 | 1,582.0 | 7,193.0 | 7,985.0 | 8,619.7 | 11,468.3 | 15,258.2 | 20,300.7 | 27,009.5 |
| Depreciation, % | 12.09 | 12.74 | 12.98 | 21.27 | 19.32 | 15.68 | 15.68 | 15.68 | 15.68 | 15.68 |
| EBIT | 3,013.0 | 2,420.0 | 2,073.0 | -7,152.0 | -1,601.0 | 4,584.6 | 6,099.7 | 8,115.5 | 10,797.4 | 14,365.7 |
| EBIT, % | 27.04 | 22.68 | 17 | -21.15 | -3.87 | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 |
| Total Cash | 1,552.0 | 2,091.0 | 3,905.0 | 3,731.0 | 3,780.0 | 9,426.8 | 12,542.1 | 16,686.9 | 22,201.5 | 29,538.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,633.0 | 2,537.0 | 2,446.0 | 7,611.0 | 7,312.0 | 11,838.4 | 15,750.7 | 20,955.9 | 27,881.3 | 37,095.3 |
| Account Receivables, % | 23.63 | 23.77 | 20.06 | 22.51 | 17.7 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 |
| Inventories | 453.0 | 970.0 | 668.0 | .0 | .0 | 2,048.9 | 2,726.0 | 3,626.9 | 4,825.5 | 6,420.2 |
| Inventories, % | 4.06 | 9.09 | 5.48 | 0 | 0 | 3.73 | 3.73 | 3.73 | 3.73 | 3.73 |
| Accounts Payable | 463.0 | 397.0 | 412.0 | 1,454.0 | 1,260.0 | 2,045.5 | 2,721.5 | 3,620.9 | 4,817.5 | 6,409.6 |
| Accounts Payable, % | 4.15 | 3.72 | 3.38 | 4.3 | 3.05 | 3.72 | 3.72 | 3.72 | 3.72 | 3.72 |
| Capital Expenditure | -289.0 | -402.0 | -373.0 | -987.0 | -1,316.0 | -1,706.9 | -2,271.0 | -3,021.4 | -4,020.0 | -5,348.4 |
| Capital Expenditure, % | -2.59 | -3.77 | -3.06 | -2.92 | -3.18 | -3.1 | -3.1 | -3.1 | -3.1 | -3.1 |
| Tax Rate, % | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 |
| EBITAT | 2,717.5 | 1,707.2 | 1,455.3 | -5,824.6 | -1,295.6 | 3,606.2 | 4,798.0 | 6,383.6 | 8,493.3 | 11,300.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,152.5 | 2,177.2 | 3,072.3 | -3,073.6 | 5,478.4 | 4,729.2 | 10,081.9 | 13,413.7 | 17,846.6 | 23,744.4 |
| WACC, % | 6.79 | 6.19 | 6.18 | 6.52 | 6.5 | 6.44 | 6.44 | 6.44 | 6.44 | 6.44 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 55,757.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 24,219 | |||||||||
| Terminal Value | 546,035 | |||||||||
| Present Terminal Value | 399,750 | |||||||||
| Enterprise Value | 455,507 | |||||||||
| Net Debt | 42,966 | |||||||||
| Equity Value | 412,541 | |||||||||
| Diluted Shares Outstanding, MM | 2,436 | |||||||||
| Equity Value Per Share | 169.35 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real WBD financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Warner Bros. Discovery’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Warner Bros. Discovery, Inc. (WBD).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable parameters specific to WBD.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Warner Bros. Discovery's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Warner Bros. Discovery, Inc. (WBD).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for streamlined analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based WBD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Warner Bros. Discovery's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose Warner Bros. Discovery, Inc. (WBD)?
- Extensive Content Library: Access a vast array of films and shows, catering to diverse audiences.
- Innovative Streaming Solutions: Cutting-edge technology enhances viewer experience across platforms.
- Global Reach: Engage with audiences worldwide, leveraging a strong international presence.
- Commitment to Quality: High production values ensure captivating storytelling and entertainment.
- Industry Leadership: A trusted name in media, recognized for excellence and creativity.
Who Should Use This Product?
- Investors: Evaluate Warner Bros. Discovery’s valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of leading media companies like Warner Bros. Discovery.
- Consultants: Provide comprehensive valuation analyses for clients in the media sector.
- Students and Educators: Utilize current data to explore and teach valuation principles.
What the Template Contains
- Preloaded WBD Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.