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 |