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

MS is covered here under the financial profile. Every figure below is computed from MS's own SEC EDGAR XBRL filings, as of 2026-09-18. Trailing-twelve-month revenue is 78.04B; year-over-year revenue growth is 18.00%. MS trades at a P/TBV of 3.2214, on a market capitalisation of 319.64B.

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

Raw & derived facts for the selected ticker
endAssetsCashAndEquivalentsDepreciationAndAmortizationDepreciationAndAmortization_TTMDividendsPerShareDividendsPerShare_TTMEPS_QUARTERLY_CALCEPS_TTM_CALCGoodwillIncomeTaxExpenseIncomeTaxExpense_TTMLongTermDebtNetIncomeLossNetIncomeLoss_TTMNetInterestIncomeNetInterestIncome_TTMNoninterestExpenseNoninterestExpense_TTMNoninterestIncomeNoninterestIncome_TTMOperatingCashFlowOperatingCashFlow_TTMPPNRPPNR_QUARTERLYPretaxIncomePretaxIncome_TTMProvisionForCreditLossesProvisionForCreditLosses_TTMRevenueRevenue_TTMSharesOutstandingStockIssuedStockIssued_TTMStockRepurchasedStockRepurchased_TTMStockholdersEquityTangibleEquity
2026-06-301.68T160.13B1.20B4.40B1.00004.00003.557012.845817.11B1.70B5.78B383.16B5.58B20.16B2.78B10.83B13.90B51.68B18.57B67.21B-2.75B-15.59B26.36B7.45B7.35B26.15B21.35B78.04B1.57B1.50B5.83B116.33B99.22B
2026-03-311.58T133.53B714.00M4.51B1.00003.92503.532411.493017.11B1.37B5.13B363.01B5.57B18.11B2.70B10.40B13.47B49.75B17.88B63.09B-7.10B-1.01B23.73B7.11B7.01B23.42B20.58B73.49B1.58B1.75B5.33B114.29B97.18B
2025-12-311.42T111.69B1.14B4.66B1.00003.85002.761910.591116.73B1.34B4.93B341.68B4.40B16.86B2.85B10.05B12.11B48.34B15.04B60.60B-2.41B-17.89B22.30B5.78B5.76B21.95B17.89B70.64B1.59B1.50B4.58B111.63B94.91B
2025-09-301.36T103.73B1.35B5.17B1.00003.77502.899410.174816.73B1.37B4.78B324.13B4.61B16.18B2.49B9.74B12.20B47.43B15.73B59.23B-3.33B-3.68B21.55B6.03B6.03B21.10B18.22B68.98B1.59B1.08B3.83B109.96B93.24B
2025-06-301.35T109.13B1.31B5.09B0.92503.70002.22169.263016.73B1.05B4.40B320.13B3.54B14.76B2.35B9.45B11.97B46.32B14.45B56.69B11.83B-17.67B19.82B4.82B4.62B19.29B16.79B66.14B1.59B1.00B3.50B108.18B91.45B
2025-03-311.30T90.74B865.00M5.05B0.92503.62502.69698.933116.71B1.17B4.31B297.00B4.32B14.29B2.35B9.17B12.06B45.21B15.39B55.20B-23.98B-26.97B19.15B5.68B5.54B18.75B17.74B64.36B1.60B1.00B3.25B106.81B90.10B
2024-12-311.22T105.39B1.65B5.16B0.92503.55002.30548.311616.71B1.18B4.07B284.31B3.71B13.39B2.55B8.61B11.20B43.90B13.67B53.15B11.80B1.36B17.86B5.02B4.91B17.60B16.22B61.76B1.61B750.00M3.25B104.51B87.81B
2024-09-301.26T91.08B1.27B4.92B0.92503.47501.98146.956516.73B995.00M3.44B291.22B3.19B11.19B2.20B7.96B11.08B43.50B13.19B50.48B-17.32B-28.19B14.94B4.30B4.22B14.79B15.38B58.43B1.61B750.00M3.80B103.65B86.91B
2024-06-301.21T90.16B1.27B4.64B0.85003.40001.90946.463716.72B957.00M3.15B269.90B3.08B10.41B2.07B7.74B10.87B42.41B12.95B48.59B2.52B-7.12B13.92B4.15B4.07B13.71B15.02B56.32B1.61B750.00M4.55B100.71B84.00B
2024-03-311.23T102.31B975.00M4.29B0.85003.32502.11145.890516.72B933.00M2.79B266.15B3.41B9.52B1.80B7.68B10.75B42.02B13.34B47.08B4.36B-19.31B12.74B4.39B4.39B12.45B15.14B54.76B1.62B1.00B4.80B99.20B82.48B
2023-12-311.19T89.23B1.41B4.26B0.85003.25000.92165.520716.71B555.00M2.58B260.54B1.52B9.09B1.90B8.23B10.80B41.80B11.00B45.91B-17.75B-33.54B12.35B2.10B2.10B11.81B12.90B54.14B1.65B1.30B5.30B99.04B82.33B
2023-09-301.17T108.40B988.00M4.06B0.85003.17501.46565.968416.70B710.00M2.56B242.84B2.41B9.81B1.98B8.65B9.99B40.87B11.30B45.34B3.75B-29.78B13.13B3.28B3.15B12.51B13.27B54.00B1.64B1.50B5.70B99.21B82.51B
2023-06-301.16T104.99B922.00M4.00B0.77503.10001.32166.075116.65B591.00M2.57B243.82B2.18B10.03B2.01B9.19B10.48B40.44B11.45B44.52B-9.67B-41.08B13.27B2.97B2.81B12.75B13.46B53.71B1.65B1.00B6.75B100.39B83.73B
2023-03-311.20T111.26B940.00M4.00B0.77503.02501.79196.219516.66B727.00M2.76B245.59B2.98B10.34B2.35B9.46B10.52B39.67B12.17B43.93B-9.87B-16.50B13.72B3.99B3.76B13.26B14.52B53.38B1.66B1.50B8.49B100.83B84.17B
2022-12-311.18T128.13B1.21B4.00B0.77502.95001.30536.438416.65B528.00M2.91B233.87B2.24B11.03B2.32B9.33B9.87B39.30B10.43B44.34B-14.00B-6.40B14.37B2.88B2.79B14.09B12.75B53.67B1.71B1.70B9.87B100.14B83.49B
2022-09-301.16T111.70B928.00M4.03B0.77502.87501.55107.359516.72B726.00M3.55B216.36B2.63B12.49B2.51B9.10B9.56B39.07B10.48B46.35B-7.55B7.95B16.38B3.42B3.39B16.18B12.99B55.44B1.70B2.56B11.00B101.01B84.29B
Copy table — 8 periods, ~4,341 characters
end,Assets,CashAndEquivalents,DepreciationAndAmortization,DepreciationAndAmortization_TTM,DividendsPerShare,DividendsPerShare_TTM,EPS_QUARTERLY_CALC,EPS_TTM_CALC,Goodwill,IncomeTaxExpense,IncomeTaxExpense_TTM,LongTermDebt,NetIncomeLoss,NetIncomeLoss_TTM,NetInterestIncome,NetInterestIncome_TTM,NoninterestExpense,NoninterestExpense_TTM,NoninterestIncome,NoninterestIncome_TTM,OperatingCashFlow,OperatingCashFlow_TTM,PPNR,PPNR_QUARTERLY,PretaxIncome,PretaxIncome_TTM,ProvisionForCreditLosses,ProvisionForCreditLosses_TTM,Revenue,Revenue_TTM,SharesOutstanding,StockIssued,StockIssued_TTM,StockRepurchased,StockRepurchased_TTM,StockholdersEquity,TangibleEquity
2026-06-30,1675057000000.0,160135000000.0,1202000000.0,4402000000.0,1.0,4.0,3.55704270235819,12.845761631612492,17105000000.0,1695000000.0,5777000000.0,383156000000.0,5581000000.0,20155000000.0,2780000000.0,10829000000.0,13902000000.0,51681000000.0,18568000000.0,67213000000.0,-2747000000.0,-15587000000.0,26361000000.0,7446000000.0,7348000000.0,26147000000.0,,,21348000000.0,78042000000.0,1569000000.0,,,1500000000.0,5835000000.0,116329000000.0,99224000000.0
2026-03-31,1581418000000.0,133529000000.0,714000000.0,4507000000.0,1.0,3.925,3.5323604060913705,11.493020304568528,17105000000.0,1373000000.0,5129000000.0,363010000000.0,5567000000.0,18113000000.0,2703000000.0,10396000000.0,13471000000.0,49753000000.0,17877000000.0,63090000000.0,-7098000000.0,-1011000000.0,23733000000.0,7109000000.0,7011000000.0,23421000000.0,,,20580000000.0,73486000000.0,1576000000.0,,,1750000000.0,5335000000.0,114286000000.0,97181000000.0
2025-12-31,1420270000000.0,111695000000.0,1138000000.0,4658000000.0,1.0,3.85,2.761934673366834,10.59108040201005,16726000000.0,1336000000.0,4929000000.0,341681000000.0,4397000000.0,16861000000.0,2855000000.0,10046000000.0,12112000000.0,48342000000.0,15035000000.0,60599000000.0,-2410000000.0,-17889000000.0,22303000000.0,5778000000.0,5760000000.0,21954000000.0,,,17890000000.0,70645000000.0,1592000000.0,,,1500000000.0,4585000000.0,111632000000.0,94906000000.0
2025-09-30,1364806000000.0,103734000000.0,1348000000.0,5165000000.0,1.0,3.775,2.89937106918239,10.174842767295598,16725000000.0,1373000000.0,4775000000.0,324128000000.0,4610000000.0,16178000000.0,2491000000.0,9743000000.0,12196000000.0,47432000000.0,15733000000.0,59235000000.0,-3332000000.0,-3679000000.0,21546000000.0,6028000000.0,6028000000.0,21100000000.0,,,18224000000.0,68978000000.0,1590000000.0,,,1085000000.0,3835000000.0,109962000000.0,93237000000.0
2025-06-30,1353870000000.0,109130000000.0,1307000000.0,5087000000.0,0.925,3.7,2.221594475831764,9.263025737602009,16734000000.0,1047000000.0,4397000000.0,320128000000.0,3539000000.0,14756000000.0,2347000000.0,9448000000.0,11974000000.0,46319000000.0,14445000000.0,56689000000.0,11829000000.0,-17670000000.0,19818000000.0,4818000000.0,4622000000.0,19293000000.0,,,16792000000.0,66137000000.0,1593000000.0,,,1000000000.0,3500000000.0,108184000000.0,91450000000.0
2025-03-31,1300296000000.0,90739000000.0,865000000.0,5051000000.0,0.925,3.625,2.696875,8.933125,16714000000.0,1173000000.0,4307000000.0,296997000000.0,4315000000.0,14293000000.0,2353000000.0,9168000000.0,12060000000.0,45214000000.0,15386000000.0,55196000000.0,-23976000000.0,-26974000000.0,19150000000.0,5679000000.0,5544000000.0,18745000000.0,,,17739000000.0,64364000000.0,1600000000.0,,,1000000000.0,3250000000.0,106812000000.0,90098000000.0
2024-12-31,1215071000000.0,105386000000.0,1645000000.0,5161000000.0,0.9249999999999998,3.55,2.3054003724394785,8.311607697082557,16706000000.0,1182000000.0,4067000000.0,284307000000.0,3714000000.0,13390000000.0,2552000000.0,8611000000.0,11202000000.0,43901000000.0,13671000000.0,53150000000.0,11800000000.0,1362000000.0,17860000000.0,5021000000.0,4906000000.0,17596000000.0,,,16223000000.0,61761000000.0,1611000000.0,,,750000000.0,3250000000.0,104511000000.0,87805000000.0
2024-09-30,1258027000000.0,91084000000.0,1270000000.0,4922000000.0,0.925,3.475,1.9813548788067123,6.956494717215662,16735000000.0,995000000.0,3440000000.0,291223000000.0,3188000000.0,11193000000.0,2196000000.0,7956000000.0,11083000000.0,43496000000.0,13187000000.0,50478000000.0,-17323000000.0,-28190000000.0,14938000000.0,4300000000.0,4221000000.0,14786000000.0,,,15383000000.0,58434000000.0,1609000000.0,,,750000000.0,3800000000.0,103647000000.0,86912000000.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 74 periods · 14 concepts · 2 null in every period shown — kept on purpose, an empty column is a finding

