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 PANW, in pipeline order: what EDGAR returned, what was derived from it, what was computed, and the latest state. Every table downloads at full precision.

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

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 62 periods · 33 concepts

Raw & derived facts for the selected ticker
endCapexCapex_TTMCashAndEquivalentsDepreciationAndAmortizationDepreciationAndAmortization_TTMEBITDA_QUARTERLYEBITDA_TTMEPS_QUARTERLY_CALCEPS_TTM_CALCFCF_QUARTERLYFCF_TTMGoodwillIncomeTaxExpenseIncomeTaxExpense_TTMLongTermDebtNetIncomeLossNetIncomeLoss_TTMOperatingCashFlowOperatingCashFlow_TTMOperatingIncomeLossOperatingIncomeLoss_TTMPretaxIncomePretaxIncome_TTMRevenueRevenue_TTMShareBasedCompensationShareBasedCompensation_TTMSharesOutstandingStockIssuedStockIssued_TTMStockRepurchasedStockRepurchased_TTMStockholdersEquity
2026-07-31103.00M440.00M2.51B341.00M855.00M513.00M1.55B-0.36910.40181.25B4.11B22.01B13.00M229.00M1.77B-282.00M307.00M1.36B4.55B172.00M695.00M-269.00M536.00M3.41B11.48B460.00M1.77B764.00M1.00M265.00M27.49B
2026-04-3083.00M424.00M2.36B334.00M598.00M151.00M1.62B-0.22101.0524788.00M3.79B21.90B21.00M554.00M1.19B-177.00M843.00M871.00M4.22B-183.00M1.02B-156.00M1.40B3.00B10.61B643.00M1.67B801.00M126.00M274.00M1.00B27.67B
2026-01-31170.00M409.00M4.16B91.00M352.00M488.00M1.77B0.60761.8031384.00M3.56B6.93B117.00M582.00M432.00M1.28B554.00M3.97B397.00M1.42B549.00M1.86B2.59B9.89B301.00M1.35B711.00M8.00M351.00M9.39B
2025-10-3184.00M287.00M3.07B89.00M348.00M398.00M1.61B0.47111.57551.69B3.69B4.57B78.00M523.00M334.00M1.12B1.77B3.98B309.00M1.27B412.00M1.64B2.47B9.56B370.00M1.37B709.00M130.00M380.00M8.66B
2025-07-3187.00M247.00M2.27B84.00M343.00M581.00M1.59B0.35831.5994934.00M3.47B4.57B338.00M462.00M0.00254.00M1.13B1.02B3.72B497.00M1.24B592.00M1.60B2.54B9.22B354.00M1.29B709.00M10.00M371.00M0.000.007.82B
2025-04-3068.00M207.60M2.38B88.00M335.80M307.00M1.32B0.37061.7512560.00M3.00B4.05B49.00M84.60M383.20M262.00M1.24B628.00M3.21B219.00M984.50M311.00M1.32B2.29B8.87B326.00M1.21B707.00M203.00M384.30M0.00300.00K7.23B
2025-01-3148.00M177.00M2.23B87.00M322.10M328.00M1.26B0.37661.7700509.00M2.93B4.05B58.00M8.00M533.80M267.00M1.25B557.00M3.11B241.00M942.20M325.00M1.26B2.26B8.57B320.00M1.15B709.00M37.00M297.10M0.00500.30M6.38B
2024-10-3144.00M164.20M2.28B84.00M303.70M370.00M1.06B0.49513.85731.47B3.08B4.05B17.00M-1.66B645.80M351.00M2.73B1.51B3.24B286.00M754.80M368.00M1.07B2.14B8.29B295.00M1.10B709.00M121.00M317.60M0.00500.30M5.91B
2024-07-3147.60M157.00M1.53B76.80M284.00M315.30M968.00M0.50583.6412465.50M3.10B3.35B-39.40M-1.59B963.90M358.10M2.58B513.10M3.26B238.50M684.00M318.70M988.00M2.19B8.03B269.50M1.08B708.00M23.30M283.00M300.00K567.00M5.17B
2024-04-3037.40M146.60M1.37B74.30M276.50M251.00M975.50M0.39313.4507491.50M3.01B3.37B-27.60M-1.46B1.16B278.80M2.45B528.90M3.16B176.70M699.00M251.20M985.80M1.98B7.79B263.50M1.06B709.30M115.80M319.80M500.00M566.70M4.47B
2024-01-3135.20M140.40M1.78B68.60M274.50M122.20M875.50M2.44323.1841654.80M2.92B3.37B-1.61B-1.41B1.82B1.75B2.28B690.00M3.06B53.60M601.00M135.50M865.60M1.98B7.53B272.00M1.07B715.00M57.50M334.30M0.0066.70M4.36B
2023-10-3136.80M143.50M2.49B64.30M275.80M279.50M863.10M0.27760.87751.49B2.92B2.93B88.40M200.60M1.95B194.20M613.90M1.53B3.07B215.20M587.30M282.60M814.50M1.88B7.21B271.00M1.08B699.60M86.40M277.50M66.70M316.70M2.17B
2023-07-3137.20M146.30M1.14B69.30M282.20M322.80M669.50M0.33270.6424376.90M2.63B2.93B88.80M126.60M1.99B227.70M439.70M414.10M2.78B253.50M387.30M316.50M566.30M1.95B6.89B254.20M1.07B684.50M60.10M258.80M0.00272.70M1.75B
2023-04-3031.20M148.30M1.99B72.30M285.40M151.00M434.60M0.15640.3123400.90M2.74B2.93B23.20M51.80M3.68B107.80M215.30M432.10M2.89B78.70M149.20M131.00M267.10M1.72B6.49B271.00M1.06B689.40M130.30M199.00M0.00615.00M1.23B
2023-01-3138.30M117.10M1.35B69.90M284.50M109.80M307.40M0.12700.0517656.30M2.73B2.91B200.00K49.30M3.68B84.20M34.30M694.60M2.84B39.90M22.90M84.40M83.60M1.66B6.16B283.30M1.04B663.20M700.00K146.20M250.00M615.00M729.00M
2022-10-3139.60M159.50M2.07B70.70M284.30M85.90M193.40M0.0296-0.21191.20B2.47B2.75B14.40M61.80M3.68B20.00M-143.40M1.24B2.63B15.20M-90.90M34.40M-81.60M1.56B5.82B266.00M1.02B676.80M67.70M145.60M22.70M915.00M508.00M
Copy table — 8 periods, ~3,869 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,StockIssued_TTM,StockRepurchased,StockRepurchased_TTM,StockholdersEquity
2026-07-31,103000000.0,440000000.0,2514000000.0,341000000.0,855000000.0,513000000.0,1550000000.0,-0.36910994764397903,0.4018324607329843,1254000000.0,4113000000.0,22010000000.0,13000000.0,229000000.0,1774000000.0,-282000000.0,307000000.0,1357000000.0,4553000000.0,172000000.0,695000000.0,-269000000.0,536000000.0,3410000000.0,11480000000.0,460000000.0,1774000000.0,764000000.0,1000000.0,265000000.0,,,27492000000.0
2026-04-30,83000000.0,424000000.0,2364000000.0,334000000.0,598000000.0,151000000.0,1618000000.0,-0.2209737827715356,1.0524344569288389,788000000.0,3793000000.0,21902000000.0,21000000.0,554000000.0,1192000000.0,-177000000.0,843000000.0,871000000.0,4217000000.0,-183000000.0,1020000000.0,-156000000.0,1397000000.0,3002000000.0,10606000000.0,643000000.0,1668000000.0,801000000.0,126000000.0,274000000.0,1000000000.0,,27668000000.0
2026-01-31,170000000.0,409000000.0,4158000000.0,91000000.0,352000000.0,488000000.0,1774000000.0,0.6075949367088608,1.8030942334739803,384000000.0,3565000000.0,6931000000.0,117000000.0,582000000.0,,432000000.0,1282000000.0,554000000.0,3974000000.0,397000000.0,1422000000.0,549000000.0,1864000000.0,2594000000.0,9893000000.0,301000000.0,1351000000.0,711000000.0,8000000.0,351000000.0,,,9393000000.0
2025-10-31,84000000.0,287000000.0,3066000000.0,89000000.0,348000000.0,398000000.0,1614000000.0,0.4710860366713681,1.5754583921015515,1687000000.0,3690000000.0,4567000000.0,78000000.0,523000000.0,,334000000.0,1117000000.0,1771000000.0,3977000000.0,309000000.0,1266000000.0,412000000.0,1640000000.0,2474000000.0,9556000000.0,370000000.0,1370000000.0,709000000.0,130000000.0,380000000.0,,,8665000000.0
2025-07-31,87000000.0,247000000.0,2269000000.0,84000000.0,343000000.0,581000000.0,1586000000.0,0.35825105782792666,1.5994358251057827,934000000.0,3469000000.0,4567000000.0,338000000.0,462000000.0,0.0,254000000.0,1134000000.0,1021000000.0,3716000000.0,497000000.0,1243000000.0,592000000.0,1596000000.0,2536000000.0,9221000000.0,354000000.0,1295000000.0,709000000.0,10000000.0,371000000.0,0.0,0.0,7824000000.0
2025-04-30,68000000.0,207600000.0,2383000000.0,88000000.0,335800000.0,307000000.0,1320300000.0,0.37057991513437055,1.7512022630834512,560000000.0,3000500000.0,4050800000.0,49000000.0,84600000.0,383200000.0,262000000.0,1238100000.0,628000000.0,3208100000.0,219000000.0,984500000.0,311000000.0,1322700000.0,2289000000.0,8874000000.0,326000000.0,1210500000.0,707000000.0,203000000.0,384300000.0,0.0,300000.0,7230000000.0
2025-01-31,48000000.0,177000000.0,2226000000.0,87000000.0,322100000.0,328000000.0,1264300000.0,0.3765867418899859,1.7699576868829336,509000000.0,2932000000.0,4050800000.0,58000000.0,8000000.0,533800000.0,267000000.0,1254900000.0,557000000.0,3109000000.0,241000000.0,942200000.0,325000000.0,1262900000.0,2257000000.0,8569800000.0,320000000.0,1148000000.0,709000000.0,37000000.0,297100000.0,0.0,500300000.0,6375000000.0
2024-10-31,44000000.0,164200000.0,2283000000.0,84000000.0,303700000.0,370000000.0,1058500000.0,0.49506346967559944,3.8572637517630466,1466000000.0,3077800000.0,4050800000.0,17000000.0,-1661400000.0,645800000.0,351000000.0,2734800000.0,1510000000.0,3242000000.0,286000000.0,754800000.0,368000000.0,1073400000.0,2139000000.0,8287900000.0,295000000.0,1100000000.0,709000000.0,121000000.0,317600000.0,0.0,500300000.0,5912000000.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 60 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-07-310.06450.427235.83%0.3677-72.93%-0.47746.05%0.050424.50%1.12%0.056060.33%
2026-04-300.04310.396635.76%0.2625-31.91%-0.72449.62%-0.061019.52%3.05%0.146255.28%
2026-01-310.312236.04%0.14802.16%14.37%0.153015.44%13.65%0.520751.48%
2025-10-310.318938.61%0.6819-59.16%13.25%0.124915.30%12.89%0.272653.92%
2025-07-310.00000.289537.62%0.3683-56.01%-1.430613.48%0.196014.87%14.49%0.348252.50%
2025-04-300.05300.064033.81%0.2446-49.42%-1.514711.09%0.095713.90%17.12%0.389447.71%
2025-01-310.08370.006334.21%0.2255-44.88%-1.338410.99%0.106813.85%19.68%0.539948.06%
2024-10-310.1092-1.547837.14%0.6854345.48%-1.54679.11%0.133714.99%46.26%1.469452.13%
2024-07-310.1865-1.609338.63%0.2127486.31%-0.59008.52%0.109016.46%49.87%1.417355.09%
2024-04-300.2602-1.482938.66%0.24761036.83%-0.21658.97%0.089020.05%54.78%2.235058.72%
2024-01-310.4181-1.630138.82%0.33156537.32%0.04497.98%0.027122.28%52.25%2.312461.10%
2023-10-310.89690.246340.56%0.7929-0.63118.15%0.114623.89%28.28%64.45%
2023-07-311.13930.223638.17%0.19301.27895.62%0.129825.29%25.15%63.46%
2023-04-302.98770.193942.20%0.23303.88682.30%0.045725.52%17.47%67.72%
2023-01-315.04840.589744.31%0.39657.59270.37%0.024126.73%4.71%71.03%
2022-10-317.241342.51%0.76578.3320-1.56%0.009727.65%-28.23%70.16%
Copy table — 8 periods, ~2,077 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-07-31,0.064527862650953,0.42723880597014924,0.3582752613240418,0.36774193548387096,-0.7292768959435626,-0.4774193548387097,0.06054006968641115,0.05043988269794721,0.2449842750244009,0.011166884911974392,0.05600145932141554,0.6032595363484428
2026-04-30,0.0430822610958508,0.39656406585540444,0.35762775787290213,0.262491672218521,-0.3191180033922947,-0.7243510506798516,0.0961719781255893,-0.06095936042638241,0.19517692134324993,0.03046841116090791,0.1462018730489074,0.5528046792161521
2026-01-31,,0.31223175965665234,0.36035580713635906,0.14803392444101773,0.02159534624272852,,0.14373799656322653,0.1530454895913647,0.15440266984060314,0.13648461620355584,0.5207148659626321,0.5147584769769622
2025-10-31,,0.31890243902439025,0.38614483047300124,0.6818916734033953,-0.5915606260055579,,0.1324822101297614,0.12489894907033144,0.15300618974649782,0.12890940565493364,0.27257198633479746,0.5391510202194991
2025-07-31,0.0,0.2894736842105263,0.3762064851968333,0.36829652996845424,-0.5601241272304112,-1.4306431273644389,0.13480099772258974,0.19597791798107256,0.14874797558240926,0.14493865030674846,0.34817316548971444,0.5249544607792426
2025-04-30,0.05300138312586446,0.06396008165116807,0.3381226053639847,0.24464831804281345,-0.49415754208203955,-1.514655760054533,0.11094207798061753,0.09567496723460026,0.13896268915328647,0.1712448132780083,0.38943759436336184,0.47708529451727116
2025-01-31,0.08373333333333334,0.006334626652941642,0.34213167168428665,0.2255206025697829,-0.44878327330229284,-1.3384481531282133,0.1099442227356531,0.10677891005759858,0.1384807503254777,0.1968470588235294,0.5399277170639359,0.48061242200976434
2024-10-31,0.10923545331529093,-1.5477920626048072,0.3713606583091012,0.6853669939223936,3.4547971982407555,-1.5467170524326879,0.09107252741949107,0.13370733987844788,0.1499153647639926,0.4625845737483085,1.4693745970341714,0.5212760230730937

