← Filings of LDOS

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

46 tables with numbers, filed Aug 4, 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

	July 3, 2020	January 3, 2020
	(in millions)
ASSETS
Cash and cash equivalents	$588		$668
Receivables, net	1,789		1,734
Inventory, net	294		72
Other current assets	381		338
Total current assets	3,052		2,812

	Three Months Ended			Six Months Ended
	July 3, 2020	June 28, 2019		July 3, 2020	June 28, 2019
	(in millions, except per share amounts)
Revenues	$2,914		$2,728		$5,803	$5,305
Cost of revenues	2,531		2,348		5,025	4,569
Selling, general and administrative expenses	195		175		383	341
Bad debt expense and recoveries	(81)		—		(72)	—
Acquisition, integration and restructuring costs	16		1		28	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 July 3, 2020					Six Months Ended July 3, 2020
	Defense Solutions	Civil		Health	Total	Defense Solutions		Civil	Health	Total
	(in millions)
DoD and U.S. Intelligence Community	$1,362		$12		$123		$1,497		$2,647		$29	$247	$2,923
Other government agencies(1)	175		615		247		1,037		383		1,159	622	2,164
Commercial and non-U.S. customers	219		112		27		358		431		183	55	669
Total	$1,756		$739		$397		$2,892		$3,461		$1,371	$924	$5,756

	Three Months Ended June 28, 2019					Six Months Ended June 28, 2019
	Defense Solutions	Civil		Health	Total	Defense Solutions		Civil	Health	Total
	(in millions)
DoD and U.S. Intelligence Community	$1,192		$17		$113		$1,322		$2,327		$34	$237	$2,598
Other government agencies(1)	154		564		343		1,061		310		1,075	645	2,030
Commercial and non-U.S. customers	214		80		39		333		413		167	67	647
Total	$1,560		$661		$495		$2,716		$3,050		$1,276	$949	$5,275

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

	Weighted average amortization period	Fair value
	(in years)	(in millions)
Programs	7	$117
Software and technology	10	140
Trade name	5	23
Total	8	$280

Cash	$18
Receivables	159
Inventory	47
Other current assets	22
Operating lease right-of-use assets	25
Property, plant and equipment	173
Intangible assets	544
Other assets	9

	July 3, 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,620		$(608)		$1,012		$1,003		$(536)	$467
Software and technology	253		(88)		165		102		(83)	19
Customer relationships	45		(8)		37		45		(6)	39
Backlog	33		(14)		19		—		—	—

Receivables	$134
Inventory	101
Intangible assets	280
Goodwill	599

	July 3, 2020	January 3, 2020
	(in millions)
Raw materials	$139		$46
Work in process	89		13
Finished goods	66		13
	$294		$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)	$112
2021	208
2022	200
2023	177
2024	130
2025 and thereafter	429

		Three Months Ended			Six Months Ended
	Income statement line item	July 3, 2020	June 28, 2019		July 3, 2020	June 28, 2019
		(in millions)
Sales-type leases:
Selling price at lease commencement	Revenues	$12		$6		$28	$16
Cost of underlying asset	Cost of revenues	(10)		(5)		(23)	(14)
Operating income		2		1		5	2
Interest income on lease receivables	Revenues	2		—		4	—

	July 3, 2020			January 3, 2020
	Carrying value	Fair value		Carrying value	Fair value
	(in millions)
Financial assets:
Derivatives	$2		$2		$2	$2
Financial liabilities:
Derivatives	$124		$124		$75	$75

	Asset derivatives
	Balance sheet line item	July 3, 2020	January 3, 2020
		(in millions)
Fair value interest rate swaps	Other current assets(1)	$2		$2
(1) The carrying amount of the fair value interest rate swaps were recorded within "Other assets" as of January 3, 2020.
	Liability derivatives
	Balance sheet line item	July 3, 2020	January 3, 2020
		(in millions)

	Carrying amount of hedged item			Cumulative amount of fair value adjustment included within the hedged item
Balance sheet line item of hedged item	July 3, 2020	January 3, 2020		July 3, 2020	January 3, 2020
	(in millions)
Long-term debt, current portion(1)	$452		$452		$2	$2

	Stated interest rate	Effective interest rate	July 3, 2020(1)	January 3, 2020(1)
			(in millions)
Senior unsecured term loans:
$300 million Term Loan, due June 2021	2.18%	2.52%	$299		$—
$1,925 million Term Loan, due January 2025	1.56%	1.81%	1,883		—
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

	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 (loss) income	(14)		(62)		1	(75)

Exhibit Number	Description of Exhibit
3.1	Restated Certificate of Incorporation of Leidos Holdings, Inc. Incorporated by reference to Exhibit 3.1 to our Current Report on Form 8-K filed with the SEC on May 15, 2020.
3.2	Bylaws of Leidos Holdings, Inc. Incorporated by reference to Exhibit 3.2 to our Current Report on Form 8-K filed with the SEC on May 15, 2020.
4.1	Indenture relating to the 2.950% Senior Notes due 2023, 3.625% Senior Notes due 2025 and the 4.375% Senior Notes due 2030, dated as of May 12, 2020, by and among Leidos, Inc., as issuer, Leidos Holdings, Inc., as guarantor, and Citibank, N.A., as trustee. Incorporated by reference to Exhibit 4.1 to our Current Report on Form 8-K filed with the SEC on May 12, 2020.
4.2	Form of 2.950% Senior Notes due 2023. Incorporated by reference to Exhibit 4.2 to our Current Report on Form 8-K filed with the SEC on May 12, 2020.
4.3	Form of 3.625% Senior Notes due 2025. Incorporated by reference to Exhibit 4.3 to our Current Report on Form 8-K filed with the SEC on May 12, 2020.
4.4	Form of 4.375% Senior Notes due 2030. Incorporated by reference to Exhibit 4.4 to our Current Report on Form 8-K filed with the SEC on May 12, 2020.
4.5	Exchange and Registration Rights Agreement, dated May 12, 2020, by and among Leidos, Inc., Leidos Holdings, Inc., Citigroup Global Markets Inc., MUFG Securities Americas Inc. and BofA Securities, Inc. Incorporated by reference to Exhibit 4.5 to our Current Report on Form 8-K filed with the SEC on May 12, 2020.

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 “million, which included the following (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 July 3, 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 was as follows:”

Table 29 after “The following amounts were recorded on the condensed consolidated balance sheets related to cumulative basis adjustments for fair value hedg”

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

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

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

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

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

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

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

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

Table 38 after “As of July 3, 2020, the future expirations of the outstanding letters of credit and surety bonds were as follows:”

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

Table 40 after “Segment and Corporate Results”

Table 41 after “LEIDOS HOLDINGS, INC.”

Table 42 after “The increase in operating income for the three and six months ended July 3, 2020, as compared to the three and six months ended June 28, 201”

Table 43 after “The decrease in operating income for the three and six months ended July 3, 2020, as compared to the three and six months ended June 28, 201”

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

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

Table 46 after “Exhibits.”