|
Endeavoavor Silver Corp. (EXK) DCF Valoración
CA | Basic Materials | Other Precious Metals | 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
Endeavour Silver Corp. (EXK) Bundle
¡Simplifique la valoración de Endeavour Silver Corp. (EXK) con esta calculadora DCF personalizable! Con Real Endeavour Silver Corp. (EXK) financieras y entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Endeavour Silver Corp. (EXK) en minutos.
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 | 121.7 | 138.5 | 165.3 | 210.2 | 205.5 | 235.3 | 269.4 | 308.5 | 353.3 | 404.5 |
Revenue Growth, % | 0 | 13.75 | 19.4 | 27.12 | -2.23 | 14.51 | 14.51 | 14.51 | 14.51 | 14.51 |
EBITDA | -11.6 | 30.5 | 31.6 | 50.2 | 48.8 | 37.3 | 42.7 | 48.9 | 55.9 | 64.1 |
EBITDA, % | -9.54 | 22.01 | 19.08 | 23.88 | 23.75 | 15.84 | 15.84 | 15.84 | 15.84 | 15.84 |
Depreciation | 33.0 | 30.6 | 24.5 | 25.4 | 29.4 | 42.5 | 48.7 | 55.8 | 63.9 | 73.1 |
Depreciation, % | 27.12 | 22.07 | 14.83 | 12.11 | 14.29 | 18.08 | 18.08 | 18.08 | 18.08 | 18.08 |
EBIT | -44.6 | -.1 | 7.0 | 24.7 | 19.4 | -5.3 | -6.1 | -6.9 | -7.9 | -9.1 |
EBIT, % | -36.66 | -0.05398488 | 4.26 | 11.78 | 9.45 | -2.25 | -2.25 | -2.25 | -2.25 | -2.25 |
Total Cash | 23.4 | 65.9 | 114.5 | 92.0 | 40.4 | 93.9 | 107.5 | 123.1 | 141.0 | 161.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 23.0 | 20.2 | 14.6 | 4.4 | 6.6 | 22.4 | 25.6 | 29.4 | 33.6 | 38.5 |
Account Receivables, % | 18.85 | 14.59 | 8.85 | 2.09 | 3.22 | 9.52 | 9.52 | 9.52 | 9.52 | 9.52 |
Inventories | 13.6 | 16.6 | 27.5 | 19.2 | 27.3 | 29.3 | 33.5 | 38.4 | 43.9 | 50.3 |
Inventories, % | 11.16 | 12.02 | 16.63 | 9.13 | 13.27 | 12.44 | 12.44 | 12.44 | 12.44 | 12.44 |
Accounts Payable | 15.7 | 18.3 | 22.1 | 29.7 | 43.8 | 35.3 | 40.4 | 46.3 | 53.0 | 60.7 |
Accounts Payable, % | 12.89 | 13.24 | 13.36 | 14.15 | 21.33 | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 |
Capital Expenditure | -21.8 | -25.5 | -54.1 | -109.7 | -117.8 | -84.0 | -96.2 | -110.2 | -126.2 | -144.5 |
Capital Expenditure, % | -17.91 | -18.44 | -32.72 | -52.21 | -57.33 | -35.72 | -35.72 | -35.72 | -35.72 | -35.72 |
Tax Rate, % | 66.45 | 66.45 | 66.45 | 66.45 | 66.45 | 66.45 | 66.45 | 66.45 | 66.45 | 66.45 |
EBITAT | -48.7 | .1 | 3.3 | 6.2 | 6.5 | -2.2 | -2.5 | -2.8 | -3.3 | -3.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -58.4 | 7.4 | -27.8 | -51.9 | -78.1 | -70.0 | -52.4 | -60.0 | -68.7 | -78.7 |
WACC, % | 13.51 | 13.4 | 13.45 | 13.43 | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 |
PV UFCF | ||||||||||
SUM PV UFCF | -226.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -80 | |||||||||
Terminal Value | -701 | |||||||||
Present Terminal Value | -373 | |||||||||
Enterprise Value | -600 | |||||||||
Net Debt | -26 | |||||||||
Equity Value | -574 | |||||||||
Diluted Shares Outstanding, MM | 198 | |||||||||
Equity Value Per Share | -2.90 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real EXK financials.
- Accurate Data: Historical data and future projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Endeavour Silver Corp.'s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- Comprehensive Silver Market Data: Gain access to detailed historical performance and future outlooks for Endeavour Silver Corp. (EXK).
- Adjustable Financial Assumptions: Modify highlighted inputs such as silver prices, production costs, and growth estimates.
- Real-Time Analytics: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow metrics.
- User-Friendly Interface: Intuitive dashboards and visualizations to easily interpret your investment analysis.
- Suitable for All Levels: A streamlined design tailored for investors, analysts, and industry professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Endeavour Silver Corp. (EXK) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Endeavour Silver Corp. (EXK)'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Endeavour Silver Corp. (EXK)?
- User-Friendly Interface: Perfectly suited for both novice and seasoned users.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate changes in Endeavour Silver's valuation as you modify inputs.
- Preloaded Data: Comes equipped with Endeavour Silver's actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed investment choices.
Who Should Use This Product?
- Investors: Accurately assess Endeavour Silver Corp.’s (EXK) fair value to inform investment choices.
- CFOs: Utilize a high-quality DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily modify the template for client valuation reports specific to (EXK).
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading mining companies.
- Educators: Implement it as a resource to illustrate valuation techniques in the classroom.
What the Template Contains
- Historical Data: Includes Endeavour Silver Corp.'s (EXK) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Endeavour Silver Corp.'s (EXK) 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 Endeavour Silver Corp.'s (EXK) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.