Tables

Tables in the 10-Q of Lumentum Holdings Inc.

59 tables with numbers, filed Oct 31, 2019. Each one downloads as an Excel file or a CSV (numbers are stored as numbers), 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 ↗

← Filings of LITE

Table 1 after “million shares of common stock outstanding.”

TABLE OF CONTENTS
Page
PART I - FINANCIAL INFORMATION
Item 1.Financial Statements (Unaudited)
Condensed Consolidated Statements of Operations for the Three Months Ended September 28, 2019 and September 29, 20182
Condensed Consolidated Statements of Comprehensive Income for the Three Months Ended September 28, 2019 and September 29, 20183
Condensed Consolidated Balance Sheets as of September 28, 2019 and June 29, 20194
Condensed Consolidated Statements of Redeemable Convertible Preferred Stock and Stockholders’ Equity for the Three Months Ended September 28, 2019 and September 29, 20185

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

Table 2 after “)”

Three Months Ended
September 28, 2019September 29, 2018
Net revenue$449.9$354.1
Cost of sales269.7227.3
Amortization of acquired developed intangibles12.50.8
Gross profit167.7126.0
Operating expenses:
Research and development49.934.6

First 8 of 29 rows. The download has all of them.

Table 3 after “(Unaudited)”

Three Months Ended
September 28, 2019September 29, 2018
Net income$47.6$47.4
Other comprehensive income, net of tax:
Net change in cumulative translation adjustment—0.1
Net change in unrealized gain on available-for-sale securities0.10.4
Other comprehensive income, net of tax0.10.5
Comprehensive income, net of tax$47.7$47.9

Table 4 after “)”

September 28, 2019June 29, 2019
ASSETS
Current assets:
Cash and cash equivalents$539.0$432.6
Short-term investments291.9335.9
Accounts receivable, net292.8238.0
Inventories202.2228.8
Prepayments and other current assets97.397.5

First 8 of 39 rows. The download has all of them.

Table 5 after “)”

Three Months Ended September 28, 2019
Common StockAdditional Paid-In CapitalAccumulatedOther Comprehensive IncomeTotal Stockholders' Equity
SharesAmountRetained Earnings
Balance as of June 29, 201976.7$0.1$1,360.8$129.1$7.1$1,497.1
Net income———47.6—47.6
Other comprehensive income————0.10.1
Issuance of shares pursuant to equity plans, net of tax withholdings0.5—————
Stock-based compensation——16.5——16.5

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

Table 6 after “)”

Three Months Ended September 29, 2018
Non-Controlling Interest Redeemable Convertible Series A Preferred Stock
Common StockAdditional Paid-In CapitalAccumulatedOther Comprehensive IncomeTotal Stockholders' Equity
SharesAmountSharesAmountRetained Earnings
Balance as of June 30, 2018—$35.862.8$0.1$753.2$166.4$6.4$926.1
Net income—————47.4—47.4
Other comprehensive income——————0.50.5
Declared dividend for preferred stock—————(0.2)—(0.2)

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

Table 7 after “(Unaudited)”

Three Months Ended
September 28, 2019September 29, 2018
OPERATING ACTIVITIES:
Net income$47.6$47.4
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation expense31.619.7
Stock-based compensation16.710.8
Unrealized loss on derivative liability—2.1

First 8 of 44 rows. The download has all of them.

Table 8 after “):”

Three Months Ended
September 28, 2019September 29, 2018
Basic Earnings per Common Share
Net income$47.6$47.4
Less: Cumulative dividends on Series A Preferred Stock—(0.2)
Less: Earnings allocated to Series A Preferred Stock—(1.1)
Net income attributable to common stockholders - Basic$47.6$46.1
Weighted average common shares outstanding including Series A Preferred Stock76.964.6

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

Table 9 after “The total fair value of consideration given in connection with the acquisition of Oclaro consisted of the following:”

