tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of LITE

Tables in the 10-Q of Lumentum Holdings Inc.

53 tables with numbers, filed Nov 1, 2018. 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
TABLE OF CONTENTS
Page
PART I - FINANCIAL INFORMATION
Item 1.Financial Statements (Unaudited)
Condensed Consolidated Statements of Operations for the Three Months Ended September 29, 2018 and September 30, 20172
Condensed Consolidated Statements of Comprehensive Income (Loss) for the Three Months Ended September 29, 2018 and September 30, 20173
Condensed Consolidated Balance Sheets as of September 29, 2018 and June 30, 20184
Condensed Consolidated Statements of Cash Flows for the Three Months Ended September 29, 2018 and September 30, 20175

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

Table 2 after “(Unaudited)”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Net revenue$354.1$243.2
Cost of sales227.3173.9
Amortization of acquired developed technologies0.80.8
Gross profit126.068.5
Operating expenses:
Research and development34.636.3

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

Table 3 after “(Unaudited)”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Net income$47.4$7.1
Other comprehensive income (loss), net of tax:
Net change in cumulative translation adjustment0.11.9
Net change in unrealized gain (loss) on available-for-sale securities0.4(0.1)
Other comprehensive income, net of tax0.51.8
Comprehensive income (loss), net of tax$47.9$8.9

Table 4 after “(Unaudited)”

Download CSV
September 29, 2018June 30, 2018
ASSETS
Current assets:
Cash and cash equivalents$459.4$397.3
Short-term investments274.9314.2
Accounts receivable, net239.6197.1
Inventories136.6153.6
Prepayments and other current assets70.665.0

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

Table 5 after “(Unaudited)”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
OPERATING ACTIVITIES:
Net income$47.4$7.1
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation expense19.716.7
Stock-based compensation10.89.3
Unrealized (gain) loss on derivative liability2.1(4.2)

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

Table 6 after “:”

Download CSV
Less than 1 year1-2 yearsGreater than 2 yearsTotal
Performance Obligations$384.8$22.7$0.4$407.9

Table 7 after “The following table reflects the changes in contract balances for the three months ended September 30, 2018:”

Download CSV
Contract balancesBalance sheet locationSeptember 29, 2018June 30, 2018ChangePercentage Change
Accounts receivable, netAccounts receivable, net$239.6$197.1$42.521.6%
Deferred revenue and customer depositsOther current liabilities$2.6$2.8$(0.2)(7.1)%

Table 8 after “Select condensed consolidated balance sheet line items, as if we had adopted Topic 606 in previous years, are summarized below as of the per”

Download CSV
June 30, 2018AdjustmentsJuly 1, 2018
Assets:
Accounts receivable, net$197.1$0.6$197.7
Inventories153.6(1.2)152.4
Stockholders’ equity:
Retained earnings$166.4$(0.6)$165.8

Table 9 after “):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Basic Earnings per Common Share
Net income$47.4$7.1
Less: Cumulative dividends on Series A Preferred Stock(0.2)(0.2)
Less: Earnings allocated to Series A Preferred Stock(1.1)(0.2)
Net income attributable to common stockholders - Basic$46.1$6.7
Weighted average common shares outstanding including Series A Preferred Stock64.663.2

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

Table 10 after “):”

Download CSV
Foreign currency translation adjustments, net of taxDefined benefit obligation, net of tax (1)Unrealized gain (loss) on available-for-sale securities, net of taxTotal
Beginning balance as of June 30, 2018$10.3$(2.3)$(1.6)$6.4
Other comprehensive income0.1—0.40.5
Ending balance as of September 29, 2018$10.4$(2.3)$(1.2)$6.9

Table 11 after “):”

Download CSV
September 29, 2018June 30, 2018
Finished goods$80.7$98.2
Work in process32.934.5
Raw materials and purchased parts23.020.9
Inventories$136.6$153.6

Table 12 after “):”

Download CSV
September 29, 2018June 30, 2018
Capitalized manufacturing overhead$18.3$20.5
Prepayments22.319.5
Advances to contract manufacturers13.714.0
Other current assets16.311.0
Prepayments and other current assets$70.6$65.0

