Applying a data ontology framework to AI moat investing — why FactSet, Veeva, Roper, and SPGI may be mispriced relative to Snowflake/Databricks. Methodology and open question on durability inside.
▲ 62 r/SecurityAnalysis+1 crossposts

Applying a data ontology framework to AI moat investing — why FactSet, Veeva, Roper, and SPGI may be mispriced relative to Snowflake/Databricks. Methodology and open question on durability inside.

Background: I've spent twenty years doing data ontology work professionally — building the semantic structures that turn raw, ungoverned data into something usable, most recently at SurveyMonkey. On the side I've built a personal screener pulling 16 years of SEC XBRL data across roughly 1,700 tickers, normalizing inconsistent tags so true FCF (operating cash flow minus CapEx minus SBC) is comparable across companies. I'm posting this here specifically because I think the methodology question is more interesting than the stock picks, and this sub seems like the right place to have that argued with rather than just agreed with.

The consensus trade and why I think it's incomplete

Everyone agrees the AI infrastructure trade is the data platform layer — Snowflake, Databricks, Amplitude. Raw data storage, query, and governance tooling. The market has priced this consensus in fully; these names carry premium multiples on the "picks and shovels" thesis.

My argument: raw data infrastructure is closer to a commodity than people are pricing it as. SQL servers, data warehouses, analytics capture platforms — this category has been re-invented every decade with marginal differentiation, and the switching costs, while real, are mostly operational (migration pain) rather than epistemic (the new platform can do everything the old one could, eventually). What's scarce isn't the pipe. It's validated, structured, domain-specific content moving through the pipe.

The taxonomy I'm using

I split AI-relevant data companies into four categories:

Foundational language data — Reddit (RDDT) is the only name here. Granular subreddit classification plus upvote-based quality signal is genuinely unique training corpus for natural, idiomatic language. I don't own it — FCF yield too low for my framework, still in a cash-consuming growth phase — but the data moat argument is real.

Industry-specific contextual data — FactSet (FDS), Veeva (VEEV), Roper (ROP), S&P Global (SPGI). These companies have spent decades organizing messy, heavily regulated domain data into clean, structured ontologies: financial workflows, FDA-validated clinical trial records, county tax administration, credit ratings methodology. None of this is scrapeable. A general model trained on public web data has zero exposure to what a structured clinical trial submission or a properly normalized financial model actually looks like internally.

Workflow/usage data — Adobe (ADBE), Salesforce (CRM), SS&C (SSNC). The moat here is encoded human process rather than raw content. A Salesforce lead-to-contact-to-opportunity data model isn't bad design — it's encoding a specific sales workflow that took years to standardize across millions of companies. Replacing it means replicating not just the data but the process logic embedded in how that data gets created and transformed.

Data foundation platforms — Amplitude (AMPL), Snowflake (SNOW). The commodity layer described above.

The valuation argument

The names in categories 2 and 3 are trading at meaningfully better true FCF yields than the consensus infrastructure plays, despite (in my view) deeper and more durable moats — partly because the SaaSpocalypse selloff has lumped them in indiscriminately with software companies that genuinely do have weak, scrapeable moats. I think the market is pricing the wrong layer of the stack.

The honest open question I'd actually like pushback on

Is "irreplaceable context" really a durable moat, or just a temporary information asymmetry that AI labs close over time as they get better at synthetic data generation, data partnerships, or simply paying for licensing access to exactly this kind of structured content? If OpenAI or Anthropic can license FactSet's data outright, or if regulatory data eventually becomes more standardized and shareable industry-wide (think FDA pushing toward common data standards), does the moat compress faster than the multiple suggests it will? I think the moat holds longer than the market is currently pricing, but I'm genuinely less certain about the 10-year case than the 3-year case, and would like to hear from anyone closer to enterprise AI procurement or regulatory data standards on how real this risk is.

Full piece with the four-category breakdown and a true FCF yield comparison table is here, for anyone who wants the data: https://cavemanscreener.substack.com/p/context-is-50-iq-points-part-ii-data

Disclosure: I own FDS and ADBE.

u/JoeInOR — 6 days ago
▲ 25 r/SecurityAnalysis+1 crossposts

Last week I published a bear case DCF on Comcast with a "dream scenario" of an NBCUniversal spinoff at $55-75 per share. This morning they announced it. Stock is up 20% premarket. Here's the original math.

