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

47 tables with numbers, filed Nov 5, 2020. 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 Priestley Road,
Surrey Research Park,
Guildford,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 September 30, 2020 and 20194
Consolidated Statements of Income - Nine Months Ended September 30, 2020 and 20195
Consolidated Statements of Comprehensive Income - Quarters Ended September 30, 2020 and 20196
Consolidated Statements of Comprehensive Income - Nine Months Ended September 30, 2020 and 20197
Condensed Consolidated Balance Sheets - September 30, 2020 and December 31, 20198

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

Table 3 after “(UNAUDITED)”

Download CSV
Quarter Ended September 30,
20202019
Sales$6,855$7,000
Cost of sales, exclusive of depreciation and amortization3,8354,061
Selling, general and administrative770850
Depreciation and amortization1,1681,095
Research and development3644
Cost reduction programs and other charges48125

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

Table 4 after “(UNAUDITED)”

Download CSV
Nine Months Ended September 30,
20202019
Sales$19,971$21,148
Cost of sales, exclusive of depreciation and amortization11,29712,457
Selling, general and administrative2,3912,613
Depreciation and amortization3,4343,513
Research and development114135
Cost reduction programs and other charges428355

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

Table 5 after “(UNAUDITED)”

Download CSV
Quarter Ended September 30,
20202019
NET INCOME (INCLUDING NONCONTROLLING INTERESTS)$731$738
OTHER COMPREHENSIVE INCOME (LOSS)
Translation adjustments:
Foreign currency translation adjustments696(1,183)
Reclassification to net income——
Income taxes7(6)

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

Table 6 after “(UNAUDITED)”

Download CSV
Nine Months Ended September 30,
20202019
NET INCOME (INCLUDING NONCONTROLLING INTERESTS)$1,822$1,843
OTHER COMPREHENSIVE INCOME (LOSS)
Translation adjustments:
Foreign currency translation adjustments(1,299)(1,230)
Reclassification to net income—12
Income taxes31(1)

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

Table 7 after “(UNAUDITED)”

Download CSV
September 30, 2020December 31, 2019
Assets
Cash and cash equivalents$5,199$2,700
Accounts receivable - net4,0334,322
Contract assets170368
Inventories1,7331,697
Assets held for sale3125
Prepaid and other current assets1,1271,140

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

Table 8 after “(UNAUDITED)”

Download CSV
Nine Months Ended September 30,
20202019
Increase (Decrease) in Cash and Cash Equivalents
Operations
Net income - Linde plc$1,731$1,774
Less: Income from discontinued operations, net of tax and noncontrolling interests(3)(98)
Add: Noncontrolling interests from continuing operations9162
Income from continuing operations (including noncontrolling interests)1,8191,738

First 8 of 48 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 Charges12
Note 3. Supplemental Information13
Note 4. Debt15
Note 5. Financial Instruments16
Note 6. Fair Value Disclosures19
Note 7. Earnings Per Share – Linde plc Shareholders20
Note 8. Retirement Programs21

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

Table 10 after “The following table summarizes the activities related to the company's cost reduction charges for the quarter and nine months ended Septembe”

Download CSV
Quarter Ended September 30, 2020
(millions of dollars)Severance costsOther cost reduction chargesTotal cost reduction program related chargesMerger-related and other chargesTotal
Americas$2$—$2$6$8
EMEA17421526
APAC2—2—2
Engineering1(1)———
Other9514(2)12
Total$31$8$39$9$48

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

Table 11 after “The following table summarizes the activities related to the company's cost reduction related charges for the nine months ended September 30”

Download CSV
(millions of dollars)Severance costsOther cost reduction chargesTotal cost reduction program related chargesMerger-related and other chargesTotal
Balance, December 31, 2019$117$16$133$67$200
2020 Cost Reduction Programs and Other Charges2814933098428
Less: Cash payments(103)(13)(116)(45)(161)
Less: Non-cash charges—(32)(32)(71)(103)
Foreign currency translation and other819413
Balance, September 30, 2020$303$21$324$53$377

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

Download CSV
(Millions of dollars)September 30, 2020December 31, 2019
Inventories
Raw materials and supplies$400$396
Work in process374331
Finished goods959970
Total inventories$1,733$1,697

Table 13 after “The following is a summary of Linde's outstanding debt at September 30, 2020 and December 31, 2019:”

Download CSV
(Millions of dollars)September 30, 2020December 31, 2019
SHORT-TERM
Commercial paper and U.S. bank borrowings$3,230$996
Other bank borrowings (primarily international)794736
Total short-term debt4,0241,732
LONG-TERM (a)
(U.S. dollar denominated unless otherwise noted)
2.25% Notes due 2020 (e)—300

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

