Shoe Carnival, Inc. (SCVL) DCF Valuation

Shoe Carnival, Inc. (SCVL) DCF Valuation
  • Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • Pré-Construídos Para Uso Rápido E Eficiente
  • Não É Necessária Experiência; Fácil De Seguir

Shoe Carnival, Inc. (SCVL) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 0.26279 0.72648 1.06 0.24179 0.22052
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.