Calcbench

Calcbench is all about providing financial analysts with quick ways to find useful financial information, so in advance of all those Q2 earnings releases that will start to arrive next week, we offer one more.  When looking at a company’s financial summary, look for the series of Excel export choices that Calcbench also provides. Usually you’ll see that as a list of Excel icons above the financial data, although sometimes those icons are stacked in a corner instead.  For example, see Figure 1, below, which shows the latest quarterly data filed by beer and spirits giant Constellation Brands ($STZ) on Wednesday.  Click on any of those icons, and in moments you’ll get reams of useful data ready to be exported to your desktop in Excel. You can then fiddle with that spreadsheet to your heart’s content, dump the data into other models and templates you already have, or do whatever else you want to do with the data. Moreover, when you view the data as a spreadsheet, you get muc...

The second quarter of 2024 has now closed, which means earnings reports for Q2 activity will start arriving in about two weeks (and then become a torrent by end of July).  To help analysts prepare for that deluge of information, Calcbench reminds everyone that we have several earnings analysis templates ready to go, which will automatically capture and report earnings disclosures as your favorite companies and industry sectors file. For example, we have our pharmaceuticals industry template , which tracks the sales of blockbuster drugs. Each of several pharma industry giants (Merck, Pfizer, Johnson & Johnson) gets their own tab in the spreadsheet, and then each company tab tracks sales of individual drugs that reap $1 billion or more in revenue.  We also have our airlines industry template , which tracks performance metrics such as revenue per available seat mile (RASM), cost per available seat mile (CASM), ticket revenue, fuel cost per gallon, and more. You can see a summ...

The second quarter of 2024 draws to a close this week, which means Q2 earnings reports reports should start to arrive about two weeks after that — but when, exactly? And once the window opens, how quickly does the trickle of earnings reports turn into a flood?  To answer that question in a fun way, Calcbench looked at the distribution of filing dates for second-quarter of 2023 and plotted them into a chart. See Figure 1, below. As you can see, the first few weeks of July are quiet. Usually the Wall Street banks go first in mid-July, with the tech giants about a week later, and a few other large businesses (the airlines, for example) reporting as well. Not until the end of July do we see filing volume really start to spike, and then it reaches its peak at the start of August. Also note that Thursdays seem to be the busiest filing days of the week, presumably so that good reports can leave you feeling great for the weekend and bad ones can be forgotten by the subsequent Monday. Presu...