Barrick Gold Corporation (GOLD) DCF Valuation

Barrick Gold Corporation (GOLD) 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

Barrick Gold Corporation (GOLD) 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:

Simplify Barrick Gold Corporation (GOLD) valuation with this customizable DCF Calculator! Featuring real Barrick Gold Corporation (GOLD) financials and adjustable forecast inputs, you can test scenarios and uncover Barrick Gold Corporation (GOLD) fair value in minutes.


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
Account Receivables, % 6.84 6.08 7.85 8.23 10.28
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.

No products were found matching.