← Filings of EXPD
Tables in the 10-Q of EXPEDITORS INTERNATIONAL OF WASHINGTON INC
14 tables with numbers, filed May 9, 2018. 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)”
| March 31, 2018 | December 31, 2017 | |
| Current Assets: | | | |
| Cash and cash equivalents | $1,132,901 | | $1,051,099 |
| Accounts receivable, less allowance for doubtful accounts of $12,688 at March 31, 2018 and $12,858 at December 31, 2017 | 1,326,168 | | 1,414,741 |
| Deferred contract costs | 120,861 | | — |
| Other | 58,161 | | 75,612 |
| Total current assets | 2,638,091 | | 2,541,452 |
| Property and equipment, less accumulated depreciation and amortization of $433,280 at March 31, 2018 and $420,282 at December 31, 2017 | 531,068 | | 525,203 |
First 8 of 30 rows. The download has all of them.
Table 2 after “(Unaudited)”
| Three months ended | | |
| March 31, | | |
| 2018 | 2017 | |
| Revenues: | | | |
| Airfreight services | $731,227 | | $615,545 |
| Ocean freight and ocean services | 520,883 | | 493,759 |
| Customs brokerage and other services | 602,152 | | 435,828 |
| Total revenues | 1,854,262 | | 1,545,132 |
First 8 of 32 rows. The download has all of them.
Table 3 after “(Unaudited)”
| Three months ended | | |
| March 31, | | |
| 2018 | 2017 | |
| Net earnings | $136,200 | | $93,567 |
| Other comprehensive income, net of tax: | | | |
| Foreign currency translation adjustments, net of tax of $5,512 and $4,876 for the three months ended March 31, 2018 and 2017 | 8,851 | | 8,860 |
| Other comprehensive income | 8,851 | | 8,860 |
| Comprehensive income | 145,051 | | 102,427 |
First 8 of 10 rows. The download has all of them.
Table 4 after “(Unaudited)”
| Three months ended | | |
| March 31, | | |
| 2018 | 2017 | |
| Operating Activities: | | | |
| Net earnings | $136,200 | | $93,567 |
| Adjustments to reconcile net earnings to net cash from operating activities: | | | |
| (Recoveries) provision for losses on accounts receivable | (265) | | 931 |
| Deferred income tax expense | 2,853 | | 5,593 |
First 8 of 33 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 | | |
| March 31, | | |
| 2018 | 2017 | |
| Stock compensation expense | $11,267 | | $10,623 |
| Recognized tax benefit | $1,517 | | $2,213 |
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 | | | | |
| March 31, | | | | |
| (Amounts in thousands, except per share amounts) | Net earningsattributable toshareholders | Weighted averageshares | | Earnings per share | |
| 2018 | | | | | |
| Basic earnings attributable to shareholders | $135,692 | | 175,900 | | $0.77 |
| Effect of dilutive potential common shares | — | | 3,516 | | — |
| Diluted earnings attributable to shareholders | $135,692 | | 179,416 | | $0.76 |
| 2017 | | | | | |
First 8 of 11 rows. The download has all of them.
Table 7 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 | | |
| March 31, | | |
| 2018 | 2017 | |
| Shares | — | | 3,751 |
Table 8 after “are as follows:”
| Shareholders’equity | Noncontrollinginterest | | Totalequity | |
| Balance at December 31, 2017 | $1,991,858 | | 2,515 | | 1,994,373 |
| Cumulative effect of accounting change | (22,357) | | (105) | | (22,462) |
| Exercise of stock options | 26,397 | | — | | 26,397 |
| Shares repurchased under provisions of stock repurchase plans | (172,360) | | — | | (172,360) |
| Stock compensation expense | 11,267 | | — | | 11,267 |
| Net earnings | 135,692 | | 508 | | 136,200 |
| Other comprehensive income (loss) | 8,972 | | (121) | | 8,851 |
First 8 of 16 rows. The download has all of them.
Table 9 after “Cash and cash equivalents consist of the following:”
| March 31, 2018 | December 31, 2017 | | | | |
| Cost | Fair Value | | Cost | Fair Value | |
| Cash and Cash Equivalents: | | | | | | |
| Cash and overnight deposits | $452,028 | | 452,028 | | 383,021 | 383,021 |
| Corporate commercial paper | 643,085 | | 644,225 | | 635,345 | 635,919 |
| Time deposits | 37,788 | | 37,788 | | 32,733 | 32,733 |
| Total cash and cash equivalents | $1,132,901 | | 1,134,041 | | 1,051,099 | 1,051,673 |
Table 10 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 March 31, 2018: | | | | | | | | | | | | | | | |
| Revenues from unaffiliated customers | $534,869 | | 76,525 | | 32,722 | | 630,572 | | 168,600 | | 305,792 | | 105,182 | — | 1,854,262 |
| Transfers between geographic areas | 28,881 | | 3,562 | | 3,387 | | 6,017 | | 6,550 | | 14,188 | | 5,355 | (67,940) | — |
| Total revenues | $563,750 | | 80,087 | | 36,109 | | 636,589 | | 175,150 | | 319,980 | | 110,537 | (67,940) | 1,854,262 |
| Net revenues1 | $277,185 | | 30,447 | | 14,745 | | 137,208 | | 44,406 | | 98,635 | | 33,201 | 11 | 635,838 |
| Operating income | $69,648 | | 9,018 | | 2,370 | | 69,923 | | 15,132 | | 19,278 | | 7,438 | 11 | 192,818 |
| Identifiable assets at period end | $1,558,181 | | 165,368 | | 55,036 | | 542,965 | | 153,411 | | 533,012 | | 208,173 | (3,665) | 3,212,481 |
First 8 of 21 rows. The download has all of them.
Table 11 after “The following table presents the calculation of consolidated net revenues:”
| Three months ended | | |
| March 31, | | |
| 2018 | 2017 | |
| Total revenues | $1,854,262 | | $1,545,132 |
| Expenses: | | | |
| Airfreight services | 513,504 | | 443,404 |
| Ocean freight and ocean services | 379,418 | | 366,063 |
| Customs brokerage and other services | 325,502 | | 208,060 |
First 8 of 9 rows. The download has all of them.
Table 12 after “The table and the accompanying discussion and analysis should be read in conjunction with the condensed consolidated financial statements an”
| Three months ended March 31, | | | | | | |
| 2018 | 2017 | | | | | |
| Amount | Percentof netrevenues | | Amount | | Percentof netrevenues | |
| (in thousands) | | | | | | | |
| Airfreight services: | | | | | | | |
| Revenues | $731,227 | | | | $615,545 | | |
| Expenses | 513,504 | | | | 443,404 | | |
| Net revenues | 217,723 | | 34% | | | 172,141 | 33% |
First 8 of 28 rows. The download has all of them.
Table 13 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 | |
| January 1-31, 2018 | — | | $— | | — | 9,151,504 |
| February 1-28, 2018 | 1,330,594 | | 65.26 | | 1,330,594 | 7,890,263 |
| March 1-31, 2018 | 1,330,893 | | 64.26 | | 1,330,893 | 6,506,921 |
| Total | 2,661,487 | | $64.76 | | 2,661,487 | 6,506,921 |
Table 14 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.