← Filings of LITE

Tables in the 10-Q of Lumentum Holdings Inc.

50 tables with numbers, filed Feb 6, 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 OF CONTENTS
	Page
PART I - FINANCIAL INFORMATION
	Item 1.	Financial Statements (Unaudited)
		Condensed Consolidated Statements of Operations for the Three Months and Six Months Ended December 30, 2017 and December 31, 2016	2
		Condensed Consolidated Statements of Comprehensive Income (Loss) for the Three Months and Six Months Ended December 30, 2017 and December 31, 2016	3
		Condensed Consolidated Balance Sheets as of December 30, 2017 and July 1, 2017	4
		Condensed Consolidated Statements of Cash Flows for the Six Months Ended December 30, 2017 and December 31, 2016	5

	Three Months Ended	Six Months Ended
	December 30, 2017	December 31, 2016		December 30, 2017	December 31, 2016
Net revenue	$404.6		$265.0		$647.8	$523.1
Cost of sales	232.7		176.3		406.6	351.0
Amortization of acquired developed technologies	0.8		1.7		1.6	3.4
Gross profit	171.1		87.0		239.6	168.7
Operating expenses:
Research and development	43.8		38.7		80.1	75.6

	December 30, 2017	July 1, 2017
ASSETS
Current assets:
Cash and cash equivalents	$202.1		$272.9
Short-term investments	422.4		282.4
Accounts receivable, net	222.1		166.3
Inventories	147.3		145.2
Prepayments and other current assets	59.9		63.5

	Foreign currency translation adjustments, net of tax	Defined benefit obligation, net of tax		Unrealized gain (loss) on available-for-sale securities, net of tax	Total
Beginning balance as of July 1, 2017	$10.5		$(3.1)		$—	$7.4
Other comprehensive income (loss)	1.9		—		(0.1)	1.8
Ending balance as of September 30, 2017	12.4		(3.1)		(0.1)	9.2
Other comprehensive income (loss)	0.1		—		(0.6)	(0.5)
Ending balance as of December 30, 2017	$12.5		$(3.1)		$(0.7)	$8.7

	December 30, 2017	July 1, 2017
Finished goods	$99.5		$71.7
Work in process	26.5		49.4
Raw materials and purchased parts	21.3		24.1
Inventories	$147.3		$145.2

	December 30, 2017	July 1, 2017
Capitalized manufacturing overhead	$26.3		$30.1
Prepayments	6.4		12.3
Advances to contract manufacturers	15.1		10.5
Other current assets	12.1		10.6
Prepayments and other current assets	$59.9		$63.5

	December 30, 2017	July 1, 2017
Land	$10.6		$10.6
Buildings and improvement	44.7		37.3
Machinery and equipment (1)	526.3		461.1
Furniture and fixtures and software	42.9		35.8
Leasehold improvements	29.9		30.5
Construction in progress	66.0		84.6
	720.4		659.9

	December 30, 2017	July 1, 2017
Warranty accrual (3)	$9.9		$9.7
Restructuring accrual and related charges (2)	0.4		3.8
Deferred revenue and customer deposits	6.6		6.9
Capital lease obligation (1)	9.1		—
Other current liabilities	3.4		1.5
Other current liabilities	$29.4		$21.9

	December 30, 2017	July 1, 2017
Asset retirement obligation	$2.5		$2.5
Pension and related accrual	4.3		3.9
Deferred rent	3.3		3.3
Unrecognized tax benefit	7.2		10.5
Capital lease obligation (1)	3.1		—
Other non-current liabilities	4.0		4.8
Other non-current liabilities	$24.4		$25.0

	December 30, 2017	July 1, 2017
Cash and cash equivalents:
Cash	$133.2		$201.3
Certificates of deposit	6.2		52.1
Commercial paper	41.9		14.7
Corporate debt securities	2.7		—
Money market funds	3.0		4.8
U.S. Treasury	13.5		—

	Six Months Ended
	December 30, 2017	December 31, 2016
