|
A.K.A. Brands Holding Corp. (también conocido como) Valoración de DCF
US | Consumer Cyclical | Specialty Retail | NYSE
|
- ✓ 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
a.k.a. Brands Holding Corp. (AKA) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra (también conocida como) DCF Calculadora! Utilizando datos reales de A.K.A.S. Holding Corp. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (aka) como un inversor experimentado.
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 | 102.4 | 215.9 | 562.2 | 611.7 | 546.3 | 816.8 | 1,221.3 | 1,826.2 | 2,730.7 | 4,083.2 |
| Revenue Growth, % | 0 | 110.77 | 160.37 | 8.81 | -10.7 | 49.53 | 49.53 | 49.53 | 49.53 | 49.53 |
| EBITDA | 9.5 | 28.9 | 27.2 | -143.4 | -66.7 | -13.3 | -19.9 | -29.7 | -44.4 | -66.4 |
| EBITDA, % | 9.29 | 13.39 | 4.84 | -23.45 | -12.2 | -1.63 | -1.63 | -1.63 | -1.63 | -1.63 |
| Depreciation | 6.2 | 6.8 | 23.0 | 30.1 | 19.1 | 35.5 | 53.1 | 79.3 | 118.6 | 177.4 |
| Depreciation, % | 6.08 | 3.13 | 4.08 | 4.92 | 3.5 | 4.34 | 4.34 | 4.34 | 4.34 | 4.34 |
| EBIT | 3.3 | 22.1 | 4.2 | -173.6 | -85.8 | -48.8 | -72.9 | -109.1 | -163.1 | -243.8 |
| EBIT, % | 3.21 | 10.25 | 0.75526 | -28.37 | -15.71 | -5.97 | -5.97 | -5.97 | -5.97 | -5.97 |
| Total Cash | 5.5 | 26.3 | 38.8 | 46.3 | 21.9 | 58.8 | 87.9 | 131.4 | 196.5 | 293.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .4 | 1.2 | 2.7 | 3.2 | 4.8 | 4.6 | 6.9 | 10.3 | 15.4 | 23.0 |
| Account Receivables, % | 0.3895 | 0.5479 | 0.47368 | 0.52817 | 0.87797 | 0.56344 | 0.56344 | 0.56344 | 0.56344 | 0.56344 |
| Inventories | 22.6 | 33.1 | 115.8 | 126.5 | 91.0 | 155.8 | 233.0 | 348.4 | 520.9 | 778.9 |
| Inventories, % | 22.09 | 15.34 | 20.59 | 20.68 | 16.66 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 |
| Accounts Payable | 7.2 | 4.7 | 25.1 | 20.9 | 28.3 | 36.4 | 54.5 | 81.4 | 121.8 | 182.1 |
| Accounts Payable, % | 7.06 | 2.17 | 4.46 | 3.42 | 5.18 | 4.46 | 4.46 | 4.46 | 4.46 | 4.46 |
| Capital Expenditure | -1.4 | -1.8 | -8.6 | -20.0 | -6.0 | -13.2 | -19.8 | -29.6 | -44.2 | -66.1 |
| Capital Expenditure, % | -1.37 | -0.82393 | -1.53 | -3.27 | -1.1 | -1.62 | -1.62 | -1.62 | -1.62 | -1.62 |
| Tax Rate, % | -1.98 | -1.98 | -1.98 | -1.98 | -1.98 | -1.98 | -1.98 | -1.98 | -1.98 | -1.98 |
| EBITAT | 1.9 | 14.7 | 4.9 | -169.8 | -87.5 | -41.1 | -61.4 | -91.8 | -137.2 | -205.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -9.1 | 5.8 | -44.4 | -175.2 | -33.1 | -75.2 | -89.5 | -133.8 | -200.1 | -299.2 |
| WACC, % | 8.56 | 8.86 | 9.96 | 9.89 | 9.96 | 9.45 | 9.45 | 9.45 | 9.45 | 9.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -575.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -305 | |||||||||
| Terminal Value | -4,098 | |||||||||
| Present Terminal Value | -2,609 | |||||||||
| Enterprise Value | -3,185 | |||||||||
| Net Debt | 114 | |||||||||
| Equity Value | -3,299 | |||||||||
| Diluted Shares Outstanding, MM | 11 | |||||||||
| Equity Value Per Share | -308.13 |
What You Will Get
- Editable Forecast Inputs: Effortlessly adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: a.k.a. Brands Holding Corp.’s (AKA) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model designed to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as sales growth, profit margins, and investment expenditures.
- Instant DCF Valuation: Provides real-time calculations for intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages a.k.a. Brands Holding Corp.'s (AKA) actual financial data for dependable valuation results.
- Simplified Scenario Testing: Easily evaluate various assumptions and analyze results side by side.
- Efficiency Booster: Streamline your workflow by avoiding the construction of intricate valuation models from the ground up.
How It Works
- Download the Template: Get instant access to the Excel-based a.k.a. Brands Holding Corp. (AKA) DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates a.k.a. Brands Holding Corp.'s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for a.k.a. Brands Holding Corp. (AKA)?
- Accuracy: Utilizes real financial data for precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Fashion Students: Explore market trends and apply them using real-time data.
- Researchers: Integrate industry models into studies or academic projects.
- Investors: Validate your investment strategies and analyze valuation metrics for a.k.a. Brands Holding Corp. (AKA).
- Market Analysts: Enhance your analysis process with a ready-to-use, customizable financial model.
- Entrepreneurs: Understand how large retail brands like a.k.a. Brands are evaluated in the market.
What the Template Contains
- Pre-Filled Data: Includes a.k.a. Brands Holding 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 a.k.a. Brands Holding 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.