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. 

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. 

Lake Oswego WOW: Nearly 1 in 6 Owner Occupants with a Mortgage Got a Government Assisted Home Loan in Just ONE Year; Loan Total Was $395 Million.

With my recent work on the need for government assisted RENTAL housing in Lake Oswego, including Foothills redevelopment, I thought this would be a good time to go back and see how many government assisted HOME LOANS have been provided to Lake Oswego home owners in the recent past. 

The $$ and household estimates here do NOT include home ownership related tax expenditures like home mortgage and property tax deductions or home buyer tax credits, etc, but ONLY the ONE YEAR amount of single family loans from FHA, Fannie Mae and Freddie Mac.  (My estimate also doesn't include VA home loans).

As the table pasted below shows I estimate that in CY 2010 1,400+ Lake Oswego families received nearly $395 million in loans insured or purchased by government agencies: FHA, Fannie Mae, and Freddie Mac. (My estimate is conservative as the GSE loan total ONLY includes 6 of 12 census tracts  that I count that are fully or partially located in Lake Oswego and recall that I also did NOT include VA loans):

Further Analysis Possible With Excel Workbook

You can do you own analysis by looking at the GSE FHA CY 2010 Lake Oswego workbook I have posted HERE. It includes the table above; all the loan level GSE and FHA data available; and a worksheet that shows a listing of Lake Oswego census tracts that I used and and clipped pictures of Census Tract map boundary maps.  

I recommend that you look at the READ ME worksheet when you open this workbook.

 

WOW: Nearly One in Six Lake Oswego Owner Occupied Home Owners With a Mortgage Got a Government Assisted Home Loan in Just ONE Year, CY 2010. 

The most recent 3 Year ACS estimate (Table B25081] is that there were 8,278 Lake Oswego owner occupied households with a mortgage. Using the Excel workbook "occupancy code " data field in the GSE data worksheet to filter out 77 LO GSE investor/ non owner occupant loans leaves 1,228 owner occupied GSE loans during CY 2010. 

Adding in the 122 FHA owner occupied loans means there were 1,350 owner occupied government assisted home loans in Lake Oswego during CY 2010. 

Dividing that by the 8,278 Lake Oswego owner occupied households with mortgage means that 16.3% of all LO families (nearly one in six) with a mortgage got a government assisted loan in just ONE year, CY 2010. [Note that my count of government assisted loans also does NOT include VA loans).

Excel Downloading Tip-This workbook was created in Excel 2007/2010 format. Some users report they cannot direct view Excel files in this format from within their browser and/or that Excel files they save 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 an Excel 2007/2010 extension (.xlsx), and THEN open the file with Excel 2007/2010.
 

Originally created and posted on the Oregon Housing Blog.

Fannie and Freddie Present Evidence to Regulator that Foreclosure Related Principal Reductions Work.

ProPublica story is HERE.

New analyses by mortgage giants Freddie Mac and Fannie Mae have added an explosive new dimension to one of the most politically charged debates about the housing crisis: Whether to reduce the amount of money beleaguered homeowners owe on their mortgages.

Their conclusion: Such loan forgiveness wouldn’t just help keep hundreds of thousands of families in their homes, it would also save Freddie and Fannie money. That, in turn, would help taxpayers, who bailed out the companies at a cost of more than $150 billion and are still on the hook for future losses.

The analyses, which have not been made public, were recently presented to the agency that controls the companies, the Federal Housing Finance Agency, according to two people familiar with the matter.

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.

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.

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.

1st Data Tables Created Using New GSE CY 2010 Database: State Distribution of $1 TRILLION in GSE Single Family Loan Acquisitions.

I am pleased to note that with the significant assistance from my friend Roberta Ando (also a retired HUD Oregon Field Office Director) I have been able to create the first national MS Access databases for ALL single family loans purchased by Fannie Mae and Freddie Mac during CY 2010, down to the census tract level. 

These databases form a new home owner/buyer focused" Picture of GSE Assisted Households" very similar to the periodic HUD Picture of Subsidized Households database and can be updated annually (more about that below).

Each of the 4.8 million loan level records in the databases contain 39 fields of data, so there are more than 187 million pieces of data in these two databases.(The original data came from FHFA in text files and required many, many tweaks and lots of computing power to get it into useable MS Access formats).
 

Unlike HMDA Data, These New GSE SF Databases Cover the Entire Country, NOT Just Metro Areas
 
Unlike HMDA data, these newly created databases cover the entire country and NOT just metropolitan areas; they also include a first time home buyer field not found in HMDA. A complete list of data elements in the database can be found HERE.

Future Plans


I will be releasing additional analysis of the GSE 2010 data in the coming days and weeks and am shopping for a national home to make these large Fannie and Freddie MS Access databases available for download and analysis by others. 

Because the GSE data is now in MS Access format, users can filter records and export files to MS Excel for further analysis or use database tools in Excel to directly query the MS Access databases. 


Maps Possible Too
Some users may also choose to convert the data tables they create into maps to help illustrate the geographic location of GSE loan purchases; for example, a map by state, metro area, county, or census tract of all GSE Hispanic first time home buyer loan counts and dollars.

Updating Annually Possible IF FHFA Cooperates
I will also be following up to encourage greater transparency from FHFA to make this annual public database available in MS Access formats so that the public can actually see who is benefiting from these loans [FHFA currently releases data in text form ONLY]. 

While I am pleased that Roberta and I have been able to put together these databases this year, there is no reason why FHFA should not be expected to post these databases in MS Access format annually.


All PDF tables I create from these databases will be available in a link in the right pane, Picture of GSE Assisted Households, CY 2010.

Today's First Analysis: 
State Distribution by Loan Counts and Shares of $1 Trillion in Loan Acquisitions for 4.8 Million Households

The two tables in the Picture of GSE Assisted Households, CY 2010 PDF file HERE show:

• Table 1: An alpha listing by state for Fannie, Freddie and both GSE's showing both loan counts and loan $$ [unpaid principal amount of the loans at the time they were purchased by the GSE's].
• Table 2: A sorted state listing of the highest to lowest shares/%'s of the total national loan counts.