Table 14 after “16”

Download CSV
Fair Value
Notional AmountsAssets (a)Liabilities (a)
(Millions of dollars)September 30, 2020December 31, 2019September 30, 2020December 31, 2019September 30, 2020December 31, 2019
Derivatives Not Designated as Hedging Instruments:
Currency contracts:
Balance sheet items$6,714$7,936$30$62$97$37
Forecasted transactions9527486141215
Cross-currency swaps4271,0294535640

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

Table 15 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 September 30,Nine Months Ended September 30,
(Millions of dollars)2020201920202019
Derivatives Not Designated as Hedging Instruments
Currency contracts:
Balance sheet items
Debt-related$(74)$213$(213)$282
Other balance sheet items328(48)30

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

Table 16 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)September 30, 2020December 31, 2019September 30, 2020December 31, 2019September 30, 2020December 31, 2019
Assets
Derivative assets$—$—$148$167$—$—
Investments and securities*2118——3328
Total$21$18$148$167$33$28
Liabilities

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

Table 17 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 September 30,Nine Months Ended September 30,
2020201920202019
Numerator (Millions of dollars)
Income from continuing operations$699$728$1,728$1,676
Income from discontinued operations17398
Net Income – Linde plc$700$735$1,731$1,774
Denominator (Thousands of shares)
Weighted average shares outstanding525,339539,504527,177542,360

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

Table 18 after “The components of net pension and postretirement benefits other than pensions (“OPEB”) costs for the quarter and nine months ended September”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
PensionsOPEBPensionsOPEB
(Millions of dollars)20202019202020192020201920202019
Amount recognized in Operating Profit
Service cost$38$34$1$—$111$112$2$1
Amount recognized in Net pension and OPEB cost (benefit), excluding service cost
Interest cost52611315419446
Expected return on plan assets(122)(117)——(360)(349)——

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

Table 19 after “The table below presents sales and operating profit information about reportable segments and Other for the quarters and nine months ended S”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars)2020201920202019
SALES(a)
Americas$2,641$2,771$7,735$8,252
EMEA1,6221,6344,7034,989
APAC1,4841,4614,1154,376
Engineering6786412,0962,029
Other4304861,3221,440

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

Table 20 after “Table of Contents”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars)2020201920202019
SEGMENT OPERATING PROFIT
Americas$742$671$2,025$1,901
EMEA3703351,0281,014
APAC337308912885
Engineering106120335297
Other(40)(50)(116)(172)

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

Table 21 after “A summary of the changes in total equity for the quarter and nine months ended September 30, 2020 and 2019 is provided below:”

Download CSV
Quarter Ended September 30,
(Millions of dollars)20202019
ActivityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal EquityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal Equity
Balance, beginning of period$45,537$2,387$47,924$50,564$2,315$52,879
Net income (b)700317317352737
Other comprehensive income (loss)64840688(1,223)(50)(1,273)
Noncontrolling interests:
Additions (reductions)—1111—113113

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

Table 22 after “Table of Contents”

Download CSV
Nine Months Ended September 30,
(Millions of dollars)20202019
ActivityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal EquityLinde plc Shareholders’ EquityNoncontrolling Interests (a)Total Equity
Balance, beginning of period (a)$49,074$2,448$51,522$51,596$5,484$57,080
Net income (b)1,731911,8221,774671,841
Other comprehensive income (loss)(1,159)(48)(1,207)(1,144)(138)(1,282)
Noncontrolling interests:
Additions (reductions)—2626—(2,953)(2,953)

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

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

Download CSV
September 30,December 31,
(Millions of dollars)20202019
Cumulative translation adjustment - net of taxes:
Americas$(4,070)$(3,357)
EMEA(168)(136)
APAC(80)(140)
Engineering150(29)
Other(432)282

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

Table 24 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 September 30, 2020
SalesAmericasEMEAAPACEngineeringOtherTotal%
Merchant$739$472$526$—$34$1,77126%
On-Site622334528——1,48422%
Packaged Gas1,265799413—52,48236%
Other1517176783911,11816%
Total$2,641$1,622$1,484$678$430$6,855100%

Table 25 after “Table of Contents”

