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 Feb 9, 2023. 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 “million shares of common stock outstanding.”

Download CSV
TABLE OF CONTENTS
Page
PART I - FINANCIAL INFORMATION
Item 1.Financial Statements (Unaudited)
Condensed Consolidated Statements of Operations for the Three and Six Months Ended December 31, 2022 and January 1, 20222
Condensed Consolidated Statements of Comprehensive Income (Loss) for the Three and Six Months Ended December 31, 2022 and January 1, 20223
Condensed Consolidated Balance Sheets as of December 31, 2022 and July 2, 20224
Condensed Consolidated Statements of Stockholders’ Equity for the Three and Six Months Ended December 31, 2022 and January 1, 20225

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

Table 2 after “)”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Net revenue$506.0$446.7$1,012.8$895.1
Cost of sales315.1223.3597.7423.7
Amortization of acquired developed intangibles24.715.947.731.7
Gross profit166.2207.5367.4439.7
Operating expenses:
Research and development75.853.2148.5107.3

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

Table 3 after “(Unaudited)”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Net income (loss)$(31.7)$56.7$(32.1)$138.2
Other comprehensive income (loss), net of tax:
Net change in unrealized gain (loss) on available-for-sale securities3.6(2.3)3.0(2.0)
Other comprehensive income (loss), net of tax3.6(2.3)3.0(2.0)
Comprehensive income (loss), net of tax$(28.1)$54.4$(29.1)$136.2

Table 4 after “)”

Download CSV
December 31, 2022July 2, 2022
ASSETS
Current assets:
Cash and cash equivalents$592.1$1,290.2
Short-term investments1,088.31,258.8
Accounts receivable, net330.5262.0
Inventories366.9250.1
Prepayments and other current assets114.878.1

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

Table 5 after “)”

Download CSV
Common StockAdditional Paid-In CapitalAccumulated DeficitAccumulated Other Comprehensive Income (Loss)Total Stockholders' Equity
SharesAmount
Balance as of July 2, 202268.0$0.1$2,003.6$(129.1)$0.4$1,875.0
Cumulative adjustment from adoption of ASU 2020-06——(426.5)85.6—(340.9)
Net loss———(0.4)—(0.4)
Other comprehensive loss————(0.6)(0.6)
Issuance of shares in connection with vesting of restricted stock units and performance stock units0.7—————
Withholding taxes related to net share settlement of restricted stock units(0.2)—(22.4)——(22.4)

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

Table 6 after “)”

Download CSV
Common StockAdditional Paid-In CapitalRetained EarningsAccumulated Other Comprehensive IncomeTotal Stockholders' Equity
SharesAmount
Balance as of July 3, 202173.0$0.1$1,743.6$220.9$8.2$1,972.8
Net income———81.581.5
Other comprehensive income————0.30.3
Issuance of shares in connection with vesting of restricted stock units and performance stock units0.6—————
Withholding taxes related to net share settlement of restricted stock units(0.2)—(16.6)——(16.6)
Repurchases of common stock(1.1)——(91.7)—(91.7)

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

Table 7 after “(Unaudited)”

Download CSV
Six Months Ended
December 31, 2022January 1, 2022
OPERATING ACTIVITIES:
Net income (loss)$(32.1)$138.2
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation expense50.941.0
Stock-based compensation83.252.1
Amortization of acquired intangibles68.342.9

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

Table 8 after “):”

Download CSV
Short Term Debt - 2024 NotesLong Term Debt - 2026 NotesLong Term Debt - 2028 NotesAdditional Paid-In CapitalAccumulated DeficitDeferred Tax Asset (Liability), net
Balances pre-adoption of ASC 2020-06$409.9$831.4$634.7$2,003.6$129.1$12.9
Reclassify amounts from equity to debt—312.9229.3(542.2)——
Adjustment for interest accretion—(99.5)(9.7)—(109.2)—
Tax effect———115.723.692.1
Balances upon adoption of ASC 2020-06$409.9$1,044.8$854.3$1,577.1$43.5$105.0

