|
Gold Fields Limited (GFI) DCF Valoración
ZA | 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
Gold Fields Limited (GFI) Bundle
Ya sea que sea un inversor o analista, esta calculadora DCF Limited (GFI) de Gold Fields Limited es la herramienta perfecta para una valoración precisa. Precedidos con datos reales de Gold Fields Limited, puede ajustar los pronósticos y ver los efectos en tiempo real.
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).