Royal Gold, Inc. (RGLD) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 6.04 8.4 8.38 8.7 8.51
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.