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

21 tables with numbers, filed Oct 28, 2021. 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, 2021 and 20203
Condensed Consolidated Balance Sheets as of September 30, 2021 and December 31, 20204
Condensed Consolidated Statements of Stockholders’ Equity for the Three and Nine Months Ended September 30, 2021 and 20205
Condensed Consolidated Statements of Cash Flows for the Nine Months Ended September 30, 2021 and 20206
Notes to Condensed Consolidated Financial Statements as of September 30, 20217

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

Table 2 after “2”

Download CSV
Three Months EndedNine Months Ended
September 30,September 30,
2021202020212020
Operating revenues, excluding fuel surcharge revenues$2,813,939$2,296,053$7,808,954$6,327,876
Fuel surcharge revenues330,873176,470862,377571,045
Total operating revenues3,144,8122,472,5238,671,3316,898,921
Operating expenses:
Rents and purchased transportation1,667,2361,297,3334,557,7703,467,782

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

Table 3 after “3”

Download CSV
September 30, 2021December 31, 2020
ASSETS
Current assets:
Cash and cash equivalents$529,595$313,302
Trade accounts receivable, net1,442,9481,124,403
Prepaid expenses and other292,604404,412
Total current assets2,265,1471,842,117
Property and equipment, at cost6,350,1415,908,710

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

Table 4 after “4”

Download CSV
Three Months Ended September 30, 2020 and 2021
Additional
CommonPaid-inRetainedTreasuryStockholders’
StockCapitalEarningsStockEquity
Balances at June 30, 2020$1,671$402,653$4,762,295$(2,775,776)$2,390,843
Comprehensive income:
Net earnings--125,496-125,496
Cash dividend declared and paid ($0.27 per share)--(28,533)-(28,533)

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

Table 5 after “4”

Download CSV
Nine Months Ended September 30, 2020 and 2021
Additional
CommonPaid-inRetainedTreasuryStockholders’
StockCapitalEarningsStockEquity
Balances at December 31, 2019$1,671$374,049$4,592,938$(2,701,629)$2,267,029
Comprehensive income:
Net earnings--352,028-352,028
Cash dividend declared and paid ($0.81 per share)--(85,708)-(85,708)

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

Table 6 after “5”

Download CSV
Nine Months Ended
September 30,
20212020
Cash flows from operating activities:
Net earnings$518,597$352,028
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization415,839392,786
Noncash lease expense40,16034,110

First 8 of 40 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,
2021202020212020
Restricted share units:
Pretax compensation expense$11,677$11,250$34,669$38,358
Tax benefit2,9312,8808,7029,820
Restricted share unit expense, net of tax$8,746$8,370$25,967$28,538
Performance share units:
Pretax compensation expense$4,269$3,344$12,742$10,300

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, 2021December 31, 2020
Senior notes$1,299.6$1,305.4
Less current portion of long-term debt(354.7)-
Total long-term debt$944.9$1,305.4

Table 9 after “in millions):”

Download CSV
Asset/(Liability) Balance
September 30, 2021December 31, 2020Input Level
Trading investments$25.1$23.11
Interest rate swap$5.2$12.52
Senior notes, net of unamortized discount and debt issuance costs$(354.7)$(361.3)2

Table 10 after “A summary of certain segment information is presented below (in millions):”

Download CSV
Assets (Excludes intercompany accounts)
September 30, 2021December 31, 2020
JBI$2,798$2,426
DCS1,6611,482
ICS394301
FMS472486
JBT358286
Other (includes corporate)830947

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

Table 11 after “A summary of certain segment information is presented below (in millions):”

Download CSV
Operating Revenues
Three Months Ended September 30,Nine Months Ended September 30,
2021202020212020
JBI$1,413$1,211$3,879$3,426
DCS6655331,8661,628
ICS6664311,7991,071
FMS206182620475
JBT204109537322

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

Table 12 after “A summary of certain segment information is presented below (in millions):”

