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.

43 tables with numbers, filed May 5, 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 ↗

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 Flows5
Notes to Condensed Consolidated Financial Statements6

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

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

Download CSV
April 3, 2020January 3, 2020
(in millions)
ASSETS
Cash and cash equivalents$445$668
Receivables, net1,7931,734
Other current assets630410
Total current assets2,8682,812
Property, plant and equipment, net490287

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

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(in millions, except per share amounts)
Revenues$2,889$2,577
Cost of revenues2,4942,221
Selling, general and administrative expenses197166
Acquisition, integration and restructuring costs122
Equity earnings of non-consolidated subsidiaries(6)(4)

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

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(in millions)
Net income$115$189
Foreign currency translation adjustments(74)10
Unrecognized loss on derivative instruments(42)(15)
Pension adjustments1—
Total other comprehensive loss, net of taxes(115)(5)

First 8 of 9 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 lossLeidos Holdings, Inc. stockholders' equityNon-controlling interestTotal
(in millions, except for per share amounts)
Balance at January 3, 2020141$2,587$896$(70)$3,413$4$3,417
Cumulative adjustments related to ASU adoption(1)(1)(1)
Balance at January 4, 20201412,587895(70)3,41243,416
Net income——115—115—115
Other comprehensive loss, net of taxes———(115)(115)—(115)
Issuances of stock19——9—9

First 8 of 12 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 lossLeidos Holdings, Inc. stockholders' equityNon-controlling interestTotal
(in millions, except for per share amounts)
Balance at December 28, 2018146$2,966$372$(30)$3,308$3$3,311
Cumulative adjustments related to ASU adoption——48—48—48
Balance at December 29, 20181462,966420(30)3,35633,359
Net income——189—189—189
Other comprehensive loss, net of taxes———(5)(5)—(5)
Issuances of stock111——11—11

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

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(in millions)
Cash flows from operations:
Net income$115$189
Adjustments to reconcile net income to net cash provided by operations:
Gain on sale of business—(88)
Depreciation and amortization6158

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

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(in millions, except per share amounts)
Favorable impact$24$23
Unfavorable impact(7)(19)
Net impact to income before income taxes$17$4
Impact on diluted EPS attributable to Leidos common stockholders$0.09$0.02

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

Download CSV
Three Months Ended April 3, 2020
Defense SolutionsCivilHealthTotal
(in millions)
DoD and U.S. Intelligence Community$1,285$17$124$1,426
Other government agencies(1)2085443751,127
Commercial and non-U.S. customers2127128311
Total$1,705$632$527$2,864

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

Download CSV
Three Months Ended March 29, 2019
Defense SolutionsCivilHealthTotal
(in millions)
DoD and U.S. Intelligence Community$1,135$17$124$1,276
Other government agencies(1)156511302969
Commercial and non-U.S. customers1998728314
Total$1,490$615$454$2,559

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

Download CSV
Three Months Ended April 3, 2020
Defense SolutionsCivilHealthTotal
(in millions)
Cost-reimbursement and fixed-price-incentive-fee$1,094$346$65$1,505
Firm-fixed-price440173373986
Time-and-materials and fixed-price-level-of-effort17111389373
Total$1,705$632$527$2,864

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

Download CSV
Three Months Ended March 29, 2019
Defense SolutionsCivilHealthTotal
(in millions)
Cost-reimbursement and fixed-price-incentive-fee$986$367$69$1,422
Firm-fixed-price364142269775
Time-and-materials and fixed-price-level-of-effort140106116362
Total$1,490$615$454$2,559

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

Download CSV
Three Months Ended April 3, 2020
Defense SolutionsCivilHealthTotal
(in millions)
United States$1,513$619$527$2,659
International19213—205
Total$1,705$632$527$2,864

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

Download CSV
Three Months Ended March 29, 2019
Defense SolutionsCivilHealthTotal
(in millions)
United States$1,304$599$454$2,357
International18616—202
Total$1,490$615$454$2,559

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

Download CSV
Balance sheet line itemApril 3, 2020January 3, 2020
(in millions)
Contract assets - current:
Unbilled receivables(1)Receivables, net$718$735
Contract liabilities - current:
Deferred revenueAccounts payable and accrued liabilities$420$400
Contract liabilities - non-current:
Deferred revenueOther long-term liabilities$8$9

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

Download CSV
Cash$18
Receivables159
Other current assets64
Operating lease right-of-use assets25
Property, plant and equipment161
Intangible assets464
Accounts payable and accrued liabilities(45)
Accrued payroll and employee benefits(29)

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

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

