Gold Fields Limited (GFI) DCF Valuation

Gold Fields Limited (GFI) 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

Gold Fields Limited (GFI) 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:

Whether you're an investor or analyst, this Gold Fields Limited (GFI) DCF Calculator is the perfect tool for accurate valuation. Preloaded with real data from Gold Fields Limited, you can adjust forecasts and see the effects in real-time.


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 2,967.1 3,892.1 4,195.2 4,286.7 4,500.7 5,019.8 5,598.8 6,244.6 6,964.8 7,768.1
Revenue Growth, % 0 31.18 7.79 2.18 4.99 11.53 11.53 11.53 11.53 11.53
EBITDA 1,324.7 2,149.3 2,293.6 2,067.6 2,068.5 2,497.2 2,785.2 3,106.5 3,464.8 3,864.4
EBITDA, % 44.65 55.22 54.67 48.23 45.96 49.75 49.75 49.75 49.75 49.75
Depreciation 640.0 688.0 744.5 771.7 795.3 930.3 1,037.6 1,157.3 1,290.8 1,439.7
Depreciation, % 21.57 17.68 17.75 18 17.67 18.53 18.53 18.53 18.53 18.53
EBIT 684.7 1,461.3 1,549.1 1,295.9 1,273.2 1,566.9 1,747.6 1,949.1 2,174.0 2,424.7
EBIT, % 23.08 37.55 36.93 30.23 28.29 31.21 31.21 31.21 31.21 31.21
Total Cash 515.0 886.8 524.7 769.4 648.7 853.5 951.9 1,061.7 1,184.2 1,320.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 94.6 133.7 155.5 207.7 198.5
Account Receivables, % 3.19 3.44 3.71 4.85 4.41
Inventories 417.8 521.6 627.6 759.0 827.9 788.5 879.5 980.9 1,094.1 1,220.3
Inventories, % 14.08 13.4 14.96 17.71 18.39 15.71 15.71 15.71 15.71 15.71
Accounts Payable 138.1 133.4 165.0 133.1 161.8 187.9 209.6 233.7 260.7 290.8
Accounts Payable, % 4.65 3.43 3.93 3.1 3.59 3.74 3.74 3.74 3.74 3.74
Capital Expenditure -612.5 -583.7 -1,088.7 -1,069.3 -1,123.8 -1,119.5 -1,248.6 -1,392.6 -1,553.2 -1,732.4
Capital Expenditure, % -20.64 -15 -25.95 -24.94 -24.97 -22.3 -22.3 -22.3 -22.3 -22.3
Tax Rate, % 41.89 41.89 41.89 41.89 41.89 41.89 41.89 41.89 41.89 41.89
EBITAT 315.9 897.0 952.4 800.6 739.9 905.3 1,009.7 1,126.2 1,256.1 1,400.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -30.9 853.7 512.0 287.5 380.4 783.5 706.8 788.3 879.2 980.6
WACC, % 7.44 7.52 7.52 7.52 7.5 7.5 7.5 7.5 7.5 7.5
PV UFCF
SUM PV UFCF 3,316.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 1,000
Terminal Value 18,186
Present Terminal Value 12,667
Enterprise Value 15,984
Net Debt 1,024
Equity Value 14,960
Diluted Shares Outstanding, MM 895
Equity Value Per Share 16.71

What You Will Get

  • Accurate GFI Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust parameters such as WACC, tax rates, revenue growth, and capital expenditures.
  • Real-Time Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Analysis: Evaluate various scenarios to assess Gold Fields Limited's future performance.
  • User-Friendly Interface: Designed for industry professionals while remaining approachable for newcomers.

Key Features

  • Comprehensive DCF Model: Offers detailed unlevered and levered DCF valuation frameworks tailored for Gold Fields Limited (GFI).
  • WACC Analysis Tool: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
  • Customizable Forecast Inputs: Easily alter growth projections, capital investments, and discount rates.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and operational efficiency ratios specific to Gold Fields Limited (GFI).
  • Interactive Dashboard and Graphs: Visual representations that condense essential valuation metrics for straightforward analysis.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Gold Fields Limited (GFI) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Gold Fields Limited’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Gold Fields Limited (GFI)?

  • Reliable Data: Access up-to-date financial information specific to Gold Fields Limited for accurate valuation.
  • Customizable Inputs: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Efficiency Boost: Built-in calculations save you the hassle of starting from the ground up.
  • Professional-Grade Resource: Ideal for investors, analysts, and consultants focusing on Gold Fields Limited.
  • User-Friendly Interface: Easy-to-navigate design and clear instructions cater to users of all experience levels.

Who Should Use This Product?

  • Investors: Accurately assess Gold Fields Limited’s (GFI) intrinsic value before making investment choices.
  • CFOs: Utilize a high-quality DCF model for financial reporting and strategic analysis related to Gold Fields Limited (GFI).
  • Consultants: Efficiently customize the template for valuation reports tailored to Gold Fields Limited (GFI) clients.
  • Entrepreneurs: Acquire insights into the financial modeling practices employed by leading mining companies like Gold Fields Limited (GFI).
  • Educators: Implement it as a resource for teaching valuation techniques in the context of Gold Fields Limited (GFI).

What the Template Contains

  • Comprehensive DCF Model: Editable template with detailed valuation calculations for Gold Fields Limited (GFI).
  • Real-World Data: Gold Fields Limited’s historical and projected financials preloaded for analysis.
  • Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios for (GFI).
  • Financial Statements: Full annual and quarterly breakdowns for deeper insights into Gold Fields Limited (GFI).
  • Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to (GFI).
  • Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Gold Fields Limited (GFI).