Download CSV
(Millions of dollars)Quarter Ended September 30, 2019
SalesAmericasEMEAAPACEngineeringOther (a)Total%
Merchant$760$474$523$—$52$1,80926%
On-Site676345494——1,51522%
Packaged Gas1,303815396—72,52136%
Other32—486414341,15516%
Total$2,771$1,634$1,461$641$493$7,000100%
(Millions of dollars)Nine months ended September 30, 2020

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

Table 26 after “The following table provides summary information for the quarter and nine months ended September 30, 2020 and 2019. The reported amounts are”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars, except per share data)20202019Variance20202019Variance
Sales$6,855$7,000(2)%$19,971$21,148(6)%
Cost of sales, exclusive of depreciation and amortization$3,835$4,061(6)%$11,297$12,457(9)%
As a percent of sales55.9%58.0%56.6%58.9%
Selling, general and administrative$770$850(9)%$2,391$2,613(8)%
As a percent of sales11.2%12.1%12.0%12.4%
Depreciation and amortization$1,168$1,0957%$3,434$3,513(2)%

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

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

Download CSV
Quarter Ended September 30, 2020 vs. 2019Nine Months Ended September 30, 2020 vs. 2019
% Change% Change
Factors Contributing to Changes - Sales
Volume(3)%(4)%
Price/Mix2%2%
Cost pass-through—%(1)%
Currency—%(3)%
Acquisitions/divestitures(1)%(1)%

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

Table 28 after “The reported amounts are GAAP amounts from the Condensed Consolidated Statement of Operations.”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars)20202019Variance20202019%
SALES
Americas$2,641$2,771(5)%$7,735$8,252(6)%
EMEA1,6221,634(1)%4,7034,989(6)%
APAC1,4841,4612%4,1154,376(6)%
Engineering6786416%2,0962,0293%
Other430486(12)%1,3221,440(8)%

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

Table 29 after “Americas”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars)20202019Variance20202019Variance
Reported sales$2,641$2,771(5)%$7,735$8,252(6)%
Reported operating profit$742$67111%$2,025$1,9017%
As a percent of sales28.1%24.2%26.2%23.0%

Table 30 after “Table of Contents”

Download CSV
Quarter Ended September 30, 2020 vs. 2019Nine Months Ended September 30, 2020 vs. 2019
% Change% Change
SalesSales
Factors Contributing to Changes
Volume(2)%(3)%
Price/Mix2%2%
Cost pass-through—%(1)%
Currency(4)%(3)%

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

Table 31 after “EMEA”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars)20202019Variance20202019Variance
Reported sales$1,622$1,634(1)%$4,703$4,989(6)%
Reported operating profit$370$33510%$1,028$1,0141%
As a percent of sales22.8%20.5%21.9%20.3%

Table 32 after “EMEA”

Download CSV
Quarter Ended September 30, 2020 vs. 2019Nine Months Ended September 30, 2020 vs. 2019
% Change% Change
SalesSales
Factors Contributing to Changes
Volume(4)%(4)%
Price/Mix3%2%
Cost pass-through—%(1)%
Currency2%(2)%

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

Table 33 after “APAC”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars)20202019Variance20202019Variance
Reported sales$1,484$1,4612%$4,115$4,376(6)%
Reported operating profit$337$3089%$912$8853%
As a percent of sales22.7%21.1%22.2%20.2%

Table 34 after “APAC”

Download CSV
Quarter Ended September 30, 2020 vs. 2019Nine Months Ended September 30, 2020 vs. 2019
% Change% Change
SalesReported
Factors Contributing to Changes
Volume/Equipment(1)%(4)%
Price/Mix1%1%
Cost pass-through—%(1)%
Currency2%(2)%

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

Table 35 after “Engineering”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars)20202019Variance20202019Variance
Reported sales$678$6416%$2,096$2,0293%
Reported operating profit$106$120(12)%$335$29713%
As a percent of sales15.6%18.7%16.0%14.6%

Table 36 after “Engineering”

Download CSV
Quarter Ended September 30, 2020 vs. 2019Nine Months Ended September 30, 2020 vs. 2019
% Change% Change
SalesSales
Factors Contributing to Changes
Volume2%4%
Currency4%(1)%
6%3%

Table 37 after “Other”

Download CSV
Quarter Ended September 30,Nine Months Ended September 30,
(Millions of dollars)20202019Variance20202019Variance
Reported sales$430$486(12)%$1,322$1,440(8)%
Reported operating profit (loss)$(40)$(50)20%$(116)$(172)33%
As a percent of sales(9.3)%(10.3)%(8.8)%(11.9)%

Table 38 after “Other”

