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.

Everything the charts are drawn from, for AMZN, in pipeline order: what EDGAR returned, what was derived from it, what was computed, and the latest state. Every table downloads at full precision.

AMZN is covered here under the standard profile. Every figure below is computed from AMZN's own SEC EDGAR XBRL filings, as of 2026-09-18. Trailing-twelve-month revenue is 775.68B; year-over-year revenue growth is 15.77%. AMZN trades at a P/E (TTM) of 20.2447, on a market capitalisation of 2.71T.

Facts

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 78 periods · 32 concepts · 1 null in every period shown — kept on purpose, an empty column is a finding

Raw & derived facts for the selected ticker
endCapexCapex_TTMCashAndEquivalentsDepreciationAndAmortizationDepreciationAndAmortization_TTMEBITDA_QUARTERLYEBITDA_TTMEPS_QUARTERLY_CALCEPS_TTM_CALCFCF_QUARTERLYFCF_TTMGoodwillIncomeTaxExpenseIncomeTaxExpense_TTMLongTermDebtNetIncomeLossNetIncomeLoss_TTMOperatingCashFlowOperatingCashFlow_TTMOperatingIncomeLossOperatingIncomeLoss_TTMPretaxIncomePretaxIncome_TTMRevenueRevenue_TTMShareBasedCompensationShareBasedCompensation_TTMSharesOutstandingStockIssued_TTM ᵃStockRepurchasedStockRepurchased_TTMStockholdersEquity
2026-06-3054.21B173.03B78.21B19.99B75.20B47.45B168.91B5.745812.4077-8.82B-11.62B23.50B18.20B39.62B133.00B62.65B135.28B45.39B161.40B27.46B93.71B80.86B175.47B200.61B775.68B6.04B19.31B10.90B551.62B
2026-03-3144.20B151.00B101.82B18.95B70.44B42.80B155.86B2.78238.3500-18.17B-2.47B23.45B9.56B24.09B122.63B30.25B90.80B26.03B148.53B23.85B85.42B39.83B115.47B181.52B742.78B4.03B19.81B10.87B441.91B
2025-12-3139.52B131.82B86.81B19.47B65.76B44.45B145.73B1.95737.173714.94B7.70B23.27B4.95B19.09B68.84B21.19B77.67B54.46B139.51B24.98B79.97B26.61B97.31B213.39B716.92B4.40B19.47B10.83B411.06B
2025-09-3035.09B120.13B66.92B16.80B61.92B34.22B138.12B1.95367.0523430.00M10.56B23.26B6.91B16.47B55.10B21.19B76.48B35.52B130.69B17.42B76.20B28.17B93.06B180.17B691.33B4.85B20.07B10.85B369.63B
2025-06-3032.18B107.66B57.74B15.23B58.56B34.40B134.75B1.68096.5355332.00M13.48B23.16B2.68B12.26B56.08B18.16B70.62B32.52B121.14B19.17B76.19B20.86B82.92B167.70B670.04B6.53B20.55B10.81B333.77B
2025-03-3125.02B93.09B66.21B14.26B55.37B32.67B127.06B1.58696.1099-8.00B20.81B23.09B4.55B11.35B58.75B17.13B65.94B17.02B113.90B18.41B71.69B21.68B77.31B155.67B650.31B3.69B20.74B10.79B305.87B
2024-12-3127.83B83.00B78.78B15.63B52.80B36.83B121.39B1.86595.526417.80B32.88B23.07B2.33B9.27B58.00B20.00B59.25B45.64B115.88B21.20B68.59B22.35B68.61B187.79B637.96B5.00B22.01B10.72B285.97B
2024-09-3022.62B69.75B75.09B13.44B50.98B30.85B111.58B1.42794.64543.35B42.95B23.08B2.71B10.00B60.50B15.33B49.87B25.97B112.71B17.41B60.60B18.04B59.95B158.88B620.13B5.33B23.34B10.73B259.15B
2024-06-3017.62B59.61B71.18B12.04B49.67B26.71B104.05B1.25934.14827.66B48.34B22.88B1.77B9.60B62.68B13.48B44.42B25.28B107.95B14.67B54.38B15.24B54.10B147.98B604.33B6.72B23.83B10.71B236.45B
2024-03-3114.93B53.45B72.85B11.68B49.22B26.99B96.61B0.97763.53184.06B45.70B22.77B2.47B8.64B66.85B10.43B37.68B18.99B99.15B15.31B47.38B12.98B46.42B143.31B590.74B4.96B24.24B10.67B0.00000.00216.66B
2023-12-3114.59B52.73B73.39B13.82B48.66B27.03B85.52B1.01262.899827.88B32.22B22.79B3.06B7.12B67.18B10.62B30.43B42.47B84.95B13.21B36.85B13.69B37.56B169.96B574.78B6.32B24.02B10.49B0.00000.00201.88B
2023-09-3012.48B54.73B49.60B12.13B47.53B23.32B73.91B0.93571.90188.74B16.92B22.75B2.31B2.83B67.47B9.88B20.08B21.22B71.65B11.19B26.38B12.19B22.91B143.08B554.03B5.83B23.31B10.56B0.00000.00182.97B
2023-06-3011.46B58.63B49.53B11.59B45.72B19.27B63.44B0.64601.25105.02B3.21B22.79B804.00M594.00M67.47B6.75B13.07B16.48B61.84B7.68B17.72B7.56B13.66B134.38B538.05B7.13B23.04B10.45B0.00000.00168.60B
2023-03-3114.21B62.90B49.34B11.12B43.85B15.90B57.20B0.30660.4150-9.42B-8.57B22.75B948.00M-847.00M69.47B3.17B4.29B4.79B54.33B4.77B13.35B4.12B3.45B127.36B524.90B4.75B21.12B10.35B0.00003.33B154.53B
2022-12-3116.59B63.65B53.89B12.69B41.92B15.42B54.17B0.0273-0.267212.58B-16.89B20.29B-1.23B-3.22B70.54B278.00M-2.72B29.17B46.75B2.74B12.25B-962.00M-5.94B149.20B513.98B5.61B19.62B10.19B0.00006.00B146.04B
2022-09-3016.38B65.99B34.95B10.33B39.17B12.85B52.15B0.27801.0960-4.97B-26.32B20.17B69.00M-1.38B63.54B2.87B11.32B11.40B39.66B2.52B12.97B2.94B9.96B127.10B502.19B5.56B17.70B10.33B0.00006.00B137.49B

