Negotiation, Negotiation, Negotiation

UK Property Investment news and comments from Mark Harrison of

Housing affordability index – Update to the end of Q1, 2007

Posted by markharrison on June 6, 2007


Yup, in another shock move, I’ve actually updated this in three consecutive quarters – crikey.

For those of you unfamiliar with the index, this is a composite that tracks average UK house prices, average UK incomes, and interest rates. Basically, it measures the ability of the average person to pay the INTEREST the mortgage on an average house.

If you just want the headline summary – things are about the level they were in 1985-1988 (they wobbled a bit about this level for about 4 years.) I fear that the upward trend is going to continue (up is unaffordable) since base rates have gone up in this quarter.

If you want to have a look at the index, look here. (This link will take you to the downloads section, so you’ll always see the most recent version. Links on previous blog posts have gone to a particular revision, which therefore stop working whenever I update them 😦 )

The house price data comes from the “Communities and Local Government” website (formerly known as the Office of Deputy Prime Minister.) It is “mix-adjusted”, which means that if one month a lot of big houses sell, and the next month a lot of small houses sell, the statistics take this into account and it doesn’t look like prices have gone because smaller houses sold better than bigger ones this month. (This is, as I understand it, particularly an issue in London where a lot of expensive house sales follow the city bonus cycle.)

The average incomes are from the Office of National Statistics. They are “seasonally adjusted”, but as good a source as any (and better than most.) The slightly annoying thing is that the ONS have changed their website around a lot since 2004, and thus I couldn’t find the older figures. Hence I used the ones from 2004 – which introduced a small error, since I only had the figures on a PDF, and has lost the spreadsheet, it means that figures prior to 1990 are only correct to two decimal places.) The ONS figures are slightly annoying in that they “retrospectively change” figures previously published – hence this version has a different figure for Q4 2006 compared to the same graph in February!

The interest rates are from the Bank of England website. I’ve picked the “quarter close” figures which, again, is a methodology I picked before I ran the graphs. In some years, there was no change, in others there were many wild changes throughout the year, and there is an argument that I should have picked an “average for quarter”. I don’t believe that the different would have been material though.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: