United Rentals, Inc. (URI) DCF Valuation
- ✓ 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
Looking to assess the intrinsic value of United Rentals, Inc.? Our (URI) DCF Calculator integrates real-world data along with extensive customization features, enabling you to refine predictions and enhance your investment choices.
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.