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

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

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

Raw & derived facts for the selected ticker
endCapexCapex_TTMCashAndEquivalentsDepreciationAndAmortizationDepreciationAndAmortization_TTMDividendsPerShareDividendsPerShare_TTMEPS_QUARTERLY_CALCEPS_TTM_CALCFCF_QUARTERLYFCF_TTMGoodwillIncomeTaxExpenseIncomeTaxExpense_TTMLongTermDebtNetIncomeLossNetIncomeLoss_TTMOperatingCashFlowOperatingCashFlow_TTMOperatingIncomeLossOperatingIncomeLoss_TTMPretaxIncomePretaxIncome_TTMResearchAndDevelopmentResearchAndDevelopment_TTMRevenueRevenue_TTMShareBasedCompensationShareBasedCompensation_TTMSharesOutstandingStockIssuedStockIssued_TTMStockRepurchasedStockRepurchased_TTMStockholdersEquity
2026-06-281.32B5.36B20.42B1.96B7.75B1.34005.24002.26798.62147.29B22.24B48.48B1.21B4.16B37.34B5.53B21.04B8.62B27.61B6.75B25.20B3.65B15.10B25.31B97.93B458.00M1.41B2.44B221.00M8.07B84.97B
2026-03-291.05B5.09B21.69B2.00B7.74B1.30005.20002.14098.60461.47B17.78B48.56B755.00M3.90B37.53B5.24B21.04B2.51B22.87B5.99B24.94B3.53B14.97B24.06B96.36B300.00M1.37B2.45B4.03B7.85B81.19B
2025-12-281.84B4.83B19.71B2.01B7.50B1.30005.14002.105911.03325.47B19.70B48.77B-150.00M5.78B41.44B5.12B26.80B7.31B24.53B4.97B32.58B4.25B14.66B24.56B94.19B309.00M1.35B2.43B1.92B5.95B81.54B
2025-09-281.16B4.61B18.23B1.78B7.39B1.30005.08002.121410.34308.01B19.60B48.05B2.34B6.38B39.41B5.15B25.12B9.17B24.20B7.49B31.50B3.67B15.71B23.99B92.15B347.00M1.28B2.43B1.90B4.31B79.28B
2025-06-291.04B4.48B18.58B1.94B7.46B1.30005.02002.28899.36752.83B18.55B48.12B954.00M4.69B39.23B5.54B22.66B3.88B23.03B6.49B27.35B3.52B16.99B23.74B90.63B410.00M1.23B2.42B0.002.95B78.47B
2025-03-30795.00M4.41B38.47B1.77B7.30B1.24004.96004.53798.99833.38B20.37B44.47B2.63B4.79B38.35B11.00B21.81B4.17B24.78B13.63B26.60B3.23B16.91B21.89B89.33B288.00M1.16B2.42B2.13B3.08B78.11B
2024-12-291.61B4.42B24.11B1.90B7.34B1.24004.91001.41235.78995.37B19.84B44.20B456.00M2.62B32.40B3.43B14.07B6.98B24.27B3.89B16.69B5.30B17.23B22.52B88.82B238.00M1.18B2.43B282.00M2.43B71.49B
2024-09-291.03B4.40B19.98B1.85B7.29B1.24004.86001.10966.04806.96B20.75B44.80B644.00M2.86B31.29B2.69B14.68B7.99B25.15B3.34B17.63B4.95B16.41B22.47B87.70B295.00M1.12B2.43B539.00M2.37B70.16B
2024-06-30976.00M4.34B24.88B1.78B7.27B1.24004.81001.934815.69694.66B20.30B44.25B1.06B3.12B31.64B4.69B38.02B5.63B24.64B5.75B19.50B3.44B14.91B22.45B86.58B341.00M1.12B2.42B136.00M2.75B71.54B
2024-03-31807.00M4.49B25.47B1.81B7.42B1.19004.76001.339515.83312.85B18.70B36.62B459.00M2.99B25.08B3.25B38.48B3.66B23.19B3.71B20.06B3.54B15.17B21.38B85.65B302.00M1.16B2.43B1.48B2.99B70.02B
2023-12-311.59B4.54B21.86B1.84B7.49B1.19004.70001.581413.72956.27B18.25B36.56B694.00M1.74B27.35B4.05B35.15B7.86B22.79B4.83B15.06B4.48B15.09B21.39B85.16B178.00M1.16B2.56B216.00M5.05B68.77B
2023-10-01967.00M4.54B19.73B1.83B7.42B1.19004.640010.208313.57966.52B15.74B36.12B908.00M1.66B26.05B26.03B34.62B7.49B20.28B5.22B14.08B3.45B14.31B21.35B83.70B296.00M1.20B2.55B920.00M6.16B71.23B
2023-07-021.12B4.53B21.18B1.93B7.27B1.19004.58001.95914.97163.06B14.55B45.44B930.00M1.61B33.90B5.14B13.05B4.18B19.07B6.31B14.03B3.70B14.35B21.52B82.35B382.00M1.18B2.63B381.00M7.40B75.15B
2023-04-02863.00M4.26B19.17B1.88B7.08B1.13004.5200-0.02614.88352.39B16.21B45.58B-796.00M1.71B34.93B-68.00M12.72B3.26B20.47B-1.29B12.87B3.46B14.35B20.89B81.04B306.00M1.17B2.61B3.54B8.00B70.87B
2023-01-011.59B4.01B12.89B1.77B6.97B1.13004.45001.32146.73493.76B17.18B36.05B613.00M3.21B28.44B3.52B17.94B5.35B21.19B3.84B19.36B3.71B14.36B19.94B79.99B213.00M1.14B2.66B1.32B6.04B76.80B
2022-10-02952.00M3.84B11.36B1.69B7.04B1.13004.38001.67517.19845.33B17.74B33.38B862.00M2.18B27.60B4.46B19.16B6.28B21.58B5.17B16.76B3.48B14.93B20.00B69.82B281.00M1.14B2.66B2.17B5.71B74.60B
Copy table — 8 periods, ~4,025 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,OperatingIncomeLoss,OperatingIncomeLoss_TTM,PretaxIncome,PretaxIncome_TTM,ResearchAndDevelopment,ResearchAndDevelopment_TTM,Revenue,Revenue_TTM,ShareBasedCompensation,ShareBasedCompensation_TTM,SharesOutstanding,StockIssued,StockIssued_TTM,StockRepurchased,StockRepurchased_TTM,StockholdersEquity
2026-06-28,1321000000.0,5364000000.0,20422000000.0,1959000000.0,7751000000.0,1.34,5.24,2.2679398385312077,8.621367976722265,7295000000.0,22244000000.0,48479000000.0,1213000000.0,4159000000.0,37344000000.0,5534000000.0,21037000000.0,8616000000.0,27608000000.0,,,6747000000.0,25196000000.0,3653000000.0,15104000000.0,25310000000.0,97929000000.0,458000000.0,1414000000.0,2440100000.0,,,221000000.0,8075000000.0,84971000000.0
2026-03-29,1049000000.0,5086000000.0,21688000000.0,2004000000.0,7735000000.0,1.3,5.199999999999999,2.140929167348274,8.60461311958122,1465000000.0,17784000000.0,48558000000.0,755000000.0,3900000000.0,37527000000.0,5235000000.0,21040000000.0,2514000000.0,22870000000.0,,,5990000000.0,24940000000.0,3527000000.0,14967000000.0,24062000000.0,96362000000.0,300000000.0,1366000000.0,2445200000.0,,,4028000000.0,7854000000.0,81186000000.0
2025-12-28,1837000000.0,4832000000.0,19709000000.0,2011000000.0,7503000000.0,1.2999999999999998,5.14,2.105869762081172,11.033176916110975,5472000000.0,19698000000.0,48772000000.0,-150000000.0,5777000000.0,41438000000.0,5116000000.0,26804000000.0,7309000000.0,24530000000.0,,,4966000000.0,32581000000.0,4252000000.0,14665000000.0,24564000000.0,94193000000.0,309000000.0,1354000000.0,2429400000.0,,,1924000000.0,5953000000.0,81544000000.0
2025-09-28,1157000000.0,4607000000.0,18231000000.0,1777000000.0,7388000000.0,1.3,5.08,2.1213868072140327,10.342995964753356,8012000000.0,19597000000.0,48048000000.0,2341000000.0,6383000000.0,39408000000.0,5152000000.0,25119000000.0,9169000000.0,24204000000.0,,,7493000000.0,31502000000.0,3672000000.0,15711000000.0,23993000000.0,92149000000.0,347000000.0,1283000000.0,2428600000.0,,,1902000000.0,4311000000.0,79277000000.0
2025-06-29,1043000000.0,4479000000.0,18577000000.0,1943000000.0,7457000000.0,1.3,5.02,2.2888677607374643,9.367533380182712,2835000000.0,18549000000.0,48117000000.0,954000000.0,4686000000.0,39235000000.0,5537000000.0,22661000000.0,3878000000.0,23028000000.0,,,6491000000.0,27347000000.0,3516000000.0,16991000000.0,23743000000.0,90627000000.0,410000000.0,1231000000.0,2419100000.0,,,0.0,2948000000.0,78473000000.0
2025-03-30,795000000.0,4412000000.0,38474000000.0,1772000000.0,7296000000.0,1.24,4.96,4.537915669609704,8.998267183761037,3379000000.0,20371000000.0,44468000000.0,2632000000.0,4794000000.0,38355000000.0,10999000000.0,21810000000.0,4174000000.0,24783000000.0,,,13631000000.0,26604000000.0,3225000000.0,16915000000.0,21893000000.0,89331000000.0,288000000.0,1162000000.0,2423800000.0,,,2127000000.0,3084000000.0,78109000000.0
2024-12-29,1612000000.0,4424000000.0,24105000000.0,1896000000.0,7339000000.0,1.2400000000000002,4.91,1.412282868197909,5.789906972915123,5371000000.0,19842000000.0,44200000000.0,456000000.0,2621000000.0,32400000000.0,3431000000.0,14066000000.0,6983000000.0,24266000000.0,,,3887000000.0,16687000000.0,5298000000.0,17232000000.0,22520000000.0,88821000000.0,238000000.0,1176000000.0,2429400000.0,,,282000000.0,2432000000.0,71490000000.0
2024-09-29,1029000000.0,4401000000.0,19980000000.0,1846000000.0,7286000000.0,1.24,4.86,1.109600889657729,6.048025042217554,6964000000.0,20745000000.0,44799000000.0,644000000.0,2859000000.0,31289000000.0,2694000000.0,14684000000.0,7993000000.0,25146000000.0,,,3338000000.0,17626000000.0,4952000000.0,16414000000.0,22471000000.0,87696000000.0,295000000.0,1116000000.0,2427900000.0,,,539000000.0,2366000000.0,70158000000.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

