← Filings of EXPD
Tables in the 10-Q of EXPEDITORS INTERNATIONAL OF WASHINGTON INC
14 tables with numbers, filed Aug 5, 2021. 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)”
| June 30, 2021 | | December 31, 2020 | |
| Assets: | | | | |
| Current Assets: | | | | |
| Cash and cash equivalents | $1,674,121 | | $1,527,791 | |
| Accounts receivable, less allowance for credit loss of $6,104 at June 30, 2021 and $5,579 at December 31, 2020 | | 2,647,516 | | 1,998,055 |
| Deferred contract costs | | 534,692 | | 327,448 |
| Other | | 128,933 | | 110,250 |
| Total current assets | | 4,985,262 | | 3,963,544 |
First 8 of 34 rows. The download has all of them.
Table 2 after “(Unaudited)”
| Three months ended June 30, | | Six months ended June 30, | | | | |
| 2021 | | 2020 | | 2021 | 2020 | |
| Revenues: | | | | | | | |
| Airfreight services | $1,523,569 | | $1,269,654 | | $2,849,484 | $1,925,252 | |
| Ocean freight and ocean services | | 1,098,550 | | 489,385 | | 2,052,462 | 980,725 |
| Customs brokerage and other services | | 986,974 | | 652,039 | | 1,905,967 | 1,348,868 |
| Total revenues | | 3,609,093 | | 2,411,078 | | 6,807,913 | 4,254,845 |
| Operating Expenses: | | | | | | | |
First 8 of 31 rows. The download has all of them.
Table 3 after “(Unaudited)”
| Three months ended June 30, | | Six months ended June 30, | | | | |
| 2021 | | 2020 | | 2021 | 2020 | |
| Net earnings | $316,974 | | $184,188 | | $604,924 | $306,970 | |
| Other comprehensive income (loss), net of tax: | | | | | | | |
| Foreign currency translation adjustments, net of income taxes expense (benefit) of $221 and $(5,148) for the three months ended June 30, 2021 and 2020 and $(3,172) and $(3,974) for the six months ended June 30, 2021 and 2020. | | 9,159 | | 16,410 | | (7,038) | (22,439) |
| Other comprehensive income (loss) | | 9,159 | | 16,410 | | (7,038) | (22,439) |
| Comprehensive income | | 326,133 | | 200,598 | | 597,886 | 284,531 |
| Less comprehensive income attributable to the noncontrolling interest | | 341 | | 141 | | 607 | 289 |
First 8 of 9 rows. The download has all of them.
Table 4 after “(Unaudited)”
| Three months ended June 30, | | Six months ended June 30, | | | | |
| 2021 | | 2020 | | 2021 | 2020 | |
| Operating Activities: | | | | | | | |
| Net earnings | $316,974 | | $184,188 | | $604,924 | $306,970 | |
| Adjustments to reconcile net earnings to net cash from operating activities: | | | | | | | |
| Provisions for losses on accounts receivable | | 1,090 | | 2,389 | | 2,289 | 4,209 |
| Deferred income tax expense | | 1,850 | | 9,287 | | 10,001 | 4,148 |
| Stock compensation expense | | 30,909 | | 21,638 | | 42,094 | 32,794 |
First 8 of 34 rows. The download has all of them.
Table 5 after “(Unaudited)”
| Common Stock | | | | | | | | | | | | | | | | | | | |
| For the three months ended June 30, 2021 and 2020 | Shares | | Par value | | | Additional paid-in capital | | Retained earnings | | Accumulated other comprehensive loss | | Total shareholders’ equity | | | Noncontrolling interest | | Total equity | | | |
| Balance at March 31, 2021 | | 168,808 | | $1,688 | | | $101,269 | | $2,887,323 | | $(115,486) | | $2,874,794 | | | $3,856 | | $2,878,650 | | |
| Shares issued under employee stock plans | | 861 | | | 9 | | | 8,809 | | | — | | | — | | | 8,818 | | — | 8,818 |
| Shares repurchased under provisions of stock repurchase plan | | (500) | | | (5) | | | (62,467) | | | — | | | — | | | (62,472) | | — | (62,472) |
| Stock compensation expense | | — | | | — | | | 30,909 | | | — | | | — | | | 30,909 | | — | 30,909 |
| Net earnings | | — | | | — | | | — | | | 316,372 | | | — | | | 316,372 | | 602 | 316,974 |
| Other comprehensive income (loss) | | — | | | — | | | — | | | — | | | 9,420 | | | 9,420 | | (261) | 9,159 |
First 8 of 37 rows. The download has all of them.
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 June 30, | | | | | | | |
| Net earnings attributable to shareholders | | Weighted average shares | | | Earnings per share | | |
| 2021 | | | | | | | | |
| Basic earnings attributable to shareholders | $316,372 | | | 169,210 | | | $1.87 | |
| Effect of dilutive potential common shares | | — | | | 2,467 | | | — |
| Diluted earnings attributable to shareholders | $316,372 | | | 171,677 | | | $1.84 | |
| 2020 | | | | | | | | |
| Basic earnings attributable to shareholders | $183,869 | | | 166,767 | | | $1.10 | |
First 8 of 20 rows. The download has all of them.
Table 7 after “Cash and cash equivalents consist of the following:”
| June 30, 2021 | | December 31, 2020 | | | | |
| Cost | | Fair Value | | Cost | Fair Value | |
| Cash and Cash Equivalents: | | | | | | | |
| Cash and overnight deposits | $761,806 | | $761,806 | | $602,112 | $602,112 | |
| Corporate commercial paper | | 845,471 | | 845,527 | | 872,287 | 872,350 |
| Time deposits | | 66,844 | | 66,844 | | 53,392 | 53,392 |
| Total cash and cash equivalents | $1,674,121 | | $1,674,177 | | $1,527,791 | $1,527,854 | |
Table 8 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 June 30, 2021: | | | | | | | | | | | | | | | |
| Revenues | $997,567 | | 101,465 | | 46,981 | | 1,309,382 | | 417,718 | | 544,949 | | 192,186 | (1,155) | 3,609,093 |
| Directly related cost of transportation and other expenses1 | $566,882 | | 59,311 | | 25,952 | | 1,086,641 | | 335,219 | | 376,856 | | 148,290 | (518) | 2,598,633 |
| Salaries and other operating expenses2 | $241,121 | | 31,300 | | 14,735 | | 106,812 | | 49,046 | | 123,408 | | 34,026 | (633) | 599,815 |
| Operating income | $189,564 | | 10,854 | | 6,294 | | 115,929 | | 33,453 | | 44,685 | | 9,870 | (4) | 410,645 |
| Identifiable assets at period end | $2,972,363 | | 196,558 | | 102,296 | | 1,114,475 | | 377,370 | | 929,706 | | 291,406 | (31,003) | 5,953,171 |
| Capital expenditures | $2,905 | | 64 | | 72 | | 400 | | 532 | | 2,100 | | 466 | — | 6,539 |
First 8 of 34 rows. The download has all of them.
Table 9 after “The below tables present the effect of the correction for the following periods:”
| Three Months ended Mar 31, 2021 | | | | | |
| As Reported | | Adjustments | | As Corrected | |
| Revenues: | | | | | | |
| Airfreight services | $1,476,961 | | $(151,046) | | $1,325,915 | |
| Ocean freight and ocean services | | 958,178 | | (4,266) | | 953,912 |
| Customs brokerage and other services | | 922,401 | | (3,408) | | 918,993 |
| Total revenues1 | | 3,357,540 | | (158,720) | | 3,198,820 |
| Directly related transportation operating expenses: | | | | | | |
First 8 of 12 rows. The download has all of them.
| Three Months ended June 30, 2020 | | | | | |
| As Reported | | Adjustments | | As Corrected | |
| Revenues: | | | | | | |
| Airfreight services | $1,434,590 | | $(164,936) | | $1,269,654 | |
| Ocean freight and ocean services | | 491,712 | | (2,327) | | 489,385 |
| Customs brokerage and other services | | 654,330 | | (2,291) | | 652,039 |
| Total revenues1 | | 2,580,632 | | (169,554) | | 2,411,078 |
| Directly related transportation operating expenses: | | | | | | |
First 8 of 12 rows. The download has all of them.
Table 11 after “% of total adjustments.”
| Six Months ended June 30, 2020 | | | | | |
| As Reported | | Adjustments | | As Corrected | |
| Revenues: | | | | | | |
| Airfreight services | $2,143,629 | | $(218,377) | | $1,925,252 | |
| Ocean freight and ocean services | | 985,139 | | (4,414) | | 980,725 |
| Customs brokerage and other services | | 1,353,728 | | (4,860) | | 1,348,868 |
| Total revenues1 | | 4,482,496 | | (227,651) | | 4,254,845 |
| Directly related transportation operating expenses: | | | | | | |
First 8 of 12 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 June 30, | | Six months ended June 30, | | | | | | | | |
| (in thousands) | 2021 | | | 2020 | | Percentage change | 2021 | 2020 | Percentage change | | |
| Airfreight services: | | | | | | | | | | | |
| Revenues1 | $1,523,569 | | | $1,269,654 | | 20% | $2,849,484 | $1,925,252 | 48% | | |
| Expenses1 | | 1,136,328 | | | 932,137 | | 22 | 2,090,872 | | 1,398,865 | 49 |
| Ocean freight services and ocean services: | | | | | | | | | | | |
| Revenues1 | | 1,098,550 | | | 489,385 | | 124 | 2,052,462 | | 980,725 | 109 |
| Expenses1 | | 862,251 | | | 361,272 | | 139 | 1,604,686 | | 725,668 | 121 |
First 8 of 22 rows. The download has all of them.
Table 13 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 | | |
| April 1-30, 2021 | | — | | $— | | | — | | 8,877,693 | |
| May 1-31, 2021 | | — | | | — | | | — | | 9,633,363 |
| June 1-30, 2021 | | 500,000 | | | 124.94 | | | 500,000 | | 9,169,128 |
| Total | | 500,000 | | $124.94 | | | 500,000 | | 9,169,128 | |
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 | 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.