Discounted Cash Flow (DCF) Analysis Unlevered

FFBW, Inc. (FFBW)

$11.73

-0.07 (-0.59%)
All numbers are in Millions, Currency in USD
Stock DCF: 10.84 | 11.73 | overvalue

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 8.339.209.4910.6511.6112.6213.7214.9116.2117.62
Revenue (%)
EBITDA 2.093.835.194.313.914.945.375.836.346.89
EBITDA (%)
EBIT 1.633.494.854.023.624.484.875.295.756.25
EBIT (%)
Depreciation 0.460.340.350.300.290.460.500.540.590.64
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 61.3045.5052.28105.70100.8891.9599.95108.65118.11128.39
Total Cash (%)
Account Receivables 0.780.770.730.990.811.051.141.241.351.47
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 0.040.070.050.020.010.050.050.060.060.07
Accounts Payable (%)
Capital Expenditure -0.36-0.11-0.10-0.06-0.21-0.22-0.24-0.26-0.29-0.31
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 11.73
Beta 0.390
Diluted Shares Outstanding 6.45
Cost of Debt
Tax Rate 24.57
After-tax Cost of Debt 11.48%
Risk-Free Rate
Market Risk Premium
Cost of Equity 5.439
Total Debt 6.50
Total Equity 75.68
Total Capital 82.18
Debt Weighting 7.91
Equity Weighting 92.09
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 8.339.209.4910.6511.6112.6213.7214.9116.2117.62
EBITDA 2.093.835.194.313.914.945.375.836.346.89
EBIT 1.633.494.854.023.624.484.875.295.756.25
Tax Rate 338.46%23.11%24.39%23.61%24.57%86.83%86.83%86.83%86.83%86.83%
EBIAT -3.892.683.663.072.730.590.640.700.760.82
Depreciation 0.460.340.350.300.290.460.500.540.590.64
Accounts Receivable -0.010.04-0.270.18-0.24-0.09-0.10-0.11-0.12
Inventories ----------
Accounts Payable -0.03-0.02-0.03-0.010.04000.010.01
Capital Expenditure -0.36-0.11-0.10-0.06-0.21-0.22-0.24-0.26-0.29-0.31
UFCF -3.792.963.9432.990.630.810.880.961.04
WACC
PV UFCF 0.590.720.740.760.78
SUM PV UFCF 3.61

Terminal Value

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

Intrinsic Value

Enterprise Value 23.97
Net Debt -45.98
Equity Value 69.95
Shares Outstanding 6.45
Equity Value Per Share 10.84