|
Coeur Mining, Inc. (CDE) Valoración de DCF
US | Basic Materials | Gold | NYSE
|
- ✓ 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
Coeur Mining, Inc. (CDE) Bundle
¡Descubra el verdadero valor de Coeur Mining, Inc. (CDE) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Coeur Mining, Inc. (CDE), todo dentro de una sola plantilla de Excel.
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 | 711.5 | 785.5 | 832.8 | 785.6 | 821.2 | 852.6 | 885.2 | 919.0 | 954.1 | 990.6 |
Revenue Growth, % | 0 | 10.39 | 6.03 | -5.67 | 4.53 | 3.82 | 3.82 | 3.82 | 3.82 | 3.82 |
EBITDA | -142.4 | 226.5 | 160.4 | 85.2 | 76.9 | 82.3 | 85.5 | 88.8 | 92.1 | 95.7 |
EBITDA, % | -20.02 | 28.84 | 19.26 | 10.85 | 9.36 | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 |
Depreciation | 190.8 | 143.1 | 140.3 | 125.9 | 116.2 | 157.0 | 163.0 | 169.2 | 175.7 | 182.4 |
Depreciation, % | 26.82 | 18.22 | 16.85 | 16.02 | 14.15 | 18.41 | 18.41 | 18.41 | 18.41 | 18.41 |
EBIT | -333.3 | 83.4 | 20.1 | -40.7 | -39.4 | -74.6 | -77.5 | -80.5 | -83.5 | -86.7 |
EBIT, % | -46.84 | 10.62 | 2.41 | -5.17 | -4.79 | -8.76 | -8.76 | -8.76 | -8.76 | -8.76 |
Total Cash | 55.6 | 92.8 | 56.7 | 93.5 | 61.6 | 78.2 | 81.2 | 84.3 | 87.5 | 90.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 18.7 | 23.5 | 32.4 | 6.3 | 3.9 | 18.4 | 19.1 | 19.8 | 20.6 | 21.4 |
Account Receivables, % | 2.62 | 2.99 | 3.89 | 0.80215 | 0.4698 | 2.16 | 2.16 | 2.16 | 2.16 | 2.16 |
Inventories | 122.1 | 126.1 | 132.4 | 144.8 | 156.1 | 147.6 | 153.2 | 159.1 | 165.1 | 171.5 |
Inventories, % | 17.16 | 16.05 | 15.9 | 18.43 | 19 | 17.31 | 17.31 | 17.31 | 17.31 | 17.31 |
Accounts Payable | 69.2 | 90.6 | 103.9 | 96.1 | 115.1 | 102.3 | 106.2 | 110.2 | 114.5 | 118.8 |
Accounts Payable, % | 9.72 | 11.53 | 12.48 | 12.24 | 14.02 | 12 | 12 | 12 | 12 | 12 |
Capital Expenditure | -99.8 | -99.3 | -309.8 | -352.4 | -364.6 | -261.1 | -271.1 | -281.4 | -292.2 | -303.3 |
Capital Expenditure, % | -14.02 | -12.64 | -37.2 | -44.85 | -44.4 | -30.62 | -30.62 | -30.62 | -30.62 | -30.62 |
Tax Rate, % | -51.36 | -51.36 | -51.36 | -51.36 | -51.36 | -51.36 | -51.36 | -51.36 | -51.36 | -51.36 |
EBITAT | -322.9 | 34.1 | -173.0 | -50.0 | -59.6 | -50.4 | -52.4 | -54.4 | -56.4 | -58.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -303.4 | 90.5 | -344.5 | -270.6 | -297.8 | -173.4 | -162.9 | -169.1 | -175.5 | -182.2 |
WACC, % | 10.67 | 10.02 | 9.55 | 10.7 | 10.7 | 10.33 | 10.33 | 10.33 | 10.33 | 10.33 |
PV UFCF | ||||||||||
SUM PV UFCF | -646.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -186 | |||||||||
Terminal Value | -2,232 | |||||||||
Present Terminal Value | -1,365 | |||||||||
Enterprise Value | -2,012 | |||||||||
Net Debt | 494 | |||||||||
Equity Value | -2,506 | |||||||||
Diluted Shares Outstanding, MM | 343 | |||||||||
Equity Value Per Share | -7.30 |
What You Will Get
- Real Coeur Mining Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Coeur Mining, Inc. (CDE).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Coeur Mining, Inc. (CDE).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Coeur Mining, Inc. (CDE)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Coeur Mining, Inc. (CDE).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Coeur Mining, Inc. (CDE).
Key Features
- Real-Life CDE Data: Pre-filled with Coeur Mining’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust production forecasts, mining costs, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- 1. Access the Template: Download and open the Excel file containing Coeur Mining, Inc.'s (CDE) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate multiple forecasts to examine various valuation outcomes.
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making.
Why Choose This Calculator for Coeur Mining, Inc. (CDE)?
- Accurate Data: Real Coeur Mining financials provide trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the mining sector.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about investing in Coeur Mining, Inc. (CDE).
- Financial Analysts: Enhance valuation methodologies with comprehensive financial models tailored for Coeur Mining, Inc. (CDE).
- Consultants: Provide clients with expert valuation analysis of Coeur Mining, Inc. (CDE) efficiently and effectively.
- Business Owners: Learn how mining companies like Coeur Mining, Inc. (CDE) are valued to inform your own business strategies.
- Finance Students: Explore valuation principles using real data and case studies related to Coeur Mining, Inc. (CDE).
What the Template Contains
- Pre-Filled DCF Model: Coeur Mining’s (CDE) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Coeur Mining’s (CDE) 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.