annual cadenceStockIssued_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, ~4,011 characters
end,Capex,Capex_TTM,CashAndEquivalents,DepreciationAndAmortization,DepreciationAndAmortization_TTM,EBITDA_QUARTERLY,EBITDA_TTM,EPS_QUARTERLY_CALC,EPS_TTM_CALC,FCF_QUARTERLY,FCF_TTM,Goodwill,IncomeTaxExpense,IncomeTaxExpense_TTM,LongTermDebt,NetIncomeLoss,NetIncomeLoss_TTM,OperatingCashFlow,OperatingCashFlow_TTM,OperatingIncomeLoss,OperatingIncomeLoss_TTM,PretaxIncome,PretaxIncome_TTM,Revenue,Revenue_TTM,ShareBasedCompensation,ShareBasedCompensation_TTM,SharesOutstanding,StockIssued_TTM,StockRepurchased,StockRepurchased_TTM,StockholdersEquity
2026-06-30,54208000000.0,173028000000.0,78213000000.0,19988000000.0,75200000000.0,47449000000.0,168912000000.0,5.745849766119417,12.407685957993213,-8821000000.0,-11625000000.0,23504000000.0,18199000000.0,39615000000.0,132995000000.0,62647000000.0,135281000000.0,45387000000.0,161403000000.0,27461000000.0,93712000000.0,80857000000.0,175466000000.0,200606000000.0,775680000000.0,6038000000.0,19314000000.0,10903000000.0,,,,551620000000.0
2026-03-31,44203000000.0,151003000000.0,101816000000.0,18945000000.0,70439000000.0,42797000000.0,155861000000.0,2.7823248114769172,8.350009196247932,-18171000000.0,-2472000000.0,23449000000.0,9560000000.0,24094000000.0,122632000000.0,30255000000.0,90798000000.0,26032000000.0,148531000000.0,23852000000.0,85422000000.0,39834000000.0,115466000000.0,181519000000.0,742776000000.0,4032000000.0,19810000000.0,10874000000.0,,,,441914000000.0
2025-12-31,39522000000.0,131819000000.0,86810000000.0,19471000000.0,65756000000.0,44448000000.0,145731000000.0,1.9573288999722915,7.173732335827099,14937000000.0,7695000000.0,23273000000.0,4946000000.0,19087000000.0,68836000000.0,21192000000.0,77670000000.0,54459000000.0,139514000000.0,24977000000.0,79975000000.0,26605000000.0,97311000000.0,213386000000.0,716924000000.0,4397000000.0,19467000000.0,10827000000.0,,,,411065000000.0
2025-09-30,35095000000.0,120131000000.0,66922000000.0,16796000000.0,61916000000.0,34218000000.0,138117000000.0,1.9536191793453204,7.052282157676348,430000000.0,10560000000.0,23260000000.0,6910000000.0,16466000000.0,55097000000.0,21187000000.0,76482000000.0,35525000000.0,130691000000.0,17422000000.0,76201000000.0,28170000000.0,93055000000.0,180169000000.0,691330000000.0,4847000000.0,20065000000.0,10845000000.0,,,,369631000000.0
2025-06-30,32183000000.0,107656000000.0,57741000000.0,15227000000.0,58562000000.0,34398000000.0,134752000000.0,1.6809180085137887,6.535535813436979,332000000.0,13481000000.0,23155000000.0,2678000000.0,12262000000.0,56082000000.0,18164000000.0,70623000000.0,32515000000.0,121137000000.0,19171000000.0,76190000000.0,20857000000.0,82922000000.0,167702000000.0,670038000000.0,6534000000.0,20551000000.0,10806000000.0,,,,333775000000.0
2025-03-31,25019000000.0,93093000000.0,66207000000.0,14262000000.0,55373000000.0,32667000000.0,127064000000.0,1.5868618549059577,6.109886037246364,-8004000000.0,20810000000.0,23089000000.0,4553000000.0,11351000000.0,58750000000.0,17127000000.0,65944000000.0,17015000000.0,113903000000.0,18405000000.0,71691000000.0,21679000000.0,77310000000.0,155667000000.0,650313000000.0,3689000000.0,20739000000.0,10793000000.0,,,,305867000000.0
2024-12-31,27834000000.0,82999000000.0,78779000000.0,15631000000.0,52795000000.0,36834000000.0,121388000000.0,1.8658707210148306,5.526350153903554,17802000000.0,32878000000.0,23074000000.0,2325000000.0,9265000000.0,58000000000.0,20004000000.0,59248000000.0,45636000000.0,115877000000.0,21203000000.0,68593000000.0,22349000000.0,68614000000.0,187792000000.0,637959000000.0,4995000000.0,22011000000.0,10721000000.0,,,,285970000000.0
2024-09-30,22620000000.0,69753000000.0,75091000000.0,13442000000.0,50984000000.0,30853000000.0,111583000000.0,1.4278528178854215,4.645365626455519,3351000000.0,42953000000.0,23081000000.0,2706000000.0,10002000000.0,60500000000.0,15328000000.0,49868000000.0,25971000000.0,112706000000.0,17411000000.0,60599000000.0,18037000000.0,59951000000.0,158877000000.0,620128000000.0,5333000000.0,23335000000.0,10735000000.0,,,,259151000000.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 · 12 concepts

