|
Valoración de DCF de Barrick Gold Corporation (Gold)
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
Barrick Gold Corporation (GOLD) Bundle
¡Simplifique la valoración de Barrick Gold Corporation (Gold) con esta calculadora DCF personalizable! Con el Real Barrick Gold Corporation (Gold) Financials y los aportes de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Barrick Gold Corporation (Gold) 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 | 9,717.0 | 12,595.0 | 11,985.0 | 11,013.0 | 11,397.0 | 11,971.2 | 12,574.3 | 13,207.7 | 13,873.1 | 14,572.1 |
Revenue Growth, % | 0 | 29.62 | -4.84 | -8.11 | 3.49 | 5.04 | 5.04 | 5.04 | 5.04 | 5.04 |
EBITDA | 7,105.0 | 7,725.6 | 6,649.0 | 3,699.4 | 5,158.9 | 6,435.5 | 6,759.7 | 7,100.3 | 7,458.0 | 7,833.7 |
EBITDA, % | 73.12 | 61.34 | 55.48 | 33.59 | 45.27 | 53.76 | 53.76 | 53.76 | 53.76 | 53.76 |
Depreciation | 2,161.1 | 2,462.6 | 2,148.9 | 2,000.5 | 2,169.1 | 2,320.5 | 2,437.4 | 2,560.2 | 2,689.1 | 2,824.6 |
Depreciation, % | 22.24 | 19.55 | 17.93 | 18.16 | 19.03 | 19.38 | 19.38 | 19.38 | 19.38 | 19.38 |
EBIT | 4,943.9 | 5,263.1 | 4,500.1 | 1,698.9 | 2,989.8 | 4,115.0 | 4,322.4 | 4,540.1 | 4,768.8 | 5,009.1 |
EBIT, % | 50.88 | 41.79 | 37.55 | 15.43 | 26.23 | 34.37 | 34.37 | 34.37 | 34.37 | 34.37 |
Total Cash | 3,314.0 | 5,188.0 | 5,280.0 | 4,440.0 | 4,148.0 | 4,694.2 | 4,930.7 | 5,179.1 | 5,440.0 | 5,714.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 665.0 | 766.0 | 940.7 | 906.0 | 1,172.0 | 940.6 | 987.9 | 1,037.7 | 1,090.0 | 1,144.9 |
Account Receivables, % | 6.84 | 6.08 | 7.85 | 8.23 | 10.28 | 7.86 | 7.86 | 7.86 | 7.86 | 7.86 |
Inventories | 2,289.0 | 1,878.0 | 1,734.0 | 1,781.0 | 1,782.0 | 2,028.9 | 2,131.2 | 2,238.5 | 2,351.3 | 2,469.8 |
Inventories, % | 23.56 | 14.91 | 14.47 | 16.17 | 15.64 | 16.95 | 16.95 | 16.95 | 16.95 | 16.95 |
Accounts Payable | 715.0 | 929.0 | 539.0 | 741.0 | 678.0 | 764.0 | 802.5 | 842.9 | 885.4 | 930.0 |
Accounts Payable, % | 7.36 | 7.38 | 4.5 | 6.73 | 5.95 | 6.38 | 6.38 | 6.38 | 6.38 | 6.38 |
Capital Expenditure | -1,701.0 | -2,054.0 | -2,435.0 | -3,049.0 | -3,086.0 | -2,607.2 | -2,738.5 | -2,876.5 | -3,021.4 | -3,173.6 |
Capital Expenditure, % | -17.51 | -16.31 | -20.32 | -27.69 | -27.08 | -21.78 | -21.78 | -21.78 | -21.78 | -21.78 |
Tax Rate, % | 54.8 | 54.8 | 54.8 | 54.8 | 54.8 | 54.8 | 54.8 | 54.8 | 54.8 | 54.8 |
EBITAT | 3,086.7 | 3,845.7 | 3,194.3 | 436.6 | 1,351.5 | 2,282.9 | 2,398.0 | 2,518.8 | 2,645.7 | 2,778.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 1,307.8 | 4,778.2 | 2,487.5 | -422.2 | 104.6 | 2,066.7 | 1,985.7 | 2,085.7 | 2,190.8 | 2,301.2 |
WACC, % | 6.31 | 6.43 | 6.4 | 5.92 | 6.13 | 6.24 | 6.24 | 6.24 | 6.24 | 6.24 |
PV UFCF | ||||||||||
SUM PV UFCF | 8,864.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 2,347 | |||||||||
Terminal Value | 55,394 | |||||||||
Present Terminal Value | 40,933 | |||||||||
Enterprise Value | 49,798 | |||||||||
Net Debt | 1,075 | |||||||||
Equity Value | 48,723 | |||||||||
Diluted Shares Outstanding, MM | 1,755 | |||||||||
Equity Value Per Share | 27.76 |
What You Will Get
- Comprehensive GOLD Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, production costs, and capital investments.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Barrick Gold’s future prospects.
- User-Friendly Interface: Designed for experts while remaining approachable for novices.
Key Features
- Customizable Mining Metrics: Adjust essential parameters like gold prices, production costs, and resource estimates.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other financial metrics in real-time.
- Industry-Leading Precision: Leverages Barrick Gold's actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Easily test various market conditions and evaluate their impacts.
- Efficiency Booster: Remove the complexity of developing intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Barrick Gold Corporation’s (GOLD) financial data.
- 2. Modify Inputs: Adjust essential parameters such as production forecasts, gold prices, and operating costs.
- 3. Analyze Results Immediately: The DCF model automatically computes the intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate different forecasts to assess various valuation scenarios.
- 5. Present with Assurance: Deliver expert valuation analyses to bolster your investment strategies.
Why Choose This Calculator for Barrick Gold Corporation (GOLD)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses tailored for mining investments.
- Customizable Inputs: Modify yellow-highlighted cells to evaluate different market scenarios.
- Detailed Insights: Automatically computes Barrick Gold's intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable benchmarks for analysis.
- Professional Quality: Perfect for financial analysts, investors, and mining industry consultants.
Who Should Use Barrick Gold Corporation (GOLD)?
- Investors: Gain insights into gold market trends and make informed investment choices.
- Financial Analysts: Utilize comprehensive reports to enhance your analysis of mining operations.
- Consultants: Customize data presentations for clients in the natural resources sector.
- Mining Enthusiasts: Explore the intricacies of gold production and its impact on global markets.
- Educators and Students: Leverage real-world case studies to enrich finance and geology curricula.
What the Template Contains
- Pre-Filled Data: Includes Barrick Gold Corporation’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Barrick Gold Corporation’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.