Test Embed of Excel File in the Cloud: GSE CY 2010 Oregon Hispanic Loans by County.

I am pasting below one of the worksheets from the GSE Excel workbook that I posted yesterday.  This worksheet shows GSE Hispanic loans in Oregon for CY 2010, by county and by loan purpose. 

The embed is from file I have posted to MS cloud service (Windows Live SkyDrive).

In addition to being able to view the Excel file in this post in your browser

• You can use the scroll bars to see columns/rows not initially visible. 
• Also note that at the very bottom of the embed you also have the option to download the actual Excel file with this worksheet or to open it full size in your browser. 

Being able to view/download Excel files in their original formats within a blog post/browser is a clear demonstration of how "the cloud" can be creatively integrated with our current desktop applications. Being able to "Save As" a file into the cloud should reduce the need to send files as email attachments and expand the ability to share and collaborate with others.

Note: A direct link to this file is HERE. 

I am still very much in a learning curve in using this new capability; would appreciate any feedback on your experience in viewing and downloading this Excel file.

Originally created and posted on the Oregon Housing Blog. 

Sunshine Week Capstone: Posting of Large GSE MS Access Databases Covering $1 Trillion in CY 2010 Loans.

Readers will recall that I have previously posted [to date] 10 tables in a PDF file titled A Picture of GSE Assisted Households, CY 2010 and also [to date] 4 GSE related Excel workbooks in an on line SpiderOak data storage folder.

To cap off my national Sunshine Week posts I am pleased to announce today that I have created a new on line SpiderOak data storage folder that contains the source data for all of my recent GSE posts-- two VERY large GSE MS Access databases (As I have noted before those databases would not have been possible without the assistance of my friend (and also a retired HUD Oregon Field Office Director) Roberta Ando). 

Caution--BEFORE You Download these MS Access Databases

These MS Access databases are VERY LARGE [Freddie's is 383 MB's and Fannie's 588 MB's]. I recommend that you do not download them unless you have a broadband connection, AND a fast PC, AND substantial memory/RAM and disk space. (I use a notebook PC with 8GB of memory and an Intel Core i7 processor and working with these files maxes out my system).

How to Download These MS Access Databases

1. The MS Access databases and other related documents can be found in a folder located on a cloud storage site, SpiderOak.
2. The web page  for that folder is HERE.
3. I have also added a link to this folder in the right pane of my blog; look for GSE CY 2010 Access Databases.
4. The folder contains two MS Access files (one for each GSE), and two PDFs; AN IMPORTANT READ ME PDF, and a PDF data dictionary that has codes for  the 39 data fields in each record.
5. The initial view of this folder/web page will allow you to click on the “download” radio button to the right to download both databases and a “READ ME” files as a compressed  zip file [ I DO NOT recommend this method as I encounter errors in the size of the downloaded file and in trying to open the file]. 
6. INSTEAD I recommend that you A. Left click on the folder name on the left side of the page  to open the folder and look for the file name that is of interest to you [I would select the READ ME file first].  B. Then on the right side of the web page, left click the “download” radio button  for each file to download that file in an uncompressed format.
7. After downloading the file(s), navigate to the directory where you downloaded the file and double click the file to open. [To conserve memory, before you try to open one of these MS Access databases I would recommend that you shut other programs and perhaps also your browser].

A Similar Cloud Folder Has (Smaller) MS Excel Files for Downloading

I have also previously posted links to a second cloud folder similar to the one above that contains only MS Excel files that I have created using the MS Access databases as a source. 

Files in this MS Excel folder are substantially smaller than the MS Access files because they focus  on subsets of data in the  MS Access databases, but some are still in the 100 MB range, so don't download them unless you have the PC resources (processor speed and memory) to work with them once downloaded. 

You can use the same How to Download instructions from above; a link to the GSE MS Excel folder is in the right pane of my blog as GSE CY 2010 Excel Files 

Future Annual GSE Transparency Will Require New FHFA Cooperation
FHFA currently publishes CT level loan level GSE data ONLY in text formats, and as a result very little public analysis has been done. These databases demonstrate that it IS possible to create GSE files in formats that are more likely to be used by the general public and that clearly will make the geographic and demographic distribution of GSE loans more transparent.

As I have noted elsewhere,  I will be working with elected officials and FHFA to insure that the CY 2011 GSE data posted in September 2012 is published in these MS Access formats. 

