Obvious question for financial analysts: which firms make these drugs, and how important are those products to the company’s total revenue? 

Don’t worry — Calcbench figured it out for you!

Pharmaceutical firms are required to report annual sales of their blockbuster drugs as individual operating segments of the whole business. So we just took the list of drugs newly added to the Medicare Negotiation program, identified who sells them, and then looked up each drug’s individual revenue. The result is Table 1, below.

As you can see, some of the drugs are major revenue sources for their respective manufacture. Xifaxan, used to treat diarrhea, accounted for 20 percent of Bausch Cos.’ ($BHC) total sales in 2023; that’s a lot of exposure. 

Even more precarious is the position of Novo Nordisk ($NVO), which has three weight loss drugs (Ozempic, Weygovy, and Reybelsus) on the list, and altogether they accounted for a whopping 36 percent of Novo’s revenue in 2023.

What will the numbers look like for 2024? Ask us in a few weeks as the pharma firms start filing their annual reports. We’ll stay on it. 

To be clear, nobody yet knows what price the incoming Trump Administration will negotiate with the pharma companies on our list, or whether the Trump Administration will even bother negotiating at all. President-elect Trump has railed about the high price of drugs before, but the pharmaceutical industry has challenged the legality of the Medicare Negotiation Program in court and it’s not clear that the Trump Administration will bother to defend it.

Politics isn’t our thing here so we’ll have those questions alone. Still, right now, the addition of new drugs to the negotions list poses a significant new risk to Big Pharma firms. Calcbench can help you quickly identify and assess the size of that risk, so you can respond accordingly.

Figure 1, below, shows UnitedHealth’s total revenue for the last eight quarters. As one can see, revenue in 2024 was up appreciably from 2023. 

Figure 2 shows that quarterly revenue broken down by business unit. To little surprise, insurance premiums accounted for the solid majority of all company revenue. 

That’s how the money is coming in. Figure 3, below, shows how it’s going out: UnitedHealth operating expenses for the last eight quarters. Again to little surprise, most of UnitedHealth’s costs go toward paying medical claims. 

Lastly, we wanted to understand medical costs as a portion of revenue. Figure 4 shows that for the last eight quarters that number has stayed within a narrow band, accounting for roughly two-thirds of all revenue every quarter for the last two years. 

The Calcbench research team pulled together all these charts in less than 10 minutes, using the Export Data Tables feature we discussed in a post earlier this week. That feature is available to all Calcbench users, to dig up precise, comprehensive, segment-level data with just a few keystrokes.

Start with our Recent Filings page, which tracks and indexes corporate filings typically within a few minutes of those filings arriving at the Securities and Exchange Commission. For many companies (and almost all large ones), you’ll see an option on the far right side of your screen that says Export Data Tables. See Figure 1, below.

If you click on that Export Data Tables option, Calcbench will then open a new tab displaying all the table data from the company you’ve chosen in spreadsheet format. We randomly selected Calumet ($CLMT), a solvents manufacturer that filed preliminary earnings results on Jan. 14, to see what would come up. The result is Figure 2, below.

OK, a quick table to reconcile Calumet’s estimated net loss for Q4 to the company’s Adjusted EBITDA. Calumet reported a potential range for Q4 net loss, and we won’t know the precise number until it files a full earnings release and quarterly report in a few weeks — but you can already see some internal adjustment items and what they’re likely to be.

There’s more, too. Look at that row of buttons above the spreadsheet: the second one from the left says “Filings.” If you click on that button, you’ll get a new display that lets you see all the recent filings right there next to your spreadsheet. See Figure 3, below.

Now you can choose from any of the filers on that new pane on the right; when you hit “Export Data Tables” again, that information will automatically populate into the spreadsheet display on the left.

Even better, notice the text field above that list of recent filers. You can type in the name of any company, and get a display of all filings for that company. We typed in JPMorgan Chase ($JPM), and got the results shown in Figure 4, below.

Astute observers will notice the spreadsheet display is now different. That’s because once the list of JPMorgan filings appeared, we clicked on Export Data Tables for the Form 8-K earnings filing listed near the top. As soon as we did, Calcbench displayed all important financial metrics at the top and then listed 10 tables’ worth of data further down the spreadsheet. It’s all there, waiting to be exported to your own desktop in a tidy Excel spreadsheet. 