OPERATING ACTIVITIES:
Net income	$211.9		$8.4
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation expense	34.9		25.0
Stock-based compensation	24.1		16.7
Unrealized (gain) loss on derivative liability	(12.1)		17.9

	Three Months Ended	Six Months Ended
	December 30, 2017	December 31, 2016		December 30, 2017	December 31, 2016
Numerator:
Net income	$204.8		$11.8		$211.9	$8.4
Less: Cumulative dividends on Series A Preferred Stock (a)	(0.3)		(0.2)		(0.5)	(0.4)
Net income attributable to common stockholders - basic	$204.5		$11.6		$211.4	$8.0
Net income attributable to common stockholders - diluted	$204.8		$11.8		$211.9	$8.0
Denominator:

	As of December 30, 2017
	Amortized Cost	Fair Value
Due in 1 year	$184.1		$184.0
Due in 1 year through 5 years	226.1		225.4
Due in 5 years through 10 years	4.5		4.5
Due after 10 years	8.4		8.5
	$423.1		$422.4

Liability component:	December 30, 2017	July 1, 2017
Principal	$450.0		$450.0
Unamortized debt discount	(124.3)		(132.5)
Net carrying amount of the liability component	$325.7		$317.5

	As of December 30, 2017
	AmortizedCost	GrossUnrealizedGains		GrossUnrealizedLosses	Fair Value
Certificates of deposit	$23.2		$—		$—	$23.2
Commercial paper	35.3		—		—	35.3
Asset-backed securities	89.1		—		(0.1)	89.0
Corporate debt securities	263.1		0.1		(0.7)	262.5
Municipal bonds	5.8		—		—	5.8
Mortgage-backed securities	1.0		—		—	1.0

	As of July 1, 2017
	AmortizedCost	GrossUnrealizedGains		GrossUnrealizedLosses	Fair Value
Certificates of deposit	$202.1		$—		$—	$202.1
Asset-backed securities	26.1		—		—	26.1
Corporate debt securities	46.4		—		—	46.4
Municipal bonds	4.9		—		—	4.9
Foreign government bonds	1.0		—		—	1.0
U.S. Treasury	1.9		—		—	1.9

	As of December 30, 2017
	Level 1	Level 2		Level 3	Total
Assets:
Cash equivalents:
Certificates of deposit	$—		$6.2		$—	$6.2
Commercial paper	—		41.9		—	41.9
Corporate debt securities	—		2.7		—	2.7
Money market funds	3.0		—		—	3.0

	December 30, 2017
(in millions, except percentages)	Three Months Ended	Six Months Ended
Contractual interest expense	$0.3		$0.6
Amortization of the debt discount	4.1		8.2
Total interest expense	$4.4		$8.8
Effective interest rate on the liability component	5.4%		5.4%

	December 30, 2017	July 1, 2017
Stock price	$48.90		$57.05
Conversion price	$24.63		$24.63
Expected term (years)	2.61		3.11
Expected annual volatility	50.0%		47.5%
Risk-free rate	1.95%		1.57%
Preferred yield	7.97%		7.56%

	Optical Communications	Commercial Lasers		Total
Balance as of beginning of period	$5.9		$5.5		$11.4
Currency translation	0.3		(0.1)		0.2
Balance as of end of period	$6.2		$5.4		$11.6

As of December 30, 2017	Gross Carrying Amount	Accumulated Amortization		Net
Acquired developed technology	$105.6		$(96.8)		$8.8
Other	9.4		(9.4)		—
Total Intangibles	$115.0		$(106.2)		$8.8

Fiscal Years
Remainder of 2018	$1.6
2019	3.0
2020	2.9
Thereafter	1.3
Total amortization	$8.8

	Restricted Stock Units	Restricted Stock Awards		Performance Stock Units
	Number of Shares	Weighted-Average Grant Date Fair Value per Share		Number of Shares	Weighted-Average Grant Date Fair Value per Share	Number of Shares		Weighted-Average Grant Date Fair Value per Share
