|
Valoración de DCF de IAMGOLD Corporation (IAG)
CA | 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
IAMGOLD Corporation (IAG) Bundle
¡Descubra el verdadero potencial de IAMGOLD Corporation (IAG) con nuestra calculadora DCF avanzada! Sastre los supuestos clave, explore varios escenarios y evalúe cómo las diferentes variables afectan la valoración de IAMGold, todas convenientemente alojadas en 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 | 1,065.3 | 1,241.7 | 1,151.7 | 958.8 | 987.1 | 976.0 | 965.1 | 954.3 | 943.5 | 933.0 |
Revenue Growth, % | 0 | 16.56 | -7.25 | -16.75 | 2.95 | -1.12 | -1.12 | -1.12 | -1.12 | -1.12 |
EBITDA | -36.7 | 392.4 | 214.8 | 273.6 | 315.4 | 209.4 | 207.1 | 204.8 | 202.5 | 200.2 |
EBITDA, % | -3.45 | 31.6 | 18.65 | 28.54 | 31.95 | 21.46 | 21.46 | 21.46 | 21.46 | 21.46 |
Depreciation | 283.7 | 272.1 | 263.7 | 234.4 | 221.7 | 231.0 | 228.4 | 225.9 | 223.3 | 220.8 |
Depreciation, % | 26.64 | 21.91 | 22.89 | 24.45 | 22.46 | 23.67 | 23.67 | 23.67 | 23.67 | 23.67 |
EBIT | -320.5 | 120.3 | -48.9 | 39.2 | 93.7 | -21.6 | -21.3 | -21.1 | -20.9 | -20.6 |
EBIT, % | -30.08 | 9.69 | -4.24 | 4.09 | 9.49 | -2.21 | -2.21 | -2.21 | -2.21 | -2.21 |
Total Cash | 836.7 | 947.5 | 552.5 | 407.8 | 367.1 | 551.5 | 545.4 | 539.2 | 533.2 | 527.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 51.4 | .0 | 47.2 | 83.0 | 67.5 | 47.7 | 47.1 | 46.6 | 46.1 | 45.6 |
Account Receivables, % | 4.82 | 0.0000000805 | 4.1 | 8.66 | 6.83 | 4.88 | 4.88 | 4.88 | 4.88 | 4.88 |
Inventories | 308.5 | 327.3 | 302.1 | 199.9 | 266.3 | 252.5 | 249.7 | 246.9 | 244.1 | 241.4 |
Inventories, % | 28.96 | 26.36 | 26.23 | 20.85 | 26.98 | 25.88 | 25.88 | 25.88 | 25.88 | 25.88 |
Accounts Payable | 211.9 | 244.7 | 304.4 | 294.1 | 317.6 | 251.6 | 248.8 | 246.0 | 243.2 | 240.5 |
Accounts Payable, % | 19.89 | 19.71 | 26.43 | 30.67 | 32.18 | 25.78 | 25.78 | 25.78 | 25.78 | 25.78 |
Capital Expenditure | -274.4 | -317.2 | -655.2 | -780.5 | -907.3 | -549.5 | -543.4 | -537.3 | -531.2 | -525.3 |
Capital Expenditure, % | -25.76 | -25.55 | -56.89 | -81.4 | -91.92 | -56.3 | -56.3 | -56.3 | -56.3 | -56.3 |
Tax Rate, % | 26.44 | 26.44 | 26.44 | 26.44 | 26.44 | 26.44 | 26.44 | 26.44 | 26.44 | 26.44 |
EBITAT | -350.2 | 51.9 | -39.0 | -34.2 | 68.9 | -12.8 | -12.7 | -12.5 | -12.4 | -12.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -488.8 | 72.1 | -392.8 | -524.2 | -644.0 | -363.8 | -327.0 | -323.4 | -319.7 | -316.2 |
WACC, % | 9.54 | 8.84 | 9.29 | 8.31 | 9.21 | 9.04 | 9.04 | 9.04 | 9.04 | 9.04 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,289.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -322 | |||||||||
Terminal Value | -4,583 | |||||||||
Present Terminal Value | -2,973 | |||||||||
Enterprise Value | -4,263 | |||||||||
Net Debt | 585 | |||||||||
Equity Value | -4,848 | |||||||||
Diluted Shares Outstanding, MM | 485 | |||||||||
Equity Value Per Share | -10.00 |
What You Will Get
- Real IAG Financial Data: Pre-filled with IAMGOLD’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 IAMGOLD’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 IAG Financials: Pre-filled historical and projected data for IAMGOLD Corporation (IAG).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate IAMGOLD’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize IAMGOLD’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-built Excel file containing IAMGOLD Corporation’s (IAG) financial data.
- Customize: Modify projections, including gold production estimates, operating costs, and discount rates.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Generate various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for IAMGOLD Corporation (IAG)?
- Designed for Industry Experts: A sophisticated tool utilized by geologists, financial analysts, and investment managers.
- Up-to-Date Data: IAMGOLD’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various mining scenarios and market assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling IAMGOLD Corporation (IAG) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for IAMGOLD Corporation (IAG).
- Consultants: Deliver professional valuation insights on IAMGOLD Corporation (IAG) to clients quickly and accurately.
- Business Owners: Understand how mining companies like IAMGOLD Corporation (IAG) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to IAMGOLD Corporation (IAG).
What the Template Contains
- Historical Data: Includes IAMGOLD Corporation's (IAG) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate IAMGOLD Corporation's (IAG) 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 IAMGOLD Corporation's (IAG) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.