My architecture for models has always been: a core MOD tab that includes 10-20+ years of annuals and 5-10 years of quarters, then a string of tabs that build out deep analytical work around all of the core questions of the business (KPI correlations, EPS scenarios/sensitivities, balance sheet stress test, normalized profitability, historical guidance evolution, divestiture scenarios, etc - whatever the unique investment question demands).
This is where the real thesis in a company emerges "oh this competitive threat on this device will lead to a 7% revenue miss and given it's high GM structure a 12% EBITDA miss, and the company may also have to pull their LT guidance at investor day in Fall". This doesn't show up in the P&L on first cut, but in the Excel analytics around the model, informed by multi-dimensional due diligence (talking to mgmt, peers, reading industry trade rags, reading sell-side research, studying past category priors, talking to KOLs, etc), that then feeds back into generally a singular P&L assumption (incredibly depth behind the simplicity of one assumption). And in pitching ideas (I've always been a fan of 100 page decks with the 15 key slides then 85 appendix slides), these tabular analytics become copy and pasted into PPT for team conversation. The opposite of vibes based investing...
But the historical PL/BS/CF baseline is critical to start asking questions around KPI correlations or historical behaviors of the business & management team (i.e. "when revenue was weak, how did the CFO pull cost levers"). This quantitative history lesson is a critical step in building deep comprehension around companies & industries. And is one (of the many reasons) I have never let my teams use sell-side or other modeling templates, they just weren't flexible enough to serve as the right backbone.
But is there alpha directly in just updating 20 years of annuals and 10 years of quarters? Of course not. And how much of my life has been wasted doing so in a clean, accurate way. A LOT, lol. A lot of my 20s to be honest, sadly, was spent as an Excel jockey late into the evenings ordering delivery from Tao...generally orange chicken & banana pudding, which is why I tipped the scales at 280+ at one point.... But the alpha-generating insights sit on top of this important analytical infrastructure. Building a clean historical model is necessary but not sufficient, and, at the top funds, no vendor/service really solved this (until roughly 2015 when I started using Insync for historical baselines).
So it is so nice that the updating & spreading of historical numbers has become a "push-button exercise".
This frees up my time to go deeper on the key questions that matter, in TABS around the core MOD structure.
I'll give you one example, with Claude in Excel, I am curious how much of the
$GOOG story is contingent on YouTube. Not a SOTP / spin-off story, but more of a value derivation question today, but more importantly in thinking about the forward 3-7 year growth algorithm at Google in a world where search may mature, how much can YouTube carry the baton to sustain high growth in revenue/EBITDA/EPS? Companies don't make this easy for us as investors with obfuscated disclosures that require layers of assumptions, generally for competitive reasons. Calls with IR, formers and sell-side can often refine these assumptions.
Once you have the right PL/BS/CF baseline, these sorts of analyses are becoming incredibly easy to run, and off of each company model there could be a dozen+ of these sorts of questions, quantified.