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

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

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

Raw & derived facts for the selected ticker
endCapexCapex_TTMCashAndEquivalentsDepreciationAndAmortizationDepreciationAndAmortization_TTMDividendsPerShareDividendsPerShare_TTMEPS_QUARTERLY_CALCEPS_TTM_CALCFCF_QUARTERLYFCF_TTMGoodwillIncomeTaxExpenseIncomeTaxExpense_TTMLongTermDebtNetIncomeLossNetIncomeLoss_TTMOperatingCashFlowOperatingCashFlow_TTMPretaxIncomePretaxIncome_TTMResearchAndDevelopmentResearchAndDevelopment_TTMRevenueRevenue_TTMShareBasedCompensationShareBasedCompensation_TTMSharesOutstandingStockIssuedStockIssued_TTMStockRepurchasedStockRepurchased_TTMStockholdersEquity
2026-06-30893.00M3.90B6.85B599.00M3.21B0.85003.3600-0.54051.28464.48B16.06B21.58B654.00M2.78B53.90B-1.33B3.17B5.37B19.97B-683.00M5.95B9.74B30.45B16.61B66.57B298.00M892.00M2.47B43.00M261.00M757.00M4.21B41.93B
2026-03-31991.00M3.77B5.33B581.00M3.12B0.85003.3200-1.71523.61452.93B14.12B21.58B709.00M2.70B49.10B-4.24B8.94B3.92B17.89B-3.53B11.63B12.59B24.76B16.29B65.77B185.00M810.00M2.47B157.00M230.00M874.00M4.79B45.88B
2025-12-311.03B4.11B14.56B1.49B3.04B0.85003.28001.18197.28121.82B12.36B21.58B458.00M2.81B49.30B2.96B18.25B2.86B16.47B3.42B21.07B3.89B15.79B16.40B65.01B205.00M820.00M2.51B47.00M92.00M1.25B5.08B52.61B
2025-09-30987.00M4.02B18.17B532.00M2.07B0.81003.24002.31597.61976.83B13.05B21.59B958.00M2.77B41.40B5.79B19.03B7.82B17.07B6.75B21.82B4.23B16.49B17.28B64.23B204.00M802.00M2.50B14.00M57.00M1.32B4.32B51.85B
2025-06-30764.00M3.81B8.01B518.00M2.10B0.81003.20001.76166.52852.53B14.72B21.59B571.00M2.74B35.40B4.43B16.41B3.29B18.53B5.00B19.16B4.05B18.11B15.81B63.62B216.00M793.00M2.51B12.00M48.00M1.34B3.44B48.99B
2025-03-311.33B3.84B8.63B502.00M2.10B0.81003.16002.00676.88821.17B17.04B21.68B818.00M2.72B34.80B5.08B17.43B2.50B20.88B5.90B20.17B3.62B17.57B15.53B63.92B195.00M780.00M2.53B19.00M109.00M1.16B2.35B48.34B
2024-12-31937.00M3.37B13.24B522.00M2.10B0.81003.12001.47306.73632.51B18.10B21.67B426.00M2.80B37.10B3.74B17.12B3.45B21.47B4.17B19.94B4.58B17.94B15.62B64.17B187.00M761.00M2.54B12.00M177.00M489.00M1.31B46.31B
2024-09-30783.00M3.42B14.59B553.00M2.08B0.77003.08001.24244.78088.51B14.84B21.70B929.00M1.56B38.10B3.16B12.15B9.29B18.26B4.09B13.72B5.86B22.98B16.66B63.17B195.00M741.00M2.54B5.00M171.00M444.00M1.21B44.50B
2024-06-30791.00M3.54B11.30B518.00M1.98B0.77003.04002.14435.39944.85B13.15B21.16B545.00M1.50B37.80B5.46B13.74B5.64B16.69B6.01B15.25B3.50B20.43B16.11B62.48B203.00M710.00M2.54B73.00M173.00M251.00M1.23B43.58B
2024-03-31861.00M3.72B5.58B511.00M1.89B0.77003.00001.87190.90642.23B11.04B21.18B903.00M1.59B34.20B4.76B2.31B3.09B14.76B5.67B3.91B3.99B30.25B15.78B61.40B176.00M676.00M2.54B87.00M182.00M122.00M1.32B40.36B
2023-12-31989.00M3.86B6.84B502.00M1.83B0.77002.9600-0.48140.1433-743.00M9.14B21.20B-820.00M1.51B35.10B-1.23B365.00M246.00M13.01B-2.05B1.89B9.63B30.53B14.63B60.11B167.00M645.00M2.55B6.00M125.00M393.00M1.35B37.58B
2023-09-30902.00M4.02B8.61B452.00M1.76B0.73002.92001.86371.80996.82B13.17B21.18B870.00M2.83B34.90B4.75B4.61B7.72B17.19B5.62B7.45B3.31B24.68B15.96B59.31B164.00M623.00M2.55B7.00M384.00M466.00M953.00M41.25B
2023-06-30965.00M4.25B5.66B426.00M1.80B0.73002.8800-2.35331.22532.74B10.83B21.20B637.00M2.29B36.90B-5.97B3.11B3.70B15.07B-5.33B5.41B13.32B25.77B15.04B58.31B169.00M598.00M2.54B82.00M387.00M338.00M487.00M38.69B
2023-03-311.01B4.41B9.71B448.00M1.85B0.73002.84001.10585.1078332.00M11.26B21.21B825.00M2.19B30.70B2.82B13.03B1.34B15.67B3.65B15.23B4.28B15.25B14.49B57.87B145.00M566.00M2.55B30.00M402.00M149.00M149.00M46.83B
2022-12-311.15B4.39B12.69B430.00M1.82B0.73002.80001.18695.71163.28B14.71B21.20B495.00M1.92B30.70B3.02B14.52B4.43B19.09B3.51B16.44B3.77B13.55B13.83B59.28B145.00M541.00M2.54B265.00M384.00M0.000.0045.99B
2022-09-301.13B4.45B11.14B499.00M1.82B0.69002.76001.27775.72624.48B15.31B21.16B330.00M1.51B30.40B3.25B14.56B5.60B19.76B3.58B16.84B4.40B12.84B14.96B58.97B139.00M515.00M2.54B10.00M253.00M0.0018.00M44.46B
Copy table — 8 periods, ~4,105 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,StockIssued_TTM,StockRepurchased,StockRepurchased_TTM,StockholdersEquity
2026-06-30,893000000.0,3904000000.0,6849000000.0,599000000.0,3205000000.0,0.85,3.3599999999999994,-0.5404858299595142,1.2846153846153847,4477000000.0,16063000000.0,21582000000.0,654000000.0,2779000000.0,53900000000.0,-1335000000.0,3173000000.0,5370000000.0,19967000000.0,-683000000.0,5948000000.0,9741000000.0,30453000000.0,16607000000.0,66569000000.0,298000000.0,892000000.0,2470000000.0,43000000.0,261000000.0,757000000.0,4206000000.0,41933000000.0
2026-03-31,991000000.0,3775000000.0,5327000000.0,581000000.0,3124000000.0,0.85,3.32,-1.715210355987055,3.6144822006472492,2927000000.0,14115000000.0,21581000000.0,709000000.0,2696000000.0,49100000000.0,-4240000000.0,8935000000.0,3918000000.0,17890000000.0,-3534000000.0,11630000000.0,12592000000.0,24760000000.0,16286000000.0,65768000000.0,185000000.0,810000000.0,2472000000.0,157000000.0,230000000.0,874000000.0,4794000000.0,45878000000.0
2025-12-31,1033000000.0,4112000000.0,14565000000.0,1493000000.0,3045000000.0,0.8499999999999996,3.28,1.1818907060231352,7.281212604706821,1824000000.0,12360000000.0,21579000000.0,458000000.0,2805000000.0,49300000000.0,2963000000.0,18254000000.0,2857000000.0,16472000000.0,3420000000.0,21067000000.0,3886000000.0,15789000000.0,16400000000.0,65011000000.0,205000000.0,820000000.0,2507000000.0,47000000.0,92000000.0,1252000000.0,5084000000.0,52606000000.0
2025-09-30,987000000.0,4016000000.0,18169000000.0,532000000.0,2074000000.0,0.81,3.24,2.3158526821457164,7.619695756605284,6835000000.0,13049000000.0,21587000000.0,958000000.0,2773000000.0,41400000000.0,5785000000.0,19034000000.0,7822000000.0,17065000000.0,6745000000.0,21817000000.0,4234000000.0,16487000000.0,17276000000.0,64235000000.0,204000000.0,802000000.0,2498000000.0,14000000.0,57000000.0,1323000000.0,4321000000.0,51850000000.0
2025-06-30,764000000.0,3812000000.0,8007000000.0,518000000.0,2095000000.0,0.81,3.2,1.7616394747313968,6.528452049343414,2529000000.0,14722000000.0,21591000000.0,571000000.0,2744000000.0,35400000000.0,4427000000.0,16406000000.0,3293000000.0,18534000000.0,4999000000.0,19162000000.0,4048000000.0,18115000000.0,15806000000.0,63616000000.0,216000000.0,793000000.0,2513000000.0,12000000.0,48000000.0,1345000000.0,3442000000.0,48993000000.0
2025-03-31,1328000000.0,3839000000.0,8629000000.0,502000000.0,2095000000.0,0.81,3.16,2.0067167127617545,6.888186487554326,1172000000.0,17039000000.0,21684000000.0,818000000.0,2718000000.0,34800000000.0,5079000000.0,17434000000.0,2500000000.0,20878000000.0,5903000000.0,20169000000.0,3621000000.0,17567000000.0,15529000000.0,63922000000.0,195000000.0,780000000.0,2531000000.0,19000000.0,109000000.0,1164000000.0,2348000000.0,48335000000.0
2024-12-31,937000000.0,3372000000.0,13242000000.0,522000000.0,2104000000.0,0.81,3.12,1.4730421094057458,6.736324281778828,2513000000.0,18096000000.0,21668000000.0,426000000.0,2803000000.0,37100000000.0,3743000000.0,17117000000.0,3450000000.0,21468000000.0,4170000000.0,19936000000.0,4584000000.0,17938000000.0,15624000000.0,64168000000.0,187000000.0,761000000.0,2541000000.0,12000000.0,177000000.0,489000000.0,1306000000.0,46313000000.0
2024-09-30,783000000.0,3424000000.0,14593000000.0,553000000.0,2084000000.0,0.77,3.08,1.2424242424242424,4.780794962613144,8508000000.0,14840000000.0,21697000000.0,929000000.0,1557000000.0,38100000000.0,3157000000.0,12148000000.0,9291000000.0,18264000000.0,4090000000.0,13720000000.0,5862000000.0,22981000000.0,16657000000.0,63174000000.0,195000000.0,741000000.0,2541000000.0,5000000.0,171000000.0,444000000.0,1210000000.0,44502000000.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-301.28540.467224.13%0.2696-80.66%261.56%4.64%7.57%0.1559
2026-03-311.07020.231821.46%0.1797-48.75%91.85%2.89%19.48%0.3677
2025-12-310.93720.133119.01%0.11126.64%45.05%0.71921.31%34.70%0.5883
2025-09-300.79850.127120.31%0.395656.68%42.52%0.34981.68%36.71%0.6290
2025-06-300.72260.143223.14%0.160019.44%49.02%0.45981.82%33.49%0.5987
2025-03-310.72000.134826.66%0.0755656.03%45.88%0.40364.10%36.07%0.6542
2024-12-310.80110.140628.20%0.16084589.59%46.32%0.54996.74%36.96%0.6945
2024-09-300.85610.113523.49%0.5108163.63%64.42%0.61986.51%27.30%0.5327
2024-06-300.86730.098221.04%0.3008341.53%56.30%0.35917.15%31.52%0.6126
2024-03-310.84730.406817.98%0.1413-82.30%330.96%0.41146.11%5.71%0.1202
2023-12-310.93400.800415.21%-0.0508-97.49%2065.51%1.40%0.97%0.0223
2023-09-300.84610.379622.20%0.4270-68.34%161.34%0.39170.58%11.17%0.2297
2023-06-300.95370.422718.57%0.1822-80.40%235.05%2.00%8.04%0.1778
2023-03-310.65550.143619.46%0.0229-3.31%55.60%0.66017.21%27.82%0.5085
2022-12-310.66750.116624.81%0.237217.61%49.02%0.615121.72%31.57%0.5858
2022-09-300.68380.089525.97%0.2992102.25%48.20%0.540027.84%32.74%0.6248
Copy table — 8 periods, ~1,761 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.2853838265804975,0.4672158708809684,0.2412985023058781,0.26958511471066415,-0.8065951481165428,2.6155688622754485,,0.04641913983903412,0.07566832804712278,0.15591371431379294
2026-03-31,1.07022973974454,0.23181427343078245,0.21461805133195475,0.17972491710671742,-0.4874956980612596,0.9185271404588695,,0.02887894621570042,0.19475565630585465,0.36774087335885086
2025-12-31,0.9371554575523704,0.1331466274267812,0.19012167171709404,0.11121951219512195,0.06642519133025648,0.45047441656623205,0.7191866351670602,0.013137389352948503,0.34699463939474584,0.5883262964514777
2025-09-30,0.7984570877531341,0.12710271806389511,0.2031447030435121,0.39563556378791387,0.5668422785643727,0.4252138278869392,0.34976318063958517,0.01679488397125395,0.3670973963355834,0.6289528467105046
2025-06-30,0.7225522013348846,0.14320008349859095,0.23141976861167002,0.16000253068455017,0.19437973209085624,0.49016213580397416,0.4597989609216174,0.01819811456649445,0.33486416426836485,0.5987154222319538
2025-03-31,0.7199751732698872,0.13476126729138777,0.26655924407872095,0.07547169811320754,6.560277536860364,0.4587564529081106,0.4036444181925576,0.041041008436207393,0.360691010654805,0.6541593185996774
2024-12-31,0.8010709735927277,0.14059991974317818,0.2820097244732577,0.16084229390681004,45.895890410958906,0.4631606005725302,0.5498824472348384,0.0674385334531058,0.3695938505387256,0.6945425035504159
2024-09-30,0.8561412970203587,0.11348396501457726,0.2349067654414791,0.5107762502251306,1.6362847222222223,0.6442443200526836,0.6197560975609756,0.06507738476582259,0.27297649543840724,0.5326901995176496

