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

44 tables with numbers, filed May 6, 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 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 March 31, 2021 and 20204
Consolidated Statements of Comprehensive Income - Quarters Ended March 31, 2021 and 20205
Condensed Consolidated Balance Sheets - March 31, 2021 and December 31, 20206
Condensed Consolidated Statements of Cash Flows - Three Months Ended March 31, 2021 and 20207
Notes to Condensed Consolidated Financial Statements8

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

Table 3 after “(UNAUDITED)”

Download CSV
Quarter Ended March 31,
20212020
Sales$7,243$6,739
Cost of sales, exclusive of depreciation and amortization4,0543,843
Selling, general and administrative787861
Depreciation and amortization1,1661,142
Research and development3544
Cost reduction programs and other charges(8)131

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

Table 4 after “(UNAUDITED)”

Download CSV
Quarter Ended March 31,
20212020
NET INCOME (INCLUDING NONCONTROLLING INTERESTS)$1,018$608
OTHER COMPREHENSIVE INCOME (LOSS)
Translation adjustments:
Foreign currency translation adjustments(657)(2,740)
Reclassification to net income (Note 13)(52)—
Income taxes(6)25

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

Table 5 after “(UNAUDITED)”

Download CSV
March 31, 2021December 31, 2020
Assets
Cash and cash equivalents$4,096$3,754
Accounts receivable - net4,1394,167
Contract assets137162
Inventories1,6951,729
Prepaid and other current assets1,0651,112
Total Current Assets11,13210,924

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

Table 6 after “(UNAUDITED)”

Download CSV
Three Months Ended March 31,
20212020
Increase (Decrease) in Cash and Cash Equivalents
Operations
Net income - Linde plc$980$573
Less: Income from discontinued operations, net of tax and noncontrolling interests(1)(2)
Add: Noncontrolling interests from continuing operations3835
Income from continuing operations (including noncontrolling interests)1,017606

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

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

Download CSV
Note 1. Summary of Significant Accounting Policies9
Note 2. Cost Reduction Programs and Other Charges9
Note 3. Supplemental Information11
Note 4. Debt12
Note 5. Financial Instruments13
Note 6. Fair Value Disclosures15
Note 7. Earnings Per Share – Linde plc Shareholders17
Note 8. Retirement Programs17

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

Table 8 after “The following table summarizes the activities related to the company's cost reduction charges for the three months ended March 31, 2021:”

Download CSV
Quarter Ended March 31, 2021
(millions of dollars)Severance costsOther cost reduction chargesTotal cost reduction program related chargesMerger-related and other chargesTotal
Americas$3$2$5$—$5
EMEA13720—20
APAC224(53)(49)
Engineering7—7—7
Other17819
Total$26$18$44$(52)$(8)

Table 9 after “The following table summarizes the activities related to the company's cost reduction related charges for the three months ended March 31, 2”

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 Charges261844(52)(8)
Less: Cash payments(54)(1)(55)(4)(59)
Less: Non-cash charges / benefits—(13)(13)5239
Foreign currency translation and other(4)—(4)(3)(7)
Balance, March 31, 2021$251$26$277$57$334

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

Download CSV
(Millions of dollars)March 31, 2021December 31, 2020
Inventories
Raw materials and supplies$364$411
Work in process347337
Finished goods984981
Total inventories$1,695$1,729

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

Download CSV
(Millions of dollars)March 31, 2021December 31, 2020
SHORT-TERM
Commercial paper$1,979$2,527
Other borrowings (primarily non U.S.)1,297724
Total short-term debt3,2763,251
LONG-TERM (a)
(U.S. dollar denominated unless otherwise noted)
3.875% Euro denominated notes due 2021 (b)709748

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

Table 12 after “The following table is a summary of the notional amount and fair value of derivatives outstanding at March 31, 2021 and December 31, 2020 fo”

Download CSV
Fair Value
Notional AmountsAssets (a)Liabilities (a)
(Millions of dollars)March 31, 2021December 31, 2020March 31, 2021December 31, 2020March 31, 2021December 31, 2020
Derivatives Not Designated as Hedging Instruments:
Currency contracts:
Balance sheet items$6,002$6,470$26$72$32$48
Forecasted transactions705823616912
Cross-currency swaps194260232467

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

Table 13 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 March 31,
(Millions of dollars)20212020
Derivatives Not Designated as Hedging Instruments
Currency contracts:
Balance sheet items
Debt-related$19$(5)
Other balance sheet items4(41)

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

