Shoe Carnival, Inc. (SCVL) 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
Shoe Carnival, Inc. (SCVL) Bundle
Evaluate Shoe Carnival, Inc.'s (SCVL) financial outlook like an expert! This (SCVL) DCF Calculator provides you with pre-loaded financials and the versatility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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 | 1,036.6 | 976.8 | 1,330.4 | 1,262.2 | 1,175.9 | 1,230.2 | 1,287.0 | 1,346.4 | 1,408.6 | 1,473.7 |
Revenue Growth, % | 0 | -5.77 | 36.2 | -5.12 | -6.84 | 4.62 | 4.62 | 4.62 | 4.62 | 4.62 |
EBITDA | 114.2 | 80.1 | 269.4 | 169.6 | 125.2 | 156.4 | 163.6 | 171.2 | 179.1 | 187.3 |
EBITDA, % | 11.02 | 8.2 | 20.25 | 13.44 | 10.65 | 12.71 | 12.71 | 12.71 | 12.71 | 12.71 |
Depreciation | 59.3 | 58.1 | 61.8 | 71.0 | 28.8 | 60.0 | 62.8 | 65.7 | 68.7 | 71.9 |
Depreciation, % | 5.72 | 5.95 | 4.64 | 5.62 | 2.45 | 4.88 | 4.88 | 4.88 | 4.88 | 4.88 |
EBIT | 54.9 | 22.0 | 207.7 | 98.7 | 96.4 | 96.4 | 100.8 | 105.5 | 110.4 | 115.5 |
EBIT, % | 5.3 | 2.25 | 15.61 | 7.82 | 8.2 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 |
Total Cash | 61.9 | 106.5 | 132.4 | 63.0 | 111.2 | 101.6 | 106.3 | 111.2 | 116.3 | 121.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2.7 | 7.1 | 14.2 | 3.1 | 2.6 | 6.2 | 6.5 | 6.8 | 7.1 | 7.4 |
Account Receivables, % | 0.26279 | 0.72648 | 1.06 | 0.24179 | 0.22052 | 0.50317 | 0.50317 | 0.50317 | 0.50317 | 0.50317 |
Inventories | 259.5 | 233.3 | 285.2 | 390.4 | 346.4 | 321.7 | 336.5 | 352.1 | 368.3 | 385.3 |
Inventories, % | 25.03 | 23.88 | 21.44 | 30.93 | 29.46 | 26.15 | 26.15 | 26.15 | 26.15 | 26.15 |
Accounts Payable | 60.7 | 57.7 | 69.1 | 78.9 | 58.3 | 69.3 | 72.5 | 75.8 | 79.3 | 83.0 |
Accounts Payable, % | 5.85 | 5.91 | 5.19 | 6.25 | 4.96 | 5.63 | 5.63 | 5.63 | 5.63 | 5.63 |
Capital Expenditure | -18.5 | -12.4 | -31.4 | -77.3 | -56.3 | -40.2 | -42.0 | -44.0 | -46.0 | -48.1 |
Capital Expenditure, % | -1.78 | -1.27 | -2.36 | -6.12 | -4.79 | -3.26 | -3.26 | -3.26 | -3.26 | -3.26 |
Tax Rate, % | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 |
EBITAT | 43.1 | 16.3 | 155.2 | 73.8 | 73.6 | 73.0 | 76.3 | 79.8 | 83.5 | 87.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -117.7 | 80.9 | 138.0 | -16.8 | 69.9 | 125.0 | 85.1 | 89.1 | 93.2 | 97.5 |
WACC, % | 9.59 | 9.54 | 9.55 | 9.55 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 |
PV UFCF | ||||||||||
SUM PV UFCF | 379.1 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 98 | |||||||||
Terminal Value | 1,082 | |||||||||
Present Terminal Value | 685 | |||||||||
Enterprise Value | 1,064 | |||||||||
Net Debt | 255 | |||||||||
Equity Value | 809 | |||||||||
Diluted Shares Outstanding, MM | 27 | |||||||||
Equity Value Per Share | 29.52 |
What You Will Get
- Real Shoe Carnival Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Shoe Carnival’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- 🔍 Real-Life SCVL Financials: Pre-filled historical and projected data for Shoe Carnival, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Shoe Carnival’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Shoe Carnival’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 prebuilt Excel template featuring Shoe Carnival, Inc. (SCVL) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key metrics.
- Step 3: Modify forecasts and assumptions within the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalibrated results, including Shoe Carnival, Inc. (SCVL)'s intrinsic value.
- Step 5: Utilize the outputs to make informed investment choices or create comprehensive reports.
Why Choose Shoe Carnival, Inc. (SCVL)?
- Wide Selection: Access a diverse range of footwear for the entire family, all in one place.
- Competitive Pricing: Enjoy great deals and discounts that make shopping affordable.
- Convenient Shopping Experience: Shop online or in-store with a seamless and user-friendly interface.
- Quality Assurance: Trust in our commitment to providing high-quality brands and products.
- Customer Satisfaction: Join a community of happy customers who value our exceptional service.
Who Should Use Shoe Carnival, Inc. (SCVL)?
- Shoe Shoppers: Discover a wide selection of footwear at competitive prices.
- Fashion Enthusiasts: Stay updated with the latest trends in shoes and accessories.
- Families: Find stylish and affordable options for every family member.
- Deal Seekers: Take advantage of exclusive promotions and discounts for great savings.
- Retail Analysts: Analyze market trends and consumer behavior in the footwear industry.
What the Template Contains
- Pre-Filled DCF Model: Shoe Carnival, Inc.'s (SCVL) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Shoe Carnival, Inc.'s (SCVL) 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.