Lumentum Holdings [LITE]
No .xlsx was produced this run (time-boxed; the brief's priority order puts accounting-quality and valuation work above model artefacts). These notes carry every figure the model would contain with its source.
Per known-silent-failures.md §1, had a workbook been built: no defined name matching
^[A-Za-z]{1,3}\d{1,7}$. This is not hypothetical on this ticker — the record shows a prior LITE
memo losing its volatility-derived risk ratio and its conversion trigger because the defined name
VOL252 resolved as cell VOL252 and returned 0, silently. Use vol_252d, rev_fy27. And §2: the same
prior LITE memo was one of three confirmations that concurrent agents sharing one Excel instance return
another workbook's numbers as "verification" — open by absolute path and assert the filename matches the
ticker before reading a cell.
| Item | Source | Why |
|---|---|---|
| Annual revenue, segment split, opex | 10-K FY2025 audited statements | AV's FY2024 quarterly series is corrupted (see defects); AV's sellingGeneralAndAdministrative runs understated-to-zero |
| Quarterly revenue, gross profit, operating income, FY2025 onward only | AV INCOME_STATEMENT (normalized) |
FY2025 quarters sum to $1,645.0m = the filed FY2025 figure exactly; FY2026 9M ties to the 10-Q. Do not use AV for FY2024 or earlier |
| Operating margin | operatingIncome / totalRevenue |
AV's ebit field is not operating income — 18.5% high on this name |
| D&A | AV CASH_FLOW |
|
| EBITDA | computed: operating income + |cash-flow D&A| | AV's ebitda field unusable |
| Share count | 10-Q cover page + convert note + preferred note + guided count | AV returns 96.2m against a filed 77.8m; no vendor field carries the fully diluted figure |
| Net debt | 10-Q Note 9 debt table, hand-totalled | AV populates shortTermDebt $3,251.1m and currentLongTermDebt $3,238.6m for one borrowing — the §9.6 double-count |
| Customer / receivables concentration | EDGAR 10-K FY2025 and 10-Q Q3FY26 | AV does not carry it |
| Segment split | EDGAR 10-K FY2025 Note 17 — the last one that exists | Retired in Q1 FY2026 |
| Guidance, product-category split | transcript, 2026-05-05 CFO/CEO prepared remarks + Q&A | AV EARNINGS_ESTIMATES returns zero rows |
| Prices, volatility | Alpaca daily bars, adjustment=all, explicit start= |
§4: limit=N without start= returns zero bars |
| Splits | AV SPLITS — empty array, never split |
Rules out the §9.3 basis class |
| FY2023 | FY2024 | FY2025 | |
|---|---|---|---|
| Cloud & Networking revenue | 1,322.5 | 1,084.9 | 1,410.8 |
| Industrial Tech revenue | 444.5 | 274.3 | 234.2 |
| Total net revenue | 1,767.0 | 1,359.2 | 1,645.0 |
| Gross profit | 569.0 | 251.5 | 459.9 |
| Gross margin | 32.2% | 18.5% | 28.0% |
| R&D | 307.8 | 302.2 | 303.9 (18.5% of revenue) |
| SG&A | 348.8 | 310.7 | 348.2 (21.2%) |
| Restructuring | 28.1 | 72.6 | 22.8 |
| Gain on sale of facility | — | — | (34.9) — non-recurring, −2.1% of revenue |
| Operating margin | (6.5)% | (31.9)% | (10.9)% |
| Cloud & Networking segment profit | 313.2 | 124.5 | 264.5 |
| Industrial Tech segment profit | 152.7 | 25.1 | 12.1 |
Note the $34.9m Shenzhen facility gain sitting inside FY2025 operating expenses. It flattered the FY2025 GAAP operating margin by 2.1pp and is excluded from every forward figure here. It is a gain, not revenue, so it does not affect any growth rate — but it is exactly the class of item the 10x Genomics precedent (~$94m of settlements inside FY2025 revenue) exists to catch.
| Period | Revenue | Gross % | Op income | Op % | AR | DSO (same-qtr) | Inventory | DIO |
|---|---|---|---|---|---|---|---|---|
| 2024-09-30 | 336.9 | 23.1 | (82.4) | (24.5) | 198.5 | 53.8d | 403.3 | 142.1d |
| 2024-12-31 | 402.2 | 24.8 | (50.9) | (12.7) | 226.9 | 51.5d | 402.3 | 121.3d |
| 2025-03-29 | 425.2 | 28.8 | (65.4) | (15.4) | 255.7 | 54.9d | 422.9 | 127.5d |
| 2025-06-28 | 480.7 | 33.3 | (3.2) | (0.7) | 250.0 | 47.5d | 470.1 | 133.7d |
| 2025-09-27 | 533.8 | 34.0 | 15.0 | 2.8 | 307.0 | 52.5d | 531.6 | 137.7d |
| 2025-12-27 | 665.5 | 36.1 | 63.9 | 9.6 | 376.8 | 51.7d | 570.4 | 122.4d |
| 2026-03-28 | 808.4 | 44.2 | 175.6 | 21.7 | 452.5 | 51.1d | 632.8 | 127.9d |
TTM: revenue $2,488.4m, gross margin 37.71%, operating income $251.3m (10.10%), D&A $254.5m, EBITDA $505.8m (20.33%). Prior-year TTM: revenue $1,645.0m, operating income −$201.9m (−12.27%). YoY: revenue +69.0%; operating margin +22.4pp.
Sum check: FY2025 quarters = 336.9 + 402.2 + 425.2 + 480.7 = $1,645.0m = filed FY2025 exactly. FY2026 9M = 533.8 + 665.5 + 808.4 = $2,007.7m = the 10-Q. Both windows tie.
Use same-quarter DSO. 51.1d (Q3FY26) vs 54.9d vs 62.2d — falling 11.1 days in two years while revenue grew 140%. The TTM-basis measure reads 66.4d vs 63.4d and is the acceleration artifact documented in the FN file.
| Cash and equivalents | 2,617.8 |
| Short-term investments | 554.5 |
| Accounts receivable, net | 452.5 |
| Inventory | 632.8 |
| Goodwill | 1,066.3 |
| Acquired intangibles, net | 362.9 (future amortisation $360.4m total) |
| Total assets | 7,027.9 |
| Convertible notes, principal | 3,198.4 (carrying $3,183.4m; fair value $19,074.7m) |
| Term loans (SMBC, Japan) | 98.4 |
| Net debt | 124.5 |
| Total stockholders' equity | 2,973.4 |
| Common shares outstanding (cover, 2026-04-30) | 77.8m |
| Series A Convertible Preferred (NVIDIA) | 2.9m, $695.31/sh, 1:1 |
| Fully diluted (derived; company guides ~102m) | 102.10m |
Convert detail — model each series separately:
| Series | Principal | Conversion price | If-converted shares | Fair value |
|---|---|---|---|---|
| 2026 Notes (0.50%) | 468.7 | $99.29 | 4.721m | 3,328.0 |
| 2028 Notes | 861.0 | $131.03 | 6.571m | 4,617.2 |
| 2029 Notes | 603.7 | $69.54 | 8.681m | 6,262.3 |
| 2032 Notes (0.375%, issued 2025-09-08) | 1,265.0 | $187.77 | 6.737m | 4,867.2 |
| Total | 3,198.4 | 26.710m | 19,074.7 |
Less cash-settled principal equivalent (3,198.4 ÷ 602.23) = 5.311m → net settlement 21.40m shares.
$102.0m of 2032 Capped Call Options was purchased and economically offsets 2032 dilution up to an unextracted cap. Capped calls do not enter GAAP diluted EPS. Range: fully diluted 95.4m–102.1m; EV $57.6–61.6bn. The 102.1m figure is used because it ties to the company's guided count.
| Q4FY26 revenue | $960–1,010m, midpoint $985m — all-time record, +104% YoY |
| Q4FY26 non-GAAP operating margin | 35–36% |
| Q4FY26 non-GAAP EPS | $2.85–3.05, at a 16.5% non-GAAP tax rate |
| Q4FY26 diluted share count assumed | ~102 million |
| FY2026 revenue | $2,993m (+81.9%) = 9M $2,007.7m + Q4 midpoint |
| Q3FY26 product split | Components $533.3m (+77% YoY, +20% QoQ); Systems $275.1m (+121% YoY, +24% QoQ) |
| Q3FY26 quantified new products | Cloud transceivers +>$268.0m over 9M; OCS >$38.0m over 9M |
| Stated ambition | $2 billion quarterly revenue — no date attached |
shortTermDebt and currentLongTermDebt — AV populates both for the same borrowing.| Field | Do not use | Use instead |
|---|---|---|
| Screen record | INDETERMINATE, revenue_ttm $1,530.8m at 2025-03-29 (486d stale) |
$2,488.4m TTM to 2026-03-28. Screen understated revenue by 38.5% and dropped the name from the universe |
AV INCOME_STATEMENT, FY2024 quarters |
2023-12-31 duplicates 2024-06-30; 2024-03-31 duplicates 2024-09-30 | Filed annuals. AV FY2024 sums to $1,271.1m vs filed $1,359.2m (−6.5%); AV-derived 3y CAGR 11.0% vs filed 19.2% |
AV commonStockSharesOutstanding |
96.2m | 77.8m common (10-Q cover); 102.10m fully diluted |
AV shortTermDebt + currentLongTermDebt |
flat sum — double-counts ~$3.2bn | $3,198.4m principal from Note 9 |
AV ebit |
$297.7m TTM | $251.3m = operatingIncome. AV overstates 18.5%, 1.86pp of margin |
AV ebitda |
any value | operating income + |cash-flow D&A| |
AV EARNINGS_ESTIMATES |
empty array read as "no estimates exist" | INDETERMINATE; substitute filed guidance and declare it |
| TTM-basis DSO | 66.4d vs 63.4d | same-quarter: 51.1d vs 54.9d vs 62.2d, improving |
| Segment split, FY2026 onward | does not exist | Last disclosure FY2025; carry forward and mark unverifiable |
| Naive market cap | $46,853m on 77.8m shares | EV $61,613m on 102.10m diluted — a 31.5% difference |