tickdelta
Sign in

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

← Filings of LIN

Tables in the 10-Q of LINDE PLC

49 tables with numbers, filed Jul 30, 2021. Each one downloads as a CSV for Excel or Google Sheets, 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 “(Exact name of registrant as specified in its charter)”

Download CSV
Ireland98-1448883
(State or other jurisdiction of incorporation)(I.R.S. Employer Identification No.)
The Priestley Centre
10 Riverview Dr.,10 Priestley Road,
Danbury, CTSurrey Research Park,
United States 06810Guildford,SurreyGU2 7XY
United Kingdom
(Address of principal executive offices) (Zip Code)

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

Table 2 after “Table of Contents”

Download CSV
INDEX
PART I - FINANCIAL INFORMATION
Item 1.Financial Statements (unaudited)
Consolidated Statements of Income - Quarters Ended June 30, 2021 and 20204
Consolidated Statements of Income - Six Months Ended June 30, 2021 and 20205
Consolidated Statements of Comprehensive Income - Quarters Ended June 30, 2021 and 20206
Consolidated Statements of Comprehensive Income - Six Months Ended June 30, 2021 and 20207
Condensed Consolidated Balance Sheets - June 30, 2021 and December 31, 20208

First 8 of 22 rows. The CSV has all of them.

Table 3 after “(UNAUDITED)”

Download CSV
Quarter Ended June 30,
20212020
Sales$7,584$6,377
Cost of sales, exclusive of depreciation and amortization4,1943,619
Selling, general and administrative822760
Depreciation and amortization1,1711,124
Research and development3434
Cost reduction programs and other charges204249

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

Table 4 after “(UNAUDITED)”

Download CSV
Six Months Ended June 30,
20212020
Sales$14,827$13,116
Cost of sales, exclusive of depreciation and amortization8,2487,462
Selling, general and administrative1,6091,621
Depreciation and amortization2,3372,266
Research and development6978
Cost reduction programs and other charges196380

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

Table 5 after “(UNAUDITED)”

Download CSV
Quarter Ended June 30,
20212020
NET INCOME (INCLUDING NONCONTROLLING INTERESTS)$877$483
OTHER COMPREHENSIVE INCOME (LOSS)
Translation adjustments:
Foreign currency translation adjustments412745
Reclassification to net income——
Income taxes(2)(1)

First 8 of 23 rows. The CSV has all of them.

Table 6 after “(UNAUDITED)”

Download CSV
Six Months Ended June 30,
20212020
NET INCOME (INCLUDING NONCONTROLLING INTERESTS)$1,895$1,091
OTHER COMPREHENSIVE INCOME (LOSS)
Translation adjustments:
Foreign currency translation adjustments(245)(1,995)
Reclassification to net income (Note 13)(52)—
Income taxes(8)24

First 8 of 23 rows. The CSV has all of them.

Table 7 after “(UNAUDITED)”

Download CSV
June 30, 2021December 31, 2020
Assets
Cash and cash equivalents$3,137$3,754
Accounts receivable - net4,3424,167
Contract assets173162
Inventories1,6921,729
Prepaid and other current assets1,1021,112
Total Current Assets10,44610,924

First 8 of 34 rows. The CSV has all of them.

Table 8 after “(UNAUDITED)”

Download CSV
Six Months Ended June 30,
20212020
Increase (Decrease) in Cash and Cash Equivalents
Operations
Net income - Linde plc$1,821$1,031
Less: Income from discontinued operations, net of tax and noncontrolling interests(2)(2)
Add: Noncontrolling interests from continuing operations7460
Income from continuing operations (including noncontrolling interests)1,8931,089

First 8 of 40 rows. The CSV has all of them.

Table 9 after “Notes to Condensed Consolidated Financial Statements - Linde plc and Subsidiaries (Unaudited)”

Download CSV
Note 1. Summary of Significant Accounting Policies11
Note 2. Cost Reduction Programs and Other Charges11
Note 3. Supplemental Information14
Note 4. Debt15
Note 5. Financial Instruments16
Note 6. Fair Value Disclosures18
Note 7. Earnings Per Share – Linde plc Shareholders19
Note 8. Retirement Programs20

First 8 of 13 rows. The CSV has all of them.

Table 10 after “lowing table summarizes the activities related to the company's cost reduction charges for the quarter and six months ended June 30, 2021:”

