Compass Minerals International, Inc. (CMP) 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 Minerals International, Inc. (CMP) Bundle
Evaluate the financial outlook of Compass Minerals International, Inc. (CMP) with expert precision! This (CMP) DCF Calculator comes with pre-filled financial data and offers total flexibility to 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,493.6 | 1,490.5 | 836.6 | 1,244.1 | 1,204.7 | 1,209.1 | 1,213.5 | 1,218.0 | 1,222.4 | 1,226.9 |
Revenue Growth, % | 0 | -0.20755 | -43.87 | 48.71 | -3.17 | 0.36584 | 0.36584 | 0.36584 | 0.36584 | 0.36584 |
EBITDA | 277.0 | 153.0 | 173.4 | 39.4 | 90.7 | 145.7 | 146.2 | 146.7 | 147.3 | 147.8 |
EBITDA, % | 18.55 | 10.27 | 20.73 | 3.17 | 7.53 | 12.05 | 12.05 | 12.05 | 12.05 | 12.05 |
Depreciation | 136.9 | 137.9 | 94.6 | 113.7 | 98.6 | 113.8 | 114.2 | 114.6 | 115.0 | 115.4 |
Depreciation, % | 9.17 | 9.25 | 11.31 | 9.14 | 8.18 | 9.41 | 9.41 | 9.41 | 9.41 | 9.41 |
EBIT | 140.1 | 15.1 | 78.8 | -74.3 | -7.9 | 31.9 | 32.0 | 32.1 | 32.2 | 32.4 |
EBIT, % | 9.38 | 1.01 | 9.42 | -5.97 | -0.65576 | 2.64 | 2.64 | 2.64 | 2.64 | 2.64 |
Total Cash | 27.0 | 34.7 | 18.1 | 46.1 | 38.7 | 32.0 | 32.1 | 32.2 | 32.3 | 32.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 311.6 | 342.4 | 132.8 | 167.2 | 129.5 | 202.9 | 203.6 | 204.4 | 205.1 | 205.9 |
Account Receivables, % | 20.86 | 22.97 | 15.87 | 13.44 | 10.75 | 16.78 | 16.78 | 16.78 | 16.78 | 16.78 |
Inventories | 266.6 | 311.5 | 321.7 | 302.2 | 392.2 | 324.2 | 325.3 | 326.5 | 327.7 | 328.9 |
Inventories, % | 17.85 | 20.9 | 38.45 | 24.29 | 32.56 | 26.81 | 26.81 | 26.81 | 26.81 | 26.81 |
Accounts Payable | 111.3 | 126.2 | 90.0 | 114.7 | 116.8 | 110.2 | 110.7 | 111.1 | 111.5 | 111.9 |
Accounts Payable, % | 7.45 | 8.47 | 10.76 | 9.22 | 9.7 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 |
Capital Expenditure | -96.8 | -98.1 | -71.8 | -96.7 | -149.4 | -101.1 | -101.5 | -101.9 | -102.2 | -102.6 |
Capital Expenditure, % | -6.48 | -6.58 | -8.58 | -7.77 | -12.4 | -8.36 | -8.36 | -8.36 | -8.36 | -8.36 |
Tax Rate, % | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 |
EBITAT | 112.8 | 10.6 | -478.9 | -3,029.8 | -3.7 | 19.0 | 19.1 | 19.1 | 19.2 | 19.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -314.0 | -10.4 | -292.9 | -3,003.0 | -104.7 | 19.8 | 30.2 | 30.3 | 30.5 | 30.6 |
WACC, % | 7.79 | 7.33 | 4.21 | 8.65 | 6.3 | 6.86 | 6.86 | 6.86 | 6.86 | 6.86 |
PV UFCF | ||||||||||
SUM PV UFCF | 115.2 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 32 | |||||||||
Terminal Value | 1,113 | |||||||||
Present Terminal Value | 799 | |||||||||
Enterprise Value | 914 | |||||||||
Net Debt | 767 | |||||||||
Equity Value | 147 | |||||||||
Diluted Shares Outstanding, MM | 41 | |||||||||
Equity Value Per Share | 3.61 |
What You Will Get
- Real Compass Minerals Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Compass Minerals International, Inc. (CMP).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Compass Minerals' fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Compass Minerals International, Inc. (CMP).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility in your financial assessments.
Key Features
- Comprehensive DCF Model: Features in-depth unlevered and levered DCF valuation frameworks.
- WACC Estimator: Ready-to-use Weighted Average Cost of Capital template with adjustable parameters.
- Customizable Forecast Inputs: Alter growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Compass Minerals International, Inc. (CMP).
- Interactive Dashboard and Visuals: Graphical representations highlight essential valuation indicators for streamlined analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing Compass Minerals International, Inc.'s (CMP) data.
- 2. Adjust Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. Instant Results: The DCF model automatically computes the intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities for Compass Minerals International, Inc. (CMP).
- 5. Present with Assurance: Deliver professional valuation insights that reinforce your decision-making process.
Why Choose This Calculator for Compass Minerals International, Inc. (CMP)?
- Designed for Experts: A specialized tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Compass Minerals’ historical and projected financials are preloaded to ensure precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Easy-to-follow instructions lead you through each step of the calculation.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing investments in Compass Minerals International, Inc. (CMP).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Offer clients precise valuation insights related to Compass Minerals International, Inc. (CMP).
- Students and Educators: Utilize real-world data to learn and teach financial modeling techniques.
- Industry Analysts: Gain insights into how companies like Compass Minerals International, Inc. (CMP) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Compass Minerals International's (CMP) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Compass Minerals' profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.