Discounted Cash Flow (DCF) Analysis Unlevered
Sleep Country Canada Holdings Inc. (ZZZ.TO)
$26.84
+0.47 (+1.78%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 622.98 | 712.37 | 757.70 | 920.19 | 928.66 | 1,028.67 | 1,139.45 | 1,262.16 | 1,398.09 | 1,548.66 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
EBITDA | 101.37 | 150.15 | 158.44 | 197.97 | 226.87 | 214.38 | 237.47 | 263.05 | 291.37 | 322.75 |
EBITDA (%) | ||||||||||
EBIT | 86.55 | 95.70 | 101.57 | 137.24 | 161.24 | 150.20 | 166.38 | 184.30 | 204.15 | 226.13 |
EBIT (%) | ||||||||||
Depreciation | 14.82 | 54.45 | 56.87 | 60.73 | 65.63 | 64.18 | 71.09 | 78.75 | 87.23 | 96.62 |
Depreciation (%) |
Balance Sheet Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Total Cash | 29.99 | 44.04 | 38.32 | 36.55 | 78.32 | 58.55 | 64.85 | 71.84 | 79.57 | 88.14 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 13.12 | 20.90 | 9.67 | 16.68 | 14.30 | 19.89 | 22.03 | 24.41 | 27.03 | 29.95 |
Account Receivables (%) | ||||||||||
Inventories | 54.73 | 65.36 | 68.72 | 91.54 | 98.69 | 97.94 | 108.49 | 120.17 | 133.11 | 147.45 |
Inventories (%) | ||||||||||
Accounts Payable | 28.53 | 44.30 | 51.41 | 62.21 | 56.11 | 62.52 | 69.25 | 76.71 | 84.97 | 94.12 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -27.17 | -35.45 | -17.66 | -24.12 | -17.22 | -33.22 | -36.79 | -40.75 | -45.14 | -50.01 |
Capital Expenditure (%) |
Weighted Average Cost Of Capital
Share price | $ 26.84 |
---|---|
Beta | 1.551 |
Diluted Shares Outstanding | 37.21 |
Cost of Debt | |
Tax Rate | 24.36 |
After-tax Cost of Debt | 2.83% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 10.930 |
Total Debt | 412.86 |
Total Equity | 998.66 |
Total Capital | 1,411.53 |
Debt Weighting | 29.25 |
Equity Weighting | 70.75 |
Wacc |
Build Up Free Cash
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 622.98 | 712.37 | 757.70 | 920.19 | 928.66 | 1,028.67 | 1,139.45 | 1,262.16 | 1,398.09 | 1,548.66 |
---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 101.37 | 150.15 | 158.44 | 197.97 | 226.87 | 214.38 | 237.47 | 263.05 | 291.37 | 322.75 |
EBIT | 86.55 | 95.70 | 101.57 | 137.24 | 161.24 | 150.20 | 166.38 | 184.30 | 204.15 | 226.13 |
Tax Rate | 27.46% | 28.07% | 24.64% | 27.28% | 24.36% | 26.36% | 26.36% | 26.36% | 26.36% | 26.36% |
EBIAT | 62.78 | 68.84 | 76.54 | 99.80 | 121.97 | 110.61 | 122.52 | 135.71 | 150.33 | 166.52 |
Depreciation | 14.82 | 54.45 | 56.87 | 60.73 | 65.63 | 64.18 | 71.09 | 78.75 | 87.23 | 96.62 |
Accounts Receivable | - | -7.78 | 11.23 | -7.01 | 2.38 | -5.59 | -2.14 | -2.37 | -2.63 | -2.91 |
Inventories | - | -10.63 | -3.36 | -22.82 | -7.15 | 0.75 | -10.55 | -11.68 | -12.94 | -14.34 |
Accounts Payable | - | 15.77 | 7.11 | 10.80 | -6.10 | 6.41 | 6.73 | 7.46 | 8.26 | 9.15 |
Capital Expenditure | -27.17 | -35.45 | -17.66 | -24.12 | -17.22 | -33.22 | -36.79 | -40.75 | -45.14 | -50.01 |
UFCF | 50.43 | 85.20 | 130.75 | 117.36 | 159.50 | 143.14 | 150.86 | 167.11 | 185.11 | 205.04 |
WACC | ||||||||||
PV UFCF | 131.86 | 128.01 | 130.61 | 133.27 | 135.98 | |||||
SUM PV UFCF | 659.74 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 8.56 |
Free cash flow (t + 1) | 209.14 |
Terminal Value | 3,188.12 |
Present Value of Terminal Value | 2,114.39 |
Intrinsic Value
Enterprise Value | 2,774.13 |
---|---|
Net Debt | 334.55 |
Equity Value | 2,439.58 |
Shares Outstanding | 37.21 |
Equity Value Per Share | 65.57 |