tickdelta
Sign in

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

← Filings of LDOS

Tables in the 10-Q of Leidos Holdings, Inc.

37 tables with numbers, filed May 3, 2022. 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 “TABLE OF CONTENTS”

Download CSV
Part IPage
Item 1.Financial Statements (Unaudited)1
Condensed Consolidated Balance Sheets1
Condensed Consolidated Statements of Income2
Condensed Consolidated Statements of Comprehensive Income3
Condensed Consolidated Statements of Equity4
Condensed Consolidated Statements of Cash Flows5
Notes to Condensed Consolidated Financial Statements6

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

Table 2 after “CONDENSED CONSOLIDATED BALANCE SHEETS (UNAUDITED)”

Download CSV
April 1, 2022December 31, 2021
(in millions)
Assets:
Cash and cash equivalents$297$727
Receivables, net2,4192,189
Inventory, net279274
Other current assets492429
Total current assets3,4873,619

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

Table 3 after “CONDENSED CONSOLIDATED STATEMENTS OF INCOME (UNAUDITED)”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions, except per share amounts)
Revenues$3,494$3,315
Cost of revenues2,9822,848
Selling, general and administrative expenses236159
Acquisition, integration and restructuring costs35
Equity loss (earnings) of non-consolidated subsidiaries2(5)

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

Table 4 after “CONDENSED CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (UNAUDITED)”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions)
Net income$177$205
Foreign currency translation adjustments2(4)
Unrecognized gain on derivative instruments2913
Pension adjustments1—
Total other comprehensive income, net of taxes329

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

Table 5 after “CONDENSED CONSOLIDATED STATEMENTS OF EQUITY (UNAUDITED)”

Download CSV
Shares of common stockAdditional paid-in capitalRetained earningsAccumulated other comprehensive incomeLeidos Holdings, Inc. stockholders' equityNon-controlling interestTotal
(in millions, except for per share amounts)
Balance at December 31, 2021140$2,423$1,880$(12)$4,291$53$4,344
Net income——175—1752177
Other comprehensive income, net of taxes———3232—32
Issuances of stock115——15—15
Repurchases of stock and other(4)(526)——(526)—(526)
Dividends of $0.36 per share——(48)—(48)—(48)

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

Table 6 after “CONDENSED CONSOLIDATED STATEMENTS OF EQUITY (UNAUDITED)”

Download CSV
Shares of common stockAdditional paid-in capitalRetained earningsAccumulated other comprehensive lossLeidos Holdings, Inc. stockholders' equityNon-controlling interestTotal
(in millions, except for per share amounts)
Balance at January 1, 2021142$2,580$1,328$(46)$3,862$9$3,871
Net income——205—205—205
Other comprehensive income, net of taxes———99—9
Issuances of stock—14——14—14
Repurchases of stock and other(1)(123)——(123)—(123)
Dividends of $0.34 per share——(49)—(49)—(49)

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

Table 7 after “CONDENSED CONSOLIDATED STATEMENTS OF CASH FLOWS (UNAUDITED)”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions)
Cash flows from operations:
Net income$177$205
Adjustments to reconcile net income to net cash provided by operations:
Depreciation and amortization8577
Stock-based compensation1615

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

Table 8 after “Changes in estimates on contracts were as follows:”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions, except per share amounts)
Favorable impact$41$31
Unfavorable impact(26)(19)
Net impact to income before income taxes$15$12
Impact on diluted EPS attributable to Leidos common stockholders$0.08$0.06

Table 9 after “Disaggregated revenues by customer-type were as follows:”

Download CSV
Three Months Ended April 1, 2022
Defense SolutionsCivilHealthTotal
(in millions)
DoD and U.S. Intelligence Community$1,539$20$238$1,797
Other government agencies(1)2226133851,220
Commercial and non-U.S. customers28714727461
Total$2,048$780$650$3,478

Table 10 after “Disaggregated revenues by customer-type were as follows:”

Download CSV
Three Months Ended April 2, 2021
Defense SolutionsCivilHealthTotal
(in millions)
DoD and U.S. Intelligence Community$1,407$13$158$1,578
Other government agencies(1)2726054071,284
Commercial and non-U.S. customers27812526429
Total$1,957$743$591$3,291

Table 11 after “Disaggregated revenues by contract-type were as follows:”

Download CSV
Three Months Ended April 1, 2022
Defense SolutionsCivilHealthTotal
(in millions)
Cost-reimbursement and fixed-price-incentive-fee$1,183$408$167$1,758
Firm-fixed-price6182554171,290
Time-and-materials and fixed-price-level-of-effort24711766430
Total$2,048$780$650$3,478

Table 12 after “Disaggregated revenues by contract-type were as follows:”

