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 |