AngloGold Ashanti Limited (AU) 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
AngloGold Ashanti Limited (AU) Bundle
Evaluate the financial outlook of AngloGold Ashanti Limited (AU) with expert precision! This (AU) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 3,525.0 | 4,595.0 | 4,029.0 | 4,501.0 | 4,582.0 | 4,943.4 | 5,333.4 | 5,754.0 | 6,207.9 | 6,697.6 |
| Revenue Growth, % | 0 | 30.35 | -12.32 | 11.72 | 1.8 | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 |
| EBITDA | 1,170.0 | 2,010.0 | 1,296.0 | 1,365.0 | 1,169.0 | 1,630.7 | 1,759.4 | 1,898.2 | 2,047.9 | 2,209.4 |
| EBITDA, % | 33.19 | 43.74 | 32.17 | 30.33 | 25.51 | 32.99 | 32.99 | 32.99 | 32.99 | 32.99 |
| Depreciation | 602.0 | 576.0 | 477.0 | 637.0 | 472.0 | 651.6 | 703.0 | 758.5 | 818.3 | 882.8 |
| Depreciation, % | 17.08 | 12.54 | 11.84 | 14.15 | 10.3 | 13.18 | 13.18 | 13.18 | 13.18 | 13.18 |
| EBIT | 568.0 | 1,434.0 | 819.0 | 728.0 | 697.0 | 979.1 | 1,056.4 | 1,139.7 | 1,229.6 | 1,326.6 |
| EBIT, % | 16.11 | 31.21 | 20.33 | 16.17 | 15.21 | 19.81 | 19.81 | 19.81 | 19.81 | 19.81 |
| Total Cash | 466.0 | 1,330.0 | 1,154.0 | 1,108.0 | 964.0 | 1,151.4 | 1,242.3 | 1,340.3 | 1,446.0 | 1,560.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 47.0 | 56.0 | 50.0 | 20.0 | 25.0 | 47.3 | 51.0 | 55.0 | 59.4 | 64.1 |
| Account Receivables, % | 1.33 | 1.22 | 1.24 | 0.44435 | 0.54561 | 0.9566 | 0.9566 | 0.9566 | 0.9566 | 0.9566 |
| Inventories | 632.0 | 733.0 | 703.0 | 773.0 | 829.0 | 856.2 | 923.7 | 996.6 | 1,075.2 | 1,160.0 |
| Inventories, % | 17.93 | 15.95 | 17.45 | 17.17 | 18.09 | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 |
| Accounts Payable | 365.0 | 403.0 | 406.0 | 391.0 | 464.0 | 474.7 | 512.2 | 552.6 | 596.2 | 643.2 |
| Accounts Payable, % | 10.35 | 8.77 | 10.08 | 8.69 | 10.13 | 9.6 | 9.6 | 9.6 | 9.6 | 9.6 |
| Capital Expenditure | -709.0 | -756.0 | -1,041.0 | -1,547.0 | -1,042.0 | -1,181.6 | -1,274.8 | -1,375.4 | -1,483.9 | -1,600.9 |
| Capital Expenditure, % | -20.11 | -16.45 | -25.84 | -34.37 | -22.74 | -23.9 | -23.9 | -23.9 | -23.9 | -23.9 |
| Tax Rate, % | 473.02 | 473.02 | 473.02 | 473.02 | 473.02 | 473.02 | 473.02 | 473.02 | 473.02 | 473.02 |
| EBITAT | 334.0 | 889.3 | 529.9 | 359.4 | -2,599.9 | 460.0 | 496.3 | 535.4 | 577.6 | 623.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -87.0 | 637.3 | 4.9 | -605.6 | -3,157.9 | -108.8 | -109.4 | -118.0 | -127.3 | -137.4 |
| WACC, % | 7.96 | 8 | 8.04 | 7.85 | 7.24 | 7.82 | 7.82 | 7.82 | 7.82 | 7.82 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -477.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -140 | |||||||||
| Terminal Value | -2,409 | |||||||||
| Present Terminal Value | -1,653 | |||||||||
| Enterprise Value | -2,131 | |||||||||
| Net Debt | 1,455 | |||||||||
| Equity Value | -3,586 | |||||||||
| Diluted Shares Outstanding, MM | 421 | |||||||||
| Equity Value Per Share | -8.52 |
What You Will Get
- Real AU Financial Data: Pre-filled with AngloGold Ashanti's historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See AngloGold Ashanti's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for AngloGold Ashanti Limited (AU).
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable inputs.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates specific to AngloGold Ashanti Limited (AU).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for AngloGold Ashanti Limited (AU).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring AngloGold Ashanti Limited’s (AU) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including the intrinsic value of AngloGold Ashanti Limited (AU).
- Step 5: Use the outputs to make informed investment decisions or create comprehensive reports.
Why Choose This Calculator for AngloGold Ashanti Limited (AU)?
- Accurate Data: Up-to-date AngloGold Ashanti financials guarantee dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations streamline the process, saving you time and effort.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the mining sector.
- User-Friendly: Clear layout and guided instructions ensure accessibility for all users.
Who Should Use AngloGold Ashanti Limited (AU)?
- Investors: Gain insights into gold mining investments with a leading company in the sector.
- Financial Analysts: Utilize comprehensive reports to analyze market trends and performance metrics.
- Consultants: Tailor presentations and recommendations based on AngloGold Ashanti’s financial data.
- Mining Enthusiasts: Explore the operational strategies and innovations in the gold mining industry.
- Educators and Students: Leverage case studies and real-world applications in mining finance education.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring thorough valuation calculations.
- Real-World Data: AngloGold Ashanti’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.