|
Valoración DCF de Amerco (Uhal)
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
AMERCO (UHAL) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (UHAL)! Equipado con datos reales de Amerco y supuestos personalizables, esta herramienta le permite pronosticar, analizar y valorar Amerco como un inversor experimentado.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 3,978.9 | 4,542.0 | 5,739.7 | 5,864.7 | 5,625.7 | 6,168.9 | 6,764.6 | 7,417.8 | 8,134.1 | 8,919.5 |
Revenue Growth, % | 0 | 14.15 | 26.37 | 2.18 | -4.08 | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 |
EBITDA | 1,202.4 | 1,627.4 | 2,337.8 | 2,183.8 | 1,919.7 | 2,197.9 | 2,410.1 | 2,642.8 | 2,898.0 | 3,177.9 |
EBITDA, % | 30.22 | 35.83 | 40.73 | 37.24 | 34.12 | 35.63 | 35.63 | 35.63 | 35.63 | 35.63 |
Depreciation | 664.1 | 664.0 | 697.0 | 733.9 | 817.9 | 869.9 | 953.9 | 1,046.0 | 1,147.0 | 1,257.7 |
Depreciation, % | 16.69 | 14.62 | 12.14 | 12.51 | 14.54 | 14.1 | 14.1 | 14.1 | 14.1 | 14.1 |
EBIT | 538.3 | 963.4 | 1,640.8 | 1,450.0 | 1,101.8 | 1,328.0 | 1,456.2 | 1,596.9 | 1,751.0 | 1,920.1 |
EBIT, % | 13.53 | 21.21 | 28.59 | 24.72 | 19.58 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 |
Total Cash | 494.4 | 1,194.0 | 2,704.1 | 2,060.5 | 1,535.5 | 1,829.1 | 2,005.8 | 2,199.4 | 2,411.8 | 2,644.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 186.7 | 224.4 | 229.3 | 189.5 | 215.9 | 255.4 | 280.0 | 307.1 | 336.7 | 369.2 |
Account Receivables, % | 4.69 | 4.94 | 4 | 3.23 | 3.84 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 |
Inventories | 101.1 | 105.6 | 158.9 | 151.5 | 150.9 | 159.1 | 174.5 | 191.4 | 209.8 | 230.1 |
Inventories, % | 2.54 | 2.32 | 2.77 | 2.58 | 2.68 | 2.58 | 2.58 | 2.58 | 2.58 | 2.58 |
Accounts Payable | .0 | .0 | .0 | 761.0 | 754.3 | 325.5 | 357.0 | 391.4 | 429.2 | 470.7 |
Accounts Payable, % | 0 | 0 | 0 | 12.98 | 13.41 | 5.28 | 5.28 | 5.28 | 5.28 | 5.28 |
Capital Expenditure | -2,309.4 | -1,441.5 | -2,136.5 | -2,723.9 | -2,992.9 | -2,796.3 | -3,066.4 | -3,362.5 | -3,687.1 | -4,043.2 |
Capital Expenditure, % | -58.04 | -31.74 | -37.22 | -46.45 | -53.2 | -45.33 | -45.33 | -45.33 | -45.33 | -45.33 |
Tax Rate, % | 25.17 | 25.17 | 25.17 | 25.17 | 25.17 | 25.17 | 25.17 | 25.17 | 25.17 | 25.17 |
EBITAT | 629.3 | 738.7 | 1,250.4 | 1,100.6 | 824.5 | 1,072.0 | 1,175.5 | 1,289.0 | 1,413.5 | 1,550.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,303.7 | -81.0 | -247.5 | -81.1 | -1,383.2 | -1,330.9 | -945.6 | -1,036.9 | -1,137.0 | -1,246.8 |
WACC, % | 8 | 7.67 | 7.66 | 7.66 | 7.64 | 7.73 | 7.73 | 7.73 | 7.73 | 7.73 |
PV UFCF | ||||||||||
SUM PV UFCF | -4,583.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1,272 | |||||||||
Terminal Value | -22,202 | |||||||||
Present Terminal Value | -15,302 | |||||||||
Enterprise Value | -19,885 | |||||||||
Net Debt | 4,792 | |||||||||
Equity Value | -24,677 | |||||||||
Diluted Shares Outstanding, MM | 196 | |||||||||
Equity Value Per Share | -125.85 |
What You Will Receive
- Adjustable Forecast Parameters: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Financial Data: AMERCO’s financial information pre-loaded to facilitate your analysis.
- Automated DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Professional and Customizable: A refined Excel model that aligns with your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital expenditures for AMERCO (UHAL).
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other financial metrics for quick insights.
- High-Precision Accuracy: Leverages AMERCO's actual financial data to deliver realistic valuation results.
- Effortless Scenario Testing: Easily explore various assumptions and analyze different outcomes.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template with AMERCO’s data included.
- Step 2: Explore the pre-filled sheets to familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including AMERCO’s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for AMERCO (UHAL)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: AMERCO’s historical and projected financials are preloaded for precise analysis.
- Forecast Simulation: Effortlessly test various scenarios and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Comprehensive step-by-step guidance simplifies the entire process.
Who Should Use This Product?
- Investors: Evaluate AMERCO's (UHAL) market position before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of leading companies like AMERCO.
- Consultants: Create comprehensive valuation reports for clients based on AMERCO's data.
- Students and Educators: Utilize real-time data to practice and teach valuation concepts related to AMERCO.
What the Template Contains
- Preloaded UHAL 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.