RECENT POSTS
Friday, March 22, 2019
Our New Master Class Video

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

Archive  |  Search:

Earlier this month, we chose to analyze the tax reconciliation data for a subset of S&P500 firms. Anyone with a Calcbench subscription is invited to do something similar (or better). Here is a short summary of what we found.

Background and Data:

During the reporting of effective tax rates, companies provide more detailed information on the reconciling of these rates, or the taxes owed, versus the statutory corporate tax rate. At Calcbench, we examined the reconciling items on a systematic basis to observe behavior within this group of firms.

The exercise of systematically reconciling each item and putting them on an apples-to-apples basis is much easier said than done. An example of why this is a challenging exercise is that some firms reconcile to the dollar while others reconcile to the tax rate. In this case, the picture(s) below save us a thousand words.

So we took our data that was in percents and converted it into dollars so that we could try to do a closer comparison.

Once we started looking at the income tax footnotes, we found that there were 5 common reconciling items that impacted corporate taxes owed:

  1. State / Local taxes
  2. Research and Development
  3. Foreign Impacts (e.g. Irish subsidiary)
  4. Share Based Compensation Effects
  5. Domestic Manufacturing Credits

Certainly, there are other contributing factors, with many of them being firm specific. We chose not to examine these for purposes of this exercise. But we may return to firm specific factors at a later date.

Some high level observations from the 2016 annual filings are below:

  • 473 firms out of 500 reported reconciling items with 428 firms reporting profits before tax in 2016
  • 224 reported an effective tax rate (e.g. 25%)
  • 127 reported dollar levels of taxes owed (e.g. $1 billion)
  • 122 firms provided both percentages and dollars owed in detailed breakdowns

Of the 428 firms in our sample that reported profits before tax in 2016, the 5 reconciling items in aggregate are below:

(Note that the State / Local deduction is added back when calculating the federal effective tax rate. We reported the results because the data is significant)

The top 10 foreign reconciling items were taken by the following firms:

The top 10 share R&D reconciling items were taken by the following firms:

The top 10 manufacturing reconciling items were taken by the following firms:

Top 10 share based compensation reconciling items were taken by the following firms:

The top 10 State/ Local reconciling items were taken by the following firms:

The idea behind the data is rather simple. Get data and use it.


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.