|
Valoración DCF de Zumiez Inc. (Zumz)
US | Consumer Cyclical | Apparel - Retail | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Zumiez Inc. (ZUMZ) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (ZUMZ)! Utilizando datos reales de Zumiez Inc. y suposiciones personalizables, esta herramienta lo equipa para pronosticar, analizar y valor (ZUMZ) como un inversor experimentado.
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 | 1,034.1 | 990.7 | 1,183.9 | 958.4 | 875.5 | 848.4 | 822.1 | 796.6 | 771.9 | 748.0 |
Revenue Growth, % | 0 | -4.2 | 19.5 | -19.05 | -8.65 | -3.1 | -3.1 | -3.1 | -3.1 | -3.1 |
EBITDA | 85.8 | 121.0 | 180.7 | 52.7 | -39.1 | 62.5 | 60.5 | 58.6 | 56.8 | 55.1 |
EBITDA, % | 8.3 | 12.21 | 15.27 | 5.5 | -4.47 | 7.36 | 7.36 | 7.36 | 7.36 | 7.36 |
Depreciation | 25.1 | 24.1 | 22.9 | 21.6 | 22.8 | 19.8 | 19.2 | 18.6 | 18.0 | 17.4 |
Depreciation, % | 2.43 | 2.43 | 1.94 | 2.26 | 2.6 | 2.33 | 2.33 | 2.33 | 2.33 | 2.33 |
EBIT | 60.7 | 96.9 | 157.8 | 31.1 | -61.9 | 42.7 | 41.4 | 40.1 | 38.8 | 37.6 |
EBIT, % | 5.87 | 9.79 | 13.33 | 3.25 | -7.07 | 5.03 | 5.03 | 5.03 | 5.03 | 5.03 |
Total Cash | 251.2 | 375.5 | 294.5 | 173.5 | 171.6 | 211.7 | 205.1 | 198.8 | 192.6 | 186.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 16.8 | 16.6 | 14.4 | 20.6 | 13.8 | 14.0 | 13.6 | 13.1 | 12.7 | 12.3 |
Account Receivables, % | 1.63 | 1.67 | 1.22 | 2.15 | 1.57 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 |
Inventories | 135.1 | 134.4 | 128.7 | 134.8 | 128.8 | 112.5 | 109.0 | 105.6 | 102.3 | 99.2 |
Inventories, % | 13.06 | 13.56 | 10.87 | 14.07 | 14.71 | 13.26 | 13.26 | 13.26 | 13.26 | 13.26 |
Accounts Payable | 47.8 | 69.8 | 55.6 | 40.4 | 38.9 | 42.4 | 41.1 | 39.9 | 38.6 | 37.4 |
Accounts Payable, % | 4.62 | 7.04 | 4.7 | 4.21 | 4.44 | 5 | 5 | 5 | 5 | 5 |
Capital Expenditure | -18.8 | -9.1 | -15.7 | -25.6 | -20.4 | -15.4 | -14.9 | -14.4 | -14.0 | -13.6 |
Capital Expenditure, % | -1.82 | -0.91425 | -1.33 | -2.67 | -2.32 | -1.81 | -1.81 | -1.81 | -1.81 | -1.81 |
Tax Rate, % | -1.18 | -1.18 | -1.18 | -1.18 | -1.18 | -1.18 | -1.18 | -1.18 | -1.18 | -1.18 |
EBITAT | 44.6 | 72.1 | 117.3 | 20.1 | -62.6 | 33.0 | 32.0 | 31.0 | 30.1 | 29.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -53.2 | 110.1 | 118.1 | -11.4 | -48.9 | 57.2 | 38.9 | 37.7 | 36.5 | 35.4 |
WACC, % | 7.7 | 7.71 | 7.71 | 7.55 | 8.13 | 7.76 | 7.76 | 7.76 | 7.76 | 7.76 |
PV UFCF | ||||||||||
SUM PV UFCF | 168.0 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 36 | |||||||||
Terminal Value | 528 | |||||||||
Present Terminal Value | 364 | |||||||||
Enterprise Value | 532 | |||||||||
Net Debt | 132 | |||||||||
Equity Value | 400 | |||||||||
Diluted Shares Outstanding, MM | 19 | |||||||||
Equity Value Per Share | 20.73 |
What You Will Get
- Real Zumiez Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Zumiez’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Accurate Zumiez Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help you visualize your valuation results.
- Suitable for All Skill Levels: An intuitive design tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Zumiez Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Zumiez Inc. (ZUMZ)?
- Accurate Data: Up-to-date Zumiez financials provide trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations remove the hassle of starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the retail sector.
- User-Friendly: Simple design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Zumiez Inc. (ZUMZ) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Offer clients precise valuation insights for Zumiez Inc. (ZUMZ) stock.
- Students and Educators: Utilize real-world data to learn and teach financial modeling techniques.
- Retail Enthusiasts: Gain insights into how retail companies like Zumiez Inc. (ZUMZ) are valued in the marketplace.
What the Template Contains
- Pre-Filled Data: Contains Zumiez Inc.'s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Evaluate Zumiez Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing key valuation results.