Who pays the most tax? Who pays the least tax?

Why do I care? Maybe I don’t. But this is fun anyway.

Go to the IRS.gov website to the SOI Tax Stats page.

Download one of the Excel spreadsheets under Basic Tables: Returns Filed and Sources of Income. I used All Returns: Adjusted Gross Income, Exemptions, Deductions, and Tax Items for 2008.

Look at spreadsheet columns I through N. I & J show the amount of taxable income in each bracket and the number of returns in that bracket. M & N show the number of returns that had tax and the total amount of tax in each bracket.

At the top of column J, the number is 5,652,925,474. Dollar values are in thousands, so this is about $5.6 trillion of taxable income earned by US taxpayers in 2008. At the top of column N it shows that to total tax paid by all these people is 1,031,580,923, or about $1 trillion. So of all the taxable income earned in 2008, 18.2% was paid in federal income tax.

I added a new column, to the right of N, and in cell O10 entered the formula =N10/N$9. Then I formatted the column to show results as a percent. Column O now shows the percentage of tax paid by each income bracket:

I then added another column to the right of I, and in cell J10 entered the formula =I10/I$9 and formatted it for a percent. Column J now shows the percentage of the population (of taxpayers) in each tax bracket:

With these extra columns it’s pretty easy to see where the tax revenue comes from. Cells P23 through P28 sum to 33.24% of revenue. J23 through J28 sum to 0.8% – meaning that the top 0.8% of taxpayers (those with over $500k taxable income) really do account pay 33% of the tax in the USA. The next 62.2% of tax revenue is paid by 54.5% of the population – those between $40,000 and $500,000. The bottom 44.7% of the population pays 4.5% of the tax revenue.

The different population segments are color coded below:

It’s interesting (and strange) that the 13,400 people who made over $10m in 2008 contributed more revenue than the bottom 54.7% – 59,000,000 people.

The table with my additions is available here:




2 thoughts on “Who pays the most tax? Who pays the least tax?”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s