Academy Sports and Outdoors, Inc. (ASO) 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
Academy Sports and Outdoors, Inc. (ASO) Bundle
Discover the true value of Academy Sports and Outdoors, Inc. (ASO) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes influence the valuation of Academy Sports and Outdoors, Inc. (ASO) – 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 | 4,829.9 | 5,689.2 | 6,773.1 | 6,395.1 | 6,159.3 | 6,583.9 | 7,037.8 | 7,522.9 | 8,041.6 | 8,595.9 |
Revenue Growth, % | 0 | 17.79 | 19.05 | -5.58 | -3.69 | 6.89 | 6.89 | 6.89 | 6.89 | 6.89 |
EBITDA | 345.8 | 535.0 | 1,005.0 | 971.5 | 788.8 | 782.1 | 836.1 | 893.7 | 955.3 | 1,021.2 |
EBITDA, % | 7.16 | 9.4 | 14.84 | 15.19 | 12.81 | 11.88 | 11.88 | 11.88 | 11.88 | 11.88 |
Depreciation | 121.2 | 119.4 | 99.7 | 106.7 | 110.9 | 125.8 | 134.4 | 143.7 | 153.6 | 164.2 |
Depreciation, % | 2.51 | 2.1 | 1.47 | 1.67 | 1.8 | 1.91 | 1.91 | 1.91 | 1.91 | 1.91 |
EBIT | 224.6 | 415.6 | 905.2 | 864.8 | 677.9 | 656.4 | 701.6 | 750.0 | 801.7 | 857.0 |
EBIT, % | 4.65 | 7.3 | 13.36 | 13.52 | 11.01 | 9.97 | 9.97 | 9.97 | 9.97 | 9.97 |
Total Cash | 149.4 | 377.6 | 486.0 | 337.1 | 347.9 | 366.4 | 391.7 | 418.7 | 447.5 | 478.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 14.0 | 17.3 | 19.7 | 16.5 | 19.4 | 19.2 | 20.5 | 21.9 | 23.4 | 25.1 |
Account Receivables, % | 0.28984 | 0.30419 | 0.29112 | 0.25806 | 0.3145 | 0.29154 | 0.29154 | 0.29154 | 0.29154 | 0.29154 |
Inventories | 1,099.7 | 990.0 | 1,171.8 | 1,283.5 | 1,194.2 | 1,276.4 | 1,364.4 | 1,458.4 | 1,558.9 | 1,666.4 |
Inventories, % | 22.77 | 17.4 | 17.3 | 20.07 | 19.39 | 19.39 | 19.39 | 19.39 | 19.39 | 19.39 |
Accounts Payable | 428.8 | 791.4 | 737.8 | 686.5 | 541.1 | 700.5 | 748.8 | 800.5 | 855.6 | 914.6 |
Accounts Payable, % | 8.88 | 13.91 | 10.89 | 10.73 | 8.78 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 |
Capital Expenditure | -62.8 | -41.3 | -76.0 | -108.8 | -208.3 | -108.4 | -115.9 | -123.8 | -132.4 | -141.5 |
Capital Expenditure, % | -1.3 | -0.72539 | -1.12 | -1.7 | -3.38 | -1.65 | -1.65 | -1.65 | -1.65 | -1.65 |
Tax Rate, % | 21.71 | 21.71 | 21.71 | 21.71 | 21.71 | 21.71 | 21.71 | 21.71 | 21.71 | 21.71 |
EBITAT | 219.4 | 378.4 | 707.0 | 663.6 | 530.7 | 553.8 | 592.0 | 632.8 | 676.5 | 723.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -407.1 | 925.5 | 493.0 | 501.7 | 374.4 | 648.7 | 569.6 | 608.8 | 650.8 | 695.7 |
WACC, % | 9.16 | 9.08 | 8.92 | 8.91 | 8.93 | 9 | 9 | 9 | 9 | 9 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,457.9 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 699 | |||||||||
Terminal Value | 8,226 | |||||||||
Present Terminal Value | 5,347 | |||||||||
Enterprise Value | 7,805 | |||||||||
Net Debt | 1,349 | |||||||||
Equity Value | 6,456 | |||||||||
Diluted Shares Outstanding, MM | 77 | |||||||||
Equity Value Per Share | 83.34 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real ASO financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Academy Sports and Outdoors' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Pre-Loaded Data: Academy Sports and Outdoors' historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Observe Academy Sports and Outdoors' intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and key metrics effectively.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Academy Sports and Outdoors, Inc. (ASO) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Academy Sports and Outdoors, Inc.'s (ASO) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Academy Sports and Outdoors, Inc. (ASO)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for ASO.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Academy Sports and Outdoors' intrinsic value and Net Present Value.
- Integrated Data: Features historical and projected data for precise evaluations.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focused on ASO.
Who Should Use This Product?
- Investors: Accurately assess Academy Sports and Outdoors, Inc.'s (ASO) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to client needs.
- Entrepreneurs: Acquire insights into the financial modeling practices of leading retail companies.
- Educators: Employ it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Academy Sports and Outdoors, Inc. (ASO) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Academy Sports and Outdoors, Inc. (ASO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.