Monday, May 27, 2013

Proving Rick Unger is a moron and his followers are ignorant robots

Let us look at government spending in a context that makes some sense. The Obama admin likes to play music chairs with their data so don't be surprised if these links quit working. The Obama admin is not as transparent as they pretend to be.

Lets open up a document that gives us the GDP:

Save that document on your drive and save it as gdplev-JDAYER_is_FRICKING_AWESOM.xls or you can make up your own name. I actually used gdplev-a. (I think spelling awesome wrong plays well into the morons who think I am masturbating mentally to prove my own self worth, it would never occur to those idiots that I just want to share something that should be obvious).

Delete everything but column A and column B.

Now you have a list of the GDP for years 1929 to 2012.

Open up:

Save this on your hard drive and then save a copy we can mess with.

Delete everything but columns A, B and C in the copy.

Delete row 83.

Copy cell B35 to C118

Paste the data into the gdplev sheet we copied, select cell D9 (or whatever) and then paste. You should have GDP data (in billions) aligned with Tax Receipts and Outlays (spending) (in millions) from 1929 to 2012.

There are several formulas we can use to derive the percentage of tax receipts and percentage of spending based on GDP.

My favorite equation, =((D9*100000)/((B9*100000000)/100))
Another slightly weird equation, but, usable, =(D9/B9)/10 (millions are 1,000th so if I divide by an extra 10 it gives me hundredths)
Another equation, ==(D9*1000000)/(B9*1000000000)

We have to remember that the GDP numbers are in billions and the tax receipt and outlays are in millions so we have to convert. You are welcome to use your own equation as long it represents an accurate ratio that we can compare to other years.

Put the equation in cell F9 and then double click on the lower right corner of cell F9 to auto fill. This gives us tax receipts as a percentage of GDP. Is the taxation ratio lower or higher than other years?

In cell G9 we need a similar equation, =((E9*100000)/((B9*100000000)/100)) where we use the outlays so we can compare the percentage of GDP spent by the government.

Lets look at Obama's spending.

Obama is collecting a lower percentage of GDP in taxes and is spending more of GDP. Obama is actually collecting a higher percentage of taxes from the middle class and has lowered the effective tax rate of those making in excess of $1,000,000.00 I'm not going to describe how to check that data here, but, I'll give you a clue how to do it. Download the data from the IRS website.

This is not rocket science people. It is really easy to figure out for yourselves. Quit being robots that believe what you want to.

No comments: