Fannie Mae Single-Family Loan Performance Data

Fannie Mae Updates its Single-Family Historical Loan Performance Dataset

On October 16, 2018, Fannie Mae updated its Single-Family Loan Performance credit dataset to include:

Primary dataset:

  • Acquisition data for Q3 2017 and performance data through Q2 2018.
  • Updated acquisitions files to reflect any data corrections.

HARP dataset:

  • Performance data through Q2 2018.

Please read our FAQs for additional details around the Primary and HARP datasets.

To capture all updates, users have the option of downloading each acquisition and performance file in the dataset or downloading both the entire Single-Family Loan Acquisition data file and the entire Performance data file with just one click.

We provide this data, along with our unique analytical tool, Data Dynamics®, to help investors model the credit performance of loans owned or guaranteed by Fannie Mae as we work to further develop our credit risk sharing programs.  Visit our webpages to learn more about our programs and our industry-leading approach to credit risk management.

Credit Performance Analysis Webinars

As an accompaniment to this latest release, Fannie Mae has prepared two webinars to review the new data elements and to show participants how we compile the data files to produce the related Statistical Summaries.

Please contact the Fannie Mae Investor Help Line at 1-800-2FANNIE or by e-mail with any questions.

News

Fannie Mae Expands its Single-Family Historical Loan Performance Dataset to include loans with terms less than 30 yearsSeptember 22, 2017

Fannie Mae Enhances its Single-Family Historical Loan Performance Dataset to include HARP Mortgage LoansAugust 17, 2017

Fannie Mae Adds New Download Capability to Single-Family Loan Performance DatasetJune 2, 2017

Read All News »


Overview

Fannie Mae provides loan performance data on a portion of its single-family mortgage loans to promote better understanding of the credit performance of Fannie Mae mortgage loans. The population includes two datasets. These two datasets should be combined via a mapping file that we have provided in order to assist market participants in understanding how original loans that subsequently refinanced through the Home Affordable Refinance Program® (HARP®) performed subsequent to their refinance.

The Single Family Fixed Rate Mortgage (primary) dataset contains a subset of Fannie Mae’s 30-year and less, fully amortizing, full documentation, single-family, conventional fixed-rate mortgages. This dataset does not include data on adjustable-rate mortgage loans, balloon mortgage loans, interest-only mortgage loans, mortgage loans with prepayment penalties, government-insured mortgage loans, Home Affordable Refinance Program (HARP) mortgage loans, Refi Plus mortgage loans, or non-standard mortgage loans. Certain types of mortgage loans (e.g., mortgage loans with LTVs greater than 97 percent, Alt-A, other mortgage loans with reduced documentation and/or streamlined processing, and programs or variances that are ineligible today) have been excluded in order to make the dataset more reflective of current underwriting guidelines. Also excluded are mortgage loans originated prior to 1999, mortgage loans subject to long-term standby commitments, sold with lender recourse or subject to certain other third-party risk-sharing arrangements, or that were acquired by Fannie Mae on a negotiated bulk basis.

The initial population of mortgage loans in the primary dataset included Fannie Mae acquisitions between January 1, 2000 and March 31, 2012 with corresponding monthly performance data as of December 31, 2012. Every quarter following the initial release, Fannie Mae updates the acquisition data to include a new quarter of acquired mortgage loans as of the prior year in addition to providing updated performance data as of the previous quarter. Fannie Mae releases updated information on or after the 20th of the month following the end of the quarter.

The HARP dataset contains approximately one million 30-year fixed rate mortgage loans that are in the primary dataset that were acquired by Fannie Mae from January 1, 2000 through September 30, 2015 and then subsequently refinanced into a fixed rate mortgage loan through HARP from April 1, 2009 through September 30, 2016. While the population of HARP loans is expected to grow slightly prior to the anticipated final expiration of the HARP program, we do not currently anticipate adding new HARP loan acquisitions to this dataset. We expect to update the monthly performance data for the HARP dataset on a quarterly basis in conjunction with our normal quarterly updates of the primary historical dataset. The HARP dataset also includes a mapping key to assist users in aligning the loan ID in the primary dataset with the corresponding loan ID in the HARP dataset after the loan was refinanced.


Data Access

The loan performance data is available here. Fannie Mae requires the user to register and create a unique username and password in order to access the performance data. An email will be sent to the user to confirm registration. The user is also required to accept the Terms and Conditions, which, among other things, prohibits the user from distributing data to third parties or using it in support of external commercial purposes without the express written consent of Fannie Mae. For more information regarding external commercial use or redistribution of this data, please contact Fannie Mae's Fixed-Income Marketing at 800-2FANNIE (800-232-6643) or by email.

Due to the size of the data files, we do not recommend loading the data into Microsoft Office Excel. One should consider using a recognized third-party database management system to load and access the data as basic spreadsheet applications may result in the loss or incomplete capture of the file. Sample acquisition and performance data files are available to assist users with database setup and R and SAS code are available for both the primary dataset and the HARP dataset to assist users with the download.

For user convenience, we provide an option which allows users to download all acquisition files and all performance files with one-click each. In addition, a Download History section on the website provides a list of the files the user has previously requested for download. If a user chooses to download each acquisition and performance file in the dataset individually, the file download is capped at 100 files per hour. Download speeds may vary depending on demand.

The loan performance data for the primary dataset is divided into two text files for each acquisition quarter. The “Acquisition” file includes static data at the time of a mortgage loan’s origination and delivery to Fannie Mae. The “Performance” file contains the monthly performance data of each mortgage loan from the time of Fannie Mae’s acquisition up until its current status as of the previous quarter, until the mortgage loan has been liquidated (e.g., paid-off, repurchased, short sale, etc.), or in the event of a real estate owned (REO) property, until after expenses and proceeds are collected upon disposal of the property. Certain data attributes also will be updated to reflect new terms, if applicable, as a result of a modification. The HARP dataset is organized in a similar manner, but also includes the mapping key to assist users in aligning the loan ID in the primary dataset with the corresponding loan ID in the HARP dataset after the loan was refinanced. Complete definitions of the data elements are in the glossary  .

During quarterly updates, Fannie Mae will refresh the acquisition data in the primary dataset to reflect any data corrections resulting from ongoing quality assurance efforts. Corrections could result in the addition or removal of mortgage loans from the original population. In addition, performance data will also reflect changes if servicing corrections have been made in the previous quarter.

Fannie Mae relies on its sellers and servicers to provide complete and accurate data. In cases where the data is unavailable, Fannie Mae will leave that value blank.

Fannie Mae cannot guarantee the data is complete or error-free. The data is provided for your general information only, is current only as of its specified date and does not constitute an offer to sell or a solicitation of an offer to buy securities. All information relating to Fannie Mae securities is qualified in its entirety by the relevant prospectus and any related supplements. Investors should review the relevant prospectus and any related supplements before making a decision with respect to the purchase or sale of any security. In addition, before purchasing any security, please consult your legal and financial advisors for information about and analysis of the security, its risks and its suitability as an investment in your particular circumstances.

Page last revised: 09/22/17