Discounted Cash Flow (DCF) Analysis Unlevered

United Bankshares, Inc. (UBSI)

$34.01

+1.30 (+3.97%)
All numbers are in Millions, Currency in USD
Stock DCF: 105.35 | 34.01 | undervalue

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 712.62726.531,031.121,006.871,031.611,145.041,270.941,410.691,565.801,737.96
Revenue (%)
EBITDA 435.17488.55451.91523.15591.33644.47715.33793.98881.28978.18
EBITDA (%)
EBIT 456.24509.08468.35515.24567.66654.30726.24806.10894.73993.11
EBIT (%)
Depreciation -21.06-20.53-16.447.9123.67-9.84-10.92-12.12-13.45-14.93
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 3,356.633,273.975,161.607,799.945,718.586,300.576,993.347,762.288,615.779,563.10
Total Cash (%)
Account Receivables 60.6058.0866.8364.5194.8988.3698.08108.86120.83134.12
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable ----------
Accounts Payable (%)
Capital Expenditure -5.78-11.08-19.03-15.38-14.72-16.34-18.14-20.13-22.35-24.80
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 34.01
Beta 1.045
Diluted Shares Outstanding 120.09
Cost of Debt
Tax Rate 20.95
After-tax Cost of Debt 3.43%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.715
Total Debt 2,434.10
Total Equity 4,084.27
Total Capital 6,518.37
Debt Weighting 37.34
Equity Weighting 62.66
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 712.62726.531,031.121,006.871,031.611,145.041,270.941,410.691,565.801,737.96
EBITDA 435.17488.55451.91523.15591.33644.47715.33793.98881.28978.18
EBIT 456.24509.08468.35515.24567.66654.30726.24806.10894.73993.11
Tax Rate 21.65%19.83%19.66%20.55%20.95%20.53%20.53%20.53%20.53%20.53%
EBIAT 357.47408.12376.28409.36448.72519.99577.16640.62711.06789.25
Depreciation -21.06-20.53-16.447.9123.67-9.84-10.92-12.12-13.45-14.93
Accounts Receivable -2.51-8.752.32-30.386.53-9.72-10.78-11.97-13.29
Inventories ----------
Accounts Payable ----------
Capital Expenditure -5.78-11.08-19.02-15.38-14.72-16.34-18.14-20.13-22.35-24.80
UFCF 330.63379.02332.07404.21427.29500.34538.39597.59663.30736.23
WACC
PV UFCF 468.75472.55491.38510.97531.34
SUM PV UFCF 2,474.99

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 6.74
Free cash flow (t + 1) 750.95
Terminal Value 15,842.89
Present Value of Terminal Value 11,434

Intrinsic Value

Enterprise Value 13,909
Net Debt 1,257.45
Equity Value 12,651.55
Shares Outstanding 120.09
Equity Value Per Share 105.35