Table 13 after “):”

Download CSV
September 29, 2018June 30, 2018
Land$10.6$10.6
Buildings and improvement59.455.1
Machinery and equipment (1)476.0463.6
Computer equipment and software26.526.3
Furniture and fixtures2.92.2
Leasehold improvements27.025.8
Construction in progress59.952.6

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

Table 14 after “NOTES TO UNAUDITED CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Continued)”

Download CSV
September 29, 2018June 30, 2018
Warranty accrual (1)$6.6$6.6
Restructuring accrual and related charges (2)1.61.9
Deferred revenue and customer deposits2.62.8
Capital lease obligation (3)5.47.3
Other current liabilities4.83.5
Other current liabilities$21.0$22.1

Table 15 after “):”

Download CSV
September 29, 2018June 30, 2018
Asset retirement obligation$2.7$2.7
Pension and related accrual3.73.5
Deferred rent2.52.6
Unrecognized tax benefit9.06.1
Capital lease obligation (1)—0.4
Other non-current liabilities0.93.7
Other non-current liabilities$18.8$19.0

Table 16 after “):”

Download CSV
Amortized CostGross Unrealized GainsGross Unrealized LossesFair Value
September 29, 2018:
Cash$149.9$—$—$149.9
Cash equivalents:
Commercial paper3.6——3.6
Money market funds286.5——286.5
U.S. Treasury19.4——19.4
Total cash and cash equivalents$459.4$—$—$459.4

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

Table 17 after “:”

Download CSV
Less than 12 months12 Months or GreaterTotal
Fair ValueUnrealized LossesFair ValueUnrealized LossesFair ValueUnrealized Losses
September 29, 2018:
Commercial paper$6.1$—$—$—$6.1$—
Asset-backed securities48.4(0.2)8.5—56.9(0.2)
Corporate debt securities113.3(0.8)46.9(0.3)160.2(1.1)
Mortgage-backed securities2.8———2.8—
Foreign government bonds4.1———4.1—

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

Table 18 after “):”

Download CSV
September 29, 2018June 30, 2018
Amortized CostFair ValueAmortized CostFair Value
Due in 1 year$150.0$149.5$150.1$149.6
Due in 1 year through 5 years119.4118.7157.2156.1
Due in 5 years through 10 years4.94.96.16.1
Due after 10 years1.81.82.42.4
$276.1$274.9$315.8$314.2

Table 19 after “NOTES TO UNAUDITED CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Continued)”

Download CSV
Level 1Level 2Level 3Total
September 29, 2018:
Assets:
Cash equivalents:
Commercial paper$—$3.6$—$3.6
Money market funds286.5——286.5
U.S. Treasury19.4——19.4
Short-term investments:

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

Table 20 after “NOTES TO UNAUDITED CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Continued)”

Download CSV
Level 1Level 2Level 3Total
June 30, 2018:
Assets:
Cash equivalents:
Certificates of deposit$—$3.0$—$3.0
Commercial paper—112.1—112.1
Money market funds0.8——0.8
U.S. Treasury securities143.6——143.6

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

Table 21 after “):”

Download CSV
Liability component:September 29, 2018June 30, 2018
Principal$450.0$450.0
Unamortized debt discount(111.5)(115.8)
Net carrying amount of the liability component$338.5$334.2

Table 22 after “:”

Download CSV
Three Months Ended
(in millions, except percentages)September 29, 2018September 30, 2017
Contractual interest expense$0.3$0.3
Amortization of the debt discount4.34.1
Total interest expense$4.6$4.4
Effective interest rate on the liability component5.4%5.4%

Table 23 after “):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Balance as of beginning of period$52.4$51.6
Unrealized (gain) loss on the Series A Preferred Stock derivative liability2.1(4.2)
Balance as of end of period$54.5$47.4

Table 24 after “:”

Download CSV
Optical CommunicationsCommercial LasersTotal
Balance as of beginning of period$5.9$5.4$11.3
Foreign currency translation adjustment———
Balance as of end of period$5.9$5.4$11.3

