RECENT POSTS
Tuesday, January 8, 2019
A Look at Climate Change Disclosures

Wednesday, January 2, 2019
Quants: Point-in-Time Data for Backtesting

Friday, December 28, 2018
Now Showing: Controls & Procedures

Thursday, December 27, 2018
A Reminder on Non-GAAP Reporting Rules

Monday, December 17, 2018
Researching PG&E’s Wildfire Risk

Wednesday, December 12, 2018
Tracking Brexit Disclosures

Thursday, December 6, 2018
Campbell Soup: Looking Behind the Label

Sunday, December 2, 2018
SEC Comment Letters: The Amazon Example

Wednesday, November 28, 2018
Measuring Big Pharma’s Chemical Dependency

Monday, November 26, 2018
Analysts, Can You Relate? A True Story

Monday, November 19, 2018
Digging Up Historical Trend Data: Quest Example

Sunday, November 11, 2018
Cost of Revenue, SG&A: Q3 Update

Monday, November 5, 2018
Lease Accounting: FedEx vs. UPS

Saturday, November 3, 2018
New Email Alerting Powers

Wednesday, October 31, 2018
PTC and Two Tales of Revenue

Tuesday, October 30, 2018
10-K/Q Section Text Change Detection

Sunday, October 28, 2018
Finding Purchase Price Allocation

Sunday, October 21, 2018
Charting Netflix Growth in Three Ways

Wednesday, October 17, 2018
Interesting Data on Interest Income

Thursday, October 11, 2018
The Decline of Sears in Three Charts

Archive  |  Search:

Here at Calcbench, we pride ourselves on helping clients to use data more intensively, which lets your people on payroll work more efficiently. After all, time is money.

So recently we aimed our database superpowers at a common but frustrating question: What has changed from one annual report to the next?

This question can drive financial analysts nuts. Sometimes old items from previous reports disappear; sometimes new items arrive without fanfare. Either way, analysts generally can find the answer only through painstaking, manual labor.

Calcbench uses a different approach. We start by going into our databases and constructing a query to catalog the all the XBRL tags in a company’s most recent 10-K. Remember, XBRL tags are code that identify what a piece of financial data is, so computer programs (like ours) know how to interpret a numerical value they find: “Oh, this XBRL tag says , so the value next to that tag is the revenue number. I should display it at the top with the word ‘revenue’ next to it.” That sort of thing.

So first we catalog all the XBRL tags from a company’s most recent 10-K. Then we compare that result with all the XBRL tags used in the prior year’s 10-K— and from there, it’s a short exercise to identify which old tags were discontinued, which new tags were added, and which tags appear in both years (and therefore can be ignored, since we’re only looking for what has changed).

We ran this exercise for the 30 companies in the Dow Jones Industrial Average, and the results are as follows.

In other words, the financial statements of the DJIA were slightly less complex this year compared to 2016: on average, they introduced 47.6 new tags, but removed 53.8 tags—a reduction of 6.2 tags.

In absolute terms that reduction isn’t much; most companies use a host of tags, and most tags endure from one year to the next. (Don’t forget that academic paper we discussed earlier this year, arguing that the total number of XBRL tags in a financial statement is a good measure of accounting complexity, and by extension the probability of errors or financial restatements.)

Anyway, back to the financial analysts. Once you know what tags have changed from one year to the next, you can ask the CFO the next logical question during an earnings call: Why has the accounting changed? Did two lines of business become so similar they were consolidated? Was an old line of business shut down forever? Are the emerging markets growing so rapidly that you want to assign new tags for those revenue streams?

We at Calcbench won’t necessarily know the answer. Our gig is to give you precise information so you can ask the probing questions that help you make better decisions. That, we can do in spades.

Right now, we can do this year-by-year accounting churn analysis upon request. It doesn’t take us long, but we do need to work with subscribers to target specific companies. In the future we’ll publish a longer churn analysis for the S&P 500, so stay tuned. And if you do have a specific request, let us know at info@calcbench.com.


FREE Calcbench Premium
Two Week Trial

Research Financial & Accounting Data Like Never Before. More features and try our Excel add-in. Sign up now to try the Premium Suite.