(Especially astute observers will even notice that the Calumet data is still there on the spreadsheet too, in a secondary tab pushed to the back.)

You can use these capabilities to hop from one filing to another, extracting footnote-level disclosures and piling them into nifty spreadsheet tables with just a few clicks; Calcbench does all the heavy extraction and processing for you. Everything is neatly labeled, lined up, and ready to go.

All you need is a Calcbench subscription, a keen sense of which companies you want to study, and strong fingers to start typing as soon as the earnings data starts to arrive. We’ll do the rest!

We always love Delta earnings reports because they’re a great example of the non-GAAP disclosures that companies make, and which Calcbench tracks. In the airline world, two critical non-GAAP disclosures are total revenue per available seat mile (TRASM) and cost per available seat mile (CASM). Just about every major airline reports those two items in their earnings releases, including Delta. 

Calcbench indexes both disclosures, so you can track them through time using our See Tag History feature. We did precisely that, and the result is Figure 1, below. 

As you can see, TRASM has generally stayed above CASM for the last three years, except for a brief period at the start of 2022 (when inflation was all the rage). 

The airlines publish lots of other nuggets too, such as fuel expense ($2.41 billion for the fourth quarter at Delta), average fuel price per gallon ($2.36, which is less than what Calcbench pays at the pump), aircraft rent expense, landing fees, and other items. Delta also breaks out revenue for passenger services, cargo service, and the always popular “Other” line of revenue.

We’ll be publishing more earnings snippets in days and weeks to come; and don’t forget our world-renowned Calcbench Earnings Tracker, which compiles earnings performance every quarter compared to the year-earlier period. We don’t have enough 2024 filings yet to launch the tracker for Q4, but it will be up and running soon!

We can start with a look at the earnings release, filed on Dec. 12. The semiconduct giant reported $51.57 billion in revenue, up 44 percent from the prior year; operating income of $13.46 billion, a decline of 17 percent; and net income of $5.89 billion, down 58 percent. 

Except, those are the boring old GAAP numbers. Read further down the earnings release and you arrive at adjusted, non-GAAP numbers, and they tell quite a different tale. See Figure 1, below. 

Broadcom booked so many adjustments, of such large size, that its GAAP net income of $5.89 billion transformed into non-GAAP net income of $23.73 billion — up 29 percent from $18.79 billion in non-GAAP net income for the prior year. 

One can see the line-item adjustments driving that non-GAAP change:

• $9.27 billion for amortization costs

• $5.67 billion for stock-based compensation

• $1.79 billion for restructuring costs

OK, companies make those adjustments to arrive at non-GAAP net income all the time — but these are huge numbers. What, specifically, is driving them at Broadcom? 

To answer that question, we opened the Footnotes and Disclosure tool and searched for the word “amortization” in Broadcom’s 10-K report, which the company filed on Dec. 20. This resulted in matches all over the report, but one match caught our eye immediately: the Management Discussion & Analysis. 

We went there, and found our answer: Broadcom’s acquisition of VMWare! That deal, which closed in November 2023, was valued at $61 billion; and the financial reporting consequences are visible all over the income statement. Consider these excerpts from the MD&A:

Selling, general and administrative expense increased $3,367 million, or 211%, in fiscal year 2024, compared to the prior fiscal year. The increase was primarily due to higher compensation, including higher stock-based compensation, as a result of an increase in headcount from the VMware Merger… 

Restructuring and other charges recognized in operating expenses were $1,533 million and $244 million in fiscal years 2024 and 2023, respectively. The fiscal year 2024 charges primarily included employee termination costs from cost reduction activities related to the VMware Merger…

Amortization of acquisition-related intangible assets recognized in operating expenses increased $1,850 million, or 133%, in fiscal year 2024, compared to the prior fiscal year primarily due to higher amortization of customer-related intangible assets from the VMware Merger…

We could continue, but you get the picture. Broadcom swallowed a whale when it acquired VMWare, and that whale will take some time to digest.

Actually, that brings up another question. What might future amortization costs be? After all, Broadcom acquired a lot of intangible assets from VMWare, and those assets are amortized on a straight-line basis until they reach zero. So you can model out future amortization of intangibles, and Broadcom provides a table listing those costs! It’s right there in the Goodwill & Intangibles footnote disclosure. See Figure 2, below.

Broadcom even discloses how many years it will be amortizing the various intangible assets it has. We can’t say for sure that all of the amounts above relate directly to the VMWare deal, but clearly that deal accounts for a substantial portion of things. 

