Equinox Gold Corp. (EQX) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Equinox Gold Corp. (EQX) Bundle
Evaluate Equinox Gold Corp.'s (EQX) financial outlook like an expert! This (EQX) DCF Calculator comes with pre-filled financial data and offers the flexibility to modify revenue growth, WACC, margins, and other critical 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 | 281.7 | 842.5 | 1,082.3 | 952.2 | 1,088.2 | 1,443.8 | 1,915.7 | 2,541.7 | 3,372.4 | 4,474.5 |
| Revenue Growth, % | 0 | 199.08 | 28.46 | -12.02 | 14.28 | 32.68 | 32.68 | 32.68 | 32.68 | 32.68 |
| EBITDA | 95.5 | 232.5 | 338.0 | 131.5 | 291.1 | 384.9 | 510.7 | 677.6 | 899.0 | 1,192.8 |
| EBITDA, % | 33.9 | 27.6 | 31.23 | 13.81 | 26.75 | 26.66 | 26.66 | 26.66 | 26.66 | 26.66 |
| Depreciation | 40.0 | 139.6 | 196.4 | 181.4 | 216.1 | 253.6 | 336.5 | 446.5 | 592.4 | 786.0 |
| Depreciation, % | 14.21 | 16.57 | 18.15 | 19.05 | 19.86 | 17.57 | 17.57 | 17.57 | 17.57 | 17.57 |
| EBIT | 55.5 | 92.9 | 141.6 | -49.8 | 75.0 | 131.3 | 174.2 | 231.1 | 306.6 | 406.8 |
| EBIT, % | 19.69 | 11.03 | 13.08 | -5.23 | 6.89 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 |
| Total Cash | 68.7 | 344.9 | 546.0 | 237.6 | 284.7 | 481.9 | 639.4 | 848.4 | 1,125.7 | 1,493.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 27.4 | 55.9 | 14.2 | 8.2 | 82.3 | 75.3 | 100.0 | 132.6 | 176.0 | 233.5 |
| Account Receivables, % | 9.72 | 6.63 | 1.31 | 0.85907 | 7.56 | 5.22 | 5.22 | 5.22 | 5.22 | 5.22 |
| Inventories | 46.3 | 208.3 | 201.6 | 265.1 | 412.0 | 362.3 | 480.7 | 637.9 | 846.3 | 1,122.9 |
| Inventories, % | 16.42 | 24.72 | 18.63 | 27.84 | 37.86 | 25.1 | 25.1 | 25.1 | 25.1 | 25.1 |
| Accounts Payable | 45.1 | 99.2 | 109.3 | 122.5 | 112.8 | 176.4 | 234.1 | 310.6 | 412.1 | 546.7 |
| Accounts Payable, % | 15.99 | 11.77 | 10.1 | 12.87 | 10.36 | 12.22 | 12.22 | 12.22 | 12.22 | 12.22 |
| Capital Expenditure | -97.6 | -172.9 | -344.2 | -557.1 | -523.3 | -558.9 | -741.6 | -983.9 | -1,305.5 | -1,732.2 |
| Capital Expenditure, % | -34.64 | -20.52 | -31.81 | -58.5 | -48.09 | -38.71 | -38.71 | -38.71 | -38.71 | -38.71 |
| Tax Rate, % | -95.59 | -95.59 | -95.59 | -95.59 | -95.59 | -95.59 | -95.59 | -95.59 | -95.59 | -95.59 |
| EBITAT | 85.5 | 49.9 | 146.9 | -53.7 | 146.6 | 119.1 | 158.0 | 209.7 | 278.2 | 369.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -.6 | -119.8 | 57.5 | -473.6 | -391.3 | -65.9 | -332.4 | -441.1 | -585.2 | -776.4 |
| WACC, % | 8.75 | 7.65 | 8.75 | 8.75 | 8.75 | 8.53 | 8.53 | 8.53 | 8.53 | 8.53 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,625.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -792 | |||||||||
| Terminal Value | -12,128 | |||||||||
| Present Terminal Value | -8,055 | |||||||||
| Enterprise Value | -9,680 | |||||||||
| Net Debt | 753 | |||||||||
| Equity Value | -10,433 | |||||||||
| Diluted Shares Outstanding, MM | 316 | |||||||||
| Equity Value Per Share | -32.99 |
What You Will Get
- Real EQX Financial Data: Pre-filled with Equinox Gold Corp.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Equinox Gold Corp.'s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life EQX Financials: Pre-filled historical and projected data for Equinox Gold Corp.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Equinox Gold’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Equinox Gold’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring Equinox Gold Corp.'s (EQX) financial data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Equinox Gold Corp.'s (EQX) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for Equinox Gold Corp. (EQX)?
- Accurate Data: Up-to-date Equinox Gold financials provide dependable 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 from starting from square one.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the mining sector.
- User-Friendly: Clear design and step-by-step guidance make it accessible for all users.
Who Should Use Equinox Gold Corp. (EQX)?
- Individual Investors: Make informed decisions about buying or selling shares of Equinox Gold Corp. (EQX).
- Financial Analysts: Enhance valuation processes with comprehensive financial models specific to Equinox Gold Corp. (EQX).
- Consultants: Provide clients with expert valuation insights related to Equinox Gold Corp. (EQX) quickly and accurately.
- Mining Industry Professionals: Gain a deeper understanding of how mining companies like Equinox Gold Corp. (EQX) are valued to inform your business strategies.
- Finance Students: Explore valuation methods using real-world data and case studies from Equinox Gold Corp. (EQX).
What the Template Contains
- Historical Data: Includes Equinox Gold Corp.'s (EQX) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Equinox Gold Corp.'s (EQX) 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 Equinox Gold Corp.'s (EQX) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.