United Rentals, Inc. (URI) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 16.36 15.42 17.26 17.21 15.56
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

  1. Download the Template: Gain immediate access to the Excel-based URI DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key factors.
  3. Instant Calculations: The model automatically recalculates United Rentals’ intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
  5. 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.