Mattel, Inc. (MAT) 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
Mattel, Inc. (MAT) Bundle
Gain insights into your Mattel, Inc. (MAT) valuation analysis with our state-of-the-art DCF Calculator! This Excel template comes preloaded with real MAT data, enabling you to adjust forecasts and assumptions for precise calculations of Mattel’s intrinsic value.
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 | 4,504.6 | 4,583.7 | 5,457.7 | 5,434.7 | 5,441.2 | 5,720.4 | 6,013.9 | 6,322.4 | 6,646.8 | 6,987.8 |
Revenue Growth, % | 0 | 1.76 | 19.07 | -0.42142 | 0.11995 | 5.13 | 5.13 | 5.13 | 5.13 | 5.13 |
EBITDA | 313.9 | 573.3 | 909.0 | 819.3 | 766.5 | 747.0 | 785.3 | 825.6 | 868.0 | 912.5 |
EBITDA, % | 6.97 | 12.51 | 16.66 | 15.08 | 14.09 | 13.06 | 13.06 | 13.06 | 13.06 | 13.06 |
Depreciation | 244.5 | 193.5 | 184.3 | 182.2 | 177.3 | 224.7 | 236.2 | 248.3 | 261.0 | 274.4 |
Depreciation, % | 5.43 | 4.22 | 3.38 | 3.35 | 3.26 | 3.93 | 3.93 | 3.93 | 3.93 | 3.93 |
EBIT | 69.4 | 379.8 | 724.7 | 637.2 | 589.2 | 522.3 | 549.1 | 577.3 | 606.9 | 638.1 |
EBIT, % | 1.54 | 8.29 | 13.28 | 11.72 | 10.83 | 9.13 | 9.13 | 9.13 | 9.13 | 9.13 |
Total Cash | 630.0 | 762.2 | 731.4 | 761.2 | 1,261.4 | 929.0 | 976.7 | 1,026.8 | 1,079.5 | 1,134.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 936.4 | 1,034.0 | 1,072.7 | 860.2 | 1,081.8 | 1,129.3 | 1,187.2 | 1,248.2 | 1,312.2 | 1,379.5 |
Account Receivables, % | 20.79 | 22.56 | 19.65 | 15.83 | 19.88 | 19.74 | 19.74 | 19.74 | 19.74 | 19.74 |
Inventories | 495.5 | 514.7 | 777.2 | 894.1 | 571.6 | 725.6 | 762.9 | 802.0 | 843.2 | 886.4 |
Inventories, % | 11 | 11.23 | 14.24 | 16.45 | 10.51 | 12.69 | 12.69 | 12.69 | 12.69 | 12.69 |
Accounts Payable | 459.4 | 495.4 | 579.2 | 471.5 | 442.3 | 554.0 | 582.4 | 612.3 | 643.7 | 676.7 |
Accounts Payable, % | 10.2 | 10.81 | 10.61 | 8.68 | 8.13 | 9.68 | 9.68 | 9.68 | 9.68 | 9.68 |
Capital Expenditure | -116.4 | -121.6 | -151.4 | -186.5 | -160.3 | -164.6 | -173.0 | -181.9 | -191.3 | -201.1 |
Capital Expenditure, % | -2.58 | -2.65 | -2.77 | -3.43 | -2.95 | -2.88 | -2.88 | -2.88 | -2.88 | -2.88 |
Tax Rate, % | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 |
EBITAT | 93.5 | 255.4 | 1,390.0 | 497.7 | 271.4 | 408.9 | 429.9 | 451.9 | 475.1 | 499.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -750.8 | 246.4 | 1,205.5 | 481.2 | 360.1 | 379.1 | 426.3 | 448.1 | 471.1 | 495.3 |
WACC, % | 7.12 | 6.68 | 7.12 | 6.82 | 6.39 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,813.8 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 513 | |||||||||
Terminal Value | 15,407 | |||||||||
Present Terminal Value | 11,074 | |||||||||
Enterprise Value | 12,888 | |||||||||
Net Debt | 1,405 | |||||||||
Equity Value | 11,483 | |||||||||
Diluted Shares Outstanding, MM | 357 | |||||||||
Equity Value Per Share | 32.15 |
What You Will Get
- Real MAT Financial Data: Pre-filled with Mattel’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Mattel’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Pre-Loaded Data: Mattel’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: Observe Mattel’s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Download the Template: Gain immediate access to the Excel-based MAT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically refreshes Mattel’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation changes.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose Mattel, Inc. (MAT)?
- Innovative Products: A diverse range of toys and games that inspire creativity and play.
- Strong Brand Recognition: Trusted names like Barbie, Hot Wheels, and Fisher-Price resonate with consumers.
- Commitment to Quality: Rigorous safety standards ensure products are safe for children.
- Sustainable Practices: Initiatives focused on environmental responsibility and sustainability.
- Proven Track Record: A history of financial stability and growth in the toy industry.
Who Should Use This Product?
- Investors: Accurately estimate Mattel, Inc.'s (MAT) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to Mattel, Inc. (MAT).
- Consultants: Quickly adapt the template for valuation reports for clients interested in Mattel, Inc. (MAT).
- Entrepreneurs: Gain insights into financial modeling used by leading toy manufacturers, including Mattel, Inc. (MAT).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to companies like Mattel, Inc. (MAT).
What the Template Contains
- Pre-Filled Data: Features Mattel's historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Assess Mattel’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.