Discounted Cash Flow (DCF) Analysis Unlevered

Deutsche Bank Aktiengesellschaft (DB)

$11.25

+0.06 (+0.54%)
All numbers are in Millions, Currency in USD
Stock DCF: 191.35 | 11.25 | undervalue

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,31825,09522,95023,79325,31325,114.7424,918.0424,722.8724,529.2424,337.12
Revenue (%)
EBITDA 12,92712,8568,6397,1738,69010,169.8710,090.2210,011.199,932.789,854.99
EBITDA (%)
EBIT -----10,169.8710,090.2210,011.199,932.789,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,995242,605186,442224,994222,740234,692.01232,853.85231,030.09229,220.61227,425.30
Total Cash (%)
Account Receivables 86,98870,18166,94177,20674,79376,440.8975,842.1875,248.1774,658.8174,074.06
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 109,36593,19473,70781,55071,79087,119.9086,437.5685,760.5685,088.8684,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,31825,09522,95023,79325,31325,114.7424,918.0424,722.8724,529.2424,337.12
EBITDA 12,92712,8568,6397,1738,69010,169.8710,090.2210,011.199,932.789,854.99
EBIT -----10,169.8710,090.2210,011.199,932.789,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.675,686.785,642.245,598.055,554.20
Depreciation ----------
Accounts Receivable -16,8073,240-10,2652,413-1,647.89598.70594.01589.36584.74
Inventories ----------
Accounts Payable --16,171-19,4877,843-9,76015,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.255,132.425,092.225,052.345,012.77
WACC
PV UFCF 18,327.124,806.024,614.264,430.154,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