|
Weyco Group, Inc. (Weys) DCF Valoración
US | Consumer Cyclical | Apparel - Footwear & Accessories | 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
Weyco Group, Inc. (WEYS) Bundle
¡Simplifique la valoración de Weyco Group, Inc. (WEYS) con esta calculadora DCF personalizable! Con el Real Weyco Group, Inc. (Weys) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Weyco Group, Inc. (WEYS) en minutos.
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 | 304.0 | 195.4 | 267.6 | 351.7 | 318.0 | 336.4 | 355.8 | 376.4 | 398.1 | 421.1 |
Revenue Growth, % | 0 | -35.73 | 36.99 | 31.42 | -9.58 | 5.77 | 5.77 | 5.77 | 5.77 | 5.77 |
EBITDA | 30.9 | -3.8 | 30.1 | 43.2 | 44.2 | 30.7 | 32.5 | 34.3 | 36.3 | 38.4 |
EBITDA, % | 10.15 | -1.97 | 11.26 | 12.27 | 13.89 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 |
Depreciation | 3.5 | 3.1 | 2.7 | 2.7 | 2.9 | 3.7 | 3.9 | 4.1 | 4.3 | 4.6 |
Depreciation, % | 1.16 | 1.6 | 1.02 | 0.77274 | 0.89609 | 1.09 | 1.09 | 1.09 | 1.09 | 1.09 |
EBIT | 27.3 | -7.0 | 27.4 | 40.4 | 41.3 | 27.0 | 28.6 | 30.2 | 32.0 | 33.8 |
EBIT, % | 8.99 | -3.57 | 10.25 | 11.5 | 12.99 | 8.03 | 8.03 | 8.03 | 8.03 | 8.03 |
Total Cash | 15.7 | 34.7 | 28.1 | 18.4 | 69.5 | 40.7 | 43.0 | 45.5 | 48.2 | 50.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 51.5 | 36.0 | 53.8 | 54.2 | 39.5 | 56.1 | 59.3 | 62.7 | 66.3 | 70.2 |
Account Receivables, % | 16.95 | 18.43 | 20.09 | 15.42 | 12.43 | 16.66 | 16.66 | 16.66 | 16.66 | 16.66 |
Inventories | 86.7 | 59.0 | 71.0 | 128.0 | 74.9 | 97.7 | 103.3 | 109.3 | 115.6 | 122.3 |
Inventories, % | 28.52 | 30.21 | 26.54 | 36.38 | 23.55 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 |
Accounts Payable | 12.5 | 8.4 | 19.2 | 14.9 | 8.8 | 15.2 | 16.1 | 17.0 | 18.0 | 19.1 |
Accounts Payable, % | 4.1 | 4.32 | 7.19 | 4.25 | 2.78 | 4.53 | 4.53 | 4.53 | 4.53 | 4.53 |
Capital Expenditure | -7.4 | -3.4 | -1.0 | -2.3 | -3.3 | -4.2 | -4.4 | -4.7 | -5.0 | -5.3 |
Capital Expenditure, % | -2.43 | -1.72 | -0.37625 | -0.66584 | -1.04 | -1.25 | -1.25 | -1.25 | -1.25 | -1.25 |
Tax Rate, % | 26.13 | 26.13 | 26.13 | 26.13 | 26.13 | 26.13 | 26.13 | 26.13 | 26.13 | 26.13 |
EBITAT | 21.1 | -8.4 | 20.6 | 30.1 | 30.5 | 21.6 | 22.9 | 24.2 | 25.6 | 27.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -108.6 | 30.6 | 3.3 | -31.3 | 91.8 | -11.9 | 14.3 | 15.2 | 16.0 | 17.0 |
WACC, % | 7.56 | 7.6 | 7.56 | 7.55 | 7.55 | 7.56 | 7.56 | 7.56 | 7.56 | 7.56 |
PV UFCF | ||||||||||
SUM PV UFCF | 37.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 17 | |||||||||
Terminal Value | 241 | |||||||||
Present Terminal Value | 168 | |||||||||
Enterprise Value | 205 | |||||||||
Net Debt | -56 | |||||||||
Equity Value | 261 | |||||||||
Diluted Shares Outstanding, MM | 10 | |||||||||
Equity Value Per Share | 27.34 |
What You Will Get
- Real WEYS Financial Data: Pre-filled with Weyco Group’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 Weyco Group’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
- 🔍 Real-Life WEYS Financials: Pre-filled historical and projected data for Weyco Group, Inc. (WEYS).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Weyco Group’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Weyco Group’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring Weyco Group, Inc. (WEYS) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Weyco Group, Inc. (WEYS) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Weyco Group, Inc. (WEYS)?
- Designed for Experts: A sophisticated tool favored by financial analysts, CFOs, and industry consultants.
- Accurate Data: Weyco Group’s historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Assess the fair value of Weyco Group, Inc. (WEYS) to inform your investment choices.
- CFOs: Utilize a sophisticated DCF model for accurate financial reporting and analysis.
- Consultants: Efficiently customize the template for client valuation reports.
- Entrepreneurs: Discover financial modeling techniques employed by leading companies.
- Educators: Employ it as an educational resource to illustrate valuation methods.
What the Template Contains
- Preloaded WEYS 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.