Calculated metrics for the selected ticker
endeffective_tax_rateefficiency_ratioefficiency_ratio_quarterlyequity_to_assetsincome_yoy_growthnet_interest_marginpayout_ratiopayout_ratio_quarterlyprovision_ratioprovision_ratio_quarterlyrevenue_yoy_growthroaroerotce
2026-06-300.220966.22%0.65126.94%36.59%0.65%31.14%0.281118.00%1.20%17.33%0.2031
2026-03-310.219067.70%0.65467.23%26.73%0.66%34.15%0.283114.17%1.15%15.85%0.1864
2025-12-310.224568.43%0.67707.86%25.92%0.71%36.35%0.362114.38%1.19%15.10%0.1777
2025-09-300.226368.76%0.66928.06%44.54%0.71%37.10%0.344918.04%1.19%14.71%0.1735
2025-06-300.227970.03%0.71317.99%41.71%0.70%39.94%0.416417.42%1.09%13.64%0.1614
2025-03-310.229870.25%0.67998.21%50.15%0.71%40.58%0.343017.53%1.10%13.38%0.1586
2024-12-310.231171.08%0.69058.60%47.35%0.71%42.71%0.401214.07%1.10%12.81%0.1525
2024-09-300.232774.44%0.72058.24%14.14%0.63%49.95%0.46698.22%0.89%10.80%0.1288
2024-06-300.230175.29%0.72378.31%3.82%0.64%52.60%0.44524.87%0.86%10.34%0.1240
2024-03-310.224176.74%0.71008.07%-7.97%0.63%56.45%0.40262.58%0.77%9.60%0.1154
2023-12-310.218777.20%0.83728.30%-17.61%0.69%58.87%0.92230.89%0.76%9.18%0.1104
2023-09-300.204375.69%0.75308.49%-21.48%0.74%53.20%0.5800-2.61%0.84%9.88%0.1188
2023-06-300.201775.29%0.77918.62%-26.05%0.79%51.03%0.5864-6.12%0.86%9.99%0.1198
2023-03-310.208474.30%0.72498.40%-29.06%0.79%48.64%0.4325-9.27%0.86%10.26%0.1229
2022-12-310.206573.23%0.77408.48%-26.64%0.79%45.82%0.5937-10.19%0.93%11.01%0.1321
2022-09-300.219470.46%0.73648.71%-15.17%0.78%39.07%0.4997-5.82%1.08%12.36%0.1482
Copy table — 8 periods, ~2,228 characters
end,effective_tax_rate,efficiency_ratio,efficiency_ratio_quarterly,equity_to_assets,income_yoy_growth,net_interest_margin,payout_ratio,payout_ratio_quarterly,provision_ratio,provision_ratio_quarterly,revenue_yoy_growth,roa,roe,rotce
2026-06-30,0.2209431292308869,0.6622203428922888,0.6512085441259134,0.0694477859559406,0.3658850637029005,0.006464854628827556,0.3113867526668321,0.2811324135459595,,,0.18000514084400554,0.012032426359222402,0.17325860275597657,0.20312625977586068
2026-03-31,0.21899150335169293,0.6770405247257981,0.6545675413022352,0.07226805310170999,0.26726369551528717,0.0065738470157795095,0.3415116214873295,0.28309682054966767,,,0.14172518799328815,0.01145364476691172,0.15848835377911555,0.1863841697451148
2025-12-31,0.22451489477999453,0.6842947130016278,0.6770262716601453,0.07859913960021686,0.25922330097087376,0.007073302963521021,0.3635134333669415,0.3620650443484194,,,0.14384482116546038,0.011871686369493125,0.15104092016626058,0.17766000042146968
2025-09-30,0.22630331753554503,0.6876395372437589,0.6692273924495171,0.08056969268892429,0.44536764048959165,0.007138743528384254,0.3710131042156014,0.34490238611713664,,,0.1804428928363624,0.011853699353607765,0.14712355177243047,0.17351480635370078
2025-06-30,0.2279064945835277,0.7003492749897939,0.7130776560266794,0.07990722890676358,0.41707481033323734,0.006978513446638156,0.3994375169422608,0.4163676179711783,,,0.17422413180882046,0.010899126208572463,0.13639724913110995,0.16135593220338984
2025-03-31,0.22976793811683116,0.7024734323534896,0.6798579401319127,0.0821443732811606,0.5015232692509717,0.007050702301629783,0.40579304554677115,0.342989571263036,,,0.17534056462510494,0.010992112565139014,0.13381455267198442,0.15863837155097782
2024-12-31,0.23113207547169812,0.7108207444827642,0.6905011403562843,0.08601225771991924,0.4735336194563662,0.007086828670917172,0.4271135175504107,0.40123182552504033,,,0.1407014757217,0.011019932168572865,0.1281204849250318,0.15249701042081887
2024-09-30,0.23265250913025834,0.7443611595988636,0.720470649418189,0.08238853379140511,0.1414440138690598,0.0063241885905469435,0.4995331903868489,0.4668522584692597,,,0.0821912734276613,0.008897265321014572,0.10799154823583895,0.12878543814432988

