TRX Gold Corporation (TRX) 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
TRX Gold Corporation (TRX) Bundle
Explore the financial future of TRX Gold Corporation (TRX) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of TRX Gold Corporation (TRX) and inform your investment strategy.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | .0 | .0 | 10.5 | 26.6 | 28.5 | 36.2 | 45.9 | 58.3 | 73.9 | 93.8 |
Revenue Growth, % | 0 | 0 | 0 | 153.88 | 7.41 | 26.85 | 26.85 | 26.85 | 26.85 | 26.85 |
EBITDA | -5.0 | -4.2 | -1.3 | 10.7 | 10.1 | 19.1 | 24.2 | 30.7 | 38.9 | 49.3 |
EBITDA, % | 100 | 100 | -12.65 | 40.31 | 35.49 | 52.63 | 52.63 | 52.63 | 52.63 | 52.63 |
Depreciation | .1 | .2 | .1 | .9 | 1.6 | 15.2 | 19.3 | 24.5 | 31.0 | 39.3 |
Depreciation, % | 100 | 100 | 0.80827 | 3.55 | 5.49 | 41.97 | 41.97 | 41.97 | 41.97 | 41.97 |
EBIT | -5.1 | -4.4 | -1.4 | 9.8 | 8.6 | 18.3 | 23.3 | 29.5 | 37.4 | 47.5 |
EBIT, % | 100 | 100 | -13.46 | 36.75 | 30 | 50.66 | 50.66 | 50.66 | 50.66 | 50.66 |
Total Cash | 2.1 | 9.3 | 5.9 | 5.3 | 5.8 | 21.5 | 27.2 | 34.5 | 43.8 | 55.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .3 | 1.8 | 2.2 | 1.4 | 16.6 | 21.1 | 26.8 | 34.0 | 43.1 |
Account Receivables, % | 100 | 100 | 16.83 | 8.19 | 4.76 | 45.96 | 45.96 | 45.96 | 45.96 | 45.96 |
Inventories | .4 | .8 | 2.5 | 3.4 | 4.3 | 18.3 | 23.2 | 29.4 | 37.3 | 47.3 |
Inventories, % | 100 | 100 | 24.05 | 12.95 | 15.18 | 50.44 | 50.44 | 50.44 | 50.44 | 50.44 |
Accounts Payable | 2.6 | 1.2 | 5.5 | 8.0 | 10.8 | 23.2 | 29.4 | 37.3 | 47.4 | 60.1 |
Accounts Payable, % | 100 | 100 | 52.47 | 30.2 | 37.77 | 64.09 | 64.09 | 64.09 | 64.09 | 64.09 |
Capital Expenditure | -3.9 | -6.3 | -8.8 | -12.3 | -9.5 | -11.9 | -15.0 | -19.1 | -24.2 | -30.7 |
Capital Expenditure, % | 100 | 100 | -84.1 | -46.42 | -33.23 | -32.75 | -32.75 | -32.75 | -32.75 | -32.75 |
Tax Rate, % | 104.55 | 104.55 | 104.55 | 104.55 | 104.55 | 104.55 | 104.55 | 104.55 | 104.55 | 104.55 |
EBITAT | -4.8 | -2.6 | -1.7 | 1.8 | -.4 | 10.0 | 12.6 | 16.0 | 20.3 | 25.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -6.3 | -10.9 | -9.3 | -8.4 | -5.6 | -3.5 | 13.7 | 17.4 | 22.1 | 28.0 |
WACC, % | 6.82 | 6.26 | 6.91 | 5.62 | 5.34 | 6.19 | 6.19 | 6.19 | 6.19 | 6.19 |
PV UFCF | ||||||||||
SUM PV UFCF | 61.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 29 | |||||||||
Terminal Value | 682 | |||||||||
Present Terminal Value | 505 | |||||||||
Enterprise Value | 567 | |||||||||
Net Debt | -5 | |||||||||
Equity Value | 572 | |||||||||
Diluted Shares Outstanding, MM | 291 | |||||||||
Equity Value Per Share | 1.97 |
What You Will Receive
- Comprehensive Financial Model: TRX Gold Corporation’s actual data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, discount rates, and other essential drivers.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, allowing for continual use in detailed forecasting.
Key Features
- 🔍 Real-Life TRX Financials: Pre-filled historical and projected data for TRX Gold Corporation (TRX).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate TRX’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize TRX’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring TRX Gold Corporation’s (TRX) 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 updated results, including TRX Gold Corporation’s (TRX) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for TRX Gold Corporation (TRX)?
- Designed for Investors: An advanced tool tailored for analysts, portfolio managers, and gold enthusiasts.
- Comprehensive Data: TRX's historical and projected financials integrated for precise analysis.
- Flexible Scenario Analysis: Effortlessly test various market conditions and investment strategies.
- Insightful Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Detailed instructions simplify navigation and usage.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and dependable valuation models for analyzing TRX Gold Corporation (TRX).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding TRX Gold Corporation (TRX).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Mining Industry Enthusiasts: Gain insights into how mining companies like TRX Gold Corporation (TRX) are valued in the market.
What the Template Contains
- Pre-Filled Data: Includes TRX Gold Corporation’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze TRX Gold Corporation’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.