← 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 ↗
| | 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 2017 | 3 |
| Condensed Consolidated Balance Sheets as of June 30, 2018 and December 31, 2017 | 4 |
| Condensed Consolidated Statements of Cash Flows for the Six Months Ended June 30, 2018 and 2017 | 5 |
| Notes to Condensed Consolidated Financial Statements as of June 30, 2018 | 6 |
| Item 2. | Management's Discussion and Analysis of Financial Condition and Results of Operations | 12 |
First 8 of 20 rows. The CSV has all of them.
| Three Months Ended | | Six Months Ended | | | | |
| June 30, | | June 30, | | | | |
| 2018 | | 2017 | | 2018 | 2017 | |
| Operating revenues, excluding fuel surcharge revenues | $1,874,388 | | $1,551,051 | | $3,587,321 | $3,012,820 | |
| Fuel surcharge revenues | | 264,639 | | 175,864 | | 499,951 | 343,253 |
| Total operating revenues | | 2,139,027 | | 1,726,915 | | 4,087,272 | 3,356,073 |
| Operating expenses: | | | | | | | |
| Rents and purchased transportation | | 1,073,164 | | 871,122 | | 2,038,057 | 1,677,562 |
First 8 of 27 rows. The CSV has all of them.
| June 30, 2018 | | December 31, 2017 | |
| (unaudited) | | | |
| ASSETS | | | | |
| Current assets: | | | | |
| Cash and cash equivalents | $15,191 | | $14,612 | |
| Trade accounts receivable, net | | 1,019,622 | | 920,767 |
| Prepaid expenses and other | | 272,608 | | 403,349 |
| Total current assets | | 1,307,421 | | 1,338,728 |
First 8 of 26 rows. The CSV has all of them.
| Six Months Ended | | | |
| June 30, | | | |
| 2018 | | 2017 | |
| 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 amortization | | 213,006 | | 185,238 |
| Share-based compensation | | 26,001 | | 23,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, | | | | |
| 2018 | | 2017 | | 2018 | 2017 | |
| Restricted share units: | | | | | | | |
| Pretax compensation expense | $9,844 | | $8,873 | | $18,435 | $17,010 | |
| Tax benefit | | 2,559 | | 3,314 | | 4,793 | 5,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, 2018 | | December 31, 2017 | |
| Senior revolving line of credit | $169.6 | | $241.4 | |
| Senior notes | | 835.4 | | 844.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, 2018 | December 31, 2017 | Input Level |
| Trading investments | $16.7 | $16.4 | 1 |
| 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, 2018 | | December 31, 2017 | |
| JBI | $2,163 | | $2,108 | |
| DCS | | 1,370 | | 1,182 |
| ICS | | 228 | | 204 |
| JBT | | 278 | | 283 |
| Other (includes corporate) | | 550 | | 688 |
| 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, | | | | |
| 2018 | | 2017 | | 2018 | 2017 | |
| JBI | $1,165 | | $1,001 | | $2,235 | $1,939 | |
| DCS | | 530 | | 412 | | 1,024 | 804 |
| ICS | | 347 | | 222 | | 643 | 432 |
| JBT | | 101 | | 95 | | 194 | 188 |
| Subtotal | | 2,143 | | 1,730 | | 4,096 | 3,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, | | | | |
| 2018 | | 2017 | | 2018 | 2017 | |
| JBI | $134.0 | | $109.7 | | $248.2 | $205.0 | |
| DCS | | 58.5 | | 48.6 | | 99.0 | 93.3 |
| ICS | | 14.9 | | (0.2) | | 23.8 | 4.2 |
| JBT | | 7.5 | | 5.5 | | 12.6 | 10.5 |
| Other (includes corporate) | | (0.1) | | - | | - | - |
First 8 of 9 rows. The CSV has all of them.
| Depreciation and Amortization Expense | | | | | | |
| Three Months Ended June 30, | | Six Months Ended June 30, | | | | |
| 2018 | | 2017 | | 2018 | 2017 | |
| JBI | $42.4 | | $40.4 | | $85.0 | $80.8 | |
| DCS | | 49.2 | | 37.2 | | 96.1 | 73.6 |
| ICS | | 0.3 | | 0.3 | | 0.8 | 0.6 |
| JBT | | 10.0 | | 10.3 | | 20.2 | 20.5 |
| Other (includes corporate) | | 5.5 | | 4.9 | | 10.9 | 9.7 |
First 8 of 9 rows. The CSV has all of them.
| Summary of Operating Segment Results For the Three Months Ended June 30, (in millions) | | | | | | |
| Operating Revenues | | Operating Income | | | | |
| 2018 | | 2017 | | 2018 | 2017 | |
| JBI | $1,165 | | $1,001 | | $134.0 | $109.7 | |
| DCS | | 530 | | 412 | | 58.5 | 48.6 |
| ICS | | 347 | | 222 | | 14.9 | (0.2) |
| JBT | | 101 | | 95 | | 7.5 | 5.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 Revenues | | Percentage Change of Dollar Amounts Between Quarters | | | |
| 2018 | | 2017 | | 2018 vs. 2017 | |
| Total operating revenues | | 100.0% | | 100.0% | | 23.9% |
| Operating expenses: | | | | | | |
| Rents and purchased transportation | | 50.2 | | 50.4 | | 23.2 |
| Salaries, wages and employee benefits | | 21.8 | | 22.6 | | 19.4 |
| Fuel and fuel taxes | | 5.4 | | 4.6 | | 46.1 |
First 8 of 20 rows. The CSV has all of them.
| Summary of Operating Segment Results For the Six Months Ended June 30, (in millions) | | | | | | |
| Operating Revenues | | Operating Income | | | | |
| 2018 | | 2017 | | 2018 | 2017 | |
| JBI | $2,235 | | $1,939 | | $248.2 | $205.0 | |
| DCS | | 1,024 | | 804 | | 99.0 | 93.3 |
| ICS | | 643 | | 432 | | 23.8 | 4.2 |
| JBT | | 194 | | 188 | | 12.6 | 10.5 |
| Subtotal | | 4,096 | | 3,363 | | 383.6 | 313.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 Revenues | | Percentage Change of Dollar Amounts Between Periods | | | |
| 2018 | | 2017 | | 2018 vs. 2017 | |
| Total operating revenues | | 100.0% | | 100.0% | | 21.8% |
| Operating expenses: | | | | | | |
| Rents and purchased transportation | | 49.9 | | 50.0 | | 21.5 |
| Salaries, wages and employee benefits | | 22.4 | | 22.9 | | 18.9 |
| Fuel and fuel taxes | | 5.5 | | 4.8 | | 39.9 |
First 8 of 20 rows. The CSV has all of them.
| June 30, 2018 | | December 31, 2017 | | | June 30, 2017 | | |
| Working capital ratio | | 1.13 | | | 1.45 | | | 1.49 |
| Current portion of long-term debt (millions) | $249.4 | | | - | | | - | |
| Total debt (millions) | $755.6 | | $1,085.6 | | | $943.2 | | |
| Total debt to equity | | 0.49 | | | 0.59 | | | 0.67 |
| Total debt as a percentage of total capital | | 33% | | | 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
| Total | | One Year Or Less | | One to Three Years | Three to Five Years | After Five Years | | |
| Operating leases | $92.0 | | $31.9 | | $41.0 | $16.4 | $2.7 | | |
| Debt obligations | | 1,020.2 | | 250.0 | | 170.2 | | 350.0 | 250.0 |
| Interest payments on debt (1) | | 129.1 | | 34.7 | | 52.8 | | 34.4 | 7.2 |
| Commitments to acquire revenue equipment and facilities | | 853.9 | | 336.1 | | 517.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
| Period | Number of Common Shares Purchased | | Average Price Paid Per Common Share Purchased | | | Total 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, 2018 | | 420,145 | | $119.07 | | | 420,145 | | $471 | |
| May 1 through May 31, 2018 | | - | | | - | | | - | | 471 |
| June 1 through June 30, 2018 | | - | | | - | | | - | | 471 |
| Total | | 420,145 | | $119.07 | | | 420,145 | | $471 | |
| Exhibit Number | Exhibits | |
| 3.1 | | Amended 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.2 | | Amended 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.1 | | Rule 13a-14(a)/15d-14(a) Certification |
| 31.2 | | Rule 13a-14(a)/15d-14(a) Certification |
| 32.1 | | Section 1350 Certification |
| 32.2 | | Section 1350 Certification |
| 101.INS | XBRL Instance Document |
| 101.SCH | XBRL Taxonomy Extension Schema Document |
| 101.CAL | XBRL Taxonomy Extension Calculation Linkbase Document |
| 101.DEF | XBRL Taxonomy Extension Definition Linkbase Document |
| 101.LAB | XBRL Taxonomy Extension Label Linkbase Document |
| 101.PRE | XBRL Taxonomy Extension Presentation Linkbase Document |