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.

36 tables with numbers, filed Nov 1, 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 Flows6
Notes to Condensed Consolidated Financial Statements7

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

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

Download CSV
September 30, 2022December 31, 2021
(in millions)
Assets:
Cash and cash equivalents$807$727
Receivables, net2,2842,189
Inventory, net286274
Other current assets464429
Total current assets3,8413,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 EndedNine Months Ended
September 30, 2022October 1, 2021September 30, 2022October 1, 2021
(in millions, except per share amounts)
Revenues$3,608$3,483$10,699$10,246
Cost of revenues3,0952,9429,1368,740
Selling, general and administrative expenses233233727625
Bad debt expense (recoveries)(1)(1)3(11)
Acquisition, integration and restructuring costs461221

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

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

Download CSV
Three Months EndedNine Months Ended
September 30, 2022October 1, 2021September 30, 2022October 1, 2021
(in millions)
Net income$164$208$513$583
Foreign currency translation adjustments(75)(29)(158)(12)
Unrecognized gain on derivative instruments1845418
Pension adjustments1—(19)—
Total other comprehensive (loss) income, net of taxes(56)(25)(123)6

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 income (loss)Leidos stockholders' equityNon-controlling interestTotal stockholders' equity
(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 27 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 income (loss)Leidos stockholders' equityNon-controlling interestTotal stockholders' equity
(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 27 rows. The CSV has all of them.

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

Download CSV
Nine Months Ended
September 30, 2022October 1, 2021
(in millions)
Cash flows from operations:
Net income$513$583
Adjustments to reconcile net income to net cash provided by operations:
Depreciation and amortization249244
Stock-based compensation5349

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

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

Download CSV
Three Months EndedNine Months Ended
September 30, 2022October 1, 2021September 30, 2022October 1, 2021
(in millions, except per share amounts)
Favorable impact$36$47$116$115
Unfavorable impact(29)(24)(75)(72)
Net impact to income before income taxes$7$23$41$43
Impact on diluted EPS attributable to Leidos common stockholders$0.03$0.12$0.22$0.22

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

Download CSV
Three Months Ended September 30, 2022Nine Months Ended September 30, 2022
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
DoD and U.S. Intelligence Community$1,559$22$255$1,836$4,620$62$732$5,414
Other U.S. government agencies(1)2366763721,2846861,9491,1773,812
Commercial and non-U.S. customers28015128459869446831,398
Total$2,075$849$655$3,579$6,175$2,457$1,992$10,624

Table 10 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (UNAUDITED)”

Download CSV
Three Months Ended October 1, 2021Nine Months Ended October 1, 2021
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
DoD and U.S. Intelligence Community$1,513$19$203$1,735$4,386$45$545$4,976
Other U.S. government agencies(1)2156194501,2847241,8491,2923,865
Commercial and non-U.S. customers28112128430859377801,316
Total$2,009$759$681$3,449$5,969$2,271$1,917$10,157

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

Download CSV
Three Months Ended September 30, 2022Nine Months Ended September 30, 2022
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
Cost-reimbursement and fixed-price-incentive-fee$1,166$442$200$1,808$3,493$1,293$534$5,320
Firm-fixed-price6682793891,3361,9507921,2604,002
Time-and-materials and fixed-price-level-of-effort241128664357323721981,302
Total$2,075$849$655$3,579$6,175$2,457$1,992$10,624

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

Download CSV
Three Months Ended October 1, 2021Nine Months Ended October 1, 2021
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
Cost-reimbursement and fixed-price-incentive-fee$1,230$397$137$1,764$3,627$1,176$361$5,164
Firm-fixed-price5402454431,2281,6197551,2543,628
Time-and-materials and fixed-price-level-of-effort2391171014577233403021,365
Total$2,009$759$681$3,449$5,969$2,271$1,917$10,157

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

Download CSV
Three Months Ended September 30, 2022Nine Months Ended September 30, 2022
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
United States$1,830$810$655$3,295$5,429$2,340$1,992$9,761
International24539—284746117—863
Total$2,075$849$655$3,579$6,175$2,457$1,992$10,624

Table 14 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (UNAUDITED)”

Download CSV
Three Months Ended October 1, 2021Nine Months Ended October 1, 2021
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
United States$1,778$726$681$3,185$5,237$2,158$1,917$9,312
International23133—264732113—845
Total$2,009$759$681$3,449$5,969$2,271$1,917$10,157

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

Download CSV
Balance sheet line itemSeptember 30, 2022December 31, 2021
(in millions)
Contract assets - current:
Unbilled receivablesReceivables, net$1,028$1,022
Contract liabilities - current:
Deferred revenue (1)Accounts payable and accrued liabilities$450$364
Contract liabilities - non-current:
Deferred revenue (1)Other long-term liabilities$26$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 11 rows. The CSV has all of them.

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

Download CSV
September 30, 2022December 31, 2021
Gross carrying valueAccumulated amortizationNet carrying valueGross carrying valueAccumulated amortizationNet carrying value
(in millions)
Finite-lived intangible assets:
Programs$1,697$(967)$730$1,722$(830)$892
Software and technology218(130)88230(121)109
Customer relationships84(21)6397(18)79
Backlog———38(37)1

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

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

Download CSV
Fiscal year ending
(in millions)
2022 (remainder of year)$56
2023199
2024147
2025119
202694
2027 and thereafter266

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
September 30, 2022December 31, 2021
Carrying valueFair valueCarrying valueFair value
(in millions)
Financial assets:
Derivatives$20$20$—$—
Financial liabilities:
Derivatives$16$16$53$53

Table 20 after “The fair value of the interest rate swaps and foreign currency forward contracts was as follows:”

Download CSV
Balance sheet line itemSeptember 30, 2022December 31, 2021
(in millions)
Asset derivatives:
Cash flow interest rate swapsOther long-term assets$20$—
Liability derivatives:
Cash flow interest rate swapsOther long-term liabilities$—$53
Foreign currency forward contractsAccounts payable and accrued liabilities16—

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 EndedNine Months Ended
September 30, 2022October 1, 2021September 30, 2022October 1, 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$50$47$148$138
Amount recognized in other comprehensive income (loss)$21$—$57$9
Amount reclassified from accumulated other comprehensive income (loss) to interest expense, net$2$5$13$14

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

Download CSV
Stated interest rateEffective interest rateSeptember 30, 2022(1)December 31, 2021(1)
(in millions)
Short-term debt:
Senior unsecured term loans:
$380 million term loan, due May 20221.54%1.64%$—$380
$380 million term loan, due May 20234.13%4.22%380—
Total short-term debt$380$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) ("AOCI") were as follows:”

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

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 EndedNine Months Ended
September 30, 2022October 1, 2021September 30, 2022October 1, 2021
(in millions)
Basic weighted average number of shares outstanding137141137141
Dilutive common share equivalents—stock options and other stock awards1212
Diluted weighted average number of shares outstanding138143138143

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

Download CSV
Three Months EndedNine Months Ended
September 30, 2022October 1, 2021September 30, 2022October 1, 2021
(in millions)
Revenues:
Defense Solutions$2,075$2,009$6,176$5,971
Civil8747922,5262,357
Health6596821,9971,918
Total revenues$3,608$3,483$10,699$10,246

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

Table 26 after “As of September 30, 2022, the future expirations of the outstanding letters of credit, surety bonds and future lease commitments were as fol”

Download CSV
Fiscal year ending
(in millions)
2022 (remainder of year)$22
202326
2024103
202522
202619
2027 and thereafter26

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

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

Download CSV
Three Months EndedNine Months Ended
September 30, 2022October 1, 2021Dollar changePercent changeSeptember 30, 2022October 1, 2021Dollar changePercent change
(dollars in millions)
Revenues$3,608$3,483$1253.6%$10,699$10,246$4534.4%
Operating income281305(24)(7.9)%823882(59)(6.7)%
Non-operating expense, net(60)(45)(15)33.3%(155)(137)(18)13.1%
Income before income taxes221260(39)(15.0)%668745(77)(10.3)%
Income tax expense(57)(52)(5)9.6%(155)(162)7(4.3)%

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

Table 28 after “Segment and Corporate Results”

Download CSV
Three Months EndedNine Months Ended
Defense SolutionsSeptember 30, 2022October 1, 2021Dollar changePercent changeSeptember 30, 2022October 1, 2021Dollar changePercent change
(dollars in millions)
Revenues$2,075$2,009$663.3%$6,176$5,971$2053.4%
Operating income137140(3)(2.1)%409429(20)(4.7)%
Operating margin6.6%7.0%6.6%7.2%

Table 29 after “The decrease in operating income for the nine months ended September 30, 2022, as compared to the nine months ended October 1, 2021, was pri”

Download CSV
Three Months EndedNine Months Ended
CivilSeptember 30, 2022October 1, 2021Dollar changePercent changeSeptember 30, 2022October 1, 2021Dollar changePercent change
(dollars in millions)
Revenues$874$792$8210.4%$2,526$2,357$1697.2%
Operating income79582136.2%160187(27)(14.4)%
Operating margin9.0%7.3%6.3%7.9%

Table 30 after “LEIDOS HOLDINGS, INC.”

Download CSV
Three Months EndedNine Months Ended
HealthSeptember 30, 2022October 1, 2021Dollar changePercent changeSeptember 30, 2022October 1, 2021Dollar changePercent change
(dollars in millions)
Revenues$659$682$(23)(3.4)%$1,997$1,918$794.1%
Operating income91130(39)(30.0)%335339(4)(1.2)%
Operating margin13.8%19.1%16.8%17.7%

Table 31 after “The decrease in operating income for the nine months ended September 30, 2022, as compared to the nine months ended October 1, 2021, was pri”

Download CSV
Three Months EndedNine Months Ended
CorporateSeptember 30, 2022October 1, 2021Dollar changePercent changeSeptember 30, 2022October 1, 2021Dollar changePercent change
(dollars in millions)
Operating loss$(26)$(23)$(3)13.0%$(81)$(73)$(8)11.0%

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

Download CSV
September 30, 2022October 1, 2021
SegmentFundedUnfundedTotalFundedUnfundedTotal
(in millions)
Defense Solutions$4,178$13,842$18,020$4,412$15,160$19,572
Civil2,0378,65210,6891,7137,7029,415
Health1,2145,1056,3191,1644,5415,705
Total$7,429$27,599$35,028$7,289$27,403$34,692

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

Download CSV
Three Months EndedNine Months Ended
September 30, 2022October 1, 2021September 30, 2022October 1, 2021
(in millions)
Net cash provided by operating activities$748$565$881$821
Net cash used in investing activities(26)(53)(55)(693)
Net cash used in financing activities(217)(209)(730)(44)
Net increase in cash, cash equivalents and restricted cash$505$303$96$84

Table 34 after “Balance Sheet”

Download CSV
September 30, 2022December 31, 2021
Total current assets$2,358$2,229
Goodwill5,8114,171
Investments in consolidated subsidiaries3,2784,918
Other long-term assets1,2831,362
Total assets$12,730$12,680
Total current liabilities$3,263$2,400
Long-term debt, net of current portion3,9744,590

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

Table 35 after “In February 2022, our Board of Directors authorized a share repurchase program of up to 20 million shares of our outstanding common stock. T”

Download CSV
PeriodTotal Number of Shares (or Units) PurchasedAverage 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
July 1, 2022 - July 31, 2022—$——15,203,974
August 1, 2022 - August 31, 2022———15,203,974
September 1, 2022 - September 30, 202225,20593.20—15,203,974
Total25,205$93.20—

Table 36 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.