Discounted Cash Flow (DCF) Analysis Unlevered

LL Flooring Holdings, Inc. (LL)

$9.57

-0.13 (-1.34%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 9.57 | undervalue

Operating Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 1,028.931,084.641,092.601,097.701,152.341,185.741,220.111,255.471,291.851,329.29
Revenue (%)
EBITDA -20.82-34.9730.4271.2871.6224.302525.7326.4727.24
EBITDA (%)
EBIT -38.56-53.4012.9553.6452.794.704.844.985.125.27
EBIT (%)
Depreciation 17.7418.4317.4717.6418.8319.6020.1620.7521.3521.97
Depreciation (%)

Balance Sheet Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 19.9411.568.99169.9485.1963.3265.1667.0568.9970.99
Total Cash (%)
Account Receivables 1.301.371.381.381.451.501.541.581.631.68
Account Receivables (%)
Inventories 262.28318.27286.37244.41254.38297.35305.97314.83323.96333.35
Inventories (%)
Accounts Payable 67.6873.4159.8370.5463.4672.9475.0577.2279.4681.77
Accounts Payable (%)
Capital Expenditure -7.41-14.33-19.91-15.83-19.44-16.58-17.06-17.56-18.07-18.59
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 9.57
Beta 2.192
Diluted Shares Outstanding 29.25
Cost of Debt
Tax Rate 21.01
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 13.186
Total Debt 130.22
Total Equity 279.89
Total Capital 410.12
Debt Weighting 31.75
Equity Weighting 68.25
Wacc

Build Up Free Cash

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 1,028.931,084.641,092.601,097.701,152.341,185.741,220.111,255.471,291.851,329.29
EBITDA -20.82-34.9730.4271.2871.6224.302525.7326.4727.24
EBIT -38.56-53.4012.9553.6452.794.704.844.985.125.27
Tax Rate 1.90%-1.83%25.39%-14.52%21.01%6.39%6.39%6.39%6.39%6.39%
EBIAT -37.82-54.389.6661.4341.704.404.534.664.794.93
Depreciation 17.7418.4317.4717.6418.8319.6020.1620.7521.3521.97
Accounts Receivable --0.07-0.01-0.01-0.07-0.04-0.04-0.04-0.05-0.05
Inventories --55.9931.9041.96-9.98-42.96-8.62-8.87-9.12-9.39
Accounts Payable -5.74-13.5910.72-7.089.472.112.182.242.30
Capital Expenditure -7.41-14.33-19.91-15.83-19.44-16.58-17.06-17.56-18.07-18.59
UFCF -27.50-100.6125.53115.9123.96-26.121.081.111.141.18
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -
Free cash flow (t + 1) 1.20
Terminal Value -
Present Value of Terminal Value -

Intrinsic Value

Enterprise Value -
Net Debt 45.03
Equity Value -
Shares Outstanding 29.25
Equity Value Per Share -