GrowGeneration Corp. (GRWG) 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
GrowGeneration Corp. (GRWG) Bundle
Unlock GrowGeneration Corp. (GRWG) true value with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect GrowGeneration Corp. (GRWG) valuation – all within a single Excel template.
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 | 79.7 | 193.4 | 422.5 | 278.2 | 225.9 | 308.9 | 422.5 | 577.8 | 790.2 | 1,080.7 |
| Revenue Growth, % | 0 | 142.51 | 118.49 | -34.16 | -18.8 | 36.76 | 36.76 | 36.76 | 36.76 | 36.76 |
| EBITDA | 2.8 | 11.0 | 27.9 | -149.5 | -29.8 | -31.6 | -43.2 | -59.1 | -80.8 | -110.5 |
| EBITDA, % | 3.48 | 5.7 | 6.6 | -53.74 | -13.18 | -10.23 | -10.23 | -10.23 | -10.23 | -10.23 |
| Depreciation | 1.1 | 2.4 | 12.6 | 17.1 | 16.6 | 11.8 | 16.1 | 22.0 | 30.1 | 41.2 |
| Depreciation, % | 1.32 | 1.26 | 2.98 | 6.16 | 7.35 | 3.81 | 3.81 | 3.81 | 3.81 | 3.81 |
| EBIT | 1.7 | 8.6 | 15.3 | -166.6 | -46.4 | -43.4 | -59.3 | -81.1 | -110.9 | -151.7 |
| EBIT, % | 2.16 | 4.44 | 3.61 | -59.9 | -20.53 | -14.04 | -14.04 | -14.04 | -14.04 | -14.04 |
| Total Cash | 13.0 | 177.9 | 81.2 | 71.9 | 65.0 | 112.5 | 153.9 | 210.4 | 287.8 | 393.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.0 | 6.5 | 8.2 | 9.6 | 9.1 | 11.0 | 15.0 | 20.5 | 28.1 | 38.4 |
| Account Receivables, % | 5.01 | 3.37 | 1.94 | 3.43 | 4.02 | 3.55 | 3.55 | 3.55 | 3.55 | 3.55 |
| Inventories | 22.7 | 54.0 | 105.6 | 77.1 | 64.9 | 85.1 | 116.4 | 159.2 | 217.8 | 297.8 |
| Inventories, % | 28.42 | 27.94 | 24.99 | 27.71 | 28.73 | 27.56 | 27.56 | 27.56 | 27.56 | 27.56 |
| Accounts Payable | 6.0 | 14.6 | 17.0 | 15.7 | 11.7 | 18.5 | 25.3 | 34.6 | 47.4 | 64.8 |
| Accounts Payable, % | 7.56 | 7.56 | 4.03 | 5.65 | 5.16 | 5.99 | 5.99 | 5.99 | 5.99 | 5.99 |
| Capital Expenditure | -2.4 | -4.4 | -18.7 | -12.9 | -6.7 | -10.7 | -14.6 | -20.0 | -27.3 | -37.3 |
| Capital Expenditure, % | -2.95 | -2.29 | -4.44 | -4.64 | -2.97 | -3.46 | -3.46 | -3.46 | -3.46 | -3.46 |
| Tax Rate, % | -0.06887052 | -0.06887052 | -0.06887052 | -0.06887052 | -0.06887052 | -0.06887052 | -0.06887052 | -0.06887052 | -0.06887052 | -0.06887052 |
| EBITAT | 1.4 | 5.3 | 12.8 | -163.7 | -46.4 | -36.7 | -50.2 | -68.7 | -93.9 | -128.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -20.6 | -21.9 | -44.1 | -133.7 | -27.9 | -50.9 | -77.2 | -105.6 | -144.4 | -197.5 |
| WACC, % | 14.35 | 14.12 | 14.42 | 14.62 | 14.65 | 14.43 | 14.43 | 14.43 | 14.43 | 14.43 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -358.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -201 | |||||||||
| Terminal Value | -1,620 | |||||||||
| Present Terminal Value | -826 | |||||||||
| Enterprise Value | -1,184 | |||||||||
| Net Debt | 13 | |||||||||
| Equity Value | -1,197 | |||||||||
| Diluted Shares Outstanding, MM | 61 | |||||||||
| Equity Value Per Share | -19.57 |
What You Will Get
- Real GRWG Financial Data: Pre-filled with GrowGeneration’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See GrowGeneration’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life GRWG Financials: Pre-filled historical and projected data for GrowGeneration Corp.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate GrowGeneration’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize GrowGeneration’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based GRWG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates GrowGeneration's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for GrowGeneration Corp. (GRWG)?
- Accurate Data: Utilize real GrowGeneration financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the effort of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the cannabis industry.
- User-Friendly: Easy-to-navigate design and comprehensive instructions cater to users of all experience levels.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing GrowGeneration Corp. (GRWG) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Offer clients precise valuation insights for GrowGeneration Corp. (GRWG) stock.
- Students and Educators: Utilize real-world data to practice and teach financial modeling techniques related to the cannabis industry.
- Industry Enthusiasts: Gain insights into how companies like GrowGeneration Corp. (GRWG) are valued in the burgeoning cannabis market.
What the Template Contains
- Pre-Filled Data: Includes GrowGeneration Corp.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze GrowGeneration Corp.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.