|
J.B. Hunt Transport Services, Inc. (JBHT) Valoración de DCF
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
J.B. Hunt Transport Services, Inc. (JBHT) Bundle
¡Agilice su análisis y aumente la precisión con nuestra calculadora DCF (JBHT)! Con datos reales de J.B. Hunt Transport Services, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, evaluar y valor (JBHT) al igual que un inversor experimentado.
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,165.3 | 9,636.6 | 12,168.3 | 14,814.0 | 12,829.7 | 14,105.0 | 15,507.1 | 17,048.6 | 18,743.3 | 20,606.5 |
Revenue Growth, % | 0 | 5.14 | 26.27 | 21.74 | -13.39 | 9.94 | 9.94 | 9.94 | 9.94 | 9.94 |
EBITDA | 1,274.2 | 713.1 | 1,045.5 | 1,331.6 | 1,738.8 | 1,479.2 | 1,626.3 | 1,787.9 | 1,965.7 | 2,161.1 |
EBITDA, % | 13.9 | 7.4 | 8.59 | 8.99 | 13.55 | 10.49 | 10.49 | 10.49 | 10.49 | 10.49 |
Depreciation | 538.7 | 573.4 | 612.2 | 728.3 | 738.0 | 776.5 | 853.7 | 938.6 | 1,031.9 | 1,134.5 |
Depreciation, % | 5.88 | 5.95 | 5.03 | 4.92 | 5.75 | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 |
EBIT | 735.6 | 139.8 | 433.3 | 603.2 | 1,000.8 | 702.7 | 772.6 | 849.4 | 933.8 | 1,026.6 |
EBIT, % | 8.03 | 1.45 | 3.56 | 4.07 | 7.8 | 4.98 | 4.98 | 4.98 | 4.98 | 4.98 |
Total Cash | 35.0 | 313.3 | 355.5 | 51.9 | 53.3 | 206.5 | 227.1 | 249.6 | 274.5 | 301.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,011.8 | 1,124.4 | 1,506.6 | 1,528.1 | 1,689.9 | 1,652.4 | 1,816.7 | 1,997.3 | 2,195.8 | 2,414.1 |
Account Receivables, % | 11.04 | 11.67 | 12.38 | 10.32 | 13.17 | 11.72 | 11.72 | 11.72 | 11.72 | 11.72 |
Inventories | 21.1 | 23.8 | 25.0 | 40.6 | 42.2 | 36.3 | 39.9 | 43.8 | 48.2 | 53.0 |
Inventories, % | 0.23028 | 0.24702 | 0.20571 | 0.27408 | 0.32882 | 0.25718 | 0.25718 | 0.25718 | 0.25718 | 0.25718 |
Accounts Payable | 602.6 | 587.5 | 772.7 | 798.8 | 737.4 | 850.8 | 935.4 | 1,028.4 | 1,130.6 | 1,243.0 |
Accounts Payable, % | 6.57 | 6.1 | 6.35 | 5.39 | 5.75 | 6.03 | 6.03 | 6.03 | 6.03 | 6.03 |
Capital Expenditure | -854.1 | -738.5 | -947.6 | -1,540.8 | -1,862.4 | -1,401.7 | -1,541.0 | -1,694.2 | -1,862.6 | -2,047.8 |
Capital Expenditure, % | -9.32 | -7.66 | -7.79 | -10.4 | -14.52 | -9.94 | -9.94 | -9.94 | -9.94 | -9.94 |
Tax Rate, % | 22.1 | 22.1 | 22.1 | 22.1 | 22.1 | 22.1 | 22.1 | 22.1 | 22.1 | 22.1 |
EBITAT | 557.8 | 106.2 | 329.7 | 456.3 | 779.6 | 536.1 | 589.4 | 648.0 | 712.4 | 783.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -188.0 | -189.4 | -203.8 | -367.1 | -569.6 | 67.8 | -181.2 | -199.2 | -219.0 | -240.8 |
WACC, % | 9.21 | 9.21 | 9.21 | 9.21 | 9.22 | 9.21 | 9.21 | 9.21 | 9.21 | 9.21 |
PV UFCF | ||||||||||
SUM PV UFCF | -551.7 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | -248 | |||||||||
Terminal Value | -3,993 | |||||||||
Present Terminal Value | -2,570 | |||||||||
Enterprise Value | -3,122 | |||||||||
Net Debt | 1,876 | |||||||||
Equity Value | -4,997 | |||||||||
Diluted Shares Outstanding, MM | 104 | |||||||||
Equity Value Per Share | -47.84 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real JBHT financials.
- Real-World Data: Historical data and forward-looking estimates (as shown in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly view the effects of your inputs on J.B. Hunt’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, with comprehensive step-by-step instructions.
Key Features
- Pre-Loaded Data: J.B. Hunt's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View J.B. Hunt's intrinsic value recalculated in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Download: Obtain the comprehensive Excel file containing J.B. Hunt's financial data.
- Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to suit your analysis.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and evaluate outcomes instantly.
- Make Decisions: Leverage the valuation results to inform your investment strategy for J.B. Hunt Transport Services, Inc. (JBHT).
Why Choose This Calculator for J.B. Hunt Transport Services, Inc. (JBHT)?
- All-in-One Solution: Combines DCF, WACC, and key financial ratios for comprehensive analysis.
- Flexible Inputs: Modify the yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes J.B. Hunt's intrinsic value and Net Present Value.
- Ready-to-Use Data: Historical and projected data provide reliable foundations for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Logistics Professionals: Develop comprehensive and accurate models for transportation and logistics analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights for J.B. Hunt Transport Services, Inc. (JBHT) to clients.
- Students and Educators: Utilize real-world data to learn and teach about financial modeling in the transportation sector.
- Industry Analysts: Gain insights into how transportation companies like J.B. Hunt are valued in the market.
What the Template Contains
- Preloaded JBHT 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.