Monday, February 7, 2011

2011-2013 Excel Workbook: $31.3 Billion In State of Oregon Tax Expenditures; Rental Housing Gets 37 Cents Out of Every $100.

The State of Oregon Tax Expenditure report for the coming biennium includes an Excel formatted table that shows projected costs, and more, for each of the 378 State of Oregon tax expenditures. 

In order to create a format that would allow use of filters and a pivot table I made some edits, and also added a column to indicate IF the tax expenditure was related to housing, and if so, whether it was a home ownership or rental housing related item.

The resulting Excel workbook, with 5 worksheets is HERE; take a look at the READ ME tab to see contents and some explanatory notes. (NOTE: This workbook was created in Excel 2007 format.Some users report when they save Excel 2007 files they end up with a compressed .zip file extension. My suggestion is to RIGHT CLICK and save the file to your PC. Then navigate to the file you downloaded and look at its file extension. IF it appears as .ZIP extension, change the .ZIP extension to Excel 2007 extension (.xlsx), and THEN open the file with Excel 2007/2010

Double Click to Enlarge
Several observations:
  1. At a time of severe budget pressure for appropriated/General Fund programs, total Oregon tax expenditures are expected to INCREASE by $3.49 BILLION (12.3%) in the coming biennium, reaching a total of $31,339,500,000.
  2. Income tax related tax expenditures will account for $12.07 Billion (38.5%) of all expenditures; property tax expenditures will account for $19.11 billion (61%).
  3. The 17.8% rate of increase in income tax expenditures is 95% HIGHER than the 9.1% rate of increase for property tax expenditures in the coming biennium. 
  4. Remaining tax expenditures of $155 million (less than 1/2 of 1% of total tax expenditures) come from miscellaneous sources including oil, tobacco, and medical provider sources [medical provider tax provides $100 million of this subtotal]. 
  5. My earlier post HERE noted that the total for Oregon housing related tax expenditures is projected to be $2.362 Billion; that amounts to 7.5% of all projected 2011-2013 state tax expenditures.
  6. As bar graph in this post indicates, for every $100 in State of Oregon tax expenditures, rental housing will receive 37 cents, and home ownership $7.17. This means the rate of Home ownership to rental housing tax expenditure ratio is more than 19 to 1.
  7. Home ownership tax expenditures are project to increase at a higher rate (18.9%) than non housing tax expenditures (11.9%), while rental tax expenditures are projected to grow by a much smaller 4.2% 
Originally created and posted on the Oregon Housing Blog.

No comments:

Post a Comment