|
Drdgold Limited (DRD) 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
DRDGOLD Limited (DRD) Bundle
¡Maximice la eficiencia y mejore la precisión con nuestra calculadora DCF (DRD)! Utilizando datos reales de supuestos DrdGold Limited y personalizables, esta herramienta le permite pronosticar, analizar y evaluar (DRD) al igual que un inversor experimentado.
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 | 222.2 | 279.8 | 271.8 | 291.9 | 331.4 | 367.8 | 408.2 | 453.0 | 502.8 | 558.1 |
Revenue Growth, % | 0 | 25.9 | -2.86 | 7.38 | 13.53 | 10.99 | 10.99 | 10.99 | 10.99 | 10.99 |
EBITDA | 66.9 | 109.9 | 94.5 | 103.9 | 114.1 | 128.1 | 142.2 | 157.8 | 175.1 | 194.4 |
EBITDA, % | 30.11 | 39.27 | 34.76 | 35.58 | 34.43 | 34.83 | 34.83 | 34.83 | 34.83 | 34.83 |
Depreciation | 17.1 | 15.8 | 16.6 | 14.0 | 14.4 | 21.0 | 23.3 | 25.9 | 28.8 | 31.9 |
Depreciation, % | 7.71 | 5.64 | 6.11 | 4.8 | 4.33 | 5.72 | 5.72 | 5.72 | 5.72 | 5.72 |
EBIT | 49.8 | 94.1 | 77.9 | 89.8 | 99.7 | 107.1 | 118.8 | 131.9 | 146.4 | 162.5 |
EBIT, % | 22.39 | 33.63 | 28.66 | 30.78 | 30.09 | 29.11 | 29.11 | 29.11 | 29.11 | 29.11 |
Total Cash | 91.1 | 115.8 | 133.6 | 130.6 | 27.7 | 135.8 | 150.7 | 167.3 | 185.6 | 206.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 6.7 | 7.2 | 7.6 | 6.9 | 18.7 | 12.1 | 13.4 | 14.9 | 16.5 | 18.3 |
Account Receivables, % | 3.02 | 2.57 | 2.79 | 2.37 | 5.66 | 3.28 | 3.28 | 3.28 | 3.28 | 3.28 |
Inventories | 17.2 | 18.1 | 20.7 | 22.0 | 24.4 | 27.0 | 29.9 | 33.2 | 36.9 | 40.9 |
Inventories, % | 7.73 | 6.45 | 7.61 | 7.53 | 7.37 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 |
Accounts Payable | 18.5 | 18.7 | 22.8 | 27.9 | 38.3 | 32.7 | 36.3 | 40.3 | 44.7 | 49.7 |
Accounts Payable, % | 8.32 | 6.7 | 8.38 | 9.55 | 11.55 | 8.9 | 8.9 | 8.9 | 8.9 | 8.9 |
Capital Expenditure | -9.6 | -21.0 | -31.0 | -60.8 | -158.6 | -67.6 | -75.1 | -83.3 | -92.5 | -102.6 |
Capital Expenditure, % | -4.33 | -7.51 | -11.41 | -20.84 | -47.85 | -18.39 | -18.39 | -18.39 | -18.39 | -18.39 |
Tax Rate, % | 26.87 | 26.87 | 26.87 | 26.87 | 26.87 | 26.87 | 26.87 | 26.87 | 26.87 | 26.87 |
EBITAT | 32.3 | 69.0 | 60.0 | 68.3 | 72.9 | 78.0 | 86.6 | 96.1 | 106.7 | 118.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 34.4 | 62.7 | 46.6 | 25.9 | -75.2 | 30.0 | 34.2 | 38.0 | 42.1 | 46.8 |
WACC, % | 9.86 | 9.86 | 9.87 | 9.87 | 9.86 | 9.86 | 9.86 | 9.86 | 9.86 | 9.86 |
PV UFCF | ||||||||||
SUM PV UFCF | 142.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 48 | |||||||||
Terminal Value | 606 | |||||||||
Present Terminal Value | 379 | |||||||||
Enterprise Value | 521 | |||||||||
Net Debt | -26 | |||||||||
Equity Value | 547 | |||||||||
Diluted Shares Outstanding, MM | 866 | |||||||||
Equity Value Per Share | 0.63 |
What You Will Receive
- Comprehensive Financial Model: DRDGOLD Limited’s actual data facilitates accurate DCF valuation.
- Complete Forecasting Flexibility: Modify revenue growth, margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates allow you to view results instantly as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for expert-level valuation.
- Adaptable and Repeatable: Designed for versatility, enabling ongoing use for in-depth forecasts.
Key Features
- Comprehensive DRDGOLD Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Assumptions: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow evaluations.
- User-Friendly Dashboard: Clear charts and summaries to help you visualize your valuation outcomes.
- Suitable for All Experience Levels: An intuitive layout designed for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered DRDGOLD Limited (DRD) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for DRDGOLD Limited (DRD)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for DRDGOLD Limited (DRD)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Data Integration: DRDGOLD's historical and projected financials are preloaded for precision.
- Versatile Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Instantly computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Accurately assess DRDGOLD Limited’s (DRD) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial analysis and reporting for DRDGOLD Limited (DRD).
- Consultants: Effortlessly customize the template for valuation reports tailored to DRDGOLD Limited (DRD) clients.
- Entrepreneurs: Obtain insights into financial modeling practices employed by leading mining companies, including DRDGOLD Limited (DRD).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to DRDGOLD Limited (DRD).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for DRDGOLD Limited (DRD).
- Real-World Data: DRDGOLD's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into DRDGOLD's performance.
- Key Ratios: Integrated analysis covering profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.