Oregon CY 2011 GSE Data in Excel (W Gift Card Contest): GSE Loans Down 16% from CY 2011, Still Nearly $14 Billlion.

I have extracted Oregon data from the CY 2011 national GSE Public Use MS Access database and have posted that (much smaller) 27 MB Excel workbook to Google Docs HERE (it's possible that you may need a free Google account to download but I don't think so).

The Excel workbook includes an enhanced version of the MS Access data that includes several fields I created that show names for otherwise coded data, including county and metro names, names for borrower and co borrower race and ethnicity, and a income grouping name (less than 80% MFI, etc.),  [For the codes used for other fields look at the CY 2011 data dictionary is HERE].

Also included in the workbook are:

1. A statewide comparison of loan counts and $$ for CY 2011 vs  CY 2010.  
2. County level loan counts and $$ for CY 2011 AND CY 2010.
3. A pivot table.
4. A summary of CY 2011 loans by county and by agency.
5. Select code values with a link to the CY 2011 data GSE census tract data dictionary.

Observations: 

1. Total Oregon GSE loans in CY 2011 were 70,656; Total loan $$ were $13.8 billion.
2. CY 2011 vs CY 2010: The GSE reduction in loan counts was 16% overall, but only 2% for home purchase loans; Fannie Mae's reduction was only 10%, and Fannie Mae Home Purchase loans grew by 5%.   
3. My prior post HERE summarizes data showing an even LARGER 32% drop in the count of Oregon FHA loans for CY 2011 to 13,659, with a loan volume of $2.7 billion.  
4. So, combined CY 2011 GSE and FHA loan volume in Oregon was 84,315 and $16,492,372,532 vs.104,288 and $21,350,843,920 in CY 2011. (That's a 19% reduction in the number of loans and a 23% reduction in loan $$).                 

Gift Card Contest: 
ITunes gift card, and shout out, to the first person who uses the pivot table to find and send me the correct answer to the question:

 "In CY 2011, out of the total of 70,656 loans they acquired in Oregon, how many total Oregon loans did the GSE's purchase that had been made to first time home buyers with either a Hispanic borrower OR coborrower?

Originally created and posted on the Oregon Housing Blog. 

FHFA Posts GSE CY 2011 Census Tract Level Data as MS Access Database.

You can download newly posted CY 2011 GSE single family census tract level MS Access database HERE (it is 246 MB's and will take LOTS of PC power so I wouldn't download and try to open unless you have lots of RAM and computing power).  

Main page for FHFA public disclosures is HERE.

Readers will recall getting FHFA to post this database in MS Access format was one of rare occasions where outcome was exactly what I was hoping, in no small measure thanks to follow up from Will White, Senior Advisor to Senator Merkley. I'm very pleased that FHFA posted CY 2011 GSE CT level data in this format with need for prompting.

Originally created and posted on the Oregon Housing Blog.

Oregon FHA Loan Volume Drops by 32% in CY 2011 but Still Tops 13,000 Families, $2.3 Billion.

I recently completed an analysis that showed that the total number of FHA loans in Oregon in CY 2011 was down 32% from the records set in CY 2010.  

The decline for home purchase loans was less, at 25%. This means that the share of all FHA loans that were for home purchases increased to 61% from the 55% in CY 2011.

Even with the volume decrease there were 13,659 FHA loans insured in Oregon in CY 2011, representing a commitment of $2.369 Billion.  

In addition to the drop in loan volume the average FHA insured loan amount decreased by 5.7%, from $209,412 to $197,558. 

My statewide CY 2010-CY 2011 summary and county level CY 2011 data is available in the PDF file I created HERE. 

Originally created and posted on the Oregon Housing Blog.

CY 2011 Through June: County Breakout of $1.5 Billion in Oregon FHA Loans, With Full Year CY 2010 Statewide Comparison.

I have prepared two tables in a 3 page PDF HERE. File  includes:

• A county breakout of FHA SF loans in Oregon for CY 2011 through June by loan type. (Home Purchase, Refi, and HECM).
• By loan type, a statewide comparison of first half CY 2011 loan volume with full year CY 2010 loan volume. (This is third page of the PDF).

Some observations about the first six months of CY 2011 Oregon FHA loan activity:

1. FHA has insured 7,530 loans, representing the commitment of more than $1.5 billion in private funds.
2. Of that total, 4,272 loans were used to purchase a home, with loan commitments that exceeded $803 million. (That's 53% of total dollars, and 57% of the total number of loans). The remainder of loans were refinance loans, including reverse mortgage loans (HECM's).
3. Oregon FHA SF loan volumes are 38% of record full CY 2010 totals.
4. Compared to full year CY 2010, the amount of the average FHA insured home purchase loan is down 5.2% statewide and 6.2%  in the 5 county Portland metro area of Oregon.
5. The average HECM loan was $81,000+ more than the average home purchase loan; 67% of HECM loans were made outside the Portland metro area, compared to only 46% of regular refinance loans. 

Originally created and posted on the Oregon Housing Blog.