Discounted Cash Flow (DCF) Analysis Levered
Barclays PLC (BCS)
$9.02
-0.12 (-1.31%)
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 | 21,073 | 21,132 | 21,625 | 21,615 | 21,954 | 22,180.95 | 22,410.25 | 22,641.92 | 22,875.98 | 23,112.47 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| Operating Cash Flow | 60,711 | 8,504 | -12,295 | 57,505 | 48,919 | 33,730.68 | 34,079.38 | 34,431.68 | 34,787.62 | 35,147.24 |
| Operating Cash Flow (%) | ||||||||||
| Capital Expenditure | -1,456 | -1,402 | -1,793 | -1,324 | -1,720 | -1,587.94 | -1,604.35 | -1,620.94 | -1,637.69 | -1,654.62 |
| Capital Expenditure (%) | ||||||||||
| Free Cash Flow | 59,255 | 7,102 | -14,088 | 56,181 | 47,199 | 32,142.74 | 32,475.02 | 32,810.74 | 33,149.92 | 33,492.61 |
Weighted Average Cost Of Capital
| Share price | $ 9.02 |
|---|---|
| Beta | 1.293 |
| Diluted Shares Outstanding | 4,355 |
| Cost of Debt | |
| Tax Rate | 14.68 |
| After-tax Cost of Debt | 1.62% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 9.719 |
| Total Debt | 166,590 |
| Total Equity | 39,282.10 |
| Total Capital | 205,872.10 |
| Debt Weighting | 80.92 |
| Equity Weighting | 19.08 |
| 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 | 21,073 | 21,132 | 21,625 | 21,615 | 21,954 | 22,180.95 | 22,410.25 | 22,641.92 | 22,875.98 | 23,112.47 |
|---|---|---|---|---|---|---|---|---|---|---|
| Operating Cash Flow | 60,711 | 8,504 | -12,295 | 57,505 | 48,919 | 33,730.68 | 34,079.38 | 34,431.68 | 34,787.62 | 35,147.24 |
| Capital Expenditure | -1,456 | -1,402 | -1,793 | -1,324 | -1,720 | -1,587.94 | -1,604.35 | -1,620.94 | -1,637.69 | -1,654.62 |
| Free Cash Flow | 59,255 | 7,102 | -14,088 | 56,181 | 47,199 | 32,142.74 | 32,475.02 | 32,810.74 | 33,149.92 | 33,492.61 |
| WACC | ||||||||||
| PV LFCF | 26,654 | 26,102.10 | 25,561.63 | 25,032.35 | 24,514.03 | |||||
| SUM PV LFCF | 149,456.85 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 3.17 |
| Free cash flow (t + 1) | 34,162.47 |
| Terminal Value | 2,919,868.85 |
| Present Value of Terminal Value | 2,498,021.62 |
Intrinsic Value
| Enterprise Value | 2,647,478.46 |
|---|---|
| Net Debt | -71,984 |
| Equity Value | 2,719,462.46 |
| Shares Outstanding | 4,355 |
| Equity Value Per Share | 624.45 |