I am offering to share with FHFA free of charge the MS Access databases I created AND and also a small MS Access Data Import  Spec file that could be posted that would allow others to import text files into MS Access (this would eliminate need for FHFA to directly post files in MS Access format; users would use the Data Import Spec to correctly import the text file into MS Access).

[None of the GSE Access, Excel or PDF files would have been possible without the help of my friend, and fellow retired HUD Oregon HUD Office Director, Roberta Ando).

Originally created and posted on the Oregon Housing Blog.

New GSE Excel Post: Details for 117,000 Loans to African American Borrowers.

I have put together a new GSE Excel workbook with loan level details for $22.529 Billion in CY 2010 GSE acquired loans for 117,524 African American Borrowers and Co Borrowers. 

How to Download These GSE Excel Workbooks

1. All of these GSE related Excel workbooks are included in a folder I have created on a cloud data sharing service, SpiderOak.  A link to that folder is HERE and it has also been added to the right pane as GSE CY 2010 Excel Files. [Ask me sometime about what a pain it was to find a web site that can host large file sizes].
2. The link above will open a web page.
3. From that web page you will see a “download” radio file on the right side that is supposed to allow you to download all Excel files in this folder as a single compressed file-I DO NOT recommend this method as I encounter errors in the size of the downloaded compressed file and in trying to open the file.
4. INSTEAD you should A. Left mouse click on the underlined folder name on the LEFT side of the page [GSE 2010 Public Shared Excel]  to open the folder AND THEN B. Click the “download” radio button on the right side for that file to download each file individually in an uncompressed format.
5. After downloading the file(s), navigate to the directory where you downloaded the file and double click to open.

GSE Loans Excel Workbook 4: GSE Loans to African Americans [47 MB]

The data in this Excel workbook consists of data for 117,524/$22.529 billion in single family loans purchased by the GSE’s during CY 2010 where the borrower OR Co borrower was an African American.  

The GSE CY 2010 data dictionary with all 39 field names and values can be found HERE (and has also been included in the SpiderOak Excel folder).

In addition, to make the workbook easier to use,  I created lookup formulas to add fields with NAMES for 8 of the 39 data elements; those additional columns begin at column “AN” of the Oregon CY 2010 GSE Data worksheet. These include columns with the county and MSA names, names for race and ethnicity, a name for the purpose of the loan, and a column that places the ratio of borrower income to median area income in one of 5 categories /“bins”. 
 

This workbook also includes a pivot table, allowing users to focus on geographies or demographics of interest; the default view is for a count of all loans by state showing by GSE the number of loans to African Americans. Users can change the fields displayed in the pivot table to retrieve any combination of data using the data fields available. 

The workbook also includes a state summary of the share of all loans that went to African Americans, in ranked order by the percentage of all loans to African Americans. (This state level African American loan summary also appears as Table 10 in the PDF file with my series of GSE CY 2010 tables, Picture of GSE Assisted Households, CY 2010) 

Finally, this workbook contains a second detailed state worksheet summary of African American loans counts by GSE and by borrower/co borrower.

Originally created and posted on the Oregon Housing Blog.

New Table Added to Picture of GSE Assisted Households CY 2010: $22.5 Billion in Loans to 117,000+ African Americans.

I have added a new table to the GSE PDF table series, with a link in the right pane, Picture of GSE Assisted Households, CY 2010.

Table 10 shows a count of loans and $$ by state, ranked by the share of all single family GSE loans made to African American borrowers or co borrowers
 

Some observations:

1. Oregon ranked 42nd in the share of all GSE loans in the state that went to African Americans.
2. Among top 20 states in share of loans to African Americans only two (Nevada and Texas ) were west of the Mississippi river.
3. In Michigan and California, states with substantial African American populations (6.67% and 14.27%), only 1.6% of GSE loans went to African Americans. [Wikipedia state African American population table is HERE].
4. GSE CY 2010 loans to investors [prior post] at $40.2 billion/243,000 loans were substantially higher than $22.5 billion/117,000 loans to African Americans.

Note: 

In this table and in my coming Excel workbook "African American borrowers" includes all loans where an African American was borrower AND all loans where African American was a co borrower (even if borrower was not African American). 

Excel Workbook Coming  
A scheduled posting later will include a link to my Excel cloud space folder where the complete Excel workbook with loan level records for African American borrowers and co borrowers will be uploaded so users may do further analysis.

