Cadre Holdings, Inc. (CDRE) 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
Cadre Holdings, Inc. (CDRE) Bundle
Discover the true potential of Cadre Holdings, Inc. (CDRE) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect Cadre Holdings, Inc. (CDRE) valuation – all within one convenient Excel template.
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 | 420.7 | 404.6 | 427.3 | 457.8 | 482.5 | 499.8 | 517.7 | 536.2 | 555.4 | 575.3 |
Revenue Growth, % | 0 | -3.83 | 5.6 | 7.15 | 5.39 | 3.58 | 3.58 | 3.58 | 3.58 | 3.58 |
EBITDA | 44.1 | 59.4 | 68.9 | 42.0 | 75.4 | 66.1 | 68.4 | 70.9 | 73.4 | 76.0 |
EBITDA, % | 10.49 | 14.68 | 16.12 | 9.17 | 15.64 | 13.22 | 13.22 | 13.22 | 13.22 | 13.22 |
Depreciation | 15.4 | 14.7 | 13.7 | 15.7 | 15.7 | 17.2 | 17.8 | 18.4 | 19.1 | 19.8 |
Depreciation, % | 3.67 | 3.64 | 3.21 | 3.42 | 3.26 | 3.44 | 3.44 | 3.44 | 3.44 | 3.44 |
EBIT | 28.7 | 44.7 | 55.1 | 26.3 | 59.7 | 48.9 | 50.6 | 52.4 | 54.3 | 56.2 |
EBIT, % | 6.82 | 11.04 | 12.91 | 5.75 | 12.37 | 9.78 | 9.78 | 9.78 | 9.78 | 9.78 |
Total Cash | 2.5 | 2.9 | 33.9 | 45.3 | 87.7 | 37.3 | 38.6 | 40.0 | 41.4 | 42.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 55.6 | 43.6 | 48.3 | 64.6 | 58.4 | 61.5 | 63.7 | 66.0 | 68.3 | 70.8 |
Account Receivables, % | 13.21 | 10.79 | 11.31 | 14.1 | 12.09 | 12.3 | 12.3 | 12.3 | 12.3 | 12.3 |
Inventories | 62.1 | 60.9 | 64.0 | 70.3 | 81.0 | 76.9 | 79.6 | 82.5 | 85.4 | 88.5 |
Inventories, % | 14.77 | 15.06 | 14.97 | 15.35 | 16.78 | 15.39 | 15.39 | 15.39 | 15.39 | 15.39 |
Accounts Payable | 25.7 | 22.0 | 19.3 | 23.4 | 28.4 | 27.1 | 28.0 | 29.0 | 30.1 | 31.1 |
Accounts Payable, % | 6.11 | 5.43 | 4.52 | 5.11 | 5.89 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 |
Capital Expenditure | -3.1 | -4.7 | -2.8 | -4.5 | -6.7 | -4.9 | -5.1 | -5.3 | -5.5 | -5.7 |
Capital Expenditure, % | -0.73253 | -1.16 | -0.66278 | -0.98157 | -1.39 | -0.9869 | -0.9869 | -0.9869 | -0.9869 | -0.9869 |
Tax Rate, % | 26.99 | 26.99 | 26.99 | 26.99 | 26.99 | 26.99 | 26.99 | 26.99 | 26.99 | 26.99 |
EBITAT | 26.7 | 61.6 | 36.4 | 16.3 | 43.6 | 38.5 | 39.9 | 41.3 | 42.8 | 44.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -52.9 | 81.0 | 36.9 | 9.1 | 53.1 | 50.4 | 48.6 | 50.4 | 52.2 | 54.0 |
WACC, % | 9.9 | 9.93 | 9.77 | 9.75 | 9.8 | 9.83 | 9.83 | 9.83 | 9.83 | 9.83 |
PV UFCF | ||||||||||
SUM PV UFCF | 193.9 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 56 | |||||||||
Terminal Value | 964 | |||||||||
Present Terminal Value | 603 | |||||||||
Enterprise Value | 797 | |||||||||
Net Debt | 59 | |||||||||
Equity Value | 738 | |||||||||
Diluted Shares Outstanding, MM | 38 | |||||||||
Equity Value Per Share | 19.47 |
What You Will Get
- Comprehensive CDRE Financials: Access to both historical data and future projections for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Cadre Holdings' future performance.
- User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Model: Features both unlevered and levered DCF valuation frameworks tailored for Cadre Holdings, Inc. (CDRE).
- WACC Analysis Tool: Pre-configured Weighted Average Cost of Capital calculator with adjustable parameters.
- Customizable Forecast Inputs: Adjust growth projections, capital spending, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency metrics specifically for Cadre Holdings, Inc. (CDRE).
- Visual Dashboard and Charts: Graphical representations that highlight essential valuation indicators for straightforward interpretation.
How It Works
- 1. Access the Template: Download and open the Excel file containing Cadre Holdings, Inc.'s (CDRE) financial data.
- 2. Adjust Key Inputs: Modify critical variables such as growth projections, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Various Scenarios: Evaluate different forecasts to understand a range of valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation analyses to bolster your strategic decisions.
Why Choose This Calculator for Cadre Holdings, Inc. (CDRE)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Cadre Holdings.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for (CDRE).
- In-Depth Analysis: Automatically computes Cadre Holdings’ intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business consultants focusing on (CDRE).
Who Should Use This Product?
- Investors: Evaluate Cadre Holdings, Inc.'s (CDRE) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and analyze financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like Cadre Holdings, Inc.
- Consultants: Provide clients with comprehensive valuation assessments for informed decision-making.
- Students and Educators: Utilize current data to learn and teach effective valuation practices.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for Cadre Holdings, Inc. (CDRE).
- Real-World Data: Cadre Holdings’ historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Cadre Holdings, Inc. (CDRE).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Cadre Holdings, Inc. (CDRE).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Cadre Holdings, Inc. (CDRE).