Table 25 after “:”

Download CSV
Optical CommunicationsCommercial LasersTotal
Balance as of beginning of period$5.9$5.5$11.4
Foreign currency translation adjustment0.2(0.1)0.1
Balance as of end of period$6.1$5.4$11.5

Table 26 after “):”

Download CSV
September 29, 2018:Gross Carrying AmountAccumulated AmortizationNet
Acquired developed technologies$105.6$(99.3)$6.3
Other intangibles7.0(7.0)—
Total intangible assets$112.6$(106.3)$6.3

Table 27 after “):”

Download CSV
June 30, 2018:Gross Carrying AmountAccumulated AmortizationNet
Acquired developed technologies$105.5$(98.5)$7.0
Other intangibles7.0(7.0)—
Total intangible assets$112.5$(105.5)$7.0

Table 28 after “):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Cost of sales$0.8$0.8
Total$0.8$0.8

Table 29 after “(in millions):”

Download CSV
Fiscal Years
Remainder of 2019$2.2
20202.9
20210.5
20220.5
Thereafter0.2
Total amortization$6.3

Table 30 after “):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Balance as of beginning of period$1.9$3.8
Charges1.32.9
Payments(1.6)(5.4)
Balance as of end of period$1.6$1.3

Table 31 after “:”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Cost of sales$3.3$2.7
Research and development2.83.1
Selling, general and administrative4.73.5
$10.8$9.3

Table 32 after “:”

Download CSV
Restricted Stock UnitsRestricted Stock AwardsPerformance Stock Units
Number of SharesWeighted-Average Grant Date Fair Value per ShareNumber of SharesWeighted-Average Grant Date Fair Value per ShareNumber of Shares (1)Weighted-Average Grant Date Fair Value per Share
Unvested balance as of beginning of period1.7$43.10.1$32.50.2$52.0
Granted0.767.8————
Vested(0.5)38.4——(0.1)52.0
Canceled(0.1)49.6————
Unvested balance as of end of period1.8$55.20.1$32.50.1$—

Table 33 after “NOTES TO UNAUDITED CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Continued)”

Download CSV
Awards Available for Grant
Balance as of beginning of period5.6
Granted(0.7)
Canceled0.1
Balance as of end of period5.0

Table 34 after “, the assumptions used to estimate the fair value of the 2015 Purchase Plan shares to be issued were as follows:”

Download CSV
September 29, 2018September 30, 2017
Expected term (years)0.50.5
Expected volatility58.8%53.0%
Risk-free interest rate2.02%1.02%
Dividend yield—%—%

Table 35 after “):”

Download CSV
Fiscal Years
Remainder of 2019$8.8
20206.5
20215.1
20223.4
20232.4
Thereafter1.8
Total minimum operating lease payments$28.0

Table 36 after “):”

Download CSV
Fiscal Years
Remainder of 2019$6.7
20200.4
Total minimum capital lease payments$7.1
Less: amount representing interest$(0.1)
Present value of capital lease obligation$7.0

Table 37 after “:”

Download CSV
Fiscal Years
Remainder of 2019$0.6
20201.1
20211.1
20221.1
20231.1
Thereafter451.2
Total 2024 Notes payments$456.2

Table 38 after “):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Balance as of beginning of period$6.6$9.7
Provision for warranty1.21.0
Utilization of reserve(1.2)(1.3)
Balance as of end of period$6.6$9.4

Table 39 after “:”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Net revenue:
OpComms$310.1$207.9
Lasers44.035.3
Net revenue$354.1$243.2
Gross profit:
OpComms124.972.1

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

Table 40 after “reportable segments. In addition, it discloses the percentage of our total net revenue attributable to our product offerings which serve the”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
OpComms:$310.1$207.9
Telecom142.9110.4
Datacom34.245.2
Consumer and Industrial133.052.3
Lasers$44.0$35.3

Table 41 after “(in millions, except percentage data):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Net revenue:
Americas:
United States$21.96.2%$33.613.8%
Mexico56.315.924.810.3
Other Americas0.90.32.20.9
Total Americas$79.122.4%$60.625.0%

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

