US Public Debt – historical

In a recent “debate” with a friend, I looked for historical data about the US public debt. I found Google Public Data, which has info about the annual budget deficit/surplus, but apparently (oddly) doesn’t have the debt. Odd because this info is available on the Treasury website.

I copied & pasted the data into Google Docs and made a chart of my own and some basic comparisons over time. Here are some of them rendered as images, though the scale makes the horizontal access kind of useless. I tried embedding the interactive Flash-based graph but it didn’t work. Oh well.

{“dataSourceUrl”:”//spreadsheets.google.com/spreadsheet/tq?key=0Arz9JIGL5KjodGlHZjZyRE9YXzBRd0JpVDRKWkE1d0E&transpose=0&headers=1&range=A1%3AC461&gid=0&pub=1″,”options”:{“displayAnnotations”:true,”title”:””,”backgroundColor”:”#FFFFFF”,”legend”:”right”,”logScale”:false,”wmode”:”opaque”,”hAxis”:{“maxAlternation”:1},”hasLabelsColumn”:true,”width”:550,”height”:400},”state”:{},”chartType”:”AnnotatedTimeLine”,”chartName”:”US Public Debt”}

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:

08in12ms
Continue reading “Who pays the most tax? Who pays the least tax?”