SharesPer ShareTotal Consideration(in millions)
Cash paid for outstanding Oclaro common stock$964.8
Lumentum common shares issued to Oclaro stockholders10,941,436$41.80457.4
Replacement equity awards for Oclaro equity awards2.7
Total consideration$1,424.9

Table 10 after “):”

As Previously Reported on June 29, 2019
Cash and cash equivalents$345.0
Accounts receivable, net68.0
Inventories155.0
Prepayments and other current assets33.7
Property, plant and equipment, net134.7
Intangibles444.0
Deferred income tax asset42.6

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

Table 11 after “):”

Amortized CostGross Unrealized GainsGross Unrealized LossesFair Value
September 28, 2019:
Cash$213.8$—$—$213.8
Cash equivalents:
Certificates of deposit5.5——5.5
Commercial paper82.3——82.3
Money market funds229.7——229.7
U.S. Agency securities1.2——1.2

First 8 of 37 rows. The download has all of them.

Table 12 after “):”

Less than 12 months12 Months or GreaterTotal
Fair ValueUnrealized LossesFair ValueUnrealized LossesFair ValueUnrealized Losses
September 28, 2019:
Commercial paper$3.8$—$—$—$3.8$—
Asset-backed securities0.7—2.1—2.8—
Corporate debt securities5.2—6.9—12.1—
Foreign government bonds——2.2—2.2—
U.S. government bonds6.9———6.9—

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

Table 13 after “):”

September 28, 2019June 29, 2019
Amortized CostFair ValueAmortized CostFair Value
Due in 1 year$151.9$152.2$178.9$179.1
Due in 1 year through 5 years133.3134.2148.1149.0
Due in 5 years through 10 years4.54.56.06.0
Due after 10 years1.01.01.81.8
$290.7$291.9$334.8$335.9

Table 14 after “):”

Level 1Level 2Level 3Total
September 28, 2019: (1)
Assets:
Cash equivalents:
Certificates of deposit$—$5.5$—$5.5
Commercial paper—82.3—82.3
Money market funds229.7——229.7
U.S. Agency securities—1.2—1.2

First 8 of 21 rows. The download has all of them.

Table 15 after “(Unaudited)”

Level 1Level 2Level 3Total
June 29, 2019: (1)
Assets:
Cash equivalents:
Commercial paper$—$37.4$—$37.4
Money market funds168.1——168.1
U.S. Treasury securities13.3——13.3
Short-term investments:

First 8 of 21 rows. The download has all of them.

Table 16 after “):”

September 28, 2019June 29, 2019
Raw materials and purchased parts$73.0$78.3
Work in process62.172.5
Finished goods67.178.0
Inventories (1)$202.2$228.8

Table 17 after “):”

September 28, 2019June 29, 2019
Prepayments$37.2$32.4
Vendor receivable34.236.3
Value added tax receivable12.611.9
Advances to contract manufacturers6.18.7
Assets held-for-sale4.94.9
Other current assets2.33.3
Prepayments and other current assets$97.3$97.5

Table 18 after “):”

September 28, 2019
Operating lease right-of-use assets$91.5
Less: accumulated amortization(3.3)
Operating lease right-of-use assets, net$88.2

Table 19 after “):”

September 28, 2019June 29, 2019
Land$44.2$44.2
Buildings and improvement106.5103.7
Machinery and equipment (1)510.2500.5
Computer equipment and software25.325.4
Furniture and fixtures5.14.9
Leasehold improvements30.931.2
Finance lease right-of-use assets (1)28.416.0

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

Table 20 after “:”

September 28, 2019June 29, 2019
Restructuring accrual and related charges (1)$10.7$14.6
Warranty accrual (2)7.07.5
Deferred revenue and customer deposits2.52.9
Finance lease liabilities, current (3)9.70.4
Income tax payable (4)17.08.7
Other current liabilities5.75.1
Other current liabilities$52.6$39.2

Table 21 after “):”

