← Filings of EXPD
Tables in the 10-Q of EXPEDITORS INTERNATIONAL OF WASHINGTON INC
18 tables with numbers, filed Nov 7, 2017. Each one downloads as an Excel file or a CSV (numbers are stored as numbers),
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 “(Unaudited)”
| September 30, 2017 | December 31, 2016 | |
| Current Assets: | | | |
| Cash and cash equivalents | $1,033,444 | | $974,435 |
| Accounts receivable, less allowance for doubtful accounts of $11,217 at September 30, 2017 and $9,247 at December 31, 2016 | 1,349,854 | | 1,190,130 |
| Other | 135,623 | | 54,014 |
| Total current assets | 2,518,921 | | 2,218,579 |
| Property and equipment, less accumulated depreciation and amortization of $413,219 at September 30, 2017 and $406,652 at December 31, 2016 | 513,070 | | 536,572 |
| Goodwill | 7,927 | | 7,927 |
First 8 of 27 rows. The download has all of them.
Table 2 after “(Unaudited)”
| Three months ended | Nine months ended | | | | |
| September 30, | September 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Revenues: | | | | | | |
| Airfreight services | $735,164 | | $621,566 | | $2,022,577 | $1,764,512 |
| Ocean freight and ocean services | 563,386 | | 495,460 | | 1,585,730 | 1,414,344 |
| Customs brokerage and other services | 503,616 | | 445,368 | | 1,411,270 | 1,277,174 |
| Total revenues | 1,802,166 | | 1,562,394 | | 5,019,577 | 4,456,030 |
First 8 of 33 rows. The download has all of them.
Table 3 after “(Unaudited)”
| Three months ended | Nine months ended | | | | |
| September 30, | September 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Net earnings | $120,606 | | $107,949 | | $322,928 | $321,435 |
| Other comprehensive income (loss), net of tax: | | | | | | |
| Foreign currency translation adjustments, net of tax of $4,128 and $202 for the three months ended September 30, 2017 and 2016 and $14,019 and $223 for the nine months ended September 30, 2017 and 2016 | 7,489 | | 260 | | 25,585 | (457) |
| Other comprehensive income (loss) | 7,489 | | 260 | | 25,585 | (457) |
| Comprehensive income | 128,095 | | 108,209 | | 348,513 | 320,978 |
First 8 of 10 rows. The download has all of them.
Table 4 after “(Unaudited)”
| Three months ended | Nine months ended | | | | |
| September 30, | September 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Operating Activities: | | | | | | |
| Net earnings | $120,606 | | $107,949 | | $322,928 | $321,435 |
| Adjustments to reconcile net earnings to net cash from operating activities: | | | | | | |
| Provision for losses on accounts receivable | 1,741 | | 1,321 | | 3,187 | 2,461 |
| Deferred income tax (benefit) expense | (28,854) | | (1,439) | | (16,000) | 2,342 |
First 8 of 32 rows. The download has all of them.
Table 5 after “Total stock compensation expense and the total related tax benefit recognized are as follows:”
| Three months ended | Nine months ended | | | | |
| September 30, | September 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Stock compensation expense | $11,210 | | $10,476 | | $39,036 | $34,264 |
| Recognized tax benefit | $2,311 | | $2,149 | | $8,187 | $5,928 |
Table 6 after “The following table reconciles the numerator and the denominator of the basic and diluted per share computations for earnings attributable t”
| Three months ended | | | | |
| September 30, | | | | |
| (Amounts in thousands, except per share amounts) | Net earningsattributable toshareholders | Weighted averageshares | | Earnings per share | |
| 2017 | | | | | |
| Basic earnings attributable to shareholders | $120,263 | | 179,416 | | $0.67 |
| Effect of dilutive potential common shares | — | | 2,372 | | — |
| Diluted earnings attributable to shareholders | $120,263 | | 181,788 | | $0.66 |
| 2016 | | | | | |
First 8 of 11 rows. The download has all of them.
Table 7 after “The following table reconciles the numerator and the denominator of the basic and diluted per share computations for earnings attributable t”
| Nine months ended | | | | |
| September 30, | | | | |
| (Amounts in thousands, except per share amounts) | Net earningsattributable toshareholders | Weighted averageshares | | Earnings per share | |
| 2017 | | | | | |
| Basic earnings attributable to shareholders | $322,378 | | 179,827 | | $1.79 |
| Effect of dilutive potential common shares | — | | 2,124 | | — |
| Diluted earnings attributable to shareholders | $322,378 | | 181,951 | | $1.77 |
| 2016 | | | | | |
First 8 of 11 rows. The download has all of them.
Table 8 after “The following potential common shares have been excluded from the computation of diluted earnings per share because the effect would have be”
| Three months ended | Nine months ended | | | | |
| September 30, | September 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Shares | 1 | | 8,646 | | 1,233 | 9,516 |
Table 9 after “are as follows:”
| Shareholders’equity | Noncontrollinginterest | | Totalequity | | |
| Balance at December 31, 2016 | $1,844,638 | | 2,575 | | | 1,847,213 |
| Exercise of stock options | 134,014 | | — | | | 134,014 |
| Issuance of shares under stock purchase plan | 28,767 | | — | | | 28,767 |
| Shares repurchased under provisions of stock repurchase plans | (340,736) | | — | | | (340,736) |
| Stock compensation expense | 39,036 | | — | | | 39,036 |
| Net earnings | 322,378 | | 550 | | | 322,928 |
| Other comprehensive income (loss) | 25,632 | | (47) | | | 25,585 |
First 8 of 20 rows. The download has all of them.
Table 10 after “Cash and cash equivalents consist of the following:”
| September 30, 2017 | December 31, 2016 | | | | |
| Cost | Fair Value | | Cost | Fair Value | |
| Cash and Cash Equivalents: | | | | | | |
| Cash and overnight deposits | $385,432 | | 385,432 | | 406,787 | 406,787 |
| Corporate commercial paper | 613,433 | | 613,825 | | 507,777 | 507,889 |
| Time deposits | 34,579 | | 34,579 | | 59,871 | 59,871 |
| Total cash and cash equivalents | $1,033,444 | | 1,033,836 | | 974,435 | 974,547 |
Table 11 after “. At September 30, 2017, future minimum annual lease payments under all noncancelable leases are as follows:”
| 2017 | $16,984 |
| 2018 | 65,813 |
| 2019 | 53,209 |
| 2020 | 41,565 |
| 2021 | 27,696 |
| Thereafter | 47,009 |
| $252,276 |
Table 12 after “Financial information regarding the Company’s operations by geographic area is as follows:”
| (in thousands) | UNITEDSTATES | OTHERNORTHAMERICA | | LATINAMERICA | NORTH ASIA | SOUTH ASIA | | EUROPE | MIDDLE EAST, AFRICA AND INDIA | ELIMI-NATIONS | | CONSOLI-DATED | | | |
| Three months ended September 30, 2017: | | | | | | | | | | | | | | | |
| Revenues from unaffiliated customers | $476,575 | | 65,544 | | 24,181 | | 686,915 | | 170,225 | | 273,606 | | 105,120 | — | 1,802,166 |
| Transfers between geographic areas | 26,888 | | 2,782 | | 3,679 | | 5,253 | | 5,681 | | 10,302 | | 5,318 | (59,903) | — |
| Total revenues | $503,463 | | 68,326 | | 27,860 | | 692,168 | | 175,906 | | 283,908 | | 110,438 | (59,903) | 1,802,166 |
| Net revenues1 | $257,030 | | 30,664 | | 14,710 | | 138,667 | | 41,411 | | 85,390 | | 29,956 | 1,314 | 599,142 |
| Operating income | $74,645 | | 9,215 | | 2,652 | | 72,070 | | 11,697 | | 11,124 | | 5,495 | (3) | 186,895 |
| Identifiable assets at period end | $1,636,293 | | 100,651 | | 52,238 | | 446,826 | | 143,893 | | 473,509 | | 212,210 | 3,261 | 3,068,881 |
First 8 of 21 rows. The download has all of them.
| (in thousands) | UNITED STATES | OTHER NORTH AMERICA | | LATIN AMERICA | NORTH ASIA | SOUTH ASIA | | EUROPE | MIDDLE EAST, AFRICA AND INDIA | ELIMI- NATIONS | | CONSOLI- DATED | | | |
| Nine months ended September 30, 2017: | | | | | | | | | | | | | | | |
| Revenues from unaffiliated customers | $1,354,811 | | 187,997 | | 69,747 | | 1,873,393 | | 475,163 | | 764,596 | | 293,870 | — | 5,019,577 |
| Transfers between geographic areas | 79,356 | | 8,246 | | 11,073 | | 15,139 | | 16,520 | | 29,288 | | 15,316 | (174,938) | — |
| Total revenues | $1,434,167 | | 196,243 | | 80,820 | | 1,888,532 | | 491,683 | | 793,884 | | 309,186 | (174,938) | 5,019,577 |
| Net revenues1 | $737,842 | | 84,630 | | 43,634 | | 371,459 | | 117,634 | | 242,244 | | 89,973 | 2,964 | 1,690,380 |
| Operating income | $191,256 | | 26,583 | | 8,349 | | 183,515 | | 37,434 | | 36,189 | | 17,928 | (5) | 501,249 |
| Identifiable assets at period end | $1,636,293 | | 100,651 | | 52,238 | | 446,826 | | 143,893 | | 473,509 | | 212,210 | 3,261 | 3,068,881 |
First 8 of 21 rows. The download has all of them.
Table 14 after “The following table presents the calculation of consolidated net revenues:”
| Three months ended | Nine months ended | | | | |
| September 30, | September 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Total revenues | $1,802,166 | | $1,562,394 | | $5,019,577 | $4,456,030 |
| Expenses: | | | | | | |
| Airfreight services | 547,595 | | 444,359 | | 1,490,417 | 1,236,555 |
| Ocean freight and ocean services | 411,061 | | 359,991 | | 1,163,051 | 1,006,710 |
| Customs brokerage and other services | 244,368 | | 212,785 | | 675,729 | 597,320 |
First 8 of 9 rows. The download has all of them.
Table 15 after “The table and the accompanying discussion and analysis should be read in conjunction with the condensed consolidated financial statements an”
| Three months ended September 30, | Nine months ended September 30, | | | | | | | | | | | | |
| 2017 | 2016 | | 2017 | | 2016 | | | | | | | | |
| Amount | Percentof netrevenues | | Amount | | Percentof netrevenues | Amount | | Percentof netrevenues | Amount | Percentof netrevenues | | | |
| (in thousands) | | | | | | | | | | | | | | |
| Airfreight services: | | | | | | | | | | | | | | |
| Revenues | $735,164 | | | | $621,566 | | | | $2,022,577 | | | $1,764,512 | | |
| Expenses | 547,595 | | | | 444,359 | | | | 1,490,417 | | | 1,236,555 | | |
| Net revenues | 187,569 | | 31% | | | 177,207 | | 32% | | 532,160 | | 31% | 527,957 | 33% |
First 8 of 28 rows. The download has all of them.
Table 16 after “At September 30, 2017, our contractual obligations are as follows:”
| | Payments due by period | | | | | | |
| In thousands | Total | | Less than1 year | 1 - 3years | | 3 - 5years | After 5 years | |
| Contractual Obligations: | | | | | | | | |
| Operating leases | $252,276 | | 77,266 | | 92,184 | | 49,135 | 33,691 |
| Unconditional purchase obligations | 62,481 | | 62,481 | | — | | — | — |
| Construction, equipment and technology purchase obligations | 33,445 | | 26,996 | | 6,449 | | — | — |
| Total contractual cash obligations | $348,202 | | 166,743 | | 98,633 | | 49,135 | 33,691 |
Table 17 after “ISSUER PURCHASES OF EQUITY SECURITIES”
| Period | Total number ofshares purchased | Average pricepaid per share | | Total number of sharespurchased as part ofpublicly announcedplans or programs | Maximum numberof shares that may yet bepurchased under theplans or programs | |
| July 1-31, 2017 | — | | $— | | — | 14,683,556 |
| August 1-31, 2017 | 1,552,335 | | 55.34 | | 1,552,335 | 13,101,686 |
| September 1-30, 2017 | 2,057,379 | | 56.80 | | 2,057,379 | 10,982,748 |
| Total | 3,609,714 | | $56.18 | | 3,609,714 | 10,982,748 |
Table 18 after “Exhibits required by Item 601 of Regulation S-K.”
| Exhibit Number | Description |
| 31.1 | Certification of Chief Executive Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002 |
| 31.2 | Certification of Chief Financial Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002 |
| 32 | Certification pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002 |
| 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 |
First 8 of 10 rows. The download has all of them.