Calculated metrics for the selected ticker
enddebt_to_equityeffective_tax_ratefcf_marginfcf_margin_quarterlyincome_yoy_growthpayout_ratiopayout_ratio_quarterlyrevenue_yoy_growthroerotce
2026-06-280.43950.165122.71%0.2882-7.17%60.78%0.59088.06%24.76%0.5765
2026-03-290.46220.156418.46%0.0609-3.53%60.43%0.60727.87%25.92%0.6448
2025-12-280.50820.177320.91%0.222890.56%46.59%0.61736.05%32.87%0.8179
2025-09-280.49710.202621.27%0.333971.06%49.12%0.61285.08%31.69%0.8043
2025-06-290.50000.171420.47%0.1194-40.39%53.59%0.56804.68%28.88%0.7465
2025-03-300.49100.180222.80%0.1543-43.32%55.12%0.27334.30%27.92%0.6483
2024-12-290.45320.157122.34%0.2385-59.99%84.80%0.87804.30%19.68%0.5154
2024-09-290.44600.162223.66%0.3099-57.59%80.36%1.11754.77%20.93%0.5790
2024-06-300.44220.160123.45%0.2075191.24%30.64%0.64095.13%53.14%1.3932
2024-03-310.35820.149121.84%0.1333202.39%30.06%0.88845.68%54.95%1.1518
2023-12-310.39770.115321.43%0.293295.94%34.23%0.75256.46%51.11%1.0912
2023-10-010.36570.117618.80%0.305580.74%34.17%0.116619.88%48.61%0.9863
2023-07-020.45110.114717.67%0.1421-28.92%92.12%0.607412.56%17.37%0.4394
2023-04-020.49290.132520.00%0.1146-35.83%92.56%6.27%17.95%0.5030
2023-01-010.37030.166021.48%0.1887-14.07%66.07%0.85521.59%23.36%0.4402
2022-10-020.37000.130125.41%0.26677.14%60.85%0.6746-23.65%25.68%0.4648
Copy table — 8 periods, ~1,800 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-28,0.4394911204999353,0.16506588347356724,0.22714415545956765,0.2882259976293955,-0.07166497506729619,0.6077921756904502,0.5908445970365017,0.0805720149624285,0.24757858563509905,0.5764825167159926
2026-03-29,0.4622348680807036,0.15637530072173217,0.1845540773333887,0.06088438201313274,-0.03530490600641911,0.6043269961977186,0.6072129894937918,0.0787072796677526,0.25915798290345626,0.6448449184749295
2025-12-28,0.5081673697635632,0.177311930266106,0.2091238202414192,0.22276502198339032,0.9055879425565192,0.4658676316967616,0.6173221266614543,0.06048119251078021,0.3287059746885117,0.8178933235689003
2025-09-28,0.49709247322678707,0.20262205574249254,0.2126664423922126,0.33393072979619054,0.7106374284935986,0.4911536287272582,0.6128066770186336,0.05077768655354853,0.3168510412856188,0.8043485222069231
2025-06-29,0.49998088514520916,0.17135334771638572,0.20467410374391737,0.11940361369666849,-0.40394023883423646,0.535893473368342,0.5679664078020589,0.046791258547403514,0.2887744829431779,0.7465081038344973
2025-03-30,0.4910445659271019,0.18019846639603068,0.22803953834615084,0.15434157036495683,-0.43315313442145753,0.5512172397982577,0.2732532048368034,0.04300158789463859,0.2792251853179531,0.6483160429238132
2024-12-29,0.45321023919429293,0.1570683765805717,0.2233931164927213,0.23849911190053286,-0.5998634540437515,0.8480274420588654,0.878011075488196,0.04300191406662823,0.19675479087984332,0.5154268962990106
2024-09-29,0.4459790758003364,0.16220356291841598,0.23655582922824303,0.30991055137733076,-0.5759011090573013,0.8035681013347863,1.1175189309576836,0.047704383355435365,0.20929901080418484,0.5790449150203084

