RECENT POSTS
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

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

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.