|
Clarus Corporation (Clar) DCF Valoración
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
Clarus Corporation (CLAR) Bundle
¡Evalúe la perspectiva financiera de Clarus Corporation (Clar) como un experto! Esta calculadora DCF (Clar) proporciona métricas financieras prejuidas y ofrece una flexibilidad total para modificar el crecimiento de los ingresos, WACC, los márgenes y otros supuestos cruciales para alinearse con sus predicciones.
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 | 229.4 | 224.0 | 375.8 | 448.1 | 286.0 | 320.7 | 359.5 | 403.1 | 451.9 | 506.7 |
Revenue Growth, % | 0 | -2.37 | 67.76 | 19.24 | -36.17 | 12.12 | 12.12 | 12.12 | 12.12 | 12.12 |
EBITDA | 20.2 | 14.6 | 13.0 | 12.4 | 1.5 | 14.2 | 15.9 | 17.8 | 19.9 | 22.4 |
EBITDA, % | 8.79 | 6.52 | 3.47 | 2.76 | 0.52234 | 4.41 | 4.41 | 4.41 | 4.41 | 4.41 |
Depreciation | 8.8 | 9.8 | 18.2 | 23.0 | 20.4 | 16.2 | 18.2 | 20.4 | 22.9 | 25.6 |
Depreciation, % | 3.85 | 4.36 | 4.84 | 5.12 | 7.11 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 |
EBIT | 11.3 | 4.8 | -5.2 | -10.6 | -18.9 | -2.1 | -2.3 | -2.6 | -2.9 | -3.3 |
EBIT, % | 4.94 | 2.16 | -1.38 | -2.36 | -6.59 | -0.64532 | -0.64532 | -0.64532 | -0.64532 | -0.64532 |
Total Cash | 1.7 | 17.8 | 19.5 | 12.1 | 11.3 | 13.2 | 14.8 | 16.5 | 18.5 | 20.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 42.0 | 50.6 | 66.3 | 48.1 | 54.9 | 56.7 | 63.6 | 71.3 | 79.9 | 89.6 |
Account Receivables, % | 18.28 | 22.59 | 17.64 | 10.74 | 19.18 | 17.69 | 17.69 | 17.69 | 17.69 | 17.69 |
Inventories | 73.4 | 68.4 | 129.4 | 147.1 | 91.4 | 103.7 | 116.3 | 130.4 | 146.2 | 163.9 |
Inventories, % | 32.01 | 30.52 | 34.42 | 32.82 | 31.96 | 32.34 | 32.34 | 32.34 | 32.34 | 32.34 |
Accounts Payable | 13.5 | 21.5 | 31.5 | 24.8 | 20.0 | 23.3 | 26.2 | 29.3 | 32.9 | 36.9 |
Accounts Payable, % | 5.89 | 9.59 | 8.38 | 5.53 | 7 | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 |
Capital Expenditure | -4.1 | -5.4 | -17.4 | -8.3 | -6.0 | -8.2 | -9.2 | -10.3 | -11.5 | -12.9 |
Capital Expenditure, % | -1.79 | -2.42 | -4.63 | -1.84 | -2.09 | -2.55 | -2.55 | -2.55 | -2.55 | -2.55 |
Tax Rate, % | 49.47 | 49.47 | 49.47 | 49.47 | 49.47 | 49.47 | 49.47 | 49.47 | 49.47 | 49.47 |
EBITAT | 21.6 | 7.5 | -9.7 | -9.6 | -9.5 | -1.8 | -2.0 | -2.3 | -2.6 | -2.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -75.6 | 16.3 | -75.6 | -1.2 | 49.0 | -4.6 | -9.6 | -10.8 | -12.1 | -13.6 |
WACC, % | 6.64 | 6.64 | 6.64 | 6.45 | 5.66 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
PV UFCF | ||||||||||
SUM PV UFCF | -41.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -14 | |||||||||
Terminal Value | -315 | |||||||||
Present Terminal Value | -231 | |||||||||
Enterprise Value | -272 | |||||||||
Net Debt | 125 | |||||||||
Equity Value | -397 | |||||||||
Diluted Shares Outstanding, MM | 37 | |||||||||
Equity Value Per Share | -10.59 |
What You Will Get
- Editable Forecast Inputs: Seamlessly adjust assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Clarus Corporation’s (CLAR) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you automatically.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Clarus Corporation (CLAR).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Visual Dashboard: Intuitive charts and summaries to help you visualize your valuation outcomes.
- Designed for All Skill Levels: A straightforward layout tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Download the Template: Obtain the Excel file containing Clarus Corporation’s (CLAR) preloaded data.
- 2. Modify Assumptions: Adjust crucial inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to investigate different valuation results.
- 5. Present with Assurance: Share professional valuation insights to reinforce your decision-making process.
Why Choose This Calculator for Clarus Corporation (CLAR)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for Clarus Corporation (CLAR).
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios for Clarus Corporation (CLAR).
- Detailed Insights: Automatically computes Clarus Corporation’s (CLAR) intrinsic value and Net Present Value.
- Preloaded Data: Historical and forecasted data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on Clarus Corporation (CLAR).
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing portfolios involving Clarus Corporation (CLAR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Clarus Corporation (CLAR).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into the market valuation of tech companies like Clarus Corporation (CLAR).
What the Template Contains
- Historical Data: Includes Clarus Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Clarus Corporation’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Clarus Corporation’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.