|
a.k.a. Brands Holding Corp. (AKA) DCF Valuation
US | Consumer Cyclical | Specialty Retail | NYSE
|
- ✓ 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
a.k.a. Brands Holding Corp. (AKA) Bundle
Optimize your time and improve precision with our (AKA) DCF Calculator! Utilizing actual data from a.k.a. Brands Holding Corp. and customizable assumptions, this tool enables you to forecast, analyze, and evaluate (AKA) like a seasoned investor.
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.