American Rebel Holdings, Inc. (AREB) 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
American Rebel Holdings, Inc. (AREB) Bundle
Looking to assess the intrinsic value of American Rebel Holdings, Inc.? Our (AREB) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and make more informed investment choices.
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 | .5 | 1.3 | 1.0 | 8.4 | 16.2 | 27.2 | 45.6 | 76.5 | 128.2 | 215.0 |
Revenue Growth, % | 0 | 134.66 | -21.41 | 756.26 | 92.06 | 67.66 | 67.66 | 67.66 | 67.66 | 67.66 |
EBITDA | -5.9 | -3.6 | -4.0 | -6.4 | -10.6 | -24.0 | -40.2 | -67.4 | -113.1 | -189.5 |
EBITDA, % | -1109.72 | -288.79 | -408.74 | -75.56 | -65.26 | -88.16 | -88.16 | -88.16 | -88.16 | -88.16 |
Depreciation | .1 | .1 | .0 | .1 | .1 | 1.0 | 1.7 | 2.8 | 4.6 | 7.8 |
Depreciation, % | 11.59 | 4.92 | 0.36916 | 0.59276 | 0.64227 | 3.62 | 3.62 | 3.62 | 3.62 | 3.62 |
EBIT | -6.0 | -3.7 | -4.0 | -6.4 | -10.7 | -24.1 | -40.3 | -67.6 | -113.4 | -190.1 |
EBIT, % | -1121.31 | -293.71 | -409.11 | -76.15 | -65.9 | -88.41 | -88.41 | -88.41 | -88.41 | -88.41 |
Total Cash | .1 | .1 | .0 | .4 | 1.1 | 2.3 | 3.9 | 6.5 | 10.9 | 18.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .2 | .2 | .1 | 1.6 | 2.8 | 5.6 | 9.4 | 15.8 | 26.5 | 44.5 |
Account Receivables, % | 42.77 | 14.08 | 10.21 | 19.09 | 17.36 | 20.7 | 20.7 | 20.7 | 20.7 | 20.7 |
Inventories | .8 | .7 | .7 | 7.4 | 6.1 | 19.0 | 31.9 | 53.4 | 89.6 | 150.2 |
Inventories, % | 150.59 | 54.29 | 69.5 | 87.83 | 37.61 | 69.85 | 69.85 | 69.85 | 69.85 | 69.85 |
Accounts Payable | .7 | .5 | 1.0 | 2.2 | 1.9 | 15.3 | 25.6 | 43.0 | 72.0 | 120.8 |
Accounts Payable, % | 127.85 | 43.02 | 104.6 | 26.17 | 11.69 | 56.18 | 56.18 | 56.18 | 56.18 | 56.18 |
Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | -.1 | -.1 |
Capital Expenditure, % | 0 | 0 | 0 | -0.2472 | -0.03882105 | -0.05720443 | -0.05720443 | -0.05720443 | -0.05720443 | -0.05720443 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -7.3 | -5.1 | -5.4 | -7.7 | -10.7 | -24.1 | -40.3 | -67.6 | -113.4 | -190.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -7.6 | -5.0 | -4.8 | -14.7 | -10.8 | -25.4 | -45.0 | -75.5 | -126.6 | -212.2 |
WACC, % | 9.34 | 9.34 | 9.34 | 9.34 | 9.34 | 9.34 | 9.34 | 9.34 | 9.34 | 9.34 |
PV UFCF | ||||||||||
SUM PV UFCF | -343.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -216 | |||||||||
Terminal Value | -2,948 | |||||||||
Present Terminal Value | -1,886 | |||||||||
Enterprise Value | -2,229 | |||||||||
Net Debt | 4 | |||||||||
Equity Value | -2,233 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | -766.82 |
What You Will Get
- Real AREB Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automatic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess American Rebel Holdings' future performance.
- User-Friendly Design: Designed for professionals but easy to navigate for newcomers.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for American Rebel Holdings, Inc. (AREB).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs specific to AREB.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis of AREB.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to American Rebel Holdings, Inc. (AREB).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of AREB.
How It Works
- Step 1: Download the Excel file for American Rebel Holdings, Inc. (AREB).
- Step 2: Review pre-entered data for American Rebel (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for American Rebel’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose the American Rebel Holdings, Inc. (AREB) Calculator?
- Accuracy: Utilizes real American Rebel financial data for precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of creating a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and attention to detail expected at the CFO level.
- User-Friendly: Intuitive interface designed for users of all financial backgrounds.
Who Should Use This Product?
- Investors: Evaluate American Rebel Holdings, Inc.'s (AREB) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for (AREB).
- Startup Founders: Understand the valuation strategies of companies like American Rebel Holdings, Inc. (AREB).
- Consultants: Provide comprehensive valuation analyses and reports for clients interested in (AREB).
- Students and Educators: Utilize real data from American Rebel Holdings, Inc. (AREB) to teach and practice valuation skills.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: American Rebel Holdings, Inc. (AREB)’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables to present clear, actionable results.