Every figure this model derived for LLY, the value it took, and
the element in the company's own XBRL it was read from — so any of it can be checked
against the filing rather than taken on trust.
As at 2026-06-30.
The figures, and where each came from
This is the part no other screener shows. Each figure below names the XBRL element it
was read from, so it can be checked against the filing itself.
Figure
Value
XBRL tag
As at
capex
9,893,000,000
PaymentsToAcquireOtherPropertyPlantAndEquipment
2026-06-30
cash
9,071,600,000
CashAndCashEquivalentsAtCarryingValue
2026-06-30
current assets
64,672,000,000
AssetsCurrent
2026-06-30
current liabilities
47,741,000,000
LiabilitiesCurrent
2026-06-30
equity
33,879,000,000
StockholdersEquity
2026-06-30
interest expense
894,900,000
InterestExpenseNonoperating
2025-12-31
ocf
28,083,000,000
NetCashProvidedByUsedInOperatingActivities
2026-06-30
revenue
79,665,800,000
Revenues
2026-06-30
sbc
649,000,000
ShareBasedCompensation
2026-06-30
The ratios
The figures themselves rather than their scores — what somebody looking up
LLY on one particular measure came for.
Ratio
Value
cash operating margin
47.46
current ratio
1.35
current ratio reported
1.35
dilution pct
-0.53
ev ebit
32.53
ev owner earnings
65.02
ev sales
14.32
fcf margin
22.83
growth cv
0.66
interest cover
39.18
net debt ebitda
0.9
operating margin
44.01
owner earnings margin
22.02
revenue growth
49.58
revenue growth per share
50.38
roic
41.15
rule of 40
93.6
sbc pct revenue
0.81
What to be careful about
What this model itself distrusts about LLY's figures. Written by the
derivation as it ran, not added afterwards.
presents no operating result; summed as revenue minus the costs it does tag (CostOfGoodsAndServicesSold, SellingGeneralAndAdministrativeExpense, ResearchAndDevelopmentExpenseExcludingAcquiredInProcessCost, ResearchAndDevelopmentAssetAcquiredOtherThanThroughBusinessCombinationWrittenOff). Checked against the company's own figures: the answer lands 1.8% of revenue from the 33,596M pre-tax profit it reports, which is its interest and other non-operating items
gross profit not tagged; rebuilt from Revenues - CostOfGoodsAndServicesSold
no forward EPS estimate; growth rests on filings only. Analyst consensus is not published in XBRL, so it has to be fetched from a data provider or set by hand in overrides.yaml as `eps_growth_2y`
durability rests on 3 of 4 inputs; not tagged: contracted coverage
growth DROPPED from the total: only 2 of 4 inputs could be computed (margin trend, margin recent not tagged), so the score is not meaningful. Its weight is spread over the other dimensions