Originally created and posted on the Oregon Housing Blog.

In CY 2010 GSE's Purchased 8,100 Loans Made to Millionaires.

I have put together an Excel workbook with loan level detail for $3 billion/8,139 loans purchased by the GSE's in 2010 that were to borrowers with incomes of $1 million or more.  

( I have also added the state level summary of loans to Millionaires to my PDF compilation in the right pane, Picture of GSE Assisted Households, CY 2010). Look for Table 9.  

Millionaires make up a VERY small percentage (2/10ths of 1%) of the more than 4.8 million loans purchased by the GSE's in CY 2010 and a substantial number of these loans could have been refinances of existing loans (users can research that more closely using this Excel workbook). 

In Oregon in CY 2010 there were a total of 104 GSE loans that went to millionaires, totaling $25.8 million; this represented only 1/10th of 1 percent of all loans in Oregon.

How to Download GSE Excel Workbooks

1. All of these Excel posts are included in a folder I have created on a cloud data sharing service, SpiderOak.  A link to that folder is HERE and it has also been added to the right pane as GSE CY 2010 Excel Files. [Ask me sometime about what a pain it was to find a web site that can host large file sizes].
2. The link above will open a web page.
3. From that web page you will see a “download” radio file on the right side that is supposed to allow you to download all Excel files in this folder as a single compressed file-I DO NOT recommend this method as I encounter errors in the size of the downloaded compressed file and in trying to open the file.
4. INSTEAD you should A. Left mouse click on the underlined folder name on the LEFT side of the page [GSE 2010 Public Shared Excel]  to open the folder AND THEN B. Click the “download” radio button on the right side for that file to download each file individually in an uncompressed format.
5. After downloading the file(s), navigate to the directory where you downloaded the file and double click to open.

GSE Loans Excel Workbook 3: GSE Loans to Millionaires [3.7 MB]

The data in this Excel workbook consists of $3 billion/8,139 loans purchased by the GSE’s during CY 2010 where borrower income of $1 million or more was reported.  The GSE CY 2010 data dictionary with all 39 field names and values can be found HERE:

In addition, to make the workbook easier to use,  I created lookup formulas to add fields with NAMES for 8 of the 39 data elements; those additional columns begin at column “AN” of the Oregon CY 2010 GSE Data worksheet. These include columns with the county and MSA names, names for race and ethnicity, a name for the purpose of the loan, and a column that places the ratio of borrower income to median area income in one of 5 categories /“bins”.  [For this workbook only I added one additional column that shows the ratio of borrower annual income to the median income for the census tract where the loan was purchased].
 

This workbook also includes a pivot table, allowing users to focus on geographies or demographics of interest; the default view is for a count of all loans by state showing by GSE the number of loans to millionaires. Users can change the fields displayed in the pivot table to retrieve any combination of data using the data fields available.  A summary worksheet in the workbook includes a ranked order by state of the % of all GSE loans that went to millionaires.

NOTE:
Loan records in this workbook are limited to ONLY borrowers with incomes of $1 million or more.

Originally created and posted on the Oregon Housing Blog.

Excel Workbook with Details on $40.2 Billion in GSE Single Family Loans Made to 243,000 Investors in CY 2010.

I have put together a first ever Excel workbook with loan level detail for $40.254 Billion in GSE acquired loans for 243,018 investors during CY 2010.  

Note: $40 Billion is only $4.6 billion less than the TOTAL HUD proposed budget for FY 2013, while the 243,000+ investor loans represent 5.1% of the 4.8+ million single family loans purchased by the GSE's in CY 2010.

How to Download These GSE Excel Workbooks

1. All of these GSE related Excel workbooks are included in a folder I have created on a cloud data sharing service, SpiderOak.  A link to that folder is HERE and it has also been added to the right pane as GSE CY 2010 Excel Files. [Ask me sometime about what a pain it was to find a web site that can host large file sizes].
2. The link above will open a web page.
3. From that web page you will see a “download” radio file on the right side that is supposed to allow you to download all Excel files in this folder as a single compressed file-I DO NOT recommend this method as I encounter errors in the size of the downloaded compressed file and in trying to open the file.
4. INSTEAD you should A. Left mouse click on the underlined folder name on the LEFT side of the page [GSE 2010 Public Shared Excel]  to open the folder AND THEN B. Click the “download” radio button on the right side for that file to download each file individually in an uncompressed format.
5. After downloading the file(s), navigate to the directory where you downloaded the file and double click to open.