Download CSV
Weighted average amortization periodFair value
(in years)(in millions)
Program intangibles10$430
Backlog intangibles134
Total9$464

Table 18 after “The following expenses were incurred related to the acquisition of Dynetics:”

Download CSV
Three Months Ended
April 3, 2020
(in millions)
Acquisition costs$8
Integration costs1
Total acquisition and integration costs$9

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(in millions, except per share amounts)
Revenues$2,952$2,722
Net income attributable to Leidos common stockholders130158
Earnings per share:
Basic$0.92$1.09
Diluted0.901.07

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

Download CSV
Defense SolutionsCivilHealthTotal
(in millions)
Goodwill at December 28, 2018$2,015$1,924$921$4,860
Goodwill re-allocation25(25)——
Acquisition of IMX Medical Management Services, Inc.——5050
Divestiture of health staff augmentation business——(5)(5)
Foreign currency translation adjustments(4)8—4
Adjustment to goodwill3——3

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

Table 21 after “Intangible assets consisted of the following:”

Download CSV
April 3, 2020January 3, 2020
Gross carrying valueAccumulated amortizationNet carrying valueGross carrying valueAccumulated amortizationNet carrying value
(in millions)
Finite-lived intangible assets:
Program intangibles$1,427$(566)$861$1,003$(536)$467
Software and technology102(84)18102(83)19
Customer relationships45(7)3845(6)39
Backlog34(6)28———

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

Table 22 after “The estimated annual amortization expense as of April 3, 2020, was as follows:”

Download CSV
Fiscal year ending
(in millions)
2020 (remainder of year)$142
2021171
2022166
2023144
2024100
2025 and thereafter223

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

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

Download CSV
Three Months Ended
Income statement line itemApril 3, 2020March 29, 2019
(in millions)
Sales-type leases:
Selling price at lease commencementRevenues$16$10
Cost of underlying assetCost of revenues(13)(9)
Operating income31
Interest income on lease receivablesRevenues2—

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

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

Download CSV
April 3, 2020January 3, 2020
Carrying valueFair valueCarrying valueFair value
(in millions)
Financial assets:
Derivatives$5$5$2$2
Financial liabilities:
Derivatives$125$125$75$75

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

Download CSV
Asset derivatives
Balance sheet line itemApril 3, 2020January 3, 2020
(in millions)
Fair value interest rate swapsOther current assets(1)$4$2
Foreign currency forward contractsOther current assets1—
$5$2
(1) The carrying amount of the fair value interest rate swaps were recorded within "Other assets" as of January 3, 2020.
Liability derivatives

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

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

