J.B. Hunt Transport Services, Inc. (JBHT) DCF Valuation

J.B. Hunt Transport Services, Inc. (JBHT) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

J.B. Hunt Transport Services, Inc. (JBHT) 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:

Streamline your analysis and boost precision with our (JBHT) DCF Calculator! With real data from J.B. Hunt Transport Services, Inc. and customizable assumptions, this tool enables you to forecast, evaluate, and value (JBHT) just like a seasoned investor.


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
Account Receivables, % 11.04 11.67 12.38 10.32 13.17
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.

No products were found matching.