Analysis of Connecticut Tax Load by Income Bracket

[This article was first published on R on Redwall Analytics, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Introduction

This brief study finds that Connecticut residents pay $62-63 billion annually in total taxes (including: Federal, State, Municipal Real Estate, Sales, FICA, Medicare) on adjusted gross income of $165-167 billion (an effective tax rate of 37-38%). Some taxes, such as FICA and Medicare, might be considered forms of savings or insurance with a future benefit, and local real estate tax funding education might offset tuition expenses (if the taxpayer’s children can high quality public schools). Nevertheless, this is the total amount taken from residents to fund their government.

In the study, we will attempt to allocate all taxes paid among the six income groups and 169 towns between 2008-2016. While estimates and assumptions have used to make allocations for some taxes (described below), it appears that middle income brackets (ie: between $50-100k) have the highest effective tax rates (>40%). In addition, 7.5% of taxpayers with the highest incomes (>$200k) also have effective rates >40% and pay almost half of all taxes. Although the lowest brackets don’t pay much in Federal or State income tax, the estimated tax burdens for these groups are still over 30%.

It is important to note that all data comes from the period before the recent tax change. Out of $27 billion in Federal income tax paid, Connecticut residents deducted approximately $10 billion of mortgage interest and state and local taxes, so the effect of the cap will be significant relative to rate reductions. This may be looked at in a future post, but it may be hard to get an estimate using this data.

Methodology

The IRS publishes annual (SOI) tax return data by zip code grouped by income size each year SOI Tax Stats – Individual Income Tax Statistics – ZIP Code Data (SOI). We have loaded all SOI data for Connecticut residents since 2001. It is important to emphasize that it is not possible to see individual tax returns, only collectively by zip code divided into six income levels. Once loaded and cleaned, were able to add up all of the zip codes in each of Connecticut’s 169 towns to see most taxes paid in each town.

Every line item of the 1040 tax return is reflected as a variable in the dataset, including adjusted gross income, state and local income tax paid and mortgage interest deducted by zip and income bracket. It is also possible to see how many returns filed by town, income level and the range of deductions taken by income group. Please see Figure 1 below showing that almost 100% of returns above $200k itemized, but less than 10% of returns below $25k. A lower percentage of middle income returns have been itemizing over time.

Percentage of Income Bracket Itemizing Deductions

Figure 1: Percentage of Income Bracket Itemizing Deductions

Estimate of Sales Tax, Medicare and FICA and Partial Allocation of Local Real Estate Tax to Income Groups

Several taxes are only partially or not present at all on IRS returns, but can be estimated with reasonable confidence. For example, only a few percent of returns deduct sales tax, but this was estimated based on 6.25% of AGI for the lowest bracket down to 1.25% for the highest. The basis for this estimate came from the Institute for Taxation and Economic Policy in their paper Who Pays?.

In addition, FICA can be estimated based on 6.2% of the employee AGI, and an additional 6.2% by the employer (up to $128k). Some might leave the employer contribution out because it is not directly paid by the employee, but we included it because it is a tied of the employee’s labor. Medicare is imputed at 2.9% of AGI without limit.

The allocation of real estate tax paid is more complicated because only about half of the annual $10 billion paid is deducted on IRS tax returns (mostly by higher income taxpayers who itemize). From the work we did last week in Reviewing Fairfield County Municipal Fiscal Indicators Since 2007, we know real estate tax for each town. Using this, it was possible to impute the actual amount paid, but not deducted for taxes by town. We then allocated this to the income groups based on where it was estimated to be paid but not deducted.

For example, relatively few taxpayers with income below $25k are likely to own significant amounts of real estate, and if so, the values should be relatively low (implying low real estate taxes). In addition, the highest brackets are most likely to itemize, hence reflecting the tax on their returns. However, these taxpayers are likely to be much higher valued homes, so only a small number not itemized could add up to meaningful dollar amounts. We used the following ratios to allocate to income groups: <$25k (5% allocated), $25-50k (10%), $50-75k (25%), $75-100k (25%), "$100-200k (30%) and $200k+ (5%). There is no science behind these allocations other than common sense, so the levels among groups might be slightly off, but the absolute amount allocated should be correct.

Finally, only $8.5 billion out of $10 billion of total state income tax paid annually was deducted, and hence allocated to the income groups in our numbers. This probably means that middle income effective tax rates are if anything understated by our study. Other taxes left out of the analysis are estate taxes of $170 million, real estate conveyance of $27 million and gas taxes. Corporate income taxes of $800 million annually are also out of scope.

Effective Tax Rates of Middle Income Groups Highest and Growing Steadily

Effective tax rates and number of taxpayers by income bracket can be seen by hovering in over the line in Figure 2. As mentioned earlier, tax burden on the two lowest and largest brackets are meaningful (above 30%), but mostly composed of social security and sales tax (as we will see further down). These brackets don’t pay meaningful income or real estate taxes. It can be seen by hovering over the graph that these two groups make up almost half of all filers.

Figure 2 also shows the highest and steadily growing effective tax rates on the $50-75k and $75-100k brackets. This may be partly attributed to falling deductions as the percentage who itemize have been falling (shown in 1). While these groups still pay relatively little income tax, real estate taxes have moved up meaningfully in most towns. These groups have also shown little or no income growth over the whole period studied, so tax increases more directly affect effective rates than the higher income groups where earnings recovered during the period.

The >$200k bracket is a much broader range of incomes from the 1% to the 0.1%. With the high cost of living in Fairfield County, it is possible to reach this threshold without the same standard of living as it might bring elsewhere in the country. It also includes taxpayers who are able to structure to a degree where they will live and how much tax they will pay. Overall, the effective rate for this bracket jumped 3-5% when taxes were raised in 2012 (in attempt to close the budget deficit).

Although several ultra high income taxpayers vocally changed their residences and/or relocated their businesses, recent IRS numbers showed that other higher income taxpayers left more quietly The Out-Migration Problem. Despite this, the chart below shows that by 2016, the number of filers in the highest bracket actually grew by 20% in 2014-2016 above the levels before the hike. Some recovery in the number of taxpayers in this group should have been expected as it also likely suffered the biggest reduction during the recession due to heavier reliance on financial services activities and capital gains, a future study will attempt to find pre-crisis data for comparison to better understand the long term trend.

Figure 2: Estimated Total Taxes Paid By Type (All Towns)

The Highest Income Groups Pay a Majority of Tax

In Figure 3), Federal income tax (shown in red) makes almost half of the tax paid by Connecticut residents at approximately $27 billion, (though $8 billion reportedly comes back to the state in the form of federal grants). While Federal and State income taxes are almost entirely paid by the top quarter of tax payers, many other state and local taxes are carried more broadly. As we showed in Figure 2, those top two groups contained 259k and 122k filers out of the total of 1.72 million,respectively. Even with the more regressive nature of some local taxes such as real estate Analysis Comparing Connecticut Real Estate Assessments over Three Revaluation Cycles, the overall structure is progressive with 7.5% and 22% of returns funding 49% and 71% of taxes.

Figure 3: Estimated Total Taxes Paid By Type (All Towns)

Conclusions

Based on this analysis, there is amunition for both political perspectives (the ultimate objective of this blog). Middle income filers appear to now have a higher tax burden than the two upper groups as a percentage of total income, and all groups are paying a meaningful amount of tax (in contrast to the fears of some conservative commentators). However, the two upper groups bear the predominant share of the tax load in contrast to the progressive call to pay a “fair share”. It will be interesting to see the data in 2018 when the cap on state and local tax deductions enters the dicussion. Despite the state’s many urgent needs to fund its pensions, invest in transportation infrastructure and improve educational outcomes in key cities to be able compete for new enterprise as legacy industries diminish, it doesn’t appear that there is a lot of room to further increase taxes on any group. It is hard to imagine a business which would expect to pass on higher costs to its customers in this manner without taking real structural measures to become more efficient. Now that the data is loaded and cleaned, future posts will look at tax burden by town and county and will look at tax burden on seniors (those reporting social security benefits) to see which new insights might be revealed. It appears that there is a lot of runway for further analysis.

To leave a comment for the author, please follow the link and comment on their blog: R on Redwall Analytics.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)