Download CSV
Quarter Ended June 30, 2021
(millions of dollars)Severance costsOther cost reduction chargesTotal cost reduction program related chargesMerger-related and other chargesTotal
Americas$—$—$—$—$—
EMEA16914183—183
APAC5—5—5
Engineering—66—6
Other8210—10
Total$182$22$204$—$204

Table 11 after “Table of Contents”

Download CSV
Six Months Ended June 30, 2021
(millions of dollars)Severance costsOther cost reduction chargesTotal cost reduction program related chargesMerger-related and other chargesTotal
Americas$3$2$5$—$5
EMEA18221203—203
APAC729(53)(44)
Engineering7613—13
Other9918119
Total$208$40$248$(52)$196

Table 12 after “Table of Contents”

Download CSV
(millions of dollars)Severance costsOther cost reduction chargesTotal cost reduction program related chargesMerger-related and other chargesTotal
Balance, December 31, 2020$283$22$305$64$369
2021 Cost Reduction Programs and Other Charges20840248(52)196
Less: Cash payments(85)(5)(90)(6)(96)
Less: Non-cash charges / benefits—(19)(19)5435
Foreign currency translation and other(5)—(5)(3)(8)
Balance, June 30, 2021$401$38$439$57$496

Table 13 after “The following is a summary of Linde's consolidated inventories:”

Download CSV
(Millions of dollars)June 30, 2021December 31, 2020
Inventories
Raw materials and supplies$369$411
Work in process358337
Finished goods965981
Total inventories$1,692$1,729

Table 14 after “The following is a summary of Linde's outstanding debt at June 30, 2021 and December 31, 2020:”

Download CSV
(Millions of dollars)June 30, 2021December 31, 2020
SHORT-TERM
Commercial paper$2,808$2,527
Other borrowings (primarily non U.S.)873724
Total short-term debt3,6813,251
LONG-TERM (a)
(U.S. dollar denominated unless otherwise noted)
3.875% Euro denominated notes due 2021 (c)—748

First 8 of 34 rows. The CSV has all of them.

Table 15 after “The following table is a summary of the notional amount and fair value of derivatives outstanding at June 30, 2021 and December 31, 2020 for”

Download CSV
Fair Value
Notional AmountsAssets (a)Liabilities (a)
(Millions of dollars)June 30, 2021December 31, 2020June 30, 2021December 31, 2020June 30, 2021December 31, 2020
Derivatives Not Designated as Hedging Instruments:
Currency contracts:
Balance sheet items$4,972$6,470$32$72$24$48
Forecasted transactions523823616612
Cross-currency swaps174260252457

First 8 of 17 rows. The CSV has all of them.

Table 16 after “The following table summarizes the impact of the company’s derivatives on the consolidated statements of income:”

Download CSV
Amount of Pre-Tax Gain (Loss) Recognized in Earnings *
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)2021202020212020
Derivatives Not Designated as Hedging Instruments
Currency contracts:
Balance sheet items
Debt-related$10$37$29$32
Other balance sheet items3(29)7(70)

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

Table 17 after “The following table summarizes assets and liabilities measured at fair value on a recurring basis:”

Download CSV
Fair Value Measurements Using
Level 1Level 2Level 3
(Millions of dollars)June 30, 2021December 31, 2020June 30, 2021December 31, 2020June 30, 2021December 31, 2020
Assets
Derivative assets$—$—$142$200$—$—
Investments and securities*1921——4647
Total$19$21$142$20046$47
Liabilities

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

Table 18 after “Basic and diluted earnings per share is computed by dividing Income from continuing operations, Income from discontinued operations and Net ”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
2021202020212020
Numerator (Millions of dollars)
Income from continuing operations$840$458$1,819$1,029
Income from discontinued operations1—22
Net Income – Linde plc$841$458$1,821$1,031
Denominator (Thousands of shares)
Weighted average shares outstanding518,552525,238520,314528,118

First 8 of 19 rows. The CSV has all of them.

Table 19 after “The components of net pension and postretirement benefits other than pensions (“OPEB”) costs for the quarter and six months ended June 30, 2”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
PensionsOPEBPensionsOPEB
(Millions of dollars)20212020202120202021202020212020
Amount recognized in Operating Profit
Service cost$38$36$1$—$78$73$1$1
Amount recognized in Net pension and OPEB cost (benefit), excluding service cost
Interest cost3850—27610213
Expected return on plan assets(131)(118)——(262)(238)——

