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
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 | 196.6 | 219.3 | 244.6 | 272.8 | 304.3 |
Account Receivables, % | 3.19 | 3.44 | 3.71 | 4.85 | 4.41 | 3.92 | 3.92 | 3.92 | 3.92 | 3.92 |
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
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Gold Fields Limited (GFI) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Gold Fields Limited’s intrinsic value.
- 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).