Table 9 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Numerator:
Net income (loss) - basic and diluted$(31.7)$56.7$(32.1)$138.2
Denominator:
Weighted average common shares outstanding - basic68.372.368.272.5
Effect of dilutive securities from stock-based benefit plans—0.5—0.6
Shares issuable assuming conversion of the convertible notes—2.5—2.3

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

Table 10 after “):”

Download CSV
Fair Value
Cash consideration for outstanding NeoPhotonics common stock (1)$867.3
Settlement of pre-existing relationship (loan to NeoPhotonics) (2)50.0
Stock-based compensation (3)17.1
Total purchase price consideration$934.4

Table 11 after “):”

Download CSV
Fair Value
Total purchase price consideration$934.4
Assets acquired
Cash and cash equivalents$92.9
Accounts receivable, net66.5
Inventories84.3
Prepayments and other current assets24.2
Property, plant and equipment, net106.1

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

Table 12 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Net revenue$506.0$527.3$1,036.7$1,059.4
Net income (loss)(25.8)22.86.645.0

Table 13 after “):”

Download CSV
Amortized CostGross Unrealized GainsGross Unrealized LossesFair Value
December 31, 2022:
Cash$383.3$—$—$383.3
Cash equivalents:
Commercial paper4.8——4.8
Money market funds180.1——180.1
U.S. Treasury securities23.9——23.9
Total cash and cash equivalents$592.1$—$—$592.1

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

Table 14 after “):”

Download CSV
Continuous Loss Position For More Than 12 MonthsContinuous Loss Position For Less Than 12 MonthsGross Unrealized Losses
Fair ValueUnrealized LossesFair ValueUnrealized Losses
December 31, 2022:
U.S. Agency securities$45.9$(1.1)$83.0$(0.5)$(1.6)
Certificates of deposit——5.7——
Commercial paper——73.4(0.2)(0.2)
Corporate debt securities283.9(3.0)176.2(1.8)(4.8)
Municipal bonds1.0————

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

Table 15 after “(Unaudited)”

Download CSV
December 31, 2022July 2, 2022
Amortized CostFair ValueAmortized CostFair Value
Due in 1 year$879.5$871.6$1,010.9$1,002.2
Due in 1 year through 5 years218.1216.7261.0256.6
$1,097.6$1,088.3$1,271.9$1,258.8

Table 16 after “):”

Download CSV
Level 1Level 2Level 3Total
December 31, 2022: (1)
Assets:
Cash equivalents:
Commercial paper$—$4.8$—$4.8
Money market funds180.1——180.1
U.S. Treasury securities23.9——23.9
Short-term investments:

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

Table 17 after “million in cash held in our bank accounts as of December 31, 2022.”

Download CSV
Level 1Level 2Level 3Total
July 2, 2022: (1)
Assets:
Cash equivalents:
Commercial paper$—$23.6$—$23.6
Money market funds1,000.2——1,000.2
U.S. Agency securities—8.0—8.0
U.S. Treasury securities22.5——22.5

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

Table 18 after “):”

Download CSV
December 31, 2022July 2, 2022
Carrying AmountEstimated Fair ValueCarrying AmountEstimated Fair Value
2028 Notes$855.0$659.7$634.7$735.7
2026 Notes1,045.3907.4831.41,065.0
2024 Notes420.7473.2409.9614.2
$2,321.0$2,040.3$1,876.0$2,414.9

Table 19 after “):”

Download CSV
December 31, 2022July 2, 2022
Raw materials and purchased parts$166.2$98.9
Work in process118.992.2
Finished goods81.859.0
Inventories$366.9$250.1

Table 20 after “):”

Download CSV
December 31, 2022July 2, 2022
Operating lease right-of-use assets$119.1$102.1
Less: accumulated amortization(34.2)(28.5)
Operating lease right-of-use assets, net$84.9$73.6

Table 21 after “):”

Download CSV
December 31, 2022July 2, 2022
Land$63.3$49.7
Buildings and improvements146.6105.3
Machinery and equipment632.6548.8
Computer equipment and software36.131.3
Furniture and fixtures10.18.9
Leasehold improvements45.935.7
Construction in progress75.947.0

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

