XBRL Metrics
This pipeline fetches SEC EDGAR 10k and 10q filings of more than 600 companies, extracts the XBRL facts, computes derived metrics, and links them to yfinance course data. This data stream is as pure as possible.
The green circle is the current multiple — today's price against the latest available fundamentals — not a filed period. It is excluded from the mean line, and hidden when the as-of date predates it.
Everything the charts are drawn from, for LLY, in pipeline order: what EDGAR returned, what was derived from it, what was computed, and the latest state. Every table downloads at full precision.
LLY is covered here under the pharma_medtech profile. Every figure below is computed from LLY's own SEC EDGAR XBRL filings, as of 2026-09-18. Trailing-twelve-month revenue is 79.67B; year-over-year revenue growth is 49.58%. LLY trades at a P/E (TTM) of 38.5582, on a market capitalisation of 1.03T.
Showing the most recent 16 periods. Raw is what EDGAR returned; derived is what the pipeline computed from it. Columns are grouped so a concept sits next to its own derivations.
Raw & derived facts
Straight from EDGAR, plus what the pipeline built on top. Revenue next to Revenue_TTM is the TTM derivation, auditable.
16 of 75 periods · 32 concepts · 2 null in every period shown — kept on purpose, an empty column is a finding
| end | Capex | Capex_TTM | CashAndEquivalents | DepreciationAndAmortization | DepreciationAndAmortization_TTM | DividendsPerShare | DividendsPerShare_TTM | EPS_QUARTERLY_CALC | EPS_TTM_CALC | FCF_QUARTERLY | FCF_TTM | Goodwill | IncomeTaxExpense | IncomeTaxExpense_TTM | LongTermDebt | NetIncomeLoss | NetIncomeLoss_TTM | OperatingCashFlow | OperatingCashFlow_TTM | PretaxIncome | PretaxIncome_TTM | ResearchAndDevelopment | ResearchAndDevelopment_TTM | Revenue | Revenue_TTM | ShareBasedCompensation | ShareBasedCompensation_TTM | SharesOutstanding | StockIssued_TTM ᵃ | StockRepurchased | StockRepurchased_TTM | StockholdersEquity |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-06-30 | 2.93B | 9.89B | 8.95B | 534.00M | 2.10B | 3.4600 | — | 7.9389 | 29.8883 | 7.76B | 18.19B | 8.85B | 2.15B | 6.88B | 47.86B | 7.09B | 26.71B | 10.69B | 28.08B | 9.25B | 33.60B | 3.82B | 14.60B | 22.97B | 79.67B | 201.00M | 649.00M | 893.70M | — | 1.60B | 6.17B | 33.88B |
| 2026-03-31 | 2.33B | 8.66B | 5.28B | 509.00M | 2.04B | — | — | 8.2554 | 28.2143 | 3.01B | 11.82B | 6.13B | 1.45B | 5.85B | 39.37B | 7.40B | 25.28B | 5.33B | 20.48B | 8.85B | 31.13B | 3.51B | 14.11B | 19.80B | 72.25B | 161.00M | 633.00M | 895.90M | — | 2.36B | 5.26B | 31.20B |
| 2025-12-31 | 2.55B | 7.84B | 7.27B | 585.70M | 2.00B | — | — | 7.3810 | 22.9514 | 677.90M | 8.97B | 5.90B | 1.63B | 5.09B | 42.50B | 6.64B | 20.64B | 3.22B | 16.81B | 8.27B | 25.73B | 3.80B | 13.34B | 19.29B | 65.18B | 136.10M | 626.00M | 899.30M | — | 1.51B | 4.11B | 26.54B |
| 2025-09-30 | 2.09B | 6.79B | 9.79B | 470.30M | 1.90B | 0.0000 | — | 6.2111 | 20.4854 | 6.75B | 9.27B | 5.90B | 1.65B | 4.09B | 40.87B | 5.58B | 18.41B | 8.84B | 16.06B | 7.23B | 22.50B | 3.47B | 12.56B | 17.60B | 59.42B | 150.90M | 632.20M | 898.80M | — | 708.30M | 4.65B | 23.79B |
| 2025-06-30 | 1.70B | 6.05B | 3.38B | 478.00M | 1.89B | 3.0000 | — | 6.2914 | 15.3369 | 1.39B | 4.88B | 5.77B | 1.12B | 3.06B | 34.18B | 5.66B | 13.80B | 3.09B | 10.94B | 6.78B | 16.86B | 3.34B | 11.83B | 15.56B | 53.26B | 185.00M | 614.50M | 899.80M | — | 692.00M | 4.39B | 18.27B |
| 2025-03-31 | 1.51B | 5.58B | 3.09B | 463.00M | 1.83B | — | — | 3.0635 | 12.3319 | 156.00M | 3.74B | 5.77B | 697.00M | 2.49B | 34.50B | 2.76B | 11.11B | 1.67B | 9.32B | 3.46B | 13.60B | 2.73B | 11.20B | 12.73B | 49.00B | 154.00M | 640.60M | 900.60M | — | 1.20B | 3.70B | 15.76B |
| 2024-12-31 | 1.50B | 5.06B | 3.27B | 485.20M | 1.77B | — | — | 4.8776 | 11.7133 | 977.70M | 3.76B | 5.77B | 628.50M | 2.09B | 29.47B | 4.41B | 10.59B | 2.47B | 8.82B | 5.04B | 12.68B | 3.02B | 10.99B | 13.53B | 45.04B | 142.30M | 646.00M | 904.10M | — | 2.05B | 2.50B | 14.27B |
| 2024-09-30 | 1.35B | 4.63B | 3.37B | 466.80M | 1.67B | 0.0000 | — | 1.0722 | 9.2481 | 2.36B | 1.40B | 5.77B | 618.10M | 1.78B | 29.05B | 970.30M | 8.37B | 3.71B | 6.03B | 1.59B | 10.15B | 2.73B | 10.53B | 11.44B | 40.86B | 133.20M | 624.40M | 905.00M | — | 446.10M | 446.10M | 14.24B |
| 2024-06-30 | 1.22B | 4.25B | 3.22B | 414.40M | 1.61B | 2.6000 | — | 3.2814 | 8.1197 | 241.40M | 257.30M | 5.77B | 550.20M | 1.65B | 23.73B | 2.97B | 7.34B | 1.47B | 4.51B | 3.52B | 8.99B | 2.71B | 10.21B | 11.30B | 38.92B | 211.10M | 706.80M | 904.20M | — | 0.00 | 0.00 | 13.56B |
| 2024-03-31 | 986.30M | 3.77B | 2.46B | 400.60M | 1.57B | — | — | 2.4816 | 6.7913 | 179.70M | -90.40M | 4.94B | 293.20M | 1.42B | 24.56B | 2.24B | 6.14B | 1.17B | 3.68B | 2.54B | 7.56B | 2.52B | 9.85B | 8.77B | 35.93B | 159.40M | 657.20M | 903.80M | — | 0.00 | 0.00 | 12.81B |
| 2023-12-31 | 1.07B | 3.45B | 2.82B | 387.40M | 1.53B | — | — | 2.4237 | 5.8010 | -1.38B | 792.00M | 4.94B | 318.90M | 1.31B | 19.10B | 2.19B | 5.24B | -312.00M | 4.24B | 2.51B | 6.55B | 2.56B | 9.31B | 9.35B | 34.12B | 120.70M | 629.00M | 903.30M | — | 0.00 | 750.00M | 10.77B |
| 2023-09-30 | 970.30M | 2.88B | 2.38B | 411.00M | 1.51B | 0.0000 | — | -0.0638 | 5.5439 | 1.22B | 3.34B | 4.09B | 484.60M | 1.15B | 17.92B | -57.40M | 4.99B | 2.19B | 6.21B | 427.20M | 6.14B | 2.41B | 8.75B | 9.50B | 32.07B | 215.60M | 601.20M | 899.80M | — | 0.00 | 750.00M | 11.22B |
| 2023-06-30 | 738.20M | 2.52B | 2.69B | 366.30M | 1.47B | 2.2600 | — | 1.9533 | 7.1979 | -106.30M | 3.72B | 4.08B | 325.70M | 783.00M | 18.16B | 1.76B | 6.50B | 631.90M | 6.24B | 2.09B | 7.28B | 2.36B | 8.14B | 8.31B | 29.52B | 161.50M | 470.70M | 902.70M | — | 0.00 | 750.00M | 11.06B |
| 2023-03-31 | 668.50M | 2.16B | 3.55B | 362.30M | 1.45B | — | — | 1.4889 | 6.2956 | 1.06B | 4.64B | 4.07B | 184.80M | 595.70M | 18.88B | 1.34B | 5.69B | 1.73B | 6.79B | 1.53B | 6.28B | 1.99B | 7.57B | 6.96B | 27.69B | 131.20M | 401.30M | 903.30M | — | 750.00M | 750.00M | 11.19B |
| 2022-12-31 | 500.70M | 1.85B | 2.07B | 375.00M | 1.52B | — | — | 2.1420 | 6.9032 | 1.16B | 5.73B | 4.07B | 158.70M | 561.60M | 14.82B | 1.94B | 6.24B | 1.66B | 7.59B | 2.10B | 6.81B | 2.00B | 7.19B | 7.30B | 28.54B | 92.90M | 371.10M | 904.62M | — | 0.00 | 1.50B | 10.65B |
| 2022-09-30 | 617.20M | — | 2.62B | 362.90M | 1.59B | 0.0000 | — | 1.6062 | 6.6754 | 1.60B | — | 3.89B | 113.80M | 516.70M | 14.14B | 1.45B | 6.03B | 2.22B | 8.18B | 1.57B | 6.55B | 1.80B | 7.09B | 6.94B | 29.24B | 85.10M | 353.50M | 903.80M | — | 0.00 | 2.25B | 10.07B |
ᵃ annual cadence — StockIssued_TTM. This filer discloses the item once a year, so the value is the 12-month figure taken as filed rather than four quarters summed. One point a year is complete coverage of what was published, not a gap.
Unmarked _TTM columns are summed from four quarters. FCF_TTM, EBITDA_TTM, FFO_TTM and EPS_TTM_CALC are built from other columns further down the pipeline and carry no provenance of their own — theirs is their inputs', visible in this same table.
Copy table — 8 periods, ~3,813 characters
end,Capex,Capex_TTM,CashAndEquivalents,DepreciationAndAmortization,DepreciationAndAmortization_TTM,DividendsPerShare,DividendsPerShare_TTM,EPS_QUARTERLY_CALC,EPS_TTM_CALC,FCF_QUARTERLY,FCF_TTM,Goodwill,IncomeTaxExpense,IncomeTaxExpense_TTM,LongTermDebt,NetIncomeLoss,NetIncomeLoss_TTM,OperatingCashFlow,OperatingCashFlow_TTM,PretaxIncome,PretaxIncome_TTM,ResearchAndDevelopment,ResearchAndDevelopment_TTM,Revenue,Revenue_TTM,ShareBasedCompensation,ShareBasedCompensation_TTM,SharesOutstanding,StockIssued_TTM,StockRepurchased,StockRepurchased_TTM,StockholdersEquity 2026-06-30,2933000000.0,9893000000.0,8950000000.0,534000000.0,2099000000.0,3.46,,7.938905673044646,29.888329417030324,7757000000.0,18190000000.0,8849000000.0,2152000000.0,6884400000.0,47858000000.0,7095000000.0,26711200000.0,10690000000.0,28083000000.0,9247000000.0,33595600000.0,3819000000.0,14596200000.0,22974000000.0,79665800000.0,201000000.0,649000000.0,893700000.0,,1601000000.0,6173000000.0,33879000000.0 2026-03-31,2326000000.0,8657000000.0,5282000000.0,509000000.0,2043000000.0,,,8.255385645719388,28.214309632771513,3007000000.0,11823000000.0,6130000000.0,1454000000.0,5848400000.0,39370000000.0,7396000000.0,25277200000.0,5333000000.0,20480000000.0,8850000000.0,31125600000.0,3510000000.0,14113200000.0,19799000000.0,72249800000.0,161000000.0,633000000.0,895900000.0,,2356000000.0,5264000000.0,31198000000.0 2025-12-31,2546700000.0,7841000000.0,7268000000.0,585700000.0,1997000000.0,,,7.380962971199822,22.95140664961637,677900000.0,8972000000.0,5898000000.0,1628500000.0,5091400000.0,42503000000.0,6637700000.0,20640200000.0,3224600000.0,16813000000.0,8266200000.0,25731600000.0,3801500000.0,13337200000.0,19292000000.0,65179800000.0,136100000.0,626000000.0,899300000.0,,1507700000.0,4108000000.0,26535000000.0 2025-09-30,2087300000.0,6790500000.0,9791900000.0,470300000.0,1896500000.0,0.0,,6.211059190031152,20.485425011125944,6748100000.0,9271800000.0,5898000000.0,1649900000.0,4091400000.0,40873600000.0,5582500000.0,18412300000.0,8835400000.0,16062300000.0,7232400000.0,22503700000.0,3465700000.0,12558600000.0,17600800000.0,59420900000.0,150900000.0,632200000.0,898800000.0,,708300000.0,4654200000.0,23793300000.0 2025-06-30,1697000000.0,6053900000.0,3375900000.0,478000000.0,1893000000.0,3.0,,6.291398088464103,15.336852633918648,1390000000.0,4884900000.0,5770500000.0,1116000000.0,3059600000.0,34180100000.0,5661000000.0,13800100000.0,3087000000.0,10938800000.0,6777000000.0,16859700000.0,3336000000.0,11827000000.0,15558000000.0,53259200000.0,185000000.0,614500000.0,899800000.0,,692000000.0,4392000000.0,18272900000.0 2025-03-31,1510000000.0,5581700000.0,3093300000.0,463000000.0,1829400000.0,,,3.06351321341328,12.331889851210304,156000000.0,3736300000.0,5770500000.0,697000000.0,2493800000.0,34499500000.0,2759000000.0,11106100000.0,1666000000.0,9318000000.0,3456000000.0,13599900000.0,2734000000.0,11202200000.0,12729000000.0,49004000000.0,154000000.0,640600000.0,900600000.0,,1200000000.0,3700000000.0,15764800000.0 2024-12-31,1496200000.0,5058000000.0,3268000000.0,485200000.0,1767000000.0,,,4.877557792279615,11.713306050215683,977700000.0,3760000000.0,5770000000.0,628500000.0,2090000000.0,29474000000.0,4409800000.0,10590000000.0,2473900000.0,8818000000.0,5038300000.0,12680000000.0,3022900000.0,10991000000.0,13533100000.0,45043000000.0,142300000.0,646000000.0,904100000.0,,2053900000.0,2500000000.0,14272000000.0 2024-09-30,1350700000.0,4632800000.0,3369000000.0,466800000.0,1669200000.0,0.0,,1.0721546961325967,9.248066298342541,2361200000.0,1399300000.0,5768400000.0,618100000.0,1780400000.0,29045400000.0,970300000.0,8369500000.0,3711900000.0,6032100000.0,1588400000.0,10149900000.0,2734100000.0,10530400000.0,11439100000.0,40863200000.0,133200000.0,624400000.0,905000000.0,,446100000.0,446100000.0,14240000000.0
Calculated metrics
What the pipeline computes from the facts above. Quality flags are pulled out below rather than left as 0/1 columns between the ratios.
16 of 73 periods · 10 concepts · 1 null in every period shown — kept on purpose, an empty column is a finding
| end | debt_to_equity | effective_tax_rate | fcf_margin | fcf_margin_quarterly | income_yoy_growth | payout_ratio | payout_ratio_quarterly | revenue_yoy_growth | roe | rotce |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-06-30 | 1.4126 | 0.2049 | 22.83% | 0.3376 | 93.56% | — | 0.4358 | 49.58% | 78.84% | 1.0672 |
| 2026-03-31 | 1.2619 | 0.1879 | 16.36% | 0.1519 | 127.60% | — | — | 47.44% | 81.02% | 1.0083 |
| 2025-12-31 | 1.6018 | 0.1979 | 13.77% | 0.0351 | 94.90% | — | — | 44.71% | 77.78% | 1.0002 |
| 2025-09-30 | 1.7179 | 0.1818 | 15.60% | 0.3834 | 119.99% | — | 0.0000 | 45.41% | 77.38% | 1.0289 |
| 2025-06-30 | 1.8705 | 0.1815 | 9.17% | 0.0893 | 87.97% | — | 0.4768 | 36.83% | 75.52% | 1.1038 |
| 2025-03-31 | 2.1884 | 0.1834 | 7.62% | 0.0123 | 80.94% | — | — | 36.38% | 70.45% | 1.1112 |
| 2024-12-31 | 2.0652 | 0.1648 | 8.35% | 0.0722 | 102.10% | — | — | 32.00% | 74.20% | 1.2456 |
| 2024-09-30 | 2.0397 | 0.1754 | 3.42% | 0.2064 | 67.78% | — | 0.0000 | 27.41% | 58.77% | 0.9879 |
| 2024-06-30 | 1.7498 | 0.1832 | 0.66% | 0.0214 | 12.99% | — | 0.7924 | 31.87% | 54.14% | 0.9420 |
| 2024-03-31 | 1.9169 | 0.1881 | -0.25% | 0.0205 | 7.93% | — | — | 29.76% | 47.91% | 0.7797 |
| 2023-12-31 | 1.7736 | 0.2005 | 2.32% | -0.1479 | -16.09% | — | — | 19.56% | 48.65% | 0.8985 |
| 2023-09-30 | 1.5974 | 0.1878 | 10.40% | 0.1284 | -17.32% | — | — | 9.69% | 44.46% | 0.6991 |
| 2023-06-30 | 1.6412 | 0.1075 | 12.59% | -0.0128 | 14.16% | — | 1.1570 | 1.53% | 58.73% | 0.9302 |
| 2023-03-31 | 1.6872 | 0.0948 | 16.74% | 0.1526 | -7.22% | — | — | -5.56% | 50.82% | 0.7990 |
| 2022-12-31 | 1.3911 | 0.0825 | 20.08% | 0.1591 | 11.88% | — | — | 0.79% | 58.64% | 0.9495 |
| 2022-09-30 | 1.4045 | 0.0789 | — | 0.2304 | 1.02% | — | 0.0000 | 5.34% | 59.91% | 0.9765 |
Copy table — 8 periods, ~1,527 characters
end,debt_to_equity,effective_tax_rate,fcf_margin,fcf_margin_quarterly,income_yoy_growth,payout_ratio,payout_ratio_quarterly,revenue_yoy_growth,roe,rotce 2026-06-30,1.4126154845184333,0.2049196918644108,0.22832884374474366,0.3376425524505963,0.9355801769552394,,0.43582832980972513,0.4958129299726619,0.7884294105493078,1.0671673991210546 2026-03-31,1.2619398679402525,0.18789677949983294,0.16364059139264053,0.15187635739178745,1.275974464483482,,,0.4743653579299649,0.8102186037566511,1.0083453007818732 2025-12-31,1.6017712455247786,0.19786565934492997,0.13765000813135359,0.0351389176860875,0.9490273843248347,,,0.4470572563994406,0.777848125117769,1.0001550612976693 2025-09-30,1.7178617509971295,0.18181010233872652,0.15603600753270314,0.3833973455752011,1.199928311129697,,0.0,0.4541421131972043,0.7738438972315735,1.0288902672768827 2025-06-30,1.870535054643762,0.18147416620699064,0.09171936491723495,0.08934310322663581,0.8796616633523113,,0.47684154742978274,0.36833261824076957,0.7552222143173771,1.1037960711543384 2025-03-31,2.188388054399675,0.18336899536026,0.07624479634315566,0.012255479613481028,0.8094004561746497,,,0.3637982856506734,0.7044872120166447,1.1112434087429834 2024-12-31,2.065162556053812,0.16482649842271294,0.08347578980085696,0.07224508796949701,1.0209923664122136,,,0.3199800726761224,0.7420123318385651,1.245589273112209 2024-09-30,2.039705056179775,0.17541059517827762,0.03424352473619296,0.2064148403283475,0.6777924785502365,,0.0,0.2740883934835139,0.5877457865168539,0.9879479673261249
Quality flags
Distortion of data.
| flag | raised | periods evaluated | most recent |
|---|---|---|---|
| buyback_distortion_flag | 3 | 68 | 2019-12-31 |
| inorganic_contaminated | 5 | 46 | 2026-06-30 |
| low_tax_rate_flag | 8 | 67 | 2023-03-31 |
| share_count_jump_flag | 0 | 54 | — |
Per-period flag values
| end | buyback_distortion_flag | inorganic_contaminated | low_tax_rate_flag | share_count_jump_flag |
|---|---|---|---|---|
| 2026-06-30 | 0 | 1 | 0 | 0 |
| 2026-03-31 | 0 | 0 | 0 | 0 |
| 2025-12-31 | 0 | 0 | 0 | 0 |
| 2025-09-30 | 0 | 0 | 0 | 0 |
| 2025-06-30 | 0 | 0 | 0 | 0 |
| 2025-03-31 | 0 | 0 | 0 | 0 |
| 2024-12-31 | 0 | 0 | 0 | 0 |
| 2024-09-30 | 0 | 0 | 0 | 0 |
| 2024-06-30 | 0 | 0 | 0 | 0 |
| 2024-03-31 | 0 | 0 | 0 | 0 |
| 2023-12-31 | 0 | 1 | 0 | 0 |
| 2023-09-30 | 0 | 0 | 0 | 0 |
| 2023-06-30 | 0 | 0 | 0 | 0 |
| 2023-03-31 | 0 | 0 | 1 | 0 |
| 2022-12-31 | 0 | 0 | 1 | 0 |
| 2022-09-30 | 0 | 0 | 1 | 0 |
Valuation history
Multiples over time, priced off the closing price nearest each period end.
16 of 75 periods · 9 concepts · 1 null in every period shown — kept on purpose, an empty column is a finding
| end | buyback_distortion_flag | dividend_yield | ev_fcf | ev_sales | pb_ratio | pe_ratio | pe_to_revenue_growth | pfcf_ex_sbc | pfcf_ratio |
|---|---|---|---|---|---|---|---|---|---|
| 2026-06-30 | 0.0000 | — | 60.9843 | 13.9245 | 31.5947 | 40.0730 | 0.8082 | 61.0226 | 58.8453 |
| 2026-03-31 | 0.0000 | — | 72.3604 | 11.8411 | 26.3295 | 32.4968 | 0.6851 | 73.4074 | 69.4772 |
| 2025-12-31 | 0.0000 | — | 111.1289 | 15.2969 | 36.2470 | 46.5990 | 1.0424 | 115.2424 | 107.2016 |
| 2025-09-30 | 0.0000 | — | 76.8533 | 11.9919 | 28.6419 | 37.0126 | 0.8150 | 78.8794 | 73.5010 |
| 2025-06-30 | 0.0000 | — | 148.6830 | 13.6371 | 38.0617 | 50.3980 | 1.3683 | 162.8647 | 142.3770 |
| 2025-03-31 | 0.0000 | — | 205.3985 | 15.6606 | 46.6878 | 66.2721 | 1.8217 | 237.7570 | 196.9928 |
| 2024-12-31 | 0.0000 | — | 190.3385 | 15.8887 | 48.3091 | 65.1055 | 2.0347 | 221.4087 | 183.3688 |
| 2024-09-30 | 0.0000 | — | 583.4204 | 19.9784 | 55.5269 | 94.4744 | 3.4469 | 1020.3946 | 565.0709 |
| 2024-06-30 | 0.0000 | — | 3213.0586 | 21.2400 | 59.4465 | 109.8114 | 3.4454 | — | 3133.3586 |
| 2024-03-31 | 0.0000 | — | — | 19.8532 | 53.9536 | 112.6205 | 3.7845 | — | — |
| 2023-12-31 | 0.0000 | — | 673.0475 | 15.6211 | 47.9737 | 98.6198 | 5.0420 | 3170.3534 | 652.4843 |
| 2023-09-30 | 0.0000 | — | 146.5379 | 15.2466 | 42.1958 | 94.9110 | 9.7958 | 173.0588 | 141.8802 |
| 2023-06-30 | 0.0000 | — | 115.4850 | 14.5446 | 37.4038 | 63.6904 | — | 127.4652 | 111.3250 |
| 2023-03-31 | 0.0000 | — | 68.5484 | 11.4759 | 27.0275 | 53.1844 | — | 71.4233 | 65.2406 |
| 2022-12-31 | 0.0000 | — | 58.3404 | 11.7153 | 30.2000 | 51.5027 | — | 60.0011 | 56.1161 |
| 2022-09-30 | 0.0000 | — | — | 10.0805 | 28.1250 | 46.9439 | 8.7987 | — | — |
Copy table — 8 periods, ~1,277 characters
end,buyback_distortion_flag,dividend_yield,ev_fcf,ev_sales,pb_ratio,pe_ratio,pe_to_revenue_growth,pfcf_ex_sbc,pfcf_ratio 2026-06-30,0.0,,60.98431962678562,13.924479186943838,31.594698013850188,40.072957186918984,0.8082273527866352,61.022562796375944,58.84534216664269 2026-03-31,0.0,,72.36038732250401,11.841096574855085,26.32953584569411,32.496829526765815,0.6850590791152087,73.40740476442939,69.47719354765836 2025-12-31,0.0,,111.12885602184879,15.296887935035507,36.246960475900785,46.59902017558102,1.0423501578049617,115.2424030946594,107.20163801025717 2025-09-30,0.0,,76.85326571513808,11.99187674804012,28.6419458022896,37.01256274651278,0.8149995710800914,78.87939361285444,73.50098244759563 2025-06-30,0.0,,148.6830140503332,13.637111622676883,38.061690007304406,50.39800112567827,1.368274180179568,162.86470947322795,142.3770098332561 2025-03-31,0.0,,205.39849580872433,15.660566482126699,46.68782349856241,66.27206669219048,1.821670670428235,237.7569531576499,196.99280033459218 2024-12-31,0.0,,190.3385115619416,15.888657582152618,48.30905293391959,65.10545830716718,2.034672277016002,221.4087358615608,183.36883071087777 2024-09-30,0.0,,583.4203948723804,19.97837072341182,55.5269493360198,94.47443199055164,3.446859999791789,1020.394578068037,565.0709344278724
Current snapshot
37 concepts · as of 2026-09-18 · one row per concept, so a profile that does not apply is simply absent
| concept | avg_pe_5y | avg_pe_5y_diverges | avg_pe_5y_history_too_short | avg_pe_5y_median | avg_pfcf_5y | avg_pfcf_5y_diverges | avg_pfcf_5y_history_too_short | avg_pfcf_5y_median | cash | days_past_expected_filing | days_since_last_filing | debt | eps_ttm | equity | ev | ev_fcf | ev_sales | fcf_ttm | filing_likely_overdue | fundamentals_stale | market_cap | p_ffo_band_elevated | p_tbv_band_elevated | pb_ratio | pe_ratio | pe_ratio_band_elevated | pe_to_revenue_growth | pfcf_ex_sbc | pfcf_ratio | pfcf_ratio_band_elevated | price | revenue_ttm | shares_basis | shares_delta_pct | shares_outstanding | shares_source_is_edgar | yoy_growth |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| value | 53.1298 | 0.0000 | 0.0000 | 50.9504 | 112.2927 | 0.0000 | 0.0000 | 126.6026 | 8.95B | -50.0000 | 80.0000 | 47.86B | 29.8883 | 33.88B | 1.07T | 58.6115 | 13.3827 | 18.19B | 0.0000 | 0.0000 | 1.03T | 1.0000 | 1.0000 | 30.3207 | 38.5582 | 1.0000 | 0.7777 | 58.5620 | 56.4725 | 1.0000 | 1152.4400 | 79.67B | 0.0000 | 0.2629 | 891.36M | 0.0000 | 0.4958 |
Copy table — ~1,021 characters
concept,value avg_pe_5y,53.12984776204853 avg_pe_5y_diverges,0.0 avg_pe_5y_history_too_short,0.0 avg_pe_5y_median,50.950351956475984 avg_pfcf_5y,112.29266548395749 avg_pfcf_5y_diverges,0.0 avg_pfcf_5y_history_too_short,0.0 avg_pfcf_5y_median,126.6026148136344 cash,8950000000.0 days_past_expected_filing,-50.0 days_since_last_filing,80.0 debt,47858000000.0 eps_ttm,29.888329417030324 equity,33879000000.0 ev,1066143535988.6001 ev_fcf,58.611519295689945 ev_sales,13.382700430907617 fcf_ttm,18190000000.0 filing_likely_overdue,0.0 fundamentals_stale,0.0 market_cap,1027235535988.6001 p_ffo_band_elevated,1.0 p_tbv_band_elevated,1.0 pb_ratio,30.320715959402584 pe_ratio,38.55819386624337 pe_ratio_band_elevated,1.0 pe_to_revenue_growth,0.7776762471355757 pfcf_ex_sbc,58.561971152648084 pfcf_ratio,56.47254183554701 pfcf_ratio_band_elevated,1.0 price,1152.44 revenue_ttm,79665800000.0 shares_basis,0.0 shares_delta_pct,0.262850331477431 shares_outstanding,891357065.0 shares_source_is_edgar,0.0 yoy_growth,0.4958129299726619