Calculated metrics for the selected ticker
enddebt_to_equityeffective_tax_ratefcf_marginfcf_margin_quarterlyincome_yoy_growthnet_debt_to_ebitdaoperating_marginoperating_margin_quarterlyrevenue_yoy_growthroerotcerule_of_40
2026-06-300.24110.2258-1.50%-0.044091.55%0.324312.08%0.136915.77%24.52%0.256214.27%
2026-03-310.27750.2087-0.33%-0.100137.69%0.133611.50%0.131414.22%20.55%0.217013.89%
2025-12-310.16750.19611.07%0.070031.09%-0.123311.16%0.117112.38%18.89%0.200313.45%
2025-09-300.14910.17691.53%0.002453.37%-0.085611.02%0.096711.48%20.69%0.220813.01%
2025-06-300.16800.14792.01%0.002058.99%-0.012311.37%0.114310.87%21.16%0.227412.88%
2025-03-310.19210.14683.20%-0.051474.99%-0.058711.02%0.118210.08%21.56%0.233213.28%
2024-12-310.20280.13505.15%0.094894.73%-0.171210.75%0.112910.99%20.72%0.225416.14%
2024-09-300.23350.16686.93%0.0211148.36%-0.13089.77%0.109611.93%19.24%0.211218.86%
2024-06-300.26510.17758.00%0.0518239.80%-0.08169.00%0.099212.32%18.79%0.208020.32%
2024-03-310.30860.18617.74%0.0284777.60%-0.06218.02%0.106812.54%17.39%0.194420.28%
2023-12-310.33280.18965.61%0.1640-0.07266.41%0.077711.83%15.07%0.169917.43%
2023-09-300.36880.12363.05%0.061177.33%0.24174.76%0.078210.32%10.97%0.125313.38%
2023-06-300.40020.04350.60%0.037412.62%0.28283.29%0.057210.73%7.75%0.089611.33%
2023-03-310.4496-1.63%-0.0740-79.95%0.35192.54%0.03759.87%2.78%0.03268.24%
2022-12-310.4830-3.29%0.08430.30742.38%0.01839.40%-1.86%-0.02166.11%
2022-09-300.4622-0.1384-5.24%-0.0391-56.89%0.54832.58%0.01999.66%8.24%0.09654.42%
Copy table — 8 periods, ~2,192 characters
end,debt_to_equity,effective_tax_rate,fcf_margin,fcf_margin_quarterly,income_yoy_growth,net_debt_to_ebitda,operating_margin,operating_margin_quarterly,revenue_yoy_growth,roe,rotce,rule_of_40
2026-06-30,0.24109894492585476,0.22577023468934151,-0.014986850247524752,-0.04397176555038234,0.9155374311484927,0.32432272425878567,0.12081270627062707,0.1368902226254449,0.15766568463281194,0.24524310213552808,0.25615773807269615,0.1426788343852872
2026-03-31,0.2775019573944252,0.20866748653283218,-0.0033280558337910756,-0.10010522314468458,0.37689554773747425,0.13355489827474482,0.11500371579049404,0.13140222235688825,0.14218230298333268,0.20546531678109314,0.21697871984514833,0.1388542471495416
2025-12-31,0.16745770133677157,0.19614432078593375,0.010733355278941701,0.06999990627313882,0.3109303267620849,-0.1233368329319088,0.11155296795755199,0.11705079058607407,0.12377754683294695,0.1889482198679041,0.2002877831414779,0.13451090211188865
2025-09-30,0.14905946741480017,0.17694911611412606,0.015274904893466217,0.0023866480915140783,0.5336889387984278,-0.08561581847274412,0.11022377157074045,0.09669810011711227,0.11481823107487488,0.20691446334317198,0.22080947885359917,0.1300931359683411
2025-06-30,0.16802336903602727,0.14787390559803187,0.02011975440198914,0.0019797020906131115,0.5899277336275017,-0.01231150558062218,0.11370996868834304,0.11431586981669867,0.10872133621474211,0.21158864504531497,0.22736140621981843,0.12884109061673127
2025-03-31,0.19207694847760629,0.14682447290130643,0.03199997539646293,-0.05141744878490624,0.7499203906167073,-0.0586869609015929,0.11024076098740145,0.11823315153500742,0.10084470325354644,0.2155969751558684,0.2332006025928467,0.13284467865000937
2024-12-31,0.2028184774626709,0.13503075174162707,0.05153622724971354,0.09479637045241544,0.9473459326211997,-0.17117837018486176,0.1075194487420038,0.1129068330919315,0.1099089224666614,0.2071825715984194,0.2253666849248372,0.16144514971637494
2024-09-30,0.2334546268391787,0.16683624960384313,0.06926473244233448,0.02109178798693329,1.4835898202101698,-0.13076364679207406,0.0977201480984571,0.1095879202150091,0.11930804941266504,0.19242835258208535,0.21124242809336213,0.18857278185499954