Quality flags

Distortion of data.

Quality flags, how often and how recently
flagraisedperiods evaluatedmost recent
buyback_distortion_flag056
fcf_exceeds_ebitda28282026-07-31
inorganic_contaminated10502026-04-30
low_tax_rate_flag6162025-04-30
share_count_jump_flag2582012-07-31
Per-period flag values
Quality flags per period
endbuyback_distortion_flagfcf_exceeds_ebitdainorganic_contaminatedlow_tax_rate_flagshare_count_jump_flag
2026-07-3101000
2026-04-3001100
2026-01-3101100
2025-10-3101000
2025-07-3101000
2025-04-3001010
2025-01-3101010
2024-10-3101110
2024-07-3101010
2024-04-3001010
2024-01-3101010
2023-10-3101000
2023-07-3101000
2023-04-3001000
2023-01-3101000
2022-10-310100

Valuation history

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

16 of 62 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-07-310.0000163.082761.458322.01909.2215825.7919108.387461.6382
2026-04-300.000088.049037.559513.43235.1914170.38598.729867.593137.8685
2026-01-310.000013.395798.14796.356656.831835.2947
2025-10-310.000018.0208139.79429.136567.306142.3171
2025-07-310.000076.174934.826613.102015.7314108.53837.296856.615635.4807
2025-04-300.000098.583443.379314.667518.2793106.74387.681573.832144.0458
2025-01-310.0000102.081544.018315.060020.5104104.19467.524173.292544.5954
2024-10-310.0000119.130640.970815.214921.606446.70803.115664.585441.5027
2024-07-310.0000118.164636.885914.249822.239244.59052.709656.767637.0701
2024-04-300.0000105.538634.176413.213823.090642.14912.101952.858634.2465
2024-01-310.0000138.271441.432216.082127.774153.15702.385565.287741.4188
2023-10-310.000097.860828.893311.7190138.47275.795846.105029.0796
2023-07-310.0000129.059032.838612.5357194.56187.693954.955232.5132
2023-04-300.0000148.603723.58089.9513292.122511.445637.461422.9641
2023-01-310.0000178.721620.14348.92491533.674231.105119.2876
2022-10-310.0000308.570124.131610.258339.907923.4800
Copy table — 8 periods, ~1,308 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-07-31,0.0,,163.08265144594253,61.45832962344054,22.018999106377258,9.221522979092498,825.7918884078532,,108.38739193724281,61.63824695871892
2026-04-30,0.0,,88.0490271116806,37.55953753406254,13.432333195049898,5.19138809696036,170.38591443262067,8.729818733689815,67.59309452550552,37.868527779251046
2026-01-31,0.0,,,,,13.395685177038212,98.14794919494534,6.35662254391507,56.8318296603071,35.29471833602242
2025-10-31,0.0,,,,,18.020792140179264,139.79423804355713,9.136508678189399,67.30610512700574,42.317117586626914
2025-07-31,0.0,,76.17490815094109,34.82657951207627,13.10198506966626,15.731391146139133,108.53827542098111,7.296790090487571,56.615641364945986,35.48065849737463
2025-04-30,0.0,,98.5834316608175,43.37933838419508,14.667534913429947,18.279322935238913,106.74380487987831,7.681472309601877,73.8321255987583,44.045827302708666
2025-01-31,0.0,,102.08145116015362,44.01827377277702,15.060045590536795,20.510396659103094,104.19458020701428,7.5241201367064345,73.29247685077479,44.59542247673337
2024-10-31,0.0,,119.13063792146261,40.97075191366176,15.2149254020763,21.60639043299529,46.70797873331438,3.1156231922488664,64.5853879259117,41.50269031121846