September 28, 2019June 29, 2019
Asset retirement obligation$4.5$4.5
Pension and related accrual (1)8.17.9
Deferred rent—2.2
Unrecognized tax benefit18.818.7
Finance lease liabilities, non-current0.4—
Other non-current liabilities0.30.4
Other non-current liabilities$32.1$33.7

Table 22 after “The components of lease costs, lease term, and discount rate are as follows:”

Three Months Ended
September 28, 2019
Finance lease cost (in millions):
Amortization of right-of-use assets$3.9
Interest0.1
Operating lease cost4.0
Variable lease cost0.6
Short-term lease cost0.5

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

Table 23 after “(Unaudited)”

Fiscal YearsOperating Leases (1)Finance LeasesTotal
Remainder of 2020$10.6$7.5$18.1
202113.52.716.2
202212.5—12.5
202311.3—11.3
20249.6—9.6
Thereafter30.9—30.9
Total minimum lease payments$88.4$10.2$98.6

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

Table 24 after “):”

Fiscal YearsOperating LeasesFinance LeasesTotal
2020$13.9$0.8$14.7
202112.1—12.1
202211.2—11.2
202311.3—11.3
20249.8—9.8
Thereafter31.7—31.7
Total minimum operating lease payments$90.0$0.8$90.8

Table 25 after “:”

Optical CommunicationsCommercial LasersTotal
Balance as of September 28, 2019$363.5$5.4$368.9

Table 26 after “(Unaudited)”

IntangibleFair value(in millions)Weighted average amortization period(in years)
Acquired developed technologies$182.04.4 years
Customer relationships145.08 years
In-process research and development94.0n/a
Order backlog22.01 year
Total intangible assets$443.0

Table 27 after “):”

September 28, 2019Gross Carrying AmountAccumulated AmortizationNet
Acquired developed technologies$287.5$(136.2)$151.3
Customer relationships149.3(18.5)130.8
In-process research and development94.0—94.0
Order backlog22.0(21.5)0.5
Other intangibles2.7(2.7)—
Total intangible assets$555.5$(178.9)$376.6

Table 28 after “):”

June 29, 2019Gross Carrying AmountAccumulated AmortizationNet
Acquired developed technologies$287.5$(125.2)$162.3
Customer relationships149.3(12.3)137.0
In-process research and development94.0—94.0
Order backlog22.0(19.9)2.1
Other intangibles2.7(2.7)—
Total intangible assets$555.5$(160.1)$395.4

Table 29 after “):”

Three Months Ended
September 28, 2019September 29, 2018
Cost of sales$12.5$0.8
Selling, general and administrative6.3—
Total amortization of intangibles$18.8$0.8

Table 30 after “(in millions):”

Fiscal Years
Remainder of 2020$52.2
202166.7
202264.1
202340.6
202421.8
Thereafter37.2
Total future amortization$282.6

Table 31 after “):”

Liability component:September 28, 2019June 29, 2019
Principal$450.0$450.0
Unamortized debt discount(93.5)(98.1)
Net carrying amount of the liability component$356.5$351.9

Table 32 after “:”

Three Months Ended
September 28, 2019September 29, 2018
Contractual interest expense$0.3$0.3
Amortization of the debt discount4.64.3
Total interest expense$4.9$4.6
Effective interest rate on the liability component5.4%5.4%

Table 33 after “:”

September 28, 2019June 29, 2019
Principal$497.5$500.0
Repayment of principal—(2.5)
Unamortized value of the debt issuance costs(8.2)(8.5)
Net carrying value$489.3$489.0
Term loan, current$6.2$5.0
Term loan, non-current$483.1$484.0

Table 34 after “:”

Three Months Ended
September 28, 2019September 29, 2018
Contractual interest expense$6.1$0.4
Amortization of the debt issuance costs0.3—
Total interest expense$6.4$0.4

Table 35 after “):”

