|
Escalade, valoración DCF Incorporated (ESCA)
US | Consumer Cyclical | Leisure | 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
Escalade, Incorporated (ESCA) Bundle
¡Descubra el verdadero valor de Escalade, Incorporated (ESCA) con nuestra calculadora DCF avanzada! Ajuste suposiciones esenciales, explore varios escenarios y evalúe los efectos de los cambios en la valoración de Escalade, todo dentro de una plantilla de Excel fácil de usar.
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 | 180.5 | 273.6 | 313.6 | 313.8 | 263.6 | 296.7 | 333.9 | 375.8 | 423.0 | 476.1 |
Revenue Growth, % | 0 | 51.57 | 14.6 | 0.04623548 | -16 | 12.56 | 12.56 | 12.56 | 12.56 | 12.56 |
EBITDA | 13.3 | 37.0 | 36.7 | 32.4 | 23.5 | 30.8 | 34.6 | 39.0 | 43.9 | 49.4 |
EBITDA, % | 7.37 | 13.54 | 11.71 | 10.32 | 8.92 | 10.37 | 10.37 | 10.37 | 10.37 | 10.37 |
Depreciation | 4.0 | 4.0 | 4.8 | 6.1 | 5.7 | 5.5 | 6.2 | 7.0 | 7.9 | 8.9 |
Depreciation, % | 2.23 | 1.47 | 1.54 | 1.93 | 2.15 | 1.87 | 1.87 | 1.87 | 1.87 | 1.87 |
EBIT | 9.3 | 33.0 | 31.9 | 26.3 | 17.8 | 25.2 | 28.4 | 32.0 | 36.0 | 40.5 |
EBIT, % | 5.14 | 12.07 | 10.17 | 8.39 | 6.77 | 8.51 | 8.51 | 8.51 | 8.51 | 8.51 |
Total Cash | 5.9 | 3.5 | 4.4 | 4.0 | .0 | 4.3 | 4.8 | 5.4 | 6.1 | 6.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 35.5 | 65.3 | 66.0 | 57.4 | 50.0 | 60.4 | 68.0 | 76.5 | 86.1 | 96.9 |
Account Receivables, % | 19.64 | 23.86 | 21.04 | 18.3 | 18.96 | 20.36 | 20.36 | 20.36 | 20.36 | 20.36 |
Inventories | 42.3 | 72.5 | 92.4 | 121.9 | 92.5 | 90.9 | 102.4 | 115.2 | 129.7 | 146.0 |
Inventories, % | 23.41 | 26.49 | 29.46 | 38.84 | 35.08 | 30.66 | 30.66 | 30.66 | 30.66 | 30.66 |
Accounts Payable | 7.8 | 20.9 | 15.8 | 9.4 | 9.8 | 14.1 | 15.8 | 17.8 | 20.1 | 22.6 |
Accounts Payable, % | 4.3 | 7.65 | 5.05 | 3 | 3.72 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
Capital Expenditure | -2.2 | -5.5 | -9.7 | -2.1 | -2.1 | -4.6 | -5.2 | -5.8 | -6.6 | -7.4 |
Capital Expenditure, % | -1.21 | -1.99 | -3.09 | -0.67281 | -0.79107 | -1.55 | -1.55 | -1.55 | -1.55 | -1.55 |
Tax Rate, % | 21.32 | 21.32 | 21.32 | 21.32 | 21.32 | 21.32 | 21.32 | 21.32 | 21.32 | 21.32 |
EBITAT | 7.5 | 26.0 | 25.5 | 20.9 | 14.0 | 20.1 | 22.6 | 25.5 | 28.7 | 32.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -60.6 | -22.3 | -5.1 | -2.5 | 54.8 | 16.4 | 6.4 | 7.2 | 8.1 | 9.2 |
WACC, % | 9.64 | 9.59 | 9.61 | 9.6 | 9.59 | 9.6 | 9.6 | 9.6 | 9.6 | 9.6 |
PV UFCF | ||||||||||
SUM PV UFCF | 37.3 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 9 | |||||||||
Terminal Value | 155 | |||||||||
Present Terminal Value | 98 | |||||||||
Enterprise Value | 136 | |||||||||
Net Debt | 60 | |||||||||
Equity Value | 76 | |||||||||
Diluted Shares Outstanding, MM | 14 | |||||||||
Equity Value Per Share | 5.44 |
What You Will Receive
- Comprehensive Financial Model: Utilize Escalade, Incorporated’s (ESCA) actual performance data for accurate DCF analysis.
- Complete Forecasting Flexibility: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Instant updates allow you to view results immediately as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, enabling repeated application for in-depth forecasting.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as sales growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value, and additional financial metrics.
- High Precision Valuation: Incorporates Escalade's real-world financial data for accurate valuation results.
- Effortless Scenario Testing: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Escalade, Incorporated’s (ESCA) 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 the recalibrated results, including Escalade, Incorporated’s (ESCA) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose This Calculator for Escalade, Incorporated (ESCA)?
- Accuracy: Utilizes real Escalade financials to ensure precise data.
- Flexibility: Crafted for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexities of building a DCF model from the ground up.
- Professional-Grade: Designed with the precision and usability expected by CFOs.
- User-Friendly: Intuitive interface, suitable for users without advanced financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Escalade, Incorporated (ESCA) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Escalade, Incorporated (ESCA).
- Consultants: Deliver professional valuation insights on Escalade, Incorporated (ESCA) to clients quickly and accurately.
- Business Owners: Understand how companies like Escalade, Incorporated (ESCA) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Escalade, Incorporated (ESCA).
What the Template Contains
- Pre-Filled Data: Contains Escalade, Incorporated's historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations for [ESCA].
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs for [ESCA].
- Key Financial Ratios: Assess Escalade’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing key valuation outcomes for [ESCA].