Wednesday, March 9, 2011

Change to "Guesstimated" State and Local Spending

We create "guesstimated" state and local spending at to provide an estimate of state and local spending to match up against the five year forecast of federal spending that comes out each year in the federal budget. Otherwise the most recent data for state spending is at least a year old and local spending at least two years old.

Up to now, the "guesstimated" state and local spending for years more recent than the latest US Census Bureau report on State and Local Government Finances has been a simple projection of the change between the last two reported years. If, e.g., education spending increased by 5% between 2007 and 2008 we have constructed an education spending value for all future years by increasing each year by five percent.

Effective immediately we are changing the "guesstimated" method. The new method assumes that state and local spending and revenue in the next few years will trend back towards the average value recorded in the recent past, expressed as a percent of GDP (or GSP).

Here is the new method for computing "guesstimated" spending for all states combined and for each individual state.
  1. Establish a five year Reference Period. At present the last year for which state spending is available is 2009, so the reference period is 2005 through 2009. (UPDATE 1/23/14: Reference period is now 2011 to 2012)
  2. For each spending and revenue item calculate an average value for the Reference Period as percent of GDP for a combined state or local value, or as percent of Gross State Project (GSP) for individual states.
  3. Compute a Projected Value (e.g., for 2010) that would continue the percentage change for the latest two years (2008 and 2009) for each spending or revenue item.
  4. Compute a Revert-to-mean Value (e.g., for 2010) that would return the spending or revenue item to the average calculated for the Reference Period as percent of projected GDP for the US or state GSP for the year.
  5. Calculate and save in the database (e.g., for 2010) a Mean Value for the spending/revenue item that is half way between the Projected Value and the Revert-to-mean Value.
  6. Repeat procedure for all spending and revenue items.
  7. Compute total spending and total revenue from new values for 2010.
  8. Repeat for other states.
The projected value for US GDP is the value for each year from Table 10.1 in the Historical Tables of the federal budget. The projected value for each state GSP is computed by applying the change in federal GDP growth rate to the last year's state GSP and then moving the state GSP growth rate towards the federal growth rate by 40 percent of the difference between the state and the federal growth rate.

The "guesstimated" value for state and local revenue code "X08 Employee Retirement - Earnings on Investments" is too volatile to be "guesstimated" using this method. It is computed by changing the latest year's value by 60 percent of the difference between the latest year's value and the average value for the Reference Period. This value, for all states combined, was a $500 billion loss in 2009. This method reverts "X08" to a substantial gain in 2010 and future years. (UPDATE: 1/23/14: X08 is now computed like other items)

Thursday, March 3, 2011

Federal Budget FY12 Released

On February 14, 2011, we updated with the numbers from the historical tables in the FY12 federal budget. Actual revenue for FY 2010 and estimated revenue through FY 2016 come from Tables 4.1, 4.4, and 4.5. Actual spending for FY 2010 and estimated spending at the subfunction level through FY 2016 comes from Table 3.2. Account level spending estimates through FY 2016 come from the outlays table in the Public Budget Database. Federal debt estimates come from Table 7.1 and GDP estimates come from Table 10.1.

Federal Budget Analyst Added

On February 12, 2011 we added Federal Budget Analyst to Just in time for the FY12 federal budget release, this feature allows the user to view spending and revenue estimates for out years for each subfunction in the federal budget and also to compare estimates vs. actual for a specific fiscal year in different budgets. Click here to access this feature.

Also, we have added the CBO Long Term Outlook for the federal budget as published by the Congressional Budget Office here.

State Finances Update for FY 2009

On January 12, 2011 we updated the state spending and revenue using the Census Bureau numbers for FY 2009 released early January. Local spending and revenue for 2009 was updated for each category by creating numbers for 2009 to change by the same percentage as the corresponding state number. State and local numbers for 2010 through 2016 were created to project forward the change between 2008 and 2009.