Adjusted ETR
The dataset includes the firm-year Adjusted ETR measure from Schwab, Stomberg, and Xia (Contemporary Accounting Research 2022).
The dataset also includes 1) the 10 rate reconciling groups in Schwab, Stomberg, and Xia (2022), and 2) the underlying rate reconciling categories used to construct the 10 groups.
Future updates to the data will be posted to this site once available.
Data Download
Note: The most current version includes all Compustat firm-years meeting the Schwab, Stomberg, and Xia (2022) sample selection criteria from 1993 to 2016. Last updated: 08/2022.
Data Dictionary
Please see data dictionary (PDF file) for additional information.
Click here to download data dictionary
An Illustrative Example
Below is the rate reconciliation schedule reported in Waste Management’s 2013 10-K filing (CIK = 0000823768) as well as how each item maps into the rate reconciling group in Schwab, Stomberg, and Xia (2022).
Accordingly, Waste Management will report the following items in the dataset:
Credit, DPAD & Foreign: -0.1174
UTB Release: -0.0347
NDE, Perm & Foreign: 0.0211
Goodwill Impairment: 0.4195
State Taxes: 0.0981
All Others: 0.0009 (= -2.28% + 2.37%)