Discounted Cash Flow (DCF) Analysis Unlevered
Shoe Carnival, Inc. (SCVL)
$19.64
-1.21 (-5.80%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Actual | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected |
Revenue | 1,029.65 | 1,036.55 | 976.77 | 1,330.39 | 1,262.23 | 1,344.23 | 1,431.55 | 1,524.54 | 1,623.57 | 1,729.03 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
EBITDA | 72.35 | 71.89 | 38.08 | 226.43 | 170.61 | 130.11 | 138.56 | 147.57 | 157.15 | 167.36 |
EBITDA (%) | ||||||||||
EBIT | 50.51 | 54.94 | 21.96 | 207.68 | 147.42 | 106.85 | 113.79 | 121.18 | 129.05 | 137.43 |
EBIT (%) | ||||||||||
Depreciation | 21.84 | 16.95 | 16.11 | 18.75 | 23.20 | 23.26 | 24.78 | 26.39 | 28.10 | 29.92 |
Depreciation (%) |
Balance Sheet Data
Year A/P | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Actual | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected |
Total Cash | 67.02 | 61.90 | 106.53 | 132.40 | 62.97 | 103.04 | 109.74 | 116.87 | 124.46 | 132.54 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 1.22 | 2.72 | 7.10 | 14.16 | 3.05 | 6.49 | 6.91 | 7.36 | 7.84 | 8.35 |
Account Receivables (%) | ||||||||||
Inventories | 257.54 | 259.49 | 233.27 | 285.20 | 390.39 | 339.54 | 361.59 | 385.08 | 410.10 | 436.73 |
Inventories (%) | ||||||||||
Accounts Payable | 48.71 | 60.66 | 57.72 | 69.09 | 78.85 | 75.10 | 79.97 | 85.17 | 90.70 | 96.59 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -7.41 | -18.50 | -12.40 | -31.39 | 3.16 | -15.82 | -16.84 | -17.94 | -19.10 | -20.34 |
Capital Expenditure (%) |
Weighted Average Cost Of Capital
Share price | $ 19.64 |
---|---|
Beta | 1.416 |
Diluted Shares Outstanding | 27.81 |
Cost of Debt | |
Tax Rate | 25.19 |
After-tax Cost of Debt | 0.07% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 10.374 |
Total Debt | 343.23 |
Total Equity | 546.23 |
Total Capital | 889.46 |
Debt Weighting | 38.59 |
Equity Weighting | 61.41 |
Wacc |
Build Up Free Cash
Year A/P | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Actual | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected |
Revenue | 1,029.65 | 1,036.55 | 976.77 | 1,330.39 | 1,262.23 | 1,344.23 | 1,431.55 | 1,524.54 | 1,623.57 | 1,729.03 |
---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 72.35 | 71.89 | 38.08 | 226.43 | 170.61 | 130.11 | 138.56 | 147.57 | 157.15 | 167.36 |
EBIT | 50.51 | 54.94 | 21.96 | 207.68 | 147.42 | 106.85 | 113.79 | 121.18 | 129.05 | 137.43 |
Tax Rate | 24.27% | 21.62% | 25.80% | 25.25% | 25.19% | 24.42% | 24.42% | 24.42% | 24.42% | 24.42% |
EBIAT | 38.25 | 43.06 | 16.30 | 155.24 | 110.29 | 80.75 | 86 | 91.58 | 97.53 | 103.87 |
Depreciation | 21.84 | 16.95 | 16.11 | 18.75 | 23.20 | 23.26 | 24.78 | 26.39 | 28.10 | 29.92 |
Accounts Receivable | - | -1.51 | -4.37 | -7.06 | 11.11 | -3.44 | -0.42 | -0.45 | -0.48 | -0.51 |
Inventories | - | -1.96 | 26.23 | -51.94 | -105.19 | 50.85 | -22.06 | -23.49 | -25.01 | -26.64 |
Accounts Payable | - | 11.95 | -2.95 | 11.37 | 9.76 | -3.75 | 4.88 | 5.20 | 5.53 | 5.89 |
Capital Expenditure | -7.41 | -18.50 | -12.40 | -31.39 | 3.16 | -15.82 | -16.84 | -17.94 | -19.10 | -20.34 |
UFCF | 52.68 | 50 | 38.92 | 94.98 | 52.32 | 131.86 | 76.33 | 81.29 | 86.57 | 92.19 |
WACC | ||||||||||
PV UFCF | 123.93 | 67.42 | 67.48 | 67.55 | 67.61 | |||||
SUM PV UFCF | 393.99 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 6.40 |
Free cash flow (t + 1) | 94.04 |
Terminal Value | 2,137.18 |
Present Value of Terminal Value | 1,567.23 |
Intrinsic Value
Enterprise Value | 1,961.22 |
---|---|
Net Debt | 291.86 |
Equity Value | 1,669.37 |
Shares Outstanding | 27.81 |
Equity Value Per Share | 60.02 |