Walt Disney Financial Model
Media Company Financials Example (Free Excel Download)
The Walt Disney Company is a diversified global entertainment conglomerate that produces premium content, operates direct-to-consumer streaming services, broadcasts live sports, and operates world-renowned theme parks and cruise lines.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the equity valuation and cash flow generation capacity of The Walt Disney Company, enabling an analyst to assess whether the transition of its linear networks to a profitable Direct-to-Consumer (DTC) streaming model, combined with the cash-generative Experiences segment, justifies its current market valuation.
- What the company does: The Walt Disney Company is a diversified global entertainment conglomerate that produces premium content, operates direct-to-consumer streaming services, broadcasts live sports, and operates world-renowned theme parks and cruise lines.
- Business segments:
- Entertainment (~44% of revenue): Linear Networks, Direct-to-Consumer (Disney+, Hulu), and Content Sales/Licensing.
- Experiences (~39% of revenue): Domestic and International Parks, Disney Cruise Line, and Consumer Products.
- Sports (~17% of revenue): ESPN and Star India (prior to deconsolidation).
- Key geographies: Primarily Americas (~80% of revenue), with significant operations in Europe and Asia-Pacific.
- Business model type: IP-driven flywheel. Disney monetises its core intellectual property across multiple touchpoints: theatrical release, streaming, linear television, theme park attractions, and consumer merchandise.
- Competitive position: Market leader in theme parks and family entertainment; top-tier competitor in global streaming (Disney+, Hulu) alongside Netflix; dominant player in US sports broadcasting (ESPN).
- Recent major events: Restructured into three new segments in FY2024; achieved DTC streaming profitability in FY2024; deconsolidated the Star India joint venture in Q1 FY2025; executing a $5.5B+ cost-cutting programme; fully acquired Hulu from Comcast.
The downloadable Walt Disney 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 & AssumptionsWalt Disney financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $67.42B | $82.72B | $88.90B | $91.36B | $94.42B |
| Total costs and expenses | -$63.76B | -$75.95B | -$79.91B | -$79.45B | -$80.59B |
| Operating income | $7.77B | $12.12B | $12.86B | $15.60B | $17.55B |
| Net income | $2.00B | $3.15B | $2.35B | $4.97B | $12.40B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Walt Disney
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Entertainment
- Segment name: Entertainment (Linear Networks, Direct-to-Consumer, Content Sales/Licensing and Other).
- Revenue driver formula:
- *Linear:* Subscribers x Affiliate Fee + Advertising Impressions x CPM.
- *DTC:* Paid Subscribers x Average Revenue Per User (ARPU) + Ad Revenue.
- *Content Sales:* Theatrical Box Office + Home Entertainment/Licensing Fees.
- Historical growth rate: Low single-digit overall, with DTC growing double-digits offsetting Linear declines.
- Key growth levers and headwinds: Password sharing crackdowns and ad-tier adoption drive DTC; cord-cutting is a secular headwind for Linear Networks.
- Pricing dynamics: Subscription price increases for Disney+ and Hulu; contractual affiliate fees for linear.
- Revenue recognition notes: Subscription revenue recognised rateably over the subscription period; theatrical revenue recognised as films are exhibited.
- Seasonality: Content Sales highly dependent on the theatrical release slate (e.g., summer blockbusters, holiday releases).
Sports
- Segment name: Sports (ESPN, Star India).
- Revenue driver formula: Affiliate Fees + Advertising Revenue + ESPN+ Subscriptions x ARPU.
- Historical growth rate: Flat to low single-digit growth.
- Key growth levers and headwinds: Transitioning ESPN to a flagship DTC app; rising sports rights costs (NFL, NBA) pressure margins.
- Pricing dynamics: High contractual affiliate fees passed to cable distributors.
- Seasonality: Q1 (calendar Q4) is the strongest due to the NFL and College Football seasons.
Experiences
- Segment name: Experiences (Domestic Parks & Experiences, International Parks & Experiences, Consumer Products).
- Revenue driver formula: Attendance x Per Capita Guest Spending (Tickets, Food, Merchandise) + Available Room Nights x Occupancy x Average Daily Rate (ADR).
- Historical growth rate: High single-digit to double-digit post-pandemic recovery.
- Key growth levers and headwinds: Disney Cruise Line fleet expansion (Disney Treasure, etc.); macroeconomic sensitivity of consumer travel budgets; extreme weather events (hurricanes).
- Pricing dynamics: Dynamic pricing for park tickets; high pricing power demonstrated over the last 5 years.
- Seasonality: Strongest in fiscal Q3 (spring break/early summer) and Q4 (summer), as well as late Q1 (Christmas holidays).
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Reported as "Cost of services" (programming and production costs, park operating costs) and "Cost of products" (merchandise costs).
- Gross margin range: Disney does not report a traditional gross margin, but Cost of Services & Products typically runs 60-65% of total revenue.
- Key input costs: Sports broadcasting rights, film/TV production costs, theme park labour, and cruise line fuel/provisions.
- How COGS scales with revenue: Programming costs are largely fixed/step-function (sports rights are multi-year contracts), creating high operating leverage. Park costs have a high fixed component (maintenance, base staffing).
Operating Expenses
- R&D: Not material / not explicitly disclosed (tech development for streaming is embedded in SG&A and Cost of Services).
- SG&A: Reported as "Selling, general, administrative and other". Runs at 16-18% of revenue. Heavily driven by DTC marketing and corporate overhead.
- Depreciation & Amortisation: ~5-6% of revenue (~$5.3B in FY2024). Heavily skewed towards theme parks and cruise ships. *Note: Content amortisation sits in Cost of Services, not D&A.*
- Restructuring / one-time charges: Frequent in recent years due to the $5.5B cost-cutting initiative and content impairment charges.
Margin Profile
- Operating margin: Total segment operating margin typically ranges from 15-18%.
- Segment-level margins:
- Entertainment: ~10-12% (DTC recently crossed into profitability).
- Sports: ~10-15% (pressured by rights costs).
- Experiences: ~25-30% (highly profitable, though dragged slightly by cruise pre-opening costs).
Balance Sheet Structure
- Total assets: ~$200B.
- Key asset categories: Produced and licensed content assets (massive portion of current and non-current assets), Parks/Resorts PP&E, Goodwill.
- Goodwill & intangibles: ~$75B+ (nearly 40% of total assets), stemming from major acquisitions (21st Century Fox, Marvel, Lucasfilm, Pixar).
- Working capital profile:
- DSO: ~45-55 days.
- DPO: ~60-70 days.
- Net working capital: Typically negative. Disney collects cash upfront for streaming subscriptions, park tickets, and cruise bookings (Deferred Revenue), creating a negative working capital advantage that funds operations.
- PP&E: ~$30B+. Consists of theme park infrastructure, land, and cruise ships. Useful lives range from 3-50 years.
- Right-of-use assets: Material (~$3-4B) due to real estate and equipment leases.
Capital Expenditure & Investment
- Capex as % of revenue: ~8-9% (Targeting ~$8B for FY2025).
- Maintenance vs. growth capex: Heavily skewed towards growth (estimated 60/40 split), driven by the 10-year $60B Experiences investment plan.
- Major capex programmes: Disney Cruise Line fleet expansion (adding multiple ships like the Disney Treasure), park expansions in Florida and California.
- Capitalised software: Streaming platform development costs are capitalised and amortised.
- M&A pattern: Historically a transformational acquirer (Fox, Marvel), but currently focused on organic growth, debt paydown, and integrating the remaining Hulu stake.
Debt & Capital Structure
- Total debt: ~$46B (Long-term + Short-term).
- Net debt / EBITDA: ~2.1x as of late 2024/early 2025, down from >4.0x during the pandemic.
- Credit rating: A- (S&P), recently upgraded due to improving leverage and DTC profitability.
- Key debt instruments: Senior unsecured notes, commercial paper, and term loans.
- Interest rate profile: Predominantly fixed-rate long-term bonds; weighted average cost of debt is approximately 3.5-4.5%.
- Share repurchase programme: Active. Targeting $3B in stock repurchases for FY2025.
- Dividend policy: Reinstated. Targeting dividend growth that tracks earnings growth (current yield ~1.3%).
Cash Flow Characteristics
- Operating cash flow conversion: Very strong. Targeting ~$15B in OCF for FY2025.
- Free cash flow margin: ~7-9% (OCF of $15B less Capex of $8B = ~$7B FCF on ~$94B revenue).
- Major non-cash items: Depreciation and amortisation (~$5.3B), and massive amortisation of film and television costs (which is added back, while cash spent on new content is deducted).
- Working capital cash flow impact: Deferred revenue from parks and streaming acts as a continuous source of cash as the business grows.
- Cash tax rate: Typically lower than the statutory rate due to production tax credits and international tax structuring.
Sheet Structure
- Assumptions & Drivers: Hardcoded inputs for macroeconomic factors, segment growth, ARPU, attendance, and margins.
- Summary Dashboard: Key outputs, target price, EPS, FCF, and leverage metrics.
- Consolidated Income Statement: Revenue, Cost of Services, Cost of Products, SG&A, D&A, Restructuring, Interest, Taxes, Net Income.
- Segment Operating Income: Revenue and Operating Income broken out strictly by Entertainment, Sports, and Experiences.
- Entertainment DTC Build: Disney+ Core and Hulu subscriber roll-forward, ARPU, ad revenue, and programming costs.
- Experiences Build: Domestic and International attendance, per capita spending, cruise line capacity, and operating margins.
- Content Asset Schedule: Roll-forward of capitalised film/TV production costs (Beginning Balance + Cash Spend - Amortisation = Ending Balance).
- Balance Sheet: Assets (including Content Assets, PP&E, Goodwill), Liabilities (Deferred Revenue, Debt), and Equity.
- Cash Flow Statement: Net Income to OCF (adjusting for content amortisation vs spend), Investing (Capex), Financing (Dividends, Buybacks, Debt paydown).
- Debt Schedule: Tranches of debt, interest expense calculation, and leverage ratios.
- DCF Valuation: Unlevered free cash flow, WACC calculation, terminal value, and implied share price.
Key Financial Relationships
- `Entertainment DTC Revenue = (Beginning Subs + Ending Subs) / 2 * Monthly ARPU * 12 + DTC Advertising Revenue`
- `Experiences Revenue = (Domestic Attendance * Domestic Per Cap) + (International Attendance * International Per Cap) + Cruise Line Revenue + Consumer Products Revenue`
- `Sports Revenue = ESPN Linear Affiliate Fees + ESPN Advertising + ESPN+ Subscription Revenue`
- `Total Cost of Services = Entertainment Programming & Production Costs + Sports Rights Costs + Parks Operating Costs`
- `Content Asset Ending Balance = Content Asset Beginning Balance + Cash Paid for Content - Content Amortisation (recognised in Cost of Services)`
- `Segment Operating Income = Segment Revenue - Segment Operating Expenses (excluding corporate unallocated overhead)`
- `Consolidated Operating Income = Sum of Segment Operating Income - Corporate & Unallocated Shared Expenses`
- `Net Interest Expense = (Average Total Debt * Weighted Average Interest Rate) - Interest Income on Cash`
- `Free Cash Flow = Cash Provided by Operations - Investments in Parks, Resorts and Other Property (Capex)`
- `Net Debt / EBITDA = (Short-Term Debt + Long-Term Debt - Cash & Equivalents) / Adjusted EBITDA`
Cross-Sheet Dependencies
- The Segment Operating Income sheet is the core engine. It feeds total revenues and operating expenses into the Consolidated Income Statement.
- The Content Asset Schedule calculates content amortisation (which feeds into Cost of Services on the Income Statement) and cash spent on content (which feeds into the Operating Cash Flow section of the Cash Flow Statement).
- The Experiences Build drives Capex assumptions (cruise ships, park expansions), which flow to the Balance Sheet (PP&E) and Cash Flow Statement (Investing outflows).
- The Debt Schedule calculates interest expense, which flows to the Income Statement. The resulting Net Income flows to the Cash Flow Statement, which determines cash available for debt paydown, creating a circular reference loop that must be managed via a circuit breaker.
Sign Convention
- Revenues and Assets: Entered and displayed as positive numbers.
- Expenses and Liabilities: Entered as positive numbers in assumption schedules, but subtracted in formulas (e.g., `Gross Profit = Revenue - COGS`).
- Cash Flow: Cash inflows are positive; cash outflows (Capex, debt repayment, dividends) are negative.
- Contra-accounts: Accumulated depreciation is negative on the balance sheet.
Things Most Likely to Go Wrong
- Star India Deconsolidation: Disney deconsolidated Star India in Q1 FY2025. Historical revenue and operating income for the Sports and Entertainment segments will not be directly comparable to FY2025+ without pro-forma adjustments.
- Content Spend vs. Amortisation: Treating content spend as standard Capex is a critical error. Cash spent on content is an *Operating* Cash Flow outflow, while content amortisation is a non-cash add-back in OCF.
- Cruise Line Pre-Opening Expenses: The launch of new ships (e.g., Disney Treasure) incurs heavy pre-opening expenses (~$200M in FY2025) that temporarily depress Experiences margins. The model must normalise this.
- Hurricane Impacts: Q1 FY2025 Experiences operating income was hit by ~$120M due to Hurricanes Milton and Helene. Do not extrapolate this depressed margin run-rate.
- Hulu Non-Controlling Interest: Disney fully acquired Hulu, meaning historical NCI lines on the income statement will change materially.
- Adjusted vs. GAAP EPS: Disney frequently reports massive restructuring and impairment charges (e.g., $5.5B cost-cutting programme). The model must clearly separate GAAP Net Income from Adjusted EPS to match management guidance.
- Deferred Revenue: Park tickets and streaming subs are paid upfront. If revenue grows, deferred revenue must grow proportionally on the balance sheet, providing a working capital cash benefit.
- Corporate Allocations: Segment Operating Income excludes "Corporate and Unallocated Shared Expenses". Summing segment OI will not equal consolidated EBIT without subtracting this corporate line.
Validation Checks
- "Experiences segment operating margin should be in the 25-30% range; flag if it drops below 20% outside of a pandemic scenario."
- "Entertainment DTC operating margin should be positive (crossed into profitability in FY24); flag if it reverts to deep historical losses."
- "Capex should be approximately $8B annually based on FY25 guidance; flag if Capex/Revenue drops below 7%."
- "Net Debt / EBITDA should remain below 2.5x to maintain the recent A- credit rating upgrade."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Cash provided by operations should be approximately $15B in FY25; flag if OCF conversion falls below 1.2x Net Income."
- "Dividend payout should track earnings growth, with total share repurchases around $3B annually."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Entertainment Revenue Growth | 3.0 | % | Blended rate: DTC growth offsetting Linear declines |
| Sports Revenue Growth | 2.0 | % | Mature domestic market, offset by Star India deconsolidation |
| Experiences Revenue Growth | 6.0 | % | Driven by cruise capacity expansion and park pricing power |
| Entertainment Segment Margin | 11.0 | % | Reflects DTC profitability and cost-cutting |
| Sports Segment Margin | 12.0 | % | Pressured by rising sports rights costs |
| Experiences Segment Margin | 28.0 | % | Highly profitable segment, adjusting for temporary cruise pre-opening costs |
| SG&A as % of Revenue | 17.5 | % | Historical average, benefiting slightly from $5.5B cost cuts |
| D&A as % of Revenue | 5.6 | % | Based on FY24 actuals ($5.3B on $94B revenue) |
| Effective Tax Rate | 21.0 | % | Standard corporate rate, adjusted for international mix |
| Capex | 8,000 | $M | Management guidance for FY2025 |
| Share Repurchases | 3,000 | $M | Management guidance for FY2025 |
| Cost of Debt | 4.2 | % | Weighted average interest rate on long-term debt |
| WACC | 8.5 | % | Standard discount rate for diversified media/entertainment |
| Terminal Growth Rate | 2.5 | % | Long-term GDP and inflation alignment |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and The Walt Disney Company Investor Relations website.
- Key peers for benchmarking:
- Streaming/Content: Netflix (NFLX), Warner Bros. Discovery (WBD), Paramount Global (PARA).
- Parks/Experiences: Comcast (CMCSA - Universal Studios).
- Industry data sources: Nielsen (linear TV ratings and streaming share), Box Office Mojo (theatrical release performance), Themed Entertainment Association (TEA) annual attendance reports.
- Consensus estimates: Bloomberg, FactSet, or Yahoo Finance for forward EPS and revenue estimates.
Sources
- The Walt Disney Company Q1 FY2025 Earnings Release (thewaltdisneycompany.com)
- The Walt Disney Company FY2024 Form 10-K and Earnings Release
- S&P Global Ratings: Walt Disney Co. Upgraded To 'A-' On Improving Leverage
- Finbox and GuruFocus: Disney Net Debt to EBITDA metrics
- Trading Economics: Walt Disney Financials
Do more with the Walt Disney model
Frequently asked
What does The Walt Disney Company do?+
The Walt Disney Company is a diversified global entertainment conglomerate that produces premium content, operates direct-to-consumer streaming services, broadcasts live sports, and operates world-renowned theme parks and cruise lines. It monetizes its core intellectual property across multiple touchpoints, including theatrical release, streaming, and consumer merchandise.
How does Walt Disney generate revenue across its business segments?+
Walt Disney generates revenue primarily through its Entertainment segment (streaming, linear networks, content sales), Experiences segment (parks, cruises, consumer products), and Sports segment (ESPN). Its business model is an IP-driven flywheel, leveraging core intellectual property across multiple platforms for monetization.
What is Walt Disney's capital expenditure strategy and its impact on the financial model?+
Walt Disney's capital expenditure is approximately 8-9% of revenue, with a significant portion (estimated 60/40 split) skewed towards growth capex. This is driven by major programs like the 10-year, $60 billion Experiences investment plan and Disney Cruise Line fleet expansion, impacting future asset growth.
What is the primary purpose of a financial model for The Walt Disney Company?+
A financial model for The Walt Disney Company aims to evaluate its equity valuation and cash flow generation capacity. It enables an analyst to assess whether the transition to a profitable Direct-to-Consumer streaming model, combined with the cash-generative Experiences segment, justifies its current market valuation.
Can I download an Excel financial model for Walt Disney (DIS)?+
Yes, an Excel financial model for The Walt Disney Company (DIS) is available for download. This general corporate model provides a forecast horizon from FY2026 to FY2030, allowing for detailed analysis of its financials.
What is Walt Disney's typical working capital profile?+
Walt Disney typically exhibits a negative net working capital profile. This is because the company often collects cash upfront for streaming subscriptions, park tickets, and cruise bookings, creating deferred revenue that provides a working capital advantage and funds operations.
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 Media Company Financial Models
Browse another company in the same sector.
AppLovin
AppLovin operates a leading software-based platform that provides end-to-end advertising and AI solutions to help businesses reach, monetise, and grow their global audiences.
Electronic Arts
Electronic Arts (EA) is a global leader in digital interactive entertainment, developing and delivering games, content, and online services for consoles, personal computers, and mobile devices.
Fox
Fox Corporation is a leading news, sports, and entertainment broadcasting company in the United States.
Alphabet
Alphabet is a global technology holding company known for its core Google internet products including Search, YouTube, Android, and Chrome, generating revenue primarily through digital advertising while scaling cloud computing and AI infrastructure.
Hasbro
Hasbro is a global play and entertainment company that designs, manufactures, and licenses toys, tabletop games, and digital gaming experiences.
Live Nation Entertainment
Live Nation Entertainment (LYV) is the world's largest live entertainment company, operating a vertically integrated model that spans concert promotion, venue operation, ticketing, and brand sponsorship.
Meta Platforms
Meta Platforms builds technologies that help people connect, find communities, and grow businesses.
Netflix
Netflix operates a global streaming entertainment service offering television series, films, and games across various genres and languages, funded primarily through subscription fees and advertising.
Explore more Tech & Software financial model templates.