Last week I ran a bear case DCF on Comcast using normalized FCF of $16B, assumed 3% annual decline for 12 straight years, 10% discount rate, and explicitly stripped $89B in net debt from the terminal value.

Bear case fair value: $30-38 per share against a $22 price.

At the end of the piece I wrote a "dream scenario" section:

"A company that spun off Versant doesn't seem unlikely to eventually spin off other pieces - broadband infrastructure or Universal Studios as a standalone entity. According to my sum-of-parts analysis, a spinoff scenario could put CMCSA at $55-75 per share."

This morning Comcast announced exactly that. NBCUniversal and Sky spinning off into a separate publicly traded company. Broadband, wireless, and business services staying in the remaining Comcast. Stock up 20% in premarket.

The broadband rump - which produced 24x the adjusted EBITDA of the content business in Q1 2026 - is now going to trade as a pure-play infrastructure company. The content business gets its own multiple separately.

Even after the 20% move the stock is still below my bear case fair value of $30-38. The spinoff still needs regulatory approval and closes in about a year. The story isn't over.

Full DCF with the math, the debt analysis, and the buyback cannibalization model here: https://cavemanscreener.substack.com/p/buying-2-for-1-a-comcast-dcf-update

u/JoeInOR — 7 days ago

I spent a week pulling Pentagon AI procurement data from USASpending.gov. Found that BAH was sitting on a $6.4B AI contract ceiling while trading at ~$9B market cap. They announced a $720M acquisition this morning confirming the thesis.

I've been building a pipeline on USASpending.gov - 30 million rows of federal contract data going back to 2020. I've written a few pieces on this data before, mostly about DOGE cuts and defense spending patterns. This one is different because the timing was quite fortuitous.

What is the CDAO?

The Chief Digital and Artificial Intelligence Office was created by the DoD in 2022. It's the institutional brain for the Pentagon's algorithmic future - whatever AI tools the US military uses to identify targets, coordinate operations, and process battlefield intelligence flows through this office. If you want to know who's actually winning the defense AI race, you can read the procurement data.

What the data show

I filtered USASpending.gov transactions to CDAO as the awarding office. Here's the 2025 federal action obligation breakdown:

Total CDAO obligations 2025: $312 million
Palantir: $252 million — 81% of the total
Booz Allen Hamilton: $39 million
Johns Hopkins Applied Physics Lab: $6.5 million

The division of labor is visible in the transaction descriptions. Palantir's line items are all software - Maven Smart System enterprise licenses, Data-as-a-Service platform, Army Vantage analytics. BAH's line item is "business application development support services - labor." Johns Hopkins is doing basic research. Palantir builds the AI. BAH makes it work. Johns Hopkins figures out what to build next.

The Palantir number: $23.5 billion

The $252 million is obligated cash. The ceiling if the government exercises every option year is $23.5 billion against $1.8 billion currently obligated.

Project Maven alone has nearly $4 billion in enterprise license ceiling across its line items. The Data-as-a-Service platform adds $2.6 billion. The Space C2 data platform adds $2.15 billion. Army Vantage has multiple line items totaling over $4 billion in ceiling. Palantir is too rich for my blood - $286 billion market cap against $1.4 billion 2025 true FCF.

But BAH? Here's where it gets interesting...

BAH has one transaction line for CDAO in 2025. It's called CDAO Technology Synchronization of Business Operations - TSYBO. The 2025 federal action obligation is $39.2 million. The potential total value of that single vehicle is $6,408,923,808.

BAH's current market cap after significant compression in 2026 is roughly $7.6 billion. The market is pricing BAH as a legacy government consultancy in secular decline. The contract data suggests that it may hold the implementation layer for the Pentagon's AI buildout.

Some caveats

The potential end date on the TSYBO contract shows 2025 in my data. I don't fully understand what that means. It could indicate a re-compete requirement - BAH would need to defend its position as the incumbent. It could be a data artifact from how USASpending.gov records IDIQ vehicles. BAH has a strong historical renewal rate on major contracts but this is worth investigating before sizing up a position.

Also worth noting: this data is messier than my usual SEC XBRL work.If anyone here has domain knowledge on how IDIQ potential end dates work I'd love to hear it.

BAH acquisition

Today BAH announced a $720 million acquisition of Ultra I&C Mission Solutions, a defense tech company specializing in mission-critical software, encryption, and edge-compute products for battlefield deployment.