Current snapshot

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

Current snapshot for PANW
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_fcfev_salesfcf_ttmfiling_likely_overduefundamentals_stalemarket_capnet_debtp_ffo_band_elevatedp_tbv_band_elevatedpb_ratiope_ratiope_ratio_band_elevatedpfcf_ex_sbcpfcf_ratiopfcf_ratio_band_elevatedpricerevenue_ttmshares_basisshares_delta_pctshares_outstandingshares_source_is_edgaryoy_growth
value133.60730.00000.0000124.094896.51820.00000.0000108.538333.28820.00000.000034.95382.51B-70.000049.00001.77B1.55B0.401827.49B306.06B197.45751.000074.412626.66024.11B0.00000.0000306.80B-740.00M1.00001.000011.1596933.37411.0000131.166874.59250.0000375.060011.48B0.0000-6.6015818.00M0.00000.2450
Copy table — ~1,222 characters
concept,value
avg_ev_ebitda_5y,133.60729235373907
avg_ev_ebitda_5y_diverges,0.0
avg_ev_ebitda_5y_history_too_short,0.0
avg_ev_ebitda_5y_median,124.09482777165069
avg_pe_5y,96.51821769340026
avg_pe_5y_diverges,0.0
avg_pe_5y_history_too_short,0.0
avg_pe_5y_median,108.53827542098111
avg_pfcf_5y,33.288171288936695
avg_pfcf_5y_diverges,0.0
avg_pfcf_5y_history_too_short,0.0
avg_pfcf_5y_median,34.953819752582646
cash,2514000000.0
days_past_expected_filing,-70.0
days_since_last_filing,49.0
debt,1774000000.0
ebitda_ttm,1550000000.0
eps_ttm,0.4018324607329843
equity,27492000000.0
ev,306059080000.0
ev_ebitda,197.45747096774193
ev_ebitda_band_elevated,1.0
ev_fcf,74.41261366399222
ev_sales,26.660198606271777
fcf_ttm,4113000000.0
filing_likely_overdue,0.0
fundamentals_stale,0.0
market_cap,306799080000.0
net_debt,-740000000.0
p_ffo_band_elevated,1.0
p_tbv_band_elevated,1.0
pb_ratio,11.159576604103012
pe_ratio,933.3740716612378
pe_ratio_band_elevated,1.0
pfcf_ex_sbc,131.16677212483967
pfcf_ratio,74.59253099927061
pfcf_ratio_band_elevated,0.0
price,375.06
revenue_ttm,11480000000.0
shares_basis,0.0
shares_delta_pct,-6.601466992665037
shares_outstanding,818000000.0
shares_source_is_edgar,0.0
yoy_growth,0.2449842750244009