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

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

Table 2 after “(unaudited)”

Download CSV
Three Months EndedNine Months Ended
September 30,September 30,
2020201920202019
Operating revenues, excluding fuel surcharge revenues$2,296,053$2,102,494$6,327,876$5,954,102
Fuel surcharge revenues176,470261,166571,045760,832
Total operating revenues2,472,5232,363,6606,898,9216,714,934
Operating expenses:
Rents and purchased transportation1,297,3331,196,3773,467,7823,282,682

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

Table 3 after “(in thousands)”

Download CSV
September 30, 2020December 31, 2019
(unaudited)
ASSETS
Current assets:
Cash and cash equivalents$318,549$35,000
Trade accounts receivable, net1,121,8251,011,829
Prepaid expenses and other288,224434,470
Total current assets1,728,5981,481,299

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

Table 4 after “(unaudited)”

Download CSV
Three Months Ended September 30, 2019 and 2020
Additional
CommonPaid-inRetainedTreasuryStockholders’
StockCapitalEarningsStockEquity
Balances at June 30, 2019$1,671$367,166$4,385,391$(2,618,872)$2,135,356
Comprehensive income:
Net earnings--118,410-118,410
Cash dividend declared and paid ($0.26 per share)--(27,809)-(27,809)

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

Table 5 after “(unaudited)”

Download CSV
Nine Months Ended September 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--371,644-371,644
Cash dividend declared and paid ($0.78 per share)--(84,087)-(84,087)

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

Table 6 after “(unaudited)”

Download CSV
Nine Months Ended
September 30,
20202019
Cash flows from operating activities:
Net earnings$352,028$371,644
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization392,786370,728
Noncash lease expense34,11028,731

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 September 30,Nine Months Ended September 30,
2020201920202019
Restricted share units:
Pretax compensation expense$11,250$10,309$38,358$30,942
Tax benefit2,8802,6609,8207,983
Restricted share unit expense, net of tax$8,370$7,649$28,538$22,959
Performance share units:
Pretax compensation expense$3,344$3,541$10,300$11,212

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 arrange”

Download CSV
September 30, 2020December 31, 2019
Senior notes1,303.41,295.7

Table 9 after “in millions):”

Download CSV
Asset/(Liability) Balance
September 30, 2020December 31, 2019Input Level
Trading investments$21.3$20.41
Interest rate swap$10.9$4.82
Senior notes, net of unamortized discount and debt issuance costs$(360.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)
September 2020December 31, 2019
JBI$2,462$2,217
DCS1,5291,445
ICS268208
FMS433432
JBT267241
Other (includes corporate)820928

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 September 30,Nine Months Ended September 30,
2020201920202019
JBI$1,211$1,240$3,426$3,477
DCS5535471,6281,576
ICS4313371,071972
FMS182149475402
JBT10994322296

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

Table 12 after “11”

Download CSV
Operating Income/(Loss)
Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
JBI$108.4$88.7$317.7$316.4
DCS80.476.4236.4202.7
ICS(18.3)(5.6)(50.3)0.8
FMS2.11.9(6.5)(13.7)
JBT2.96.68.222.7

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

Table 13 after “11”

Download CSV
Depreciation and Amortization Expense
Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
JBI$47.4$45.8$140.7$134.9
DCS55.954.9167.8159.4
ICS0.30.90.92.7
FMS8.28.224.622.6
JBT8.88.225.625.4

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 September 30, (in millions)
Operating RevenuesOperating Income/(Loss)
2020201920202019
JBI$1,211$1,240$108.4$88.7
DCS55354780.476.4
ICS431337(18.3)(5.6)
FMS1821492.11.9
JBT109942.96.6

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 September 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%4.6%
Operating expenses:
Rents and purchased transportation52.550.68.4
Salaries, wages and employee benefits24.023.57.1
Depreciation and amortization5.45.34.4

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

Table 16 after “9”

Download CSV
Summary of Operating Segment Results For the Nine Months Ended September 30, (in millions)
Operating RevenuesOperating Income/(Loss)
2020201920202019
JBI$3,426$3,477$317.7$316.4
DCS1,6281,576236.4202.7
ICS1,071972(50.3)0.8
FMS475402(6.5)(13.7)
JBT3222968.222.7

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
Nine Months Ended September 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%2.7%
Operating expenses:
Rents and purchased transportation50.348.95.6
Salaries, wages and employee benefits25.023.97.2
Depreciation and amortization5.75.55.9

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

Table 18 after “Debt and Liquidity Data”

Download CSV
September 30, 2020December 31, 2019September 30, 2019
Working capital ratio1.581.431.29
Total debt (millions)$1,303.4$1,295.7$1,293.3
Total debt to equity0.520.570.59
Total debt as a percentage of total capital34%36%37%

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

Download CSV
TotalOne Year Or LessOne to Three YearsThree to Five YearsAfter Five Years
Operating leases$139.5$46.3$57.7$19.2$16.3
Debt obligations1,300.0-350.0250.0700.0
Interest payments on debt (1)191.742.578.859.111.3
Commitments to acquire revenue equipment and facilities604.1222.5381.6--
Total$2,235.3$311.3$868.1$328.3$727.6

Table 20 after “24”

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.