Centering GSE 2020 Oregon Loan Acquisitions on Minority Borrowers and Co-Borrowers.

In my most recent post this week I included a link to a new Excel workbook I created that included loan level detail for 163,000 GSE (Fannie Mae and Freddie Mac] loan acquisitions in Oregon in 2020.

I have now added 11 new worksheets to the GSE Excel file I created earlier HERE . The file is slightly larger at 135 MB, but the link and file name remain the same.

These worksheets focus exclusively on minority loans acquired by the GSE‘s in Oregon in 2020.

First, there is a two page summary of loans acquired for borrower or co-borrowers in four minority racial categories and for Hispanic borrowers or co-borrowers. That PDF file is HERE and the summary section is pasted below.

Then there are five pivot tables and five related data worksheets for Hispanic, American Indian or Alaska Native, Asian, Black, and Native Hawaiian Islander or other Pacific Islander borrower or co-borrowers.

Share of  Oregon GSE Loans: Four Minority Racial Categories and Hispanics 

The data shows that 5.9%/13,358 of all 163,089 loan acquisitions were for borrower or co-borrowers in 4 racial minority categories and 8.2%%/9,558 were for Hispanic borrower or co-borrowers.

For (43,640) home purchase loans those shares were 9.4%/4,088 (four minority racial categories) and 7.6%./3,324 (Hispanics).

And for (18,884) first time homebuyer loans those shares were 11.3%/2,136  (four minority racial categories)  and 9.9%/1,869 (Hispanics).

Many GSE Minority Loans Acquired Were FHA Insured Loans

84% of all loans reported by the GSE‘s for four minority racial categories were FHA insured loans. FHA insured loans were 80% of all Hispanic loans acquired by the GSE’s.

That FHA share drops to about 48% for home purchase loans for the four minority racial categories and 44% for Hispanic home purchase loans. 

And, perhaps because of rules that may have restricted how government guaranteed loans can be counted toward GSE goals, the percentage of FHA insured loans for first time homebuyer loans acquired for the four minority racial categories, and for Hispanics, was reported as ZERO.

Note that the GSE FHA loan counts are NOT all 2020 Oregon FHA loans made to borrowers and Co-borrowers in the four racial categories or to Hispanics, just those loans that were FHA insured and then acquired by GSE’s.

Originally created and posted on the Oregon Housing Blog.

Update: 2020 GSE Oregon Loan Purchases: $49 Billion, 163,000 Loans. First Time Homebuyers? $6 Billion, 19,000 Loans.

Update: I have added 11 worksheets to help focus on 2020 Oregon minority home loan acquisitions by the GSE's. 

New post HERE has the details. 

--------------

