Fabrinet [FN]
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, so the model is reproducible and every number traceable.
Per known-silent-failures.md §1–§3, had a workbook been built: no defined name matching
^[A-Za-z]{1,3}\d{1,7}$ (rev_fy27, not rev27; vol_252d, not VOL252 — the LITE memo lost a
volatility-derived risk ratio to exactly that); open by absolute path and assert the filename matches the
ticker before reading a cell; and treat the model as unverified until Excel has opened, computed and
saved it.
| Item | Source | Why |
|---|---|---|
| Annual revenue, gross profit, SG&A, operating income | 10-K FY2025 audited statements | AV's sellingGeneralAndAdministrative runs understated-to-zero (sibling-agent finding); the opex bridge must come from the filing |
| Quarterly revenue, gross profit, operating income, 81 periods | AV INCOME_STATEMENT (normalized) |
av_vs_edgar: VERIFIED, 6 periods compared, 0 DISAGREE, re-run after the 52/53-week fiscal-filer fix. FN is a 52/53-week filer, so this is exactly the case the earlier defect would have skipped |
| Operating margin | operatingIncome / totalRevenue |
AV's ebit field is not operating income — see defects |
| D&A | AV CASH_FLOW |
|
| EBITDA | computed: operating income + |cash-flow D&A| | AV's ebitda field is unusable per the brief |
| Receivables, inventory, cash | AV BALANCE_SHEET, cross-checked to the 10-Q |
|
| Customer / receivables concentration | EDGAR 10-K FY2025 Note 20 | AV does not carry it; this is the highest-value disclosure on the name |
| Debt | 10-K income statement (interest expense = zero) + AV | Confirms AV's longTermDebt: None is genuinely nil, not a silent zero |
| Guidance, segment detail | transcript, 2026-05-04 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 split-basis class, which passes the EPS cross-check |
| FY2025 (Jun 27) | FY2024 (Jun 28) | FY2023 (Jun 30) | |
|---|---|---|---|
| Revenues | 3,419,327 | 2,882,967 | 2,645,237 |
| Cost of revenues | (3,005,978) | (2,526,849) | (2,308,964) |
| Gross profit | 413,349 | 356,118 | 336,273 |
| Gross margin | 12.09% | 12.35% | 12.71% |
| SG&A | (87,466) | (78,481) | (77,673) |
| SG&A % | 2.56% | 2.72% | 2.94% |
| Restructuring and other | (1,436) | (32) | (6,896) |
| Operating income | 324,447 | 277,605 | 251,704 |
| Operating margin | 9.49% | 9.63% | 9.52% |
| Interest income | 40,162 | 33,204 | 11,xxx |
| Interest expense | — | (124) | (1,472) |
| Income before tax | 355,180 | 311,354 | 260,096 |
| Income tax | (22,653) | (15,173) | (12,183) |
| Effective tax rate | 6.38% | 4.87% | 4.68% |
| Net income | 332,527 | 296,181 | 247,913 |
FN has no R&D line. Customers own the designs. This is a structural feature and it is why a 12% gross margin still supports a 9.5% operating margin.
| Period | Revenue | Gross % | Op income | Op % | AR | DSO (same-qtr) | Inventory | DIO |
|---|---|---|---|---|---|---|---|---|
| 2025-03-28 | 871.8 | 11.7 | 78.9 | 9.0 | 658.3 | 68.9d | 531.3 | 63.0d |
| 2025-06-27 | 909.7 | 12.2 | 89.1 | 9.8 | 758.9 | 76.1d | 581.0 | 66.4d |
| 2025-09-26 | 978.1 | 11.9 | 94.2 | 9.6 | 706.9 | 66.0d | 722.2 | 76.5d |
| 2025-12-26 | 1,132.9 | 12.2 | 114.4 | 10.1 | 801.7 | 64.6d | 798.9 | 73.3d |
| 2026-03-27 | 1,214.3 | 11.6 | 116.4 | 9.6 | 908.5 | 68.3d | 876.0 | 74.5d |
TTM: revenue $4,235.0m, gross margin 11.96%, operating income $414.0m (9.78%), D&A $60.6m, EBITDA $474.6m (11.21%). Prior-year TTM revenue $3,262.5m → +29.8%.
Use same-quarter DSO, not TTM-basis DSO. On this name the TTM measure reads 78.3d against 73.6d a year ago and AR growing 8.2pp faster than revenue — which mimics the AAOI signature and is an artifact of a 39% revenue acceleration against a trailing denominator. The same-quarter series (68.3d vs 68.9d vs 72.8d) is flat to improving. Applying the same correction to AAOI does not clear it (180.5d vs 156.4d vs 129.7d), which is what establishes the corrected measure as discriminating rather than exculpatory.
| Cash and equivalents | 356.6 |
| Short-term investments | 588.7 |
| Accounts receivable, net | 908.5 |
| Inventory | 876.0 |
| Goodwill | none |
| Intangibles | 2.4 |
| Total assets | 3,509.0 |
| Total debt | 1.5 |
| Finance lease obligations | 4.4 |
| Net cash | +943.8 |
| Total shareholders' equity | 2,304.7 |
| Shares outstanding | 36.217m |
Lease convention stated per §9.7: operating leases excluded from net cash/debt across all three names in this cluster so the comparison is internally consistent. FN's are immaterial.
| Q4FY26 revenue | $1,250–1,290m, midpoint $1,270m (+40% YoY) |
| Q4FY26 gross margin | "dynamics similar to Q3" → ~11.6–12.0% |
| Q4FY26 non-GAAP EPS | $3.72–3.87 |
| FY2026 revenue | $4,595m (+34.4%) = 9M $3,325.3m + Q4 midpoint |
| FY2027 | "new customer programs... contribute more meaningfully in fiscal 2027" — no number given |
| Q3FY26 mix | Optical Communications $889m (+35%); telecom $628m (+55%); DCI modules $197m (+90%); datacom ≈$261m residual |
| HPC milestone | $150m/quarter, "probably a quarter away" |
| Buyback | $169m remaining authorisation; "no meaningful number of shares" repurchased in Q3 |
m_EBIT,T ≤ m_gross,T as a hard model
assertion that raises, not a flag. This is the check the screen lacked, which is how a 14.4% terminal
margin was applied to a 12.09% gross-margin business.| Field | Do not use | Use instead |
|---|---|---|
Screen terminal_margin |
0.144 — above FN's gross margin | 0.098, own 3-year actuals, bridged |
Screen exit_multiple / peer_n |
22.7x from 33 "growth-matched" peers | 14.0x derived, sanity-banded on 4 real EMS comparators |
Screen valuation_margin_pp |
+2.5pp / PASS — an output of an impossible input | −1.47pp, PASS WITH ARGUMENT |
AV ebit |
$448.6m TTM | $414.0m = operatingIncome. AV overstates by 8.4%, 0.82pp of margin |
AV ebitda |
any value | operating income + |cash-flow D&A| |
AV sellingGeneralAndAdministrative |
any value | 10-K: $87,466k FY2025 (2.56%) |
AV EARNINGS_ESTIMATES |
empty array read as "no estimates exist" | INDETERMINATE; substitute filed guidance and declare it |
| TTM-basis DSO | 78.3d vs 73.6d — reads as the AAOI tell | same-quarter DSO: 68.3d vs 68.9d, flat |
| Options chain | any inferred IV | UNIDENTIFIED — no contracts exist within ±10% of spot beyond 350 days |