Unvested balance as of beginning of period	1.9		$28.04		0.3		$32.51		—	$—
Granted	1.0		53.13		—		—		0.1	52.00
Exercised / Vested	(0.7)		26.23		(0.1)		32.51		—	—
Canceled	(0.2)		38.64		—		—		—	—
Unvested balance as of end of period	2.0		$37.56		0.2		$32.51		0.1	$52.00

	Awards Available for Grant
Balance as of beginning of period	6.6
Granted	(1.1)
Canceled	0.2
Balance as of end of period	5.7

Tables in the 10-Q of Lumentum Holdings Inc.

Table 1 after “Table of Contents”

Table 2 after “(Unaudited)”

Table 3 after “(Unaudited)”

Table 4 after “(Unaudited)”

Table 5 after “(Unaudited)”

Table 6 after “):”

Table 7 after “):”

Table 8 after “):”

Table 9 after “):”

Table 10 after “):”

Table 11 after “:”

Table 12 after “):”

Table 13 after “):”

Table 14 after “:”

Table 15 after “) as of July 1, 2017:”

Table 16 after “):”

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

Table 18 after “):”

Table 19 after “:”

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

Table 21 after “The following table summarizes the assumptions used to determine the fair value of the embedded derivative for Series A Preferred Stock:”

Table 22 after “:”

Table 23 after “):”

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

Table 25 after “):”

Table 26 after “(in millions):”

Table 27 after “):”

Table 28 after “:”

Table 29 after “:”

Table 30 after “:”

Table 31 after “were as follows:”

Table 32 after “):”

Table 33 after “):”

Table 34 after “:”

Table 35 after “):”

Table 36 after “:”

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

Table 38 after “:”

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

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

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

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

Table 43 after “):”

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

Table 45 after “):”

Table 46 after “):”

Table 47 after “):”

Table 48 after “(in millions)”

Table 49 after “):”

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

Fiscal Years
Remainder of 2018	$5.6
2019	11.3
2020	8.5
2021	4.7
2022	3.1
Thereafter	4.0
Total minimum operating lease payments	$37.2

Fiscal Years
Remainder of 2018	$7.0
2019	7.5
2020	0.4
Thereafter	—
Total minimum capital lease payments	$14.9
Less: amount representing interest	$(0.4)
Present value of capital lease obligation	$14.5

	As of
	December 30, 2017	July 1, 2017
Property, Plant and Equipment, net
United States	$98.4		$88.2
China	80.7		82.5
Thailand	87.3		85.3
Other countries	34.9		17.5
Total long-lived assets	$301.3		$273.5

				Gross Margin		Gross Margin
	Three Months Ended	Three Months Ended		Six Months Ended	Six Months Ended
	December 30, 2017	December 31, 2016		December 30, 2017	December 31, 2016	December 30, 2017		December 31, 2016	December 30, 2017		December 31, 2016
OpComms	$161.9		$86.7		45.0%		36.6%		$234.0			$157.7	41.2%	34.7%
Lasers	19.9		11.2		44.7%		39.4%		30.5			28.4	38.2%	41.6%
Segment total	$181.8		$97.9		44.9%		36.9%		$264.5			$186.1	40.8%	35.6%
Unallocated corporate items (1)	(10.7)		(10.9)					(24.9)		(17.4)
Total	$171.1		$87.0		42.3%		32.8%		$239.6			$168.7	37.0%	32.3%

	Payments due by period
	Total	Less than 1 year		1 - 3 years	3 - 5 years	More than 5 years
Contractual Obligations
Asset retirement obligations	$2.8		$0.3		$0.4		$0.5	$1.6
Purchase obligations (1)	187.4		179.1		8.3		—	—
Operating lease obligations (1)	37.2		13.8		14.5		6.6	2.3
Capital lease obligation (1)	14.9		11.7		3.2		—	—
Pension and post-retirement benefit payments	4.3		0.5		0.2		0.2	3.4

		Incorporated by Reference			Filed
Exhibit No.	Exhibit Description	Form	Exhibit	Filing Date	Herewith
31.1	Certification 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.2	Certification 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
101.INS	XBRL Instance				X
101.SCH	XBRL Taxonomy Extension Schema				X