Gold Royalty Corp. (GROY) DCF Valuation
- ✓ 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
Gold Royalty Corp. (GROY) Bundle
Gain insights into your Gold Royalty Corp. (GROY) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with accurate GROY data, enabling you to adjust forecasts and assumptions for a precise calculation of Gold Royalty Corp.'s intrinsic value.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|
---|---|---|---|---|---|---|---|---|---|---|
Revenue | .0 | .2 | 3.9 | 3.0 | 3.8 | 4.8 | 6.1 | 7.6 | 9.6 | |
Revenue Growth, % | 0 | 0 | 1954.26 | -22.72 | 25.76 | 25.76 | 25.76 | 25.76 | 25.76 | |
EBITDA | -.1 | -9.9 | -15.6 | -7.8 | -1.9 | -2.4 | -3.0 | -3.8 | -4.8 | |
EBITDA, % | 100 | -5166.97 | -394.73 | -254.66 | -50 | -50 | -50 | -50 | -50 | |
Depreciation | .0 | 2.7 | 1.9 | 1.0 | 2.7 | 3.4 | 4.3 | 5.3 | 6.7 | |
Depreciation, % | 100 | 1386.12 | 47.39 | 33.23 | 70.16 | 70.16 | 70.16 | 70.16 | 70.16 | |
EBIT | -.1 | -12.6 | -17.4 | -8.8 | -1.9 | -2.4 | -3.0 | -3.8 | -4.8 | |
EBIT, % | 100 | -6553.09 | -442.11 | -287.89 | -50 | -50 | -50 | -50 | -50 | |
Total Cash | .0 | 11.0 | 14.2 | 1.8 | 3.4 | 4.3 | 5.4 | 6.8 | 8.6 | |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | |
Account Receivables | .0 | .4 | 1.4 | .9 | 2.6 | 3.2 | 4.0 | 5.1 | 6.4 | |
Account Receivables, % | 100 | 214.44 | 35.8 | 30.54 | 66.59 | 66.59 | 66.59 | 66.59 | 66.59 | |
Inventories | .0 | .0 | .0 | .0 | 1.0 | 1.2 | 1.5 | 1.9 | 2.4 | |
Inventories, % | 100 | 0 | 0.00002535497 | 0 | 25 | 25 | 25 | 25 | 25 | |
Accounts Payable | .1 | 6.9 | 6.1 | 3.8 | 3.8 | 4.8 | 6.1 | 7.6 | 9.6 | |
Accounts Payable, % | 100 | 3585.94 | 154.69 | 124.57 | 100 | 100 | 100 | 100 | 100 | |
Capital Expenditure | .0 | -11.0 | -19.7 | -28.7 | -2.9 | -3.6 | -4.5 | -5.7 | -7.2 | |
Capital Expenditure, % | 100 | -5717.99 | -499.75 | -941.63 | -75 | -75 | -75 | -75 | -75 | |
Tax Rate, % | 19.07 | 19.07 | 19.07 | 19.07 | 19.07 | 19.07 | 19.07 | 19.07 | 19.07 | |
EBITAT | -.1 | -14.6 | -17.4 | -7.1 | -1.8 | -2.3 | -2.9 | -3.6 | -4.6 | |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -.1 | -16.5 | -37.0 | -36.6 | -4.6 | -2.4 | -3.1 | -3.9 | -4.9 | |
WACC, % | 8.37 | 8.37 | 8.37 | 8.2 | 8.32 | 8.32 | 8.32 | 8.32 | 8.32 | |
PV UFCF | ||||||||||
SUM PV UFCF | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | -14.8 | |
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -5 | |||||||||
Terminal Value | -78 | |||||||||
Present Terminal Value | -53 | |||||||||
Enterprise Value | -67 | |||||||||
Net Debt | 32 | |||||||||
Equity Value | -99 | |||||||||
Diluted Shares Outstanding, MM | 145 | |||||||||
Equity Value Per Share | -0.68 |
What You Will Gain
- Comprehensive Financial Model: Gold Royalty Corp.’s (GROY) actual data facilitates accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates allow you to view results instantly as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive Gold Market Data: Gain access to precise historical data and future forecasts tailored for Gold Royalty Corp. (GROY).
- Adjustable Valuation Inputs: Modify highlighted fields such as discount rates, growth forecasts, and profit margins.
- Real-Time Financial Metrics: Instant updates to Discounted Cash Flow (DCF), Net Present Value (NPV), and cash flow metrics.
- Interactive Visualization Tools: User-friendly graphs and summaries to help you interpret your valuation outcomes.
- Designed for All Levels: An accessible and straightforward layout suitable for investors, financial analysts, and consultants.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Gold Royalty Corp.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as gold price assumptions, royalty rates, and operating costs (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and apply them to your investment strategies.
Why Choose Gold Royalty Corp. (GROY)?
- Maximize Returns: Invest in a company focused on delivering high-value gold royalties.
- Expert Management: Our team has extensive experience in the gold sector, ensuring informed decision-making.
- Strong Portfolio: Benefit from a diversified collection of royalty agreements with leading mining companies.
- Transparent Operations: Clear communication and reporting keep you informed about our performance.
- Commitment to Growth: We prioritize strategic acquisitions to enhance shareholder value.
Who Should Use Gold Royalty Corp. (GROY)?
- Investors: Assess Gold Royalty Corp.'s (GROY) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts for GROY.
- Mining Entrepreneurs: Understand how royalty companies like Gold Royalty Corp. (GROY) are appraised.
- Consultants: Create detailed valuation reports for clients interested in mining investments.
- Students and Educators: Utilize GROY's data to enhance learning and teaching of valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Gold Royalty Corp. (GROY) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Gold Royalty Corp. (GROY).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify the analysis of results.