2008-2012: All State and Metro Real Personal Income and Per Capita Income Data in Excel.

Two recent posts referenced calculations of state and metro real per capita income calculations that I had done for 2008-2012. Those posts included images of two summary tables. 

I have combined all of the related state and metro data into a single Excel workbook HERE (and embedded below) that also includes links to the BEA data that I downloaded.  

The workbook opens to a index page showing all the worksheets in the workbook. (The two worksheets highlighted in red are the summary tables that I posted as pictures in the prior posts).

Posting of this workbook allows other to verify my calculations and do other calculations of interest. 


Originally created and posted on the Oregon Housing Blog.

CBO Analysis of Federal Tax Rates: Middle Income Average Effective Tax Rates Have DECLINED.

A new CBO set of reports on effective federal tax rates causes one to wonder about the need for additional tax cuts (and the disconnect between perception and reality). Note that data show is for average EFFECTIVE tax rates, and NOT incremental rates for different tax brackets.

CBO has LOTS of tables and analysis HERE(scroll to bottom).

Director's Blog post with a summary of findings is HERE.

I prepared two graphs HERE with focus on middle income families.

For middle income ("middle quintile") households the graphs illustrate for 1990, 2000, and 2007

1.Effective Average Federal Income Tax rates.(pg 2).

2.Effective Average TOTAL Federal Tax tax rates. (pg 1).

FOR

• Households with Children
• Elderly Households
• Non Elderly Households (w/o children)

In ALL cases in 2007 both the average effective federal income tax rate AND the total average effective federal tax rate has DECLINED from both 1990 and 2000 levels.  

Also in all cases the average effective federal tax rate for the elderly is the lowest, and the average effective federal tax rate is the highest for non elderly without children.

Originally created and posted on the Oregon Housing Blog.

USDA Releases 2009 Estimate of Cost of Raising Children: Monthly Housing Cost Per Child is $153-$297 Depending on Location and Family Composition.

Report is HERE: PDF pages 14-15 are a discussion of method of estimating housing costs; tables are found in PDF pages 32 to 38. 

I created the table below to show the differing housing expenses based on location and family composition. 

I added a column that shows the % of average income per child for housing expense, it varies from a high of 11% for US single parent household to a low of 5% for a Husband/Wife family in the rural US.

Observations:

1. There is BIG difference in average income between single parent and husband wife households
2. Housing expense per child in the URBAN West for a husband wife family are the highest at $297 per month-that's 95% HIGHER than the husband wife, RURAL all US per child monthly housing expense of $153.

HH Type, Location	Housing Expense	MONTHLY Housing Expense	Income Group	Average income	CALCULATED: Housing Expense/ Average Income	Table
Single Head of Household,  ALL US	$  2,810	$           234	$  56,670	$  25,130	11%	7
Husband, Wife, ALL US	$  2,961	$           247	$  56,670	$  36,250	8%	1
Husband, Wife, URBAN West	$  3,560	$           297	$  56,650	$  36,230	10%	3
Husband, Wife, RURAL ALL US	$  1,830	$           153	$  56,880	$  36,380	5%	6

Originally created and posted on the Oregon Housing Blog.

Oregon Median Family Income Changes 2009-2010 and 2000-2010.

The table I constructed HERE compares Median Family Incomes for the State of Oregon and Oregon Counties and MSA's. 

Data for 2000,2008,2009, and 2010 are included; comparisons include $$ and % for 2009-2010 AND 2000-2010.  

Who had the biggest % increase in the last year? Since 2000? Hint: It wasn't Portland-take a look at the table and you may be surprised.

(As always if you see any math problems, please DO let me know).

Originally created and posted on the Oregon Housing Blog.

Updated: Hardest Hit Income Limits Recommendation Using New FY 2010 Median Family Incomes.

 Update: I added a Hardest Hit column to far right of table to identify the 16 hardest hit counties; link remains the same.
-------------

I previously posted a summary of the Bend morning Hardest Hit outreach session, including the suggestion that income limits be set at the highest of either 120% of the STATEWIDE median family income OR 120% of the LOCAL median family income. (This would be rather than a straight 120% of statewide median income eligibility level that has been previously discussed). 

I created a 2 page PDF table HERE that shows the results of this recommendation using the NEW FY 2010 HUD median family incomes just published today [Friday]. (Feel free to double check my math, which includes use of a rounding to nearest $100 formula; if you discover any problems please send me an email or post a comment).

Eligibility Results: Three Metro Areas Get Up to 120% of Local MFI, All other Counties REMAIN at Same Level--ABOVE 120% of Local Median Income.

You can see that all counties would be at LEAST 120%, with rural counties as high as 172% of their LOCAL median family incomes. Without the recommended changes rural county %'s of LOCAL median family incomes would stay the same BUT counties in the Bend, Corvallis and Portland MSA's would be BELOW 120% of their LOCAL median family incomes.

Originally created and posted on the Oregon Housing Blog.