Download CSV
Carrying amount of hedged itemCumulative amount of fair value adjustment included within the hedged item
Balance sheet line item of hedged itemApril 3, 2020January 3, 2020April 3, 2020January 3, 2020
(in millions)
Long-term debt, current portion(1)$454$452$4$2

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(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$38
Amount recognized in other comprehensive loss$(55)$(18)
Amount reclassified from accumulated other comprehensive loss to interest expense, net—(2)

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

Download CSV
Stated interest rateEffective interest rateApril 3, 2020(1)January 3, 2020(1)
(in millions)
Senior unsecured bridge loan:
$1,250 million bridge loan, due January 20212.37%4.00%$1,238$—
Senior unsecured term loan:
$1,925 million Term Loan A, due January 20252.37%2.64%1,906—
Senior secured term loans:
$690 million Term Loan A, due August 20233.31%3.74%—581

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

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

Download CSV
Foreign currency translation adjustmentsUnrecognized gain (loss) on derivative instrumentsPension adjustmentsTotal accumulated other comprehensive loss
(in millions)
Balance at December 28, 2018$(41)$14$(3)$(30)
Other comprehensive income (loss)5(55)(1)(51)
Taxes315—18
Reclassification from accumulated other comprehensive loss—(7)—(7)
Balance at January 3, 2020(33)(33)(4)(70)
Other comprehensive (loss) income(76)(55)1(130)

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

Table 30 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 3, 2020March 29, 2019
(in millions)
Basic weighted average number of shares outstanding142145
Dilutive common share equivalents—stock options and other stock awards22
Diluted weighted average number of shares outstanding144147

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(in millions)
Supplementary cash flow information:
Cash paid for interest$27$43
Cash paid for income taxes, net of refunds—3
Non-cash investing activity:
Fixed asset additions$13$—

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

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

Download CSV
Three Months Ended
April 3, 2020
(in millions)
Sales of accounts receivable$564
Cash collections on sold receivables remitted to financial institution(367)
Outstanding balance sold to financial institution197
Cash collected but not yet remitted to financial institution(60)
Sold receivables due from customers$137

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

Download CSV
April 3, 2020January 3, 2020
(in millions)
Cash and cash equivalents$445$668
Restricted cash12049
Total cash, cash equivalents and restricted cash$565$717

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(in millions)
Revenues:
Defense Solutions$1,705$1,491
Civil654623
Health530463
Total revenues$2,889$2,577

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

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019Dollar changePercent change
(dollars in millions)
Revenues$2,889$2,577$31212.1%
Operating income192192——%
Non-operating (expense) income, net(62)54(116)214.8%
Income before income taxes130246(116)(47.2)%
Income tax expense(15)(57)42(73.7)%

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

Table 36 after “Segment and Corporate Results”

Download CSV
Three Months Ended
Defense SolutionsApril 3, 2020March 29, 2019Dollar changePercent change
(dollars in millions)
Revenues$1,705$1,491$21414.4%
Operating income95104(9)(8.7)%
Operating margin5.6%7.0%

Table 37 after “The decrease in operating income for the three months ended April 3, 2020, as compared to the three months ended March 29, 2019, was primari”

Download CSV
Three Months Ended
CivilApril 3, 2020March 29, 2019Dollar changePercent change
(dollars in millions)
Revenues$654$623$315.0%
Operating income595811.7%
Operating margin9.0%9.3%

Table 38 after “The increase in operating income for the three months ended April 3, 2020, as compared to the three months ended March 29, 2019, was primari”

Download CSV
Three Months Ended
HealthApril 3, 2020March 29, 2019Dollar changePercent change
(dollars in millions)
Revenues$530$463$6714.5%
Operating income73452862.2%
Operating margin13.8%9.7%

Table 39 after “The increase in operating income for the three months ended April 3, 2020, as compared to the three months ended March 29, 2019, was primari”

Download CSV
Three Months Ended
CorporateApril 3, 2020March 29, 2019Dollar changePercent change
(dollars in millions)
Operating loss$(35)$(15)$(20)NM

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

Download CSV
April 3, 2020January 3, 2020
(in millions)
Defense Solutions:
Funded backlog$3,936$3,063
Negotiated unfunded backlog12,29411,974
Total Defense Solutions backlog$16,230$15,037
Civil:
Funded backlog$1,296$1,267

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

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

Download CSV
Three Months Ended
April 3, 2020March 29, 2019
(in millions)
Net cash provided by operating activities$372$288
Net cash (used in) provided by investing activities(1,685)237
Net cash provided by (used in) financing activities1,161(297)
Net (decrease) increase in cash, cash equivalents and restricted cash$(152)$228

Table 42 after “The following table presents repurchases of Leidos common stock during the quarter ended April 3, 2020:”

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
January 4, 2020 - January 31, 20204,703$97.70—7,696,108
February 1, 2020 - February 29, 2020———7,696,108
March 1, 2020 - March 31, 202022872.51—7,696,108
April 1, 2020 - April 3, 2020———7,696,108
Total4,931$96.54—

Table 43 after “Exhibits.”

Download CSV
Exhibit NumberDescription of Exhibit
10.1Sale Agreement dated as of February 3, 2020, by and among L3 Harris Technologies, Inc., Leidos Inc. and Leidos Holdings Inc. Incorporated by reference to Exhibit 2.1 to our Current Report on Form 8-K filed with the SEC on February 4, 2020.
10.2Credit Agreement dated as of January 17, 2020, among Leidos Holdings, Inc., Leidos Inc. and Citibank, N.A. Incorporated by reference to Exhibit 10.1 to our Current Report on Form 8-K filed with the SEC on January 17, 2020.
10.3Bridge Credit Agreement dated as of January 31, 2020, among Leidos Holdings, Inc., Leidos Inc. and Citibank, N.A. Incorporated by reference to Exhibit 4.1 to our Current Report on Form 8-K filed with the SEC on January 31, 2020.
10.4Term Loan Credit Agreement dated as of February 12, 2020, among Leidos Holdings, Inc., Leidos, Inc. and Citibank, N.A. Incorporated by reference to Exhibit 10.1 to our Current Report on Form 8-K filed with the SEC on February 14, 2020.
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.

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