Discounted Cash Flow (DCF) Analysis Levered

Hawthorn Bancshares, Inc. (HWBK)

$21.47

+0.05 (+0.23%)
All numbers are in Millions, Currency in USD

Free Cash Flow

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 57.6367.9775.0872.7387.9698.12109.45122.09136.19151.92
Revenue (%)
Operating Cash Flow 19.0920.1530.6120.2828.9032.2435.9640.1144.7549.92
Operating Cash Flow (%)
Capital Expenditure -2.17-1.83-0.59-2.57-2.37-2.64-2.95-3.29-3.67-4.09
Capital Expenditure (%)
Free Cash Flow 16.9218.3230.0217.7126.5329.6033.0236.8341.0845.83

Weighted Average Cost Of Capital

Share price $ 21.47
Beta 0.519
Diluted Shares Outstanding -
Cost of Debt
Tax Rate -121.30
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 6.773
Total Debt -
Total Equity -
Total Capital -
Debt Weighting -
Equity Weighting -
Wacc

Build Up Free Cash Flow

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 57.6367.9775.0872.7387.9698.12109.45122.09136.19151.92
Operating Cash Flow 19.0920.1530.6120.2828.9032.2435.9640.1144.7549.92
Capital Expenditure -2.17-1.83-0.59-2.57-2.37-2.64-2.95-3.29-3.67-4.09
Free Cash Flow 16.9218.3230.0217.7126.5329.6033.0236.8341.0845.83
WACC
PV LFCF -----
SUM PV LFCF -

Terminal Value

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

Intrinsic Value

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