DRDGOLD Limited (DRD) 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
DRDGOLD Limited (DRD) Bundle
Maximize efficiency and improve precision with our (DRD) DCF Calculator! Utilizing real data from DRDGOLD Limited and customizable assumptions, this tool empowers you to forecast, analyze, and assess (DRD) just like a seasoned investor.
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.