| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | To leave a comment, click to the left of the small light blue square in the upper right corner. | |||||||||||||||||||
2 | $26,424.75 | 884.45 | ||||||||||||||||||
3 | (if income kept pace with line item) | |||||||||||||||||||
4 | 2011 Hypothetical | (based on 1985-2010) | Pct of Median Household Income | |||||||||||||||||
5 | Med Inc* | Min Wage | 1952 | 2010-11 | Increase | Projected 2040 | cagr 2011-2040 | 1952 | 2010-11 | 2040 | ||||||||||
6 | MEDIAN HOUSEHOLD INCOME | 3,900 | 49,000 | 11.6X | 109,000 | 2.8% | ||||||||||||||
7 | ||||||||||||||||||||
8 | Federal Minimum Wage | 0.75 | 7.25 | 9.7X | 111.4285714 | 32.02614379 | ||||||||||||||
9 | Federal Min Wage - Annualized (2000hr/yr) | 1,500 | 14,500 | 14.18181818 | 4.083333333 | |||||||||||||||
10 | Fed Min Wage - % of Med HH Inc | 38% | 30% | |||||||||||||||||
11 | 218,043 | 45.91 | HealthCare Spending per Household | 274 | 21,800 | 78.6X | 85,000 | 4.8% | 7% | 44% | 78% | |||||||||
12 | 94,714 | 14.01 | Average House | 7,000 | 170,000 | 23.3X | 503,000 | 3.8% | 179% | 347% | 461% | |||||||||
13 | 88,181 | 18.57 | One year at Ivy League school | 1,585 | 51,000 | 31.2X | 221,000 | 5.2% | 41% | 104% | 203% | |||||||||
14 | 2018 | |||||||||||||||||||
15 | 119,801 | 25.22 | Price of Gold | 35 | 1,530 | 42.7X | ||||||||||||||
16 | 119,587 | 25.18 | Dow Jones Average | 275 | 12,000 | 42.6X | cagr 6.7% | div yield 2.3% | ||||||||||||
17 | 111,267 | 23.43 | GDP ($ bil) | 358 | 14,535 | 39.6X | 20,500 | 57,822 | 4.9% | |||||||||||
18 | Money Supply –M3 ($bil) | 135 | 13,200 | 96.8X | ||||||||||||||||
19 | Households | 46 | 117 | 154% | 128 | |||||||||||||||
20 | Mean HH Income | 58% | $208,104,000,000 | 4524 | 83430 | $10,679,040,000,000 | 52% | |||||||||||||
21 | Median HH Income | $179,400,000,000 | 3900 | 49000 | 61800 | $7,910,400,000,000 | $9,206,068,965,517 | Average Monthly Increase(000) | ||||||||||||
22 | Med HH inc X HH / GDP | 50.1% | 39.4% | 38.6% | 77% | $1,295,668,965,517 | ||||||||||||||
23 | 62,254 | 80,257 | $10,122 | 1952-2010 | 2010-2040 | |||||||||||||||
24 | Over 18 pwe HH | 1.88 | 9844 | |||||||||||||||||
25 | ||||||||||||||||||||
26 | Population (Mil) | 157 | 308 | 96% | 377 | 0.7% | 217 | 192 | ||||||||||||
27 | Population (20-65) | 91 | 185 | 103% | 206 | 0.4% | 135 | 58 | ||||||||||||
28 | Total Employment (Household Data)) | 60 | 141 | 133% | 160 | 0.4% | 116 | 54 | ||||||||||||
29 | Male Employment | 43 | 76 | 76% | 81 | 0.2% | 47 | 14 | ||||||||||||
30 | Female Employment | 17 | 65 | 281% | 79 | 0.7% | 69 | 41 | ||||||||||||
31 | 0.3733801889 | 0.6983270372 | ||||||||||||||||||
32 | Percent of GDP | |||||||||||||||||||
33 | Government Spending on ($ bil) : | 1950 | 2010 | 1952 | 2010-11 | 2040 | ||||||||||||||
34 | Healthcare | 2.7 | 1,042 | 385X | 10,419 | 8.3% | 0.9% | 7.2% | 18.0% | |||||||||||
35 | Pensions | 1.4 | 940 | 670X | 5,079 | 6.0% | 0.5% | 6.5% | 8.8% | |||||||||||
36 | Education | 9.6 | 909 | 94X | 4,686 | 5.8% | 3.3% | 6.2% | 8.1% | |||||||||||
37 | Defense | 24.2 | 848 | 35X | 3,310 | 4.8% | 8.2% | 5.8% | 5.7% | |||||||||||
38 | Welfare | 5.7 | 715 | 125X | 5,925 | 7.6% | 1.9% | 4.9% | 10.2% | |||||||||||
39 | Protection | 1.4 | 318 | 227X | 4,561 | 9.6% | 0.5% | 2.2% | 7.9% | |||||||||||
40 | Interest | 4.9 | 299 | 60X | 2,525 | 7.6% | 1.7% | 2.1% | 4.4% | |||||||||||
41 | All Other | 20.4 | 798.5 | 39X | 1,856 | 3.0% | 6.9% | 5.5% | 3.2% | |||||||||||
42 | ||||||||||||||||||||
43 | Total Government Revenue | 69.0 | 4,576 | 65X | 17,548 | 4.7% | 23.5% | 31.4% | 30.3% | |||||||||||
44 | Total Government Expenditures | 70.3 | 5,870 | 83X | 38,361 | 6.7% | 23.9% | 40.3% | 66.3% | |||||||||||
45 | Deficit | 1.3 | 1,294 | 20,813 | 0.4% | 8.9% | 36.0% | |||||||||||||
46 | ||||||||||||||||||||
47 | Gross Public Debt | 289.0 | 18,300 | 63X | 240,000 | 9.3% | 98% | 125.8% | 415% | |||||||||||
48 | ||||||||||||||||||||
49 | * Hypothetical median incomes reflect reduction in size of households from 3.7 in 1952 to 2.6 people in 2011. | |||||||||||||||||||