Quality flags

Distortion of data.

Quality flags, how often and how recently
flagraisedperiods evaluatedmost recent
buyback_distortion_flag2682023-06-30
inorganic_contaminated2682015-03-31
low_tax_rate_flag2592024-06-30
share_count_jump_flag2682010-03-31
Per-period flag values
Quality flags per period
endbuyback_distortion_flaginorganic_contaminatedlow_tax_rate_flagshare_count_jump_flag
2026-06-300000
2026-03-310000
2025-12-310000
2025-09-300000
2025-06-300000
2025-03-310000
2024-12-310000
2024-09-300000
2024-06-300010
2024-03-310000
2023-12-310000
2023-09-300000
2023-06-301000
2023-03-310000
2022-12-310000
2022-09-300010

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-300.00002.63%22.57265.44677.524799.442921.422820.798419.6434
2026-03-310.00002.80%23.89475.12826.397432.848511.374522.059520.7936
2025-12-310.00003.18%23.72864.51134.914814.164022.404720.9183
2025-09-300.00003.97%17.38893.53253.928210.700716.630715.6086
2025-06-300.00004.20%14.85923.43873.905911.664313.738512.9985
2025-03-310.00003.70%14.23493.79444.476612.41123.024113.308112.6989
2024-12-310.00003.32%14.50884.09165.153913.94482.067813.769413.1904
2024-09-300.00002.90%19.79924.65106.074222.25173.419319.172518.2152
2024-06-300.00002.64%24.30755.11496.724721.33632.985023.564822.2922
2024-03-310.00002.46%30.71855.52317.6928134.653622.055729.960528.1260
2023-12-310.00002.95%31.00664.71596.7916699.273130.034727.9159
2023-09-300.00003.11%20.16354.47605.799351.909119.068718.1664
2023-06-301.00002.75%27.40985.08986.863185.359425.958324.5247
2023-03-310.00002.96%23.56234.58555.217718.75412.601722.846421.6982
2022-12-310.00002.82%18.37174.55775.483417.36940.799717.802317.1474
2022-09-300.00003.61%13.95653.62394.374013.35950.479913.141012.6990
Copy table — 8 periods, ~1,385 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,0.026302205529459173,22.572587603212984,5.446731581823524,7.524681627129234,99.44294821002525,21.42283302854378,20.79839659023203,19.643433646915902
2026-03-31,0.0,0.027962531564425356,23.894744788726257,5.12824356363081,6.397430635443373,32.84849722360057,11.37454842647342,22.05947558758896,20.793575819544532
2025-12-31,0.0,0.03180411237829595,23.72857702804615,4.511316732039968,4.914842642790754,14.16403046272874,,22.404697752742667,20.918301947139998
2025-09-30,0.0,0.03973715497754387,17.388871414450012,3.532457119750264,3.9281848232817396,10.700661084751403,,16.630716345811887,15.6085817370801
2025-06-30,0.0,0.042022517186755315,14.85919521069044,3.4387115174136174,3.9059472147405683,11.664273551858141,,13.738536283421974,12.998510521110221
2025-03-31,0.0,0.036963131155334346,14.234854790363887,3.794432132489757,4.476604753760427,12.411190247390746,3.0240948554376375,13.308118012978058,12.69890784512062
2024-12-31,0.0,0.03321384260972367,14.508800224958533,4.091622753878095,5.153914643207083,13.944806266918828,2.067780177428609,13.769440373282354,13.190387316028383
2024-09-30,0.0,0.028952645311416725,19.799199725354136,4.650965965812762,6.07417922619782,22.2516565627474,3.419261029437303,19.172503292733907,18.215170075758447

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 MRK
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
value19.43420.00000.000018.061817.73960.00000.000018.82116.85B-54.000080.000053.90B2.28%3.36001.284641.93B410.10B25.53046.160516.06B0.00000.0000363.04B0.00000.00008.6577114.54790.000024.676923.930222.60130.0000147.150066.57B0.00000.11462.47B0.00000.0464
Copy table — ~1,083 characters
concept,value
avg_pe_5y,19.43418890466131
avg_pe_5y_diverges,0.0
avg_pe_5y_history_too_short,0.0
avg_pe_5y_median,18.061752405670696
avg_pfcf_5y,17.73959460473846
avg_pfcf_5y_diverges,0.0
avg_pfcf_5y_history_too_short,0.0
avg_pfcf_5y_median,18.821102149283007
cash,6849000000.0
days_past_expected_filing,-54.0
days_since_last_filing,80.0
debt,53900000000.0
dividend_yield,0.022833843017329252
dividends_ttm,3.3599999999999994
eps_ttm,1.2846153846153847
equity,41933000000.0
ev,410095306531.7
ev_fcf,25.53043058779182
ev_sales,6.160454664058346
fcf_ttm,16063000000.0
filing_likely_overdue,0.0
fundamentals_stale,0.0
market_cap,363044306531.7
p_ffo_band_elevated,0.0
p_tbv_band_elevated,0.0
pb_ratio,8.657723190129493
pe_ratio,114.54790419161677
pe_ratio_band_elevated,0.0
pe_to_revenue_growth,24.676869194222505
pfcf_ex_sbc,23.930150058117462
pfcf_ratio,22.60127663149474
pfcf_ratio_band_elevated,0.0
price,147.15
revenue_ttm,66569000000.0
shares_basis,0.0
shares_delta_pct,0.11463985546999872
shares_outstanding,2467171638.0
shares_source_is_edgar,0.0
yoy_growth,0.04641913983903412