Table 22 after “:”

Download CSV
December 31, 2022July 2, 2022
Restructuring accrual and related charges (1)$14.1$—
Warranty accrual8.410.0
Income tax payable (2)20.526.0
Other current liabilities8.23.4
Other current liabilities$51.2$39.4

Table 23 after “):”

Download CSV
December 31, 2022July 2, 2022
Asset retirement obligations$8.1$4.6
Pension and related accruals (1)9.07.7
Unrecognized tax benefit52.130.5
Other non-current liabilities7.90.1
Other non-current liabilities$77.1$42.9

Table 24 after “:”

Download CSV
Optical CommunicationsCommercial LasersTotal
Balance as of July 2, 2022$363.5$5.4$368.9
Acquisition of NeoPhotonics (1)318.4—318.4
Acquisition of IPG product lines (2)10.9—10.9
Balance as of December 31, 2022$692.8$5.4$698.2

Table 25 after “):”

Download CSV
Preliminary fair value at the acquisition dateWeighted average amortization period (in years)
NeoPhotonicsIPG product linesTotal acquired
Acquired developed technologies$220.0$8.6$228.65.2
Customer relationships144.52.3146.85.9
In-process research and development48.029.177.1n/a
Total intangible assets$412.5$40.0$452.5

Table 26 after “):”

Download CSV
December 31, 2022Gross Carrying AmountsAccumulated AmortizationNet Carrying AmountsWeighted average remaining amortization period (years)
Acquired developed technologies$618.9$(352.3)$266.64.3
Customer relationships291.8(95.6)196.25.1
In-process research and development77.1—77.1n/a
Total intangible assets$987.8$(447.9)$539.9

Table 27 after “):”

Download CSV
July 2, 2022Gross Carrying AmountsAccumulated AmortizationNet Carrying AmountsWeighted average remaining amortization period (years)
Acquired developed technologies$390.3$(303.6)$86.72.5
Customer relationships145.0(76.0)69.04.4
Total intangible assets$535.3$(379.6)$155.7

Table 28 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Cost of sales$24.8$15.9$47.7$31.7
Selling, general and administrative11.35.620.611.2
Total amortization of intangibles$36.1$21.5$68.3$42.9

Table 29 after “:”

Download CSV
Fiscal Years
Remainder of 2023$57.5
2024110.2
202597.3
202684.9
202773.0
Thereafter39.9
Total future amortization$462.8

Table 30 after “):”

Download CSV
Liability component:December 31, 2022July 2, 2022
2024 Notes (1)2026 Notes (2)2028 Notes (3)2024 Notes (1)2026 Notes (2)2028 Notes (3)
Principal$448.1$1,050.0$861.0$448.1$1,050.0$861.0
Unamortized debt discount and issuance costs(27.4)(4.7)(6.0)(38.2)(218.6)(226.3)
Net carrying amount of the liability component$420.7$1,045.3$855.0$409.9$831.4$634.7

Table 31 after “:”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Contractual interest expense$2.7$1.6$5.4$3.2
Amortization of the debt discount and debt issuance costs6.215.511.930.8
Total interest expense$8.9$17.1$17.3$34.0

Table 32 after “:”

Download CSV
Fiscal Years2024 Notes2026 Notes2028 NotesTotal
Remainder of 2023$0.6$2.6$2.2$5.4
2024449.25.34.3458.8
2025—5.34.39.6
2026—5.34.39.6
2027 and thereafter—1,052.4869.61,922.0
Total convertible notes payments$449.8$1,070.9$884.7$2,405.4

Table 33 after “):”

Download CSV
Foreign currency translation adjustments, net of tax (1)Defined benefit obligations, net of tax (2)Unrealized gain (loss) on available-for-sale securities, net of taxTotal
Beginning balance as of July 2, 2022$9.7$1.0$(10.3)$0.4
Other comprehensive loss——(0.6)(0.6)
Ending balance as of October 1, 20229.71.0(10.9)(0.2)
Other comprehensive gain——3.63.6
Ending balance as of December 31, 2022$9.7$1.0$(7.3)$3.4
Foreign currency translation adjustments, net of tax (1)Defined benefit obligations, net of tax (2)Unrealized gain (loss) on available-for-sale securities, net of taxTotal
Beginning balance as of July 3, 2021$9.7$(1.4)$(0.1)$8.2

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

