The Buckle, Inc. (BKE) 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
The Buckle, Inc. (BKE) Bundle
Designed for accuracy, our (BKE) DCF Calculator allows you to evaluate The Buckle, Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | 900.3 | 901.3 | 1,294.6 | 1,345.2 | 1,261.1 | 1,391.7 | 1,535.7 | 1,694.7 | 1,870.2 | 2,063.8 |
Revenue Growth, % | 0 | 0.11375 | 43.64 | 3.91 | -6.25 | 10.35 | 10.35 | 10.35 | 10.35 | 10.35 |
EBITDA | 155.3 | 188.9 | 354.2 | 347.0 | 291.9 | 318.7 | 351.7 | 388.1 | 428.3 | 472.6 |
EBITDA, % | 17.25 | 20.96 | 27.36 | 25.79 | 23.15 | 22.9 | 22.9 | 22.9 | 22.9 | 22.9 |
Depreciation | 23.8 | 20.9 | 18.7 | 18.9 | 20.8 | 26.3 | 29.0 | 32.0 | 35.4 | 39.0 |
Depreciation, % | 2.64 | 2.31 | 1.44 | 1.4 | 1.65 | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 |
EBIT | 131.5 | 168.0 | 335.5 | 328.1 | 271.1 | 292.4 | 322.7 | 356.1 | 392.9 | 433.6 |
EBIT, % | 14.61 | 18.64 | 25.92 | 24.39 | 21.49 | 21.01 | 21.01 | 21.01 | 21.01 | 21.01 |
Total Cash | 233.5 | 322.1 | 266.9 | 273.1 | 290.4 | 349.7 | 385.9 | 425.8 | 469.9 | 518.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 3.1 | 2.8 | 12.1 | 12.6 | 8.7 | 9.0 | 9.9 | 10.9 | 12.1 | 13.3 |
Account Receivables, % | 0.34835 | 0.31322 | 0.93364 | 0.94024 | 0.68963 | 0.64502 | 0.64502 | 0.64502 | 0.64502 | 0.64502 |
Inventories | 121.3 | 101.1 | 102.1 | 125.1 | 126.3 | 144.4 | 159.4 | 175.9 | 194.1 | 214.2 |
Inventories, % | 13.47 | 11.21 | 7.89 | 9.3 | 10.01 | 10.38 | 10.38 | 10.38 | 10.38 | 10.38 |
Accounts Payable | 26.5 | 43.4 | 60.0 | 44.8 | 46.0 | 53.9 | 59.5 | 65.6 | 72.4 | 79.9 |
Accounts Payable, % | 2.94 | 4.82 | 4.63 | 3.33 | 3.64 | 3.87 | 3.87 | 3.87 | 3.87 | 3.87 |
Capital Expenditure | -7.3 | -7.7 | -19.1 | -30.4 | -37.3 | -23.2 | -25.6 | -28.3 | -31.2 | -34.5 |
Capital Expenditure, % | -0.81333 | -0.84957 | -1.48 | -2.26 | -2.96 | -1.67 | -1.67 | -1.67 | -1.67 | -1.67 |
Tax Rate, % | 23.96 | 23.96 | 23.96 | 23.96 | 23.96 | 23.96 | 23.96 | 23.96 | 23.96 | 23.96 |
EBITAT | 99.7 | 127.9 | 253.1 | 249.4 | 206.1 | 221.9 | 244.9 | 270.2 | 298.2 | 329.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 18.3 | 178.5 | 259.0 | 199.1 | 193.6 | 214.5 | 238.0 | 262.6 | 289.8 | 319.8 |
WACC, % | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,016.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 321 | |||||||||
Terminal Value | 3,834 | |||||||||
Present Terminal Value | 2,505 | |||||||||
Enterprise Value | 3,521 | |||||||||
Net Debt | 47 | |||||||||
Equity Value | 3,474 | |||||||||
Diluted Shares Outstanding, MM | 50 | |||||||||
Equity Value Per Share | 69.55 |
What You Will Get
- Real Buckle Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for The Buckle, Inc. (BKE).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on The Buckle, Inc.'s (BKE) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections tailored to The Buckle, Inc. (BKE).
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility in your analysis.
Key Features
- Comprehensive DCF Model: Features detailed unlevered and levered DCF valuation frameworks tailored for The Buckle, Inc. (BKE).
- WACC Tool: Pre-configured Weighted Average Cost of Capital calculator with adjustable parameters.
- Customizable Forecast Variables: Adjust growth projections, capital investments, and discount rates as needed.
- Integrated Financial Metrics: Evaluate profitability, leverage, and efficiency ratios specific to The Buckle, Inc. (BKE).
- Visual Dashboard and Graphs: Graphical representations provide a clear overview of essential valuation indicators for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring The Buckle, Inc. (BKE) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the key performance indicators.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the updated results, including The Buckle, Inc.'s (BKE) intrinsic value.
- Step 5: Use the outputs to make well-informed investment choices or create detailed reports.
Why Choose The Buckle, Inc. (BKE) Calculator?
- Accuracy: Utilizes genuine Buckle financial data to ensure precision.
- Flexibility: Allows users the freedom to test and adjust inputs as needed.
- Time-Saving: Eliminate the complexities of creating a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Designed for ease of use, accommodating those without extensive financial modeling skills.
Who Should Use The Buckle, Inc. (BKE) Products?
- Fashion Retail Investors: Make informed decisions with insights from a leading retail brand.
- Market Analysts: Utilize comprehensive data to evaluate trends in the apparel industry.
- Brand Consultants: Adapt our offerings for impactful client presentations or marketing strategies.
- Fashion Enthusiasts: Enhance your knowledge of retail dynamics through practical examples.
- Educators and Students: Employ our resources as a hands-on learning tool in business and fashion courses.
What the Template Contains
- Pre-Filled Data: Features The Buckle, Inc.'s historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate The Buckle, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.