Alamos Gold Inc. (AGI) 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
Alamos Gold Inc. (AGI) Bundle
Engineered for accuracy, our (AGI) DCF Calculator enables you to evaluate Alamos Gold Inc. valuation using real-world financial data and offers complete flexibility to modify all essential parameters for improved 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 | 683.1 | 748.1 | 823.6 | 821.2 | 1,023.3 | 1,135.7 | 1,260.4 | 1,398.8 | 1,552.4 | 1,722.9 |
| Revenue Growth, % | 0 | 9.52 | 10.09 | -0.2914 | 24.61 | 10.98 | 10.98 | 10.98 | 10.98 | 10.98 |
| EBITDA | 288.8 | 387.9 | 176.1 | 321.2 | 486.4 | 459.2 | 509.6 | 565.6 | 627.7 | 696.6 |
| EBITDA, % | 42.28 | 51.85 | 21.39 | 39.11 | 47.53 | 40.43 | 40.43 | 40.43 | 40.43 | 40.43 |
| Depreciation | 171.7 | 163.5 | 171.7 | 168.7 | 190.2 | 243.0 | 269.6 | 299.3 | 332.1 | 368.6 |
| Depreciation, % | 25.14 | 21.86 | 20.84 | 20.55 | 18.59 | 21.39 | 21.39 | 21.39 | 21.39 | 21.39 |
| EBIT | 117.1 | 224.4 | 4.5 | 152.5 | 296.2 | 216.2 | 240.0 | 266.3 | 295.6 | 328.0 |
| EBIT, % | 17.14 | 30 | 0.54157 | 18.57 | 28.95 | 19.04 | 19.04 | 19.04 | 19.04 | 19.04 |
| Total Cash | 205.6 | 264.2 | 196.4 | 148.4 | 237.8 | 296.6 | 329.1 | 365.3 | 405.4 | 449.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 42.0 | 34.7 | .0 | .0 | 53.1 | 36.3 | 40.3 | 44.7 | 49.6 | 55.1 |
| Account Receivables, % | 6.15 | 4.64 | 0 | 0 | 5.19 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 |
| Inventories | 126.9 | 148.5 | 199.0 | 234.2 | 271.2 | 267.1 | 296.5 | 329.0 | 365.2 | 405.3 |
| Inventories, % | 18.58 | 19.85 | 24.16 | 28.52 | 26.5 | 23.52 | 23.52 | 23.52 | 23.52 | 23.52 |
| Accounts Payable | 118.3 | 117.7 | 137.6 | 147.6 | 167.8 | 191.1 | 212.1 | 235.4 | 261.2 | 289.9 |
| Accounts Payable, % | 17.32 | 15.73 | 16.71 | 17.97 | 16.4 | 16.83 | 16.83 | 16.83 | 16.83 | 16.83 |
| Capital Expenditure | -263.6 | -300.9 | -364.3 | -313.7 | -348.9 | -443.7 | -492.4 | -546.5 | -606.5 | -673.1 |
| Capital Expenditure, % | -38.59 | -40.22 | -44.23 | -38.2 | -34.1 | -39.07 | -39.07 | -39.07 | -39.07 | -39.07 |
| Tax Rate, % | 28.5 | 28.5 | 28.5 | 28.5 | 28.5 | 28.5 | 28.5 | 28.5 | 28.5 | 28.5 |
| EBITAT | 87.3 | 148.3 | -129.4 | 55.2 | 211.8 | 107.4 | 119.2 | 132.3 | 146.8 | 162.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -55.2 | -4.0 | -317.9 | -114.9 | -16.8 | -49.1 | -115.9 | -128.6 | -142.8 | -158.4 |
| WACC, % | 9.61 | 9.61 | 9.58 | 9.6 | 9.61 | 9.6 | 9.6 | 9.6 | 9.6 | 9.6 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -438.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -162 | |||||||||
| Terminal Value | -2,126 | |||||||||
| Present Terminal Value | -1,344 | |||||||||
| Enterprise Value | -1,782 | |||||||||
| Net Debt | -225 | |||||||||
| Equity Value | -1,558 | |||||||||
| Diluted Shares Outstanding, MM | 398 | |||||||||
| Equity Value Per Share | -3.91 |
What You Will Get
- Pre-Filled Financial Model: Alamos Gold Inc.’s (AGI) actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you see results immediately as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Authentic Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for Alamos Gold Inc. (AGI).
- Adjustable Forecast Parameters: Modify the highlighted cells for assumptions such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Experience automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Utilize user-friendly charts and summaries to easily interpret your valuation findings.
- Designed for All Levels: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Model: Download and open the Excel file containing Alamos Gold Inc.'s (AGI) financial data.
- 2. Adjust Key Variables: Modify essential inputs such as production estimates, operating costs, and gold prices.
- 3. Analyze Results in Real-Time: The financial model automatically computes intrinsic value and cash flow projections.
- 4. Evaluate Scenarios: Assess various projections to understand different valuation possibilities.
- 5. Make Informed Decisions: Present detailed valuation analyses to guide your investment choices.
Why Choose Alamos Gold Inc. (AGI) Calculator?
- Accuracy: Utilizes real Alamos Gold financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use Alamos Gold Inc. (AGI)?
- Professional Investors: Develop comprehensive and dependable valuation models for mining portfolio analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Alamos Gold Inc. (AGI).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Mining Industry Enthusiasts: Gain insights into how mining companies like Alamos Gold Inc. (AGI) are valued in the financial markets.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Alamos Gold Inc. (AGI) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Alamos Gold Inc. (AGI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.