Download CSV
Three Months Ended April 2, 2021
Defense SolutionsCivilHealthTotal
(in millions)
Cost-reimbursement and fixed-price-incentive-fee$1,163$374$99$1,636
Firm-fixed-price5532623921,207
Time-and-materials and fixed-price-level-of-effort241107100448
Total$1,957$743$591$3,291

Table 13 after “Disaggregated revenues by geographic location were as follows:”

Download CSV
Three Months Ended April 1, 2022
Defense SolutionsCivilHealthTotal
(in millions)
United States$1,810$741$650$3,201
International23839—277
Total$2,048$780$650$3,478

Table 14 after “Disaggregated revenues by geographic location were as follows:”

Download CSV
Three Months Ended April 2, 2021
Defense SolutionsCivilHealthTotal
(in millions)
United States$1,713$704$591$3,008
International24439—283
Total$1,957$743$591$3,291

Table 15 after “The components of contract assets and contract liabilities consisted of the following:”

Download CSV
Balance sheet line itemApril 1, 2022December 31, 2021
(in millions)
Contract assets - current:
Unbilled receivablesReceivables, net$1,078$1,022
Contract liabilities - current:
Deferred revenue (1)Accounts payable and accrued liabilities$382$364
Contract liabilities - non-current:
Deferred revenue (1)Other long-term liabilities$25$24

Table 16 after “The following table presents changes in the carrying amount of goodwill by reportable segment:”

Download CSV
Defense SolutionsCivilHealthTotal
(in millions)
Goodwill at January 1, 2021$3,300$2,047$966$6,313
Acquisitions of businesses4255—430
Divestiture of a business(1)——(1)
Goodwill re-allocation(17)17——
Foreign currency translation adjustments(26)28—2
Goodwill at December 31, 2021$3,681$2,097$966$6,744

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

Table 17 after “Intangible assets, net consisted of the following:”

Download CSV
April 1, 2022December 31, 2021
Gross carrying valueAccumulated amortizationNet carrying valueGross carrying valueAccumulated amortizationNet carrying value
(in millions)
Finite-lived intangible assets:
Programs$1,701$(866)$835$1,722$(830)$892
Software and technology230(127)103230(121)109
Customer relationships91(16)7597(18)79
Backlog6(6)—38(37)1

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

Table 18 after “The estimated annual amortization expense as of April 1, 2022, was as follows:”

Download CSV
Fiscal year ending
(in millions)
2022 (remainder of year)$173
2023203
2024150
2025120
202696
2027 and thereafter271

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

Table 19 after “The financial instruments measured at fair value on a recurring basis primarily consisted of the following:”

Download CSV
April 1, 2022December 31, 2021
Carrying valueFair valueCarrying valueFair value
(in millions)
Financial liabilities:
Derivatives$13$13$53$53

Table 20 after “The fair value of the interest rate swaps was as follows:”

Download CSV
Liability derivatives
Balance sheet line itemApril 1, 2022December 31, 2021
(in millions)
Cash flow interest rate swapsOther long-term liabilities$13$53

Table 21 after “The effect of the cash flow hedges on other comprehensive income (loss) and earnings for the periods presented was as follows:”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions)
Total interest expense, net presented in the condensed consolidated statements of income in which the effects of cash flow hedges are recorded$48$45
Amount recognized in other comprehensive income$32$12
Amount reclassified from accumulated other comprehensive income (loss) to interest expense, net$6$5

Table 22 after “Our debt consisted of the following:”

Download CSV
Stated interest rateEffective interest rateApril 1, 2022(1)December 31, 2021(1)
(in millions)
Short-term debt:
Commercial paper0.52%-1.13%Various$75$—
Senior unsecured term loans:
$380 million term loan, due May 20221.59%1.69%380380
Total short-term debt$455$380
Long-term debt:

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

Table 23 after “Changes in the components of accumulated other comprehensive income (loss) were as follows:”

Download CSV
Foreign currency translation adjustmentsUnrecognized gain (loss) on derivative instrumentsPension adjustmentsTotal accumulated other comprehensive income (loss)
(in millions)
Balance at January 1, 2021$30$(70)$(6)$(46)
Other comprehensive income (loss)(3)181732
Taxes(5)(8)(4)(17)
Reclassification from accumulated other comprehensive income (loss)—19—19
Balance at December 31, 202122(41)7(12)
Other comprehensive income (loss)(2)32131

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

Table 24 after “The following table provides a reconciliation of the weighted average number of shares outstanding used to compute basic and diluted EPS for”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions)
Basic weighted average number of shares outstanding139142
Dilutive common share equivalents—stock options and other stock awards12
Diluted weighted average number of shares outstanding140144

Table 25 after “Sold receivables activity for the periods presented was as follows:”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions)
Sales of accounts receivable$209$465
Cash collections on sold receivables remitted to financial institution(209)(371)
Outstanding balance sold to financial institution—94
Cash collected but not yet remitted to financial institution—(19)
Sold receivables due from customers$—$75

