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 28, 2020. 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, 2020 and 20193
Condensed Consolidated Balance Sheets as of June 30, 2020 and December 31, 20194
Condensed Consolidated Statements of Stockholders’ Equity for the Three and Six Months Ended June 30, 2020 and 20195
Condensed Consolidated Statements of Cash Flows for the Six Months Ended June 30, 2020 and 20196
Notes to Condensed Consolidated Financial Statements as of June 30, 20207

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

Table 2 after “(unaudited)”

Download CSV
Three Months EndedSix Months Ended
June 30,June 30,
2020201920202019
Operating revenues, excluding fuel surcharge revenues$1,986,130$1,996,266$4,031,824$3,851,608
Fuel surcharge revenues159,443265,381394,574499,666
Total operating revenues2,145,5732,261,6474,426,3984,351,274
Operating expenses:
Rents and purchased transportation1,034,2971,086,4162,170,4492,086,305

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

Table 3 after “(in thousands)”

Download CSV
June 30, 2020December 31, 2019
(unaudited)
ASSETS
Current assets:
Cash and cash equivalents$274,654$35,000
Trade accounts receivable, net950,6361,011,829
Prepaid expenses and other319,407434,470
Total current assets1,544,6971,481,299

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

Table 4 after “(unaudited)”

Download CSV
Three Months Ended June 30, 2019 and 2020
Additional
CommonPaid-inRetainedTreasuryStockholders’
StockCapitalEarningsStockEquity
Balances at March 31, 2019$1,671$351,881$4,279,764$(2,429,552)$2,203,764
Comprehensive income:
Net earnings--133,633-133,633
Cash dividend declared and paid ($0.26 per share)--(28,006)-(28,006)

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

Table 5 after “(unaudited)”

Download CSV
Six Months Ended June 30, 2019 and 2020
Additional
CommonPaid-inRetainedTreasuryStockholders’
StockCapitalEarningsStockEquity
Balances at December 31, 2018$1,671$340,457$4,188,435$(2,429,179)$2,101,384
Comprehensive income:
Net earnings--253,234-253,234
Cash dividend declared and paid ($0.52 per share)--(56,278)-(56,278)

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

Table 6 after “(unaudited)”

Download CSV
Six Months Ended
June 30,
20202019
Cash flows from operating activities:
Net earnings$226,532$253,234
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization260,393243,924
Noncash lease expense23,55318,230

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

Table 7 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,
2020201920202019
Restricted share units:
Pretax compensation expense$12,429$10,892$27,108$20,634
Tax benefit3,1822,7236,9405,158
Restricted share unit expense, net of tax$9,247$8,169$20,168$15,476
Performance share units:
Pretax compensation expense$3,573$3,840$6,957$7,670

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

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

Download CSV
June 30, 2020December 31, 2019
Senior notes1,307.01,295.7

Table 9 after “). The following are assets and liabilities measured at fair value on a recurring basis (in millions):”

Download CSV
Asset/(Liability) Balance
June 30, 2020December 31, 2019Input Level
Trading investments$19.6$20.41
Interest rate swap$15.1$4.82
Senior notes, net of unamortized discount and debt issuance costs$(364.0)$(353.1)2

Table 10 after “move by rail. All transactions between reporting segments are eliminated in consolidation. Our customers are geographically dispersed across”

Download CSV
Assets (Excludes intercompany accounts)
June 30, 2020December 31, 2019
JBI$2,353$2,217
DCS1,4861,445
ICS196208
FMS417432
JBT259241
Other (includes corporate)843928

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

Table 11 after “move by rail. All transactions between reporting segments are eliminated in consolidation. Our customers are geographically dispersed across”

Download CSV
Operating Revenues
Three Months Ended June 30,Six Months Ended June 30,
2020201920202019
JBI$1,065$1,150$2,215$2,238
DCS5335371,0751,029
ICS304334640635
FMS140143293253
JBT108100213201

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

Table 12 after “11”

Download CSV
Operation Income
Three Months Ended June 30,Six Months Ended June 30,
2020201920202019
JBI$107.0$124.4$209.2$227.7
DCS83.176.3156.0126.3
ICS(13.1)(0.6)(32.0)6.4
FMS(5.2)(15.8)(8.5)(15.6)
JBT3.58.95.316.1

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

Table 13 after “11”

Download CSV
Depreciation and Amortization Expense
Three Months Ended June 30,Six Months Ended June 30,
2020201920202019
JBI$46.8$44.8$93.2$89.1
DCS55.653.5111.9104.5
ICS0.30.90.61.8
FMS8.28.016.414.4
JBT8.68.416.817.2

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

Table 14 after “9”

Download CSV
Summary of Operating Segment Results For the Three Months Ended June 30, (in millions)
Operating RevenuesOperating Income
2020201920202019
JBI$1,065$1,150$107.0$124.4
DCS53353783.176.3
ICS304334(13.1)(0.6)
FMS140143(5.2)(15.8)
JBT1081003.58.9

First 8 of 12 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
Three Months Ended June 30,
Dollar Amounts as a Percentage of Total Operating RevenuesPercentage Change of Dollar Amounts Between Quarters
202020192020 vs. 2019
Total operating revenues100.0%100.0%(5.1)%
Operating expenses:
Rents and purchased transportation48.248.0(4.8)
Salaries, wages and employee benefits25.823.73.6
Depreciation and amortization6.15.55.1

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

Table 16 after “9”

Download CSV
Summary of Operating Segment Results For the Six Months Ended June 30, (in millions)
Operating RevenuesOperating Income
2020201920202019
JBI$2,215$2,238$209.2$227.7
DCS1,0751,029156.0126.3
ICS640635(32.0)6.4
FMS293253(8.5)(15.6)
JBT2132015.316.1

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

Table 17 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
202020192020 vs. 2019
Total operating revenues100.0%100.0%1.7%
Operating expenses:
Rents and purchased transportation49.047.94.0
Salaries, wages and employee benefits25.524.27.3
Depreciation and amortization5.95.66.8

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

Table 18 after “Debt and Liquidity Data”

Download CSV
June 30, 2020December 31, 2019June 30, 2019
Working capital ratio1.591.431.30
Total debt (millions)$1,307.0$1,295.7$1,372.1
Total debt to equity0.550.570.64
Total debt as a percentage of total capital35%36%39%

Table 19 after “The following table summarizes our expected obligations and commitments as of June 30, 2020 (in millions):”

Download CSV
TotalOne Year Or LessOne to Three YearsThree to Five YearsAfter Five Years
Operating leases$148.5$47.7$61.0$22.6$17.2
Debt obligations1,300.0-350.0250.0700.0
Interest payments on debt (1)203.142.980.661.518.1
Commitments to acquire revenue equipment and facilities828.4389.9438.5--
Total$2,480.0$480.5$930.1$334.1$735.3

Table 20 after “Index to Exhibits”

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
101.INSInline XBRL Instance Document - the instance document does not appear in the Interactive Data File because its XBRL tags are embedded within the Inline XBRL document

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