tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of JBHT

Tables in the 10-Q of HUNT J B TRANSPORT SERVICES INC

20 tables with numbers, filed Jul 27, 2018. Each one downloads as a CSV for Excel or Google Sheets, with the filing's address in the last row. Only the layout is tidied (a "$" or ")" in a cell of its own is joined to its number); no value is changed. Open the filing on sec.gov ↗

Table 1 after “Table of Contents”

Download CSV
Page
Part I. Financial Information
Item 1.Financial Statements
Condensed Consolidated Statements of Earnings for the Three and Six Months Ended June 30, 2018 and 20173
Condensed Consolidated Balance Sheets as of June 30, 2018 and December 31, 20174
Condensed Consolidated Statements of Cash Flows for the Six Months Ended June 30, 2018 and 20175
Notes to Condensed Consolidated Financial Statements as of June 30, 20186
Item 2.Management's Discussion and Analysis of Financial Condition and Results of Operations12

First 8 of 20 rows. The CSV has all of them.

Table 2 after “2”

Download CSV
Three Months EndedSix Months Ended
June 30,June 30,
2018201720182017
Operating revenues, excluding fuel surcharge revenues$1,874,388$1,551,051$3,587,321$3,012,820
Fuel surcharge revenues264,639175,864499,951343,253
Total operating revenues2,139,0271,726,9154,087,2723,356,073
Operating expenses:
Rents and purchased transportation1,073,164871,1222,038,0571,677,562

First 8 of 27 rows. The CSV has all of them.

Table 3 after “3”

Download CSV
June 30, 2018December 31, 2017
(unaudited)
ASSETS
Current assets:
Cash and cash equivalents$15,191$14,612
Trade accounts receivable, net1,019,622920,767
Prepaid expenses and other272,608403,349
Total current assets1,307,4211,338,728

First 8 of 26 rows. The CSV has all of them.

Table 4 after “4”

Download CSV
Six Months Ended
June 30,
20182017
Cash flows from operating activities:
Net earnings$269,794$200,571
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization213,006185,238
Share-based compensation26,00123,110

First 8 of 39 rows. The CSV has all of them.

Table 5 after “The following table summarizes the components of our share-based compensation program expense (in thousands):”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
Restricted share units:
Pretax compensation expense$9,844$8,873$18,435$17,010
Tax benefit2,5593,3144,7935,596
Restricted share unit expense, net of tax$7,285$5,559$13,642$11,414
Performance share units:
Pretax compensation expense$4,121$3,067$7,566$6,100

First 8 of 10 rows. The CSV has all of them.

Table 6 after “Outstanding borrowings, net of unamortized discount, unamortized debt issuance cost, and fair value swap, under our current financing arrang”

Download CSV
June 30, 2018December 31, 2017
Senior revolving line of credit$169.6$241.4
Senior notes835.4844.2
Less current portion of long-term debt(249.4)-
Total long-term debt$755.6$1,085.6

Table 7 after “Our assets and liabilities measured at fair value are based on valuation techniques which consider prices and other relevant information gen”

Download CSV
Asset/(Liability) Balance
June 30, 2018December 31, 2017Input Level
Trading investments$16.7$16.41
Interest rate swaps$(10.8)$(1.4)2
Senior notes, net of unamortized discount and debt issuance costs$(586.7)$(595.6)2