Table 14 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)March 31, 2021December 31, 2020March 31, 2021December 31, 2020March 31, 2021December 31, 2020
Assets
Derivative assets$—$—$141$200$—$—
Investments and securities*2021——4547
Total$20$21$141$20045$47
Liabilities

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

Table 15 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 March 31,
20212020
Numerator (Millions of dollars)
Income from continuing operations$979$571
Income from discontinued operations12
Net Income – Linde plc$980$573
Denominator (Thousands of shares)
Weighted average shares outstanding522,103530,952

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

Table 16 after “The components of net pension and postretirement benefits other than pensions (“OPEB”) costs for the quarters ended March 31, 2021 and 2020 ”

Download CSV
Quarter Ended March 31,
PensionsOPEB
(Millions of dollars)2021202020212020
Amount recognized in Operating Profit
Service cost$40$37$—$1
Amount recognized in Net pension and OPEB cost (benefit), excluding service cost
Interest cost385211
Expected return on plan assets(131)(120)——

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

Table 17 after “The table below presents sales and operating profit information about reportable segments and Other for the quarters ended March 31, 2021 an”

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020
SALES(a)
Americas$2,840$2,677
EMEA1,7991,633
APAC1,4361,336
Engineering674608
Other494485

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

Table 18 after “The table below presents sales and operating profit information about reportable segments and Other for the quarters ended March 31, 2021 an”

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020
SEGMENT OPERATING PROFIT
Americas$795$661
EMEA451355
APAC351281
Engineering10991
Other(18)(36)

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

Table 19 after “A summary of the changes in total equity for the quarters ended March 31, 2021 and 2020 is provided below:”

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020
ActivityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal EquityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal Equity
Balance, beginning of period$47,317$2,252$49,569$49,074$2,448$51,522
Net income (a)980381,01857335608
Other comprehensive income (loss)(655)(6)(661)(2,574)(106)(2,680)
Noncontrolling interests:
Additions (reductions) (b)—(853)(853)—22

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

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

Download CSV
March 31,December 31,
(Millions of dollars)20212020
Cumulative translation adjustment - net of taxes:
Americas$(3,938)$(3,788)
EMEA6201,020
APAC327616
Engineering164354
Other(700)(1,020)

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

Table 21 after “The following tables show sales by distribution method at the consolidated level and for each reportable segment and Other for the three mon”

Download CSV
(Millions of dollars)Quarter Ended March 31, 2021
SalesAmericasEMEAAPACEngineeringOtherTotal%
Merchant$771$531$484$—$53$1,83925%
On-Site689392553——1,63423%
Packaged Gas1,332861361—62,56035%
Other4815386744351,21017%
Total$2,840$1,799$1,436$674$494$7,243100%

Table 22 after “Table of Contents”

Download CSV
(Millions of dollars)Quarter Ended March 31, 2020
SalesAmericasEMEAAPACEngineeringOtherTotal%
Merchant$726$470$459$—$47$1,70225%
On-Site650343492——1,48522%
Packaged Gas1,275811360—52,45136%
Other269256084331,10117%
Total$2,677$1,633$1,336$608$485$6,739100%

Table 23 after “The following table provides summary information for the three months ended March 31, 2021 and 2020. The reported amounts are GAAP amounts f”

Download CSV
Quarter Ended March 31,
(Millions of dollars, except per share data)20212020Variance
Sales$7,243$6,7397%
Cost of sales, exclusive of depreciation and amortization$4,054$3,8435%
As a percent of sales56.0%57.0%
Selling, general and administrative$787$861(9)%
As a percent of sales10.9%12.8%
Depreciation and amortization$1,166$1,1422%

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

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

Download CSV
Quarter Ended March 31, 2021 vs. 2020
% Change
Factors Contributing to Changes - Sales
Volume3%
Price/Mix2%
Cost pass-through1%
Currency4%
Acquisitions/divestitures(3)%

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

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

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020Variance
SALES
Americas$2,840$2,6776%
EMEA1,7991,63310%
APAC1,4361,3367%
Engineering67460811%
Other4944852%

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

Table 26 after “Americas”

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020Variance
Sales$2,840$2,6776%
Operating profit$795$66120%
As a percent of sales28.0%24.7%

Table 27 after “Americas”

Download CSV
Quarter Ended March 31, 2021 vs. 2020
% Change
Sales
Factors Contributing to Changes - Sales
Volume4%
Price/Mix3%
Cost pass-through1%
Currency(2)%

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

Table 28 after “EMEA”

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020Variance
Sales$1,799$1,63310%
Operating profit$451$35527%
As a percent of sales25.1%21.7%

