This version is not peer-reviewed.
Submitted:
09 November 2023
Posted:
13 November 2023
You are already at the latest version
A peer-reviewed article of this preprint also exists.
Strata of Abs ERRORS | Count of Company-Years | Percent of Total Company-Years | Cumulative Percent of Company-Years | Percentiles of Company Years | Ordered Obs. | Percentile Abs ERROR |
---|---|---|---|---|---|---|
0% to 5% | 25,531 | 10.59% | 10.59% | 1st Percentile: | 2,411 | 0.46% |
5% and 10% | 23,020 | 9.55% | 20.14% | 5th Percentile: | 12,055 | 2.29% |
10% and 15% | 19,239 | 7.98% | 28.12% | 10th Percentile: | 24,111 | 4.71% |
15% and 20% | 15,962 | 6.62% | 34.74% | 25th Percentile: | 60,276 | 12.97% |
20% and 25% | 13,663 | 5.67% | 40.40% | Median: | 120,553 | 35.61% |
25% and 50% | 45,670 | 18.94% | 59.35% | 75th Percentile: | 180,829 | 93.24% |
50% and 100% | 41,436 | 17.19% | 76.53% | 90th Percentile: | 216,995 | 245.35% |
> 100% | 56,585 | 23.47% | 100.00% | 95th Percentile: | 229,050 | 499.47% |
Total: | 241,106 | 100.00% | 100.00% | 99th Percentile: | 238,694 | 2498.45% |
Linear Regression Results | ||||||
N | Adj R-square | Coeff | t-value | p-value | ||
241,105 | 0.106 | 0.523 | 169.009 | 0.000 |
Regression Specification Models based on ABJ: log [COGSi,t / COGSi,t-3] = β0 + β1 log[SALEi,t / SALEi,t-3] + β2 * Decrease_Dummyi,t-3 to t * log [SALEi,t / SALEi,t-3)] + εi,t log [DPi,t / DPi,t-1] = β0 + β1 log[SALEi,t / SALEi,t-1-3] + β2 * Decrease_Dummyi,t-3 to t * log [SALEi,t / SALEi,t-3)] + εi,t log [XSGAi,t / XSGAi,t-1] = β0 + β1 log [SALEi,t / SALEi,t-1] + β2 * Decrease_Dummyi,t * log [SALEi,t / SALEi,t-1)] + εi,t | |||||||
Coefficient Estimates (t-statistics) | |||||||
Dependent Variable | N | Adj. R-square |
% Increase in Dependent Variable for 1% increase in Sales (β1) |
SALE Change * Decrease Dummy (β2) |
% Decrease in Dependent Variable for 1% Decrease in Sales (β1+ β2) |
β1 p-value (t value) |
β2 p-value (t value) |
COGS | 241,043 | .445 | .879 | -.162 | .717 | .000 296.380 | .001 -36.064 |
DP | 241,043 | .105 | .484 | -.279 | .205 | .000 139.327 | .000 -52.839 |
XSGA | 241,043 | .150 | .377 | -.142 | .235 | .000 154.402 | .000 -38.349 |
Regression Specification Models based on ABJ: log [COGSi,t / COGSi,t-1] = β0 + β1 log[SALEi,t / SALEi,t-1] + β2 * Decrease_Dummyi,t * log [SALEi,t / SALEi,t-1)] + εi,t log [DPi,t / DPi,t-1] = β0 + β1 log[SALEi,t / SALEi,t-1] + β2 * Decrease_Dummyi,t * log [SALEi,t / SALEi,t-1)] + εi,t log [XSGAi,t / XSGAi,t-1] = β0 + β1 log [SALEi,t / SALEi,t-1] + β2 * Decrease_Dummyi,t * log [SALEi,t / SALEi,t-1)] + εi,t | |||||||
Coefficient Estimates (t-statistics) | |||||||
Dependent Variable | N | Adj. R-square |
% Increase in Dependent Variable for 1% increase in Sales (β1) |
SALE Change * Decrease Dummy (β2) |
% Decrease in Dependent Variable for 1% Decrease in Sales (β1+ β2) |
β1 p-value (t value) |
β2 p-value (t value) |
COGS | 188,808 | .589 | .880 | -.046 | .834 | .000 404.713 | .001 -11.050 |
DP | 188,808 | .267 | .647 | -.254 | .393 | .000 227.362 | .000 -46.695 |
XSGA | 188,808 | .310 | .440 | -.131 | .309 | .000 245.616 | .000 -38.125 |
1 | We denote the names of items reported in financial statements in lower case and the names of Compustat items in upper case. For example, cogs in an income statement versus COGS in Compustat. |
2 | We choose Compustat OIADP for operating income because S&P computes OIADP before deducting income taxes and interest and because it subsumes the revenues and expenses that firms include in continuing operations on an accrual accounting basis. Also, OIADP represents the parsimonious set of aggregate Compustat variables shown in [1]. |
3 | Bostwick et al. (2016) found that S&P subtracts (DP – AM) from cogs to derive COGS when entities disclose and quantify allocation of amortization (AM) but not depreciation. |
4 | For all observations, we require OIADP - (SALE - COGS - DP - XSGA) < .001 and SALE, COGS, DP, and XSGA > 0. |
5 | In the results that follow, we revisit the same company quarters in Tables 3, 4, and 5 as analyzed in Table 1. |
Model |
Linear Regression Results |
Median Abs. Value Error |
||||
N |
Adj. R-square |
Coeff |
t-value |
p-value |
||
BASE MODEL: No adjustment for constant SALE-to-COGS or sticky DP or XSGA [6] | 241,106 | 0.015 | 0.121 | 61.415 | 0.000 | 40.40% |
INTERMEDIATE MODEL: restated SALE-to-COGS but no adjustment for sticky DP or XSGA [9] | 241,106 | 0.099 | 0.378 | 162.314 | 0.000 | 38.70% |
FULL MODEL: adjustment for SALE-to-COGS and adjusting for sticky DP and XSGA as shown in Table 1 [11] | 241,106 | 0.106 | 0.523 | 169.009 | 0.000 | 35.61% |
Strata of Abs Value Errors |
Count of Company-Years | Percent of Total Company-Years | Cumulative Percent of Company-Years | Percentiles of Company Years | Ordered Obs. | Percentile Abs Value Errors |
---|---|---|---|---|---|---|
0% to 5% | 22,456 | 14.19% | 14.19% | 1st Percentile: | 1,582 | 0.33% |
5% and 10% | 19,889 | 12.57% | 26.76% | 5th Percentile: | 7,912 | 1.70% |
10% and 15% | 16,322 | 10.31% | 37.08% | 10th Percentile: | 15,824 | 3.46% |
15% and 20% | 13,136 | 8.30% | 45.38% | 25th Percentile: | 39,559 | 9.23% |
20% and 25% | 10,729 | 6.78% | 52.16% | Median: | 79,119 | 23.28% |
25% and 50% | 32,233 | 20.37% | 72.53% | 75th Percentile: | 118,678 | 55.27% |
50% and 100% | 21,288 | 13.45% | 85.98% | 90th Percentile: | 142,413 | 143.86% |
> 100% | 22,185 | 14.02% | 100.00% | 95th Percentile: | 150,325 | 295.20% |
Total: | 158,238 | 100.00% | 100.00% | 99th Percentile: | 156,655 | 1527.25% |
Linear Regression Results | ||||||
N | Adj R-square | Coeff | t-value | p-value | ||
158,237 | 0.147 | 0.453 | 165.018 | 0.000 |
Strata of Abs Value Errors | Count of Company-Years | Percent of Total Company-Years | Cumulative Percent of Company-Years | Percentiles of Company Years | Ordered Obs. | Percentile Abs Value Errors |
---|---|---|---|---|---|---|
0% to 5% | 380 | 20.42% | 20.42% | 1st Percentile: | 19 | 0.24% |
5% and 10% | 341 | 18.32% | 38.74% | 5th Percentile: | 93 | 1.32% |
10% and 15% | 276 | 14.83% | 53.57% | 10th Percentile: | 186 | 2.46% |
15% and 20% | 184 | 9.89% | 63.46% | 25th Percentile: | 465 | 6.15% |
20% and 25% | 145 | 7.79% | 71.25% | Median: | 930 | 13.84% |
25% and 50% | 319 | 17.14% | 88.39% | 75th Percentile: | 1,395 | 27.60% |
50% and 100% | 107 | 5.75% | 94.14% | 90th Percentile: | 1,674 | 55.22% |
> 100% | 109 | 5.86% | 100.00% | 95th Percentile: | 1,767 | 110.55% |
Total: | 1,861 | 100.00% | 100.00% | 99th Percentile: | 1,841 | 686.40% |
Linear Regression Results | ||||||
N | Adj R-square | beta | t-value | p-value | ||
1,860 | 0.338 | 0.750 | 165.018 | 0.000 |
Strata of Abs Value Errors | Count of Company-Years | Percent of Total Company-Years | Cumulative Percent of Company-Years | Percentiles of Company Years | Ordered Obs. | Percentile Abs Value Errors |
---|---|---|---|---|---|---|
0% to 5% | 19,400 | 10.28% | 10.28% | 1st Percentile: | 1,888 | 0.48% |
5% and 10% | 17,613 | 9.33% | 19.61% | 5th Percentile: | 9,439 | 2.45% |
10% and 15% | 15,155 | 8.03% | 27.63% | 10th Percentile: | 18,878 | 4.87% |
15% and 20% | 12,899 | 6.83% | 34.47% | 25th Percentile: | 47,194 | 13.24% |
20% and 25% | 10,770 | 5.71% | 40.17% | Median: | 94,389 | 36.15% |
25% and 50% | 34,904 | 18.49% | 58.66% | 75th Percentile: | 141,583 | 97.33% |
50% and 100% | 32,026 | 16.97% | 75.63% | 90th Percentile: | 169,899 | 264.52% |
> 100% | 46,010 | 24.37% | 100.00% | 95th Percentile: | 179,338 | 536.49% |
Total: | 188,777 | 100.00% | 100.00% | 99th Percentile: | 186,889 | 2760.82% |
Linear Regression Results | ||||||
N | Adj R-square | beta | t-value | p-value | ||
188,776 | 0.064 | 0.259 | 113.678 | 0.000 |
Strata of Abs ERRORS | Count of Firm-Years | Percent of Total Firm-Years | Cumulative Percent of Firm-Years | Percentiles of Firm Years | Ordered Obs. | Percentiles of Abs. Value of Estimate Errors |
---|---|---|---|---|---|---|
0% to 5% | 211 | 24.25% | 24.25% | 1st Percentile: | 9 | 0.30% |
5% and 10% | 199 | 22.87% | 47.13% | 5th Percentile: | 44 | 1.05% |
10% and 15% | 112 | 12.87% | 60.00% | 10th Percentile: | 87 | 1.88% |
15% and 20% | 71 | 8.16% | 68.16% | 25th Percentile: | 218 | 5.20% |
20% and 25% | 54 | 6.21% | 74.37% | Median: | 435 | 11.00% |
25% and 50% | 119 | 13.68% | 88.05% | 75th Percentile: | 653 | 26.09% |
50% and 100% | 55 | 6.32% | 94.37% | 90th Percentile: | 783 | 58.06% |
> 100% | 49 | 5.63% | 100.00% | 95th Percentile: | 827 | 112.23% |
Total: | 870 | 100.00% | 100.00% | 99th Percentile: | 861 | 475.18% |
Linear Regression Results | ||||||
N | Adj R-square | beta | t-value | p-value | ||
869 | 0.354 | 0.936 | 21.846 | <.001 |
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2025 MDPI (Basel, Switzerland) unless otherwise stated