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 Aug 2, 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 43 rows. The CSV has all of them.

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

Download CSV
July 1, 2022December 31, 2021
(in millions)
Assets:
Cash and cash equivalents$339$727
Receivables, net2,4232,189
Inventory, net286274
Other current assets478429
Total current assets3,5263,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 EndedSix Months Ended
July 1, 2022July 2, 2021July 1, 2022July 2, 2021
(in millions, except per share amounts)
Revenues$3,597$3,448$7,091$6,763
Cost of revenues3,0592,9506,0415,798
Selling, general and administrative expenses260224494392
Bad debt expense and recoveries2(1)4(10)
Acquisition, integration and restructuring costs510815

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 EndedSix Months Ended
July 1, 2022July 2, 2021July 1, 2022July 2, 2021
(in millions)
Net income$172$170$349$375
Foreign currency translation adjustments(85)21(83)17
Unrecognized gain on derivative instruments713614
Pension adjustments(21)—(20)—
Total other comprehensive (loss) income, net of taxes(99)22(67)31

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 19 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 19 rows. The CSV has all of them.

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

Download CSV
Six Months Ended
July 1, 2022July 2, 2021
(in millions)
Cash flows from operations:
Net income$349$375
Adjustments to reconcile net income to net cash provided by operations:
Depreciation and amortization168157
Stock-based compensation3532

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 EndedSix Months Ended
July 1, 2022July 2, 2021July 1, 2022July 2, 2021
(in millions, except per share amounts)
Favorable impact$39$37$80$68
Unfavorable impact(20)(29)(46)(48)
Net impact to income before income taxes$19$8$34$20
Impact on diluted EPS attributable to Leidos common stockholders$0.10$0.04$0.18$0.11

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

Download CSV
Three Months Ended July 1, 2022Six Months Ended July 1, 2022
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
DoD and U.S. Intelligence Community$1,522$20$239$1,781$3,061$40$477$3,578
Other government agencies(1)2286604201,3084501,2738052,528
Commercial and non-U.S. customers3021482847858929555939
Total$2,052$828$687$3,567$4,100$1,608$1,337$7,045

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

Download CSV
Three Months Ended July 2, 2021Six Months Ended July 2, 2021
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
DoD and U.S. Intelligence Community$1,466$13$184$1,663$2,873$26$342$3,241
Other government agencies(1)2376254351,2975091,2308422,581
Commercial and non-U.S. customers3001312645757825652886
Total$2,003$769$645$3,417$3,960$1,512$1,236$6,708

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

Download CSV
Three Months Ended July 1, 2022Six Months Ended July 1, 2022
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
Cost-reimbursement and fixed-price-incentive-fee$1,144$443$167$1,754$2,327$851$334$3,512
Firm-fixed-price6642584541,3761,2825138712,666
Time-and-materials and fixed-price-level-of-effort24412766437491244132867
Total$2,052$828$687$3,567$4,100$1,608$1,337$7,045

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

Download CSV
Three Months Ended July 2, 2021Six Months Ended July 2, 2021
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
Cost-reimbursement and fixed-price-incentive-fee$1,234$405$125$1,764$2,397$779$224$3,400
Firm-fixed-price5262484191,1931,0795108112,400
Time-and-materials and fixed-price-level-of-effort243116101460484223201908
Total$2,003$769$645$3,417$3,960$1,512$1,236$6,708

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

Download CSV
Three Months Ended July 1, 2022Six Months Ended July 1, 2022
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
United States$1,789$789$687$3,265$3,599$1,530$1,337$6,466
International26339—30250178—579
Total$2,052$828$687$3,567$4,100$1,608$1,337$7,045

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

Download CSV
Three Months Ended July 2, 2021Six Months Ended July 2, 2021
Defense SolutionsCivilHealthTotalDefense SolutionsCivilHealthTotal
(in millions)
United States$1,746$728$645$3,119$3,459$1,432$1,236$6,127
International25741—29850180—581
Total$2,003$769$645$3,417$3,960$1,512$1,236$6,708

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

Download CSV
Balance sheet line itemJuly 1, 2022December 31, 2021
(in millions)
Contract assets - current:
Unbilled receivablesReceivables, net$944$1,022
Contract liabilities - current:
Deferred revenue (1)Accounts payable and accrued liabilities$312$364
Contract liabilities - non-current:
Deferred revenue (1)Other long-term liabilities$24$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
July 1, 2022December 31, 2021
Gross carrying valueAccumulated amortizationNet carrying valueGross carrying valueAccumulated amortizationNet carrying value
(in millions)
Finite-lived intangible assets:
Programs$1,693$(913)$780$1,722$(830)$892
Software and technology218(125)93230(121)109
Customer relationships88(19)6997(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 July 1, 2022, was as follows:”

Download CSV
Fiscal year ending
(in millions)
2022 (remainder of year)$114
2023200
2024148
2025119
202695
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
July 1, 2022December 31, 2021
Carrying valueFair valueCarrying valueFair value
(in millions)
Financial liabilities:
Derivatives$4$4$53$53

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

Download CSV
Liability derivatives
Balance sheet line itemJuly 1, 2022December 31, 2021
(in millions)
Cash flow interest rate swapsOther long-term liabilities$353
Foreign currency forward contractsAccounts payable and accrued liabilities1—
$453

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 EndedSix Months Ended
July 1, 2022July 2, 2021July 1, 2022July 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$50$46$98$91
Amount recognized in other comprehensive income (loss)$4$(3)$36$9
Amount reclassified from accumulated other comprehensive income (loss) to interest expense, net$5$4$11$9

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

Download CSV
Stated interest rateEffective interest rateJuly 1, 2022(1)December 31, 2021(1)
(in millions)
Short-term debt:
Commercial paper2.40%-2.55%Various$150$—
Senior unsecured term loans:
$380 million term loan, due May 20221.54%1.64%—380
$380 million term loan, due May 20232.63%2.72%380—
Total short-term debt$530$380

First 8 of 23 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)(100)36(26)(90)

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 EndedSix Months Ended
July 1, 2022July 2, 2021July 1, 2022July 2, 2021
(in millions)
Basic weighted average number of shares outstanding137141138141
Dilutive common share equivalents—stock options and other stock awards1212
Diluted weighted average number of shares outstanding138143139143

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

