The Re-Release of the Open Source Mortgage Default Model

By: Reggie Middleton | Wed, May 20, 2009
Print Email

I have received some feedback on the open source mortgage default model and data, and consequently took it offline due to the possibility that there may have been a material error (see The Truth About the Banks Has Been Released: the open source spreadhseet edition for the background). I have had it reviewed and reviewed it myself several times in light of the external inputs and am now putting a revised version back online for all to download, modify and or distribute. To give a quick background on what was going on, I received a notice of potential errors from a reader, along with suggestions on how he felt the model could be improved. I checked the SCAP Loss Assumptions file that he sent and although there is a difference of approach followed by us and the reader regarding estimation of loan loss rates, we have found both the methods acceptable. The key difference is that the methodology (as explained below) followed by the contributor requires certain (additional) assumptions to be made while we wanted to refrain from making additional assumptions to remove any subjective biases and base our analysis using Fed's data to the maximum extent possible. For those that do not wish to read through this lengthy history, let it be known that the end result of the reader's input, and to a lesser extent our slightly tweaked methodology both resulted in a HIGHER loss rates for mortgages (and consequently, the banks), not a lower one. So, if the original open source model was to be considered inaccurate, it would be leaning towards the optimistic side, which further drives home my point and thesis concerning the government's bogus stress tests and the current and future state of many US banks (see Welcome to the Big Bank Bamboozle! for the detailed story). Banks and asset managers have rallied enormously again, causing me to recheck my thesis and research, and yet still, I find absolutely no indication of my viewpoint being in error. This situation is similar to the era where many fundamental types tried to short the internet companies, and many got blown out of the water before the industry and the entire market collapsed. Past is not prologue, but I have been in this minimum vaue view of what I consider overvalued assets and markets when I sold off my real estate in 2006. Patience is hard to come by when you are facing against the wind, but I am not comfortable going against both the math and common sense.

One potential source of the perception of error was the inclusion of Alt-A ARMs resetting after 24 months (the 24+ month column in the Alt-A tab) in the cumulative loan loss rate section for 2 years. We feel that the exclusion of Alt-A ARM resetting after 24 months would underestimate loan losses during the actual 24 month period due to a variety of reasons, the least of which are the facts that once a certain LTV level is breached you will have early loan recasts (see The banking backdrop for 2009 where I warned of this at the beginning of the year) and the fact that there will be some defaults before an initial reset is achieved.

Those who just want to dowload the model click here (Revised SCAP Assumptions Public Open Source Version 1.1 2009-05-18 15:15:47 1.21 Mb), otherwise read on to how I got to the second slight revision of the model.

Although reset date is an important aspect to predict default rates for Alt-A ARMs there are additional factors including current LTV, borrowers paying capacity, % change in property prices, unemployment rates etc that are important determinants to predict default rates for Alt A loans. Hence altogether excluding Alt-A ARM resetting after 24 months would underestimate default assumptions.

I have have highlighted the key difference in the methodology between the approaches below.

Our methodology:

We had computed total Alt A ARM loans to be reset (including loans to be reset after 24 months) and calculated default rates on Alt A loans to be reset based on default rate assumptions considering FICO scores and LTV. We had applied an overall weighted average default rate of 80% for all loans on high risk Alt A loans to be reset.

We have made 3 changes to the document to further refine default assumptions but attempt to avoid the injection of subjective bias into the raw government data, where possible.

We have further bifurcated the loans into owner occupied and non-owner occupied, since the investor and absentee owner loans have a very high propensity to default when under water, particular in comparison to loans where the owner actually lives in the property. Below are our assumptions for default rates for each category (linked dynamically in the respective sheets). Be aware that I have left the model open, so any and all can feel free to input their own assumptions.

Based on the above assumptions, the weighted average default rate for Alt-A Arm loans is now at 25.33% (21.4%% previously) while weighted average default rate for Sup prime Arm loans is now at 39.19% (41.4% previously).

The overall loss rate has been computed as default date * (1-recovery rate). Recovery rate has been computed taking into consideration LTV at origination, % change in hosing price and historical recovery rates.

High Risk Alt-A ARM Loans
(Low FICO and high LTV)
Low Risk Alt-A ARM Loans
(High FICO and Low LTV)
Avg Risk Alt-A ARM Loans
(High FICO and High LTV / Low
FICO and Low LTV)
Owner Occupied Non-Owner Occupied Owner Occupied Non-Owner Occupied Owner Occupied Non-Owner Occupied
50% 90% 15% 30% 25% 50%
High Risk Subprime ARM Loans
(Low FICO and high LTV)
Low Risk Subprime ARM Loans
(High FICO and Low LTV)
Avg Risk
(High FICO and High LTV / Low
FICO and Low LTV)
Owner Occupied Non-Owner Occupied Owner Occupied Non-Owner Occupied Owner Occupied Non-Owner Occupied
65% 95% 20% 35% 35% 60%

