Discounted Cash Flow (DCF) Analysis Unlevered
Deutsche Bank Aktiengesellschaft (DB)
$11.25
+0.06 (+0.54%)
All numbers are in Millions, Currency in USD
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 | 26,318 | 25,095 | 22,950 | 23,793 | 25,313 | 25,114.74 | 24,918.04 | 24,722.87 | 24,529.24 | 24,337.12 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 12,927 | 12,856 | 8,639 | 7,173 | 8,690 | 10,169.87 | 10,090.22 | 10,011.19 | 9,932.78 | 9,854.99 |
| EBITDA (%) | ||||||||||
| EBIT | - | - | - | - | - | 10,169.87 | 10,090.22 | 10,011.19 | 9,932.78 | 9,854.99 |
| EBIT (%) | ||||||||||
| Depreciation | - | - | - | - | - | - | - | - | - | - |
| 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 | 280,995 | 242,605 | 186,442 | 224,994 | 222,740 | 234,692.01 | 232,853.85 | 231,030.09 | 229,220.61 | 227,425.30 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 86,988 | 70,181 | 66,941 | 77,206 | 74,793 | 76,440.89 | 75,842.18 | 75,248.17 | 74,658.81 | 74,074.06 |
| Account Receivables (%) | ||||||||||
| Inventories | - | - | - | - | - | - | - | - | - | - |
| Inventories (%) | ||||||||||
| Accounts Payable | 109,365 | 93,194 | 73,707 | 81,550 | 71,790 | 87,119.90 | 86,437.56 | 85,760.56 | 85,088.86 | 84,422.42 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -485 | -465 | -327 | -512 | -550 | -474.43 | -470.72 | -467.03 | -463.37 | -459.74 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 11.25 |
|---|---|
| Beta | 1.396 |
| Diluted Shares Outstanding | 2,108 |
| Cost of Debt | |
| Tax Rate | 30.24 |
| After-tax Cost of Debt | 2.43% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 9.333 |
| Total Debt | 156,189 |
| Total Equity | 23,715 |
| Total Capital | 179,904 |
| Debt Weighting | 86.82 |
| Equity Weighting | 13.18 |
| 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 | 26,318 | 25,095 | 22,950 | 23,793 | 25,313 | 25,114.74 | 24,918.04 | 24,722.87 | 24,529.24 | 24,337.12 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 12,927 | 12,856 | 8,639 | 7,173 | 8,690 | 10,169.87 | 10,090.22 | 10,011.19 | 9,932.78 | 9,854.99 |
| EBIT | - | - | - | - | - | 10,169.87 | 10,090.22 | 10,011.19 | 9,932.78 | 9,854.99 |
| Tax Rate | 161.16% | 79.92% | -104.63% | 51.52% | 30.24% | 43.64% | 43.64% | 43.64% | 43.64% | 43.64% |
| EBIAT | - | - | - | - | - | 5,731.67 | 5,686.78 | 5,642.24 | 5,598.05 | 5,554.20 |
| Depreciation | - | - | - | - | - | - | - | - | - | - |
| Accounts Receivable | - | 16,807 | 3,240 | -10,265 | 2,413 | -1,647.89 | 598.70 | 594.01 | 589.36 | 584.74 |
| Inventories | - | - | - | - | - | - | - | - | - | - |
| Accounts Payable | - | -16,171 | -19,487 | 7,843 | -9,760 | 15,329.90 | -682.34 | -677 | -671.70 | -666.44 |
| Capital Expenditure | -485 | -465 | -327 | -512 | -550 | -474.43 | -470.72 | -467.03 | -463.37 | -459.74 |
| UFCF | - | - | - | - | - | 18,939.25 | 5,132.42 | 5,092.22 | 5,052.34 | 5,012.77 |
| WACC | ||||||||||
| PV UFCF | 18,327.12 | 4,806.02 | 4,614.26 | 4,430.15 | 4,253.39 | |||||
| SUM PV UFCF | 36,430.94 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 3.34 |
| Free cash flow (t + 1) | 5,113.02 |
| Terminal Value | 381,568.75 |
| Present Value of Terminal Value | 323,765.46 |
Intrinsic Value
| Enterprise Value | 360,196.40 |
|---|---|
| Net Debt | -43,174 |
| Equity Value | 403,370.40 |
| Shares Outstanding | 2,108 |
| Equity Value Per Share | 191.35 |