It is. I missed the entire top 1% (yeah, i know...) Woof. I've also went right to the horse's mouth and got the census survey for household income and calculated the incomes as a function of percentile myself.
So I take each block of 1,300,000 families and then assign that group a household income. I multiply the HH income by # of families to get total income for that percentile group. I set an income level to tax above (exemption). I then set an initial tax % to tax HH income above the exemption [ (HH Income - Exemption) * Tax% = Tax revenue]. I have a table calculate that for each 1% block. I have a macro that goal seeks for each income bracket until you get to 100% tax rate. The problem is that the wealthiest 1,300,000 make an absolute assload of money (even more than I thought which is surprising in itself).
Ok, so here's what I have for my data tables: [TABLE="border: 1, cellpadding: 2, width: 206"]
[TR]
[TD="class: xl65"]
Families[/TD]
[TD="class: xl66"]
Income[/TD]
[TD="class: xl67"]
Percentile[/TD]
[/TR]
[TR]
[TD="class: xl68"]
1,300,000[/TD]
[TD="class: xl69"]
$1,700[/TD]
[TD="class: xl70"]
1.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$3,355[/TD]
[TD="class: xl73"]
2.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$5,000[/TD]
[TD="class: xl73"]
3.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$7,000[/TD]
[TD="class: xl73"]
4.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$8,885[/TD]
[TD="class: xl73"]
5.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$10,000[/TD]
[TD="class: xl73"]
6.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$12,000[/TD]
[TD="class: xl73"]
7.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$14,300[/TD]
[TD="class: xl73"]
8.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$15,600[/TD]
[TD="class: xl73"]
9.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$17,650[/TD]
[TD="class: xl73"]
10.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$19,000[/TD]
[TD="class: xl73"]
11.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$20,000[/TD]
[TD="class: xl73"]
12.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$21,814[/TD]
[TD="class: xl73"]
13.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$23,500[/TD]
[TD="class: xl73"]
14.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$25,000[/TD]
[TD="class: xl73"]
15.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$25,945[/TD]
[TD="class: xl73"]
16.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$27,040[/TD]
[TD="class: xl73"]
17.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$29,000[/TD]
[TD="class: xl73"]
18.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$30,000[/TD]
[TD="class: xl73"]
19.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$30,000[/TD]
[TD="class: xl73"]
20.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$32,000[/TD]
[TD="class: xl73"]
21.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$33,500[/TD]
[TD="class: xl73"]
22.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$35,000[/TD]
[TD="class: xl73"]
23.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$35,813[/TD]
[TD="class: xl73"]
24.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$37,000[/TD]
[TD="class: xl73"]
25.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$39,000[/TD]
[TD="class: xl73"]
26.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$40,000[/TD]
[TD="class: xl73"]
27.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$40,000[/TD]
[TD="class: xl73"]
28.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$42,000[/TD]
[TD="class: xl73"]
29.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$43,000[/TD]
[TD="class: xl73"]
30.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$45,000[/TD]
[TD="class: xl73"]
31.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$46,000[/TD]
[TD="class: xl73"]
32.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$47,800[/TD]
[TD="class: xl73"]
33.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$49,000[/TD]
[TD="class: xl73"]
34.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$50,000[/TD]
[TD="class: xl73"]
35.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$50,000[/TD]
[TD="class: xl73"]
36.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$52,000[/TD]
[TD="class: xl73"]
37.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$53,800[/TD]
[TD="class: xl73"]
38.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$55,000[/TD]
[TD="class: xl73"]
39.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$56,000[/TD]
[TD="class: xl73"]
40.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$58,000[/TD]
[TD="class: xl73"]
41.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$60,000[/TD]
[TD="class: xl73"]
42.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$60,000[/TD]
[TD="class: xl73"]
43.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$61,200[/TD]
[TD="class: xl73"]
44.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$63,000[/TD]
[TD="class: xl73"]
45.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$65,000[/TD]
[TD="class: xl73"]
46.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$66,000[/TD]
[TD="class: xl73"]
47.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$68,000[/TD]
[TD="class: xl73"]
48.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$70,000[/TD]
[TD="class: xl73"]
49.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$70,747[/TD]
[TD="class: xl73"]
50.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$72,720[/TD]
[TD="class: xl73"]
51.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$75,000[/TD]
[TD="class: xl73"]
52.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$75,000[/TD]
[TD="class: xl73"]
53.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$77,000[/TD]
[TD="class: xl73"]
54.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$79,004[/TD]
[TD="class: xl73"]
55.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$80,000[/TD]
[TD="class: xl73"]
56.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$82,000[/TD]
[TD="class: xl73"]
57.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$84,299[/TD]
[TD="class: xl73"]
58.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$85,821[/TD]
[TD="class: xl73"]
59.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$88,576[/TD]
[TD="class: xl73"]
60.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$90,000[/TD]
[TD="class: xl73"]
61.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$92,000[/TD]
[TD="class: xl73"]
62.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$95,000[/TD]
[TD="class: xl73"]
63.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$96,400[/TD]
[TD="class: xl73"]
64.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$99,134[/TD]
[TD="class: xl73"]
65.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$100,000[/TD]
[TD="class: xl73"]
66.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$101,268[/TD]
[TD="class: xl73"]
67.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$104,000[/TD]
[TD="class: xl73"]
68.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$106,500[/TD]
[TD="class: xl73"]
69.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$109,822[/TD]
[TD="class: xl73"]
70.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$111,000[/TD]
[TD="class: xl73"]
71.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$114,500[/TD]
[TD="class: xl73"]
72.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$117,000[/TD]
[TD="class: xl73"]
73.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$120,000[/TD]
[TD="class: xl73"]
74.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$122,000[/TD]
[TD="class: xl73"]
75.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$125,000[/TD]
[TD="class: xl73"]
76.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$130,000[/TD]
[TD="class: xl73"]
77.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$132,000[/TD]
[TD="class: xl73"]
78.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$135,363[/TD]
[TD="class: xl73"]
79.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$140,000[/TD]
[TD="class: xl73"]
80.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$144,000[/TD]
[TD="class: xl73"]
81.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$148,159[/TD]
[TD="class: xl73"]
82.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$150,000[/TD]
[TD="class: xl73"]
83.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$155,000[/TD]
[TD="class: xl73"]
84.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$160,000[/TD]
[TD="class: xl73"]
85.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$166,000[/TD]
[TD="class: xl73"]
86.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$172,000[/TD]
[TD="class: xl73"]
87.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$178,923[/TD]
[TD="class: xl73"]
88.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$185,000[/TD]
[TD="class: xl73"]
89.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$194,083[/TD]
[TD="class: xl73"]
90.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$200,001[/TD]
[TD="class: xl73"]
91.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$211,000[/TD]
[TD="class: xl73"]
92.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$225,000[/TD]
[TD="class: xl73"]
93.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$240,000[/TD]
[TD="class: xl73"]
94.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$254,000[/TD]
[TD="class: xl73"]
95.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$280,000[/TD]
[TD="class: xl73"]
96.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$312,000[/TD]
[TD="class: xl73"]
97.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$360,000[/TD]
[TD="class: xl73"]
98.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
1,300,000[/TD]
[TD="class: xl72"]
$497,055[/TD]
[TD="class: xl73"]
99.0%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
650,000[/TD]
[TD="class: xl72"]
$705,550[/TD]
[TD="class: xl73"]
99.5%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
130,000[/TD]
[TD="class: xl72"]
$865,732[/TD]
[TD="class: xl73"]
99.6%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
130,000[/TD]
[TD="class: xl72"]
$1,027,165[/TD]
[TD="class: xl73"]
99.7%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
130,000[/TD]
[TD="class: xl72"]
$1,099,999[/TD]
[TD="class: xl73"]
99.8%[/TD]
[/TR]
[TR]
[TD="class: xl71"]
130,000[/TD]
[TD="class: xl72"]
$1,188,109[/TD]
[TD="class: xl73"]
99.9%[/TD]
[/TR]
[TR]
[TD="class: xl74"]
117,000[/TD]
[TD="class: xl75"]
$2,717,244[/TD]
[TD="class: xl76"]
99.990%[/TD]
[/TR]
[/TABLE]
The data is problematic because the 90.7k-household sample doesn't include any household incomes above $2.94M. Sigh.
So I'm not sure how to correct for this. I guess I could take the total household income and scale my data table above accordingly. I don't love that. BUt maybe it's possible.
Also problematic is the fact that the highest earning households earn so much, it's hard to account for them because you start to get into percentiles that you can't differentiate because of the "small" sample size. So again, I don't know how to fix this.
So here are my updated but not quite correct results.
$2T in personal income taxes: [TABLE="border: 1, cellpadding: 4, cellspacing: 0"]
[TR]
[TD="width: 80"]30%[/TD]
[TD="width: 80"]32%[/TD]
[TD="width: 80"]34%[/TD]
[TD="width: 80"]36%[/TD]
[TD="width: 80"]38%[/TD]
[TD="width: 80"]40%[/TD]
[TD="width: 80"]42%[/TD]
[TD="width: 80"]44%[/TD]
[TD="width: 80"]46%[/TD]
[TD="width: 80"]48%[/TD]
[TD="width: 80"]50%[/TD]
[TD="width: 80"]53%[/TD]
[TD="width: 80"]55%[/TD]
[TD="width: 80"]58%[/TD]
[TD="width: 80"]60%[/TD]
[TD="width: 80"]63%[/TD]
[TD="width: 80"]65%[/TD]
[TD="width: 80"]68%[/TD]
[TD="width: 80"]71%[/TD]
[TD="width: 80"]74%[/TD]
[TD="width: 80"]76%[/TD]
[TD="width: 80"]79%[/TD]
[TD="width: 80"]82%[/TD]
[TD="width: 80"]85%[/TD]
[TD="width: 80"]88%[/TD]
[TD="width: 80"]90%[/TD]
[TD="width: 80"]93%[/TD]
[TD="width: 80"]96%[/TD]
[TD="width: 80"]99%[/TD]
[/TR]
[TR]
[TD]$65,000[/TD]
[TD]$70,000[/TD]
[TD]$75,000[/TD]
[TD]$80,000[/TD]
[TD]$85,000[/TD]
[TD]$90,000[/TD]
[TD]$95,000[/TD]
[TD]$100,000[/TD]
[TD]$105,000[/TD]
[TD]$110,000[/TD]
[TD]$115,000[/TD]
[TD]$120,000[/TD]
[TD]$125,000[/TD]
[TD]$130,000[/TD]
[TD]$135,000[/TD]
[TD]$140,000[/TD]
[TD]$145,000[/TD]
[TD]$150,000[/TD]
[TD]$155,000[/TD]
[TD]$160,000[/TD]
[TD]$165,000[/TD]
[TD]$170,000[/TD]
[TD]$175,000[/TD]
[TD]$180,000[/TD]
[TD]$185,000[/TD]
[TD]$190,000[/TD]
[TD]$195,000[/TD]
[TD]$200,000[/TD]
[TD]$205,000[/TD]
[/TR]
[/TABLE]
.
$3.2T in SS+PI taxes: [TABLE="border: 1, cellpadding: 4, cellspacing: 0"]
[TR]
[TD="width: 80"]31%[/TD]
[TD="width: 80"]33%[/TD]
[TD="width: 80"]35%[/TD]
[TD="width: 80"]37%[/TD]
[TD="width: 80"]39%[/TD]
[TD="width: 80"]41%[/TD]
[TD="width: 80"]44%[/TD]
[TD="width: 80"]46%[/TD]
[TD="width: 80"]49%[/TD]
[TD="width: 80"]51%[/TD]
[TD="width: 80"]54%[/TD]
[TD="width: 80"]57%[/TD]
[TD="width: 80"]60%[/TD]
[TD="width: 80"]63%[/TD]
[TD="width: 80"]67%[/TD]
[TD="width: 80"]70%[/TD]
[TD="width: 80"]73%[/TD]
[TD="width: 80"]77%[/TD]
[TD="width: 80"]81%[/TD]
[TD="width: 80"]84%[/TD]
[TD="width: 80"]88%[/TD]
[TD="width: 80"]92%[/TD]
[TD="width: 80"]96%[/TD]
[/TR]
[TR]
[TD]$25,000[/TD]
[TD]$30,000[/TD]
[TD]$35,000[/TD]
[TD]$40,000[/TD]
[TD]$45,000[/TD]
[TD]$50,000[/TD]
[TD]$55,000[/TD]
[TD]$60,000[/TD]
[TD]$65,000[/TD]
[TD]$70,000[/TD]
[TD]$75,000[/TD]
[TD]$80,000[/TD]
[TD]$85,000[/TD]
[TD]$90,000[/TD]
[TD]$95,000[/TD]
[TD]$100,000[/TD]
[TD]$105,000[/TD]
[TD]$110,000[/TD]
[TD]$115,000[/TD]
[TD]$120,000[/TD]
[TD]$125,000[/TD]
[TD]$130,000[/TD]
[TD]$135,000[/TD]
[/TR]
[/TABLE]
.
Using this method, I can only account for about $12.7T in HH income. So I think the results here have % that are too high for a given exemption. So for that 30% @ $65k, the real result might be (doing a quick scale) 30%*12.7/14 = 27.2%
Edit to add:
Here's why this is hard. If you look at the 98-99% percentile, you get a collective income of $646 B. If you take just that next 0.5% (99.0-99.5%), you get $459 B. So it's hard to get percentiles that are small enough where they actually start earning less as a group than the previous group size (1% vs 0.5%). I suck at explaining. Anyways. Even going out from 99.9% to 99.99%, you get a collective income of $318 B compared to the entire 98-99% at $646 B. Obviously this all makes sense mathematically and given how bad income disparities are. I just don't know how to fix it.
These guys have apparently been doing this for 20+ years.
https://realtimeinequality.org/
I could read through their methodology to try and get better data but blech.