|
Valoración de DCF de United Rentals, Inc. (URI)
US | Industrials | Rental & Leasing Services | 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
United Rentals, Inc. (URI) Bundle
¿Busca evaluar el valor intrínseco de United Rentals, Inc.? Nuestra calculadora DCF (URI) integra datos del mundo real junto con extensas características de personalización, lo que le permite refinar las predicciones y mejorar sus opciones de inversión.
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 | 9,351.0 | 8,530.0 | 9,716.0 | 11,642.0 | 14,332.0 | 16,053.7 | 17,982.3 | 20,142.6 | 22,562.4 | 25,272.8 |
| Revenue Growth, % | 0 | -8.78 | 13.9 | 19.82 | 23.11 | 12.01 | 12.01 | 12.01 | 12.01 | 12.01 |
| EBITDA | 4,200.0 | 2,195.0 | 2,642.0 | 5,464.0 | 6,627.0 | 6,132.9 | 6,869.7 | 7,695.0 | 8,619.4 | 9,654.9 |
| EBITDA, % | 44.91 | 25.73 | 27.19 | 46.93 | 46.24 | 38.2 | 38.2 | 38.2 | 38.2 | 38.2 |
| Depreciation | 2,038.0 | 1,952.0 | 1,969.0 | 2,217.0 | 2,781.0 | 3,319.6 | 3,718.4 | 4,165.1 | 4,665.5 | 5,226.0 |
| Depreciation, % | 21.79 | 22.88 | 20.27 | 19.04 | 19.4 | 20.68 | 20.68 | 20.68 | 20.68 | 20.68 |
| EBIT | 2,162.0 | 243.0 | 673.0 | 3,247.0 | 3,846.0 | 2,813.3 | 3,151.3 | 3,529.8 | 3,953.9 | 4,428.9 |
| EBIT, % | 23.12 | 2.85 | 6.93 | 27.89 | 26.84 | 17.52 | 17.52 | 17.52 | 17.52 | 17.52 |
| Total Cash | 52.0 | 202.0 | 144.0 | 106.0 | 363.0 | 252.0 | 282.3 | 316.2 | 354.2 | 396.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,530.0 | 1,315.0 | 1,677.0 | 2,004.0 | 2,230.0 | 2,626.8 | 2,942.3 | 3,295.8 | 3,691.7 | 4,135.2 |
| Account Receivables, % | 16.36 | 15.42 | 17.26 | 17.21 | 15.56 | 16.36 | 16.36 | 16.36 | 16.36 | 16.36 |
| Inventories | 120.0 | 125.0 | 164.0 | 232.0 | 205.0 | 252.4 | 282.7 | 316.6 | 354.7 | 397.3 |
| Inventories, % | 1.28 | 1.47 | 1.69 | 1.99 | 1.43 | 1.57 | 1.57 | 1.57 | 1.57 | 1.57 |
| Accounts Payable | 454.0 | 466.0 | 816.0 | 1,139.0 | 905.0 | 1,117.8 | 1,252.1 | 1,402.5 | 1,571.0 | 1,759.7 |
| Accounts Payable, % | 4.86 | 5.46 | 8.4 | 9.78 | 6.31 | 6.96 | 6.96 | 6.96 | 6.96 | 6.96 |
| Capital Expenditure | -2,350.0 | -1,158.0 | -3,198.0 | -3,690.0 | -4,070.0 | -4,229.0 | -4,737.1 | -5,306.2 | -5,943.6 | -6,657.6 |
| Capital Expenditure, % | -25.13 | -13.58 | -32.91 | -31.7 | -28.4 | -26.34 | -26.34 | -26.34 | -26.34 | -26.34 |
| Tax Rate, % | 24.51 | 24.51 | 24.51 | 24.51 | 24.51 | 24.51 | 24.51 | 24.51 | 24.51 | 24.51 |
| EBITAT | 1,676.5 | 189.9 | 505.3 | 2,439.3 | 2,903.4 | 2,145.9 | 2,403.7 | 2,692.4 | 3,015.9 | 3,378.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 168.5 | 1,205.9 | -774.7 | 894.3 | 1,181.4 | 1,005.2 | 1,173.4 | 1,314.4 | 1,472.3 | 1,649.1 |
| WACC, % | 10.65 | 10.66 | 10.62 | 10.63 | 10.63 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,815.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,682 | |||||||||
| Terminal Value | 19,476 | |||||||||
| Present Terminal Value | 11,749 | |||||||||
| Enterprise Value | 16,564 | |||||||||
| Net Debt | 12,299 | |||||||||
| Equity Value | 4,265 | |||||||||
| Diluted Shares Outstanding, MM | 69 | |||||||||
| Equity Value Per Share | 62.07 |
What You Will Receive
- Authentic URI Financial Data: Pre-filled with United Rentals’ historical and projected data for accurate analysis.
- Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch United Rentals’ intrinsic value update in real-time based on your modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF results.
- Intuitive Design: Straightforward layout and clear guidance suitable for all levels of expertise.
Key Features
- Customizable Forecast Inputs: Adjust essential factors such as rental revenue growth, EBITDA margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages United Rentals' (URI) real-world financial data for dependable valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based URI DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key factors.
- Instant Calculations: The model automatically recalculates United Rentals’ 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.
Why Choose United Rentals, Inc. (URI)?
- Time-Efficient: Access a comprehensive rental solution without the hassle of extensive setup.
- Enhanced Precision: Utilize accurate equipment data and pricing to minimize discrepancies in your projects.
- Highly Customizable: Adjust rental options to align with your specific needs and project requirements.
- User-Friendly Interface: Intuitive tools and resources simplify the rental process for better decision-making.
- Expert Approval: Endorsed by industry professionals who prioritize reliability and efficiency.
Who Should Use United Rentals, Inc. (URI)?
- Construction Managers: Enhance project efficiency with reliable equipment rental solutions.
- Project Planners: Streamline logistics with comprehensive access to a wide range of rental equipment.
- Contractors: Adapt rental options quickly to meet changing project needs and timelines.
- Business Owners: Optimize capital expenditure by choosing rental over purchase for heavy machinery.
- Students and Educators: Utilize real-world case studies in construction and equipment management courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled United Rentals, Inc. (URI) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for United Rentals, Inc. (URI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.