Every year in May I like to spend a few hours of my life that I’ll never get back preparing a house Valuation metric that goes beyond that generally presented by the mainstream media by getting more granular and trying to Value housing at County level. This should then for example help us to understand if there really is a north south divide when it comes to housing. Last year’s efforts can be seen here.
My definition of Value is simply how many years of gross earnings (median and average) are required to buy an average house. This is a simple average Price to Earnings Ratio (P/E) and is not unlike how some might value a company share. Importantly I am not interested in Affordability which is one’s ability to service debt at current interest rates and is what I think actually drives the UK housing market. This is because I believe that the average punter doesn’t ask is this house good Value but instead asks how much can I borrow and then spends to that limit.
For House Prices I am using average house prices as published by the Land Registry. This is calculated by using:
The Valuation analysis is arranged according to the Regions and County’s defined by the Land Registry and is shown in the Table below. Unlike the mainstream media I am calling high house prices bad (unsurprisingly the County with the highest house price is London at £462,799 and is shown in dark red) and low house prices good (the County with the lowest house price is Middlesbrough at £62,546 and is dark green) with all other prices shaded between red and green depending on house price.
For Earnings I am using the 2014 Annual Survey of Hours and Earnings (ASHE) which provides information about the levels, distribution and make-up of earnings and hours paid for employees within industries, occupations and regions in the UK. To ensure that our Earners and Homes are located within the same County I’m using the Earnings by Place of Residence by Local Authority. This dataset presents weekly Earnings at both median (the middle point from each distribution) and mean (the average) levels which we have arranged into each Land Registry Region and County in the Table below. I then multiply the data by 52 weeks to convert it to an annual salary. I am calling low earnings bad (the lowest average earnings are £17,638 in Blackpool and are dark red) and high earnings good (the highest average earnings are £36,982 in Windsor and Maidenhead and are dark green) with all other earnings shaded between red and green depending on earnings.
My definition of Value is simply how many years of gross earnings (median and average) are required to buy an average house. This is a simple average Price to Earnings Ratio (P/E) and is not unlike how some might value a company share. Importantly I am not interested in Affordability which is one’s ability to service debt at current interest rates and is what I think actually drives the UK housing market. This is because I believe that the average punter doesn’t ask is this house good Value but instead asks how much can I borrow and then spends to that limit.
For House Prices I am using average house prices as published by the Land Registry. This is calculated by using:
- The Land Registry House Price Index (HPI) dataset. This index uses repeat sales regression (RSR) on houses which have been sold more than once to calculate an increase or decrease. As it analyses each house and compares the latest buying price to the previous buying price it is by definition mix adjusting its data also. It uses all residential property transactions made in England and Wales since January 1995 so covers buyers using both cash and mortgages.
- Average prices are then calculated by taking Geometric Mean Prices (as opposed to an arithmetic mean), to reduce the influence of individual values, from April 2000 and adjusting these prices in accordance with the Index changes. They are seasonally adjusted. I am using the latest published data which comes from March 2015.
The Valuation analysis is arranged according to the Regions and County’s defined by the Land Registry and is shown in the Table below. Unlike the mainstream media I am calling high house prices bad (unsurprisingly the County with the highest house price is London at £462,799 and is shown in dark red) and low house prices good (the County with the lowest house price is Middlesbrough at £62,546 and is dark green) with all other prices shaded between red and green depending on house price.
For Earnings I am using the 2014 Annual Survey of Hours and Earnings (ASHE) which provides information about the levels, distribution and make-up of earnings and hours paid for employees within industries, occupations and regions in the UK. To ensure that our Earners and Homes are located within the same County I’m using the Earnings by Place of Residence by Local Authority. This dataset presents weekly Earnings at both median (the middle point from each distribution) and mean (the average) levels which we have arranged into each Land Registry Region and County in the Table below. I then multiply the data by 52 weeks to convert it to an annual salary. I am calling low earnings bad (the lowest average earnings are £17,638 in Blackpool and are dark red) and high earnings good (the highest average earnings are £36,982 in Windsor and Maidenhead and are dark green) with all other earnings shaded between red and green depending on earnings.