High Tide Inc. (HITI) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
High Tide Inc. (HITI) Bundle
Designed for accuracy, our (HITI) DCF Calculator enables you to evaluate High Tide Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for enhanced projections.
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 | 21.7 | 57.8 | 125.6 | 247.5 | 338.3 | 620.5 | 1,138.0 | 2,087.4 | 3,828.7 | 7,022.6 |
Revenue Growth, % | 0 | 166.07 | 117.53 | 97.02 | 36.66 | 83.42 | 83.42 | 83.42 | 83.42 | 83.42 |
EBITDA | -13.7 | 4.2 | 3.3 | -23.3 | -2.9 | -78.6 | -144.1 | -264.4 | -484.9 | -889.4 |
EBITDA, % | -63.05 | 7.35 | 2.66 | -9.43 | -0.86124 | -12.67 | -12.67 | -12.67 | -12.67 | -12.67 |
Depreciation | 1.0 | 4.7 | 16.3 | 20.9 | 22.7 | 50.7 | 92.9 | 170.4 | 312.6 | 573.4 |
Depreciation, % | 4.48 | 8.16 | 13.01 | 8.45 | 6.72 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 |
EBIT | -14.7 | -.5 | -13.0 | -44.3 | -25.6 | -129.2 | -237.1 | -434.8 | -797.5 | -1,462.8 |
EBIT, % | -67.53 | -0.81307 | -10.35 | -17.88 | -7.58 | -20.83 | -20.83 | -20.83 | -20.83 | -20.83 |
Total Cash | .6 | 5.3 | 10.3 | 17.5 | 21.0 | 41.4 | 75.9 | 139.2 | 255.2 | 468.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.5 | 1.9 | 4.5 | 5.5 | 5.3 | 21.9 | 40.2 | 73.8 | 135.3 | 248.2 |
Account Receivables, % | 7.1 | 3.21 | 3.59 | 2.22 | 1.55 | 3.53 | 3.53 | 3.53 | 3.53 | 3.53 |
Inventories | 4.7 | 4.0 | 11.8 | 16.2 | 18.0 | 61.6 | 112.9 | 207.1 | 379.9 | 696.9 |
Inventories, % | 21.47 | 6.85 | 9.41 | 6.56 | 5.33 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 |
Accounts Payable | 3.1 | 4.5 | 6.1 | 5.3 | 5.8 | 37.8 | 69.4 | 127.3 | 233.4 | 428.2 |
Accounts Payable, % | 14.09 | 7.71 | 4.82 | 2.15 | 1.71 | 6.1 | 6.1 | 6.1 | 6.1 | 6.1 |
Capital Expenditure | -7.2 | -1.9 | -7.4 | -6.3 | -4.2 | -57.4 | -105.3 | -193.2 | -354.4 | -650.0 |
Capital Expenditure, % | -33.26 | -3.33 | -5.91 | -2.54 | -1.25 | -9.26 | -9.26 | -9.26 | -9.26 | -9.26 |
Tax Rate, % | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 |
EBITAT | -14.3 | -.5 | -12.7 | -42.5 | -20.7 | -122.1 | -223.9 | -410.7 | -753.3 | -1,381.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -23.7 | 4.1 | -12.7 | -34.0 | -3.3 | -157.0 | -274.4 | -503.4 | -923.2 | -1,693.4 |
WACC, % | 10.33 | 10.4 | 10.34 | 10.29 | 9.85 | 10.24 | 10.24 | 10.24 | 10.24 | 10.24 |
PV UFCF | ||||||||||
SUM PV UFCF | -2,409.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1,727 | |||||||||
Terminal Value | -20,960 | |||||||||
Present Terminal Value | -12,873 | |||||||||
Enterprise Value | -15,282 | |||||||||
Net Debt | 29 | |||||||||
Equity Value | -15,311 | |||||||||
Diluted Shares Outstanding, MM | 74 | |||||||||
Equity Value Per Share | -205.99 |
What You Will Receive
- Comprehensive Financial Model: High Tide Inc.’s (HITI) actual data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Automatic updates provide immediate insights as you adjust parameters.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- 🔍 Real-Life HITI Financials: Pre-filled historical and projected data for High Tide Inc. (HITI).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate High Tide’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize High Tide’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review High Tide Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you adjust your assumptions.
- Step 5: Analyze the outputs and utilize the results for your investment decisions.
Why Choose High Tide Inc. (HITI) Calculator?
- All-in-One Solution: Features DCF, WACC, and comprehensive financial ratio analyses.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes High Tide Inc.'s intrinsic value and Net Present Value.
- Data-Rich: Comes with historical and projected data for precise analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors.
Who Should Use High Tide Inc. (HITI)?
- Investors: Gain insights and make informed decisions with our comprehensive market analysis tools.
- Financial Analysts: Enhance efficiency with our ready-to-use financial models tailored for your needs.
- Consultants: Easily modify our templates for impactful client presentations and strategic reports.
- Cannabis Industry Enthusiasts: Explore in-depth resources to expand your knowledge of the cannabis market.
- Educators and Students: Utilize our materials as a valuable resource in cannabis-related courses.
What the Template Contains
- Pre-Filled DCF Model: High Tide Inc.’s (HITI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate High Tide Inc.’s (HITI) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.