GSE Loans Excel Workbook 2: GSE Loans to Investors [95 MB]

The data in this Excel workbook consists of data for 243,018 /$40.2 billion in single family loans purchased by the GSE’s during CY 2010 where the borrower was an investor (Code value of "2" denoting "investment property" in data field 35, "Occupancy Code"). The GSE CY 2010 data dictionary with all 39 field names and values can be found HERE (and has also been included in the SpiderOak Excel folder).

In addition, to make the workbook easier to use,  I created lookup formulas to add fields with NAMES for 8 of the 39 data elements; those additional columns begin at column “AN” of the Oregon CY 2010 GSE Data worksheet. These include columns with the county and MSA names, names for race and ethnicity, a name for the purpose of the loan, and a column that places the ratio of borrower income to median area income in one of 5 categories /“bins”.  

This workbook also includes a pivot table, allowing users to focus on geographies or demographics of interest; the default view is for a count of all loans by state showing by GSE the number of loans to investors by income groupings. Users can change the fields displayed in the pivot table to retrieve any combination of data using the data fields available. NOTE again that loans in this workbook are limited to ONLY loans made to investors.

This workbook also includes a state level summary of the count of loans to investors, the unpaid principal amount of loans at time of GSE acquisition, and columns showing the share of all GSE loans and loan $$ that went to investors, as well as state high to low rankings using the share of loans and $$ that went to investors.  (This state level investor loan summary also appears as Table 8 in the PDF file with my series of GSE CY 2010 tables, Picture of GSE Assisted Households, CY 2010). Finally, another summary table is a list of the top 10 states based on the % of all loans in that state that went to investors

Originally created and posted on the Oregon Housing Blog.

New Table Added to Picture of GSE Assisted Households CY 2010: $40.2 Billion in Loans to 243,000+ Investors.

I have added a new table to the PDF linked series in the right pane, Picture of GSE Assisted Households, CY 2010. 

Table 8 shows a count of loans and $$ by state of single family loans made to investors, columns that show the percentage of all GSE loans in that state that went to investors, and rankings by the share of loans within the state that went to investors. 

Some observations: 

• The national total of $40.2 billion in GSE investor single family loans was only $4.6 billion less than the total HUD budget proposed for FY 2013.
• Surprisingly, three states (Idaho, Oregon, and Washington) in HUD Region 10 were among the top 10 states in the share of loans that went to investors: 

• Further analysis of this data may show that a large share of the GSE investor loans in some states were refinances of existing investor loans. A scheduled posting later this week will include a link to my Excel cloud space folder where the complete Excel workbook with investor loans will be uploaded so users may do further analysis.

Originally created and posted on the Oregon Housing Blog.

Sunshine Week Posts Will Focus on Details of $1 Trillion in GSE Loans.

To celebrate national Sunshine Week, I am planning a series of posts this week focused on the data found in the MS Access databases I recently completed (with the assistance of former HUD Oregon Field Office Director Roberta Ando).  These databases include loan level data on 4.8 million loans with loan balances that exceeded $1 Trillion when they were purchased by the GSE's in CY 2010.

Look for posts that add PDF tables to the Picture of GSE Assisted Households, CY 2010 in the right pane.  

The link to my cloud data site for Excel files in the right pane, GSE CY 2010 Excel Files , will also be updated with new Excel workbooks that provide loan level data for ALL U.S. loans purchased by the GSE's that had been made to 

• Investors, 
• Millionaires, and
• African Americans

Oh, and ONE more thing; toward the end of the week, look for one big final GSE post. 

Originally created and posted on the Oregon Housing Blog.

MS Excel: Loan Level Detail for $17+ Billion in CY 2010 Oregon GSE Loans.

Up until now all of my posts on GSE CY 2010 data have been PDF files compiled into the PDF file linked in the right pane as Picture of GSE Assisted Households.

Today, I am beginning the posting of several GSE CY 2010 MS Excel workbooks that zero in on different geographies or areas of demographic interest. I believe this is the only place on the web where you will find GSE CY 2010 data with this level of individual loan detail, including loans in both rural and metro areas. [Kudos again to Roberta Ando for helping me put together the MS Access databases that were used to extract this data].

How to Download the Excel Workbooks

