The Case-Shiller<\/a> numbers for January 2011 were released today, and the data shows that the nationwide decline in home prices is continuing.\u00a0 Of the 20 metro areas tracked by Case-Shiller, 19 showed a decline in January.\u00a0 I thought it would be interesting to take a closer look at how the Case-Shiller index in each market has performed over time.<\/p>\n In this post, I have plotted the Case-Shiller metro area data from January 2000 through January 2011.\u00a0 I have assigned each metro area to one of five U.S. regions, and I have created a plot for each region.<\/p>\n The top window of each plot shows how \u201cconstant-quality\u201d home prices have varied for each metro area within the region.\u00a0 In addition, the Consumer Price Index (CPI) and the 20-city Case-Shiller composite index are shown in each plot.<\/p>\n In the bottom window, I have adjusted each housing index on each date by the interest rate for a 30-year fixed mortgage on that date using the annuity payment equation.<\/p>\n In other words, this window shows an index of how mortgage payments have varied over time for a new buyer of a \u201cconstant-quality\u201d home.\u00a0\u00a0 The payment indexes have also been rescaled to a starting value of 100.<\/p>\n The purpose of the mortgage-rate-adjusted plots is to give some idea of how home affordability has varied over time.\u00a0 I am not suggesting that payment level is the only thing that matters to the new home buyer, and I am not suggesting that home valuation should vary directly with mortgage rates.\u00a0 However, mortgage rates do play a role in the home purchase decision, and I think it is interesting to look at this transformation of the Case-Shiller data.<\/p>\n The plots below show the Case Shiller data for each U.S. region. <\/strong><\/p>\n <\/strong><\/p>\n <\/strong> The Case-Shiller data shows that, in many markets, housing is as cheaper, in inflation adjusted terms, than it has been at any time in the past decade.\u00a0 In fact, after adjusting for both current mortgage rates and inflation, housing is more affordable in all twenty markets than in was in January of 2000.\u00a0 <\/strong><\/p>\n Data: <\/strong>The Case-Shiller data was downloaded from the S&P website<\/a>, and the CPI and mortgage rate data was downloaded from the FRED website<\/a>.<\/p>\n Code: <\/strong>The R-code for generating the plots is shown below.<\/p>\n Case-Shiller Background The Case-Shiller numbers for January 2011 were released today, and the data shows that the nationwide decline in home prices is continuing.\u00a0 Of the 20 metro areas tracked by Case-Shiller, 19 showed a decline in January.\u00a0 I thought it would be interesting to take a closer look at how the Case-Shiller index in […]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/posts\/2258"}],"collection":[{"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/comments?post=2258"}],"version-history":[{"count":57,"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/posts\/2258\/revisions"}],"predecessor-version":[{"id":4611,"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/posts\/2258\/revisions\/4611"}],"wp:attachment":[{"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/media?parent=2258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/categories?post=2258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.calculatinginvestor.com\/wp-json\/wp\/v2\/tags?post=2258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Explanation of Plots<\/strong><\/h4>\n
![\"](\"https:\/\/www.calculatinginvestor.com\/wp-content\/ql-cache\/quicklatex.com-1f0b8429cf1417768613037c3acd8888_l3.png\" "\\"Rendered")
<\/p>\nRegional Case-Shiller Plots<\/strong><\/h4>\n
![\"\"](\"http:\/\/www.calculatinginvestor.com\/wp-content\/uploads\/2011\/03\/cs_northeast.png\" "\\"cs_northeast\\"")
<\/a><\/strong><\/p>\n![\"\"](\"http:\/\/www.calculatinginvestor.com\/wp-content\/uploads\/2011\/03\/cs_southeast1.png\" "\\"cs_southeast\\"")
<\/a><\/p>\n![\"\"](\"http:\/\/www.calculatinginvestor.com\/wp-content\/uploads\/2011\/03\/cs_midwest.png\" "\\"cs_midwest\\"")
<\/a><\/p>\n![\"\"](\"http:\/\/www.calculatinginvestor.com\/wp-content\/uploads\/2011\/03\/cs_southwest.png\" "\\"cs_southwest\\"")
<\/a><\/p>\n![\"\"](\"http:\/\/www.calculatinginvestor.com\/wp-content\/uploads\/2011\/03\/cs_west.png\" "\\"cs_west\\"")
<\/a><\/p>\nTakeaways<\/strong><\/h4>\n
Additional Info<\/strong><\/h4>\n
\r\n\r\n# Load data from CSV files\r\ncs <- read.table("caseshiller2.csv",header=TRUE,sep=",")\r\nrates <- read.table("mortgagerates.csv",header=TRUE,sep=",")\r\ncpi <- read.table("cpi_data.csv",header=TRUE,sep=",")\r\n\r\n# Convert Mortgage rates to monthly rates\r\nmrates <- rates[,2]\/1200\r\n\r\n# Rescale CPI to a base of 100 in January 2000\r\ncpi <- cpi[1:length(mrates),2]\/cpi[1,2]*100\r\n\r\n# Calculate mortgage payment and rescale to base value of 100\r\na <- mrates + mrates\/((1+mrates)^360-1)\r\npmt <- a*cs[2:23]\/a[1]\r\n\r\n# Create date range for x-axis\r\ndates <- 2000 + (0:132)\/12\r\n\r\n# Plots for Western Cities\r\ndev.new(width=11,height=11)\r\npar(mfrow=c(2,1))\r\nwest <- cbind(cs[3],cs[4],cs[5],cs[6],cs[16],cs[19],cs[21],cs[23],cpi)\r\nmatplot(dates,west,type='l',xlab="",ylab="",lty =c(3,4,5,6,3,2,4,1,1),col=c(3,4,5,6,8,9,4,2,1),lwd=c(2,2,2,2,2,2,2,2,2),ylim=c(60,280),cex.axis=1.3)\r\nlegend(2000,279,c("Los Angeles","San Diego","San Franciso","Denver","Las Vegas","Portland","Seattle","Index Average","CPI"),lty = c(3,4,5,6,3,2,4,1,1),col=c(3,4,5,6,8,9,4,2,1),lwd=c(2,2,2,2,2,2,2,2,2),cex=0.9)\r\ntitle("Case-Shiller Index for Major Western Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\nmwest <- cbind(pmt[2],pmt[3],pmt[4],pmt[5],pmt[15],pmt[18],pmt[20],pmt[22],cpi)\r\nmatplot(dates,mwest,type='l',xlab="",ylab="",lty = c(3,4,5,6,3,2,4,1,1),col=c(3,4,5,6,8,9,4,2,1),lwd=c(2,2,2,2,2,2,2,2,2),ylim=c(50,250),cex.axis=1.3)\r\nlegend(2000,252,c("Los Angeles","San Diego","San Franciso","Denver","Las Vegas","Portland","Seattle","Index Average","CPI"),lty = c(3,4,5,6,3,2,4,1,1),col=c(3,4,5,6,8,9,4,2,1),lwd=c(2,2,2,2,2,2,2,2,2),cex=0.9)\r\ntitle("Mortgage Payment for Major Western Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\n# Plots for Southwestern Cities\r\ndev.new(width=11,height=11)\r\npar(mfrow=c(2,1))\r\nsouthwest <- cbind(cs[2],cs[20],cs[23],cpi)\r\nmatplot(dates,southwest,type='l',xlab="",ylab="",lty = c(3,4,1,1),col=c(3,4,2,1),lwd=c(2,2,2,2),ylim=c(60,280),cex.axis=1.3)\r\nlegend(2000,275,c("Phoenix","Dallas","Index Average","CPI"),lty = c(3,4,1,1),col=c(3,4,2,1),lwd=c(2,2,2,2))\r\ntitle("Case-Shiller Index for Major Southwestern Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\nmsouthwest <- cbind(pmt[1],pmt[19],pmt[22],cpi)\r\nmatplot(dates,msouthwest,type='l',xlab="",ylab="",lty = c(3,4,1,1),col=c(3,4,2,1),lwd=c(2,2,2,2),ylim=c(50,250),cex.axis=1.3)\r\nlegend(2000,250,c("Phoenix","Dallas","Index Average","CPI"),lty = c(3,4,1,1),col=c(3,4,2,1),lwd=c(2,2,2,2))\r\ntitle("Mortgage Pyament for Major Southwestern Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\n# Plots for Midwestern Cities\r\ndev.new(width=11,height=11)\r\npar(mfrow=c(2,1))\r\nmidwest <- cbind(cs[11],cs[13],cs[14],cs[18],cs[23],cpi)\r\nmatplot(dates,midwest,type='l',xlab="",ylab="",lty = c(3,4,5,6,1,1),col=c(3,4,5,6,2,1),lwd=c(2,2,2,2,2,2),ylim=c(60,280),cex.axis=1.3)\r\nlegend(2000,275,c("Chicago","Detroit","Minneapolis","Cleveland","Index Average","CPI"),lty = c(3,4,5,6,1,1),col=c(3,4,5,6,2,1),lwd=c(2,2,2,2,2,2))\r\ntitle("Case-Shiller Index for Major Midwestern Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\nmmidwest <- cbind(pmt[10],pmt[12],pmt[13],pmt[17],pmt[22],cpi)\r\nmatplot(dates,mmidwest,type='l',xlab="",ylab="",lty = c(3,4,5,6,1,1),col=c(3,4,5,6,2,1),lwd=c(2,2,2,2,2,2),ylim=c(50,250),cex.axis=1.3)\r\nlegend(2000,250,c("Chicago","Detroit","Minneapolis","Cleveland","Index Average","CPI"),lty = c(3,4,5,6,1,1),col=c(3,4,5,6,2,1),lwd=c(2,2,2,2,2,2))\r\ntitle("Mortgage Payment for Major Midwestern Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\n# Plots for Southeastern Cities\r\ndev.new(width=11,height=11)\r\npar(mfrow=c(2,1))\r\nsoutheast <- cbind(cs[8],cs[9],cs[10],cs[15],cs[23],cpi)\r\nmatplot(dates,southeast,type='l',xlab="",ylab="",lty = c(3,4,5,6,1,1),col=c(3,4,5,6,2,1),lwd=c(2,2,2,2,2,2),ylim=c(60,280),cex.axis=1.3)\r\nlegend(2000,275,c("Miami","Tampa","Atlanta","Charlotte","Index Average","CPI"),lty = c(3,4,5,6,1,1),col=c(3,4,5,6,2,1),lwd=c(2,2,2,2,2,2))\r\ntitle("Case-Shiller Index for Major Southeastern Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\nmsoutheast <- cbind(pmt[7],pmt[8],pmt[9],pmt[14],pmt[22],cpi)\r\nmatplot(dates,msoutheast,type='l',xlab="",ylab="",lty = c(3,4,5,6,1,1),col=c(3,4,5,6,2,1),lwd=c(2,2,2,2,2,2),ylim=c(50,250),cex.axis=1.3)\r\nlegend(2000,250,c("Miami","Tampa","Atlanta","Charlotte","Index Average","CPI"),lty = c(3,4,5,6,1,1),col=c(3,4,5,6,2,1),lwd=c(2,2,2,2,2,2))\r\ntitle("Mortgage Payment for Major Southeastern Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\n# Plots for Northeastern Cities\r\ndev.new(width=11,height=11)\r\npar(mfrow=c(2,1))\r\nnortheast <- cbind(cs[7],cs[12],cs[17],cs[23],cpi)\r\nmatplot(dates,northeast,type='l',xlab="",ylab="",lty = c(3,4,5,1,1),col=c(3,4,5,2,1),lwd=c(2,2,2,2,2),ylim=c(60,280),cex.axis=1.3)\r\nlegend(2000,275,c("Washington","Boston","New York","Index Average","CPI"),lty = c(3,4,5,1,1),col=c(3,4,5,2,1),lwd=c(2,2,2,2,2))\r\ntitle("Case-Shiller Index for Major Northeastern Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\nmnortheast <- cbind(pmt[6],pmt[11],pmt[16],pmt[22],cpi)\r\nmatplot(dates,mnortheast,type='l',xlab="",ylab="",lty = c(3,4,5,1,1),col=c(3,4,5,2,1),lwd=c(2,2,2,2,2),ylim=c(50,250),cex.axis=1.3)\r\nlegend(2000,250,c("Washington","Boston","New York","Index Average","CPI"),lty = c(3,4,5,1,1),col=c(3,4,5,2,1),lwd=c(2,2,2,2,2))\r\ntitle("Mortgage Payment for Major Northeastern Cities",xlab="Date",ylab="Index Level",cex.main="2.25",cex.lab="1.75")\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"