First 8 of 11 rows. The CSV has all of them.

Table 20 after “The table below presents sales and operating profit information about reportable segments and Other for the quarters and six months ended Ju”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)2021202020212020
SALES(a)
Americas$3,020$2,417$5,860$5,094
EMEA1,8751,4483,6743,081
APAC1,5441,2952,9802,631
Engineering6468101,3201,418
Other499407993892

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

Table 21 after “The table below presents sales and operating profit information about reportable segments and Other for the quarters and six months ended Ju”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)2021202020212020
SEGMENT OPERATING PROFIT
Americas$871$622$1,666$1,283
EMEA487303938658
APAC389294740575
Engineering108138217229
Other(18)(40)(36)(76)

First 8 of 12 rows. The CSV has all of them.

Table 22 after “A summary of the changes in total equity for the quarter and six months ended June 30, 2021 and 2020 is provided below:”

Download CSV
Quarter Ended June 30,
(Millions of dollars)20212020
ActivityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal EquityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal Equity
Balance, beginning of period$46,210$1,410$47,620$44,776$2,375$47,151
Net income (a)8413687745825483
Other comprehensive income (loss)437944676718785
Noncontrolling interests:
Additions (reductions)—77—1313

First 8 of 15 rows. The CSV has all of them.

Table 23 after “A summary of the changes in total equity for the quarter and six months ended June 30, 2021 and 2020 is provided below:”

Download CSV
Six Months Ended June 30,
(Millions of dollars)20212020
ActivityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal EquityLinde plc Shareholders’ EquityNoncontrolling Interests (a)Total Equity
Balance, beginning of period$47,317$2,252$49,569$49,074$2,448$51,522
Net income (a)1,821741,8951,031601,091
Other comprehensive income (loss)(218)3(215)(1,807)(88)(1,895)
Noncontrolling interests:
Additions (reductions) (b)—(846)(846)—1515

First 8 of 15 rows. The CSV has all of them.

Table 24 after “The components of AOCI are as follows:”

Download CSV
June 30,December 31,
(Millions of dollars)20212020
Cumulative translation adjustment - net of taxes:
Americas$(3,729)$(3,788)
EMEA9121,020
APAC330616
Engineering215354
Other(854)(1,020)

First 8 of 12 rows. The CSV has all of them.

Table 25 after “The following tables show sales by distribution method at the consolidated level and for each reportable segment and Other for the quarter a”

Download CSV
(Millions of dollars)Quarter Ended June 30, 2021
SalesAmericasEMEAAPACEngineeringOtherTotal%
Merchant$821$556$551$—$43$1,97126%
On-Site774396582——1,75223%
Packaged Gas1,369912392—62,67935%
Other5611196464501,18216%
Total$3,020$1,875$1,544$646$499$7,584100%

Table 26 after “The following tables show sales by distribution method at the consolidated level and for each reportable segment and Other for the quarter a”

Download CSV
(Millions of dollars)Quarter Ended June 30, 2020
SalesAmericasEMEAAPACEngineeringOtherTotal%
Merchant$634$415$459$—$29$1,53724%
On-Site559304466——1,32921%
Packaged Gas1,210719362—62,29736%
Other141088103721,21419%
Total$2,417$1,448$1,295$810$407$6,377100%

Table 27 after “The following tables show sales by distribution method at the consolidated level and for each reportable segment and Other for the quarter a”

Download CSV
(Millions of dollars)Six Months Ended June 30, 2021
SalesAmericasEMEAAPACEngineeringOther (a)Total%
Merchant$1,592$1,087$1,035$—$95$3,80926%
On-Site1,4637881,134——3,38523%
Packaged Gas2,7011,772753—125,23835%
Other10427581,3208862,39516%
Total$5,860$3,674$2,980$1,320$993$14,827100%
(Millions of dollars)Six Months Ended June 30, 2020

First 8 of 14 rows. The CSV has all of them.

Table 28 after “The following table provides summary information for the quarters and six months ended June 30, 2021 and 2020. The reported amounts are GAAP”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars, except per share data)20212020Variance20212020Variance
Sales$7,584$6,37719%$14,827$13,11613%
Cost of sales, exclusive of depreciation and amortization$4,194$3,61916%$8,248$7,46211%
As a percent of sales55.3%56.8%55.6%56.9%
Selling, general and administrative$822$7608%$1,609$1,621(1)%
As a percent of sales10.8%11.9%10.9%12.4%
Depreciation and amortization$1,171$1,1244%$2,337$2,2663%