The contributing reader's methodology:

The contributor had bifurcated total loans (including loans to be reset after 24 months and loans already reset) into owner occupied ALT-A, non-owner occupied ALT-A, owner occupied ALT-A ARM and non-owner occupied ALT-A ARM. These loans are classified into high risk loans based on reset schedule as per the table below, eg All loans resetting within next 12 months are classified as risky loans.

Pls note : We had classified loans into high risk loans based on LTV and FICO scores and not based on reset schedule which would require subjective assumptions (or alternatively, a more granular and very recent historical data set which we currently do not have access to.

High risk loans in relation to Resetting
Already reset 20%
within 12 mo 100%
in 12-24 mo 50%
24+ mo 15%

After classifying loans into owner occupied/ non- owner occupied and risky / non-risky loans these default rates are computed based on following assumptions.

Default rates
Owner Occupied ALT-A 15%
Non-Owner Occupied ALT-A 30%
Owner Occupied ARM 20%
Non-Owner Occupied ARM 40%
Owner Occupied ARM High Risk 50%
Non-Owner Occupied ARM High Risk 70%

Pls note : We had initially assumed single default rate for owner occupied and non-owner occupied

We appreciate that the reader's methodology could potentially improve the estimation of default rates for Alt-A ARM loan losses by bifurcating Alt A ARM loans into sub category, but we also consider the potential of injecting subjective bias an unnecessary weakness given the breadth of the NY Fed's and the FDIC's data set. We have, however added inputs to differentiate between investor loans and owner occupied loans as stated above.

Overall the different methodology no not provide significant variation in Alt A loans with our Total Alt A loss rate of 20.4%(computed based on Fed's data for delinquent loans, Foreclosure and REO) versus 19.1 % loss rate for Alt A non-ARM by the contributing reader (computed based on assumptions above).

Our default rates for Alt A ARM loans is at 25.33% (up from 21.4% in the original model) versus 32.6% by the contributing reader. The difference is not due to different methodology but due to slightly higher default rate used by the contributing reader (Alt A non-ARM).



Reggie Middleton

Author: Reggie Middleton

Reggie Middleton

Reggie Middleton

Who am I?

Well, I fancy myself the personification of the free thinking maverick, the ultimate non-conformist as it applies to investment and analysis. I am definitively outside the box - not your typical or stereotypical Wall Street investor. I work out of my home, not a Manhattan office. I build my own technology and perform my own research - in lieu of buying it or following the crowd. I create and follow my own macro strategies and am by definition, a contrarian to the nth degree.

Since I use my research as a tool for my own investing to actually put food on my table, I can stand behind it as doing what it is supposed too - educate, illustrate and elucidate. I do not sell advice, I am not a reporter hence do not sell stories, and I do not sell research. I am an entrepreneur who exists just outside of mainstream corporate America and Wall Street. This allows me freedom to do things that many can not. For instance, I pride myself on developing some of the highest quality research available, regardless of price. No conflicts of interest, no corporate politics, no special favors. Just the hard truth as I have found it - and believe me, my team and I do find it! I welcome any and all to peruse my blog, use my custom hacked collaborative social tools, read the articles, download the files, and make a critical comparison of the opinion referencing the situation at hand and the time stamp on the blog post to the reality both at the time of the post and the present. Hopefully, you will be as impressed with the Boom Bust as I am and our constituency.

I pay for significant information and data, and am well aware of the value of quality research. I find most currently available research lacking, in both quality and quantity. The reason why I had to create my own research staff was due to my dissatisfaction with what was currently available - to both individuals and institutions.

So here I am, creating my own research for my own investment activity. What really sets my actions apart is that I offer much of what I produce to the public without charge - free to distribute and redistribute, as long as it is left unaltered and full attribution is given to the author and owner. Why would I do such a thing when others easily charge 5 and 6 digits annually for what some may consider a lesser product? It is akin to open source analysis! My ideas and implementations are actually improved and fine tuned when bounced off of the collective intellect of the many, in lieu of that of the few - no matter how smart those few may believe themselves to be.

Very recently, I have started charging for the forensics portion of my work, which has freed up the resources to develop the site to deliver even more research for free, particularly on the global macro and opinion front. This move has allowed me to serve an more diverse constituency, which now includes the institutional consumer (ie., investment turned consumer banks, hedge funds, pensions, etc,) as well as the newbie individual investor who is just getting started - basically the two polar opposites of the investing spectrum. I am proud to announce major banks as paying clients, and brand new investors who take my book recommendations and opinions on true wealth and success to heart.

So, this is how I use my background and knowledge in new media, distributed computing, risk management, insurance, financial engineering, real estate, corporate valuation and financial analysis to pursue, analyze and capitalize on global macroeconomic opportunities. I have included a more in depth bio at the bottom of the page for those who really, really need to know more about me.

Copyright © 2007-2017 Reggie Middleton

All Images, XHTML Renderings, and Source Code Copyright ©