← Filings of EXPD
Tables in the 10-Q of EXPEDITORS INTERNATIONAL OF WASHINGTON INC
18 tables with numbers, filed Aug 4, 2016. 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, 2016 | December 31, 2015 | |
| Current Assets: | | | |
| Cash and cash equivalents | $980,264 | | $807,796 |
| Accounts receivable, less allowance for doubtful accounts of $8,938 at June 30, 2016 and $7,820 at December 31, 2015 | 1,051,373 | | 1,112,260 |
| Deferred Federal and state income taxes | 19,683 | | 16,861 |
| Other | 75,525 | | 56,453 |
| Total current assets | 2,126,845 | | 1,993,370 |
| Property and equipment, less accumulated depreciation and amortization of $400,396 at June 30, 2016 and $385,023 at December 31, 2015 | 540,737 | | 524,724 |
First 8 of 28 rows. The download has all of them.
Table 2 after “(Unaudited)”
| Three months ended | Six months ended | | | | |
| June 30, | June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Revenues: | | | | | | |
| Airfreight services | $582,093 | | $693,812 | | $1,142,946 | $1,401,256 |
| Ocean freight and ocean services | 464,692 | | 576,772 | | 918,884 | 1,142,489 |
| Customs brokerage and other services | 428,379 | | 420,969 | | 831,806 | 825,334 |
| Total revenues | 1,475,164 | | 1,691,553 | | 2,893,636 | 3,369,079 |
First 8 of 33 rows. The download has all of them.
Table 3 after “(Unaudited)”
| Three months ended | Six months ended | | | | |
| June 30, | June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Net earnings | $116,439 | | $118,329 | | $213,486 | $225,661 |
| Other comprehensive income (loss), net of tax: | | | | | | |
| Foreign currency translation adjustments, net of tax of $5,612 and $2,363 for the three months ended June 30, 2016 and 2015 and $424 and $8,197 for the six months ended June 30, 2016 and 2015 | (10,297) | | 4,216 | | (717) | (15,389) |
| Other comprehensive (loss) income | (10,297) | | 4,216 | | (717) | (15,389) |
| Comprehensive income | 106,142 | | 122,545 | | 212,769 | 210,272 |
First 8 of 10 rows. The download has all of them.
Table 4 after “(Unaudited)”
| Three months ended | Six months ended | | | | |
| June 30, | June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Operating Activities: | | | | | | |
| Net earnings | $116,439 | | $118,329 | | $213,486 | $225,661 |
| Adjustments to reconcile net earnings to net cash from operating activities: | | | | | | |
| Provision for losses on accounts receivable | 562 | | 584 | | 1,140 | 861 |
| Deferred income tax (benefit) expense | (6,115) | | 8,986 | | 3,781 | 20,923 |
First 8 of 37 rows. The download has all of them.
Table 5 after “The fair value of each option grant is estimated on the date of grant using the Black-Scholes option pricing model with the following assump”
| Six months ended June 30, | | |
| 2016 | 2015 | |
| Dividend yield | 1.70% | | 1.60% |
| Volatility - stock option plans | 24 - 25% | | 31% |
| Risk free interest rates | 1.31% | | 1.79% |
| Expected life (years) - stock option plans | 5.50 - 6.50 | | 6.41 - 7.47 |
| Weighted average fair value of stock options granted during the period | $9.57 | | $13.42 |
Table 6 after “Total stock compensation expense and the total related tax benefit recognized are as follows:”
| Three months ended | Six months ended | | | | |
| June 30, | June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Stock compensation expense | $12,957 | | $11,663 | | $23,788 | $21,570 |
| Recognized tax benefit | $2,049 | | $1,491 | | $3,779 | $2,734 |
Table 7 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, | | | | |
| (Amounts in thousands, except per share amounts) | Net earningsattributable toshareholders | Weighted averageshares | | Earnings per share | |
| 2016 | | | | | |
| Basic earnings attributable to shareholders | $116,052 | | 181,753 | | $0.64 |
| Effect of dilutive potential common shares | — | | 1,379 | | — |
| Diluted earnings attributable to shareholders | $116,052 | | 183,132 | | $0.63 |
| 2015 | | | | | |
First 8 of 11 rows. The download has all of them.
| Six months ended | | | | |
| June 30, | | | | |
| (Amounts in thousands, except per share amounts) | Net earningsattributable toshareholders | Weighted averageshares | | Earnings per share | |
| 2016 | | | | | |
| Basic earnings attributable to shareholders | $212,636 | | 181,882 | | $1.17 |
| Effect of dilutive potential common shares | — | | 1,228 | | — |
| Diluted earnings attributable to shareholders | $212,636 | | 183,110 | | $1.16 |
| 2015 | | | | | |
First 8 of 11 rows. The download has all of them.
Table 9 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 | Six months ended | | | | |
| June 30, | June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Shares | 9,602 | | 8,407 | | 10,632 | 10,519 |
Table 10 after “are as follows:”
| Shareholders’equity | Noncontrollinginterest | | Totalequity | |
| Balance at December 31, 2015 | $1,691,993 | | 2,683 | | 1,694,676 |
| Exercise of stock options | 90,123 | | — | | 90,123 |
| Shares repurchased under provisions of stock repurchase plans | (166,407) | | — | | (166,407) |
| Stock compensation expense | 23,788 | | — | | 23,788 |
| Tax deficiency from stock plans, net | (2,444) | | — | | (2,444) |
| Net earnings | 212,636 | | 850 | | 213,486 |
| Other comprehensive (loss) income | (774) | | 57 | | (717) |
First 8 of 20 rows. The download has all of them.
Table 11 after “The Company’s financial instruments, other than cash, consist primarily of cash equivalents, short-term investments, accounts receivable, ac”
| June 30, 2016 | December 31, 2015 | | | | |
| Cost | Fair Value | | Cost | Fair Value | |
| Cash and Cash Equivalents: | | | | | | |
| Cash and overnight deposits | $451,445 | | 451,445 | | 445,582 | 445,582 |
| Corporate commercial paper | 478,146 | | 478,183 | | 302,433 | 302,480 |
| Time deposits | 50,673 | | 50,673 | | 59,781 | 59,781 |
| Total cash and cash equivalents | 980,264 | | 980,301 | | 807,796 | 807,843 |
| Short-Term Investments: | | | | | | |
First 8 of 10 rows. The download has all of them.
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 June 30, 2016: | | | | | | | | | | | | | | | |
| Revenues from unaffiliated customers | $417,735 | | 56,674 | | 21,169 | | 517,489 | | 151,890 | | 229,882 | | 80,325 | — | 1,475,164 |
| Transfers between geographic areas | 28,973 | | 2,671 | | 4,187 | | 5,385 | | 6,326 | | 10,097 | | 5,507 | (63,146) | — |
| Total revenues | $446,708 | | 59,345 | | 25,356 | | 522,874 | | 158,216 | | 239,979 | | 85,832 | (63,146) | 1,475,164 |
| Net revenues1 | $232,860 | | 30,815 | | 14,468 | | 122,117 | | 46,257 | | 77,639 | | 28,975 | (14) | 553,117 |
| Operating income | $67,214 | | 9,600 | | 3,836 | | 61,721 | | 18,354 | | 11,838 | | 6,315 | (14) | 178,864 |
| Identifiable assets at period end | $1,363,352 | | 84,358 | | 58,570 | | 471,832 | | 118,352 | | 378,859 | | 225,877 | 5,938 | 2,707,138 |
First 8 of 21 rows. The download has all of them.
| (in thousands) | UNITEDSTATES | OTHERNORTHAMERICA | | LATINAMERICA | NORTH ASIA | SOUTH ASIA | | EUROPE | MIDDLE EAST, AFRICA AND INDIA | ELIMI-NATIONS | | CONSOLI-DATED | | | |
| Six months ended June 30, 2016: | | | | | | | | | | | | | | | |
| Revenues from unaffiliated customers | $825,561 | | 108,780 | | 41,233 | | 1,014,721 | | 288,308 | | 451,779 | | 163,254 | — | 2,893,636 |
| Transfers between geographic areas | 55,007 | | 5,371 | | 7,788 | | 10,481 | | 12,132 | | 20,458 | | 10,901 | (122,138) | — |
| Total revenues | $880,568 | | 114,151 | | 49,021 | | 1,025,202 | | 300,440 | | 472,237 | | 174,155 | (122,138) | 2,893,636 |
| Net revenues1 | $453,558 | | 58,193 | | 28,201 | | 232,908 | | 85,775 | | 152,180 | | 59,382 | (11) | 1,070,186 |
| Operating income | $115,419 | | 16,891 | | 7,688 | | 116,939 | | 34,045 | | 24,091 | | 15,628 | (11) | 330,690 |
| Identifiable assets at period end | $1,363,352 | | 84,358 | | 58,570 | | 471,832 | | 118,352 | | 378,859 | | 225,877 | 5,938 | 2,707,138 |
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 | Six months ended | | | | |
| June 30, | June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Total revenues | $1,475,164 | | $1,691,553 | | $2,893,636 | $3,369,079 |
| Expenses: | | | | | | |
| Airfreight services | 403,419 | | 506,988 | | 792,196 | 1,019,989 |
| Ocean freight and ocean services | 323,699 | | 433,356 | | 646,719 | 878,812 |
| Customs brokerage and other services | 194,929 | | 199,068 | | 384,535 | 388,651 |
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 June 30, | Six months ended June 30, | | | | | | | | | | | | |
| 2016 | 2015 | | 2016 | | 2015 | | | | | | | | |
| Amount | Percentof netrevenues | | Amount | | Percentof netrevenues | Amount | | Percentof netrevenues | Amount | Percentof netrevenues | | | |
| (in thousands) | | | | | | | | | | | | | | |
| Airfreight services: | | | | | | | | | | | | | | |
| Revenues | $582,093 | | | | $693,812 | | | | $1,142,946 | | | $1,401,256 | | |
| Expenses | 403,419 | | | | 506,988 | | | | 792,196 | | | 1,019,989 | | |
| Net revenues | 178,674 | | 32% | | | 186,824 | | 34% | | 350,750 | | 33% | 381,267 | 35% |
First 8 of 28 rows. The download has all of them.
Table 16 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 | |
| April 1-30, 2016 | — | | $— | | — | 11,390,165 |
| May 1-31, 2016 | — | | — | | — | 21,836,489 |
| June 1-30, 2016 | 1,942,952 | | 49.47 | | 1,942,952 | 18,955,712 |
| Total | 1,942,952 | | $49.47 | | 1,942,952 | 18,955,712 |
Table 17 after “Exhibits required by Item 601 of Regulation S-K.”
| Exhibit Number | Description |
| 3.2 | The Company's Amended and Restated Bylaws (Incorporated by reference to Exhibit 3.2 to Form 8-K filed on or about May 6, 2016.) |
| 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 |
First 8 of 11 rows. The download has all of them.
Table 18 after “June 30, 2016”
| 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.