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

48 tables with numbers, filed Jul 27, 2023. 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.)
10 Riverview Drive,Forge
Danbury, Connecticut43 Church Street West
United States 06810Woking, Surrey GU21 6HT
United Kingdom
(Address of principal executive offices) (Zip Code)
(203) 837 - 2000+44 14 83 242200

First 8 of 9 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, 2023 and 20224
Consolidated Statements of Income - Six Months Ended June 30, 2023 and 20225
Consolidated Statements of Comprehensive Income - Quarters Ended June 30, 2023 and 20226
Consolidated Statements of Comprehensive Income - Six Months Ended June 30, 2023 and 20227
Condensed Consolidated Balance Sheets - June 30, 2023 and December 31, 20228

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

Table 3 after “(UNAUDITED)”

Download CSV
Quarter Ended June 30,
20232022
Sales$8,204$8,457
Cost of sales, exclusive of depreciation and amortization4,3164,940
Selling, general and administrative833771
Depreciation and amortization9601,091
Research and development3537
Other charges22993

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

Table 4 after “(UNAUDITED)”

Download CSV
Six Months Ended June 30,
20232022
Sales$16,397$16,668
Cost of sales, exclusive of depreciation and amortization8,7479,738
Selling, general and administrative1,6551,573
Depreciation and amortization1,9082,203
Research and development7172
Other charges40989

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

Table 5 after “(UNAUDITED)”

Download CSV
Quarter Ended June 30,
20232022
NET INCOME (INCLUDING NONCONTROLLING INTERESTS)$1,612$410
OTHER COMPREHENSIVE INCOME (LOSS)
Translation adjustments:
Foreign currency translation adjustments(96)(1,570)
Reclassification to net income—(134)
Income taxes15

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

Table 6 after “(UNAUDITED)”

Download CSV
Six Months Ended June 30,
20232022
NET INCOME (INCLUDING NONCONTROLLING INTERESTS)$3,164$1,620
OTHER COMPREHENSIVE INCOME (LOSS)
Translation adjustments:
Foreign currency translation adjustments133(1,510)
Reclassification to net income—(134)
Income taxes1(7)

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

Table 7 after “(UNAUDITED)”

Download CSV
June 30, 2023December 31, 2022
Assets
Cash and cash equivalents$3,357$5,436
Accounts receivable - net4,7994,559
Contract assets156124
Inventories2,0791,978
Prepaid and other current assets1,020950
Total Current Assets11,41113,047

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

Table 8 after “(UNAUDITED)”

Download CSV
Six Months Ended June 30,
20232022
Increase (Decrease) in Cash and Cash Equivalents
Operations
Net income - Linde plc$3,091$1,546
Add: Noncontrolling interests7374
Net Income (including noncontrolling interests)3,1641,620
Adjustments to reconcile net income to net cash provided by operating activities:

First 8 of 39 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. Other Charges11
Note 3. Supplemental Information13
Note 4. Debt14
Note 5. Financial Instruments14
Note 6. Fair Value Disclosures16
Note 7. Earnings Per Share – Linde plc Shareholders17
Note 8. Retirement Programs18

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 pre-tax Other charges for the six months ended June 30, 2023:”

Download CSV
Six Months Ended June 30, 2023
(millions of dollars)Severance costsOther cost reduction chargesTotal cost reduction program related chargesOther chargesTotal other charges
Balance, December 31, 2022$281$27$308$12$320
2023 Other charges24—241640
Less: Cash payments / receipts(100)(1)(101)—(101)
Less: Non-cash charges———77
Foreign currency translation and other(3)—(3)—(3)
Balance, June 30, 2023$202$26$228$35$263

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

Download CSV
(Millions of dollars)June 30, 2023December 31, 2022
Inventories
Raw materials and supplies$600$567
Work in process401368
Finished goods1,0781,043
Total inventories$2,079$1,978

Table 12 after “The following is a summary of Linde's outstanding debt at June 30, 2023 and December 31, 2022:”

Download CSV
(Millions of dollars)June 30, 2023December 31, 2022
SHORT-TERM
Commercial paper$2,765$3,926
Other bank borrowings (primarily non U.S.)253191
Total short-term debt3,0184,117
LONG-TERM (a)
(U.S. dollar denominated unless otherwise noted)
2.70% Notes due 2023 (c)—501

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

Table 13 after “14”

Download CSV
Fair Value
Notional AmountsAssets (a)Liabilities (a)
(Millions of dollars)June 30, 2023December 31, 2022June 30, 2023December 31, 2022June 30, 2023December 31, 2022
Derivatives Not Designated as Hedging Instruments:
Currency contracts:
Balance sheet items$3,477$3,056$26$13$8$7
Forecasted transactions395449139119
Cross-currency swaps442———1

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