Table 8 after “, of our Annual Report (Form 10-K) for the year ended December 31, 2017. A summary of certain segment information is presented below (in mil”

Download CSV
Assets (Excludes intercompany accounts) As of
June 30, 2018December 31, 2017
JBI$2,163$2,108
DCS1,3701,182
ICS228204
JBT278283
Other (includes corporate)550688
Total$4,589$4,465

Table 9 after “, of our Annual Report (Form 10-K) for the year ended December 31, 2017. A summary of certain segment information is presented below (in mil”

Download CSV
Operating Revenues
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
JBI$1,165$1,001$2,235$1,939
DCS5304121,024804
ICS347222643432
JBT10195194188
Subtotal2,1431,7304,0963,363

First 8 of 10 rows. The CSV has all of them.

Table 10 after “, of our Annual Report (Form 10-K) for the year ended December 31, 2017. A summary of certain segment information is presented below (in mil”

Download CSV
Operating Income
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
JBI$134.0$109.7$248.2$205.0
DCS58.548.699.093.3
ICS14.9(0.2)23.84.2
JBT7.55.512.610.5
Other (includes corporate)(0.1)---

First 8 of 9 rows. The CSV has all of them.

Table 11 after “11”

Download CSV
Depreciation and Amortization Expense
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
JBI$42.4$40.4$85.0$80.8
DCS49.237.296.173.6
ICS0.30.30.80.6
JBT10.010.320.220.5
Other (includes corporate)5.54.910.99.7

First 8 of 9 rows. The CSV has all of them.

Table 12 after “7”

Download CSV
Summary of Operating Segment Results For the Three Months Ended June 30, (in millions)
Operating RevenuesOperating Income
2018201720182017
JBI$1,165$1,001$134.0$109.7
DCS53041258.548.6
ICS34722214.9(0.2)
JBT101957.55.5
Other (includes corporate)--(0.1)-

First 8 of 11 rows. The CSV has all of them.

Table 13 after “The following table sets forth items in our Condensed Consolidated Statements of Earnings as a percentage of operating revenues and the perc”

Download CSV
Three Months Ended June 30,
Dollar Amounts as a Percentage of Total Operating RevenuesPercentage Change of Dollar Amounts Between Quarters
201820172018 vs. 2017
Total operating revenues100.0%100.0%23.9%
Operating expenses:
Rents and purchased transportation50.250.423.2
Salaries, wages and employee benefits21.822.619.4
Fuel and fuel taxes5.44.646.1

First 8 of 20 rows. The CSV has all of them.

Table 14 after “7”

Download CSV
Summary of Operating Segment Results For the Six Months Ended June 30, (in millions)
Operating RevenuesOperating Income
2018201720182017
JBI$2,235$1,939$248.2$205.0
DCS1,02480499.093.3
ICS64343223.84.2
JBT19418812.610.5
Subtotal4,0963,363383.6313.0

First 8 of 10 rows. The CSV has all of them.

Table 15 after “The following table sets forth items in our Condensed Consolidated Statements of Earnings as a percentage of operating revenues and the perc”

Download CSV
Six Months Ended June 30,
Dollar Amounts as a Percentage of Total Operating RevenuesPercentage Change of Dollar Amounts Between Periods
201820172018 vs. 2017
Total operating revenues100.0%100.0%21.8%
Operating expenses:
Rents and purchased transportation49.950.021.5
Salaries, wages and employee benefits22.422.918.9
Fuel and fuel taxes5.54.839.9

First 8 of 20 rows. The CSV has all of them.

Table 16 after “Debt and Liquidity Data”

Download CSV
June 30, 2018December 31, 2017June 30, 2017
Working capital ratio1.131.451.49
Current portion of long-term debt (millions)$249.4--
Total debt (millions)$755.6$1,085.6$943.2
Total debt to equity0.490.590.67
Total debt as a percentage of total capital33%37%40%

Table 17 after “We believe our liquid assets, cash generated from operations and revolving line of credit will provide sufficient funds for our operating an”

Download CSV
TotalOne Year Or LessOne to Three YearsThree to Five YearsAfter Five Years
Operating leases$92.0$31.9$41.0$16.4$2.7
Debt obligations1,020.2250.0170.2350.0250.0
Interest payments on debt (1)129.134.752.834.47.2
Commitments to acquire revenue equipment and facilities853.9336.1517.8--
Total$2,095.2$652.7$781.8$400.8$259.9

Table 18 after “The following table summarizes purchases of our common stock during the three months ended June 30, 2018:”

Download CSV
PeriodNumber of Common Shares PurchasedAverage Price Paid Per Common Share PurchasedTotal Number of Shares Purchased as Part of a Publicly Announced Plan (1)Maximum Dollar Amount of Shares That May Yet Be Purchased Under the Plan (in millions)
April 1 through April 30, 2018420,145$119.07420,145$471
May 1 through May 31, 2018---471
June 1 through June 30, 2018---471
Total420,145$119.07420,145$471

Table 19 after “22”

Download CSV
Exhibit NumberExhibits
3.1Amended and Restated Articles of Incorporation of J.B. Hunt Transport Services, Inc. dated May 19, 1988 (incorporated by reference from Exhibit 3.1 of the Company’s Quarterly Report on Form 10-Q for the period ended March 31, 2005, filed April 29, 2005)
3.2Amended and Restated Bylaws of J.B. Hunt Transport Services, Inc. dated April 23, 2015 (incorporated by reference from Exhibit 3.1 of the Company’s current report on Form 8-K, filed April 27, 2015)
31.1Rule 13a-14(a)/15d-14(a) Certification
31.2Rule 13a-14(a)/15d-14(a) Certification
32.1Section 1350 Certification
32.2Section 1350 Certification

Table 20 after “22”

Download CSV
101.INSXBRL Instance Document
101.SCHXBRL Taxonomy Extension Schema Document
101.CALXBRL Taxonomy Extension Calculation Linkbase Document
101.DEFXBRL Taxonomy Extension Definition Linkbase Document
101.LABXBRL Taxonomy Extension Label Linkbase Document
101.PREXBRL Taxonomy Extension Presentation Linkbase Document