22nd Century Group, Inc. (XXII) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
22nd Century Group, Inc. (XXII) Bundle
Looking to determine the intrinsic value of 22nd Century Group, Inc.? Our XXII DCF Calculator integrates real-world data with comprehensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 25.8 | 28.1 | 30.9 | 62.1 | 32.2 | 37.9 | 44.6 | 52.5 | 61.8 | 72.7 |
| Revenue Growth, % | 0 | 8.82 | 10.09 | 100.69 | -48.15 | 17.69 | 17.69 | 17.69 | 17.69 | 17.69 |
| EBITDA | -24.9 | -18.1 | -31.0 | -32.9 | -40.4 | -31.3 | -36.9 | -43.4 | -51.1 | -60.1 |
| EBITDA, % | -96.25 | -64.29 | -100.17 | -52.95 | -125.49 | -82.7 | -82.7 | -82.7 | -82.7 | -82.7 |
| Depreciation | 1.6 | 1.5 | 1.5 | 3.6 | 4.9 | 2.9 | 3.4 | 3.9 | 4.6 | 5.5 |
| Depreciation, % | 6.34 | 5.44 | 4.96 | 5.78 | 15.09 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 |
| EBIT | -26.5 | -19.6 | -32.5 | -36.5 | -45.3 | -32.5 | -38.2 | -45.0 | -52.9 | -62.3 |
| EBIT, % | -102.59 | -69.73 | -105.13 | -58.73 | -140.58 | -85.69 | -85.69 | -85.69 | -85.69 | -85.69 |
| Total Cash | 39.0 | 22.3 | 48.7 | 21.2 | 2.1 | 24.3 | 28.5 | 33.6 | 39.5 | 46.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .9 | 2.2 | .6 | 1.4 | 1.7 | 1.5 | 1.8 | 2.1 | 2.5 | 3.0 |
| Account Receivables, % | 3.36 | 7.68 | 1.89 | 2.19 | 5.19 | 4.06 | 4.06 | 4.06 | 4.06 | 4.06 |
| Inventories | 2.3 | 2.0 | 2.9 | 10.0 | 4.3 | 4.2 | 4.9 | 5.8 | 6.8 | 8.0 |
| Inventories, % | 8.77 | 7.24 | 9.31 | 16.11 | 13.5 | 10.99 | 10.99 | 10.99 | 10.99 | 10.99 |
| Accounts Payable | 2.0 | 1.1 | 2.2 | 2.1 | 4.4 | 2.7 | 3.2 | 3.8 | 4.4 | 5.2 |
| Accounts Payable, % | 7.73 | 3.97 | 7.02 | 3.3 | 13.8 | 7.17 | 7.17 | 7.17 | 7.17 | 7.17 |
| Capital Expenditure | -1.1 | -.5 | -1.1 | -4.4 | -5.6 | -2.6 | -3.0 | -3.6 | -4.2 | -5.0 |
| Capital Expenditure, % | -4.23 | -1.86 | -3.46 | -7.13 | -17.44 | -6.82 | -6.82 | -6.82 | -6.82 | -6.82 |
| Tax Rate, % | -157.65 | -157.65 | -157.65 | -157.65 | -157.65 | -157.65 | -157.65 | -157.65 | -157.65 | -157.65 |
| EBITAT | -24.1 | -19.6 | -32.6 | -36.2 | -116.6 | -31.9 | -37.5 | -44.1 | -51.9 | -61.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -24.7 | -20.6 | -30.3 | -45.1 | -109.7 | -33.0 | -37.7 | -44.4 | -52.2 | -61.5 |
| WACC, % | 40.56 | 44.21 | 44.21 | 43.91 | 44.21 | 43.42 | 43.42 | 43.42 | 43.42 | 43.42 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -78.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -63 | |||||||||
| Terminal Value | -151 | |||||||||
| Present Terminal Value | -25 | |||||||||
| Enterprise Value | -104 | |||||||||
| Net Debt | 14 | |||||||||
| Equity Value | -118 | |||||||||
| Diluted Shares Outstanding, MM | 1 | |||||||||
| Equity Value Per Share | -91.25 |
What You Will Get
- Real 22nd Century Group Data: Preloaded financial metrics – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on 22nd Century Group’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Avoid building models from the ground up while ensuring precision and flexibility.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for 22nd Century Group, Inc. (XXII).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for 22nd Century Group, Inc. (XXII).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based XXII DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates the intrinsic value of 22nd Century Group, Inc.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial strategy.
Why Choose This Calculator for 22nd Century Group, Inc. (XXII)?
- Accurate Data: Up-to-date financial information for 22nd Century Group ensures dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of building from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on 22nd Century Group.
- User-Friendly: Easy-to-navigate layout and clear, step-by-step guidance cater to users of all experience levels.
Who Should Use This Product?
- Investors: Evaluate the potential of 22nd Century Group, Inc. (XXII) through detailed financial analysis.
- Students: Explore the intricacies of the biotech sector and learn about regulatory impacts on company valuations.
- Researchers: Utilize data from 22nd Century Group, Inc. (XXII) for studies on tobacco harm reduction and cannabis innovations.
- Analysts: Enhance your analysis with a robust financial model tailored for the unique aspects of the biotech industry.
- Entrepreneurs: Discover strategies used by established companies like 22nd Century Group, Inc. (XXII) to navigate market challenges.
What the Template Contains
- Preloaded XXII 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.