Table 14 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)2023202220232022
Derivatives Not Designated as Hedging Instruments
Currency contracts:
Balance sheet items
Debt-related$(44)$(41)$(83)$10
Other balance sheet items(1)4(2)(8)

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

Table 15 after “Table of Contents”

Download CSV
Fair Value Measurements Using
Level 1Level 2Level 3
(Millions of dollars)June 30, 2023December 31, 2022June 30, 2023December 31, 2022June 30, 2023December 31, 2022
Assets
Derivative assets$—$—$55$28$—$—
Investments and securities*2120——1313
Total$21$20$55$2813$13
Liabilities

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

Table 16 after “Basic and diluted earnings per share is computed by dividing Net income – Linde plc for the period by the weighted average number of either ”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
2023202220232022
Numerator (Millions of dollars)
Net Income – Linde plc$1,575$372$3,091$1,546
Denominator (Thousands of shares)
Weighted average shares outstanding489,061500,535490,201503,626
Shares earned and issuable under compensation plans557499526467
Weighted average shares used in basic earnings per share489,618501,034490,727504,093

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

Table 17 after “and 2022 are shown below:”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)2023202220232022
Amount recognized in Operating Profit
Service cost$21$32$42$65
Amount recognized in Net pension and OPEB cost (benefit), excluding service cost
Interest cost9451186104
Expected return on plan assets(131)(132)(260)(268)
Net amortization and deferral(8)19(16)38

First 8 of 10 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 quarter and six months ended Jun”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)2023202220232022
SALES(a)
Americas$3,541$3,518$7,092$6,759
EMEA2,1602,1444,3374,292
APAC1,6831,6513,2813,253
Engineering4956441,0351,372
Other325500652992

First 8 of 9 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 quarter and six months ended Jun”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)2023202220232022
SEGMENT OPERATING PROFIT
Americas$1,070$910$2,095$1,814
EMEA6305361,2371,039
APAC472426895825
Engineering107105256248
Other7119(33)

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

Table 20 after “Table of Contents”

Download CSV
Quarter Ended June 30,
(Millions of dollars)20232022
ActivityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal EquityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal Equity
Balance, beginning of period$39,970$1,353$41,323$42,963$1,414$44,377
Net income (a)1,575371,61237238410
Other comprehensive income (loss)(89)(23)(112)(1,528)(17)(1,545)
Noncontrolling interests:
Additions (reductions)(11)(7)(18)—(53)(53)

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

Table 21 after “Table of Contents”

Download CSV
Six Months Ended June 30,
(Millions of dollars)20232022
ActivityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal EquityLinde plc Shareholders’ EquityNoncontrolling InterestsTotal Equity
Balance, beginning of period$40,028$1,346$41,374$44,035$1,393$45,428
Net income (a)3,091733,1641,546741,620
Other comprehensive income (loss)(117)(25)(142)(1,418)(29)(1,447)
Noncontrolling interests:
Additions (reductions)(11)(5)(16)—(49)(49)

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

Table 22 after “The components of Accumulated other comprehensive income (loss) are as follows:”

Download CSV
June 30,December 31,
(Millions of dollars)20232022
Cumulative translation adjustment - net of taxes:
Americas$(3,572)$(3,942)
EMEA(881)(1,249)
APAC(1,238)(835)
Engineering(165)(241)
Other231483

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

Table 23 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, 2023
SalesAmericasEMEAAPACEngineeringOtherTotal%
Merchant$1,094$704$570$—$53$2,42130%
On-Site756493677——1,92623%
Packaged Gas1,638946366—122,96236%
Other53177049526089511%
Total$3,541$2,160$1,683$495$325$8,204100%

Table 24 after “Table of Contents”

Download CSV
(Millions of dollars)Quarter Ended June 30, 2022
SalesAmericasEMEAAPACEngineeringOtherTotal%
Merchant$941$634$562$—$40$2,17726%
On-Site1,049610631——2,29027%
Packaged Gas1,473884389—92,75533%
Other5516696444511,23515%
Total$3,518$2,144$1,651$644$500$8,457100%

Table 25 after “Table of Contents”

Download CSV
(Millions of dollars)Six Months Ended June 30, 2023
SalesAmericasEMEAAPACEngineeringOtherTotal%
Merchant$2,137$1,404$1,122$—$108$4,77129%
On-Site1,5601,0311,321——3,91224%
Packaged Gas3,2761,874721—325,90336%
Other119281171,0355121,81111%
Total$7,092$4,337$3,281$1,035$652$16,397100%
(Millions of dollars)Six Months Ended June 30, 2022

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