For 20 years I have downloaded and analyzed  Oregon data on loans purchased by Fannie Mae and Freddie Mac (The "GSE's). In 2001 I used that data to provide reports on the state of African American and Hispanic homeownership in Oregon. (Short version: GSE's weren't doing much to help first time African American and Hispanic homeowners and increasing homeownership rates requires more lending to first time home buyers). 

A chronological listing of my blog posts with GSE as the keyword is HERE, 

Several years ago, thanks to Will White in Senator Merkley's office, we finally got the GSE regulator (FHFA) to release annual GSE data in a MS Access format to make it easier to extract data for analysis in Excel.  Data is available at the state, metro, county, and census tract level. 

FHFA published the GSE 2020 data late last week. This year FHFA has changed the data posted to require combining two tables in Access in order to get all data fields for each loan acquired. Suffice it to say that it is a multiple step PITA to do so. [It would be much more user friendly to split the data, sorted by state name]. 

New Excel File

Thanks to the weekend rain I hunkered down and produced a 125 MB Excel workbook HERE with all the GSE loan data for 2020 for Oregon. I added several columns to convert codes into NAMES that users could understand. [File is large at about 125 MB's].

The GSE data includes many of the same data fields as the HMDA data, but covers more geography. Notably it does NOT include lender identification but DOES include FIRST TIME HOMEBUYER data that is missing in HMDA data. 

Within the Excel workbook are multiple worksheets listed in the READ me file in the workbook. They include.

• A pivot table which allows users to explore topics of interest, including race, ethnicity, gender, loan to value, financing costs, etc. [See pic pasted below for snapshot of Pivot table loan counts by Oregon metro area].
• A listing of all data fields including those that I added. 
• Two subordinate worksheets that include only 2-4 unit properties AND only first time homebuyer purchase loans.  
• A statewide and a county level summary worksheet with counts and dollars for all loans, all purchase loans, and first time home purchase loans. Both worksheets include calculations of the PER UNIT acquisition balance for 2, 3, and 4 unit properties AND how those average PER unit costs compare to ONE unit homes. (Spoiler alert--they are a LOT lower). 

Some statewide observations:

The statewide summary as a PDF is available HERE and embedded below. 

A total of 163,089 loans were purchased with 166,107 units. Two to four unit properties accounted for 2,168 loans and 5,186 units. 

Two to Four Unit PER UNIT Average Principal Balances at Acquisition Were Substantially Lower than for One Unit Properties.

The average mortgage balance at acquisition for ONE unit loans was $300,016. 

On a PER UNIT basis the average mortgage balance at acquisition for two to four unit properties was $128,074. That's 57%/171,942 LESS PER UNIT than a one unit property. 

For two to four unit home purchase acquisitions (NOT refinances) the PER UNIT difference was even higher at 58%./$191,148. 

Originally created and posted on the Oregon Housing Blog. 

CY 2010-CY 2012 Data Trifecta: Census Tract Level GSE SF Loan Data; $50 Billion in Loans to 252,000 Oregon Families.

I have prepared a one of a kind 95MB Excel workbook HERE that contains census tract loan level data for $50 Billion/ 252,000+ Oregon single family loans acquired by the GSE's in Oregon during CY 2012, CY 2011, and CY 2010.(I extracted this data from FHFA public use databases for these years).

The data worksheet has columns I have added to FHFA data to show names instead of codes for several selected fields including borrower and co-borrower race and ethnicity, loan purpose, and borrower income ranges; with 48 fields of data for each record, there are more than 12 million pieces of data available for these 3 years . 

A complete list of all fields in the data downloaded from FHFA (a data dictionary) for 2012 is HERE, 2011 HERE, and 2010 HERE [ Census tract definitions, minority percentages, and median incomes may vary from year to year as newer information became available]. 

Using filters and the pivot table in the Excel workbook users can research answers to questions like these:
1. How many loans were acquired that were made to purchase a home where there was a first time Hispanic Borrower or Co-borrower, and where were those loan made (A similar analysis is possible by race).
2. How many/where were loans acquired for borrowers with incomes below 80% MFI? 
3. How many /where were loans acquired that had been made to investors, and where were those loans? 
4. Who got high cost loans and where were they? 
5. How did refinance loan volume change from year to year?

Note that unlike HMDA data, the GSE data covers ALL areas of the state, not just metro areas, and also includes a first time home buyer field not found in HMDA data.

The PDF file HERE and embedded below summarizes by CY and by county and by year the unpaid loan balance at the time of GSE acquisition and the count of loans.



Originally created and posted on the Oregon Housing Blog. 

GSE Public Use MS Access Single Family Database for CY 2012 Available.

The MS Access GSE CY 2012 public use single family database, with data to the census tract level, is available as a zip file HERE. The web page with all GSE CY 2012 data is HERE.

My post with CY 2012 SF data from last year, which included an Oregon Excel workbook, is HERE. 

Readers may recall that posting of GSE SF data in MS Access formats occurred because of the actions of Senator Merkley, and his senior adviser Will White. 

Originally created and posted on the Oregon Housing Blog.

OR GSE Delinquencies: Still 20,000+ Delinquent Loans; Serious Delinquency Rate Was 17th Worst in Country, Higher than California, but LESS than National Avg.

Using FHFA data from Appendix in report HERE I created Excel file and ranked states by serious delinquency rates. 

Excel file is HERE and embedded below: (It is in landscape format, so you may have to scroll to fully see all columns and rows).

Originally created and posted on the Oregon Housing Blog.

New GAO Report on GSE Multifamily Activity: 2011 Market Share was Double 2008 Market Share.

Haven't read in detail yet , but report is available from NCSHA site HERE.  Quick tidbits:

[GSE's]...financed less than 30 percent of annual multifamily loans originated before 2008 ...Their share of the multifamily market increased to 86 percent in 2009, but decreased to about 57 percent in 2011 as other participants reentered the market.

State table on PDF pages 90-91 shows $6.2 billion in GSE MF activity in Oregon from 1994-2011. (Recall that GSE's did $13.8 billion in SF loans in Oregon in CY 2011 alone).

Originally created and posted on the Oregon Housing Blog.

FHFA Data: Oregon Had 20th Highest Serious Delinquency Rate, But Below National Average.

Using newly released data I have prepared and uploaded to my SkyDrive a state level summary of FHFA foreclosure information in Excel HERE and embedded below: 



FHFA PR is HERE. 

Originally created and posted on the Oregon Housing Blog.

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.

GSE's Claim Exemption from Real Estate Transfer Taxes.

And have filed a lawsuit in Illinois, according to Housing Wire, HERE. 

Raises the question as to whether GSE's are paying Oregon doc recording fees, and would consider challenging those fees also. (If anyone has insights feel free to add comment to this post).

Originally created and posted on the Oregon Housing Blog.

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. 

Cinco de Mayo Special: Loan Level Details for $53 Billion in GSE CY 2010 Hispanic Loans.

From the GSE CY 2010 MS Access databases I previously created with by fellow retired former HUD Oregon Field Office Director Roberta Ando, I have created a new Excel workbook. 

It has loan level details for more than 253,000+ loans to Hispanic borrowers OR co-borrowers that were purchased by Fannie Mae and Freddie Mac (aka "The GSE's) during CY 2010. (Shameless blog promotion: I am sure you will not find this anywhere else):

That Excel workbook is posted in a Spider Oak web folder with all the other [large] Excel GSE CY 2010 files I created.

Included are the following 8 worksheets

1. OR Hispanic Summary 2010 (Summary at the County Level).
2. OR Hispanic Pivot 2010 (Default view is county, by income grouping).
3. OR Hispanic 2010 Data.(Used for Pivot)
4. US Hispanic Summary 2010 (State level summary, includes separate First Time home buyer state summary).
5. US Hispanic Pivot Table 2010 (Default view is count of all Hispanic loans by state).
6. US Hispanic Data 2010. (Used for Pivot).
7. Lookups (for selected fields).
8. Field Listing and Link to Data Dictionary for all fields.

How to Download Excel GSE Workbooks: 
Go to the GSE CY 2010 Excel Files  link in the right pane of my blog and within the folder look for GSE Loans Excel Workbook 5 All Hispanic GSE 2010 Loans.This is a large 100 MB file, so don't download it unless you plan on using it....
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].
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].  For Hispanic data look for GSE Loans Excel Workbook 5 All Hispanic GSE 2010 Loans
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. After downloading the file(s), navigate to the directory where you downloaded the file and double click the file to open.

Note: Tables from  worksheet 4 above have also been added as Tables 11 and 12 in the PDF file , Picture of GSE Assisted Households, CY 2010 in the right pane. 

US GSE Loans to Hispanic Borrowers or Co-Borrowers

1. There were nearly $5.9 billion in loans made to 29,000+ first time home buyers.
2. There were nearly $53 Billion in loans made to 253,000+ homeowners/home buyers.

Oregon GSE Loans to Hispanic Borrowers or Co-Borrowers

1. There were $37.8 million loans made to 194 first time borrowers.
2. There were more than $513 million in total loans made to nearly 2,673 homeowners/home buyers.

More Analysis?

• You can make comparisons of Hispanic Loans to all loans at state levels by looking at Table 1 (page 2) in the Picture of GSE Assisted Households CY 2010 PDF file previously posted HERE. 
• For Oregon comparisons, you can compare loan level data down to the Census Tract level using the previously posted GSE Loans Excel Workbook 1 All Oregon GSE Loans loans posted within the folder HERE]. 

Originally created and posted on the Oregon Housing Blog

Success! FHFA Posts Annual GSE SF Data In MS Access Format for the First Time.

Sometimes at HUD and writing this blog it has felt like I "plow the ocean", doing a lot but never quite sure what progress I've made. 

Fortunately, there are a few times when the results of my work are exactly what I hoped they would be.

I am VERY pleased to report that with critical help from Senator Merkley's Senior Advisor Will White, FHFA has agreed to post, for the FIRST time, their annual single family loan level database in MS Access format. 

This is a step that can greatly increase public understanding of who benefits geographically and demographically from GSE single family lending and I think is a proverbial "Win-Win" for all involved. 

(Readers will recall that, with the help of my friend and fellow HUD Oregon Field Office Director retiree Roberta Ando, I was able to put together a MS Access database of GSE CY 2010 loans and a series of related "Picture of GSE Assisted Households, CY 2010 " reports to demonstrate the value of getting GSE SF data into a MS Access format). 

The FHFA CY 2010 GSE MS Access database (4.8+ million records) is already posted on their website HERE (look under "Single Family Census Tract File"). 

FHFA has also committed to posting the GSE CY 2011 database in MS Access format in September of this year.  

Thanks much to Will, Senator Merkley, Roberta, and to FHFA staff for their help and responsiveness in making this important information more transparent to the public. 

Before You Download the MS Database......
My prior caveat that you have a PC capable of dealing with a LARGE database remains.  FHFA has combined both Fannie and Freddie data into a file that expands to 1.6 GB MS Access file when unzipped, so you WILL need a PC with a fast processor and LOTS of memory to work with this file. 

Originally created and posted on the Oregon Housing Blog. 

FHFA Releases State Level HAMP Data and Loan Counts; I Calculate that 18% of GSE Loans in Oregon Were Acquired During CY 2010.

Map can be found HERE, clicking on a state reveals a summary table for that state; Oregon summary is pasted below as an image:

Click to Enlarge

Related Foreclosure Prevention PDF report is HERE. State level data is available in tables on PDF pages 45-53.

Note: FHFA says there were 465,707 GSE loans statewide in Oregon at the end of December 2011; the MS Excel loan GSE Oregon CY 2010 loan level report contained in my prior post HERE indicates that the GSE's purchased 84,289 Oregon loans in just CY 2010; that's a one year production of 18.1% of the total GSE loans outstanding at the end of CY 2011.

Originally created and posted on the Oregon Housing Blog.

Sunshine Week Notes My GSE Posts.

I was pleased to see that the national Sunshine Week web site has noted my GSE posts this week in a Special Reports section of their website:

A New Database on $1 Trillion in Housing Loans
Tom Cusack, the retired director of the HUD field office in Oregon, has published a series of Sunshine Week posts on his Oregon Housing Blog that highlight the geographic and demographic distribution of 4.8 million government sponsored housing loans totaling  $1 trillion purchased by Fannie Mae and Freddie Mac.

My GSE CY 2010 Links (Also in Right Pane)

Picture of GSE Assisted Households CY 2010 (PDF)

GSE CY 2010 Excel Files

GSE CY 2010 Access Databases

To see other Sunshine Week reporting go to their reading room HERE.

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.