Table 34 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Balance as of beginning of period$3.1$0.8$—$5.7
Charges (reversals), net13.90.123.2(1.0)
Payments(2.9)(0.6)(9.1)(4.4)
Balance as of end of period$14.1$0.3$14.1$0.3

Table 35 after “:”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Cost of sales$6.7$5.2$12.2$9.8
Research and development10.65.420.210.4
Selling, general and administrative19.316.750.831.9
Total stock-based compensation$36.6$27.3$83.2$52.1

Table 36 after “:”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Income tax benefit associated with stock-based compensation$6.4$4.2$11.5$8.2

Table 37 after “:”

Download CSV
Restricted Stock UnitsPerformance Stock Units
Number of SharesWeighted-Average Grant Date Fair Value per ShareNumber of SharesWeighted-Average Grant Date Fair Value per Share
Balance as of July 2, 20222.0$85.90.3$81.9
Replacement Awards Issued0.493.4——
Granted1.686.90.688.2
Vested(0.7)83.9(0.1)70.5
Canceled(0.2)88.1(0.1)88.6
Balance as of December 31, 20223.1$87.80.7$89.3

Table 38 after “:”

Download CSV
Awards Available for Grant
Balance as of July 2, 20223.8
Assumed in connection with NeoPhotonics merger0.4
Replacement Awards(0.4)
Authorized0.9
Granted(2.2)
Canceled0.3
Balance as of December 31, 20222.8

Table 39 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Balance as of beginning of period$10.1$5.1$10.0$5.0
Warranties assumed in NeoPhotonics merger——0.7—
Provision for warranty2.83.84.35.5
Utilization of reserve(4.5)(0.3)(6.6)(1.9)
Balance as of end of period$8.4$8.6$8.4$8.6

Table 40 after “:”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Net revenue:
OpComms$448.8$397.4$902.2$803.4
Lasers57.249.3110.691.7
Net revenue$506.0$446.7$1,012.8$895.1
Gross profit:
OpComms$197.0$201.8$413.0$427.7

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

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

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Amount% of TotalAmount% of TotalAmount% of TotalAmount% of Total
Net revenue:
Americas:
United States$65.512.9%$51.011.4%$127.712.6%$79.18.8%
Mexico59.511.838.38.6117.011.671.38.0
Other Americas3.80.82.70.66.10.64.70.5

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

Table 42 after “:”

Download CSV
December 31, 2022July 2, 2022
Property, plant and equipment, net
United States$131.2$107.8
Thailand131.7107.6
Japan94.238.9
China52.232.7
Other countries78.473.5
Total property, plant and equipment, net$487.7$360.5

Table 43 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
OpComms:
Telecom and Datacom$384.275.9%$267.159.8%$744.373.5%$483.154.0%
Industrial and Consumer64.612.8%130.329.2%157.915.6%320.335.8%
Total OpComms$448.888.7%$397.489.0%$902.289.1%$803.489.8%
Lasers57.211.3%49.311.0%110.610.9%91.710.2%
Net Revenue$506.0$446.7$1,012.8$895.1

Table 44 after “):”

Download CSV
Contract balancesBalance sheet locationDecember 31, 2022July 2, 2022ChangePercentage Change
Accounts receivable, netAccounts receivable, net$330.5$262.0$68.526.1%
Deferred revenue and customer depositsOther current liabilities$1.3$—$1.3n/a

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 EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Segment net revenue:
OpComms88.7%89.0%89.1%89.8%
Lasers11.311.010.910.2
Net revenue100.0100.0100.0100.0
Cost of sales62.350.059.047.3
Amortization of acquired developed intangibles4.93.64.73.5

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

