Coeur Mining, Inc. (CDE) DCF Valuation

Coeur Mining, Inc. (CDE) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Coeur Mining, Inc. (CDE) 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:

Discover the true value of Coeur Mining, Inc. (CDE) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect Coeur Mining, Inc. (CDE) valuation – all within a single Excel template.


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
Account Receivables, % 2.62 2.99 3.89 0.80215 0.4698
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.

No products were found matching.