Quality flags

Distortion of data.

Quality flags, how often and how recently
flagraisedperiods evaluatedmost recent
buyback_distortion_flag068
fcf_exceeds_ebitda5522011-12-31
inorganic_contaminated6682022-03-31
low_tax_rate_flag6502023-06-30
share_count_jump_flag072
Per-period flag values
Quality flags per period
endbuyback_distortion_flagfcf_exceeds_ebitdainorganic_contaminatedlow_tax_rate_flagshare_count_jump_flag
2026-06-300000
2026-03-310000
2025-12-3100000
2025-09-3000000
2025-06-3000000
2025-03-3100000
2024-12-3100000
2024-09-3000000
2024-06-3000000
2024-03-3100000
2023-12-3100000
2023-09-3000000
2023-06-3000010
2023-03-31000
2022-12-31000
2022-09-300010

Valuation history

Multiples over time, priced off the closing price nearest each period end.

16 of 78 periods · 10 concepts · 1 null in every period shown — kept on purpose, an empty column is a finding

Valuation history for the selected ticker
endbuyback_distortion_flagdividend_yieldev_ebitdaev_fcfev_salespb_ratiope_ratiope_to_revenue_growthpfcf_ex_sbcpfcf_ratio
2026-06-300.000015.70883.42074.710919.20911.2183
2026-03-310.000014.66403.07705.124824.94251.7543
2025-12-310.000017.0253322.43203.46086.079532.17572.5995324.7678
2025-09-300.000017.1551224.37613.42736.442231.13462.7116225.4959
2025-06-300.000017.5810175.73393.53577.102833.56883.0876175.8570
2025-03-310.000016.102398.31903.14626.713631.13973.087998.6774
2024-12-310.000019.205470.90763.65438.224939.69893.6120216.442571.5396
2024-09-300.000017.795446.22873.20207.718540.11093.3620101.960146.5684
2024-06-300.000019.806342.63193.41018.751746.58643.781384.431142.8076
2024-03-310.000019.860041.98373.24798.883351.07354.071689.669042.1150
2023-12-310.000018.569349.28922.76277.896752.39624.4293194.551449.4818
2023-09-300.000018.401380.37352.45477.335166.84266.475679.3176
2023-06-300.000021.7537430.06382.56508.0790104.20229.7100424.4723
2023-03-310.000019.03492.07446.9163248.891925.2195
2022-12-310.000016.10761.69765.8604
2022-09-300.000022.93552.38168.4909103.100210.6761
Copy table — 8 periods, ~1,264 characters
end,buyback_distortion_flag,dividend_yield,ev_ebitda,ev_fcf,ev_sales,pb_ratio,pe_ratio,pe_to_revenue_growth,pfcf_ex_sbc,pfcf_ratio
2026-06-30,0.0,,15.70878907402684,,3.4207443534344337,4.7108897068127,19.209060992098088,1.218341266638592,,
2026-03-31,0.0,,14.663989236940225,,3.07702998812393,5.124816200570112,24.942488011396065,1.7542610780696068,,
2025-12-31,0.0,,17.025301543935857,322.4319973098527,3.4607771804254237,6.079545131060335,32.17572060382795,2.599479584714427,,324.7677997789885
2025-09-30,0.0,,17.155105667160107,224.3761107415864,3.4273237519435757,6.442199732790681,31.134603297915227,2.7116428294050126,,225.49590240825307
2025-06-30,0.0,,17.580958601019212,175.7339465473289,3.5357238446245454,7.102773824895636,33.56878542974018,3.0875986810386906,,175.85700863471115
2025-03-31,0.0,,16.102272246366244,98.31903511351659,3.1462067046365063,6.713624290009319,31.139696116588016,3.0878861369938053,,98.67737245133495
2024-12-31,0.0,,19.20536777487413,70.90763378114305,3.6543119282844523,8.22491933928881,39.69889588604545,3.6119811745117683,216.44245729791302,71.53963694435248
2024-09-30,0.0,,17.79537716010837,46.22870508826792,3.2020188890944645,7.718482929474986,40.110944286042596,3.3619646355382162,101.96006573842247,46.56840196625083