Three Months Ended
September 28, 2019September 29, 2018
Service cost$0.3$0.2
Expected return on plan assets(0.1)(0.1)
Amortization of net (gain) loss0.10.1
Net periodic pension cost$0.3$0.2

Table 36 after “):”

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 tax (3)Total
Beginning balance as of June 29, 2019$9.7$(3.5)$0.9$7.1
Other comprehensive income (4)——0.10.1
Ending balance as of September 28, 2019$9.7$(3.5)$1.0$7.2
Beginning balance as of June 30, 2018$10.3$(2.3)$(1.6)$6.4
Other comprehensive income (4)0.1—0.40.5
Ending balance as of September 29, 2018$10.4$(2.3)$(1.2)$6.9

Table 37 after “):”

Three Months Ended
September 28, 2019September 29, 2018
Balance as of beginning of period$14.6$1.9
Charges1.31.3
Payments(5.2)(1.6)
Balance as of end of period$10.7$1.6

Table 38 after “:”

Three Months Ended
September 28, 2019September 29, 2018
Cost of sales$4.2$3.3
Research and development3.82.8
Selling, general and administrative8.74.7
Total stock-based compensation$16.7$10.8

Table 39 after “:”

Three Months Ended
September 28, 2019September 29, 2018
Income tax benefit associated with stock-based compensation$2.8$2.9

Table 40 after “:”

Stock OptionsRestricted Stock UnitsRestricted Stock AwardsPerformance Stock Units
Number of SharesWeighted-Average Exercise Price per ShareNumber of SharesWeighted-Average Grant Date Fair Value per ShareNumber of SharesWeighted-Average Grant Date Fair Value per ShareNumber of SharesWeighted-Average Grant Date Fair Value per Share
Balance as of June 29, 2019—$38.82.2$52.4—$32.50.2$56.0
Granted——0.958.5——0.258.7
Vested/Exercised—31.5(0.5)54.3—32.5(0.1)56.4
Canceled—29.4(0.1)51.8———57.3
Balance as of September 28, 2019—$41.32.5$54.4—$—0.3$57.3

Table 41 after “:”

Awards Available for Grant
Balance as of June 29, 20194.7
Granted(1.1)
Canceled0.1
Balance as of September 28, 20193.7

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

September 28, 2019September 29, 2018
Expected term (years)0.50.5
Expected volatility60.1%58.8%
Risk-free interest rate2.47%2.02%
Dividend yield—%—%

Table 43 after “:”

Fiscal Years
Remainder of 2020$31.0
202127.6
202227.3
202327.1
202426.9
Thereafter497.1
Total term loan payments$637.0

Table 44 after “:”

Fiscal Years
Remainder of 2020$0.5
20211.1
20221.1
20231.1
2024451.2
Thereafter—
Total 2024 Notes payments$455.0

Table 45 after “):”

Three Months Ended
September 28, 2019September 29, 2018
Balance as of beginning of period$7.5$6.6
Provision for warranty1.21.2
Utilization of reserve(1.7)(1.2)
Balance as of end of period$7.0$6.6

Table 46 after “:”

Three Months Ended
September 28, 2019September 29, 2018
Net revenue:
OpComms$416.1$310.1
Lasers33.844.0
Net revenue$449.9$354.1
Gross profit:
OpComms$191.9$124.9

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

Table 47 after “):”

Three Months Ended
September 28, 2019September 29, 2018
OpComms:
Telecom and Datacom$248.155.2%$177.150.0%
Consumer and Industrial168.037.3%133.037.6%
Total OpComms$416.192.5%$310.187.6%
Lasers33.87.5%44.012.4%
Total Revenue$449.9$354.1

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

Three Months Ended
September 28, 2019September 29, 2018
Amount% of TotalAmount% of Total
Americas:
United States$36.98.3%$21.96.2%
Mexico28.96.456.315.9
Other Americas1.10.20.90.3
Total Americas$66.914.9%$79.122.4%

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

