|
Royal Gold, Inc. (RGLD) DCF Valoración
US | Basic Materials | Gold | NASDAQ
|
- ✓ 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
Royal Gold, Inc. (RGLD) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de Royal Gold, Inc. (RGLD)! Explore datos financieros auténticos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de 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.