← Filings of EXPD
Tables in the 10-Q of EXPEDITORS INTERNATIONAL OF WASHINGTON INC
18 tables with numbers, filed Nov 6, 2019. 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, 2019 | | December 31, 2018 | |
| Assets: | | | | |
| Current Assets: | | | | |
| Cash and cash equivalents | $1,215,970 | | $923,735 | |
| Accounts receivable, less allowance for doubtful accounts of $11,853 at September 30, 2019 and $15,345 at December 31, 2018 | | 1,319,032 | | 1,581,530 |
| Deferred contract costs | | 130,690 | | 159,510 |
| Other | | 103,521 | | 70,041 |
| Total current assets | | 2,769,213 | | 2,734,816 |
First 8 of 34 rows. The download has all of them.
Table 2 after “(Unaudited)”
| Three months ended September 30, | | Nine months ended September 30, | | | | |
| 2019 | | 2018 | | 2019 | 2018 | |
| Revenues: | | | | | | | |
| Airfreight services | $715,450 | | $833,338 | | $2,171,928 | $2,366,326 | |
| Ocean freight and ocean services | | 585,374 | | 585,810 | | 1,697,824 | 1,636,701 |
| Customs brokerage and other services | | 774,031 | | 671,799 | | 2,260,733 | 1,899,741 |
| Total revenues | | 2,074,855 | | 2,090,947 | | 6,130,485 | 5,902,768 |
| Operating Expenses: | | | | | | | |
First 8 of 31 rows. The download has all of them.
Table 3 after “(Unaudited)”
| Three months ended September 30, | | Nine months ended September 30, | | | | |
| 2019 | | 2018 | | 2019 | 2018 | |
| Net earnings | $160,627 | | $163,067 | | $454,268 | $440,213 | |
| Other comprehensive income (loss), net of tax: | | | | | | | |
| Foreign currency translation adjustments, net of tax of $5,803 and $2,904 for the three months ended September 30, 2019 and 2018 and $5,364 and $12,563 for the nine months ended September 30, 2019 and 2018 | | (14,603) | | (10,929) | | (14,007) | (28,129) |
| Reclassification adjustments for foreign currency realized losses, net of tax of $145 for the nine months ended September 30, 2019 | | — | | — | | 535 | — |
| Other comprehensive loss | | (14,603) | | (10,929) | | (13,472) | (28,129) |
| Comprehensive income | | 146,024 | | 152,138 | | 440,796 | 412,084 |
First 8 of 10 rows. The download has all of them.
Table 4 after “(Unaudited)”
| Three months ended September 30, | | Nine months ended September 30, | | | | |
| 2019 | | 2018 | | 2019 | 2018 | |
| Operating Activities: | | | | | | | |
| Net earnings | $160,627 | | $163,067 | | $454,268 | $440,213 | |
| Adjustments to reconcile net earnings to net cash from operating activities: | | | | | | | |
| Provisions for losses on accounts receivable | | 757 | | 1,969 | | 453 | 2,232 |
| Deferred income tax benefit | | (5,822) | | (23,610) | | (17) | (17,522) |
| Stock compensation expense | | 12,155 | | 13,902 | | 49,361 | 43,171 |
First 8 of 36 rows. The download has all of them.
Table 5 after “(Unaudited)”
| Common Stock | | | | | | | | | | | | | | | | | | | |
| For the three months ended September 30, 2019 and 2018 | Shares | | Par value | | | Additional paid-in capital | | Retained earnings | | Accumulated other comprehensive loss | | Total shareholders’ equity | | | Noncontrolling interest | | Total equity | | | |
| Balance at June 30, 2019 | | 170,040 | | $1,701 | | | $12,433 | | $2,140,935 | | $(104,096) | | $2,050,973 | | | $1,421 | | $2,052,394 | | |
| Exercise of stock options and release of restricted shares | | 510 | | | 5 | | | 22,833 | | | — | | | — | | | 22,838 | | — | 22,838 |
| Issuance of shares under stock purchase plan | | 585 | | | 6 | | | 37,869 | | | — | | | — | | | 37,875 | | — | 37,875 |
| Shares repurchased under provisions of stock repurchase plan | | (892) | | | (10) | | | (61,989) | | | — | | | — | | | (61,999) | | — | (61,999) |
| Stock compensation expense | | — | | | — | | | 12,155 | | | — | | | — | | | 12,155 | | — | 12,155 |
| Net earnings | | — | | | — | | | — | | | 160,221 | | | — | | | 160,221 | | 406 | 160,627 |
First 8 of 43 rows. The download has all of them.
Table 6 after “Lease cost for the three and nine months ended September 30, 2019 are all recorded under rent and occupancy expenses on the condensed consol”
| Three months ended September 30, 2019 | | Nine months ended September 30, 2019 | |
| Operating lease cost | $20,784 | | $60,832 | |
| Variable lease cost | | 6,990 | | 19,867 |
| Total lease cost | $27,774 | | $80,699 | |
Table 7 after “Maturities of lease liabilities as of September 30, 2019 are as follows:”
| 2019 | $19,112 | |
| 2020 | | 77,416 |
| 2021 | | 67,505 |
| 2022 | | 61,044 |
| 2023 | | 52,427 |
| Thereafter | | 174,492 |
| Total minimum lease payments | | 451,996 |
| Less imputed interest | | 76,574 |
First 8 of 9 rows. The download has all of them.
Table 8 after “, future minimum annual lease payments under all noncancelable leases were as follows:”
| 2019 | $75,227 | |
| 2020 | | 62,974 |
| 2021 | | 47,552 |
| 2022 | | 38,352 |
| 2023 | | 26,580 |
| Thereafter | | 67,140 |
| $317,825 | |
Table 9 after “Other information related to the Company's operating leases are as follows:”
| Three months ended September 30, 2019 | Nine months ended September 30, 2019 |
| Right-of-use assets obtained in exchange for new operating lease liabilities | $14,630 | $76,664 |
| Cash paid for amounts included in the measurement of lease liabilities | $19,642 | $58,934 |
Table 10 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, | | | | | | | |
| Net earnings attributable to shareholders | | Weighted average shares | | | Earnings per share | | |
| 2019 | | | | | | | | |
| Basic earnings attributable to shareholders | $160,221 | | | 170,415 | | | $0.94 | |
| Effect of dilutive potential common shares | | — | | | 3,068 | | | — |
| Diluted earnings attributable to shareholders | $160,221 | | | 173,483 | | | $0.92 | |
| 2018 | | | | | | | | |
| Basic earnings attributable to shareholders | $162,692 | | | 173,394 | | | $0.94 | |
First 8 of 10 rows. The download has all of them.
Table 11 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, | | | | | | | |
| Net earnings attributable to shareholders | | Weighted average shares | | | Earnings per share | | |
| 2019 | | | | | | | | |
| Basic earnings attributable to shareholders | $453,069 | | | 171,084 | | | $2.65 | |
| Effect of dilutive potential common shares | | — | | | 3,379 | | | — |
| Diluted earnings attributable to shareholders | $453,069 | | | 174,463 | | | $2.60 | |
| 2018 | | | | | | | | |
| Basic earnings attributable to shareholders | $438,989 | | | 174,675 | | | $2.51 | |
First 8 of 10 rows. The download has all of them.
Table 12 after “Cash and cash equivalents consist of the following:”
| September 30, 2019 | | December 31, 2018 | | | | |
| Cost | | Fair Value | | Cost | Fair Value | |
| Cash and Cash Equivalents: | | | | | | | |
| Cash and overnight deposits | $398,235 | | $398,235 | | $427,307 | $427,307 | |
| Corporate commercial paper | | 788,060 | | 788,708 | | 467,300 | 467,760 |
| Time deposits | | 29,675 | | 29,675 | | 29,128 | 29,128 |
| Total cash and cash equivalents | $1,215,970 | | $1,216,618 | | $923,735 | $924,195 | |
Table 13 after “Financial information regarding the Company’s operations by geographic area is as follows:”
| UNITED STATES | OTHER NORTH AMERICA | | LATIN AMERICA | | NORTH ASIA | SOUTH ASIA | EUROPE | | MIDDLE EAST, AFRICA AND INDIA | | ELIMI- NATIONS | CONSOLI- DATED | | |
| For the three months ended September 30, 2019: | | | | | | | | | | | | | | | |
| Revenues1 | $692,229 | | 88,088 | | 38,341 | | 624,351 | | 196,569 | | 320,769 | | 115,397 | (889) | 2,074,855 |
| Directly related cost of transportation and other expenses2 | $389,254 | | 51,420 | | 22,990 | | 489,195 | | 145,345 | | 221,149 | | 81,592 | (446) | 1,400,499 |
| Salaries and other operating expenses3 | $210,767 | | 25,731 | | 14,547 | | 70,410 | | 32,482 | | 86,156 | | 28,151 | (438) | 467,806 |
| Operating income | $92,208 | | 10,937 | | 804 | | 64,746 | | 18,742 | | 13,464 | | 5,654 | (5) | 206,550 |
| Identifiable assets at period end | $2,059,345 | | 128,336 | | 72,029 | | 489,322 | | 164,976 | | 563,289 | | 226,657 | 2,499 | 3,706,453 |
| Capital expenditures | $7,644 | | 513 | | 833 | | 523 | | 631 | | 5,119 | | 258 | — | 15,521 |
First 8 of 17 rows. The download has all of them.
Table 14 after “Financial information regarding the Company’s operations by geographic area is as follows:”
| UNITED STATES | OTHER NORTH AMERICA | | LATIN AMERICA | | NORTH ASIA | SOUTH ASIA | EUROPE | | MIDDLE EAST, AFRICA AND INDIA | | ELIMI- NATIONS | CONSOLI- DATED | | |
| For the nine months ended September 30, 2019: | | | | | | | | | | | | | | | |
| Revenues1 | $2,033,088 | | 265,035 | | 111,277 | | 1,879,155 | | 555,128 | | 952,790 | | 336,383 | (2,371) | 6,130,485 |
| Directly related cost of transportation and other expenses2 | $1,142,701 | | 157,997 | | 64,149 | | 1,475,395 | | 407,642 | | 657,720 | | 236,184 | (1,468) | 4,140,320 |
| Salaries and other operating expenses3 | $636,243 | | 76,283 | | 41,342 | | 208,781 | | 97,324 | | 258,339 | | 86,385 | (884) | 1,403,813 |
| Operating income | $254,144 | | 30,755 | | 5,786 | | 194,979 | | 50,162 | | 36,731 | | 13,814 | (19) | 586,352 |
| Identifiable assets at period end | $2,059,345 | | 128,336 | | 72,029 | | 489,322 | | 164,976 | | 563,289 | | 226,657 | 2,499 | 3,706,453 |
| Capital expenditures | $23,544 | | 1,509 | | 1,071 | | 1,167 | | 1,235 | | 8,015 | | 1,402 | — | 37,943 |
First 8 of 17 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, | | | | | | | | |
| (in thousands) | 2019 | | | 2018 | | Percentage change | 2019 | 2018 | Percentage change | | |
| Airfreight services: | | | | | | | | | | | |
| Revenues | $715,450 | | | $833,338 | | (14)% | $2,171,928 | $2,366,326 | (8)% | | |
| Expenses | | 522,868 | | | 620,554 | | (16) | 1,574,717 | | 1,727,383 | (9) |
| Ocean freight services and ocean services: | | | | | | | | | | | |
| Revenues | | 585,374 | | | 585,810 | | — | 1,697,824 | | 1,636,701 | 4 |
| Expenses | | 424,215 | | | 435,313 | | (3) | 1,234,845 | | 1,199,887 | 3 |
First 8 of 22 rows. The download has all of them.
Table 16 after “As of September 30, 2019, our contractual obligations are as follows:”
| | | | Payments due by period | | | | | | | | |
| In thousands | Total | | Less than 1 year | | | 1 - 3 years | | 3 - 5 years | After 5 years | | | |
| Contractual Obligations: | | | | | | | | | | | | |
| Operating leases, including imputed interest | $451,996 | | | 79,216 | | | 132,699 | | 98,798 | | 141,283 | |
| Unconditional purchase obligations | | 91,729 | | | 91,729 | | | — | | — | | — |
| Construction, equipment and technology purchase obligations | | 51,264 | | | 25,612 | | | 23,213 | | 2,207 | | 232 |
| Total contractual cash obligations | $594,989 | | | 196,557 | | | 155,912 | | 101,005 | | 141,515 | |
Table 17 after “ISSUER PURCHASES OF EQUITY SECURITIES”
| Period | Total number of shares purchased | | Average price paid per share | | | Total number of shares purchased as part of publicly announced plans | | Maximum number of shares that may yet be purchased under the plans | | |
| July 1-31, 2019 | | — | | $— | | | — | | 11,025,843 | |
| August 1-31, 2019 | | 881,474 | | | 69.50 | | | 881,474 | | 9,949,780 |
| September 1-30, 2019 | | 10,454 | | | 70.02 | | | 10,454 | | 10,243,147 |
| Total | | 891,928 | | $69.51 | | | 891,928 | | 10,243,147 | |
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 | Inline 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. |
| 101.SCH | Inline XBRL Taxonomy Extension Schema Document |
| 101.CAL | Inline XBRL Taxonomy Extension Calculation Linkbase Document |
| 101.DEF | Inline XBRL Taxonomy Extension Definition Linkbase Document |
First 8 of 11 rows. The download has all of them.