← 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 ↗
| Part I | | Page |
| Item 1. | Financial Statements (Unaudited) | 1 |
| Condensed Consolidated Balance Sheets | 1 |
| Condensed Consolidated Statements of Income | 2 |
| Condensed Consolidated Statements of Comprehensive Income | 3 |
| Condensed Consolidated Statements of Equity | 4 |
| Condensed Consolidated Statements of Cash Flows | 5 |
| Notes to Condensed Consolidated Financial Statements | 6 |
First 8 of 41 rows. The CSV has all of them.
Table 2 after “CONDENSED CONSOLIDATED BALANCE SHEETS (UNAUDITED)”
Download CSV
| April 1, 2022 | December 31, 2021 | |
| (in millions) | | |
| Assets: | | | |
| Cash and cash equivalents | $297 | | $727 |
| Receivables, net | 2,419 | | 2,189 |
| Inventory, net | 279 | | 274 |
| Other current assets | 492 | | 429 |
| Total current assets | 3,487 | | 3,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, 2022 | April 2, 2021 | |
| | (in millions, except per share amounts) | | |
| Revenues | | $3,494 | | $3,315 |
| Cost of revenues | | 2,982 | | 2,848 |
| Selling, general and administrative expenses | | 236 | | 159 |
| Acquisition, integration and restructuring costs | | 3 | | 5 |
| Equity loss (earnings) of non-consolidated subsidiaries | | 2 | | (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, 2022 | April 2, 2021 | |
| (in millions) | | |
| Net income | $177 | | $205 |
| Foreign currency translation adjustments | 2 | | (4) |
| Unrecognized gain on derivative instruments | 29 | | 13 |
| Pension adjustments | 1 | | — |
| Total other comprehensive income, net of taxes | 32 | | 9 |
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 stock | Additional paid-in capital | | Retained earnings | Accumulated other comprehensive income | Leidos Holdings, Inc. stockholders' equity | | Non-controlling interest | Total | | |
| (in millions, except for per share amounts) | | | | | | | | | | |
| Balance at December 31, 2021 | 140 | | $2,423 | | $1,880 | | $(12) | | $4,291 | $53 | $4,344 |
| Net income | — | | — | | 175 | | — | | 175 | 2 | 177 |
| Other comprehensive income, net of taxes | — | | — | | — | | 32 | | 32 | — | 32 |
| Issuances of stock | 1 | | 15 | | — | | — | | 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 stock | Additional paid-in capital | | Retained earnings | Accumulated other comprehensive loss | Leidos Holdings, Inc. stockholders' equity | | Non-controlling interest | Total | | |
| (in millions, except for per share amounts) | | | | | | | | | | |
| Balance at January 1, 2021 | 142 | | $2,580 | | $1,328 | | $(46) | | $3,862 | $9 | $3,871 |
| Net income | — | | — | | 205 | | — | | 205 | — | 205 |
| Other comprehensive income, net of taxes | — | | — | | — | | 9 | | 9 | — | 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, 2022 | April 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 amortization | 85 | | 77 |
| Stock-based compensation | 16 | | 15 |
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, 2022 | April 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 Solutions | Civil | | Health | Total | |
| (in millions) | | | | | |
| DoD and U.S. Intelligence Community | $1,539 | | $20 | | $238 | $1,797 |
| Other government agencies(1) | 222 | | 613 | | 385 | 1,220 |
| Commercial and non-U.S. customers | 287 | | 147 | | 27 | 461 |
| 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 Solutions | Civil | | Health | Total | |
| (in millions) | | | | | |
| DoD and U.S. Intelligence Community | $1,407 | | $13 | | $158 | $1,578 |
| Other government agencies(1) | 272 | | 605 | | 407 | 1,284 |
| Commercial and non-U.S. customers | 278 | | 125 | | 26 | 429 |
| 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 Solutions | Civil | | Health | Total | |
| (in millions) | | | | | |
| Cost-reimbursement and fixed-price-incentive-fee | $1,183 | | $408 | | $167 | $1,758 |
| Firm-fixed-price | 618 | | 255 | | 417 | 1,290 |
| Time-and-materials and fixed-price-level-of-effort | 247 | | 117 | | 66 | 430 |
| 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 Solutions | Civil | | Health | Total | |
| (in millions) | | | | | |
| Cost-reimbursement and fixed-price-incentive-fee | $1,163 | | $374 | | $99 | $1,636 |
| Firm-fixed-price | 553 | | 262 | | 392 | 1,207 |
| Time-and-materials and fixed-price-level-of-effort | 241 | | 107 | | 100 | 448 |
| 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 Solutions | Civil | | Health | Total | |
| (in millions) | | | | | |
| United States | $1,810 | | $741 | | $650 | $3,201 |
| International | 238 | | 39 | | — | 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 Solutions | Civil | | Health | Total | |
| (in millions) | | | | | |
| United States | $1,713 | | $704 | | $591 | $3,008 |
| International | 244 | | 39 | | — | 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 item | April 1, 2022 | December 31, 2021 | |
| | (in millions) | | |
| Contract assets - current: | | | | |
| Unbilled receivables | Receivables, 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 Solutions | Civil | | Health | Total | |
| (in millions) | | | | | |
| Goodwill at January 1, 2021 | $3,300 | | $2,047 | | $966 | $6,313 |
| Acquisitions of businesses | 425 | | 5 | | — | 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, 2022 | December 31, 2021 | | | | | | | | |
| Gross carrying value | Accumulated amortization | | Net carrying value | Gross carrying value | Accumulated amortization | | Net carrying value | | |
| (in millions) | | | | | | | | | |
| Finite-lived intangible assets: | | | | | | | | | | |
| Programs | $1,701 | | $(866) | | $835 | | $1,722 | | $(830) | $892 |
| Software and technology | 230 | | (127) | | 103 | | 230 | | (121) | 109 |
| Customer relationships | 91 | | (16) | | 75 | | 97 | | (18) | 79 |
| Backlog | 6 | | (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 |
| 2023 | 203 |
| 2024 | 150 |
| 2025 | 120 |
| 2026 | 96 |
| 2027 and thereafter | 271 |
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, 2022 | December 31, 2021 | | | | |
| Carrying value | Fair value | | Carrying value | Fair 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 item | April 1, 2022 | December 31, 2021 | |
| | (in millions) | | |
| Cash flow interest rate swaps | Other 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, 2022 | April 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 rate | Effective interest rate | April 1, 2022(1) | December 31, 2021(1) | |
| | | (in millions) | | |
| Short-term debt: | | | | | |
| Commercial paper | 0.52%-1.13% | Various | $75 | | $— |
| Senior unsecured term loans: | | | | | |
| $380 million term loan, due May 2022 | 1.59% | 1.69% | 380 | | 380 |
| 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 adjustments | Unrecognized gain (loss) on derivative instruments | | Pension adjustments | Total accumulated other comprehensive income (loss) | |
| (in millions) | | | | | |
| Balance at January 1, 2021 | $30 | | $(70) | | $(6) | $(46) |
| Other comprehensive income (loss) | (3) | | 18 | | 17 | 32 |
| Taxes | (5) | | (8) | | (4) | (17) |
| Reclassification from accumulated other comprehensive income (loss) | — | | 19 | | — | 19 |
| Balance at December 31, 2021 | 22 | | (41) | | 7 | (12) |
| Other comprehensive income (loss) | (2) | | 32 | | 1 | 31 |
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, 2022 | April 2, 2021 | |
| (in millions) | | |
| Basic weighted average number of shares outstanding | 139 | | 142 |
| Dilutive common share equivalents—stock options and other stock awards | 1 | | 2 |
| Diluted weighted average number of shares outstanding | 140 | | 144 |
Table 25 after “Sold receivables activity for the periods presented was as follows:”
Download CSV
| Three Months Ended | | |
| April 1, 2022 | April 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, 2022 | April 2, 2021 | |
| (in millions) | | |
| Revenues: | | | |
| Defense Solutions | $2,049 | | $1,958 |
| Civil | 795 | | 766 |
| Health | 650 | | 591 |
| 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 |
| 2023 | 11 |
| 2024 | 81 |
| 2025 | 5 |
| 2026 | 2 |
| 2027 and thereafter | 14 |
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, 2022 | April 2, 2021 | | Dollar change | Percent change | |
| (dollars in millions) | | | | | |
| Revenues | $3,494 | | $3,315 | | $179 | 5.4% |
| Operating income | 271 | | 308 | | (37) | (12.0)% |
| Non-operating expense, net | (49) | | (46) | | (3) | 6.5% |
| Income before income taxes | 222 | | 262 | | (40) | (15.3)% |
| Income tax expense | (45) | | (57) | | 12 | (21.1)% |
First 8 of 11 rows. The CSV has all of them.
| Three Months Ended | | | | | |
| Defense Solutions | April 1, 2022 | April 2, 2021 | | Dollar change | Percent change | |
| (dollars in millions) | | | | | |
| Revenues | $2,049 | | $1,958 | | $91 | 4.6% |
| Operating income | 133 | | 152 | | (19) | (12.5)% |
| Operating margin | 6.5% | | 7.8% | | | |
| Three Months Ended | | | | | |
| Civil | April 1, 2022 | April 2, 2021 | | Dollar change | Percent change | |
| (dollars in millions) | | | | | |
| Revenues | $795 | | $766 | | $29 | 3.8% |
| Operating income | 43 | | 74 | | (31) | (41.9)% |
| Operating margin | 5.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 | | | | | |
| Health | April 1, 2022 | April 2, 2021 | | Dollar change | Percent change | |
| (dollars in millions) | | | | | |
| Revenues | $650 | | $591 | | $59 | 10.0% |
| Operating income | 118 | | 102 | | 16 | 15.7% |
| Operating margin | 18.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 | | | | | |
| Corporate | April 1, 2022 | April 2, 2021 | | Dollar change | Percent 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, 2022 | April 2, 2021 | | | | | | | | |
| Segment | Funded | Unfunded | | Total | Funded | Unfunded | | Total | | |
| (in millions) | | | | | | | | | |
| Defense Solutions | $3,919 | | $15,068 | | $18,987 | | $4,142 | | $14,393 | $18,535 |
| Civil | 1,812 | | 9,516 | | 11,328 | | 1,531 | | 6,857 | 8,388 |
| Health | 1,360 | | 4,670 | | 6,030 | | 1,310 | | 4,348 | 5,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, 2022 | April 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) |
| Total current assets | $2,002 |
| Goodwill | 4,171 |
| Investments in consolidated subsidiaries | 4,916 |
| Other long-term assets | 1,317 |
| Total assets | $12,406 |
| Total current liabilities | $2,665 |
| Long-term debt, net of current portion | 4,568 |
| Intercompany payables | 1,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
| Period | Total 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 Programs | Maximum 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, 2022 | 4,508,566 | | 88.72 | | 4,508,566 | 15,491,434 |
| March 1, 2022 - March 31, 2022 | 719 | | 107.54 | | — | 15,491,434 |
| April 1, 2022 | — | | — | | — | 15,491,434 |
| Total | 4,509,285 | | $88.72 | | 4,508,566 | |
| Exhibit Number | Description of Exhibit |
| 22 | List 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.1 | Certification of Chairman and Chief Executive Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002. |
| 31.2 | Certification of Executive Vice President and Chief Financial Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002. |
| 32.1 | Certification 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.2 | Certification 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. |
| 101 | Interactive Data File. The instance document does not appear in the Interactive Data File because its XBRL tags are embedded within the Inline XBRL document. |
| 104 | Cover 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. |