Quality flags

Distortion of data.

Quality flags, how often and how recently
flagraisedperiods evaluatedmost recent
buyback_distortion_flag1682017-12-31
fcf_exceeds_ebitda014
inorganic_contaminated5682024-06-30
low_tax_rate_flag6672022-07-03
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-280000
2026-03-290000
2025-12-280000
2025-09-280000
2025-06-290000
2025-03-300000
2024-12-290000
2024-09-290000
2024-06-300100
2024-03-310000
2023-12-310000
2023-10-010000
2023-07-020000
2023-04-020100
2023-01-010000
2022-10-020000

Valuation history

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

16 of 75 periods · 9 concepts

Valuation history for the selected ticker
endbuyback_distortion_flagdividend_yieldev_fcfev_salespb_ratiope_ratiope_to_revenue_growthpfcf_ex_sbcpfcf_ratio
2026-06-280.00002.07%28.55916.48707.277129.39333.648129.685427.7983
2026-03-290.00002.19%33.60086.20127.165227.64823.512835.431732.7102
2025-12-280.00002.52%26.30525.50116.087918.52083.062227.062325.2021
2025-09-280.00002.89%22.86074.86175.384016.99213.346423.305921.7801
2025-06-290.00003.39%20.41084.17764.561315.79553.375720.668819.2971
2025-03-300.00003.15%18.74404.27444.890017.51284.072619.884118.7498
2024-12-290.00003.54%17.37733.88204.707023.92335.563318.027716.9593
2024-09-290.00003.18%18.43994.36215.291325.28105.299518.912217.8948
2024-06-300.00003.50%16.72603.92244.65258.75461.705117.347616.3932
2024-03-310.00003.23%19.14784.18155.12049.31831.640320.433819.1687
2023-12-310.00003.24%20.65784.42665.401410.56731.635321.741420.3569
2023-10-010.00003.24%23.57424.43225.119710.53210.529725.080023.1724
2023-07-020.00003.04%28.11104.96595.272430.35192.417429.645627.2368
2023-04-020.00003.22%23.51934.70335.156328.71894.577024.294922.5470
2023-01-010.00002.80%25.50495.47955.504323.563626.344824.6002
2022-10-020.00003.00%22.79225.79085.202020.257023.378721.8762
Copy table — 8 periods, ~1,436 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-28,0.0,0.020677936239736634,28.559082627429355,6.487028704107451,7.277144366484313,29.39327061674852,3.6480744127418037,29.68536888932014,27.798338157010367
2026-03-29,0.0,0.021857762834237338,33.60078474002758,6.201161825373595,7.165242231624299,27.648163299270458,3.5127834955015316,35.4316820451121,32.710152711237654
2025-12-28,0.0,0.025153751452096838,26.30523693213694,5.501051639604147,6.087898031605433,18.520801264334928,3.062241416789817,27.062339570935094,25.202130017729385
2025-09-28,0.0,0.028904799568671747,22.86073856126984,4.861711940283726,5.3839687877342115,16.992113284175527,3.3463740547250387,23.305934999738184,21.780113975874116
2025-06-29,0.0,0.033926950019346126,20.4108064486451,4.177563516567005,4.561340191096529,15.795509854636512,3.375739474635913,20.668786743037185,19.297107596954984
2025-03-30,0.0,0.031475188366852085,18.744007209057624,4.274374750710424,4.890002059374885,17.51275428040866,4.072583162119029,19.884073655875522,18.749848846679736
2024-12-29,0.0,0.03544770968156282,17.377312439721553,3.8819719821771326,4.707030821498882,23.923335235955857,5.563318692951306,18.0277313526709,16.95925982405781
2024-09-29,0.0,0.03178542170614102,18.43989390555506,4.362064393709402,5.291293923297981,25.281026904844712,5.299518645169581,18.91215034238829,17.89475049750493

