Sandstorm Gold Ltd. (SAND) DCF Valuation

Sandstorm Gold Ltd. (SAND) 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

Sandstorm Gold Ltd. (SAND) 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:

Evaluate Sandstorm Gold Ltd.'s (SAND) financial prospects like an expert! This (SAND) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your forecasts.


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 89.4 93.0 114.9 148.7 179.6 214.6 256.3 306.1 365.6 436.6
Revenue Growth, % 0 4.02 23.47 29.49 20.78 19.44 19.44 19.44 19.44 19.44
EBITDA 58.1 63.2 82.4 162.3 167.5 170.7 203.9 243.6 290.9 347.5
EBITDA, % 64.96 67.9 71.77 109.09 93.25 79.57 79.57 79.57 79.57 79.57
Depreciation 39.2 35.4 35.9 57.9 77.3 83.7 99.9 119.4 142.6 170.3
Depreciation, % 43.81 38.04 31.22 38.9 43.04 39 39 39 39 39
EBIT 18.9 27.8 46.6 104.4 90.2 91.0 108.6 129.7 155.0 185.1
EBIT, % 21.14 29.86 40.55 70.19 50.21 42.39 42.39 42.39 42.39 42.39
Total Cash 17.8 115.6 21.2 10.8 33.4 70.4 84.1 100.5 120.0 143.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 7.6 8.0 11.8 21.4 16.0
Account Receivables, % 8.51 8.61 10.24 14.38 8.9
Inventories .0 .0 .0 .0 -.9 -.2 -.2 -.3 -.3 -.4
Inventories, % 0.000001118143 0.00000107498 0.000000871 0 -0.47366 -0.09473062 -0.09473062 -0.09473062 -0.09473062 -0.09473062
Accounts Payable 3.9 3.4 2.2 3.8 5.7 6.7 8.1 9.6 11.5 13.7
Accounts Payable, % 4.32 3.69 1.94 2.56 3.2 3.14 3.14 3.14 3.14 3.14
Capital Expenditure -61.3 -3.5 -152.7 -620.8 -20.9 -121.8 -145.5 -173.8 -207.6 -247.9
Capital Expenditure, % -68.53 -3.74 -132.94 -417.39 -11.66 -56.78 -56.78 -56.78 -56.78 -56.78
Tax Rate, % 16.49 16.49 16.49 16.49 16.49 16.49 16.49 16.49 16.49 16.49
EBITAT 13.5 15.8 28.7 93.2 75.3 66.0 78.8 94.1 112.4 134.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -12.4 46.9 -93.1 -477.8 139.9 22.4 30.3 36.2 43.3 51.7
WACC, % 9.17 8.9 8.99 9.52 9.41 9.2 9.2 9.2 9.2 9.2
PV UFCF
SUM PV UFCF 137.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 53
Terminal Value 732
Present Terminal Value 472
Enterprise Value 609
Net Debt 430
Equity Value 179
Diluted Shares Outstanding, MM 300
Equity Value Per Share 0.60

What You Will Get

  • Pre-Filled Financial Model: Sandstorm Gold Ltd.'s actual data allows for accurate DCF valuation.
  • Full Forecast Control: Modify gold production, operating costs, discount rates, and other essential metrics.
  • Instant Calculations: Automatic updates provide real-time results as you adjust inputs.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
  • Customizable and Reusable: Designed for adaptability, enabling multiple uses for in-depth forecasts.

Key Features

  • Comprehensive Historical Data: Sandstorm Gold Ltd.'s (SAND) past financial statements and pre-filled projections.
  • Customizable Parameters: Adjust factors such as discount rates, tax implications, revenue growth, and profit margins.
  • Real-Time Valuation: Monitor Sandstorm Gold Ltd.'s (SAND) intrinsic value as it updates instantly.
  • Intuitive Visualizations: Dashboard graphs showcase valuation results and essential financial metrics.
  • Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Download the Template: Get instant access to the Excel-based SAND DCF Calculator.
  2. Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically updates Sandstorm Gold Ltd.'s intrinsic value.
  4. Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
  5. Analyze and Decide: Use the results to guide your investment or financial analysis.

Why Choose This Calculator for Sandstorm Gold Ltd. (SAND)?

  • Designed for Investors: A sophisticated tool tailored for analysts, portfolio managers, and gold enthusiasts.
  • Accurate Market Data: Sandstorm Gold's historical and projected financials preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various market conditions and investment strategies.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly Interface: Clear, step-by-step guidance to facilitate your investment decisions.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Sandstorm Gold Ltd. (SAND) shares.
  • Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for the mining sector.
  • Consultants: Provide clients with accurate and timely valuation insights regarding Sandstorm Gold Ltd. (SAND).
  • Mining Industry Professionals: Gain a deeper understanding of gold streaming and its impact on company valuations.
  • Finance Students: Explore valuation methodologies using real-life examples from the mining industry.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Sandstorm Gold Ltd. historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Sandstorm Gold Ltd. (SAND).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.