Filing Flows › Companies › ELI Lilly › Analysis traps
ELI Lilly (LLY): analysis traps
Where its figures could mislead a reader, and what to check before taking them at face value · Data: Q3 2026, to Sep 30, 2026, filed Oct 29, 2026; rules v1.1
ELI Lilly (LLY): 0 rules of 10 triggered on the filings to Sep 30, 2026. 1 to review; 3 with insufficient data; 2 not applicable. Each is a question to verify, with the normal explanation that would produce the same figures.
Check these first
Low P/E at a cyclical peak = undervalued To review · confidence medium
Net income of $27.6B is at a high against a median of $6.2B over eight years; at 44.2× the market is not pricing it as cheap, but a multiple on this year's profit still understates the mid-cycle one (195.2×).
Every rule
A01 FCF growth = the business improved Not triggered confidence medium
Free cash flow rose $5.2B to $9.0B; working capital and lower capex explain 31% of it, so most of the gain is in operating cash flow itself.
The figures and how they are read
| Fiscal year before | FY2024 |
| Fiscal year | FY2025 |
| Operating cash flow, year before | $8.8B |
| Operating cash flow | $16.8B |
| Capex, year before | $5.1B |
| Capex | $7.8B |
| Free cash flow, year before | $3.8B |
| Free cash flow | $9.0B |
| Change in FCF | $5.2B |
| Change in capex | $2.8B |
| Working capital: change in its cash contribution | $1.6B |
| Of which: capex cut | 0.00 |
| Of which: working capital released | $1.6B |
| Share of the increase that need not repeat | +30.5% |
| Operating cash flow before working capital: change | 6404000000.00 |
FCF = operating cash flow − cash capex; ΔFCF = ΔOCF − ΔCapEx; the working-capital part is the change in the cash-bridge items (receivables, inventory, payables, accruals), with the sign of the cash flow statement
Source: FY2025 (cash flow statement, fiscal year) · FY2024 (cash flow statement, fiscal year before)
A07 Stock compensation added back = no economic cost Not triggered confidence high
Stock compensation is 1.0% of revenue: small enough that adding it back changes little.
The figures and how they are read
| Fiscal year | FY2025 |
| Stock compensation | $626M |
| Revenue | $65.2B |
| SBC / revenue | +1.0% |
| Buybacks | $4.1B |
| Buybacks / SBC | 6.6 |
| Diluted shares, year before | 904.1M shares |
| Diluted shares | 899.3M shares |
| Diluted shares: change | -0.5% |
SBC / revenue from the cash flow statement's add-back; the diluted weighted share count year over year; buybacks from the financing section
Source: FY2025 (stock compensation, buybacks and the diluted share count, fiscal year)
B02 Receivables growing = future cash is certain Not triggered confidence medium
Receivables grew 37% against revenue 39% in Q3 2026; DSO 80 against a median of 79: collections are keeping pace with sales.
The figures and how they are read
| Quarter | Q3 2026 |
| Revenue, year over year | +38.6% |
| Receivables, year over year | +37.1% |
| Quarter before | Q2 2026 |
| Revenue y/y, quarter before | +47.7% |
| Receivables y/y, quarter before | +41.7% |
| Days sales outstanding | 79.5 |
| DSO, median of eight quarters | 79.1 |
| Receivables | $22.1B |
| Revenue | $24.4B |
receivables and revenue against the same quarter a year earlier; DSO = receivables / quarterly revenue × days, against the median of the eight quarters before
Source: Q3 2026 (receivables and revenue) · Q3 2025 (the same quarter a year earlier)
B08 Adjusted profit = economic profit Insufficient data
no reconciliation table read from the releases yet and fewer than three quarters with both an adjusted and a GAAP EPS
C02 Low net debt = no refinancing risk Not triggered confidence medium
$781M comes due within a year, 31.6× covered by cash and investments of $5.0B plus $19.7B of free cash flow.
The figures and how they are read
| Cash and investments | $5.0B |
| Debt | $49.5B |
| Net debt | $44.5B |
| Due within a year | $781M |
| Read from | the debt maturity table |
| Free cash flow, twelve months | $19.7B |
| Cash plus free cash flow | $24.7B |
| Coverage of what is due | 31.6 |
| Due in the second year | $1.5B |
| Balance sheet date | 2026-09-30 |
due within a year from the maturity table (else the current portion of debt), against cash and investments plus free cash flow over the last twelve months (zero if negative); no credit lines assumed
Source: FY2024 (debt maturities, cash and investments)
D03 EPS growth = profit growth Insufficient data
no quarter with EPS, net income and diluted shares for both this year and last
E02 Low P/E at a cyclical peak = undervalued To review confidence medium
Net income of $27.6B is at a high against a median of $6.2B over eight years; at 44.2× the market is not pricing it as cheap, but a multiple on this year's profit still understates the mid-cycle one (195.2×).
The figures and how they are read
| market value | $1.22T |
| net income ttm | $27.6B |
| pe ttm | 44.20 |
| net income median fy | $6.2B |
| pe mid cycle | 195.20 |
| net income peak fy | $20.6B |
| years | FY2018 / 3232.0; FY2019 / 8318.0; FY2020 / 6194.0; FY2021 / 5582.0; FY2022 / 6245.0; FY2023 / 5240.0; FY2024 / 10590.0; FY2025 / 20640.0 |
| down years in window | 3 |
P/E on the trailing twelve months' net income against the P/E on the median net income of the last eight fiscal years (a mid-cycle stand-in); 'at a peak' = this year's profit at or above 90% of the best year and at least 1.3× the median
Source: Q3 2026 (net income, trailing twelve months)
What would show the trap does not apply
- Profit holds at this level through the next two years (the eight-year peak was a new base, not a top)
- The industry's capacity and prices stay where they are rather than reverting
Look again: next filing.
E07 A precise DCF value = the true value Insufficient data
no DCF in the valuation research for this company
J06 A bank's low P/E and high profit = safe Not applicable
not a bank
J08 A REIT's low net income = the dividend is unsafe Not applicable
not a REIT
What the statuses mean
Triggered: the filings show the pattern; read the normal explanations and the missing evidence before concluding anything. To review: one quarter or a weak signal; a reader's judgement, not a pattern. Not triggered: the pattern is absent on these figures. Insufficient data: the filings read so far do not hold what the rule needs; this is not a clean bill. Not applicable: the rule is not meant for this kind of company (a bank's working capital, a loss-making quarter's EPS growth). Out of date: the latest filing is more than fifteen months old.
Severity is what the pattern could mean for cash, value or solvency; confidence is how reliable the inputs and the reading are. The two are kept apart.
Record a view
A reader's judgement, grounds, what would change it and the next review; kept in the browser (needs JavaScript).
Every rule and the companies it triggers on → ELI Lilly: cash flow → Earnings quality score →
Each rule reads the company's own filings by a fixed formula and says what would explain the same figures innocently. A triggered rule is a question to verify, not a finding of manipulation, and not a view on the stock. Missing data is shown as missing, never as clear. Not investment advice.