Table 42 after “, net revenue generated from a single customer which represented 10% or greater of total net revenue is summarized as follows:”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Customer A30.5%16.3%
Customer B15.0%*
Customer C13.0%14.2%
Customer D*10.4%
*Represents less than 10% of total net revenue

Table 43 after “:”

Download CSV
As of
September 29, 2018June 30, 2018
Property, Plant and Equipment, net
United States$103.6$97.6
China62.170.0
Thailand131.3107.4
Other countries21.631.9
Total long-lived assets$318.6$306.9

Table 44 after “, net inventory purchased from a single contract manufacturer which represented 10% or greater of total net purchases is summarized as follo”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Vendor A51.5%44.9%
Vendor B25.1%25.7%
Vendor C*10.9%
*Represents less than 10% of total net purchases

Table 45 after “The results of operations for the periods presented are not necessarily indicative of results to be expected for future periods. The followi”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Segment net revenue:
OpComms87.6%85.5%
Lasers12.414.5
Net revenue100.0100.0
Cost of sales64.271.5
Amortization of acquired developed technologies0.20.3

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

Table 46 after “):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017ChangePercentage Change
Segment net revenue:
OpComms$310.1$207.9$102.249.2%
Lasers44.035.38.724.6
Net revenue$354.1$243.2$110.945.6%
Gross profit$126.0$68.5$57.583.9%
Gross margin35.6%28.2%

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

Table 47 after “, net revenue generated from a single customer which represented 10% or greater of total net revenue is summarized as follows:”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Customer A30.5%16.3%
Customer B15.0%*
Customer C13.0%14.2%
Customer D*10.4%
*Represents less than 10% of total net revenue

Table 48 after “):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Net revenue:
Americas:
United States$21.96.2%$33.613.8%
Mexico56.315.924.810.3
Other Americas0.90.32.20.9
Total Americas$79.122.4%$60.625.0%

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

Table 49 after “):”

Download CSV
Gross ProfitGross Margin
Three Months EndedThree Months Ended
September 29, 2018September 30, 2017September 29, 2018September 30, 2017
OpComms$124.9$72.140.3%34.7%
Lasers17.710.640.2%30.0%
Segment total$142.6$82.740.3%34.0%
Unallocated corporate items (1)(16.6)(14.2)
Total$126.0$68.535.6%28.2%

Table 50 after “):”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Interest expense$(5.1)$(4.4)
Foreign exchange gains (losses), net(0.3)(0.4)
Interest income2.71.5
Other income (expense), net0.3(0.1)
Interest and other income (expense), net$(2.4)$(3.4)

Table 51 after “(in millions)”

Download CSV
Three Months Ended
September 29, 2018September 30, 2017
Provision for (benefit from) income taxes$5.2$(3.6)

Table 52 after “):”

Download CSV
Payments due by period
TotalLess than 1 year1 - 3 years3 - 5 yearsMore than 5 years
Contractual Obligations
Asset retirement obligations$2.7$—$1.0$0.4$1.3
Purchase obligations (1)206.5203.53.0——
Operating lease obligations (1)28.010.410.85.31.5
Capital lease obligation (1)7.17.1———
Pension plan contributions (2)0.50.5———

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

Table 53 after “The following exhibits are filed herewith or are incorporated by reference to exhibits previously filed with the Securities and Exchange Com”

Download CSV
Incorporated by ReferenceFiled
Exhibit No.Exhibit DescriptionFormExhibitFiling DateHerewith
31.1Certification of the Chief Executive Officer pursuant to Securities Exchange Act Rules 13a-14(a) and 15d-14(a), as adopted pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.X
31.2Certification of the Chief Financial Officer pursuant to Securities Exchange Act Rules 13a-14(a) and 15d-14(a), as adopted pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.X
32.1Certification of the Chief Executive Officer pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002.X
32.2Certification of the Chief Financial Officer pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002.X
101.INSXBRL InstanceX
101.SCHXBRL Taxonomy Extension SchemaX

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