1. All of these Excel posts are included in a folder I have created on a cloud data sharing service, SpiderOak.  A link to that folder is HERE and it has also been added to the right pane as GSE CY 2010 Excel Files.[Ask me sometime about what a pain it was to find a web site that can host large file sizes].
2. The link above will open a web page.
3. From that web page you will see a “download” radio file on the right side that is supposed to allow you to download all Excel files in this folder as a single compressed file-I DO NOT recommend this method as I encounter errors in the size of the downloaded compressed file and in trying to open the file. 
4. INSTEAD you should A. Left mouse click on the underlined folder name on the LEFT side of the page [GSE 2010 Public Shared Excel]  to open the folder AND THEN B. Click the “download” radio button on the right side for that file to download each file individually in an uncompressed format.
5. After downloading the file(s), navigate to the directory where you downloaded the file and double click to open. 

First Excel Workbook: GSE Loans Excel Workbook 1: All Oregon GSE Loans [29.3MB] 

This workbook includes loan level data on 84,000+ loans purchased by Fannie Mae and Freddie Mac in Oregon during CY 2010; The unpaid principal balance at acquisition for these loans was more than $17.1 billion.

In addition, to make the workbook easier to use, I created lookup formulas to add fields with NAMES for 8 of the 39 data elements; those additional columns begin at column “AN” of the Oregon CY 2010 GSE Data worksheet. These include columns with the county and MSA names, names for race and ethnicity, a name for the purpose of the loan, and a column that places the ratio of borrower income to median area income in one of 5 categories /“bins”.

The file includes a data file, a pivot table and READ ME sheet.The pivot table allows users to focus on geographies or demographics of interest; the default view is for a count of all loans by county for both GSE’s, broken out by income grouping in columns. Users can change the fields displayed in the pivot table to retrieve any combination of data using the data fields available.  

Sample questions the pivot table can answer:

1. How many loans were purchased by the GSE's in X CT, county, MSA and what percent went to borrowers with incomes below 100% of AMI? [Add race, ethnicity, gender breakouts].
2. How many investor loans were purchased and what were the borrower incomes?
3. How many home purchase vs refinance loans?
4. What was the average unpaid principal loan balance for different areas, races, ethnicity?
5. How many first time home buyer loans were purchased in CT, county, MSA, state?
6. How many loans were purchased in CT with higher minority %?

Originally created and posted on the Oregon Housing Blog.

Corrected: GSE CY 2010: Data for 374 Metro Areas, Including 6 In Oregon.

Correction:
I inadvertently included "Not in Metro Location"  in the Metro rankings found in Table 6. Eliminating those areas from Metro rankings changes the total metro ranks to 374, and increased relative rankings for all metro areas by one. 

I have made changes in Table 6 of the Picture of GSE Assisted Households, CY 2010 and also changes in the text of the post below. Portland now ranks as 19th and Seattle 8th in the number of GSE loans by metro area. 
-----------------

I have added three new metropolitan area focused tables to the link in the right pane, A Picture of GSE Assisted Households, CY 2010. These tables are:

• Table 5: GSE CY 2010 Alpha Metro Loan $$ and Counts.
• Table 6: GSE CY 2010 Ranked Metro Loan $$ and Counts.
• Table 7: GSE CY 2010 Oregon Metro Loan $$ and Counts.

Some observations: 

1. The Portland metro area ranked 19th in the number of GSE loans, at 58,645 loans / $12.6 billion. [In 2010, the Portland metro population ranked 23rd in the country].
2. The Portland metro area ranked HIGHER than Detroit's 52,355 in GSE loan purchases, even though the Detroit metro area had a 2010 population that was nearly double (93% larger) the size of the Portland metro area. [Detroit metro pop 4,296,250 vs 2,226,009 for Portland ].
3. Seattle, ranked 15th in 2010 metro population, also ranked higher at 8th in the number of GSE area loans by metro area [ 96,868 loans/ $25.4 billion].
4. The designator "Not a Metropolitan Location" totaled 539,497 loans and $84.9 billion. These are loans that would NOT appear in HMDA data as they are outside metro areas. [Not shown in these tables, I count 12,665 Oregon loans that are coded as "Not a Metro location"; these loans totaled $2.198 billion].
5. Within Oregon, Bend and Medford (hard hit by foreclosures) still had a combined 7,758 GSE loans/ $1.5 billion. 

Notes: 

