Discounted Cash Flow (DCF) Analysis Levered
Randolph Bancorp, Inc. (RNDB)
$27
+0.01 (+-%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 27.79 | 27.90 | 39.50 | 74.28 | 53.88 | 67.70 | 85.05 | 106.86 | 134.25 | 168.67 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 5.91 | -11.29 | -16.48 | -43.29 | -0.70 | -16.32 | -20.50 | -25.75 | -32.36 | -40.65 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -3.18 | -1.43 | -0.24 | -0.59 | -2.42 | -3.04 | -3.82 | -4.79 | -6.02 | -7.57 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 2.73 | -12.72 | -16.71 | -43.88 | -3.12 | -19.35 | -24.31 | -30.55 | -38.38 | -48.22 |
Weighted Average Cost Of Capital
Share price | $ 27 |
---|---|
Beta | 0.682 |
Diluted Shares Outstanding | 4.99 |
Cost of Debt | |
Tax Rate | 24.18 |
After-tax Cost of Debt | 3.27% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 6.751 |
Total Debt | 50 |
Total Equity | 134.83 |
Total Capital | 184.83 |
Debt Weighting | 27.05 |
Equity Weighting | 72.95 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 27.79 | 27.90 | 39.50 | 74.28 | 53.88 | 67.70 | 85.05 | 106.86 | 134.25 | 168.67 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 5.91 | -11.29 | -16.48 | -43.29 | -0.70 | -16.32 | -20.50 | -25.75 | -32.36 | -40.65 |
Capital Expenditure | -3.18 | -1.43 | -0.24 | -0.59 | -2.42 | -3.04 | -3.82 | -4.79 | -6.02 | -7.57 |
Free Cash Flow | 2.73 | -12.72 | -16.71 | -43.88 | -3.12 | -19.35 | -24.31 | -30.55 | -38.38 | -48.22 |
WACC | ||||||||||
PV LFCF | -17.29 | -20.53 | -24.37 | -28.94 | -34.36 | |||||
SUM PV LFCF | -132.77 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 5.81 |
Free cash flow (t + 1) | -49.18 |
Terminal Value | -1,290.93 |
Present Value of Terminal Value | -973.35 |
Intrinsic Value
Enterprise Value | -1,106.12 |
---|---|
Net Debt | -65.45 |
Equity Value | -1,040.67 |
Shares Outstanding | 4.99 |
Equity Value Per Share | -208.39 |