Think about what edge-compute and encryption hardware does in the context of a $6.4 billion AI integration contract. Palantir's Maven Smart System identifies targets and coordinates operations at the software layer. But that software has to run somewhere secure, at the edge of the network, in environments where connectivity is unreliable and security is paramount.

Full piece with all the data tables: https://cavemanscreener.substack.com/p/bridges-to-nowhere-part-iii-inside

reddit.com
u/JoeInOR — 14 days ago

I pulled CDAO procurement data and found BAH sitting on a $6.4B AI integration contract while trading at ~$9B market cap. Published today. They announced a $720M acquisition this morning confirming the thesis.

The CDAO is the Pentagon's Chief Digital and Artificial Intelligence Office. I pulled their procurement transaction data from USASpending.gov and ran it through my contract intelligence pipeline.

Palantir captured $252M of $312M in 2025 CDAO federal action obligations: 81% of the total. More importantly, their potential contract ceiling is $23.5B against $1.8B obligated. Project Maven alone has nearly $4B in enterprise license ceiling. The Data-as-a-Service platform adds $2.6B. At $286B market cap against $1.4B true FCF, PLTR is pricing in most of this already.

BAH is the more interesting value case. One transaction line - CDAO Technology Synchronization of Business Operations - carries a $6.4B potential award ceiling against $39M obligated in 2025. BAH's current market cap after compression is roughly $7.6B. The market is pricing BAH as a dying consultancy. The contract data suggests it may hold a key to the Pentagon's AI implementation layer.

This morning BAH announced a $720M acquisition of Ultra I&C Mission Solutions, specializing in encryption and edge-compute hardware. That is precisely the implementation stack required to fulfill a $6.4B AI integration contract. The market knocked the stock down on the cash outlay. I think that's the wrong reaction.

Honest caveats: the 2025 potential end date on the BAH contract is ambiguous - could mean re-compete, could be a data artifact. I don't fully understand it and said so in the piece. The data is messier than my usual SEC XBRL work. But the coincidence of contract ceiling plus acquisition announcement plus compressed valuation is hard to ignore.

Full piece with data tables: https://cavemanscreener.substack.com/p/bridges-to-nowhere-part-iii-inside

reddit.com
u/JoeInOR — 14 days ago
▲ 46 r/BerkshireHathaway+3 crossposts

I sold DaVita in February because dividends felt more real than buybacks. It returned 70% while I watched. Here's what I learned about corporate cannibals.

A cannibal is a company retiring its own shares aggressively - but not the fake kind where buybacks just offset employee SBC dilution. NET buybacks. The kind where the share count actually shrinks.

The math is interesting: if true FCF is growing while shares shrink, the yield available to you as a shareholder is compounding twice. And here's the psychological twist — if the stock drops during the buyback, that's actually good news. Lower price means more shares retired per dollar, which means higher ownership stake. You almost get to root for the price to drop.

My filters: buyback yield of at least 5% (net share reduction) plus true FCF yield of at least 8% (OCF minus CapEx minus SBC). Here's what came out of my screener.

The standouts: ADBE, CMCSA, DBX, PYPL, DVA, BCO. Profit margin as a moat proxy puts ADBE, CMCSA, FISV and GPN at the top.

The Adobe section of the piece is what I'm most interested in hearing pushback on. The Reddit bear case I link argues freemium is a warning sign. My counter: Adobe is attracting 800 million users and generating creative workflow behavioral data at a scale that Midjourney and DALL-E simply don't have. As a data ontologist by trade, that context corpus looks more like a moat than a threat. Very few people question whether Anthropic's freemium model creates value. Why is Adobe different?

Full piece with jaws of life charts: https://cavemanscreener.substack.com/p/the-jaws-of-life-finding-stocks-that

u/JoeInOR — 18 days ago
▲ 76 r/BerkshireHathaway+1 crossposts

The psychology problem with value investing and a DCF on CMCSA that's hard to ignore

Short piece I wrote before heading on vacation. More philosophical than usual but I think it's worth discussing.

The core argument: value investing is primarily a battle against your own psychology, not a battle to find the right numbers. Every cheap stock you buy will probably drop first. Momentum is real and it works against you in the short term. Buffett's edge wasn't intellect — it was temperament.

On CMCSA specifically: I ran a segment-by-segment 15-year DCF. Assumptions are deliberately bearish — connectivity FCF shrinks 4%/yr, Peacock reaches only modest profitability, zero terminal value. Parks grow at ~3%/yr post-Epic Universe.

Result: $158B in present value cash flows against an $89B market cap.