Table 26 after “The following table summarizes the fair value of identifiable assets acquired and liabilities assumed in the acquisition of nexAir, LLC as o”

Download CSV
(Millions of dollars)January 5, 2023
Assets:
Cash and cash equivalents$55
Other current assets - net48
Property, plant and equipment, net241
Other intangible assets - net245
Other long-term liabilities - net(5)
Total identifiable net assets$584

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

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

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars, except per share data)20232022Variance20232022Variance
Sales$8,204$8,457(3)%$16,397$16,668(2)%
Cost of sales, exclusive of depreciation and amortization$4,316$4,940(13)%$8,747$9,738(10)%
As a percent of sales52.6%58.4%53.3%58.4%
Selling, general and administrative$833$7718%$1,655$1,5735%
As a percent of sales10.2%9.1%10.1%9.4%
Depreciation and amortization$960$1,091(12)%$1,908$2,203(13)%

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

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

Download CSV
Quarter Ended June 30, 2023 vs. 2022Six Months Ended June 30, 2023 vs. 2022
% Change% Change
Factors Contributing to Changes - Sales
Volume(1)%(1)%
Price/Mix7%7%
Cost pass-through(4)%(2)%
Currency(1)%(2)%
Acquisitions/divestitures(2)%(2)%

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

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

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20232022Variance20232022Variance
SALES
Americas$3,541$3,5181%$7,092$6,7595%
EMEA2,1602,1441%4,3374,2921%
APAC1,6831,6512%3,2813,2531%
Engineering495644(23)%1,0351,372(25)%
Other325500(35)%652992(34)%

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

Table 30 after “Americas”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20232022Variance20232022Variance
Sales$3,541$3,5181%$7,092$6,7595%
Operating profit$1,070$91018%$2,095$1,81415%
As a percent of sales30.2%25.9%29.5%26.8%

Table 31 after “Americas”

Download CSV
Quarter Ended June 30, 2023 vs. 2022Six Months Ended June 30, 2023 vs. 2022
% Change% Change
Factors Contributing to Changes - Sales
Volume(1)%—%
Price/Mix6%7%
Cost pass-through(7)%(5)%
Currency—%—%
Acquisitions/divestitures3%3%

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

Table 32 after “EMEA”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20232022Variance20232022Variance
Sales$2,160$2,1441%$4,337$4,2921%
Operating profit$630$53618%$1,237$1,03919%
As a percent of sales29.2%25.0%28.5%24.2%

Table 33 after “Table of Contents”

Download CSV
Quarter Ended June 30, 2023 vs. 2022Six Months Ended June 30, 2023 vs. 2022
% Change% Change
Factors Contributing to Changes - Sales
Volume(4)%(4)%
Price/Mix11%12%
Cost pass-through(3)%(1)%
Currency—%(3)%
Acquisitions/divestitures(3)%(3)%

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

Table 34 after “APAC”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20232022Variance20232022Variance
Sales$1,683$1,6512%$3,281$3,2531%
Operating profit$472$42611%$895$8258%
As a percent of sales28.0%25.8%27.3%25.4%

Table 35 after “APAC”

Download CSV
Quarter Ended June 30, 2023 vs. 2022Six Months Ended June 30, 2023 vs. 2022
% Change% Change
Factors Contributing to Changes - Sales
Volume/Equipment3%2%
Price/Mix5%5%
Cost pass-through(1)%(1)%
Currency(5)%(5)%
Acquisitions/divestitures—%—%

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

Table 36 after “Engineering”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20232022Variance20232022Variance
Sales$495$644(23)%$1,035$1,372(25)%
Operating profit$107$1052%$256$2483%
As a percent of sales21.6%16.3%24.7%18.1%

Table 37 after “Engineering”

Download CSV
Quarter Ended June 30, 2023 vs. 2022Six Months Ended June 30, 2023 vs. 2022
% Change% Change
Factors Contributing to Changes - Sales
Currency2%(2)%
Other(25)%(23)%
(23)%(25)%

Table 38 after “Other”

Download CSV
Quarter Ended June 30,Six Months Ended June 30,
(Millions of dollars)20232022Variance20232022Variance
Sales$325$500(35)%$652$992(34)%
Operating profit (loss)$7$11(36)%$9$(33)127%
As a percent of sales2.2%2.2%1.4%(3.3)%

Table 39 after “Other”