Table 46 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022ChangePercentage ChangeDecember 31, 2022January 1, 2022ChangePercentage Change
Segment net revenue:
OpComms$448.8$397.4$51.412.9%$902.2$803.4$98.812.3%
Lasers57.249.37.916.0%110.691.718.920.6%
Net revenue$506.0$446.7$59.313.3%$1,012.8$895.1$117.713.1%
Gross profit$166.2$207.5$(41.3)(19.9)%$367.4$439.7$(72.3)(16.4)%
Gross margin32.8%46.5%36.3%49.1%

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

Table 47 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Amount% of TotalAmount% of TotalAmount% of TotalAmount% of Total
Americas:
United States$65.512.9%$51.011.4%$127.712.6%$79.18.8%
Mexico59.511.838.38.6117.011.671.38.0
Other Americas3.80.82.70.66.10.64.70.5
Total Americas$128.825.5%$92.020.6%$250.824.8%$155.117.3%

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

Table 48 after “):”

Download CSV
Three Months EndedSix Months Ended
Gross ProfitGross MarginGross ProfitGross Margin
December 31, 2022January 1, 2022December 31, 2022January 1, 2022December 31, 2022January 1, 2022December 31, 2022January 1, 2022
OpComms$197.0$201.843.9%50.8%$413.0$427.745.8%53.2%
Lasers30.026.252.4%53.1%58.147.052.5%51.3%
Segment total$227.0$228.044.9%51.0%$471.1$474.746.5%53.0%
Unallocated corporate items:
Stock-based compensation(6.7)(5.2)(12.2)(9.8)

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

Table 49 after “):”

Download CSV
Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Foreign exchange gains (losses), net$(4.1)$0.7$4.9$0.6
Interest and investment income7.70.612.51.2
Other income (expense), net0.1(0.3)0.1(0.2)
Total other income, net$3.7$1.0$17.5$1.6

Table 50 after “Provision for Income Taxes”

Download CSV
(in millions)Three Months EndedSix Months Ended
December 31, 2022January 1, 2022December 31, 2022January 1, 2022
Provision for income taxes$4.6$12.4$23.8$30.5

Table 51 after “):”

Download CSV
Payments due by period
TotalLess than 1 yearMore than 1 year
Contractual Obligations
Asset retirement obligations$8.1$0.5$7.6
Operating lease liabilities, including imputed interest (1)78.614.464.2
Pension plan contributions (2)1.41.4—
Purchase obligations (3)391.5361.030.5
Convertible notes - principal (4)2,359.1—2,359.1

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

Table 52 after “):”

Download CSV
PeriodTotal number of shares purchased (1)Average price paid per share (2)Total number of shares purchased as part of publicly announced plans or programsMaximum number (or approximation dollar value) of shares that may yet be purchased under the plans or programs
October 2, 2022 to October 29, 2022—$——$384.5
October 30, 2022 to November 26, 2022—$——$384.5
November 27, 2022 to December 31, 2022—$——$384.5
Total—$——$384.5

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
ExhibitIncorporated by ReferenceFiled
No.Exhibit DescriptionFormFile No.ExhibitFiling 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.1†Certification 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.2†Certification 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
101The following financial information from Lumentum Holdings Inc.’s Quarterly Report on Form 10-Q for the fiscal quarter ended December 31, 2022 formatted in Inline XBRL (eXtensible Business Reporting Language): (i) Condensed Consolidated Statements of Operations for the three and six months ended December 31, 2022 and January 1, 2022; (ii) Condensed Consolidated Statements of Comprehensive Income (Loss) for the three and six months ended December 31, 2022 and January 1, 2022; (iii) Condensed Consolidated Balance Sheets as of December 31, 2022 and July 2, 2022; (iv) Condensed Consolidated Statements of Stockholders’ Equity for the three and six months ended December 31, 2022 and January 1 , 2022; (v) Condensed Consolidated Statements of Cash Flows for the six months ended December 31, 2022 and January 1, 2022, and (vi) Notes to the Consolidated Financial Statements.X
104Cover Page Interactive Data File, formatted in Inline XBRL (included in Exhibit 101).X