# Hasbro (HAS) Financial Model Free Excel 3-statement financial model and company analysis for Hasbro. - Canonical: https://finamodel.com/companies/hasbro - Industry: Media - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/HAS.xlsx ## Model Purpose This model provides a comprehensive sum-of-the-parts equity valuation and cash flow forecast for Hasbro to help an equity research analyst determine if the high-margin Wizards of the Coast segment is adequately priced into the consolidated share price. ## Company Overview Hasbro is a global play and entertainment company that designs, manufactures, and licenses toys, tabletop games, and digital gaming experiences. The company has recently transitioned towards a digital-first, asset-light intellectual property model, leveraging its owned franchises across multiple entertainment mediums. Business segments include: * Wizards of the Coast and Digital Gaming (approximately 46% of revenue, but over 90% of operating profit) * Consumer Products (approximately 52% of revenue) * Entertainment (approximately 2% of revenue) The company generates the majority of its revenue in North America, with Europe and Asia-Pacific forming the balance of international sales. Hasbro operates a hybrid business model: the Consumer Products segment is traditional and asset-heavy (manufacturing and distributing physical toys), while the Wizards of the Coast segment is highly asset-light and driven by high-margin digital licensing and premium tabletop cards. Hasbro holds a dominant competitive position in the tabletop gaming market (Magic: The Gathering, Dungeons & Dragons) and competes directly with Mattel and Lego in traditional toys. Recent major events include the late 2023 divestiture of the eOne film and television business to Lionsgate, a massive surge in digital licensing revenue in 2024 and 2025 from titles like Monopoly Go! and Baldur's Gate 3, and a $943 million non-cash goodwill impairment in the Consumer Products segment in 2025. ## Revenue Deep Dive ### Wizards of the Coast and Digital Gaming * **Segment name:** Wizards of the Coast and Digital Gaming * **Revenue driver formula:** (Tabletop Release Volume x Average Price per Set) + Digital Licensing Royalties * **Historical growth rate:** 10% to 45% (highly variable, spiked to 45% in FY2025 due to Universes Beyond sets and digital licensing) * **Key growth levers and headwinds:** Success of new Magic: The Gathering sets (e.g., Avatar: The Last Airbender, Final Fantasy), player engagement on digital platforms, and the pipeline of licensed video games. Headwinds include player fatigue from too many card set releases. * **Pricing dynamics:** Premium pricing power for physical collector cards; contractual royalty rates for digital licensing (e.g., Scopely for Monopoly Go!). * **Revenue recognition notes:** Digital licensing royalties are often recognised over time or upon specific milestone achievements, whereas physical tabletop sales are recognised upon shipment. * **Seasonality:** Heavily dependent on the specific release calendar of Magic: The Gathering sets, though Q4 is typically the strongest due to holiday gifting. ### Consumer Products * **Segment name:** Consumer Products * **Revenue driver formula:** Wholesale Toy Volume x Average Wholesale Price * **Historical growth rate:** Negative 12% to positive 2% (declined 4% in FY2025) * **Key growth levers and headwinds:** Growth relies on movie tie-ins (Marvel, Star Wars) and core brand refreshes (Peppa Pig, Transformers). Headwinds include retailer inventory destocking, shifting consumer preferences to digital entertainment, and US import tariffs. * **Pricing dynamics:** Highly competitive spot pricing and wholesale agreements with major retailers like Walmart and Target. * **Revenue recognition notes:** Recognised when control transfers to the retailer, net of estimated sales allowances and markdown reserves. * **Seasonality:** Extremely seasonal, with the vast majority of sales and profits generated in Q3 and Q4 ahead of the holiday shopping season. ### Entertainment * **Segment name:** Entertainment * **Revenue driver formula:** Content Delivery Volume x Licensing Fee * **Historical growth rate:** Not meaningful historically due to the eOne divestiture (declined 88% in 2024, declined 4% in 2025 on a pro-forma basis) * **Key growth levers and headwinds:** Driven by residual licensing of retained IP (e.g., Peppa Pig animated content). * **Pricing dynamics:** Contractual licensing agreements with streaming platforms and broadcasters. * **Revenue recognition notes:** Recognised when the content is delivered and available for use by the licensee. * **Seasonality:** Lumpy and dependent on specific content delivery dates. ## Cost Structure ### Variable Costs / COGS * Cost of Sales includes raw materials (plastic, cardboard), manufacturing costs, inbound freight, warehousing, and inventory obsolescence charges. * Gross margin typically ranges from 68% to 72% on a consolidated basis, heavily skewed by segment mix. * Key input costs include oil-based plastics for toys, paper for trading cards, and trans-Pacific shipping container rates. * COGS scales linearly with Consumer Products revenue but exhibits massive operating leverage in the Wizards of the Coast segment, where digital licensing carries near-zero incremental COGS. ### Operating Expenses * **Royalties:** Paid to third-party IP owners (like Disney) for the right to produce toys based on their characters. Usually 7% to 9% of total revenue. * **Advertising:** Critical for toy sales, typically running at 8% to 10% of total revenue. * **Product Development:** Essentially R&D for toy design and game development, running at 5% to 6% of revenue. * **SG&A:** Includes corporate overhead, sales force, and administrative staff. Hasbro has aggressively cut headcount recently to achieve a $750 million cost-savings target. * **Depreciation & Amortisation:** Significant amortisation of acquired intangibles from past acquisitions (eOne, D&D Beyond). * **Restructuring / Impairments:** Frequent and large in recent years, including a $943 million non-cash goodwill impairment in Q2 2025. ### Margin Profile * Consolidated adjusted operating margin expanded from 16% in 2023 to 24.2% in 2025. * Wizards of the Coast operating margin is exceptionally high, ranging from 40% to 46.0% in 2025. * Consumer Products operating margin is structurally low, ranging from 4.5% to 6.0%. * Margin expansion is entirely driven by the mix shift towards digital gaming and aggressive supply chain cost-cutting in toys. ## Balance Sheet Structure * Total assets are approximately $9 billion to $10 billion. * Key assets include Accounts Receivable, Inventory, and a massive balance of Goodwill and Intangible Assets. * Goodwill and intangibles represent over 40% of total assets, a legacy of the original eOne acquisition and the D&D Beyond purchase. * Working capital profile: * Days Sales Outstanding (DSO): 65 to 75 days. * Days Inventory Outstanding (DIO): 90 to 110 days (Hasbro has actively reduced inventory levels since 2023). * Days Payable Outstanding (DPO): 50 to 60 days. * Net working capital is typically positive and requires cash absorption ahead of the Q4 holiday season. * PP&E is relatively small (asset-light model), consisting mostly of toy manufacturing tooling and corporate IT infrastructure. * Operating lease right-of-use assets are present but not a dominant feature of the balance sheet. ## Capital Expenditure & Investment * Capex as a percentage of revenue typically runs between 2.5% and 3.5%. * The split is heavily weighted towards maintenance and tooling for new toy lines, with a growing portion dedicated to capitalised software development for digital games. * Major investments are currently focused on internal video game studio development to create owned digital titles. * M&A pattern: Historically a transformational acquirer (eOne for $4 billion), but currently focused on organic growth, debt paydown, and share repurchases following the eOne divestiture. ## Debt & Capital Structure * Total debt is approximately $3.5 billion. * The company achieved its target gross leverage ratio of 2.5x early, ending 2025 at 2.3x Gross Debt to Adjusted EBITDA. * Credit rating is typically investment grade (BBB tier). * Key debt instruments include unsecured senior notes with staggered maturities. * Interest rate profile is predominantly fixed-rate bonds. * Share repurchase programme is highly active, with a new $1.0 billion authorisation announced in February 2026. * Dividend policy is a cornerstone of the capital return strategy, paying approximately $390 million annually (yielding around 3% to 4%). ## Cash Flow Characteristics * Operating cash flow conversion is strong, with OCF frequently exceeding GAAP net income due to high non-cash amortisation and impairment charges. * Free cash flow margin typically ranges from 12% to 18% of revenue. * Major non-cash items bridging net income to OCF include depreciation, acquired intangible amortisation, stock-based compensation, and periodic goodwill impairments. * Working capital is a major seasonal use of cash in Q2 and Q3, which reverses into a massive source of cash in Q4 and Q1 as holiday receivables are collected. * Capex intensity is low, allowing for high free cash flow conversion. ## Sheet Structure 1. **Assumptions**: Hardcoded drivers for segment growth, margins, working capital days, and capital allocation. 2. **Scenarios**: Toggles for base, bull, and bear cases regarding Magic: The Gathering release success and toy tariff impacts. 3. **Segment Build**: Revenue and operating profit broken out strictly by Wizards of the Coast, Consumer Products, and Entertainment. 4. **Income Statement**: Consolidated view mirroring the 10-K, including specific lines for Royalties, Advertising, and Product Development. 5. **Balance Sheet**: Standard asset and liability line items, separating Goodwill from other Intangibles. 6. **Cash Flow Statement**: Indirect method starting from Net Income, with a detailed working capital bridge. 7. **Working Capital Schedule**: Monthly or quarterly build of Receivables, Inventory, and Payables to capture extreme seasonality. 8. **Debt Schedule**: Tranche-by-tranche bond maturity profile and interest expense calculation. 9. **PPE & Intangibles Schedule**: Capex, depreciation, capitalised software, and amortisation waterfalls. 10. **DCF Valuation**: Unlevered free cash flow build, WACC calculation, and terminal value using a sum-of-the-parts cross-check. ## Key Financial Relationships 1. Wizards of the Coast Revenue = Tabletop Gaming Revenue + Digital and Licensed Gaming Revenue 2. Consumer Products Revenue = Core Brands Revenue + Partner Brands Revenue 3. Total Consolidated Revenue = Wizards of the Coast Revenue + Consumer Products Revenue + Entertainment Revenue 4. Consolidated Gross Profit = Total Revenue - Cost of Sales (excluding depreciation) 5. Advertising Expense = (Consumer Products Revenue x CP Ad Intensity %) + (Wizards Revenue x Wizards Ad Intensity %) 6. Royalty Expense = Partner Brands Revenue x Average Royalty Rate 7. Wizards Operating Profit = Wizards Revenue x Wizards Operating Margin (historically 40% to 46%) 8. Consumer Products Operating Profit = Consumer Products Revenue x CP Operating Margin (historically 4% to 6%) 9. Adjusted EBITDA = Consolidated Operating Profit + Depreciation + Amortisation + Non-Cash Impairments + Stock-Based Compensation 10. Ending Inventory = (Cost of Sales / 365) x Days Inventory Outstanding 11. Free Cash Flow = Operating Cash Flow - Capital Expenditures - Capitalised Software Additions 12. Interest Expense = Average Debt Balance x Weighted Average Interest Rate ## Cross-Sheet Dependencies The **Assumptions** sheet feeds the **Segment Build**, which calculates revenue and operating profit. The **Segment Build** feeds the top half of the **Income Statement**. The **Income Statement** generates Net Income, which flows to the top of the **Cash Flow Statement** and into Retained Earnings on the **Balance Sheet**. The **Working Capital Schedule** uses revenue and COGS from the **Income Statement** to calculate balance sheet accounts, and the period-over-period changes flow into the **Cash Flow Statement**. The **Debt Schedule** uses cash flow deficits or surpluses to calculate debt paydown or share repurchases, which in turn feeds Interest Expense back into the **Income Statement**. This creates a circular reference between interest expense, net income, cash flow, and debt balances that must be managed with a circuit breaker toggle. ## Sign Convention * Revenue and income items are entered and displayed as positive numbers. * Expenses (COGS, SG&A, Interest) are entered as positive numbers in the assumptions but subtracted in the Income Statement formulas. * On the Cash Flow Statement, sources of cash (e.g., an increase in Accounts Payable) are positive, while uses of cash (e.g., an increase in Inventory or Capex) are negative. * On the Balance Sheet, all assets, liabilities, and equity balances are positive. ## Things Most Likely to Go Wrong * Failing to model the massive margin disparity between segments. Applying a consolidated margin assumption will break the model if the revenue mix shifts further towards Wizards of the Coast. * Straight-lining digital licensing revenue. Titles like Monopoly Go! create lumpy, high-margin royalty streams that do not follow traditional toy seasonality. * Including the $943 million 2025 goodwill impairment in run-rate operating expenses. This must be excluded to calculate true Adjusted Operating Profit. * Misunderstanding the eOne divestiture. Historical consolidated financials from 2023 include eOne film and TV revenues, making year-over-year comparisons to 2024 and 2025 meaningless without pro-forma adjustments. * Underestimating Q3 and Q4 working capital swings. Inventory builds heavily in Q2 and Q3, draining cash, before converting to receivables and cash in Q4 and Q1. * Ignoring the impact of US import tariffs on the Consumer Products segment, which sources heavily from China and can severely compress the already thin 4% to 6% margins. * Double-counting amortisation. Hasbro reports "Adjusted Operating Profit" which excludes acquired intangible amortisation. The model must clearly bridge GAAP to Non-GAAP figures. * Failing to account for the new $1.0 billion share repurchase programme, which will significantly reduce the share count and inflate EPS in 2026 and 2027. ## Validation Checks * Wizards of the Coast operating margin must remain between 40% and 47%. Flag if it drops below 40%. * Consumer Products operating margin should not exceed 8% without a specific bull-case justification. * Consolidated Adjusted Operating Margin should reconcile to approximately 24% based on the current segment mix. * Gross Debt to Adjusted EBITDA must remain below the management target of 2.5x. * Operating Cash Flow must exceed GAAP Net Income in almost all periods due to high non-cash D&A and impairments. * Total Assets must exactly equal Total Liabilities plus Shareholders' Equity in every forecasted period. * Capex as a percentage of revenue should remain between 2.5% and 3.5%. * The annual dividend payout should be approximately $390 million, growing only if management explicitly changes the policy. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Wizards of the Coast Revenue Growth | 5.0 | % | Normalising after a massive 45% growth year in 2025 | | Consumer Products Revenue Growth | 2.0 | % | Modest recovery following a 4% decline in 2025 | | Entertainment Revenue Growth | 0.0 | % | Flat growth expected for the residual IP portfolio | | Wizards of the Coast Operating Margin | 45.0 | % | In line with 2025 actuals of 46.0% and historical averages | | Consumer Products Operating Margin | 5.0 | % | Blended average of recent years (4.6% in 2025) | | Entertainment Operating Margin | 50.0 | % | High margin due to pure licensing nature of residual IP | | Advertising as % of Revenue | 9.0 | % | Required to support toy sales and digital game user acquisition | | Product Development as % of Revenue | 5.5 | % | Historical average for toy design and game development | | Days Sales Outstanding (DSO) | 70 | Days | Based on historical receivables collection patterns | | Days Inventory Outstanding (DIO) | 100 | Days | Reflects recent successful inventory reduction efforts | | Days Payable Outstanding (DPO) | 55 | Days | Standard supplier payment terms | | Capex as % of Revenue | 3.0 | % | Historical average for tooling and digital development | | Effective Tax Rate | 20.0 | % | Long-term blended global tax rate | | Share Count | 140 | Millions | Actual outstanding shares as of early 2026 | | Annual Share Repurchases | 333 | $ Millions | Assumes the $1B authorisation is deployed evenly over 3 years | | Annual Dividend Paid | 393 | $ Millions | Matches the actual cash dividend paid in 2025 | | Weighted Average Interest Rate | 5.5 | % | Based on the current fixed-rate bond portfolio | | Discount Rate (WACC) | 8.5 | % | Standard cost of capital for a consumer discretionary/gaming hybrid | | Terminal Growth Rate | 2.0 | % | Long-term inflation and GDP growth proxy | ## Data Sources & Benchmarks * **SEC Filings:** Hasbro Investor Relations website and SEC EDGAR database for 10-K and 10-Q filings. * **Direct Peers (Toys):** Mattel (MAT), Jakks Pacific (JAKK), Spin Master (TOY.TO). * **Direct Peers (Gaming):** Electronic Arts (EA), Take-Two Interactive (TTWO) for the digital gaming segment benchmarking. * **Industry Data:** Circana (formerly NPD Group) for monthly retail toy point-of-sale data and tabletop gaming market share. * **Consensus Estimates:** FactSet or Bloomberg for forward-looking analyst estimates on segment revenues and margins. ## Sources * Hasbro Q4 and Full Year 2025 Earnings Release: https://investor.hasbro.com * Hasbro 2024 and 2025 Annual Reports (Form 10-K): https://www.sec.gov * Seeking Alpha Earnings Call Transcripts (Q4 2025): https://seekingalpha.com * Investing.com Hasbro Financial Analysis: https://www.investing.com * Wargamer MTG Revenue Report: https://www.wargamer.com --- ## Frequently asked questions ### How does Hasbro generate revenue across its different business segments? Hasbro generates revenue primarily through its Consumer Products segment, which includes traditional toys, and its high-margin Wizards of the Coast and Digital Gaming segment, encompassing tabletop games and digital experiences. A smaller portion of revenue comes from its Entertainment segment, leveraging its intellectual property across various mediums. ### What are the primary drivers of Hasbro's revenue growth? Hasbro's revenue growth is driven by its diverse portfolio of intellectual property, particularly through its asset-light digital licensing and premium tabletop cards in the Wizards of the Coast segment. Growth also comes from new toy lines and distribution in its Consumer Products segment, alongside strategic investments in internal video game studio development. ### Why is the Wizards of the Coast segment so important to Hasbro's profitability? The Wizards of the Coast and Digital Gaming segment is crucial to Hasbro's profitability because it accounts for over 90% of the company's operating profit, despite representing only about 46% of total revenue. This segment operates with a highly asset-light model, driven by high-margin digital licensing and premium tabletop cards like Magic: The Gathering. ### What are the key capital expenditure and working capital assumptions in Hasbro's financial model? The financial model assumes Hasbro's capital expenditures as a percentage of revenue typically run between 2.5% and 3.5%, focused on maintenance, tooling, and capitalized software development. Net working capital is modeled to be positive, requiring cash absorption, with Days Sales Outstanding between 65-75 days and Days Inventory Outstanding between 90-110 days. ### What is the main purpose of the Hasbro financial model and its valuation approach? The Hasbro financial model aims to provide a comprehensive sum-of-the-parts equity valuation and cash flow forecast. Its primary purpose is to help an equity research analyst determine if the highly profitable Wizards of the Coast segment is adequately priced into the consolidated share price. ### Can I download a financial model for Hasbro, and what is its forecast horizon? Yes, a downloadable Excel financial model for Hasbro is available. This general corporate model provides a forecast horizon spanning from Fiscal Year 2026 through Fiscal Year 2030. [Interactive forecast calculator](https://finamodel.com/companies/hasbro/forecast)