Table 26 after “The segment information for the periods presented was as follows:”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions)
Revenues:
Defense Solutions$2,049$1,958
Civil795766
Health650591
Total revenues$3,494$3,315

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

Table 27 after “As of April 1, 2022, the future expirations of the outstanding letters of credit and surety bonds were as follows:”

Download CSV
Fiscal year ending
(in millions)
2022 (remainder of year)$38
202311
202481
20255
20262
2027 and thereafter14

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

Table 28 after “The following table summarizes our condensed consolidated results of operations for the periods presented:”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021Dollar changePercent change
(dollars in millions)
Revenues$3,494$3,315$1795.4%
Operating income271308(37)(12.0)%
Non-operating expense, net(49)(46)(3)6.5%
Income before income taxes222262(40)(15.3)%
Income tax expense(45)(57)12(21.1)%

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

Table 29 after “Segment and Corporate Results”

Download CSV
Three Months Ended
Defense SolutionsApril 1, 2022April 2, 2021Dollar changePercent change
(dollars in millions)
Revenues$2,049$1,958$914.6%
Operating income133152(19)(12.5)%
Operating margin6.5%7.8%

Table 30 after “LEIDOS HOLDINGS, INC.”

Download CSV
Three Months Ended
CivilApril 1, 2022April 2, 2021Dollar changePercent change
(dollars in millions)
Revenues$795$766$293.8%
Operating income4374(31)(41.9)%
Operating margin5.4%9.7%

Table 31 after “The decrease in operating income for the three months ended April 1, 2022, as compared to the three months ended April 2, 2021, was primaril”

Download CSV
Three Months Ended
HealthApril 1, 2022April 2, 2021Dollar changePercent change
(dollars in millions)
Revenues$650$591$5910.0%
Operating income1181021615.7%
Operating margin18.2%17.3%

Table 32 after “The increases in revenue and operating income for the three months ended April 1, 2022, as compared to the three months ended April 2, 2021,”

Download CSV
Three Months Ended
CorporateApril 1, 2022April 2, 2021Dollar changePercent change
(dollars in millions)
Operating loss$(23)$(20)$(3)15.0%

Table 33 after “The estimated value of our total backlog was as follows:”

Download CSV
April 1, 2022April 2, 2021
SegmentFundedUnfundedTotalFundedUnfundedTotal
(in millions)
Defense Solutions$3,919$15,068$18,987$4,142$14,393$18,535
Civil1,8129,51611,3281,5316,8578,388
Health1,3604,6706,0301,3104,3485,658
Total$7,091$29,254$36,345$6,983$25,598$32,581

Table 34 after “The following table summarizes cash flow information for the periods presented:”

Download CSV
Three Months Ended
April 1, 2022April 2, 2021
(in millions)
Net cash provided by operating activities$93$239
Net cash used in investing activities(21)(244)
Net cash used in financing activities(519)(148)
Net decrease in cash, cash equivalents and restricted cash$(447)$(153)

Table 35 after “Balance Sheet”

Download CSV
Total current assets$2,002
Goodwill4,171
Investments in consolidated subsidiaries4,916
Other long-term assets1,317
Total assets$12,406
Total current liabilities$2,665
Long-term debt, net of current portion4,568
Intercompany payables1,487

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

Table 36 after “In February 2022, our Board of Directors authorized a new share repurchase program of up to 20 million shares of our outstanding common stoc”

Download CSV
PeriodTotal Number of Shares(or Units)Purchased (1)Average Price Paid per Share (or Unit)Total Number of Shares (or Units) Purchased as Part of Publicly Announced Repurchase Plans or ProgramsMaximum Number of Shares (or Units) that May Yet Be Purchased Under the Plans or Programs
January 1, 2022 - January 31, 2022—$——4,554,346
February 1, 2022 - February 28, 20224,508,56688.724,508,56615,491,434
March 1, 2022 - March 31, 2022719107.54—15,491,434
April 1, 2022———15,491,434
Total4,509,285$88.724,508,566

Table 37 after “Exhibits.”

Download CSV
Exhibit NumberDescription of Exhibit
22List of Guarantors and Subsidiary Issuers of Guaranteed Securities. Incorporated herein by reference from the Company's Registration Statement on Form S-4, filed with the U.S. Securities and Exchange Commission on May 6, 2021.
31.1Certification of Chairman and Chief Executive Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
31.2Certification of Executive Vice President and Chief Financial Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
32.1Certification of Chairman and Chief Executive Officer pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002.
32.2Certification of Executive Vice President and Chief Financial Officer pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002.
101Interactive Data File. The instance document does not appear in the Interactive Data File because its XBRL tags are embedded within the Inline XBRL document.
104Cover Page Interactive Data File. The cover page interactive data file does not appear in the Interactive Data File because its XBRL tags are embedded within the Inline XBRL document.