Discounted Cash Flow (DCF) Analysis Unlevered

Dime Community Bancshares, Inc. (DCOM)

$17.39

+0.95 (+5.78%)
All numbers are in Millions, Currency in USD
Stock DCF: 1,250.92 | 17.39 | undervalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 159.59180.48399.68418.02611.88895.651,311.021,919.032,809.014,111.73
Revenue (%)
EBITDA 142.7884.15185.61281.47382.23559.49818.961,198.771,754.722,568.50
EBITDA (%)
EBIT 137.7179.18175.18271.28365.43534.90782.961,146.081,677.592,455.59
EBIT (%)
Depreciation 5.084.9710.4310.1916.8024.593652.6977.13112.90
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 706.481,327.191,957.431,119.882,961.044,334.276,344.359,286.6413,593.4619,897.63
Total Cash (%)
Account Receivables -16.5740.1548.5662.9092.08134.78197.28288.77422.70
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable ----------
Accounts Payable (%)
Capital Expenditure -1.72-5.13-7.83-8.19-11.99-17.55-25.69-37.60-55.04-80.57
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 17.39
Beta 1.060
Diluted Shares Outstanding 39.47
Cost of Debt
Tax Rate 28.01
After-tax Cost of Debt 3.07%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.699
Total Debt 1,391.62
Total Equity 686.44
Total Capital 2,078.07
Debt Weighting 66.97
Equity Weighting 33.03
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 159.59180.48399.68418.02611.88895.651,311.021,919.032,809.014,111.73
EBITDA 142.7884.15185.61281.47382.23559.49818.961,198.771,754.722,568.50
EBIT 137.7179.18175.18271.28365.43534.90782.961,146.081,677.592,455.59
Tax Rate 22.78%24.56%29.81%28.01%26.29%26.29%26.29%26.29%26.29%26.29%
EBIAT 106.3459.73122.96195.29269.35394.27577.12844.771,236.541,810.01
Depreciation 5.084.9710.4310.1916.8024.593652.6977.13112.90
Accounts Receivable ---23.58-8.41-14.34-29.17-42.70-62.51-91.49-133.92
Inventories ----------
Accounts Payable ----------
Capital Expenditure -1.72-5.13-7.83-3.75-11.99-17.55-25.69-37.60-55.04-80.57
UFCF 109.6959.58101.97188.88259.82372.14544.73797.361,167.141,708.42
WACC
PV UFCF 259.82354.66494.75690.17962.781,343.06
SUM PV UFCF 3,845.41

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.93
Free cash flow (t + 1) 1,742.59
Terminal Value 59,474.10
Present Value of Terminal Value 46,755.16

Intrinsic Value

Enterprise Value 50,600.57
Net Debt 1,222.33
Equity Value 49,378.24
Shares Outstanding 39.47
Equity Value Per Share 1,250.92