|
Deutsche Bank Aktiengesellschaft (DB) DCF Valoración
DE | Financial Services | Banks - Regional | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Deutsche Bank Aktiengesellschaft (DB) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (DB)! Utilizando datos reales de Deutsche Bank y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar Deutsche Bank Aktiengesellschaft como un inversor experimentado.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 23,914.9 | 24,897.6 | 26,369.1 | 27,779.1 | 30,095.8 | 31,879.4 | 33,768.8 | 35,770.1 | 37,890.0 | 40,135.6 |
| Revenue Growth, % | 0 | 4.11 | 5.91 | 5.35 | 8.34 | 5.93 | 5.93 | 5.93 | 5.93 | 5.93 |
| EBITDA | -457.5 | 3,086.8 | 5,523.3 | 7,695.1 | 7,980.7 | 5,460.9 | 5,784.6 | 6,127.4 | 6,490.5 | 6,875.2 |
| EBITDA, % | -1.91 | 12.4 | 20.95 | 27.7 | 26.52 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 |
| Depreciation | 2,402.1 | 2,147.8 | 2,092.6 | 2,023.8 | 1,204.7 | 2,416.2 | 2,559.4 | 2,711.0 | 2,871.7 | 3,041.9 |
| Depreciation, % | 10.04 | 8.63 | 7.94 | 7.29 | 4 | 7.58 | 7.58 | 7.58 | 7.58 | 7.58 |
| EBIT | -2,859.6 | 939.0 | 3,430.7 | 5,671.3 | 6,776.0 | 3,044.8 | 3,225.2 | 3,416.4 | 3,618.8 | 3,833.3 |
| EBIT, % | -11.96 | 3.77 | 13.01 | 20.42 | 22.51 | 9.55 | 9.55 | 9.55 | 9.55 | 9.55 |
| Total Cash | 194,297.4 | 240,912.1 | 232,124.8 | 226,941.2 | 222,422.5 | 31,879.4 | 33,768.8 | 35,770.1 | 37,890.0 | 40,135.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 69,761.5 | 1,027.5 | 77,944.3 | .0 | 81,533.4 | 19,390.8 | 20,540.0 | 21,757.3 | 23,046.8 | 24,412.7 |
| Account Receivables, % | 291.71 | 4.13 | 295.59 | 0 | 270.91 | 60.83 | 60.83 | 60.83 | 60.83 | 60.83 |
| Inventories | -423,797.1 | -448,083.0 | -470,990.1 | -534,636.3 | .0 | -25,503.5 | -27,015.0 | -28,616.1 | -30,312.0 | -32,108.5 |
| Inventories, % | -1772.11 | -1799.7 | -1786.14 | -1924.6 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 76,812.5 | 84,986.0 | 74,814.8 | 89,141.0 | 89,961.1 | 31,879.4 | 33,768.8 | 35,770.1 | 37,890.0 | 40,135.6 |
| Accounts Payable, % | 321.19 | 341.34 | 283.72 | 320.89 | 298.92 | 100 | 100 | 100 | 100 | 100 |
| Capital Expenditure | -340.8 | -533.6 | -573.2 | -351.2 | -439.8 | -539.9 | -571.9 | -605.7 | -641.6 | -679.7 |
| Capital Expenditure, % | -1.42 | -2.14 | -2.17 | -1.26 | -1.46 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 |
| Tax Rate, % | 15.96 | 15.96 | 15.96 | 15.96 | 15.96 | 15.96 | 15.96 | 15.96 | 15.96 | 15.96 |
| EBITAT | -5,714.9 | 463.4 | 2,393.4 | 5,601.3 | 5,694.8 | 2,447.5 | 2,592.6 | 2,746.3 | 2,909.0 | 3,081.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 427,194.6 | 103,270.9 | -60,268.0 | 163,190.7 | -608,889.9 | 33,888.3 | 6,831.7 | 7,236.6 | 7,665.5 | 8,119.8 |
| WACC, % | 18.91 | 10.29 | 13.76 | 18.7 | 16.2 | 15.57 | 15.57 | 15.57 | 15.57 | 15.57 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 47,359.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 8,282 | |||||||||
| Terminal Value | 61,021 | |||||||||
| Present Terminal Value | 29,594 | |||||||||
| Enterprise Value | 76,953 | |||||||||
| Net Debt | -42,039 | |||||||||
| Equity Value | 118,992 | |||||||||
| Diluted Shares Outstanding, MM | 2,104 | |||||||||
| Equity Value Per Share | 56.56 |
What You Will Get
- Real DB Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Deutsche Bank’s future performance.
- User-Friendly Design: Designed for professionals while remaining easy to navigate for newcomers.
Key Features
- Pre-Loaded Data: Deutsche Bank’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Edit WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: See Deutsche Bank’s intrinsic value recalculate in real time.
- Clear Visual Outputs: Dashboard charts display valuation results and key metrics.
- Built for Accuracy: A professional tool for analysts, investors, and finance experts.
How It Works
- Download the Template: Gain immediate access to the Excel-based DB DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Deutsche Bank's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose This Calculator for Deutsche Bank Aktiengesellschaft (DB)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses seamlessly integrated.
- Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Deutsche Bank’s intrinsic value and Net Present Value.
- Preloaded Information: Utilizes historical and projected data for reliable baseline calculations.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and precise valuation models for investment strategies involving Deutsche Bank Aktiengesellschaft (DB).
- Corporate Finance Departments: Evaluate valuation scenarios to inform corporate decision-making and strategic planning.
- Financial Consultants: Deliver accurate valuation assessments and insights for clients interested in Deutsche Bank Aktiengesellschaft (DB).
- Academics and Students: Utilize real-time financial data to enhance learning and practice in financial modeling.
- Finance Enthusiasts: Gain insights into how major banking institutions like Deutsche Bank Aktiengesellschaft (DB) are valued within the financial market.
What the Template Contains
- Historical Data: Includes Deutsche Bank’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Deutsche Bank’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Deutsche Bank’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.