That’s all just one example of how you can study non-GAAP disclosures in Calcbench to understand where they come from and what they mean for the company’s overall operations. The data is all there; you just need the right tools to pull it out! Happy holidays!

What happened, exactly? We’re not sure, and it seems that Krispy Kreme isn’t either. The company only disclosed that on Nov. 29 it was “notified regarding unauthorized activity on a portion of its information technology systems… The company is experiencing certain operational disruptions, including with online ordering in parts of the United States. Daily fresh deliveries to our retail and restaurant partners are uninterrupted.”

OK, that’s not good. Krispy Kreme then continued, saying that the attack “has had and is reasonably likely to have a material impact on the company’s business operations until recovery efforts are completed. The expected costs related to the incident… are reasonably likely to have a material impact on the company’s results of operations and financial condition.”

That disclosure arises from a rule the Securities and Exchange Commission adopted in 2023 requiring companies to disclose material cybersecurity incidents. Companies need to disclose the nature and scope of the attack, along with any estimate of the attack’s impact on the company’s operations and financial condition. 

Typically those incidents are privacy breaches, which might result in painfully expensive litigation and regulatory costs — but more and more often, we’re also seeing incidents that are ransomware attacks disrupting actual operations. That seems to be the case for Krispy Kreme here. 

One interesting thought experiment is to look at Krispy Kreme’s recent financial reports, to get a sense of how much this attack might cost. 

For example, Krispy Kreme already says the attack will be material to operations. Well, in Krispy’s most recent quarterly report, it reported net income of $55.2 million. If we define material as 2 percent of that number, the attack is costing the company at least $1.1 million.

To be clear, that is speculation on our part. When Krispy says the attack will have a “material impact on the company’s results of operations, we don’t know whether the company is talking about revenue, operating income, or some other metric. But something material is going on.

Astute analysts might also be wondering: “If Krispy Kreme suffered a material attack, doesn’t that mean its IT controls were weak? Isn’t that the sort of thing a company is supposed to discuss in its Controls & Procedures disclosure?”

Yes it is, and you raise an excellent question. Using our Footnotes and Disclosure Query tool, we found that Krispy Kreme reported in its Q3 2024 report that internal controls over financial reporting were fine. Ditto for its more fulsome discussion of internal control in the 2023 10-K filing from earlier this year. We at Calcbench don’t have a good answer for what went wrong now; you might want to ask that question on Krispy’s next earnings call. 

As Krispy Kreme gets a grip on this incident and the damage becomes more clear, the company should disclose more precise details about the cost. We’ve found other filers, for example, that even reported “earnings adjusted for cybersecurity incident.” 

Thankfully, you can still get donuts at Krispy Kreme locations. Food for thought as you’re standing in line.

Typically that work falls to the Financial Accounting Standards Board (FASB), and they have some fresh news on that front.

FASB is working on a new project to study financial key performance indicators. The group recently published a call for people in the financial analysis world (that would be you) to comment on what makes for good financial KPIs, and we encourage our readers to give FASB’s request a read and offer your opinion.

Oh, and the data that FASB used to do its preliminary research on KPIs came from Calcbench. #HumbleBrag

Why is FASB undertaking this project, and why should you care? Because more and more companies are disclosing financial KPIs in their earnings releases, but those KPIs —  EBITDA, adjusted EPS, free cash flow, or various others — are not part of U.S. Generally Accepted Accounting Principles, which means they aren’t subject to the same rigor and uniform structure as GAAP.

For example, when you look at a GAAP disclosure (revenue, inventory, liabilities, net income, and so forth), you can be confident that all filers calculate those disclosures in the same manner. That’s not the case for, say, adjusted EBITDA, adjusted EPS, or other financial KPIs; companies must calculate such KPIs consistently from one period to the next, but each company can perform those calculations in its own way. 

But back to that point about so many companies now disclosing financial KPIs. If so many companies are doing so, perhaps FASB should try to bring some order to that chaos? That’s the question this KPI project is trying to answer. See Figure 1, below, which shows the five financial KPIs most often cited by public filers.

Finding KPIs in Calcbench

You can find financial KPIs in Calcbench in several places.

