Uber Technologies, Inc. (UBER) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Uber Technologies, Inc. (UBER) Bundle
Evaluate Uber Technologies, Inc. (UBER) financial prospects like an expert! This (UBER) DCF Calculator comes with pre-filled financial data and offers total flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 14,147.0 | 11,139.0 | 17,455.0 | 31,877.0 | 37,281.0 | 49,864.8 | 66,696.1 | 89,208.7 | 119,320.2 | 159,595.5 |
| Revenue Growth, % | 0 | -21.26 | 56.7 | 82.62 | 16.95 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 |
| EBITDA | -7,402.0 | -5,913.0 | 360.0 | -7,914.0 | 1,933.0 | -12,265.3 | -16,405.3 | -21,942.7 | -29,349.2 | -39,255.7 |
| EBITDA, % | -52.32 | -53.08 | 2.06 | -24.83 | 5.18 | -24.6 | -24.6 | -24.6 | -24.6 | -24.6 |
| Depreciation | 472.0 | 575.0 | 902.0 | 947.0 | 823.0 | 1,879.3 | 2,513.7 | 3,362.2 | 4,497.0 | 6,015.0 |
| Depreciation, % | 3.34 | 5.16 | 5.17 | 2.97 | 2.21 | 3.77 | 3.77 | 3.77 | 3.77 | 3.77 |
| EBIT | -7,874.0 | -6,488.0 | -542.0 | -8,861.0 | 1,110.0 | -14,144.6 | -18,919.0 | -25,304.9 | -33,846.2 | -45,270.7 |
| EBIT, % | -55.66 | -58.25 | -3.11 | -27.8 | 2.98 | -28.37 | -28.37 | -28.37 | -28.37 | -28.37 |
| Total Cash | 11,313.0 | 6,827.0 | 4,295.0 | 4,311.0 | 6,212.0 | 19,551.9 | 26,151.5 | 34,978.6 | 46,785.3 | 62,577.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,214.0 | 1,073.0 | 2,439.0 | 2,779.0 | 4,121.0 | 5,181.9 | 6,930.9 | 9,270.4 | 12,399.5 | 16,584.8 |
| Account Receivables, % | 8.58 | 9.63 | 13.97 | 8.72 | 11.05 | 10.39 | 10.39 | 10.39 | 10.39 | 10.39 |
| Inventories | 99.0 | 767.0 | 631.0 | 680.0 | .0 | 1,329.8 | 1,778.6 | 2,379.0 | 3,182.0 | 4,256.0 |
| Inventories, % | 0.6998 | 6.89 | 3.62 | 2.13 | 0 | 2.67 | 2.67 | 2.67 | 2.67 | 2.67 |
| Accounts Payable | 272.0 | 235.0 | 860.0 | 728.0 | 790.0 | 1,332.6 | 1,782.4 | 2,384.0 | 3,188.7 | 4,265.1 |
| Accounts Payable, % | 1.92 | 2.11 | 4.93 | 2.28 | 2.12 | 2.67 | 2.67 | 2.67 | 2.67 | 2.67 |
| Capital Expenditure | -588.0 | -616.0 | -298.0 | -252.0 | -223.0 | -1,274.8 | -1,705.1 | -2,280.6 | -3,050.4 | -4,080.0 |
| Capital Expenditure, % | -4.16 | -5.53 | -1.71 | -0.79054 | -0.59816 | -2.56 | -2.56 | -2.56 | -2.56 | -2.56 |
| Tax Rate, % | 18.7 | 18.7 | 18.7 | 18.7 | 18.7 | 18.7 | 18.7 | 18.7 | 18.7 | 18.7 |
| EBITAT | -7,916.0 | -6,308.7 | -281.8 | -8,690.8 | 902.4 | -12,125.2 | -16,218.0 | -21,692.2 | -29,014.1 | -38,807.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -9,073.0 | -6,913.7 | -282.8 | -8,516.8 | 902.4 | -13,368.7 | -17,157.5 | -22,948.8 | -30,694.9 | -41,055.7 |
| WACC, % | 10.3 | 10.29 | 10.09 | 10.29 | 10.22 | 10.24 | 10.24 | 10.24 | 10.24 | 10.24 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -89,379.4 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -42,698 | |||||||||
| Terminal Value | -684,498 | |||||||||
| Present Terminal Value | -420,454 | |||||||||
| Enterprise Value | -509,833 | |||||||||
| Net Debt | 6,345 | |||||||||
| Equity Value | -516,178 | |||||||||
| Diluted Shares Outstanding, MM | 2,092 | |||||||||
| Equity Value Per Share | -246.76 |
What You Will Get
- Real UBER Financial Data: Pre-filled with Uber’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Uber’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as ride growth, revenue per trip, and operational expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional metrics with ease.
- High-Precision Accuracy: Leverages Uber’s real-world financial data for credible valuation results.
- Simplified Scenario Analysis: Explore various assumptions and effortlessly compare results.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Uber data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Uber’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Uber Technologies, Inc. (UBER)?
- Convenience: Access rides, food delivery, and logistics all in one app.
- Innovative Technology: Cutting-edge algorithms ensure efficient routing and service.
- Flexible Options: Choose from various transportation and delivery services to meet your needs.
- User-Friendly Interface: Intuitive design makes it easy to navigate and use.
- Global Reach: Available in numerous cities worldwide, connecting you wherever you go.
Who Should Use This Product?
- Professional Investors: Create comprehensive and accurate valuation models for investment analysis of Uber Technologies, Inc. (UBER).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Uber Technologies, Inc. (UBER).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into how companies like Uber are valued in the competitive market.
What the Uber Template Contains
- Preloaded UBER Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.