Discounted Cash Flow (DCF) Analysis Levered
The Container Store Group, Inc. (TCS)
$7.905
-0.02 (-0.32%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 857.23 | 895.09 | 915.95 | 990.09 | 1,094.12 | 1,163.46 | 1,237.19 | 1,315.59 | 1,398.96 | 1,487.61 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 62.18 | 54.90 | 30.75 | 138.29 | 56.99 | 83.58 | 88.88 | 94.51 | 100.50 | 106.87 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -27.65 | -33.67 | -33.62 | -17.18 | -33.39 | -35.94 | -38.21 | -40.63 | -43.21 | -45.95 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 34.53 | 21.23 | -2.87 | 121.11 | 23.60 | 47.64 | 50.66 | 53.87 | 57.29 | 60.92 |
Weighted Average Cost Of Capital
Share price | $ 7.905 |
---|---|
Beta | 1.346 |
Diluted Shares Outstanding | 50.29 |
Cost of Debt | |
Tax Rate | 27.49 |
After-tax Cost of Debt | 1.74% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 9.246 |
Total Debt | 532.34 |
Total Equity | 397.58 |
Total Capital | 929.91 |
Debt Weighting | 57.25 |
Equity Weighting | 42.75 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 857.23 | 895.09 | 915.95 | 990.09 | 1,094.12 | 1,163.46 | 1,237.19 | 1,315.59 | 1,398.96 | 1,487.61 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 62.18 | 54.90 | 30.75 | 138.29 | 56.99 | 83.58 | 88.88 | 94.51 | 100.50 | 106.87 |
Capital Expenditure | -27.65 | -33.67 | -33.62 | -17.18 | -33.39 | -35.94 | -38.21 | -40.63 | -43.21 | -45.95 |
Free Cash Flow | 34.53 | 21.23 | -2.87 | 121.11 | 23.60 | 47.64 | 50.66 | 53.87 | 57.29 | 60.92 |
WACC | ||||||||||
PV LFCF | 37.42 | 37.91 | 38.42 | 38.92 | 39.44 | |||||
SUM PV LFCF | 233.07 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 4.95 |
Free cash flow (t + 1) | 62.14 |
Terminal Value | 2,106.35 |
Present Value of Terminal Value | 1,654.32 |
Intrinsic Value
Enterprise Value | 1,887.39 |
---|---|
Net Debt | 518.08 |
Equity Value | 1,369.30 |
Shares Outstanding | 50.29 |
Equity Value Per Share | 27.23 |