SNDL Inc. (SNDL) DCF Valuation

SNDL Inc. (SNDL) 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

SNDL Inc. (SNDL) 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:

Explore the financial future of SNDL Inc. (SNDL) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of SNDL Inc. (SNDL) and shape your investment approach.


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 52.7 42.3 39.0 494.3 630.9 788.8 986.1 1,232.9 1,541.3 1,926.9
Revenue Growth, % 0 -19.7 -7.86 1168.88 27.63 25.02 25.02 25.02 25.02 25.02
EBITDA -107.7 -125.4 -88.4 -213.0 -68.8 -558.5 -698.2 -872.8 -1,091.2 -1,364.2
EBITDA, % -204.51 -296.62 -226.99 -43.08 -10.91 -70.8 -70.8 -70.8 -70.8 -70.8
Depreciation 6.8 8.0 7.1 32.8 45.1 100.7 125.8 157.3 196.7 245.9
Depreciation, % 12.89 19.01 18.11 6.64 7.14 12.76 12.76 12.76 12.76 12.76
EBIT -114.5 -133.5 -95.5 -245.8 -113.9 -580.2 -725.4 -906.8 -1,133.7 -1,417.4
EBIT, % -217.4 -315.63 -245.1 -49.73 -18.05 -73.56 -73.56 -73.56 -73.56 -73.56
Total Cash 31.5 41.9 450.5 216.4 140.0 512.5 640.7 800.9 1,001.3 1,251.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 19.2 11.0 7.5 15.7 18.8
Account Receivables, % 36.43 26.1 19.36 3.18 2.98
Inventories 51.5 20.2 23.5 91.1 89.9 376.8 471.0 588.9 736.2 920.4
Inventories, % 97.88 47.84 60.42 18.43 14.25 47.76 47.76 47.76 47.76 47.76
Accounts Payable 14.0 3.4 2.9 6.8 15.3 72.3 90.4 113.1 141.4 176.7
Accounts Payable, % 26.66 7.96 7.43 1.37 2.42 9.17 9.17 9.17 9.17 9.17
Capital Expenditure -95.9 -2.2 -2.6 -7.5 -5.5 -180.4 -225.6 -282.0 -352.5 -440.7
Capital Expenditure, % -182.09 -5.21 -6.76 -1.53 -0.8726 -22.87 -22.87 -22.87 -22.87 -22.87
Tax Rate, % -0.37438 -0.37438 -0.37438 -0.37438 -0.37438 -0.37438 -0.37438 -0.37438 -0.37438 -0.37438
EBITAT -112.6 -165.6 -94.6 -241.1 -114.3 -574.9 -718.7 -898.5 -1,123.3 -1,404.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -258.3 -130.9 -90.4 -287.6 -68.1 -1,004.6 -929.4 -1,161.9 -1,452.6 -1,816.0
WACC, % 16.57 16.58 16.57 16.56 16.58 16.57 16.57 16.57 16.57 16.57
PV UFCF
SUM PV UFCF -3,909.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -1,852
Terminal Value -12,709
Present Terminal Value -5,903
Enterprise Value -9,813
Net Debt -19
Equity Value -9,793
Diluted Shares Outstanding, MM 259
Equity Value Per Share -37.76

What You Will Get

  • Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: SNDL Inc.’s financial data pre-loaded to facilitate your analysis.
  • Automatic DCF Outputs: The template automatically calculates Net Present Value (NPV) and intrinsic value for your convenience.
  • Customizable and Professional: A refined Excel model that adjusts to meet your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Pre-Loaded Data: SNDL Inc.'s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Customize WACC, tax rates, revenue growth, and EBITDA margins.
  • Instant Results: View SNDL Inc.'s intrinsic value recalculating in real time.
  • Clear Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
  • Built for Accuracy: A professional tool designed for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered SNDL Inc. (SNDL) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for SNDL Inc.'s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for SNDL Inc. (SNDL)?

  • Designed for Experts: A specialized tool utilized by financial analysts, CFOs, and industry consultants.
  • Accurate Financial Data: SNDL’s historical and projected financial information is preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.

Who Should Use This Product?

  • Investors: Evaluate SNDL Inc.'s valuation before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
  • Startup Founders: Understand the valuation strategies of established companies like SNDL Inc.
  • Consultants: Provide comprehensive valuation analyses and reports for clients.
  • Students and Educators: Utilize current market data to learn and teach valuation principles.

What the Template Contains

  • Preloaded SNDL Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.