Discounted Cash Flow (DCF) Analysis Unlevered
Empire State Realty OP, L.P. (ESBA)
$7.84
0.00 (0.00%)
All numbers are in Millions, Currency in USD
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 | 712.47 | 731.51 | 731.34 | 609.23 | 624.09 | 605.98 | 588.40 | 571.32 | 554.75 | 538.65 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 353.35 | 369.18 | 346.67 | 265 | 289.28 | 287.61 | 279.27 | 271.16 | 263.30 | 255.66 |
| EBITDA (%) | ||||||||||
| EBIT | 192.64 | 200.67 | 165.08 | 73.99 | 79.64 | 123.56 | 119.97 | 116.49 | 113.11 | 109.83 |
| EBIT (%) | ||||||||||
| Depreciation | 160.71 | 168.51 | 181.59 | 191.01 | 209.64 | 164.06 | 159.30 | 154.67 | 150.19 | 145.83 |
| 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 | 464.34 | 604.98 | 233.95 | 526.71 | 423.69 | 405.05 | 393.30 | 381.89 | 370.80 | 360.04 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 206.96 | 230.34 | 246.38 | 191.35 | 196.02 | 190.33 | 184.81 | 179.44 | 174.24 | 169.18 |
| Account Receivables (%) | ||||||||||
| Inventories | - | - | - | - | - | - | - | - | - | - |
| Inventories (%) | ||||||||||
| Accounts Payable | 32.51 | 34.58 | 35.08 | 103.20 | 41.66 | 45.70 | 44.37 | 43.08 | 41.83 | 40.62 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -222.98 | -243.02 | -250.25 | -143.12 | -190.71 | -185.17 | -179.80 | -174.58 | -169.51 | -164.60 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 7.84 |
|---|---|
| Beta | 1.138 |
| Diluted Shares Outstanding | 277.72 |
| Cost of Debt | |
| Tax Rate | 11.85 |
| After-tax Cost of Debt | 3.56% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 9.150 |
| Total Debt | 2,339.26 |
| Total Equity | 2,177.29 |
| Total Capital | 4,516.55 |
| Debt Weighting | 51.79 |
| Equity Weighting | 48.21 |
| 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 | 712.47 | 731.51 | 731.34 | 609.23 | 624.09 | 605.98 | 588.40 | 571.32 | 554.75 | 538.65 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 353.35 | 369.18 | 346.67 | 265 | 289.28 | 287.61 | 279.27 | 271.16 | 263.30 | 255.66 |
| EBIT | 192.64 | 200.67 | 165.08 | 73.99 | 79.64 | 123.56 | 119.97 | 116.49 | 113.11 | 109.83 |
| Tax Rate | 5.95% | 4.51% | 3.82% | 23.35% | 11.85% | 9.90% | 9.90% | 9.90% | 9.90% | 9.90% |
| EBIAT | 181.18 | 191.62 | 158.77 | 56.72 | 70.20 | 111.33 | 108.10 | 104.96 | 101.92 | 98.96 |
| Depreciation | 160.71 | 168.51 | 181.59 | 191.01 | 209.64 | 164.06 | 159.30 | 154.67 | 150.19 | 145.83 |
| Accounts Receivable | - | -23.38 | -16.04 | 55.03 | -4.67 | 5.69 | 5.52 | 5.36 | 5.21 | 5.06 |
| Inventories | - | - | - | - | - | - | - | - | - | - |
| Accounts Payable | - | 2.08 | 0.50 | 68.12 | -61.54 | 4.03 | -1.33 | -1.29 | -1.25 | -1.21 |
| Capital Expenditure | -222.98 | -243.02 | -250.25 | -143.12 | -190.71 | -185.17 | -179.80 | -174.58 | -169.51 | -164.60 |
| UFCF | 118.91 | 95.80 | 74.56 | 227.76 | 22.92 | 99.94 | 91.80 | 89.13 | 86.55 | 84.03 |
| WACC | ||||||||||
| PV UFCF | 94.05 | 81.30 | 74.29 | 67.88 | 62.03 | |||||
| SUM PV UFCF | 379.55 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 6.26 |
| Free cash flow (t + 1) | 85.71 |
| Terminal Value | 2,012.09 |
| Present Value of Terminal Value | 1,485.24 |
Intrinsic Value
| Enterprise Value | 1,864.79 |
|---|---|
| Net Debt | 1,915.56 |
| Equity Value | -50.77 |
| Shares Outstanding | 277.72 |
| Equity Value Per Share | -0.18 |