Compass Diversified (CODI) DCF Valuation

Compass Diversified (CODI) DCF Valuation
  • ✓ 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

Compass Diversified (CODI) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 13.2 13.25 15.08 13.15 15.46
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.

No products were found matching.