First, if you’re researching a specific company using our Company-in-Detail page, you have an option to see the non-GAAP financial metrics that company might report. You’ll find that by looking for the “Show Guidance and non-GAAP Metrics” tab immediately above the data display. Figure 2, below, shows an example from Ingredion ($INGR). 

The red arrow points to the relevant tab you want to activate. It appears as “Hide Guidance and Non-GAAP” above because we’ve already pressed it; and when we did, those three KPIs — adjusted net income, adjusted EPS, and adjusted operating income — all appeared. 

For example, if you look further down the table, you’ll see GAAP operating income too, which is only $268 million compared to the non-GAAP adjusted operating income of $282 million. You’d see the same for net income and EPS too, but we clipped them from the image for the sake of brevity.

You can also use our Multi-Company page to research the financial KPIs of several companies at once. Figure 3, below, shows several of Ingredion’s peer companies and a few of the financial KPIs they disclose. Note that they all disclose adjusted revenue and EBITDA, but only some report non-GAAP operating income.

You can also search for non-GAAP financial metrics via our Disclosures and Footnotes Query page. For example, you could select a group of companies and then search their earnings releases for telling phrases, such as “adjusted net income.” We did that for S&P 500 companies that filed earnings releases in the last 30 days, and found two: Medtronic ($MDT) and Dollar Tree ($DLTR). 

Presumably we found only two because most S&P 500 companies had filed their latest earnings releases in October, along with their Q3 2024 results. Anyway, that quickly let us see what adjusted net income those two companies filed, along with other non-GAAP financial metrics also disclosed nearby.

Speak up!

Back to FASB’s call for comment. FASB lists numerous questions it has about financial KPIs, where the group would welcome comment from investors and companies alike. Such as:

• If you use financial KPIs in your analysis, are the financial KPIs you use comparable across different entities?

• If your company and your company’s peers present financial KPIs outside the financial statements, are the financial KPIs comparable?

• Would you benefit from standardized GAAP definitions of commonly used financial KPIs? 

• Should the FASB provide criteria for entities to use to determine when a defined financial KPI needs to be disclosed? 

And so on and so forth. We all want better, more rigorous financial data, and projects like these are what allows such data to happen. So if you care about financial reporting and have feelings on KPIs, do share them with FASB. And if we can help with your other non-GAAP financial analysis challenges, drop us a line at us@calcbench.com to tell us what’s on your mind!

Figure 1, below, shows Nvidia’s revenue by geographic segment for the last few years. 

As you can see, from the start of 2022 into mid-2023, Nvidia’s largest single market was Taiwan; but even then, the company also had an impressively even spread of revenue among the United States, China, and the rest of the world too. 

That all changed at the start of this year, when the U.S. first became Nvidia’s primary geographic market — and then peeled away from all others, even as total revenue had also taken off like a rocket. In the space of nine months, the U.S. market had become hugely important for Nvidia’s success. 

Then we get to the really good stuff: Nvidia’s revenue by operating segment. See Figure 2, below. 

Holy silicon! We knew for a while that sales of chips for AI systems (seen in blue above) were leading the charge at Nvidia, but we didn’t appreciate just how much Nvidia has become an AI chip company. Its revenue from AI chips have zoomed into the stratosphere, while a few side businesses still bring in about $3 billion every quarter. 

To put things another way, those non-AI segments at Nvidia are on pace to bring in $12.9 billion in 2024. If Nvidia spun out those rump segments as a stand-alone business (and we can hear you all saying, “Hmmmm, that’s interesting….”), that NewCo would fall smack in the middle of the S&P 500. And it’s the business we’re all squinting to see, compared to the AI chip segment. 

Pulling together this analysis was easy. We simply opened our Footnotes & Disclosure Query page and looked up Nvidia’s operating segments disclosure. Then we hovered our cursor over the relevant tables for a moment until ‘Export tag history’ appeared, and exported. A few quick keystrokes later in Excel, and we had our charts ready for you.

Who could’ve guessed that was coming? Calcbench users, that’s who!

Back in August we had two consecutive posts about large entertainment companies taking big impairments on their cable TV operations: Warner Bros. Discovery ($WBD) announced a $9.1 billion impairment charge on Aug. 7, and then Paramount Global ($PARA) followed up with a $6 billion impairment charge one day later. 

In both instances, the companies disclosed a long-term growth rate of negative 3 percent and discount rates of an eye-popping 10.5 percent (Warner Bros.) and 11 percent (Paramount). 