Two Observations From Tables 1 and 2:

• Five States (California, Illinois,Texas, New York, Florida) Accounted for 40% of CY 2010 GSE Loan $$ and 34% of all GSE SF Loans; 
• Oregon Had $17 Billion in GSE Loans to 84,000 Families, 1.7% of the national GSE Loan $$
  

 Originally created and posted on the Oregon Housing Blog.

Fannie, Freddie, AND FHA Fees Going Up Jan 1st to Pay for 2 Month Payroll Tax Holiday.

Is this HERE really any way to run a railroad/help to improve housing markets?

Originally created and posted on the Oregon Housing Blog.

New HARP Refinance Guidance Out for Fannie/Freddie.

Links to NEW lender guidance from Fannie and Freddie are posted on FHFA refinance web page HERE.

Originally created and posted on the Oregon Housing Blog.

FHA Getting Mortgage Increase but Not Fannie/Freddie?

Put in the stay tuned folder, but that's what Reuters story HERE says.

HUD FY 2012 Appropriations bill with relevant language is up for consideration by full House and Senate this week, so it won't be long before this is decided.  [Health of FHA fund (see immediate prior post) will enter into this debate]. 

Originally created and posted on the Oregon Housing Blog.

Making Home Affordable Home Owner/HAMP Event Coming to Portland Dec 3rd, After Scheduled Start Date for New Fannie/Freddie Refinance Program.

From HAMP national website, found bilingual flyer for this Saturday Convention Center event HERE.  

Treasury, HUD, Neighborworks and HOPENOW logos are included on the flyer. 

First Oregon Session Where New Refinancing Guidelines May be In Effect for Fannie/Freddie Loans

Refinancing guidelines for the new HARP program for Fannie and Freddie loans are expected to be released Nov 15, with lenders expected to accept applications in December. This event is likely the FIRST where home owners can interact with lenders to discuss  eligibility for this new refinancing program. (FHFA website for new HARP program is HERE).

Originally created and posted on the Oregon Housing Blog.

Updated: Major Revisions to Fannie/Freddie Mortgage Refinance Program Coming.

FHFA press release has now been posted HERE, includes Fact Sheet and Q and A. 
----------------
In time for President's visit to Las Vegas changes that would expand refinancing options are expected according to WSJ story HERE and Bloomberg story HERE.  WSJ story says program aimed at loans owned by Fannie and Freddie AND 

• Open to those owing more than 125% of their home's value
• Appraisal and underwriting requirements to be reduced
• Loan fees will drop; waived for borrowers who reduce their loan term
• Borrowers must be current on previous six payments

Second WSJ piece HERE also answers some questions/answers about the planned program.

Originally created and posted on the Oregon Housing Blog.

One Quarter Fannie Mae Cost for Owning/Selling 153,000 Home Inventory: $488 Million.

NPR story is HERE; audio is HERE. 

SEC filing with data is HERE. (NPR story says $488 million in foreclosure losses, I don't see that figure in SEC data link in story but did find it in larger SEC filing link HERE. ).

Originally created and posted on the Oregon Housing Blog.

Fannie Mae Own-Rent Analysis Released, Covering Four Themes.

Fannie Mae has released their latest Own-Rent analysis for themes 3 and 4 HERE. 

Earlier Fannie had released their analysis for themes 1 and 2 HERE. 

A summary of Fannie Mae analysis is HERE.

The 4 themes Fannie Mae examined were:

1. Persistence of the Homeownership Aspiration and Housing Choices Throughout the Lifecycle,
2. The Impact of Changing Demographics.
3. Economics of Owning and Renting Through the Cycle and Across Geographies.
4. Renting and Owning Behaviors by Race, Ethnicity, and Immigration Status.

Originally created and posted on the Oregon Housing Blog.