I would NOT print the entire tables 5 and 6 unless necessary, they are 14 -15 pages each.

Originally created and posted on the Oregon Housing Blog.

Fannie, Freddie, and FHA In Oregon, CY 2010: Ho Hum, Another $21 Billion Year.

Readers may recall a September 2010 post HERE that showed an Oregon county breakdown of $21 Billion in Fannie, and Freddie AND FHA loans for CY 2008. 

Because it requires so much work to produce this data, I skipped CY 2009 but have just added two additional tables to the PDF file linked in right pane of the blog; A Picture of GSE Assisted Households, CY 2010.

Look for These Two New Tables:

• Table 3: Loan Counts by Oregon County for Fannie, Freddie AND FHA, Including Loan Purpose and Shares
• Table 4: Loan $$ by Oregon County for Fannie, Freddie AND FHA, Including Loan Purpose and Shares

Some Observations:

1. During CY 2010 in Oregon there were $21.35 Billion in loans acquired or insured by the GSE's and FHA.
2. The loans went to 104,000 households.
3. Among the three agencies, FHA's share of all loans was 19%, but it had a much larger 43% share of home purchase loans. 
4. Refinances made up 82% of the GSE business in Oregon during CY 2010. 

A Multiple Year Look at Federally Supported Home Ownership Program in Oregon:
Last 3 Years: More than $65 Billion; Last 4 Years: Estimated $80 Billion.

Federally supported home loan commitments in Oregon were in excess of $65 billion for the 3 years from 2008-2010 assuming: 

• That GSE and FHA volume during 2009 was roughly the same as 2008 and 2010.
• That VA and RDA loans totaled $1 billion annually.

Assuming GSE and FHA loan volume was somewhat down during CY 2011, a working estimate is that for the last 4 calendar years federally supported home loans in Oregon totaled close to $80 Billion.

Putting an Oregon annual $20 Billion, 100,000 GSE, FHA, VA, and RDA Assisted Households A Year Estimate in Perspective:

• The federal Consolidated Federal Funds Report shows that federally supported Small Business Loans (CFDA 59.012) in Oregon totaled only $104 million during FY 2010.
• CBPP estimates HERE that there were 54,000 federally assisted renter households in Oregon in 2010, 75 years after the beginning of these programs.

Originally created and posted on the Oregon Housing Blog
 

Where Did $1 Trillion in GSE Loans Go?/ A New Picture of GSE Assisted Households Will Answer That and Other Questions.

Stay tuned....

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. 

Amended: FHA SF Loans CY 2010 by Oregon County.

Added comment on Deschutes and Jackson County noting that a high share of their loans were home purchase loans. 
--
I have created a table HERE showing the CY 2010 count and dollar volume of FHA Single Family loans for all Oregon counties.  

The table includes a breakout of loan, by purpose: purchase; refinance; or HECM/reverse equity (another form of refinance--you might call it "the final refinance" if you were morbid): 

If you print the table it is LEGAL sized and landscape orientation to allow all the data to fit on two pages. 

I have previously posted about the 20,000/$4.2 billion statewide totals for CY 2010 HERE. 

Two additional observations I would make about the county data are:

• The 5 Oregon Portland metro counties accounted for a little more than half of the total state volume of CY 2010 FHA loans (10,439/19,999=52%). 
• Deschutes (71%) and Jackson (70%) had higher rates of home purchase loans than the 55% statewide rate. 

Originally created and posted on the Oregon Housing Blog.

NEW Oregon FHA CY 2010 Home Loan Data: 20,000 Loans ($4.2 Billion); Refinancing Drop Off Pushes Overall Volume Down by 24% vs. CY 2009.

My one page DRAFT table for last three years, including new CY 2010 data, is HERE. Some quick observations:

1. Total FHA single family loans in Oregon over last 3 calendar years were more than 64,000 loans , $13.8 billion. 
2. Total CY 2010 loans were 20,000 , $4.18 billion.
3. CY 2010 VS. CY 2009:  

• Overall decline in number of loans was 24%;
• 33% decline in refinance loans;
• 59% decline in HECM/reverse equity loans (another form of refinancing);
• Purchase loans down only 6%.

I hope to have some county level FHA totals for CY 2010 up by the end of this week, beginning of next.  Any changes to this draft will reflected in the statewide totals.

                       
Originally created and posted on the Oregon Housing Blog.