tickdelta
tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of EXPD

Tables in the 10-Q of EXPEDITORS INTERNATIONAL OF WASHINGTON INC

15 tables with numbers, filed Aug 8, 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)”

June 30, 2018December 31, 2017
Current Assets:
Cash and cash equivalents$1,020,854$1,051,099
Accounts receivable, less allowance for doubtful accounts of $12,272 at June 30, 2018 and $12,858 at December 31, 20171,337,7161,414,741
Deferred contract costs136,133—
Other69,43875,612
Total current assets2,564,1412,541,452
Property and equipment, less accumulated depreciation and amortization of $435,159 at June 30, 2018 and $420,282 at December 31, 2017515,547525,203

First 8 of 30 rows. The download has all of them.

Table 2 after “(Unaudited)”

Three months endedSix months ended
June 30,June 30,
2018201720182017
Revenues:
Airfreight services$801,761$671,868$1,532,988$1,287,413
Ocean freight and ocean services530,008528,5851,050,8911,022,344
Customs brokerage and other services625,790471,8261,227,942907,654
Total revenues1,957,5591,672,2793,811,8213,217,411

First 8 of 33 rows. The download has all of them.

Table 3 after “(Unaudited)”

Three months endedSix months ended
June 30,June 30,
2018201720182017
Net earnings$140,946$108,755$277,146$202,322
Other comprehensive (loss) income, net of tax:
Foreign currency translation adjustments, net of tax of $15,171 and $5,016 for the three months ended June 30, 2018 and 2017 and $9,660 and $9,892 for the six months ended June 30, 2018 and 2017(26,051)9,236(17,200)18,096
Other comprehensive (loss) income(26,051)9,236(17,200)18,096
Comprehensive income114,895117,991259,946220,418

First 8 of 10 rows. The download has all of them.

Table 4 after “(Unaudited)”

Three months endedSix months ended
June 30,June 30,
2018201720182017
Operating Activities:
Net earnings$140,946$108,755$277,146$202,322
Adjustments to reconcile net earnings to net cash from operating activities:
Provision for losses on accounts receivable5285152631,446
Deferred income tax expense3,2357,2616,08812,854

First 8 of 35 rows. The download has all of them.

Table 5 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 toshareholdersWeighted averagesharesEarnings per share
2018
Basic earnings attributable to shareholders$140,605174,754$0.80
Effect of dilutive potential common shares—3,849—
Diluted earnings attributable to shareholders$140,605178,603$0.79
2017

First 8 of 11 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”

Six months ended
June 30,
(Amounts in thousands, except per share amounts)Net earningsattributable toshareholdersWeighted averagesharesEarnings per share
2018
Basic earnings attributable to shareholders$276,297175,324$1.58
Effect of dilutive potential common shares—3,796—
Diluted earnings attributable to shareholders$276,297179,120$1.54
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 endedSix months ended
June 30,June 30,
2018201720182017
Shares—3,0023833,001

Table 8 after “are as follows:”

Shareholders’equityNoncontrollinginterestTotalequity
Balance at December 31, 2017$1,991,8582,5151,994,373
Cumulative effect of accounting change(22,357)(105)(22,462)
Exercise of stock options and release of restricted awards, net of shares withheld for employee taxes118,545—118,545
Shares repurchased under provisions of stock repurchase plans(407,932)—(407,932)
Stock compensation expense29,269—29,269
Net earnings276,297849277,146
Other comprehensive loss(16,748)(452)(17,200)

First 8 of 18 rows. The download has all of them.

Table 9 after “Cash and cash equivalents consist of the following:”

June 30, 2018December 31, 2017
CostFair ValueCostFair Value
Cash and Cash Equivalents:
Cash and overnight deposits$527,095527,095383,021383,021
Corporate commercial paper467,528467,898635,345635,919
Time deposits26,23126,23132,73332,733
Total cash and cash equivalents$1,020,8541,021,2241,051,0991,051,673