The bear case requires believing the market is right that CMCSA is worth less than 6 years of its own normalized FCF. The DCF says that's too pessimistic even in a slow-death scenario.

Full piece: https://cavemanscreener.substack.com/p/the-sad-life-of-a-value-investor

u/JoeInOR — 1 month ago
▲ 42 r/BerkshireHathaway+1 crossposts

I screened for stocks with 10%+ True FCF yield across their entire history. Here's what survived and what the data actually says.

Built a screen using 15 years of SEC XBRL data. Filters: True FCF yield (OCF minus CapEx minus SBC) above 10% for the entire history of the stock, at least 10 years of data, P/B between 0.1 and 10, no financials, real CapEx present.

Got a list with some garbage and some names worth looking at. Added Sirius, Ford and Mattel manually since I wanted them in the comparison.

The interesting ones: CMCSA, HOG, TAP. Here's what I found on each:

Comcast: 20%+ True FCF yield. Revenue correlation to US nominal GDP is 96% over the last 5 years. It wasn't always this way, the empire-building era (2012-2017) kept correlation negative. Now it's one of the most NGDP-integrated businesses I've found. The bear case (fiber competition, Peacock losses, debt costs) is real and so is the yield.

Harley-Davidson: 9.7% of float retired in a single year and 13.4% total shareholder yield. 0.79x tangible book with almost no goodwill - the manufacturing business is essentially debt-free. While the brand is aging, the capital allocation seems exceptional.

Molson Coors: Trading below book. In 17 years FCF never went negative. 10.2% total shareholder yield. Is it safe? Well, it's beer.

