|
UBS Group AG (UBS) DCF Valoración
CH | Financial Services | Banks - Diversified | 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
UBS Group AG (UBS) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (UBS)! Utilizando datos reales de UBS Group AG y supuestos personalizables, esta herramienta le permite pronosticar, analizar y valorar UBS 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 | 32,155.6 | 36,723.3 | 38,915.5 | 36,929.7 | 43,360.0 | 46,881.2 | 50,688.4 | 54,804.8 | 59,255.4 | 64,067.5 |
Revenue Growth, % | 0 | 14.2 | 5.97 | -5.1 | 17.41 | 8.12 | 8.12 | 8.12 | 8.12 | 8.12 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | 2,153.4 | 2,359.9 | 2,351.0 | 2,287.7 | 4,162.5 | 3,277.8 | 3,544.0 | 3,831.8 | 4,143.0 | 4,479.4 |
Depreciation, % | 6.7 | 6.43 | 6.04 | 6.19 | 9.6 | 6.99 | 6.99 | 6.99 | 6.99 | 6.99 |
EBIT | -2,153.4 | -2,359.9 | -2,351.0 | -2,287.7 | -4,162.5 | -3,277.8 | -3,544.0 | -3,831.8 | -4,143.0 | -4,479.4 |
EBIT, % | -6.7 | -6.43 | -6.04 | -6.19 | -9.6 | -6.99 | -6.99 | -6.99 | -6.99 | -6.99 |
Total Cash | 125,888.6 | 184,803.0 | 226,042.8 | 190,569.4 | 365,608.8 | 46,881.2 | 50,688.4 | 54,804.8 | 59,255.4 | 64,067.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 50,500.6 | 32,349.9 | 29,220.8 | 26,007.3 | 39,837.9 | 39,894.0 | 43,133.8 | 46,636.6 | 50,424.0 | 54,518.9 |
Account Receivables, % | 157.05 | 88.09 | 75.09 | 70.42 | 91.88 | 85.1 | 85.1 | 85.1 | 85.1 | 85.1 |
Inventories | -371,500.7 | -384,126.3 | -435,009.6 | -390,366.1 | .0 | -37,505.0 | -40,550.7 | -43,843.8 | -47,404.4 | -51,254.0 |
Inventories, % | -1155.32 | -1046 | -1117.83 | -1057.05 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | 43,062.5 | 44,507.7 | 50,104.3 | 52,207.8 | 54,627.6 | 46,881.2 | 50,688.4 | 54,804.8 | 59,255.4 | 64,067.5 |
Accounts Payable, % | 133.92 | 121.2 | 128.75 | 141.37 | 125.99 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | -1,758.2 | -2,057.9 | -2,043.5 | -1,823.7 | -1,870.4 | -2,398.0 | -2,592.7 | -2,803.3 | -3,030.9 | -3,277.0 |
Capital Expenditure, % | -5.47 | -5.6 | -5.25 | -4.94 | -4.31 | -5.11 | -5.11 | -5.11 | -5.11 | -5.11 |
Tax Rate, % | 3.09 | 3.09 | 3.09 | 3.09 | 3.09 | 3.09 | 3.09 | 3.09 | 3.09 | 3.09 |
EBITAT | -1,661.9 | -1,881.1 | -1,848.5 | -1,817.3 | -4,033.7 | -2,700.0 | -2,919.2 | -3,156.3 | -3,412.6 | -3,689.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 362,795.9 | 30,642.4 | 58,068.1 | -40,679.9 | -403,518.5 | 27,882.4 | 1,645.3 | 1,778.9 | 1,923.3 | 2,079.5 |
WACC, % | 6.52 | 6.67 | 6.6 | 6.65 | 7.66 | 6.82 | 6.82 | 6.82 | 6.82 | 6.82 |
PV UFCF | ||||||||||
SUM PV UFCF | 31,975.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 2,121 | |||||||||
Terminal Value | 44,002 | |||||||||
Present Terminal Value | 31,637 | |||||||||
Enterprise Value | 63,613 | |||||||||
Net Debt | 67,125 | |||||||||
Equity Value | -3,512 | |||||||||
Diluted Shares Outstanding, MM | 3,915 | |||||||||
Equity Value Per Share | -0.90 |
What You Will Get
- Editable Forecast Inputs: Seamlessly adjust assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: UBS Group AG’s financial data pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that tailors to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life UBS Financials: Pre-filled historical and projected data for UBS Group AG (UBS).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate UBS’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize UBS’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring UBS Group AG’s (UBS) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including UBS Group AG’s (UBS) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose UBS Group AG (UBS)?
- Global Expertise: Benefit from UBS's extensive experience in financial services worldwide.
- Innovative Solutions: Access cutting-edge tools and strategies tailored to your financial needs.
- Client-Centric Approach: Personalized services designed to meet the unique goals of each client.
- Robust Research: Leverage comprehensive market insights and analysis from industry leaders.
- Reputation for Integrity: Trust in a firm known for its commitment to ethical standards and transparency.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling UBS Group AG (UBS) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for UBS Group AG (UBS).
- Consultants: Provide clients with accurate and timely valuation insights related to UBS Group AG (UBS).
- Business Owners: Learn how major players like UBS Group AG (UBS) are valued to inform your own business strategy.
- Finance Students: Explore valuation methodologies using real-world examples from UBS Group AG (UBS).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for UBS Group AG (UBS).
- Real-World Data: UBS’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into UBS’s performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage metrics specific to UBS.
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results tailored to UBS Group AG (UBS).