|
Hertz Global Holdings, Inc. (HTZ) DCF Valuation
US | Industrials | Rental & Leasing Services | NASDAQ
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Hertz Global Holdings, Inc. (HTZ) Bundle
Discover the true potential of Hertz Global Holdings, Inc. (HTZ) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how different changes influence Hertz's valuation – all within a single Excel template.
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,779.0 | 5,258.0 | 7,336.0 | 8,685.0 | 9,371.0 | 9,829.6 | 10,310.7 | 10,815.3 | 11,344.6 | 11,899.9 |
| Revenue Growth, % | 0 | -46.23 | 39.52 | 18.39 | 7.9 | 4.89 | 4.89 | 4.89 | 4.89 | 4.89 |
| EBITDA | 3,769.0 | 1,040.0 | 1,348.0 | 3,844.0 | 3,644.0 | 3,142.4 | 3,296.2 | 3,457.5 | 3,626.7 | 3,804.2 |
| EBITDA, % | 38.54 | 19.78 | 18.38 | 44.26 | 38.89 | 31.97 | 31.97 | 31.97 | 31.97 | 31.97 |
| Depreciation | 2,994.0 | 2,484.0 | 801.0 | 940.0 | 2,571.0 | 2,497.4 | 2,619.7 | 2,747.9 | 2,882.4 | 3,023.4 |
| Depreciation, % | 30.62 | 47.24 | 10.92 | 10.82 | 27.44 | 25.41 | 25.41 | 25.41 | 25.41 | 25.41 |
| EBIT | 775.0 | -1,444.0 | 547.0 | 2,904.0 | 1,073.0 | 644.9 | 676.5 | 709.6 | 744.3 | 780.8 |
| EBIT, % | 7.93 | -27.46 | 7.46 | 33.44 | 11.45 | 6.56 | 6.56 | 6.56 | 6.56 | 6.56 |
| Total Cash | 865.0 | 1,096.0 | 2,258.0 | 943.0 | 1,206.0 | 1,655.2 | 1,736.3 | 1,821.2 | 1,910.4 | 2,003.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,840.0 | 777.0 | 758.0 | 974.0 | 1,191.0 | 1,333.9 | 1,399.2 | 1,467.6 | 1,539.5 | 1,614.8 |
| Account Receivables, % | 18.82 | 14.78 | 10.33 | 11.21 | 12.71 | 13.57 | 13.57 | 13.57 | 13.57 | 13.57 |
| Inventories | 495.0 | 2,222.0 | 393.0 | 475.0 | .0 | 1,143.1 | 1,199.1 | 1,257.8 | 1,319.3 | 1,383.9 |
| Inventories, % | 5.06 | 42.26 | 5.36 | 5.47 | 0 | 11.63 | 11.63 | 11.63 | 11.63 | 11.63 |
| Accounts Payable | 943.0 | 418.0 | 572.0 | 657.0 | 701.0 | 794.9 | 833.8 | 874.6 | 917.4 | 962.3 |
| Accounts Payable, % | 9.64 | 7.95 | 7.8 | 7.56 | 7.48 | 8.09 | 8.09 | 8.09 | 8.09 | 8.09 |
| Capital Expenditure | -13,938.0 | -5,640.0 | -7,225.0 | -10,746.0 | -9,702.0 | -9,799.9 | -10,279.5 | -10,782.6 | -11,310.3 | -11,863.8 |
| Capital Expenditure, % | -142.53 | -107.27 | -98.49 | -123.73 | -103.53 | -99.7 | -99.7 | -99.7 | -99.7 | -99.7 |
| Tax Rate, % | -115.38 | -115.38 | -115.38 | -115.38 | -115.38 | -115.38 | -115.38 | -115.38 | -115.38 | -115.38 |
| EBITAT | -2,980.8 | -1,212.5 | 293.1 | 2,441.5 | 2,311.1 | 414.9 | 435.2 | 456.5 | 478.8 | 502.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -15,316.8 | -5,557.5 | -4,128.9 | -7,577.5 | -4,517.9 | -8,079.7 | -7,307.0 | -7,664.6 | -8,039.7 | -8,433.2 |
| WACC, % | 0.87444 | 4.38 | 3.11 | 4.38 | 5.05 | 3.56 | 3.56 | 3.56 | 3.56 | 3.56 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -35,586.8 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | -8,518 | |||||||||
| Terminal Value | -332,811 | |||||||||
| Present Terminal Value | -279,417 | |||||||||
| Enterprise Value | -315,004 | |||||||||
| Net Debt | 17,069 | |||||||||
| Equity Value | -332,073 | |||||||||
| Diluted Shares Outstanding, MM | 326 | |||||||||
| Equity Value Per Share | -1,018.63 |
What You Will Get
- Real HTZ Financial Data: Pre-filled with Hertz’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 Hertz’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
- Comprehensive Hertz Financials: Access reliable pre-loaded historical data and future forecasts for Hertz Global Holdings, Inc. (HTZ).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries for clear visualization of your valuation outcomes.
- Suitable for All Skill Levels: An intuitive design crafted for investors, financial officers, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based HTZ DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Hertz's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one solution.
- Customizable Inputs: Modify yellow-highlighted cells to explore different scenarios.
- Detailed Insights: Automatically computes Hertz’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants.
Who Should Use This Product?
- Finance Students: Understand the intricacies of the car rental market and apply valuation techniques using real data from Hertz Global Holdings, Inc. (HTZ).
- Academics: Integrate industry-specific models into your research or teaching related to transportation and logistics.
- Investors: Evaluate your investment strategies and analyze valuation outcomes for Hertz Global Holdings, Inc. (HTZ) stock.
- Analysts: Enhance your analysis process with a tailored, user-friendly DCF model specific to the car rental industry.
- Small Business Owners: Discover how major players like Hertz Global Holdings, Inc. (HTZ) are assessed and valued in the market.
What the Template Contains
- Historical Data: Includes Hertz's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Hertz's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Hertz's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.