← Filings of LDOS

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

46 tables with numbers, filed Nov 2, 2020. 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	6
	Notes to Condensed Consolidated Financial Statements	7

	October 2, 2020	January 3, 2020
	(in millions)
ASSETS
Cash and cash equivalents	$512		$668
Receivables, net	1,872		1,734
Inventory, net	292		72
Other current assets	523		338
Total current assets	3,199		2,812

	Three Months Ended	Nine Months Ended
	October 2, 2020	September 27, 2019		October 2, 2020	September 27, 2019
	(in millions, except per share amounts)
Revenues	$3,242		$2,835		$9,045	$8,140
Cost of revenues	2,774		2,450		7,799	7,019
Selling, general and administrative expenses	200		177		583	518
Bad debt expense and recoveries	2		(35)		(70)	(35)
Acquisition, integration and restructuring costs	5		—		33	3

	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 3, 2020	141		$2,587		$896		$(70)		$3,413	$4	$3,417
Cumulative adjustments related to ASU adoption	—		—		(1)		—		(1)	—	(1)
Balance at January 4, 2020	141		2,587		895		(70)		3,412	4	3,416
Net income	—		—		115		—		115	—	115
Other comprehensive loss, net of taxes	—		—		—		(115)		(115)	—	(115)
Issuances of stock	1		9		—		—		9	—	9

	Three Months Ended October 2, 2020	Nine Months Ended October 2, 2020
	Defense Solutions	Civil		Health	Total	Defense Solutions		Civil	Health	Total
	(in millions)
DoD and U.S. Intelligence Community	$1,411		$14		$137		$1,562		$4,058		$43	$384	$4,485
Other government agencies(1)	292		628		358		1,278		675		1,787	980	3,442
Commercial and non-U.S. customers	248		105		25		378		679		288	80	1,047
Total	$1,951		$747		$520		$3,218		$5,412		$2,118	$1,444	$8,974

	Three Months Ended September 27, 2019	Nine Months Ended September 27, 2019
	Defense Solutions	Civil		Health	Total	Defense Solutions		Civil	Health	Total
	(in millions)
DoD and U.S. Intelligence Community	$1,215		$13		$123		$1,351		$3,542		$47	$360	$3,949
Other government agencies(1)	177		577		337		1,091		487		1,652	982	3,121
Commercial and non-U.S. customers	202		88		45		335		615		255	112	982
Total	$1,594		$678		$505		$2,777		$4,644		$1,954	$1,454	$8,052

	Balance sheet line item	October 2, 2020	January 3, 2020
		(in millions)
Contract assets - current:
Unbilled receivables	Receivables, net	$829		$735
Contract liabilities - current:
Deferred revenue	Accounts payable and accrued liabilities	$578		$400
Contract liabilities - non-current:
Deferred revenue	Other long-term liabilities	$21		$9

Cash	$30
Receivables	134
Inventory	104
Other current assets	23
Operating lease right-of-use assets	35
Property, plant and equipment	35
Intangible assets	430
Accounts payable and accrued liabilities	(124)

	Weighted average amortization period	Fair value
	(in years)	(in millions)
Programs	13	$150
Customer relationships	10	91
Technology	10	91
In-process research and development ("IPR&D")(1)		98
Total	11	$430

	October 2, 2020	January 3, 2020
	Gross carrying value	Accumulated amortization		Net carrying value	Gross carrying value	Accumulated amortization		Net carrying value
	(in millions)
Finite-lived intangible assets:
Programs	$1,638		$(647)		$991		$1,003		$(536)	$467
Software and technology	205		(96)		109		102		(83)	19
Customer relationships	136		(15)		121		45		(6)	39
Backlog	32		(21)		11		—		—	—

	October 2, 2020	January 3, 2020
	(in millions)
Raw materials	$148		$46
Work in process	79		13
Finished goods	65		13
	$292		$72

	Defense Solutions	Civil		Health	Total
	(in millions)
Goodwill at December 28, 2018	$2,015		$1,924		$921	$4,860
Goodwill re-allocation	25		(25)		—	—
Acquisition of IMX Medical Management Services, Inc.	—		—		50	50
Divestiture of health staff augmentation business	—		—		(5)	(5)
Foreign currency translation adjustments	(4)		8		—	4
Adjustment to goodwill	3		—		—	3

Fiscal year ending
	(in millions)
2020 (remainder of year)	$58
2021	219
2022	208
2023	182
2024	133
2025 and thereafter	433

	Stated interest rate	Effective interest rate	October 2, 2020(1)	January 3, 2020(1)
			(in millions)