Table 10 after “Financial information regarding the Company’s operations by geographic area is as follows:”

(in thousands)UNITEDSTATESOTHERNORTHAMERICALATINAMERICANORTH ASIASOUTH ASIAEUROPEMIDDLE EAST, AFRICA AND INDIAELIMI-NATIONSCONSOLI-DATED
Three months ended June 30, 2018:
Revenues from unaffiliated customers$567,27180,26838,697674,101172,696315,950108,576—1,957,559
Transfers between geographic areas30,8053,9763,9216,1266,83214,8255,429(71,914)—
Total revenues$598,07684,24442,618680,227179,528330,775114,005(71,914)1,957,559
Net revenues1$271,88034,74915,923140,58344,886102,37133,125(971)642,546
Operating income$63,62810,0772,70170,35913,37416,9586,490(3)183,584
Identifiable assets at period end$1,488,060153,82754,186540,954157,479526,607217,716(5,997)3,132,832

First 8 of 21 rows. The download has all of them.

Table 11 after “13”

(in thousands)UNITED STATESOTHER NORTH AMERICALATIN AMERICANORTH ASIASOUTH ASIAEUROPEMIDDLE EAST, AFRICA AND INDIAELIMI- NATIONSCONSOLI- DATED
Six months ended June 30, 2018:
Revenues from unaffiliated customers$1,102,140156,79371,4191,304,673341,296621,742213,758—3,811,821
Transfers between geographic areas59,6867,5387,30812,14313,38229,01310,784(139,854)—
Total revenues$1,161,826164,33178,7271,316,816354,678650,755224,542(139,854)3,811,821
Net revenues1$549,06565,19630,668277,79189,292201,00666,326(960)1,278,384
Operating income$133,27619,0955,071140,28228,50636,23613,9288376,402
Identifiable assets at period end$1,488,060153,82754,186540,954157,479526,607217,716(5,997)3,132,832

First 8 of 21 rows. The download has all of them.

Table 12 after “The following table presents the calculation of consolidated net revenues:”

Three months endedSix months ended
June 30,June 30,
2018201720182017
Total revenues$1,957,559$1,672,279$3,811,821$3,217,411
Expenses:
Airfreight services593,325499,4181,106,829942,822
Ocean freight and ocean services385,156385,927764,574751,990
Customs brokerage and other services336,532223,301662,034431,361

First 8 of 9 rows. The download has all of them.

Table 13 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,
2018201720182017
AmountPercentof netrevenuesAmountPercentof netrevenuesAmountPercentof netrevenuesAmountPercentof netrevenues
(in thousands)
Airfreight services:
Revenues$801,761$671,868$1,532,988$1,287,413
Expenses593,325499,4181,106,829942,822
Net revenues208,43632%172,45031%426,15933%344,59131%

First 8 of 28 rows. The download has all of them.

Table 14 after “ISSUER PURCHASES OF EQUITY SECURITIES”

PeriodTotal number ofshares purchasedAverage pricepaid per shareTotal number of sharespurchased as part ofpublicly announcedplans or programsMaximum numberof shares that may yet bepurchased under theplans or programs
April 1-30, 2018—$——6,680,503
May 1-31, 2018650,00074.88650,0007,780,511
June 1-30, 20182,440,59276.582,440,5924,779,986
Total3,090,592$76.223,090,5924,779,986

Table 15 after “Exhibits required by Item 601 of Regulation S-K.”

Exhibit NumberDescription
31.1Certification of Chief Executive Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002
31.2Certification of Chief Financial Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002
32Certification pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002
101.INSXBRL Instance Document
101.SCHXBRL Taxonomy Extension Schema Document
101.CALXBRL Taxonomy Extension Calculation Linkbase Document
101.DEFXBRL Taxonomy Extension Definition Linkbase Document

First 8 of 10 rows. The download has all of them.