Also added a rolling 5-year NGDP correlation layer which shows Shutterstock losing its cash generation ability in real time (FCF went negative in 2024 while revenue kept growing.

Methodology in the piece. Happy to share the data: https://cavemanscreener.substack.com/p/lookin-for-value-in-all-the-wrong

u/JoeInOR — 1 month ago
▲ 73 r/ValueInvesting+1 crossposts

SpaceX S-1 dropped. Here's what the passive investing angle means for your index fund — and why I think this IPO is structured to use your 401k as exit liquidity.

The Starlink business is genuinely excellent — $11.4B revenue, 63% EBITDA margin, 50% growth. If you could buy Starlink as a standalone utility it would be one of the best businesses on the planet.

But you can't. Here's what you're actually buying:

→ xAI lost $6.36B on its own in 2025 → xAI's $16B in debt was refinanced onto SpaceX's balance sheet via a $20B bridge loan in March. That debt is now SpaceX's — and soon to be public investors' → The entire xAI revenue bull case is one customer: Anthropic, funded by Google and Amazon — xAI's direct competitors → Each Class B share carries 10 votes. Musk controls all shareholder outcomes. SpaceX is explicitly listing as a "controlled company" exempt from Nasdaq governance requirements → The fast-track index inclusion rule means passive funds are legally forced to buy within 15 days of listing at whatever price it's trading

Less than 7% of the $1.75T valuation is backed by current profit.

60% of mutual fund and ETF assets are now passively managed. An extra $1 of active investment generates $5 of passive buying. That's how you get to $1.75T without anyone deciding it's worth that — the machine decides.

Full piece: https://cavemanscreener.substack.com/p/the-175-trillion-trojan-horse-how

u/JoeInOR — 1 month ago
▲ 17 r/BerkshireHathaway+1 crossposts

I screened dividend aristocrats for CPI correlation to find inflation hedges. Here's what the data show.

With interest payments now equaling defense spending, I wanted to find businesses that structurally benefit from inflation rather than just survive it.

The template is Enterprise Products Partners (EPD) with PPI-indexed revenues and fixed-rate debt under 5%. In an inflationary environment their upside reprices while their cost of debt stays fixed.

I ran the same screen across dividend aristocrats: revenue correlation to CPI over 16 years of SEC data:

> Realty Income (O): 92.7% - CPI-linked lease escalators baked into contracts

> American Express (AXP): 81.4% CPI + 52% NGDP - rides both inflation and real growth

> ExxonMobil: 79.6% - energy is the CPI basket

> Republic Services: 77.8% - waste hauling contracts directly CPI-indexed

> Chevron: 72.3%

The mechanism is the same for all of them: revenues reprice with inflation whereas debt doesn't.

AXP is the most interesting with a 7.25% true FCF yield, a huge Buffett position, and it automatically clips a percentage of every nominal transaction in the economy.

Full screen with true FCF yields and 10-year averages: https://cavemanscreener.substack.com/p/surfin-inflation-finding-the-businesses

u/JoeInOR — 2 months ago

Buffett only counts it when he has the cash in hand. The Mag 7's cash flow statements are now telling a different story than their income statements.

Buffett famously said he doesn't count it until the cash is in hand. By that standard most of the Magnificent 7 are in trouble.

I published SEC data on this May 4th. The Economist confirmed it May 13th with Goldman sources. Here's its fascinating take: https://www.economist.com/business/2026/05/13/big-tech-is-sacrificing-its-cashflows-to-prop-up-the-ai-boom

The number: net income grew $157B across 43 big tech companies in 2025. True free cash flow — operating cash flow minus CapEx minus SBC — shrank $10B.

The one exception that passes Buffett's test: Nvidia. True FCF went from $2.9B to $56B in two years. They built the tollbooth everyone else is paying.

The Economist found something my data missed: $820B in off-balance-sheet lease commitments on data centers not yet built. A banker told them lawyers found "a very long list" of exit ramps in those contracts. That's the hidden blast radius if the AI buildout slows.

My money is in BRK.B, EPD, CB, AXP. Pretty boring, but I can live with that.

Full piece here: https://cavemanscreener.substack.com/p/bridges-to-nowhere-part-ii-the-economist

reddit.com
u/JoeInOR — 2 months ago

The Economist ran a story on big tech free cash flows last week. Pretty interesting article. "America's biggest companies have gone from printing money to burning it."

The Economist just ran this on "big tech" free cash flows: https://www.economist.com/business/2026/05/13/big-tech-is-sacrificing-its-cashflows-to-prop-up-the-ai-boom

I love this line: "America's biggest companies have gone from printing money to burning it."

Because I have my trusty SEC/Edgar database, I can go more into depth on the math:

Across 43 big tech companies in 2025: — Net income grew $157B — True free cash flow shrank $10B — CapEx grew $170B

The market seems to be reacting to the income growth, but the cash flow isn't following.

The Economist also found something my screener doesn't have (still struggling to get quarterly data): $820B in off-balance-sheet data center lease commitments, up from $270B a year ago. A banker told them: "When we ask our lawyers to find ways a hyperscaler might wriggle away from a lease contract, often they come back with a very long list."

In plain English: the financing underpinning the entire AI buildout may be more renegotiable than the bond buyers funding it realize.

Back of napkin on the $800B 2026 CapEx projection: if 10% of Americans pay $1,000/year for AI and every Fortune 500 spends $100M/year, that's $80B in revenue on $1.1T in cumulative AI investment. 7.3% ROI assuming it all flows back to the hyperscalers, which it won't. I can already earn 6-10% on MLP energy investments. Real, tangible money.

Full piece here: https://cavemanscreener.substack.com/p/bridges-to-nowhere-part-ii-the-economist

reddit.com
u/JoeInOR — 2 months ago
▲ 90 r/BerkshireHathaway+1 crossposts

Buffett suffered through the dotcom bubble looking wrong for years. I wonder if we're in the same setup — but the 1970s version this time.

In 1999, Berkshire underperformed badly while Buffett warned about the bubble. He was right, just early. The businesses he owned and the cash flows he collected were real. The problem really was everyone else.

The Mag 7 aren't like pets.com. Nvidia printed $56B in real cash flow last year. But the 1970s Nifty Fifty weren't frauds either. Coca-Cola, McDonald's, Philip Morris are real businesses with real earnings, yet they still fell 70–90% from peak when the discount rate environment changed.

What changed my framing? Passive flows into ETFs. At the moment they scare the sh*t out of me. BRK's cash pile is essentially my dry powder. When passive inflows become outflows at scale, Buffett deploys. That's the thesis for owning it at 20% of my portfolio alongside CB, AXP, EPD, FDS.

Mapped the full Nifty Fifty parallel — oil shocks, Burns vs Warsh, fiscal deficits, passive share growth — https://cavemanscreener.substack.com/p/that-70s-market-oil-shocks-arthur

u/JoeInOR — 2 months ago

Defense Contracts & FCF - Looking at L3Harris Corporation (LHX) and Honeywell (HON)

L3Harris (LHX, referred to in the data by its old name Harris Corporation) federal action obligations have spiked from a steady $400M-$500M since 2021 to $1.21B in 2025, but that doesn’t seem to be reflected in its price. Is the market missing something?

In my zeal to become an alt-data provider and ontologist extraordinaire, I decided to have a look at many gigabytes of USA spend data, government contracts and grants, to see whether there were insights that aren't easy to come by. The process of cleaning and understanding $4T of contract data since 2020 is challenging to say the least. But I’m finding too many nuggets to write about. If you want to see more results of this sort of alt-data analysis, please subscribe, or reach out to me if have other ideas for interesting sources of alt data.

The first thing I do when understanding a dataset of vast scope is to try to pick out the outliers and see if they tell me anything. There are certainly a couple that stick out when looking at % of spend by industry classification (NAICS). In the total federal action obligations, I see a huge amount of “Facilities Support Services” in February 2026. In total base and options value I see another large amount for “Telecommunications Resellers”.

If the government is deciding to throw billions of dollars more into certain areas, I kind of want to know who will reap the benefits. Now we look at those two categories for the major players. Here are the top ten recipients by name for each of those NAICS descriptions in 2025-2026.

I’m looking for big outliers as well as potentially public companies. Two stand out that I know: Honeywell (HON) and Harris Corporation (now L3Harris, LHX). Now it’s a question of looking at their federal contract dollars over time. Both show some growth, though LHX is showing major growth from Q2 of 2025 until Q1 of 2026. That seems like enough ($300M+ per quarter) to have a material impact on LHX’s earnings.

The actual free cash flow numbers also seem related to future federal contracts obligations, as you’d expect. Based on that massive spike in 2025 obligations, you would expect LHX to have a lot of true free cash flow growth in 2026, which the market doesn’t seem to be pricing in. On the other hand, these obligations make up maybe 20% of LHX’s true FCF, only 5% of revenue. Not insignificant, but not everything. More broadly, however, the obligation data here does look predictive of true FCF, so we have some real alt data on our hands, it seems.

The conclusion from this? First of all, the promise of alt data that no one has ontologized is enormous, but it’s hard to find outside corroboration of whether the data are up to date or accurate. So if you see something here that you’d want to act on, do some research first to confirm or deny whether this data are already incorporated into the news about these companies. As to the promise, there are 136K entities in this data receiving money. Below are some of the trend lines by total contract action obligation for the top 25 entities listed. My hierarchical mapping from SEC subsidiaries to tickers seems to be working reasonably well so far. And look at Amerisourcebergen Drug Corp’s trend towards the bottom. That’s a great trend.

u/JoeInOR — 2 months ago
▲ 3 r/Investors+2 crossposts

Used USASpending.gov modification-level data to dig into LHX and HON — methodology and findings

I’m a data analyst and I’ve been building an alt-data pipeline on top of USASpending.gov — the federal contract database covering $4.5T in obligations since 2020. The data is free and public but almost completely unprocessed from an investment standpoint. This is my first writeup from it.

The methodology problem
The raw data has 297 columns, ~30M rows, and a terrible entity resolution problem. “Raytheon Company,” “Raytheon Applied Signal Technology Inc,” and “Raytheon Canada Limited” are all separate rows with no ticker attached. I built a mapping layer using SEC EDGAR Exhibit 21 subsidiary filings cross-referenced against recipient names. Imperfect but functional for major public companies.

What I found on LHX
Harris Corporation — the legacy name L3Harris still contracts under post-merger — had steady obligations of $400-500M annually from 2021-2024. In 2025 that jumped to $1.21B.

The driver is the FAA Telecommunications Infrastructure Next Generation contract. Civilian FAA modernization, nothing to do with DoD or DOGE. The modification-level data shows the pace accelerating through 2025: ~$100M in Q2, $265M in Q3, $310M in Q4.

LHX pulled back 9% from its March high on a backward-looking revenue miss. These FAA obligations are about 5% of LHX revenue and roughly 20% of true FCF. Not the whole story but not nothing either. The historical correlation between LHX obligation levels and subsequent FCF is reasonably clean.

What I found on HON
Honeywell FM&T runs the Kansas City National Security Campus — makes non-nuclear components for US warheads under DOE contract DE-NA0002839. Single modification amounts: $591M in Q2 2025, $509M in Q4, $989M in one modification in Q1 2026.
The HON correlation with FCF is noisier. Federal contracts are ~5% of their revenue and the scatter plot doesn’t tell a clean story. Worth watching given the restructuring but I wouldn’t act on it alone.

Palantir sanity check
Federal contracts are roughly a third of PLTR revenue. The correlation between obligation growth and their FCF metrics is strong and visually obvious. Good sign the methodology isn’t completely broken.

Honest caveats
30-90 day reporting lag on the data so recent quarters may be understated. The $90B FTI-NG ceiling figure comes from a single modification record and needs verification against primary FAA sources. I’m a data analyst not a contracting expert — if anyone has domain knowledge in FAA telecom or NNSA programs I’d genuinely appreciate a sanity check.

There are 136K entities in this database getting federal money. AmerisourceBergen’s trend is one I’m looking at next. Full writeup with charts here if you want to see the visuals: https://open.substack.com/pub/cavemanscreener/p/defense-contracts-and-fcf-looking?r=29p94e&utm\_medium=ios

u/JoeInOR — 2 months ago
▲ 27 r/BerkshireHathaway+1 crossposts

I correlated every Dividend Aristocrat's True FCF against NGDP. AXP came out #1. Buffett's second largest position. Here's the full data.

I got tired of P/E ratios so I built my own thing. 15 years of SEC XBRL data, True FCF (OCF minus CapEx minus SBC) for every Dividend Aristocrat, correlated against NGDP.

The finding that bothered me: 59% of Dividend Aristocrats have negative FCF/NGDP correlation. Their dividends aren't economic — they're structural. Clorox, Lowe's, JnJ — cash flows move independently of whether the economy grows or shrinks. That's either a moat or a warning depending on what you think comes next.

The three names that stood out:

AXP — 83% FCF/NGDP, 7% True FCF yield. Every Amex transaction is a clip on nominal GDP. Buffett's been sitting on this for decades. The screen explains why quantitatively.

CB — 10.2% True FCF yield, negative NGDP correlation. Countercyclical by design. Insurance underwriting profits when everyone else is bleeding.

KO — 78% revenue/NGDP, 18% FCF/NGDP. Revenue surfs the economy. Cash doesn't follow cleanly. Buffett bought it in 1988 when the True FCF yield was extraordinary. At 1.5% today the screen wouldn't touch it fresh. Neither would he.

Also ran 125 years of stocks vs gold vs the economy indexed to 100. The order surprised people in the comments last time I posted similar work — gold loses to NGDP badly. Stocks win on dividends alone.

Checked the math. Happy to share the truncated .csv. Link way down here: https://cavemanscreener.substack.com/p/surfin-ngdp-owning-the-necessaries

u/JoeInOR — 2 months ago
▲ 78 r/BerkshireHathaway+1 crossposts

We've all heard the AI capex story. I wanted to see the physical cash reality.

I got tired of net income headlines so I wrote a Python script to pull 16 years of SEC XBRL filings for every stock that's ever been in the S&P 500. I calculated True Free Cash Flow (Operating Cash Flow minus CapEx minus Stock-Based Compensation) for the Magnificent 7 to see who's actually printing cash and who's burning it building data centers.

Here's what the earnings releases aren't showing you:

The ugly:

  • Google's True FCF shrank from $47B to $46B while revenue grew 31%. CapEx nearly tripled — $32B to $91B.
  • Amazon's True FCF went negative in 2025 at -$11.8B. $131B in CapEx will do that.
  • Meta's True FCF fell 14% while Zuckerberg told everyone the AI bet was paying off.
  • Microsoft peaked at $63B True FCF in 2024, fell to $59.6B in 2025.

The exception: Nvidia. True FCF went from $2.9B to $56B in two years. They're the toll booth everyone else is paying.

The logical problem: The market is pricing all 6 as winners of an arms race where the math only works if at least one loses. Either CapEx spending ends at some point and they collect tolls like Buffett's bridge — or they keep feeding Nvidia indefinitely. Both sides can't win the bet simultaneously.

The P/True FCF multiples tell the real story. Google is at 86x. META is at 67x. These are growth prices for companies whose truest measure of cash generation is going backwards.

There's also a structural reason valuations stay this high despite the math — Gabaix and Koijen's inelastic market hypothesis. For every $1 of active buying, passive flows inject $5. Elon Musk knows this, which is why he wants SpaceX in the S&P 500.

Full 16-year charts on my Substack. https://cavemanscreener.substack.com/p/building-bridges-to-nowhere-the-magnificent

u/JoeInOR — 2 months ago
▲ 2 r/visualization+2 crossposts

I decided to step back a bit and try connecting to the full raw files I was able to pull from the SEC to see if any larger patterns emerged, and also to look for value in places other than the usual SaaS stocks.

For better or worse, what emerged from the mass data analysis with the most beautiful-looking historical trends were actually a couple of SaaS stocks (Salesforce $CRM and Roper $ROP).

When you look at the raw numbers, their increasing revenue is perfectly translating into increasing True Free Cash Flows, and even expanding margins. These companies have a massive runway of growth left, their moats are untouched, yet they have lost a lot of market cap recently because of “AI fears.” Personally, I think those fears are wildly overblown, and the physical reality of these graphs is why.

Here is how I view the AI panic as a data guy:

I build data ecosystems, and I do predictive modeling. Creating an ecosystem (software) lets me understand billions of rows of data cheaply and efficiently. Doing predictive modeling (AI) takes a massive amount of bandwidth and energy to profile a fraction of that data.

Software companies are cheap, scaled problem-solving. That’s why their margins are so high. Generative LLMs are heavy, energy-intensive problem-solving. Yes, LLMs will replace some software features. But LLMs need structured context to run efficiently. They need reams of deterministic data to give a halfway decent answer. That data will come from highly-profitable, scaled software fortresses like Salesforce and FactSet.

Wall Street is selling the cheap, high-margin software tollbooths to buy the expensive, low-margin AI power plants. I’ll gladly take the other side of that trade.

Looking outside of tech, a few other non-SaaS outliers showed up on the grid that tell an interesting story. $BLDR (Builders FirstSource) spiked mid-COVID when everyone wanted a bigger home, but with its cyclical nature and high rates, I’m cautious. $WTRG (Essential Utilities) sticks out to me, though. Anything with fat margins, lots of yield, steady growth, and the word “essential” in the name seems like a great place to hide right now.

This isn’t a deep dive into any single ticker. It's more of a proof-of-concept for how we can visualize massive amounts of SEC data to expose outliers, avoid value traps, and find the real cash generators.

For the actual visuals (scatterplots and time-series grids), I put the write-up on my Substack here:https://cavemanscreener.substack.com/p/the-power-of-screening-with-raw-data

If anyone wants to play with the raw dataset I used to build this, just drop me a message and I’ll send you a cut (I'm also building it into a web app so I don't have to keep running Python scripts). Curious if anyone else is buying the SaaS dip right now.

u/JoeInOR — 2 months ago
▲ 37 r/ValueInvesting+1 crossposts

We’ve all heard the narrative: the "SaaS-pocalypse" is here, and AI agents are going to destroy software seat usage. I hold the conflicting belief that the market usually knows more than I do, but I wanted to see the physical reality.

I got tired of Wall Street's "Adjusted EBITDA" nonsense, so I wrote a Python script to ingest 15 years of SEC filings for 1,400 stocks. I calculated True Free Cash Flow (Operating Cash Flow minus CapEx minus Stock-Based Compensation) to see who is actually printing physical cash, and whose moat is eroding.

I cross-referenced True FCF Yield against 5-year FCF compounding and margin expansion. Here are the three most violent macroeconomic divergences in the market right now:

1. The Screaming Buy: Workday ($WDAY) The stock is down -50% over the last year. Wall Street thinks the HR software cycle is dead. But the math says they are yielding 7%, and they compounded Free Cash Flow at 40% a year for the last 5 years. The physical moat is completely intact, and you are getting it for half price.

2. The Value Trap: Gen Digital ($GEN) It screens at the very top of my list with a mouth-watering 18% FCF yield. But the script flagged a terminal decline: their 5-year margin CAGR is -24% and top-line revenue is shrinking. The yield is high because the market correctly assumes it's a melting ice cube losing to CrowdStrike and MSFT Defender.

3. The "AI Context" Play: FactSet ($FDS) FactSet has been punished by the market (down -46%), pushing its True FCF yield to 7%. But as someone who works in data science, I can tell you LLMs are useless without structured context. FactSet owns the proprietary context of the stock market. It has rock-solid top-line growth (~9%), and Wall Street is throwing it away.

The Takeaway: The market is right that some SaaS is dying, but it's throwing out the compounding monopolies with the bathwater.

Note: I couldn't format the massive 10-year data tables and the full list of 30 stocks on Reddit, so I put the raw data, the charts, and the $CRM breakdown on my Substack here if anyone wants to check my math: https://cavemanscreener.substack.com/p/saas-value-traps-and-ai-context-by

u/JoeInOR — 2 months ago