Quick Peek at Bank Performance

Q3 earnings releases will start arriving in volume this week, with Wall Street banks leading the way. By 7:45 a.m. this morning we already had earnings data from Wells Fargo ($WFC), JPMorgan Chase ($JPM), and Goldman Sachs ($GS). 

As a warm-up exercise for data analytics superpowers, the Calcbench analytics team pulled together a quick comparison of return on equity (one of the most important performance metrics banks report) for all three banks for the last eight quarters. See Figure 1, below. 



As you can see, JPMorgan has the best performing ROE overall, but Goldman has the best-performing trendline even though its ROE is starting from a lower base. And we also have Wells Fargo, finally unshackled from years of tight regulatory oversight and trying to put some pep back in its ROE step. Looks like Wells still has a ways to go on that front.


We built the above chart in about three minutes. Start from the Recent Filings page (which typically captures filing data within minutes of the information hitting the Securities and Exchange Commission), and then pull up individual firms’ earnings data on the Disclosures & Footnotes Query page. From there you can find specific ROE disclosures, and then use the Show Tag History feature to see prior periods’ disclosures for the same metric. Paste all that data into Excel and you’re done!


Of course, Calcbench subscribers can also mainline earnings data directly into your pre-existing models using our API or the Calcbench Excel Add-in; or you can search for disclosures across multiple companies all at once using our Multi-Company page. 


You get the idea: Calcbench has the data, and lots of different ways to find it and study it within a few keystrokes. Now get back to work studying more filings!

Comments

Post a Comment

Popular posts from this blog

On Amazon and Server Lifespans

So there we were the other day, skimming the latest from Deep Quarry , a newsletter on financial statement analysis written by accounting aficionado Olga Usvyatsky.  She had been picking apart Amazon.com’s latest quarterly report , and noted that the e-commerce giant had revised the useful life of certain servers and networking equipment downward from six to five years. That change, Usvyatsky noted, will have the practical effect of reducing 2025 operating income by $700 million. Moreover, Amazon ($AMZN) also decided to retire some equipment early; that led to $920 million in accelerated depreciation in Q4 2024 and will reduce 2025 operating income by another $600 million. Wait a minute. The useful life of computer servers, why does that sound familiar…  Because Calcbench wrote about that exact issue in 2021!  Back then, we noted that Google ($GOOG) and Microsoft ($MSFT) had both extended the estimated life of their computer servers from three years to four, which had t...
Read more

McDonalds versus Chipotle Earnings and KPIs

Image
This morning (July 29) , McDonalds reported Q2 earnings.  Last week (July 24th), Chipotle Mexican Grill did the same.   Since we have the financial data catchers mitt, we thought we would roll up the sleeves and get to work a little.   First question: 'How did the firms fare?'  A quick as-filed income statement should suffice: MCD: Sales Flat.  Profits Down.  But levels are high meaning they make a lot of Big Macs consistently.     CMG: Sales way up (18.3% YoY) and Profits as measured by Net Income up 33.3% YoY.  The business is objectively smaller than MCD though.  There are other ways to compare these firms and we love to talk about our ability to showcase the tools that allow for that comparison.   Using our earnings press-release toolkit allows us to compare things like Net Profit Margins in real time for these firms.  Like this quarterly since 2010:   In the last 10 plus quarters, McDonald's is 2-3 times more pro...
Read more

Inventory as a Non-Current Asset

Image
Most financial analysts think of inventory as a current asset, and in most cases you’d be correct — except for those cases where you’re not.  Turns out, more than a few companies disclose inventory as a non- current asset. The tricky part is that in many of those cases, the non-current inventory is added to “other assets.” You, the financial analyst on the outside, need to dig into the footnotes if you want to find that information.  Typically that would be a painstaking exercise — but fear not! XBRL is coming to the rescue with a dedicated XBRL tag, InventoryNoncurrent . That allows you to use Calcbench to find the item simply and quickly. So what is non-current inventory, anyway? One example of non-current inventory comes from Pfizer (PFE). The pharma giant reported $4.57 billion in non-current inventory at the end of 2023, compared to $10.19 billion of current inventory. The information was included in the Other Financial Information note, and included the following table ...
Read more