With horrible long-term prospects from those two, should anyone really be surprised that Comcast is getting out of cable TV now, before things get even worse? 

Comcast didn’t disclose similarly precise (and grim) projections in the Management Discussion & Analysis of its most recent quarterly report, but you could find clues in the text if you looked. For example, Page 20 provided a table breakdown of Comcast’s various operating units, including a “Media” unit that saw Q3 revenue up 36.5 percent. 

Underneath that table, however, Comcast warned that “We operate our Media segment as a combined television and streaming business. We expect that the number of subscribers and audience ratings at our linear television networks will continue to decline as a result of the competitive environment and shifting video consumption patterns…” (Plus, those Q3 numbers included a one-time pop from broadcasting the Olympics. Excluding Olympic revenue, the Media unit’s overall revenue only grew 4.9 percent.

One could also use our Disclosure & Footnote Query page to research whether Comcast has taken any goodwill impairments of its own. 

The answer, according to the company’s 2023 annual report, is kinda sorta. The goodwill in Comcast’s Media division held steady at $14.7 billion in 2021 and 2022, and then was revised upward in 2023 to $21.9 billion largely as a result of the company re-jiggering some of its operating divisions; but it also declared an $8.1 billion impairment in 2022 for its Sky operating division, which is the British media business that Comcast acquired in 2018.

In other words, if you had been reading Comcast’s footnote disclosures closely, and kept an eye on what its competitors were saying, it wouldn’t be far-fetched to guess that Comcast might do something like spin out its media business. 

The pieces of that mosaic were all there, scattered in the data. You just needed a good tool (like Calcbench) to find them!

As devout readers of this blog know, we use the Earnings Tracker to collect financial disclosures as companies file their latest earnings releases with the Securities and Exchange Commission. We first turned on the tracker for Q3 2024 earnings several weeks ago; as of today we now have data on nearly 3,200 non-financial firms crunched and ready for your analysis.

The headline performance numbers are in Figure 1, below.

As you can see, revenue is up 3.7 percent from the year-ago period, while net income is down 8.3 percent. We previously noted that the decline in net income was driven by two specific one-time items at Intel ($INTC) and Johnson & Johnson ($JNJ) that were so huge they skewed net income for the entire sample; strike those two, and net income for everyone else was actually up. 

That still holds true this week. Net income for all 3,200 firms was collectively 8.3 percent lower than third-quarter 2023, but if you strike Intel and J&J, net income is actually up 2.1 percent.

Even more interesting, however, is that (net) capex spending number: up 17 percent from the year-earlier period. In theory that’s great news; it means that lots of companies are spending lots of money to buy equipment, build plants, install new technology, and do all sorts of other things to foster long-term economic growth. 

So is that what’s really happening? As always, Calcbench dug into the data to find out. 

Answer: no.

Concentration of Capex

First let’s look at the absolute numbers. Total capex spending reported so far for Q3 2024 is $322.1 billion. That’s an increase of $46.9 billion from the year-earlier amount, which was $275.2 billion.

But then we looked at the companies that reported the largest increases in capex spending. The 10 firms with the largest spending jumps reported a total increase of $49.1 billion — which is $3 billion more than the total increase for the whole sample group of 3,200 firms. 

In other words, those big-spender firms accounted for all of the increase in capex spending, and then some. Among the other 3,190 firms in our sample, capex spending actually fell. 

Figure 2, below, shows who those 10 big spenders actually are. 

They are all tech companies, energy companies, and telecom companies. That’s it. Capex spending among all other companies, in all other industries, is collectively less this Q3 than it was one year ago.

What does that mean for economic growth in the future? We don’t know, but clearly an insight like this is worth keeping in mind as you run your own models and prepare for whatever earnings call is on your calendar. Calcbench gives you the information you need to ask better questions, and then find better answers. 

Calcbench will continue to update our earnings tracker at the end of every week for the next few weeks, as quarterly reports flood into the database. 

If Calcbench subscribers wish to get their hands on the template we use for this analysis, so you can conduct your own experiments at home, use this link to the file. 

Please note that it will only work with an active Calcbench subscription. If you need an active subscription (and who doesn’t, really, when swift access to real-time data is so important?), contact us at us@calcbench.com.

This is important because more companies now have more of their total assets tied up in goodwill or other intangible assets — so if you do need to declare an impairment, it can be a gut punch to the income statement. Investors do not like this, and financial analysts are always on the lookout for warning signs of impairments. 

The good news is that we have no visible shifts in market dynamics this year that suggest a wave of goodwill impairments are looming. (Compare that to, say, 2020, when the covid pandemic forced companies to declare goodwill impairments all over the place.) Still, we wanted to get a sense of companies’ overall exposure to goodwill assets, just as a thought experiment to help us understand who might be most vulnerable to impairment risk.

For example, Figure 1, below, shows the comparison of goodwill, intangible assets, and all other assets for the S&P 500 for the last five years. (Using our Bulk Data Query page, we did this in about two minutes.)

As you can see (if you squint), goodwill and other intangibles actually fell as a percentage of total assets among the S&P 500, from 14.8 percent in 2019 to 13.7 percent in 2023. Goodwill alone fell from 9.3 percent to 8.9 percent. 

OK, but perhaps that’s because S&P 500 firms tend to have large operations with lots of cash, inventory, and other physical assets. Would a larger pool of companies give a different result? Again using the Bulk Data Query page, we ran the same exercise for all non-financial companies with more than $100 million in annual revenue, about 2,100 firms in total. The result was Figure 2, below.

So we have the same pattern of goodwill and intangibles declining as a percentage of total assets over time, but they do start from a higher base: 27.4 percent of total assets in 2019, to 25.6 percent last year. What will they be for 2024 numbers? We’ll know in another five months or so.

Of course, what’s more useful to financial analysts are insights about the specific companies that have a high percentage of total assets tied up in goodwill. No fear, Calcbench can do that too! We fired up our Multi-Company page to identify those firms with the highest goodwill percentage, again looking at all non-financial firms with $100 million or more in revenue. The top 10 are in the table below.

To be clear, we have no idea whether any of these firms actually will declare goodwill impairments. We’re simply pointing out that these are the firms with an exceptionally high portion of total assets tied up in goodwill. But if you’re an analyst wondering about where goodwill impairments might send a company reeling, exercises like these are one good, logical place to begin.

All you need is the data, which Calcbench has in spades.

One good example comes from Dollar General ($DG), the discount retail giant that made $38.7 billion in its fiscal 2023. Dollar General filed its second-quarter earnings release at the end of August, and included numerous nifty items:

• Same-store sales

• Merchandise inventories

• Category sales

• Store count

• Square footage

You can track all these disclosures in the Footnote Query & Disclosure tool in Calcbench, seeing how they have evolved over time. For example, we used the Export History feature to dig up the total square footage of Dollar General stores for the last 14 quarters and put them into a chart. Figure 1, below, took us less than three minutes. 

But wait, there’s more! We then dug up Dollar General’s quarterly revenue, too; and calculated revenue per square foot over the same period. See Figure 2.

So even though revenue increased by 21.5 percent over those 14 quarters (from $8.4 billion at the start of 2021 to $10.2 billion in second-quarter 2024), revenue per square foot only went from $65.15 to $66.10 in that same timeframe. Except for a single spike at the end of 2022 (hello inflation, we see you there), revenue per square foot fluctuated within a narrow band.

Other Retail Metrics

Another critical metric for retail sector performance is same-store sales, also known as comparable store sales. It measures the change in sales at individual stores open for some set period (usually a year), so analysts can get a better sense of trends in the company’s sales growth without the influence of new stores opening or failed stores closing.

Same-store sales growth is typically reported in the earnings release, and you can often find it in the Management Discussion & Analysis of the 10-Q, too. We pulled comparable-store sales growth for Target ($TGT), shown in Figure 3, below.

Yet again, we see that sales growth was doing OK until mid-2022 when inflation flared up, and then faltered through most of 2023. Only earlier this year did comparable-store sales rebound, when inflation had largely receded. 

What will Target’s comparable-store sales growth be for Q3? Ask us again in a few weeks, when the company files. 

You can explore other nooks and crannies of disclosure, too. For example, Macy’s ($M) reports same-store sales broken out by stores the company actually owns and those where Macy’s simply licenses the brand name to other owner-operators. Williams Sonoma ($WSM) breaks out revenue by specific store brands it owns. See Figure 4, below.

Other retailers report breakouts of products sold, although that’s more usually seen in the full 10-Q rather than the earnings release. 

All of it, however, is promptly collected and indexed by Calcbench! Just use our Disclosures and Footnotes Query page to dive into the data as deeply as you want, for as many retailers and you want. We have the data!

So says the Calcbench Earnings Tracker, which we use during earnings season to collect financial disclosures as companies file their latest earnings releases with the Securities and Exchange Commission. We first turned on the tracker for Q3 2024 earnings last week; as of this week we now have data on more than 2,300 firms crunched and ready for your analysis.

Figure 1, below, shows the headline data.

That 7.3 percent decline in net income might seem alarming, but the drop is thanks to two huge, one-time items from Johnson & Johnson ($JNJ) and Intel ($INTC):

• J&J reported a massive gain one year ago when it sold off its stake in Kenvue Corp. ($KVUE) for $21.7 billion. That gain didn’t recur in Q3 2024, so even though J&J reported $2.7 billion in net income this quarter, that’s down roughly 90 percent from the $26.03 billion the company reported one year ago. 

• Intel reported a $5.6 billion restructuring charge for Q3 2024, along with various other losses. So Intel’s bottom line for this quarter is a stunning $16.64 billion net loss, compared to $297 million in net income one year ago.

If you drop Intel and J&J from our sample, then the remaining 2,300 firms saw net income increase by 3.5 percent compared to one year ago. See Figure 2, below.

Just goes to show that you should always dig deeper into the data for better insight. You’ll find lots if you look.

Meanwhile, we can also see that most major financial metrics moved into positive territory this week, including capex, opex, inventory, assets, liabilities, and cost of revenue. One week ago most of those categories were still lower than the year-earlier period. See Figure 3, below.

Calcbench will continue to update our earnings tracker at the end of every week for the next few weeks, as quarterly reports flood into the database. 

If Calcbench subscribers wish to get their hands on the template we use for this analysis, so you can conduct your own experiments at home, use this link to the file. 

Please note that it will only work with an active Calcbench subscription. If you need an active subscription (and who doesn’t, really, when swift access to real-time data is so important?), contact us at us@calcbench.com.

First example: the inventory turnover ratio, a crucial performance metric. Calcbench tracks that!

The inventory turnover ratio measures how many times a company “turns over” (that is, sells and replenishes) its inventory in a given period. You calculate it by dividing the cost of goods sold into the average inventory for a given period. A higher number is considered good, since it typically means you’re selling goods at a brisk pace. (Although it can mean you’re not stockpiling enough inventory, too.) 

But why bother with all that math yourself? Calcbench tracks inventory turnover from its Bulk Data Query page. Simply build the peer group of companies you want to research, select the periods you want to study, and then scroll down to the performance ratios listed at the bottom of the page. Inventory turnover is listed under the liquidity ratios group.

For example, we selected 15 notable retailers, including Abercrombie & Fitch ($ANF), Costco ($COST), Ross Stores ($ROST), Target ($TGT), and Walmart ($WMT). Then we tracked the average inventory turnover for the whole group for the last 10 quarters. See Figure 1, below.

Notice that inventory turnover was sky high in early 2021, when everyone was flush with pandemic stimulus payments and we had nothing to do except spend it. Then came inflationary pressures in 2022-23, and inventory turnover fell; then inflation receded, and the turnover ratio has been clawing its way back up.

Bullwhip Effect

Another favorite metric of ours is something known as the “bullwhip effect.” This is defined as a rising ratio of inventory to sales, which theoretically is a harbinger of prices about to go downward; the retailer has too much stuff on hand, so it needs to slash prices to get them sold. The result is a sudden plunge in prices, like the crack of a whip.

We first wrote about the bullwhip effect in May 2022, when the rate of inflation was near its peak. Inflation then did start to decelerate and drift downward, but not to any great extent. We revisited the bullwhip effect in November 2022, and found that the inventory-to-sale ratio was still rising.

Now let’s take one more look. See Figure 2, below, which shows inventory-to-sales ratio for the same 15 major retailers we mentioned above.

OK, interesting. Now watch what happens when we add quarterly U.S. inflation rates (as reported by the website Trading Economics.)

Hmmm. Now we see that the rising inventory-to-sales ratio in the first half of 2022 did presage a decline in inflation, which arrived in latter 2022 and early 2023. What’s especially interesting is that the ratio rose again in the first half of 2024. 

Does that mean more price declines by early 2025? And if so, would those declines be driven by recession and falling consumer demand? 

We don’t know yet. Stay tuned for that Q3 earnings data.