Download CSV
Quarter Ended June 30, 2023 vs. 2022Six Months Ended June 30, 2023 vs. 2022
% Change% Change
Factors Contributing to Changes - Sales
Volume/price4%5%
Currency—%—%
Acquisitions/divestitures(39)%(39)%
(35)%(34)%

Table 40 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 2023 Consolidated SalesExchange Rate for Income StatementExchange Rate for Balance Sheet
Year-To-Date AverageJune 30,December 31,
Currency2023202220232022
Euro19%0.930.910.920.93
Chinese yuan8%6.936.477.256.90
British pound5%0.810.770.790.83
Australian dollar4%1.481.391.501.47
Brazilian real4%5.075.064.795.28

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

Table 41 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,
20232022
NET CASH PROVIDED BY (USED FOR):
OPERATING ACTIVITIES
Net income (including noncontrolling interests)$3,164$1,620
Non-cash charges (credits):
Add: Depreciation and amortization1,9082,203
Add: Deferred income taxes(61)(221)

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

Table 42 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,
2023202220232022
Adjusted Operating Profit and Operating Margin
Reported operating profit$2,011$589$3,944$2,069
Add: Other charges2299340989
Add: Purchase accounting impacts - Linde AG (c)253406508835
Total adjustments2751,3995481,824
Adjusted operating profit$2,286$1,988$4,492$3,893

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

Table 43 after “Table of Contents”

Download CSV
Adjusted Income Taxes (a)
Reported income taxes$438$286$868$655
Add: Purchase accounting impacts - Linde AG (c)67108124216
Add: Other charges3410479101
Total adjustments101212203317
Adjusted income taxes$539$498$1,071$972
Adjusted Effective Tax Rate (a)
Reported income before income taxes and equity investments$2,004$646$3,945$2,181

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

Table 44 after “Table of Contents”

Download CSV
Adjusted Diluted EPS (b)
Reported diluted EPS$3.19$0.74$6.25$3.04
Add: Other charges(0.02)1.76(0.08)1.75
Add: Purchase accounting impacts - Linde AG (c)0.400.600.811.24
Total adjustments0.382.360.732.99
Adjusted diluted EPS$3.57$3.10$6.98$6.03
Reported percentage change331%(54)%106%(12)%
Adjusted percentage change15%15%16%16%

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

Table 45 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, 2023December 31, 2022
(Millions of dollars)
Debt$17,490$17,914
Less: cash and cash equivalents(3,357)(5,436)
Net debt14,13312,478
Less: purchase accounting impacts - Linde AG(10)(22)
Adjusted net debt$14,123$12,456

Table 46 after “Table of Contents”

Download CSV
(Millions of dollars)
Statement of Income DataSix Months Ended June 30, 2023Twelve Months Ended December 31, 2022
Sales$4,026$8,850
Operating profit7751,337
Net income300675
Transactions with non-guarantor subsidiaries1,2082,241
Balance Sheet Data (at period end)
Current assets (a)$4,896$11,478

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

Table 47 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 (1)(Millions)
April 2023830$361.66830$4,179
May 2023997$361.52997$3,818
June 2023682$368.70682$3,567
Second Quarter 20232,509$363.522,509$3,567

Table 48 after “Item 6. Exhibits”

Download CSV
(a)Exhibits
4.1Amended and Restated Fiscal Agency Agreement, dated May 4, 2023, among Linde plc, as Issuer, and Deutsche Bank Aktiengesellschaft, as Fiscal Agent and Paying Agent (filed as Exhibit 4.6 to Linde plc’s Current Report on Form 8-K dated June 12, 2033, File No. 001-38730, and is incorporated by reference)
4.2Form of Indenture for Debt Securities between Linde plc, as issuer, and The Bank of New York Mellon Trust Company, N.A., as trustee ,including form of debt securities and related guarantees (filed as Exhibit 4.2 to Linde plc’s Registration Statement on Form S-3 dated May 3, 2023, and is incorporated by reference)
4.3Form of Indenture for Debt Securities between Linde Inc., as issuer, and The Bank of New York Mellon Trust Company, N.A., as trustee ,including form of debt securities and related guarantees, (filed as Exhibit 4.3 to Linde plc’s Registration Statement on Form S-3 dated May 3, 2023, and is incorporated by reference)
4.4Form of Indenture for Debt Securities between Linde Finance B.V., as issuer, and The Bank of New York Mellon Trust Company, N.A., as trustee, including form of debt securities and related guarantees, (filed as Exhibit 4.4 to Linde plc’s Registration Statement on Form S-3 dated May 3, 2023, and is incorporated by reference)
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).

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