Table 29 after “EMEA”

Download CSV
Quarter Ended March 31, 2021 vs. 2020
% Change
Sales
Factors Contributing to Changes - Sales
Volume1%
Price/Mix3%
Cost pass-through1%
Currency7%

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

Table 30 after “APAC”

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020Variance
Sales$1,436$1,3367%
Operating profit$351$28125%
As a percent of sales24.4%21.0%

Table 31 after “APAC”

Download CSV
Quarter Ended March 31, 2021 vs. 2020
% Change
Sales
Factors Contributing to Changes - Sales
Volume/Equipment10%
Price/Mix1%
Cost pass-through1%
Currency6%

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

Table 32 after “Engineering”

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020Variance
Sales$674$60811%
Operating profit$109$9120%
As a percent of sales16.2%15.0%

Table 33 after “Table of Contents”

Download CSV
Quarter Ended March 31, 2021 vs. 2020
% Change
Sales
Factors Contributing to Changes - Sales
Volume4%
Currency7%
11%

Table 34 after “Other”

Download CSV
Quarter Ended March 31,
(Millions of dollars)20212020Variance
Sales$494$4852%
Operating profit (loss)$(18)$(36)50%
As a percent of sales(3.6)%(7.4)%

Table 35 after “Other”

Download CSV
Quarter Ended March 31, 2021 vs. 2020
% Change
Sales
Factors Contributing to Changes - Sales
Volume/price(4)%
Cost pass-through1%
Currency5%
Acquisitions/divestitures—%

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

Table 36 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 AverageMarch 31,December 31,
Currency2021202020212020
Euro21%0.830.910.850.82
Chinese yuan8%6.486.986.556.53
British pound6%0.730.780.730.73
Australian dollar4%1.291.521.321.30
Brazilian real4%5.464.435.705.20

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

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

Download CSV
(Millions of dollars)Three months ended March 31,
20212020
NET CASH PROVIDED BY (USED FOR):
OPERATING ACTIVITIES
Net income (including noncontrolling interests)$1,017$606
Non-cash charges (credits):
Add: Depreciation and amortization1,1661,142
Add: Deferred income taxes(65)(107)

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

Table 38 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 March 31,
20212020
Adjusted Operating Profit and Operating Margin
Reported operating profit$1,213$733
Add: Cost reduction programs and other charges(8)131
Add: Purchase accounting impacts - Linde AG (c)483488
Total adjustments475619
Adjusted operating profit$1,688$1,352

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

Table 39 after “Table of Contents”

Download CSV
Adjusted Income Taxes (a)
Reported income taxes$268$165
Add: Purchase accounting impacts - Linde AG (c)118122
Add: Cost reduction programs and other charges2036
Total adjustments138158
Adjusted income taxes$406$323
Adjusted Effective Tax Rate (a)
Reported income before income taxes and equity investments$1,242$754

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

Table 40 after “Table of Contents”

Download CSV
Adjusted EBITDA and % of Sales
Income from continuing operations$979$571
Add: Noncontrolling interests related to continuing operations3835
Add: Net pension and OPEB cost (benefit), excluding service cost(49)(45)
Add: Interest expense2024
Add: Income taxes268165
Add: Depreciation and amortization1,1661,142
EBITDA from continuing operations$2,422$1,892

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

Table 41 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
March 31, 2021December 31, 2020
(Millions of dollars)
Debt$15,750$16,154
Less: cash and cash equivalents(4,096)(3,754)
Net debt11,65412,400
Less: purchase accounting impacts - Linde AG(98)(121)
Adjusted net debt$11,556$12,279

Table 42 after “Table of Contents”

Download CSV
(Millions of dollars)
Statement of Income DataThree Months Ended March 31, 2021Twelve Months Ended December 31, 2020
Sales$1,720$6,772
Operating profit179760
Net income87660
Transactions with non-guarantor subsidiaries4242,082
Balance Sheet Data (at period end)
Current assets (a)$3,227$3,117

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

Table 43 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,2) (Thousands)Approximate DollarValue of Shares thatMay Yet be PurchasedUnder the Program (2)(Millions)
January 2021537$257.37537$1,138
February 20211,240$251.631,240$4,688
March 20211,719$265.401,719$4,232
First Quarter 20213,496$259.283,496$4,232

Table 44 after “Item 6. Exhibits”

Download CSV
(a)Exhibits
10.01First Amendment to the Linde Compensation Deferral Program effective April 1, 2021.
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.