Quality flags

Distortion of data.

Quality flags, how often and how recently
flagraisedperiods evaluatedmost recent
buyback_distortion_flag071
inorganic_contaminated2682021-03-31
low_tax_rate_flag9662015-09-30
share_count_jump_flag4722011-09-30
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-300000
2024-03-310000
2023-12-310000
2023-09-300000
2023-06-300000
2023-03-310000
2022-12-310000
2022-09-300000

Valuation history

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

16 of 77 periods · 6 concepts

Valuation history for the selected ticker
endbuyback_distortion_flagdividend_yieldp_ppnrp_tbvpe_ratiope_to_revenue_growth
2026-06-300.00001.92%12.37393.287416.18400.8991
2026-03-310.00002.41%10.81042.640114.16460.9994
2025-12-310.00002.20%12.46672.929716.49041.1464
2025-09-300.00002.43%11.47052.650715.27650.8466
2025-06-300.00002.70%10.99522.382714.76700.8476
2025-03-310.00003.23%9.39071.996012.58180.7176
2024-12-310.00002.95%10.85242.207414.47531.0288
2024-09-300.00003.51%10.66071.832314.22761.7310
2024-06-300.00003.72%10.58691.754114.14942.9061
2024-03-310.00003.79%11.13631.720214.90465.7741
2023-12-310.00003.77%11.48041.721415.5965
2023-09-300.00004.26%9.32461.483512.4825
2023-06-300.00004.02%9.60281.521912.7057
2023-03-310.00003.84%9.53781.554512.6500
2022-12-310.00003.90%9.00981.550611.7383
2022-09-300.00004.13%7.20771.40049.4516
Copy table — 8 periods, ~966 characters
end,buyback_distortion_flag,dividend_yield,p_ppnr,p_tbv,pe_ratio,pe_to_revenue_growth
2026-06-30,0.0,0.01924042791573652,12.373892168848402,3.287391875584664,16.183982707170067,0.8990844723260036
2026-03-31,0.0,0.024110197134094673,10.810417670674799,2.640059708977321,14.164613403529232,0.9994422024827403
2025-12-31,0.0,0.022043892502195534,12.466720533847745,2.929691147729398,16.49043758178081,1.1464046774970338
2025-09-30,0.0,0.024286467510455077,11.47051913995193,2.650705249948028,15.276536369724582,0.846613359473147
2025-06-30,0.0,0.027049299285369355,10.99516261046199,2.3827461193453883,14.76701901695146,0.8475874647006764
2025-03-31,0.0,0.03225236257298827,9.390693843831592,1.9959575918374992,12.581808375384803,0.7175640390052309
2024-12-31,0.0,0.029506444857982046,10.852394012587869,2.207434167357432,14.475261916715409,1.0287924730332398
2024-09-30,0.0,0.03511021778385035,10.660679194483194,1.8323042365517987,14.22757310883498,1.731032081083041

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 MS
conceptavg_p_ppnr_5yavg_p_ppnr_5y_divergesavg_p_ppnr_5y_history_too_shortavg_p_ppnr_5y_medianavg_p_tbv_5yavg_p_tbv_5y_divergesavg_p_tbv_5y_history_too_shortavg_p_tbv_5y_medianavg_pe_5yavg_pe_5y_divergesavg_pe_5y_history_too_shortavg_pe_5y_mediancashdays_past_expected_filingdays_since_last_filingdebtdividend_yielddividends_ttmefficiency_ratioeps_ttmequityequity_to_assetsfiling_likely_overduefundamentals_stalemarket_capnet_interest_marginp_ffo_band_elevatedp_ppnrp_ppnr_band_elevatedp_tbvp_tbv_band_elevatedpe_ratiope_ratio_band_elevatedpe_to_revenue_growthppnr_ttmpricerevenue_ttmroashares_basisshares_delta_pctshares_outstandingshares_source_is_edgartangible_equityyoy_growth
value9.44360.00000.000010.09481.82650.00000.00001.723512.49490.00000.000013.4276160.13B-53.000080.0000383.16B1.97%4.000066.22%12.8458116.33B6.94%0.00000.0000319.64B0.65%0.000012.12560.00003.22140.000015.84340.00000.880226.36B203.520078.04B1.20%0.0000-0.09971.57B0.000099.22B0.1800
Copy table — ~1,269 characters
concept,value
avg_p_ppnr_5y,9.44363816723069
avg_p_ppnr_5y_diverges,0.0
avg_p_ppnr_5y_history_too_short,0.0
avg_p_ppnr_5y_median,10.094844244459184
avg_p_tbv_5y,1.8264965398665143
avg_p_tbv_5y_diverges,0.0
avg_p_tbv_5y_history_too_short,0.0
avg_p_tbv_5y_median,1.7235066300437798
avg_pe_5y,12.494949800704402
avg_pe_5y_diverges,0.0
avg_pe_5y_history_too_short,0.0
avg_pe_5y_median,13.42758067137179
cash,160135000000.0
days_past_expected_filing,-53.0
days_since_last_filing,80.0
debt,383156000000.0
dividend_yield,0.019654088050314465
dividends_ttm,4.0
efficiency_ratio,0.6622203428922888
eps_ttm,12.845761631612492
equity,116329000000.0
equity_to_assets,0.0694477859559406
filing_likely_overdue,0.0
fundamentals_stale,0.0
market_cap,319641651747.84
net_interest_margin,0.006464854628827556
p_ffo_band_elevated,0.0
p_ppnr,12.12555106968021
p_ppnr_band_elevated,0.0
p_tbv,3.2214146955156013
p_tbv_band_elevated,0.0
pe_ratio,15.843357975688416
pe_ratio_band_elevated,0.0
pe_to_revenue_growth,0.880161416579677
ppnr_ttm,26361000000.0
price,203.52
revenue_ttm,78042000000.0
roa,0.012032426359222402
shares_basis,0.0
shares_delta_pct,-0.0997278502651068
shares_outstanding,1570566292.0
shares_source_is_edgar,0.0
tangible_equity,99224000000.0
yoy_growth,0.18000514084400554