|
Valoración de DCF de Caledonia Mining Corporation PLC (CMCL)
JE | Basic Materials | Gold | AMEX
|
- ✓ 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
Caledonia Mining Corporation Plc (CMCL) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (CMCL)! Utilizando datos reales de Caledonia Mining Corporation PLC y supuestos personalizables, esta herramienta le permite pronosticar, evaluar y evaluar (CMCL) como un inversor experto.
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 | 75.8 | 100.0 | 121.3 | 142.1 | 138.7 | 162.2 | 189.8 | 222.0 | 259.7 | 303.8 |
Revenue Growth, % | 0 | 31.88 | 21.33 | 17.1 | -2.4 | 16.98 | 16.98 | 16.98 | 16.98 | 16.98 |
EBITDA | 65.5 | 45.4 | 46.4 | 50.4 | 29.7 | 73.6 | 86.1 | 100.8 | 117.9 | 137.9 |
EBITDA, % | 86.34 | 45.42 | 38.26 | 35.5 | 21.42 | 45.39 | 45.39 | 45.39 | 45.39 | 45.39 |
Depreciation | 4.5 | 4.6 | 8.0 | 10.3 | 14.5 | 11.3 | 13.2 | 15.5 | 18.1 | 21.1 |
Depreciation, % | 5.87 | 4.63 | 6.63 | 7.23 | 10.45 | 6.96 | 6.96 | 6.96 | 6.96 | 6.96 |
EBIT | 61.0 | 40.8 | 38.4 | 40.2 | 15.2 | 62.3 | 72.9 | 85.3 | 99.8 | 116.7 |
EBIT, % | 80.47 | 40.79 | 31.63 | 28.27 | 10.97 | 38.43 | 38.43 | 38.43 | 38.43 | 38.43 |
Total Cash | 9.4 | 19.1 | 17.2 | 4.7 | 6.7 | 17.4 | 20.4 | 23.9 | 27.9 | 32.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.9 | 3.9 | 8.0 | 7.4 | 11.1 | 9.8 | 11.5 | 13.4 | 15.7 | 18.4 |
Account Receivables, % | 6.49 | 3.94 | 6.63 | 5.2 | 7.98 | 6.05 | 6.05 | 6.05 | 6.05 | 6.05 |
Inventories | 11.1 | 16.8 | 20.8 | 18.3 | 20.3 | 24.7 | 28.9 | 33.8 | 39.5 | 46.2 |
Inventories, % | 14.63 | 16.8 | 17.15 | 12.9 | 14.64 | 15.22 | 15.22 | 15.22 | 15.22 | 15.22 |
Accounts Payable | 2.8 | 1.9 | 2.5 | 3.5 | 6.2 | 4.7 | 5.5 | 6.5 | 7.6 | 8.9 |
Accounts Payable, % | 3.73 | 1.9 | 2.06 | 2.46 | 4.45 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 |
Capital Expenditure | -20.0 | -27.8 | -37.8 | -44.1 | -30.4 | -44.9 | -52.5 | -61.4 | -71.9 | -84.1 |
Capital Expenditure, % | -26.41 | -27.84 | -31.18 | -31.03 | -21.92 | -27.67 | -27.67 | -27.67 | -27.67 | -27.67 |
Tax Rate, % | 134.43 | 134.43 | 134.43 | 134.43 | 134.43 | 134.43 | 134.43 | 134.43 | 134.43 | 134.43 |
EBITAT | 42.2 | 21.0 | 18.6 | 18.1 | -5.2 | 26.7 | 31.2 | 36.5 | 42.8 | 50.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 13.5 | -7.9 | -18.7 | -11.5 | -24.1 | -11.5 | -13.1 | -15.3 | -18.0 | -21.0 |
WACC, % | 7.91 | 7.64 | 7.6 | 7.55 | 6.86 | 7.51 | 7.51 | 7.51 | 7.51 | 7.51 |
PV UFCF | ||||||||||
SUM PV UFCF | -62.4 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | -21 | |||||||||
Terminal Value | -301 | |||||||||
Present Terminal Value | -210 | |||||||||
Enterprise Value | -272 | |||||||||
Net Debt | 18 | |||||||||
Equity Value | -290 | |||||||||
Diluted Shares Outstanding, MM | 19 | |||||||||
Equity Value Per Share | -15.58 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled financial data for Caledonia Mining Corporation Plc (CMCL).
- Accurate Data: Historical performance metrics and projected estimates (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Real-Time Calculations: Instantly observe how your inputs affect Caledonia Mining's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life CMCL Financials: Pre-filled historical and projected data for Caledonia Mining Corporation Plc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Caledonia’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Caledonia’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Functions
- Download: Obtain the pre-prepared Excel file featuring Caledonia Mining Corporation Plc's (CMCL) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator?
- Accuracy: Utilizes real Caledonia Mining Corporation Plc (CMCL) financial data for precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design ensures accessibility for users of all financial backgrounds.
Who Should Use This Product?
- Mining Students: Understand mining valuation methods and apply them using real-world data.
- Researchers: Utilize industry models in academic studies or publications.
- Investors: Evaluate your investment strategies and assess valuation metrics for Caledonia Mining Corporation Plc (CMCL).
- Market Analysts: Enhance your analysis with a ready-made, adaptable DCF model tailored for mining companies.
- Entrepreneurs: Discover how large mining firms like Caledonia are evaluated in the market.
What the Template Contains
- Pre-Filled Data: Includes Caledonia Mining Corporation Plc’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Caledonia Mining Corporation Plc’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.