Current snapshot

42 concepts · as of 2026-09-18 · one row per concept, so a profile that does not apply is simply absent

Current snapshot for AMZN
conceptavg_ev_ebitda_5yavg_ev_ebitda_5y_divergesavg_ev_ebitda_5y_history_too_shortavg_ev_ebitda_5y_medianavg_pe_5yavg_pe_5y_divergesavg_pe_5y_history_too_shortavg_pe_5y_medianavg_pfcf_5yavg_pfcf_5y_divergesavg_pfcf_5y_history_too_shortavg_pfcf_5y_mediancashdays_past_expected_filingdays_since_last_filingdebtebitda_ttmeps_ttmequityevev_ebitdaev_ebitda_band_elevatedev_salesfcf_ttmfiling_likely_overduefundamentals_stalemarket_capnet_debtp_ffo_band_elevatedp_tbv_band_elevatedpb_ratiope_ratiope_ratio_band_elevatedpe_to_revenue_growthpfcf_ratio_band_elevatedpricerevenue_ttmshares_basisshares_delta_pctshares_outstandingshares_source_is_edgaryoy_growth
value19.22790.00000.000018.802144.77110.00000.000051.073577.97880.00001.000079.317678.21B-48.000080.0000133.00B168.91B12.4077551.62B2.76T16.36470.00003.5636-11.62B0.00000.00002.71T54.78B0.00000.00004.911720.24470.00001.28401.0000251.1900775.68B0.00001.081810.79B0.00000.1577
Copy table — ~1,191 characters
concept,value
avg_ev_ebitda_5y,19.227876106317286
avg_ev_ebitda_5y_diverges,0.0
avg_ev_ebitda_5y_history_too_short,0.0
avg_ev_ebitda_5y_median,18.802059977666396
avg_pe_5y,44.77110039960291
avg_pe_5y_diverges,0.0
avg_pe_5y_history_too_short,0.0
avg_pe_5y_median,51.073523301656124
avg_pfcf_5y,77.97877426619566
avg_pfcf_5y_diverges,0.0
avg_pfcf_5y_history_too_short,1.0
avg_pfcf_5y_median,79.31759287266787
cash,78213000000.0
days_past_expected_filing,-48.0
days_since_last_filing,80.0
debt,132995000000.0
ebitda_ttm,168912000000.0
eps_ttm,12.407685957993213
equity,551620000000.0
ev,2764196106150.68
ev_ebitda,16.364711246984704
ev_ebitda_band_elevated,0.0
ev_sales,3.563577900874949
fcf_ttm,-11625000000.0
filing_likely_overdue,0.0
fundamentals_stale,0.0
market_cap,2709414106150.68
net_debt,54782000000.0
p_ffo_band_elevated,0.0
p_tbv_band_elevated,0.0
pb_ratio,4.911740158352997
pe_ratio,20.244709678373166
pe_ratio_band_elevated,0.0
pe_to_revenue_growth,1.2840276389577814
pfcf_ratio_band_elevated,1.0
price,251.19
revenue_ttm,775680000000.0
shares_basis,0.0
shares_delta_pct,1.0818008137915092
shares_outstanding,10786313572.0
shares_source_is_edgar,0.0
yoy_growth,0.15766568463281194