Discounted Cash Flow (DCF) Analysis Levered
At Home Group Inc. (HOME)
$36.99
0.00 (0.00%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
| Revenue | 765.63 | 950.53 | 1,165.90 | 1,365.03 | 1,737.06 | 2,132.86 | 2,618.84 | 3,215.54 | 3,948.22 | 4,847.83 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| Operating Cash Flow | 43.50 | 106.02 | 86.33 | 105.60 | 422.74 | 240.21 | 294.94 | 362.15 | 444.66 | 545.98 |
| Operating Cash Flow (%) | ||||||||||
| Capital Expenditure | -124.27 | -232.70 | -357.52 | -246.76 | -72.29 | -399.34 | -490.33 | -602.05 | -739.23 | -907.66 |
| Capital Expenditure (%) | ||||||||||
| Free Cash Flow | -80.78 | -126.68 | -271.19 | -141.16 | 350.45 | -159.13 | -195.38 | -239.90 | -294.57 | -361.68 |
Weighted Average Cost Of Capital
| Share price | $ 36.99 |
|---|---|
| Beta | 2.520 |
| Diluted Shares Outstanding | 64.43 |
| Cost of Debt | |
| Tax Rate | -40.09 |
| After-tax Cost of Debt | 7.17% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 14.683 |
| Total Debt | 397.50 |
| Total Equity | 2,383.13 |
| Total Capital | 2,780.63 |
| Debt Weighting | 14.30 |
| Equity Weighting | 85.70 |
| Wacc |
Build Up Free Cash Flow
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
| Revenue | 765.63 | 950.53 | 1,165.90 | 1,365.03 | 1,737.06 | 2,132.86 | 2,618.84 | 3,215.54 | 3,948.22 | 4,847.83 |
|---|---|---|---|---|---|---|---|---|---|---|
| Operating Cash Flow | 43.50 | 106.02 | 86.33 | 105.60 | 422.74 | 240.21 | 294.94 | 362.15 | 444.66 | 545.98 |
| Capital Expenditure | -124.27 | -232.70 | -357.52 | -246.76 | -72.29 | -399.34 | -490.33 | -602.05 | -739.23 | -907.66 |
| Free Cash Flow | -80.78 | -126.68 | -271.19 | -141.16 | 350.45 | -159.13 | -195.38 | -239.90 | -294.57 | -361.68 |
| WACC | ||||||||||
| PV LFCF | -140.06 | -151.38 | -163.60 | -176.81 | -191.09 | |||||
| SUM PV LFCF | -822.95 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 13.61 |
| Free cash flow (t + 1) | -368.92 |
| Terminal Value | -3,177.58 |
| Present Value of Terminal Value | -1,678.86 |
Intrinsic Value
| Enterprise Value | -2,501.80 |
|---|---|
| Net Debt | 271.65 |
| Equity Value | -2,773.46 |
| Shares Outstanding | 64.43 |
| Equity Value Per Share | -43.05 |