First 8 of 32 rows. The CSV has all of them.

Table 29 after “The changes in consolidated sales compared to the prior year are attributable to the following:”

Download CSV
Quarter Ended June 30, 2021 vs. 2020Six Months Ended June 30, 2021 vs. 2020
% Change% Change
Factors Contributing to Changes - Sales
Volume15%9%
Price/Mix3%2%
Cost pass-through2%2%
Currency6%5%
Acquisitions/divestitures(3)%(3)%

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

Table 30 after “The reported amounts are GAAP amounts from the Condensed Consolidated Statements of Income.”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20212020Variance20212020Variance
SALES
Americas$3,020$2,41725%$5,860$5,09415%
EMEA1,8751,44829%3,6743,08119%
APAC1,5441,29519%2,9802,63113%
Engineering646810(20)%1,3201,418(7)%
Other49940723%99389211%

First 8 of 20 rows. The CSV has all of them.

Table 31 after “Americas”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20212020Variance20212020Variance
Sales$3,020$2,41725%$5,860$5,09415%
Operating profit$871$62240%$1,666$1,28330%
As a percent of sales28.8%25.7%28.4%25.2%

Table 32 after “Americas”

Download CSV
Quarter Ended June 30, 2021 vs. 2020Six Months Ended June 30, 2021 vs. 2020
% Change% Change
SalesSales
Factors Contributing to Changes - Sales
Volume18%10%
Price/Mix3%3%
Cost pass-through2%2%
Currency2%—%

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

Table 33 after “EMEA”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20212020Variance20212020Variance
Sales$1,875$1,44829%$3,674$3,08119%
Operating profit$487$30361%$938$65843%
As a percent of sales26.0%20.9%25.5%21.4%

Table 34 after “EMEA”

Download CSV
Quarter Ended June 30, 2021 vs. 2020Six Months Ended June 30, 2021 vs. 2020
% Change% Change
SalesSales
Factors Contributing to Changes - Sales
Volume12%6%
Price/Mix4%3%
Cost pass-through4%3%
Currency10%9%

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

Table 35 after “APAC”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20212020Variance20212020Variance
Sales$1,544$1,29519%$2,980$2,63113%
Operating profit$389$29432%$740$57529%
As a percent of sales25.2%22.7%24.8%21.9%

Table 36 after “APAC”

Download CSV
Quarter Ended June 30, 2021 vs. 2020Six Months Ended June 30, 2021 vs. 2020
% Change% Change
SalesReported
Factors Contributing to Changes - Sales
Volume/Equipment19%14%
Price/Mix2%2%
Cost pass-through2%2%
Currency8%7%

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

Table 37 after “Engineering”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20212020Variance20212020Variance
Sales$646$810(20)%$1,320$1,418(7)%
Operating profit$108$138(22)%$217$229(5)%
As a percent of sales16.7%17.0%16.4%16.1%

Table 38 after “Table of Contents”

Download CSV
Quarter Ended June 30, 2021 vs. 2020Six Months Ended June 30, 2021 vs. 2020
% Change% Change
SalesSales
Factors Contributing to Changes - Sales
Volume(29)%(15)%
Currency9%8%
(20)%(7)%

Table 39 after “Other”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20212020Variance20212020Variance
Sales$499$40723%$993$89211%
Operating profit (loss)$(18)$(40)55%$(36)$(76)53%
As a percent of sales(3.6)%(9.8)%(3.6)%(8.5)%

Table 40 after “Other”

Download CSV
Quarter Ended June 30, 2021 vs. 2020Six Months Ended June 30, 2021 vs. 2020
% Change% Change
SalesSales
Factors Contributing to Changes - Sales
Volume/price16%5%
Cost pass-through1%1%
Currency6%5%
Acquisitions/divestitures—%—%

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

Table 41 after “To help understand the reported results, the following is a summary of the significant currencies underlying Linde's consolidated results an”

Download CSV
Percentage of YTD 2021 Consolidated SalesExchange Rate for Income StatementExchange Rate for Balance Sheet
Year-To-Date AverageJune 30,December 31,
Currency2021202020212020
Euro21%0.830.910.840.82
Chinese yuan9%6.477.036.466.53
British pound6%0.720.790.720.73
Australian dollar4%1.301.521.331.30
Brazilian real4%5.384.865.005.20