Current snapshot

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

Current snapshot for JNJ
conceptavg_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_filingdebtdividend_yielddividends_ttmeps_ttmequityevev_fcfev_salesfcf_ttmfiling_likely_overduefundamentals_stalemarket_capp_ffo_band_elevatedp_tbv_band_elevatedpb_ratiope_ratiope_ratio_band_elevatedpe_to_revenue_growthpfcf_ex_sbcpfcf_ratiopfcf_ratio_band_elevatedpricerevenue_ttmshares_basisshares_delta_pctshares_outstandingshares_source_is_edgaryoy_growth
value17.62230.00000.000020.878220.86520.00000.000021.213120.42B-42.000082.000037.34B1.94%5.24008.621484.97B668.12B30.03626.822522.24B0.00000.0000651.20B0.00000.00007.663831.34310.00003.890131.262729.27540.0000270.220097.93B0.00001.25322.41B0.00000.0806
Copy table — ~1,071 characters
concept,value
avg_pe_5y,17.622303340583763
avg_pe_5y_diverges,0.0
avg_pe_5y_history_too_short,0.0
avg_pe_5y_median,20.87815007246047
avg_pfcf_5y,20.865234757935628
avg_pfcf_5y_diverges,0.0
avg_pfcf_5y_history_too_short,0.0
avg_pfcf_5y_median,21.213102125827923
cash,20422000000.0
days_past_expected_filing,-42.0
days_since_last_filing,82.0
debt,37344000000.0
dividend_yield,0.01939160683887203
dividends_ttm,5.24
eps_ttm,8.621367976722265
equity,84971000000.0
ev,668124798881.3401
ev_fcf,30.036180492777383
ev_sales,6.822542851263059
fcf_ttm,22244000000.0
filing_likely_overdue,0.0
fundamentals_stale,0.0
market_cap,651202798881.3401
p_ffo_band_elevated,0.0
p_tbv_band_elevated,0.0
pb_ratio,7.663824115066789
pe_ratio,31.3430537624186
pe_ratio_band_elevated,0.0
pe_to_revenue_growth,3.8900670135945044
pfcf_ex_sbc,31.262736384125784
pfcf_ratio,29.27543602235839
pfcf_ratio_band_elevated,0.0
price,270.22
revenue_ttm,97929000000.0
shares_basis,0.0
shares_delta_pct,1.253222979489539
shares_outstanding,2409898597.0
shares_source_is_edgar,0.0
yoy_growth,0.0805720149624285