Discounted Cash Flow (DCF) Analysis Unlevered

Brookdale Senior Living Inc. (BKD)

$2.43

-0.12 (-4.71%)
All numbers are in Millions, Currency in USD
Stock DCF: -7.90 | 2.43 | overvalue

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 4,531.434,057.093,424.452,745.892,744.912,429.852,150.951,904.061,685.521,492.05
Revenue (%)
EBITDA 157.77361.63661.80432.75319.83287.37254.38225.19199.34176.46
EBITDA (%)
EBIT -297.45-21.86296.1587.69-34.061715.0513.3211.7910.44
EBIT (%)
Depreciation 455.21383.49365.65345.06353.89270.37239.34211.86187.55166.02
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 413.12308.79553.32529.42447.53332.75294.55260.75230.82204.32
Total Cash (%)
Account Receivables 133.90133.61109.2251.1455.7664.7957.3550.7744.9439.78
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 95.05104.7271.2376.127158.8952.1346.1540.8536.16
Accounts Payable (%)
Capital Expenditure -225.47-304.09-185.87-176.66-196.92-153.11-135.54-119.98-106.21-94.02
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 2.43
Beta 1.274
Diluted Shares Outstanding 190.46
Cost of Debt
Tax Rate 0.61
After-tax Cost of Debt 4.18%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.513
Total Debt 4,892.73
Total Equity 462.83
Total Capital 5,355.56
Debt Weighting 91.36
Equity Weighting 8.64
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 4,531.434,057.093,424.452,745.892,744.912,429.852,150.951,904.061,685.521,492.05
EBITDA 157.77361.63661.80432.75319.83287.37254.38225.19199.34176.46
EBIT -297.45-21.86296.1587.69-34.061715.0513.3211.7910.44
Tax Rate 8.58%1.05%6.05%7.66%0.61%4.79%4.79%4.79%4.79%4.79%
EBIAT -271.94-21.63278.2480.97-33.8516.1914.3312.6811.239.94
Depreciation 455.21383.49365.65345.06353.89270.37239.34211.86187.55166.02
Accounts Receivable -0.2924.3958.08-4.62-9.037.446.585.835.16
Inventories ----------
Accounts Payable -9.67-33.494.89-5.12-12.11-6.76-5.98-5.30-4.69
Capital Expenditure -225.47-304.09-185.87-176.66-196.92-153.11-135.54-119.98-106.21-94.02
UFCF -42.2067.73448.93312.35113.37112.30118.80105.1793.1082.41
WACC
PV UFCF 107.32108.5091.7977.6565.69
SUM PV UFCF 450.95

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.64
Free cash flow (t + 1) 84.06
Terminal Value 3,184.01
Present Value of Terminal Value 2,537.96

Intrinsic Value

Enterprise Value 2,988.91
Net Debt 4,493.88
Equity Value -1,504.97
Shares Outstanding 190.46
Equity Value Per Share -7.90