Royal Gold, Inc. (RGLD) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Royal Gold, Inc. (RGLD) Bundle
Enhance your investment strategies with the Royal Gold, Inc. (RGLD) DCF Calculator! Explore authentic financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Royal Gold, Inc. (RGLD).
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 | 498.8 | 615.9 | 645.2 | 603.2 | 605.7 | 639.2 | 674.6 | 711.9 | 751.3 | 792.9 |
Revenue Growth, % | 0 | 23.46 | 4.76 | -6.5 | 0.41628 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 |
EBITDA | 377.8 | 489.7 | 517.4 | 474.8 | 468.1 | 500.4 | 528.1 | 557.4 | 588.2 | 620.8 |
EBITDA, % | 75.73 | 79.52 | 80.2 | 78.71 | 77.29 | 78.29 | 78.29 | 78.29 | 78.29 | 78.29 |
Depreciation | 163.1 | 163.1 | 189.0 | 183.2 | 191.1 | 192.3 | 202.9 | 214.1 | 226.0 | 238.5 |
Depreciation, % | 32.69 | 26.48 | 29.3 | 30.37 | 31.54 | 30.08 | 30.08 | 30.08 | 30.08 | 30.08 |
EBIT | 214.7 | 326.7 | 328.4 | 291.5 | 277.1 | 308.2 | 325.2 | 343.2 | 362.2 | 382.3 |
EBIT, % | 43.04 | 53.04 | 50.9 | 48.33 | 45.74 | 48.21 | 48.21 | 48.21 | 48.21 | 48.21 |
Total Cash | 319.1 | 225.9 | 143.6 | 118.6 | 104.2 | 204.3 | 215.6 | 227.5 | 240.1 | 253.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 30.1 | 51.8 | 54.1 | 52.5 | 51.6 | 51.2 | 54.0 | 57.0 | 60.2 | 63.5 |
Account Receivables, % | 6.04 | 8.4 | 8.38 | 8.7 | 8.51 | 8.01 | 8.01 | 8.01 | 8.01 | 8.01 |
Inventories | 11.7 | 17.7 | 11.6 | 12.7 | 9.8 | 13.7 | 14.5 | 15.3 | 16.1 | 17.0 |
Inventories, % | 2.34 | 2.87 | 1.8 | 2.1 | 1.62 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 |
Accounts Payable | 2.5 | 6.4 | 6.5 | 6.7 | 11.4 | 7.1 | 7.5 | 7.9 | 8.3 | 8.8 |
Accounts Payable, % | 0.49798 | 1.04 | 1 | 1.11 | 1.89 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
Capital Expenditure | -156.0 | -168.1 | -400.4 | -922.2 | -2.7 | -282.6 | -298.3 | -314.8 | -332.2 | -350.6 |
Capital Expenditure, % | -31.27 | -27.3 | -62.06 | -152.88 | -0.44212 | -44.21 | -44.21 | -44.21 | -44.21 | -44.21 |
Tax Rate, % | 15.13 | 15.13 | 15.13 | 15.13 | 15.13 | 15.13 | 15.13 | 15.13 | 15.13 | 15.13 |
EBITAT | 222.2 | 291.0 | 274.2 | 255.3 | 235.2 | 274.3 | 289.5 | 305.5 | 322.4 | 340.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 190.0 | 262.1 | 66.7 | -482.8 | 432.1 | 176.0 | 190.9 | 201.5 | 212.6 | 224.4 |
WACC, % | 7.64 | 7.6 | 7.58 | 7.59 | 7.58 | 7.6 | 7.6 | 7.6 | 7.6 | 7.6 |
PV UFCF | ||||||||||
SUM PV UFCF | 804.4 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 233 | |||||||||
Terminal Value | 6,484 | |||||||||
Present Terminal Value | 4,496 | |||||||||
Enterprise Value | 5,300 | |||||||||
Net Debt | 147 | |||||||||
Equity Value | 5,153 | |||||||||
Diluted Shares Outstanding, MM | 66 | |||||||||
Equity Value Per Share | 78.38 |
What You Will Get
- Genuine Royal Gold Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Royal Gold, Inc. (RGLD).
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Adjustments: Automatic recalculations to evaluate the effects of changes on Royal Gold’s fair value.
- Flexible Excel Template: Designed for quick edits, scenario analysis, and in-depth projections.
- Efficient and Precise: Avoid the hassle of building models from scratch while ensuring accuracy and adaptability.
Key Features
- Accurate Royal Gold Financials: Access reliable pre-loaded historical data and future forecasts.
- Customizable Valuation Assumptions: Modify highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow projections.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Skill Levels: A straightforward, intuitive layout suitable for investors, CFOs, and consultants.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Royal Gold, Inc.'s (RGLD) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as production forecasts, gold prices, and operating costs.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various projections to assess different valuation scenarios.
- 5. Present with Assurance: Deliver professional valuation analyses to inform your investment decisions.
Why Choose This Calculator for Royal Gold, Inc. (RGLD)?
- Accurate Data: Utilize real Royal Gold financials for dependable valuation outcomes.
- Customizable: Tailor key inputs like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations remove the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the gold sector.
- User-Friendly: Easy-to-navigate design with clear instructions for all users.
Who Should Use This Product?
- Mining Students: Understand valuation methods and apply them to real-world data in the precious metals sector.
- Researchers: Utilize industry-standard models for academic projects or studies related to mining and commodities.
- Investors: Evaluate your investment strategies and assess valuation metrics for Royal Gold, Inc. (RGLD).
- Financial Analysts: Enhance your analysis with a ready-to-use, adaptable DCF model tailored for mining companies.
- Entrepreneurs: Discover how major mining corporations like Royal Gold, Inc. (RGLD) are valued and analyzed in the market.
What the Template Contains
- Historical Data: Includes Royal Gold, Inc.'s (RGLD) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Royal Gold, Inc.'s (RGLD) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Royal Gold, Inc.'s (RGLD) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.