|
Hub Group, Inc. (HUBG) DCF Valoración
US | Industrials | Integrated Freight & Logistics | NASDAQ
|
- ✓ 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
Hub Group, Inc. (HUBG) Bundle
¡Descubra el verdadero potencial de Hub Group, Inc. (HUBG) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los diferentes factores influyen en la valoración del grupo HUB, todo dentro de una plantilla de Excel conveniente.
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 | 3,668.1 | 3,495.6 | 4,232.4 | 5,340.5 | 4,202.6 | 4,425.8 | 4,660.9 | 4,908.5 | 5,169.3 | 5,443.9 |
| Revenue Growth, % | 0 | -4.7 | 21.08 | 26.18 | -21.31 | 5.31 | 5.31 | 5.31 | 5.31 | 5.31 |
| EBITDA | 274.1 | 230.5 | 349.9 | 610.1 | 391.9 | 381.4 | 401.6 | 423.0 | 445.4 | 469.1 |
| EBITDA, % | 7.47 | 6.59 | 8.27 | 11.42 | 9.32 | 8.62 | 8.62 | 8.62 | 8.62 | 8.62 |
| Depreciation | 116.9 | 123.7 | 130.6 | 153.7 | 184.4 | 151.2 | 159.2 | 167.7 | 176.6 | 185.9 |
| Depreciation, % | 3.19 | 3.54 | 3.09 | 2.88 | 4.39 | 3.42 | 3.42 | 3.42 | 3.42 | 3.42 |
| EBIT | 157.2 | 106.8 | 219.3 | 456.4 | 207.4 | 230.2 | 242.4 | 255.3 | 268.9 | 283.1 |
| EBIT, % | 4.29 | 3.06 | 5.18 | 8.55 | 4.94 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 |
| Total Cash | 168.7 | 124.5 | 159.8 | 286.6 | 187.3 | 192.6 | 202.8 | 213.6 | 225.0 | 236.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 446.8 | 520.2 | 704.5 | 720.2 | 603.6 | 633.4 | 667.0 | 702.5 | 739.8 | 779.1 |
| Account Receivables, % | 12.18 | 14.88 | 16.65 | 13.48 | 14.36 | 14.31 | 14.31 | 14.31 | 14.31 | 14.31 |
| Inventories | .6 | 1.3 | 2.2 | 17.0 | .0 | 3.8 | 4.0 | 4.2 | 4.4 | 4.6 |
| Inventories, % | 0.01717502 | 0.03821899 | 0.05176753 | 0.31808 | 0 | 0.08504819 | 0.08504819 | 0.08504819 | 0.08504819 | 0.08504819 |
| Accounts Payable | 257.2 | 285.3 | 424.9 | 344.8 | 349.4 | 353.9 | 372.7 | 392.5 | 413.4 | 435.3 |
| Accounts Payable, % | 7.01 | 8.16 | 10.04 | 6.46 | 8.31 | 8 | 8 | 8 | 8 | 8 |
| Capital Expenditure | -94.8 | -115.3 | -133.0 | -219.1 | -140.1 | -145.7 | -153.5 | -161.6 | -170.2 | -179.2 |
| Capital Expenditure, % | -2.59 | -3.3 | -3.14 | -4.1 | -3.33 | -3.29 | -3.29 | -3.29 | -3.29 | -3.29 |
| Tax Rate, % | 19.92 | 19.92 | 19.92 | 19.92 | 19.92 | 19.92 | 19.92 | 19.92 | 19.92 | 19.92 |
| EBITAT | 117.1 | 81.8 | 162.8 | 348.1 | 166.1 | 175.7 | 185.0 | 194.9 | 205.2 | 216.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -51.0 | 44.0 | 115.0 | 172.1 | 348.7 | 152.1 | 175.7 | 185.1 | 194.9 | 205.3 |
| WACC, % | 7.74 | 7.76 | 7.74 | 7.76 | 7.79 | 7.76 | 7.76 | 7.76 | 7.76 | 7.76 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 726.2 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 206 | |||||||||
| Terminal Value | 2,842 | |||||||||
| Present Terminal Value | 1,956 | |||||||||
| Enterprise Value | 2,682 | |||||||||
| Net Debt | 388 | |||||||||
| Equity Value | 2,294 | |||||||||
| Diluted Shares Outstanding, MM | 64 | |||||||||
| Equity Value Per Share | 35.87 |
What You Will Get
- Real Hub Group Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Hub Group’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive Financial Data: Hub Group, Inc.'s historical financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe Hub Group's intrinsic value recalculating instantly.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- 1. Download the Template: Obtain and open the Excel file containing Hub Group, Inc.'s (HUBG) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Different Scenarios: Evaluate various forecasts to understand different valuation results.
- 5. Present with Assurance: Deliver expert valuation insights to bolster your decision-making process.
Why Choose This Calculator for Hub Group, Inc. (HUBG)?
- Designed for Industry Experts: A sophisticated tool favored by logistics analysts, CFOs, and supply chain consultants.
- Accurate Data: Hub Group’s historical and forecasted financials integrated for precision.
- Flexible Scenario Analysis: Effortlessly model various logistics forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential performance metrics.
- User-Friendly Interface: Detailed, step-by-step guidance ensures a smooth calculation process.
Who Should Use Hub Group, Inc. (HUBG)?
- Logistics Students: Understand supply chain management and apply concepts using real-world data.
- Researchers: Utilize industry-specific models in academic studies or publications.
- Investors: Evaluate your investment strategies and analyze the performance of Hub Group, Inc. (HUBG).
- Industry Analysts: Enhance your analysis with a tailored, ready-to-use financial model.
- Entrepreneurs: Learn how large logistics firms like Hub Group, Inc. (HUBG) are assessed in the market.
What the Template Contains
- Preloaded HUBG 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.