Boot Barn Holdings, Inc. (BOOT) 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
Boot Barn Holdings, Inc. (BOOT) Bundle
Simplify Boot Barn Holdings, Inc. (BOOT) valuation with this customizable DCF Calculator! Featuring real Boot Barn Holdings, Inc. (BOOT) financials and adjustable forecast inputs, you can test scenarios and uncover Boot Barn Holdings, Inc. (BOOT) fair value in minutes.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 845.6 | 893.5 | 1,488.3 | 1,657.6 | 1,667.0 | 2,017.8 | 2,442.5 | 2,956.5 | 3,578.7 | 4,331.8 |
Revenue Growth, % | 0 | 5.67 | 66.57 | 11.38 | 0.56672 | 21.04 | 21.04 | 21.04 | 21.04 | 21.04 |
EBITDA | 126.1 | 145.1 | 325.0 | 315.6 | 249.2 | 351.0 | 424.9 | 514.3 | 622.5 | 753.5 |
EBITDA, % | 14.91 | 16.24 | 21.84 | 19.04 | 14.95 | 17.39 | 17.39 | 17.39 | 17.39 | 17.39 |
Depreciation | 52.5 | 58.4 | 66.6 | 83.8 | 49.6 | 101.9 | 123.3 | 149.3 | 180.7 | 218.7 |
Depreciation, % | 6.21 | 6.53 | 4.48 | 5.06 | 2.97 | 5.05 | 5.05 | 5.05 | 5.05 | 5.05 |
EBIT | 73.6 | 86.7 | 258.4 | 231.8 | 199.6 | 249.1 | 301.5 | 365.0 | 441.8 | 534.8 |
EBIT, % | 8.71 | 9.7 | 17.36 | 13.98 | 11.97 | 12.35 | 12.35 | 12.35 | 12.35 | 12.35 |
Total Cash | 69.6 | 73.1 | 20.7 | 18.2 | 75.8 | 94.6 | 114.6 | 138.7 | 167.8 | 203.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 12.1 | 12.8 | 9.7 | 13.1 | 20.2 | 22.3 | 26.9 | 32.6 | 39.5 | 47.8 |
Account Receivables, % | 1.43 | 1.43 | 0.64922 | 0.79301 | 1.21 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
Inventories | 288.7 | 275.8 | 474.3 | 589.5 | 599.1 | 679.5 | 822.5 | 995.6 | 1,205.2 | 1,458.8 |
Inventories, % | 34.14 | 30.86 | 31.87 | 35.56 | 35.94 | 33.68 | 33.68 | 33.68 | 33.68 | 33.68 |
Accounts Payable | 95.3 | 104.6 | 131.4 | 134.2 | 132.9 | 193.2 | 233.9 | 283.1 | 342.7 | 414.9 |
Accounts Payable, % | 11.27 | 11.71 | 8.83 | 8.1 | 7.97 | 9.58 | 9.58 | 9.58 | 9.58 | 9.58 |
Capital Expenditure | -37.2 | -28.4 | -60.4 | -124.5 | -118.8 | -106.1 | -128.4 | -155.4 | -188.1 | -227.7 |
Capital Expenditure, % | -4.4 | -3.18 | -4.06 | -7.51 | -7.13 | -5.26 | -5.26 | -5.26 | -5.26 | -5.26 |
Tax Rate, % | 25.52 | 25.52 | 25.52 | 25.52 | 25.52 | 25.52 | 25.52 | 25.52 | 25.52 | 25.52 |
EBITAT | 58.5 | 66.6 | 196.9 | 175.0 | 148.7 | 190.6 | 230.7 | 279.2 | 338.0 | 409.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -131.7 | 118.2 | 34.4 | 18.4 | 61.4 | 164.4 | 118.6 | 143.6 | 173.8 | 210.4 |
WACC, % | 13.66 | 13.65 | 13.65 | 13.65 | 13.64 | 13.65 | 13.65 | 13.65 | 13.65 | 13.65 |
PV UFCF | ||||||||||
SUM PV UFCF | 549.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 215 | |||||||||
Terminal Value | 1,842 | |||||||||
Present Terminal Value | 971 | |||||||||
Enterprise Value | 1,521 | |||||||||
Net Debt | 391 | |||||||||
Equity Value | 1,130 | |||||||||
Diluted Shares Outstanding, MM | 31 | |||||||||
Equity Value Per Share | 36.91 |
What You Will Receive
- Pre-Filled Financial Model: Boot Barn Holdings, Inc.'s (BOOT) actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Immediate Calculations: Real-time updates ensure you view results as you implement changes.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Adaptable and Reusable: Designed for versatility, enabling repeated use for in-depth forecasts.
Key Features
- 🔍 Real-Life BOOT Financials: Pre-filled historical and projected data for Boot Barn Holdings, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Boot Barn’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Boot Barn’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for Boot Barn Holdings, Inc. (BOOT).
- Step 2: Review Boot Barn’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Boot Barn Holdings, Inc. (BOOT)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for Boot Barn Holdings.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Boot Barn’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on retail.
Who Should Use This Product?
- Retail Management Students: Understand retail operations and apply concepts using real-world data from Boot Barn Holdings, Inc. (BOOT).
- Academics: Integrate retail industry models into your teaching or research initiatives.
- Investors: Evaluate your investment strategies and analyze valuation metrics for Boot Barn Holdings, Inc. (BOOT).
- Market Analysts: Enhance your analysis with a tailored, ready-to-use financial model focused on retail.
- Entrepreneurs: Discover insights on how successful retail companies like Boot Barn Holdings, Inc. (BOOT) operate and thrive.
What the Template Contains
- Pre-Filled DCF Model: Boot Barn Holdings, Inc.’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Boot Barn’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.