Download CSV
Quarter Ended September 30, 2020 vs. 2019Nine Months Ended September 30, 2020 vs. 2019
% Change% Change
SalesSales
Factors Contributing to Changes
Volume/price(17)%(9)%
Cost pass-through2%1%
Currency3%—%
Acquisitions/divestitures—%—%

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

Table 39 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 2020 Consolidated SalesExchange Rate for Income StatementExchange Rate for Balance Sheet
Year-To-Date AverageSeptember 30,December 31,
Currency2020201920202019
Euro22%0.890.890.850.89
Chinese yuan7%6.996.866.796.96
British pound6%0.790.790.770.75
Australian dollar4%1.481.431.401.42
Brazilian real3%5.023.885.644.03

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

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

Download CSV
(Millions of dollars)Nine months ended September 30,
20202019
NET CASH PROVIDED BY (USED FOR):
OPERATING ACTIVITIES
Net income (including noncontrolling interests)$1,819$1,738
Non-cash charges (credits):
Add: Depreciation and amortization3,4343,513
Add: Amortization of merger-related inventory step-up—12

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

Table 41 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 September 30,Nine Months Ended September 30,
2020201920202019
Adjusted Sales
Reported Sales$6,855$7,000$19,971$21,148
Less: Merger-related divestitures (d)—(7)—(62)
Adjusted Sales$6,855$6,993$19,971$21,086
Adjusted Operating Profit and Operating Margin
Reported operating profit$969$1,000$2,293$2,278

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

Table 42 after “Table of Contents”

Download CSV
Add: Pension settlement charges110125
Add: Cost reduction programs and other charges12(2)11030
Less: Merger-related divestitures (d)—(1)—(5)
Less: Net gain on sale of businesses—(56)—(56)
Total adjustments8850403339
Adjusted income taxes$353$348$997$946
Adjusted Effective Tax Rate (a)
Reported income before income taxes and equity investments$972$1,001$2,344$2,255

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

Table 43 after “Table of Contents”

Download CSV
Total adjustments0.830.602.682.39
Adjusted diluted EPS from continuing operations$2.15$1.94$5.93$5.46
Adjusted EBITDA and % of Sales
Income from continuing operations$699$728$1,728$1,676
Add: Noncontrolling interests related to continuing operations3139162
Add: Net pension and OPEB cost (benefit), excluding service cost(41)2(131)(7)
Add: Interest expense38(3)8030
Add: Income taxes265298594607

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

Table 44 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
September 30, 2020December 31, 2019
(Millions of dollars)
Debt$17,803$13,956
Less: cash and cash equivalents(5,199)(2,700)
Net debt12,60411,256
Less: purchase accounting impacts - Linde AG(133)(195)
Adjusted net debt$12,471$11,061

Table 45 after “Table of Contents”

Download CSV
(Millions of dollars)
Statement of Income DataNine Months Ended September 30, 2020Twelve Months Ended December 31, 2019
Sales$4,948$6,510
Operating profit325592
Net income2702,271
Transactions with non-guarantor subsidiaries1,5213,533
Balance Sheet Data (at period end)
Current assets (a)$3,909$2,137

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

Table 46 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 (2)(Millions)
July 2020—$——$1,916
August 2020407$247.53407$1,815
September 2020463$244.13463$1,702
Third Quarter 2020870$245.72870$1,702

Table 47 after “Item 6. Exhibits”

Download CSV
(a)Exhibits
4.1Indenture, dated as of August 10, 2020, among Praxair, Inc., Linde plc and U.S. Bank National Association, as trustee (filed as Exhibit 4.1 to Linde plc’s Form 8-K dated August 10, 2020, Filing number 1-38730, and is incorporated herein by reference).
4.2Form of 1.100% Notes due 2030 with Guarantee Endorsements (filed as Exhibit 4.2 to Linde plc’s Form 8-K dated August 10, 2020, Filing number 1-38730, and is incorporated herein by reference).
4.3Form of 2.000% Notes due 2050 with Guarantee Endorsements (filed as Exhibit 4.3 to Linde plc’s Form 8-K dated August 10, 2020, Filing number 1-38730, and is incorporated herein by reference).
*10.1Second Amendment dated September 8, 2020 to the Amended and Restated 2009 Praxair, Inc Long Term Incentive Plan.
*10.2Linde Compensation Deferral Program Amended and Restated effective September 1, 2020.
*10.3Linde Inc 2018 Supplemental Retirement Income Plan A, Amended and Restated effective September 1, 2020.
*10.4Linde Inc 2018 Supplemental Retirement Income Plan B, Amended and Restated effective September 1, 2020.

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