Download CSV
Three Months EndedSix Months Ended
July 1, 2022July 2, 2021July 1, 2022July 2, 2021
(in millions)
Revenues:
Defense Solutions$2,052$2,004$4,101$3,962
Civil8577991,6521,565
Health6886451,3381,236
Total revenues$3,597$3,448$7,091$6,763

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

Table 26 after “As of July 1, 2022, the future expirations of the outstanding letters of credit, surety bonds and future lease commitments were as follows:”

Download CSV
Fiscal year ending
(in millions)
2022 (remainder of year)$30
202324
202498
202523
202619
2027 and thereafter24

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 EndedSix Months Ended
July 1, 2022July 2, 2021Dollar changePercent changeJuly 1, 2022July 2, 2021Dollar changePercent change
(dollars in millions)
Revenues$3,597$3,448$1494.3%$7,091$6,763$3284.8%
Operating income27126920.7%542577(35)(6.1)%
Non-operating expense, net(46)(46)——%(95)(92)(3)3.3%
Income before income taxes22522320.9%447485(38)(7.8)%
Income tax expense(53)(53)——%(98)(110)12(10.9)%

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

Table 28 after “Segment and Corporate Results”

Download CSV
Three Months EndedSix Months Ended
Defense SolutionsJuly 1, 2022July 2, 2021Dollar changePercent changeJuly 1, 2022July 2, 2021Dollar changePercent change
(dollars in millions)
Revenues$2,052$2,004$482.4%$4,101$3,962$1393.5%
Operating income13913721.5%272289(17)(5.9)%
Operating margin6.8%6.8%6.6%7.3%

Table 29 after “The decrease in operating income for the six months ended July 1, 2022, as compared to the six months ended July 2, 2021, was primarily attr”

Download CSV
Three Months EndedSix Months Ended
CivilJuly 1, 2022July 2, 2021Dollar changePercent changeJuly 1, 2022July 2, 2021Dollar changePercent change
(dollars in millions)
Revenues$857$799$587.3%$1,652$1,565$875.6%
Operating income3855(17)(30.9)%81129(48)(37.2)%
Operating margin4.4%6.9%4.9%8.2%

Table 30 after “The decrease in operating income for the three and six months ended July 1, 2022, as compared to the three and six months ended July 2, 2021”

Download CSV
Three Months EndedSix Months Ended
HealthJuly 1, 2022July 2, 2021Dollar changePercent changeJuly 1, 2022July 2, 2021Dollar changePercent change
(dollars in millions)
Revenues$688$645$436.7%$1,338$1,236$1028.3%
Operating income1261071917.8%2442093516.7%
Operating margin18.3%16.6%18.2%16.9%

Table 31 after “LEIDOS HOLDINGS, INC.”

Download CSV
Three Months EndedSix Months Ended
CorporateJuly 1, 2022July 2, 2021Dollar changePercent changeJuly 1, 2022July 2, 2021Dollar changePercent change
(dollars in millions)
Operating loss$(32)$(30)$(2)6.7%$(55)$(50)$(5)10.0%

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

Download CSV
July 1, 2022July 2, 2021
SegmentFundedUnfundedTotalFundedUnfundedTotal
(in millions)
Defense Solutions$4,351$13,668$18,019$4,293$14,154$18,447
Civil2,0518,84610,8971,6087,4939,101
Health1,1394,6675,8061,2554,7205,975
Total$7,541$27,181$34,722$7,156$26,367$33,523

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

Download CSV
Three Months EndedSix Months Ended
July 1, 2022July 2, 2021Dollar ChangeJuly 1, 2022July 2, 2021Dollar Change
(in millions)
Net cash provided by operating activities$40$17$23$133$256$(123)
Net cash used in investing activities(8)(396)388(29)(640)611
Net cash provided by (used in) financing activities6313(307)(513)165(678)
Net increase (decrease) in cash, cash equivalents and restricted cash$38$(66)$104$(409)$(219)$(190)

Table 34 after “Balance Sheet”

Download CSV
Total current assets$2,021
Goodwill5,811
Investments in consolidated subsidiaries3,276
Other long-term assets1,283
Total assets$12,391
Total current liabilities$3,075
Long-term debt, net of current portion4,021
Intercompany payables1,621

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

Table 35 after “Statements of Income”

Download CSV
Three Months EndedSix Months Ended
Revenues, net$2,402$4,776
Operating income138306
Net income attributable to Leidos common stockholders34108

Table 36 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)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
April 2, 2022 - April 30, 2022—$——15,491,434
May 1, 2022 - May 31, 2022287,460104.25287,46015,203,974
June 1, 2022 - June 30, 2022600101.69—15,203,974
July 1, 2022———15,203,974
Total288,060$104.25287,460

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.