RECENT POSTS
Thursday, March 21, 2019
Tech Data’s Goodwill Adjustment

Tuesday, March 19, 2019
There’s Taxes, and There’s Taxes

Saturday, March 16, 2019
Adventures in Tax Cuts and Net Income

Monday, March 11, 2019
Big Moves in Goodwill, Intangible Value

Friday, March 8, 2019
CVS, Goodwill, and Enterprise Value

Thursday, February 28, 2019
Summary of Our Goodwill Research/ How-To

Wednesday, February 27, 2019
What Does ‘Other’ Mean? An Example

Thursday, February 21, 2019
Another Tale, Buried in the Footnotes

Wednesday, February 13, 2019
Low Latency Calcbench

Monday, February 11, 2019
Now Streaming on Hulu: Red Ink

Thursday, February 7, 2019
Early Look at 2018 Tax Decline

Wednesday, February 6, 2019
You Revised WHAT, Netflix?

Thursday, January 31, 2019
Talking About Huawei Exposure

Wednesday, January 30, 2019
Another Discrepancy in Reported Numbers

Wednesday, January 30, 2019
Finding Revised Facts: Hertz Edition

Wednesday, January 23, 2019
GE Commercial Aviation Services: Bringing Numbers to Light

Monday, January 21, 2019
Differences in Earnings Releases and 10-Ks

Wednesday, January 16, 2019
The Importance of Textual Analysis

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

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

Archive  |  Search:
2017 Tax Reform Disclosures: Getting Started
Thursday, February 15, 2018

Before we go further poring over corporate disclosures related to tax reform, we wanted to take a step back and give Calcbench subscribers a better sense of how to find all these disclosures.

The best place to start is with our Interactive Disclosures tool. There, you can easily find any company’s disclosures on income taxes. Just open the pull-down menu on the left side for Notes to Financial Statements, and you’ll see a choice for “Income Taxes.” Click on that, and the income tax disclosures appear.

(Aside: you’ll also see a choice to download our Guide to Income Tax Disclosures, which is a great primer on what Calcbench can do for you before you dive into the data.)

You can also try to use the XBRL Data Query Tool, which lets subscribers search for financial data based on how a company “tags” that piece of data. For example, you can search for numbers tagged as “revenue,” “operating income,” “severance costs” and all sorts of other terms. (We have a whole separate post about how to use the XBRL Query tool from several months ago.)

Alas, we do have one caveat with search tax disclosures via XBRL tags: since tax reform is so new, companies are using extension tags to describe their data related to tax reform. Extensions are tags companies create themselves, rather than using those dictated by the official taxonomy for U.S. Generally Accepted Accounting Principles.

So while most companies are using extension tags that are similar, those tags aren’t always identical.

How to Get Around That

Intrepid data nerds that we are here, Calcbench decided not to let the extension tags stop us. We used the XBRL Query tool and searched for “TaxCuts” mentioned in 2017 filings, assuming that any tag referencing tax cuts would use those actual words. (XBRL tags do not use spaces between words.)

Result: dozens of companies already citing the effects of tax reform so far, and we’ve just begun to receive 2017 reports from the S&P 500. So as filing season continues into the spring, eventually we’ll see thousands of filers mentioning tax reform in one way or another. See Figure 1, below.

Here’s where it gets interesting. Thanks to our Calcbench database superpowers, you can see how many companies use the same extension — and many do, because they’re describing the same concept. For example, look at Celgene in Fig. 2 below.

You can see in that highlighted line that it describes its new effective tax rate as “EffectiveIncomeTaxRateReconciliationTaxCutsandJobsActof2017Percent.” And that tag is a hyperlink; if you click on it, you can see all the other companies that have filed financial statements using that exact same extension. In this case, 43 companies used that tax a total of 117 times. (Fig. 3, below.)

Now we’re getting a sense of comparability; you know at least some of the companies that are disclosing an effective tax rate specifically for 2017, this first year of tax reform where effective rates might go a bit haywire. From there you can go back to the Interactive Disclosures page or the Company-in-Detail page to do further research, and see what those filers had to say. Yes, other filers might also report an effective rate using some other tag; we would need to do a lot more homework to develop a complete list. This, however, at least gets you started.

In the fullness of time Calcbench will have much more to say about tax reform and reconciliation items. But, as always, you can do your own exploring too!


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.