Table 49 after “):”

Less than 1 year1-2 yearsGreater than 2 yearsTotal
Performance obligations$414.9$—$—$414.9

Table 50 after “):”

Contract balancesBalance sheet locationSeptember 28, 2019June 29, 2019ChangePercentage Change
Accounts receivable, netAccounts receivable, net$292.8$238.0$54.823.0%
Deferred revenue and customer depositsOther current liabilities$2.5$2.9$(0.4)(13.8)%

Table 51 after “:”

September 28, 2019June 29, 2019
Property, plant and equipment, net
United States$155.9$156.2
Thailand144.1157.1
China51.933.5
Japan28.328.3
Other countries56.558.2
Total long-lived assets$436.7$433.3

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

Three Months Ended
September 28, 2019September 29, 2018
Segment net revenue:
OpComms92.5%87.6%
Lasers7.512.4
Net revenue100.0100.0
Cost of sales59.964.2
Amortization of acquired developed technologies2.80.2

First 8 of 21 rows. The download has all of them.

Table 53 after “):”

Three Months Ended
September 28, 2019September 29, 2018ChangePercentage Change
Segment net revenue:
OpComms$416.1$310.1$106.034.2%
Lasers33.844.0(10.2)(23.2)
Net revenue$449.9$354.1$95.827.1%
Gross profit$167.7$126.0$41.733.1%
Gross margin37.3%35.6%

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

Table 54 after “):”

Three Months Ended
September 28, 2019September 29, 2018
Amount% of TotalAmount% of Total
Americas:
United States$36.98.3%$21.96.2%
Mexico28.96.456.315.9
Other Americas1.10.20.90.3
Total Americas$66.914.9%$79.122.4%

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

Table 55 after “):”

Three Months Ended
Gross ProfitGross Margin
September 28, 2019September 29, 2018September 28, 2019September 29, 2018
OpComms$191.9$124.946.1%40.3%
Lasers14.217.742.0%40.2%
Segment total$206.1$142.645.8%40.3%
Unallocated corporate items:
Stock-based compensation(4.2)(3.3)

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

Table 56 after “):”

Three Months Ended
September 28, 2019September 29, 2018
Foreign exchange gains (losses), net$1.1$(0.3)
Interest income4.02.7
Other income (expense), net(0.1)0.3
Total other income (expense), net$5.0$2.7

Table 57 after “Provision for Income Taxes”

(in millions)Three Months Ended
September 28, 2019September 29, 2018
Provision for income taxes$5.8$5.2

Table 58 after “):”

Payments due by period
TotalLess than 1 year1 - 3 years3 - 5 yearsMore than 5 years
Contractual Obligations
Acquisition contingencies (1)$3.0$3.0$—$—$—
Asset retirement obligations5.51.00.81.22.5
Finance lease liabilities, including imputed interest10.29.80.4——
Operating lease liabilities, including imputed interest (2)88.414.125.719.429.2
Pension plan contributions (3)0.50.5———

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

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

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.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 September 28, 2019 formatted in Inline XBRL (eXtensible Business Reporting Language): (i) Condensed Consolidated Statements of Operations for the fiscal quarters ended September 28, 2019 and September 29, 2018; (ii) Condensed Consolidated Statements of Comprehensive Income for the fiscal quarters ended September 28, 2019 and September 29, 2018; (iii) Condensed Consolidated Balance Sheets as of September 28, 2019 and June 29, 2019; (iv) Condensed Consolidated Statements of Cash Flows for the fiscal quarters ended September 28, 2019 and September 29, 2018, 2017; (v) Condensed Consolidated Statements of Redeemable Convertible Preferred Stock and Stockholders’ Equity for the fiscal quarters ended September 28, 2019 and September 29, 2018; and (vi) Notes to the Consolidated Financial Statements.X
104Cover Page Interactive Data File, formatted in Inline XBRL (included in Exhibit 101).X