to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
Calculated Risk posted a thought-provoking chart showing how single family mortgage delinquency rates have largely tracked changes in the U.S. unemployment rate since 2005, which we've excerpted (see above right). From that chart, it would appear that foreclosure activity in the U.S. is pretty closely tracking changes in the unemployment rate.
Whenever we see that kind of apparently close correlation, we go the extra mile and try to map out the relationship that would appear to exist between the two factors. We've presented our chart showing the correlation between the U.S. unemployment rate and the U.S. single-family mortgage 90-day delinquency rate to the left (larger version near the bottom of this post.) What's more, we've also created a tool for projecting the foreclosure rate from the U.S. unemployment rate based on the data as it's behaved since January 2004.
Running the numbers for an unemployment rate of 10%, we find that we might expect the single-family mortgage delinquency rate to increase to a level around 2.7% of all mortgages, based upon the correlation we observe in the data that appears to have existed since 2004.
The problem is that correlation between the U.S. unemployment rate and the percentage of mortgage delinquencies would appear to be something new.
We find that to be the case in an 1998 working paper from the Federal Reserve by Peter J. Elmer and Steven A. Seelig The Rising Long-Term Trend of Single-Family Mortgage Foreclosure Rates. Here, Elmer and Seelig considered the relationship between the unemployment rate and the rate of mortgage foreclosures in the United States from 1950 into 1998.
They found that, contrary to the pattern we observe today and to what people might reasonably expect, that there was no real correlation between changes in the rate of U.S. unemployment and the rate of mortgage foreclosures. The chart to the right graphically presents both rates, along with the 10-year Treasury yield for reference. [Note: We've previously featured a tool that predicts 30-year conventional mortgage rates given the 10-year U.S. Treasury yield.]
We believe the difference between how the relationship between how the rate of delinquencies and the rate of unemployment from the 1950s into the 1990s and from the 1990s to today may be attributed to changes in the mortgages themselves beginning in the 1990s. Primarily, what changed were the lending standards.
Throughout much of the late twentieth century, mortgage lenders required homebuyers to invest significant equity in their properties, requiring substantial down payments at the time of purchase. Often representing 20% of the market value of the homes being bought, this equity stake helped insulate the mortgage lenders from the employment status of the homebuyers.
Likewise, the homebuyers were in part insulated from having their home foreclosed upon during such periods of unemployment thanks to this margin of safety. They could draw upon their home equity, either through taking out home equity loans or by selling their homes, to avoid the fiscal calamity of foreclosure.
But, beginning in the 1990s, the systematic erosion of such lending standards also led to the elimination of this safety margin. As a result, the margin of safety for significant numbers of mortgages shrank, exposing both lender and borrower to an increased risk of foreclosure in the event the borrower became unemployed.
That's exactly what we're seeing play out today.
But we believe that will end, given that we see that the rate of mortgage delinquencies appears to already be slowing, even as the unemployment rate increases.
Running the numbers for higher levels of unemployment suggests that as the unemployment rate increases, the percentage of mortgage delinquencies will peak around 2.8%. Intuitively, we believe that makes sense since we would expect that as the substantial already number of foreclosed properties are sold to new buyers who are being held to higher lending standards, the loans represented by these properties will move from the numerator to the denominator in the calculation of the delinquency rate.
Consequently, we would anticipate that the apparent correlation we are currently observing between the U.S. unemployment rate and the delinquency rate of single-family mortgages will break down, even if unemployment rates continue to rise.
We obtained the monthly unemployment rate data for the U.S. from the BLS' Current Population Survey database. Meanwhile, we obtained the corresponding monthly single-family 90-day delinquency rate for all mortgages spanning January 2004 through May 2009 from the following Freddie Mac reports for the indicated years:
Labels: economics, real estate, tool
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.