Compass Diversified (CODI) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Compass Diversified (CODI) Bundle
Evaluate the financial outlook of Compass Diversified like an expert! This (CODI) DCF Calculator provides you with pre-filled financials and the ability to effortlessly modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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,450.3 | 1,560.8 | 1,841.7 | 2,264.0 | 2,058.9 | 2,262.1 | 2,485.5 | 2,730.9 | 3,000.5 | 3,296.7 |
| Revenue Growth, % | 0 | 7.62 | 18 | 22.93 | -9.06 | 9.87 | 9.87 | 9.87 | 9.87 | 9.87 |
| EBITDA | 121.2 | 145.7 | 249.7 | 253.8 | 236.1 | 244.0 | 268.1 | 294.6 | 323.6 | 355.6 |
| EBITDA, % | 8.36 | 9.34 | 13.56 | 11.21 | 11.47 | 10.79 | 10.79 | 10.79 | 10.79 | 10.79 |
| Depreciation | 87.3 | 92.8 | 119.7 | 124.7 | 142.4 | 139.8 | 153.6 | 168.7 | 185.4 | 203.7 |
| Depreciation, % | 6.02 | 5.95 | 6.5 | 5.51 | 6.91 | 6.18 | 6.18 | 6.18 | 6.18 | 6.18 |
| EBIT | 33.9 | 52.9 | 130.0 | 129.1 | 93.8 | 104.2 | 114.5 | 125.8 | 138.3 | 151.9 |
| EBIT, % | 2.34 | 3.39 | 7.06 | 5.7 | 4.55 | 4.61 | 4.61 | 4.61 | 4.61 | 4.61 |
| Total Cash | 100.3 | 70.7 | 157.1 | 61.3 | 450.5 | 201.6 | 221.5 | 243.4 | 267.4 | 293.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 191.4 | 206.7 | 277.7 | 297.7 | 318.2 | 317.3 | 348.6 | 383.0 | 420.8 | 462.4 |
| Account Receivables, % | 13.2 | 13.25 | 15.08 | 13.15 | 15.46 | 14.03 | 14.03 | 14.03 | 14.03 | 14.03 |
| Inventories | 317.3 | 363.4 | 562.1 | 732.4 | 740.4 | 651.5 | 715.8 | 786.4 | 864.1 | 949.4 |
| Inventories, % | 21.88 | 23.28 | 30.52 | 32.35 | 35.96 | 28.8 | 28.8 | 28.8 | 28.8 | 28.8 |
| Accounts Payable | 70.1 | 91.7 | 124.2 | 82.9 | 93.4 | 116.1 | 127.5 | 140.1 | 153.9 | 169.1 |
| Accounts Payable, % | 4.83 | 5.88 | 6.74 | 3.66 | 4.54 | 5.13 | 5.13 | 5.13 | 5.13 | 5.13 |
| Capital Expenditure | -34.9 | -30.8 | -39.9 | -64.3 | -55.8 | -54.7 | -60.1 | -66.0 | -72.6 | -79.7 |
| Capital Expenditure, % | -2.41 | -1.97 | -2.17 | -2.84 | -2.71 | -2.42 | -2.42 | -2.42 | -2.42 | -2.42 |
| Tax Rate, % | 1515.03 | 1515.03 | 1515.03 | 1515.03 | 1515.03 | 1515.03 | 1515.03 | 1515.03 | 1515.03 | 1515.03 |
| EBITAT | 53.1 | 27.4 | 74.8 | 53.9 | -1,326.8 | 52.4 | 57.5 | 63.2 | 69.4 | 76.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -333.1 | 49.7 | -82.5 | -117.2 | -1,258.2 | 249.9 | 66.8 | 73.4 | 80.6 | 88.6 |
| WACC, % | 9.43 | 7.83 | 8.02 | 7.49 | 6.1 | 7.77 | 7.77 | 7.77 | 7.77 | 7.77 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 468.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 90 | |||||||||
| Terminal Value | 1,565 | |||||||||
| Present Terminal Value | 1,077 | |||||||||
| Enterprise Value | 1,545 | |||||||||
| Net Debt | 1,221 | |||||||||
| Equity Value | 324 | |||||||||
| Diluted Shares Outstanding, MM | 72 | |||||||||
| Equity Value Per Share | 4.49 |
What You Will Get
- Real Compass Diversified Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for CODI (CODI).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to CODI (CODI).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Compass Diversified’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for CODI (CODI).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for CODI (CODI).
Key Features
- Pre-Loaded Data: Compass Diversified’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Observe Compass Diversified’s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance professionals.
How It Works
- Download: Get the pre-built Excel file featuring Compass Diversified's (CODI) financial data.
- Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC as needed.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Compass Diversified (CODI)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Compass Diversified’s intrinsic value and Net Present Value.
- Preloaded Data: Access to historical and projected data for reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants.
Who Should Use This Product?
- Professional Investors: Create comprehensive and accurate valuation models for portfolio assessments involving Compass Diversified (CODI).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Compass Diversified (CODI) investments.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Finance Enthusiasts: Gain insights into how companies like Compass Diversified (CODI) are appraised in the market.
What the Template Contains
- Historical Data: Includes Compass Diversified’s (CODI) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Compass Diversified’s (CODI) 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 Compass Diversified’s (CODI) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.