Download CSV
Operating Income/(Loss)
Three Months Ended September 30,Nine Months Ended September 30,
2021202020212020
JBI$165.1$108.4$407.2$317.7
DCS78.180.4231.5236.4
ICS14.7(18.3)25.1(50.3)
FMS1.32.120.5(6.5)
JBT14.72.939.08.2

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

Table 13 after “A summary of certain segment information is presented below (in millions):”

Download CSV
Depreciation and Amortization Expense
Three Months Ended September 30,Nine Months Ended September 30,
2021202020212020
JBI$48.9$47.4$147.5$140.7
DCS58.355.9173.6167.8
ICS0.20.30.60.9
FMS8.78.226.324.6
JBT9.18.826.825.6

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

Table 14 after “Comparison of Three Months Ended September 30, 2021 to Three Months Ended September 30, 2020”

Download CSV
Summary of Operating Segment Results For the Three Months Ended September 30, (in millions)
Operating RevenuesOperating Income/(Loss)
2021202020212020
JBI$1,413$1,211$165.1$108.4
DCS66555378.180.4
ICS66643114.7(18.3)
FMS2061821.32.1
JBT20410914.72.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 September 30,
Dollar Amounts as a Percentage of Total Operating RevenuesPercentage Change of Dollar Amounts Between Quarters
202120202021 vs. 2020
Total operating revenues100.0%100.0%27.2%
Operating expenses:
Rents and purchased transportation53.052.528.5
Salaries, wages and employee benefits22.624.019.8
Depreciation and amortization4.45.44.9

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

Table 16 after “Comparison of Nine Months Ended September 30, 2021 to Nine Months Ended September 30, 2020”

Download CSV
Summary of Operating Segment Results For the Nine Months Ended September 30, (in millions)
Operating RevenuesOperating Income/(Loss)
2021202020212020
JBI$3,879$3,426$407.2$317.7
DCS1,8661,628231.5236.4
ICS1,7991,07125.1(50.3)
FMS62047520.5(6.5)
JBT53732239.08.2

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
202120202021 vs. 2020
Total operating revenues100.0%100.0%25.7%
Operating expenses:
Rents and purchased transportation52.650.331.4
Salaries, wages and employee benefits23.025.015.9
Depreciation and amortization4.85.75.9

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

Table 18 after “Debt and Liquidity Data”

Download CSV
September 30, 2021December 31, 2020September 30, 2020
Working capital ratio1.381.701.58
Current portion of long-term debt (millions)$354.7$-$-
Total debt (millions)$1,299.6$1,305.4$1,303.4
Total debt to equity0.440.500.52
Total debt as a percentage of total capital31%33%34%

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

Download CSV
TotalOne Year Or LessOne to Three YearsThree to Five YearsAfter Five Years
Operating leases$194.4$58.2$69.2$27.5$39.5
Debt obligations1,300.0350.0250.0700.0-
Interest payments on debt (1)148.841.668.838.4-
Commitments to acquire revenue equipment and facilities2,371.81,291.31,080.5--
Total$4,015.0$1,741.1$1,468.5$765.9$39.5

Table 20 after “The following table summarizes purchases of our common stock during the three months ended September 30, 2021:”

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)
July 1 through July 31, 2021-$--$416
August 1 through August 31, 2021201,676175.20201,676381
September 1 through September 30, 202184,007178.5884,007366
Total285,683$176.20285,683$366

Table 21 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.2Second Amended and Restated Bylaws of J.B. Hunt Transport Services, Inc. dated October 21, 2021 (incorporated by reference from Exhibit 3.1 of the Company’s current report on Form 8-K, filed October 27, 2021)
22.1List of Guarantor Subsidiaries of J.B. Hunt Transport Services, Inc. (incorporated by reference from Exhibit 22.1 of the Company’s annual report on Form 10-K for the year ended December 31, 2020, filed February 23, 2021)
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

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