Senior unsecured term loans:
$300 million Term Loan, due June 2021	2.15%	2.41%	$299		$—
$1,925 million Term Loan, due January 2025	1.53%	1.78%	1,860		—
Senior secured term loans:
$690 million Term Loan A, due August 2023	3.31%	3.74%	—		581
$310 million Term Loan A, due August 2023	3.31%	3.76%	—		242

		Three Months Ended	Nine Months Ended
	Income statement line item	October 2, 2020	September 27, 2019		October 2, 2020	September 27, 2019
		(in millions)
Sales-type leases:
Selling price at lease commencement	Revenues	$16		$53		$44	$68
Cost of underlying asset	Cost of revenues	(12)		(56)		(35)	(70)
Operating income (loss)		4		(3)		9	(2)
Interest income on lease receivables	Revenues	2		1		6	1

	October 2, 2020	January 3, 2020
	Carrying value	Fair value		Carrying value	Fair value
	(in millions)
Financial assets:
Derivatives	$—		$—		$2	$2
Financial liabilities:
Derivatives	$115		$115		$75	$75

	Asset derivatives
	Balance sheet line item	October 2, 2020	January 3, 2020
		(in millions)
Fair value interest rate swaps	Other assets	$—		$2
	Liability derivatives
	Balance sheet line item	October 2, 2020	January 3, 2020
		(in millions)
Cash flow interest rate swaps	Other long-term liabilities	$114		$75

	Foreign currency translation adjustments	Unrecognized gain (loss) on derivative instruments		Pension adjustments	Total accumulated other comprehensive loss
	(in millions)
Balance at December 28, 2018	$(41)		$14		$(3)	$(30)
Other comprehensive income (loss)	5		(55)		(1)	(51)
Taxes	3		15		—	18
Reclassification from accumulated other comprehensive loss	—		(7)		—	(7)
Balance at January 3, 2020	(33)		(33)		(4)	(70)
Other comprehensive income (loss)	13		(62)		—	(49)

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
July 4, 2020 - July 31, 2020	—		$—		—	7,696,108
August 1, 2020 - August 31, 2020	—		—		—	7,696,108
September 1, 2020 - September 30, 2020	4,177		88.43		—	7,696,108
October 1, 2020 - October 2, 2020	—		—		—	7,696,108
Total	4,177		$88.43		—

Exhibit Number	Description of Exhibit
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.

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

Table 1 after “TABLE OF CONTENTS”

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Table 16 after “The preliminary fair values of the assets acquired and liabilities assumed at the Transaction Date were as follows (in millions):”

Table 17 after “The following table summarizes the preliminary fair value of intangible assets acquired at the Transaction Date and the related weighted ave”

Table 18 after “The preliminary fair values of the assets acquired and liabilities assumed at the Acquisition Date were as follows (in millions):”

Table 19 after “The following table summarizes the preliminary fair value of intangible assets acquired at the Acquisition Date and the related weighted ave”

Table 20 after “The following expenses were incurred related to the acquisitions of Dynetics and the SD&A Businesses:”

Table 21 after “The pro forma information is not intended to reflect the actual results of operations that would have occurred if the acquisitions had been ”

Table 22 after “The components of inventory, net consisted of the following:”

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

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

Table 25 after “The estimated annual amortization expense as of October 2, 2020, was as follows:”

Table 26 after “The components of lease income were as follows:”

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

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

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

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

Table 31 after “Changes in the components of accumulated other comprehensive loss were as follows:”

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

Table 33 after “Supplementary cash flow information, and non-cash activities, for the periods presented was as follows:”

Table 34 after “Sold receivables activity for the period was as follows:”

Table 35 after “The following is a reconciliation of cash and cash equivalents, as reported within the condensed consolidated balance sheets, to the total c”

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

Table 37 after “As of October 2, 2020, the future expirations of the outstanding letters of credit and surety bonds were as follows:”

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

Table 39 after “Segment and Corporate Results”

Table 40 after “The increase in operating income for the nine months ended October 2, 2020, as compared to the nine months ended September 27, 2019, was pri”

Table 41 after “The increase in operating income for the nine months ended October 2, 2020, as compared to the nine months ended September 27, 2019, was pri”

Table 42 after “The decrease in operating income for the nine months ended October 2, 2020, as compared to the nine months ended September 27, 2019, was pri”

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

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

Table 45 after “The following table presents repurchases of Leidos common stock during the quarter ended October 2, 2020:”

Table 46 after “Exhibits.”