First 8 of 15 rows. The CSV has all of them.

Table 42 after “The following selected cash flow information provides a basis for the discussion that follows:”

Download CSV
(Millions of dollars)Six months ended June 30,
20212020
NET CASH PROVIDED BY (USED FOR):
OPERATING ACTIVITIES
Net income (including noncontrolling interests)$1,893$1,089
Non-cash charges (credits):
Add: Depreciation and amortization2,3372,266
Add: Deferred income taxes(78)(261)

First 8 of 29 rows. The CSV has all of them.

Table 43 after “The following non-GAAP measures are intended to supplement investors’ understanding of the company’s financial information by providing meas”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
2021202020212020
Adjusted Operating Profit and Operating Margin
Reported operating profit$1,142$591$2,355$1,324
Add: Cost reduction programs and other charges204249196380
Add: Purchase accounting impacts - Linde AG (c)491477974965
Total adjustments6957261,1701,345
Adjusted operating profit$1,837$1,317$3,525$2,669

First 8 of 29 rows. The CSV has all of them.

Table 44 after “Table of Contents”

Download CSV
Adjusted Income Taxes (a)
Reported income taxes$334$164$602$329
Add: Purchase accounting impacts - Linde AG (c)11695234217
Add: Cost reduction programs and other charges6622698
Total adjustments122157260315
Adjusted income taxes$456$321$862$644
Adjusted Effective Tax Rate (a)
Reported income before income taxes and equity investments$1,173$618$2,415$1,372

First 8 of 38 rows. The CSV has all of them.

Table 45 after “Table of Contents”

Download CSV
Adjusted EBITDA and % of Sales
Income from continuing operations$840$458$1,819$1,029
Add: Noncontrolling interests related to continuing operations36257460
Add: Net pension and OPEB cost (benefit), excluding service cost(49)(45)(98)(90)
Add: Interest expense18183842
Add: Income taxes334164602329
Add: Depreciation and amortization1,1711,1242,3372,266
EBITDA from continuing operations$2,350$1,744$4,772$3,636

First 8 of 16 rows. The CSV has all of them.

Table 46 after “Net debt is a financial liquidity measure used by investors, financial analysts and management to evaluate the ability of a company to repay”

Download CSV
June 30, 2021December 31, 2020
(Millions of dollars)
Debt$15,492$16,154
Less: cash and cash equivalents(3,137)(3,754)
Net debt12,35512,400
Less: purchase accounting impacts - Linde AG(84)(121)
Adjusted net debt$12,271$12,279

Table 47 after “Table of Contents”

Download CSV
(Millions of dollars)
Statement of Income DataSix Months Ended June 30, 2021Twelve Months Ended December 31, 2020
Sales$3,560$6,876
Operating profit226786
Net income59690
Transactions with non-guarantor subsidiaries8682,222
Balance Sheet Data (at period end)
Current assets (a)$5,375$4,174

First 8 of 15 rows. The CSV has all of them.

Table 48 after “Purchases of Equity Securities- Certain information regarding purchases made by or on behalf of the company or any affiliated purchaser (as ”

Download CSV
PeriodTotal Numberof SharesPurchased(Thousands)Average Price Paid Per ShareTotal Numbers of SharesPurchased as Part ofPublicly AnnouncedProgram (1) (Thousands)Approximate DollarValue of Shares thatMay Yet be PurchasedUnder the Program (1)(Millions)
April 2021840$286.64840$3,991
May 20211,480$297.711,480$3,551
June 20211,732$292.031,732$3,045
Second Quarter 20214,052$292.994,052$3,045

Table 49 after “Item 6. Exhibits”

Download CSV
(a)Exhibits
*10.012021 Linde plc Long Term Incentive Plan
31.01Rule 13a-14(a) Certification
31.02Rule 13a-14(a) Certification
32.01Section 1350 Certification (such certifications are furnished for the information of the Commission and shall not be deemed incorporated by reference into any filing under the Securities Act or the Exchange Act).
32.02Section 1350 Certification (such certifications are furnished for the information of the Commission and shall not be deemed incorporated by reference into any filing under the Securities Act or the Exchange Act).
101.INSXBRL Instance Document: The XBRL Instance Document does not appear in the Interactive Data File because its XBRL tags are embedded within the Inline XBRL document.
101.SCHXBRL Taxonomy Extension Schema

First 8 of 12 rows. The CSV has all of them.