Tag Archives: charts

Australian Property Prices

Property prices have always been a popular topic of conversation in Sydney, but the subject has become more contentious since the onslaught of the Global Financial Crisis. Views on prospects for Australian property prices range from the bleakly pessimistic to the wildly optimistic. Iconoclastic economist Dr Steve Keen is one of the more prominent pessimists and expects a fall in property prices of as much as 40%. At the other extreme, research firm BIS Shrapnel recently released forecasts that prices in capital cities will rise by almost 20% over the next three years. Of course, both sides have their critics. Macquarie Bank economist Rory Robertson is so convinced that Keen is wrong that he has offered a wager in which the loser will have to walk to the top of Mount Kosciusko wearing a t-shirt saying “I was hopelessly wrong on home prices! Ask me how”. Meanwhile, many dismiss the optimists as mere shills intent on talking up the market in the interests of their clients.

Faced with a debate like this, the only recourse for the Stubborn Mule is to look at the data. Fortunately, I have been able to get my hands on a rich set of data (and ideas) from University of New South Wales economist Dr Nigel Stapledon*. Stapledon has painstakingly assembled data on Australian property prices back to the 1880s and rental data back to the 1960s. This data underpins a detailed comparison of the Australian and US property markets in Stapledon’s forthcoming paper  “Housing and the Global Financial Crisis: US versus Australia” in The Economic and Labour Relations Review, Sydney. By comparison, the House Price Indexes published by Australian Bureau of Statistics (ABS) commence in 1989.

A first glance at Stapledon’s index of Sydney property prices does indeed appear to show a meteoric trajectory that would inflame the passions of the pessimists.

Sydney House Price Index

Sydney House Price Index

Of course, asset prices tend to exhibit exponential growth, so it is far better to look at historical prices on a logarithmic scale. This reveals a striking trend. The growth of Sydney property prices has been remarkably consistent at around 9% per annum over the last 50 years.

Sydney House Price Index (log scale)

Sydney Property Prices (log scale)

Prices for Australia overall show a similar trend, with average prices over the six major capital cities growing at an average of 8.6% per annum since 1955.

Six Capital Cities

Australian Property Prices

What these charts do not take into account is the effect of inflation. Indeed, inflation varied significantly over the last 50 years, so adjusting for the effect of inflation shows that the trend in Sydney house prices has not been so stable. Booms such as those from 1987-1989 and 1997-2003 are made very clear in the chart below. But it is also evident that  prices have failed to keep up with inflation over the last few years. Nevertheless, over the last 50 years, Sydney house prices have appreciated an average of 3.1% over inflation and that is before taking rental income into account.

Sydney House Price Index (inflation adjusted)

Sydney Prices (inflation adjusted)

One difficulty with long-run property price data is that fact that observations are typically based on median house prices, which does not take into account changes in the quality of houses. The median house in 2009 may be “better” than the median house in 1955 and changes in price may reflect this change in quality as well as price appreciation. Stapledon has attempted to take this into account by constructing an index for Australian house prices (six capital cities) that is adjusted for both inflation and standardised to “constant quality”. The trend in real prices, adjusted for quality over the period 1955-2009 has been an increase of 2.1% per annum over inflation. This compares to an increase of 2.7% per annum over inflation without adjusting for quality. So, at a national level, quality changes overstate the trend growth rate by 0.7%. While Stapledon has not constructed a quality-adjusted index for Sydney, assuming that the national trend applied would lead to the conclusion that Sydney house prices have a trend growth rate of 2.4% over inflation.

Six Capital Cities (quality adjusted)Australian Prices (quality and inflation adjusted)

Interesting though this historical exploration may be, the question we would like answered is where prices may head in the future.

One approach to the problem is to assume that growth in property values in real terms may change in the short term, but over the long term will revert to a long term trend. Enthusiasts of trend following may see some significance in the fact that Australian prices still appear to be above the longer run trend, while Sydney prices have already fallen below trend. Of course, depending on the time period used to determine the trend, very different conclusions may be reached. If I were to base the trend on the full history from the 1880s, the last 50 years would appear to be well above trend.

Another popular approach is to consider housing affordability. This approach either looks at ratios of house prices to income or ratios of housing servicing costs (whether interest or rent) to income. The assumption is that these ratios should be stable over time and if increases in house prices result in reduced affordability this indicates the prices can be expected to fall in the future. Stapledon is critical of this approach, arguing that:

while income is expected to be a major influence on prices, there is no theoretical reason for any fixed relationship between prices and income or between rents and income

Over time, people may change their priorities and place a greater or lesser importance on housing and, as a result, be prepared to spend a larger or smaller proportion of their income on housing. Stapledon argues that a better approach is to examine rental yield, which is the ratio of rents to prices. Since the property prices can be expected to keep pace with inflation (and, in fact, outpace inflation), rental yields should be comparable to real yields (i.e. yields over and above inflation) on other asset classes. The easiest real yields to observe are those of inflation-linked Government bonds.  The Reserve Bank of Australia publishes historical data for inflation-linked real yields back to the late 1980s. The chart below compares these Government bond real yields to Stapledon’s history of rental yields. While the correlation is not perfect, both rental yields and real yields show a downward trend from the late 1980s/early 1990s which has only recently begun to reverse. Since rents have not fallen over this period, this provides an explanation for the strong growth in property prices over that period.

Rental Yields

Australian Rents and Inflation-Linked Bonds

So what could this approach tell us about property prices? Rental yields have already risen further than bond real yields, but certainly could go higher. What this means for prices does also depend on where rents themselves may be headed. The chart below shows the contribution of rents to consumer price inflation as published by the ABS. While the rate of growth in rents has slowed, history would suggest that rents are unlikely to go backwards. A cautious, but not overly pessimistic forecast could see rental increases falling to an annualised rate of 1% while rental yields could climb back to 4%. The combined effect would be a fall of 12%. Since prices have already fallen by 7% over the year to the end of March 2009, this would amount to a fall of almost 20%.

Rent CPI

Rent Inflation (Quarterly)

This is certainly a significant drop, but still half the fall that Keen expects to see.  For prices to fall by 40%, even assuming rents remain unchanged rather than growing by 1%, it would be necessary for real yields to rise to 5.8%, which exceeds the record level since 1960 of 5.4%. On this basis, I find it hard to be as pessimistic as Keen. Indeed, the latest data from RP Data-Rismark International suggests that prices are once again on the rise. The next ABS release is a little over a month away, so it will be interesting to see whether they see the same recovery.

The relationship between rental yields and real yields is an interesting one, but ultimately does not provide definitive predictions, but rather an indication of a range of outcomes that would be precedented historically. Of course, as Nassim Taleb has emphasised, unprecedented “black swans” can occur so history does not allow us to rule out more extreme events. Furthermore, nothing here addresses the question why prices in the US have fallen so dramatically and yet Australian prices could suffer far milder falls. That is the primary focus of Stapledon’s paper and is a topic I may return to in a future post, but this one is long enough already!

UPDATE: In this post I noted that the historical data shows a marked shift in behaviour from the mid-1950s without providing any explanation as to the cause of this shift. Needless to say this is a subject Stapledon has given some serious consideration, and I will quote from his doctorate, “Long term housing prices in Australia and some economic perspectives”:

From a longer term view, a key observation is the clear shift in direction in house prices and rents from circa the mid 1950s. House prices, in particular, jumped significantly, best illustrated by the rise in the price to income ratio from about one: one to about 4:1 in the 2000s. Looking at demand and supply variables…indicates that this shift in direction cannot be adequately explained in terms of the demand variables of income and household growth. Supply side factors appear to be more crucial and there is a substantial literature emerging in the US emphasising the importance of supply side variables and specifically the propensity to regulate to constrain supply. The evidence presented in this thesis of the lift in the cost of fringe land in the major urban areas provides prima facie evidence that supply factors have been a significant factor explaining the upward trajectory in house prices in Australia since the mid 1950s.

* I would like to thank Dr Stapledon for generously making his data available to me.

UPDATE: finally, I have published the post on why I don’t think Australia’s property market will experience the same fate as the US market.

http://unsworks.unsw.edu.au/vital/access/manager/Repository/unsworks:1435

Swine Flu on Swivel

I have now uploaded the swine flu data to a Swivel data set. I will update this data set periodically and so the rankings in the chart below should stay reasonably up to date.
Cases per Million Population by Country
Data sources: Guardian Data Blog, CIA World Fact Book.

UPDATE: A number of people have told me that in a number of places, including Victoria and much of the US, testing for swine flu has ceased. This means that the “lab confirmed” swine flu count will become increasingly meaningless over time, so I have decided to stop updating this data.

Pinching Debt Data

Regular readers of the Mule will know that I am a bit of a data-mining junkie. Whenever I come across an interesting chart I start Googling for the underlying data. But, even with well-honed Google skills, it’s not always possible to find the data. Sometimes it is simply not publically available. I ran into just this problem recently. The recent Australian Federal budget triggered countless alarmist opinion pieces despairing that Australia would be “mired in debt” and this prompted me to do some research of my own. In the process, I came across a handy primer on the subject entitled “A history of public debt in Australia”. Written by a number of Australian Treasury employees in the Budget Policy Division, it included the chart below which shows the history of net Government debt (combining Commonwealth and State debt) over almost 40 years. The chart also includes forecasts for the next few years.

Debt History - Original (v2)

Australian Government Net Debt to Gross Domestic Product

While the paper is clearly quite recent (it has no publication date), the forecasts pre-date those included in the May budget, so I was interested in updating the chart with the latest Treasury forecasts. The underlying data does not appear to be published online and, since I do not work with the authors in the Budget Policy Division, I had to resort to special measures. I turned to a handy (and free, open source) little piece of software I have used a number of times to pinch data from charts. The software is called Engauge Digitizer and it allows you to import an image of a chart and extract the underlying data.

Engauge Digitizer Screenshot

For charts with points or curve segments, Engauge generally does a great job of automatically finding the data. For a column chart like the one I had found, the process is a little bit more manual, but with a bit of clicking on the tips of each of the columns in the image, I had my data. The chart below shows the data I obtained. One indication of the accuracy of the results is that the authors of the history paper noted that net debt had averaged 5.7% of gross domestic product (GDP) since 1970. Satisfyingly, the average of my extracted data over this period was also 5.7%.

Debt History - Imported (v2)Australian Government Net Debt to GDP (imported data)

Having obtained the data, I was then able to replace the forecasts with the more recent Treasury figures included in Budget Paper No. 1.

Debt History - New Forecasts (v2)

Australian Government Net Debt to GDP (updated forecasts)

For the alarmists who are worried about this growing debt, it is useful to put these forecasts in a global perspective. The chart below puts these Treasury forecasts alongside IMF forecasts for a number of other developed countries.

World Debt Forecasts

Global Debt to GDP Forecasts

Compared to the rest of the developed world, the global financial crisis is still not looking quite so scary for Australia. When it comes to the United Kingdom, rating agency Standard and Poor’s is even more pessimistic than the IMF and is concerned that their net debt could reach 100% of GDP and have accordingly changed the credit rating outlook for the UK to negative.

UPDATE: For anyone interested in getting hold of the data without resorting to scraping it from the images, I have uploaded it to Swivel. This dataset includes the most recent Treasury forecasts.

Volkswagen: The Biggest Company in the World?

One of the more peculiar stories of late in these times of turbulent financial markets is how, briefly, Volkswagen became the biggest company in the world. In the process, hedge funds around the world suffered losses estimated at over US$35 billion.

Over the last few years, Porsche has been building a stake in Volkswagen. By November 2007, the size of their stake had reached 31%, much of which was achieved by means of share options* rather than direct share purchases. Significant increases in the Volkwagen share price meant that these options delivered large profits for Porsche, prompting criticism that the company was acting more like a hedge fund than a car manufacturer.

Continue reading

Market Capitulation

Apparently the sky is falling, at least that is what stock markets around the world are suggesting.

The Japanese stock market fell 9.6% today, the Korean market fell 10.6% and while the Australian market “only” fell by 2.6%, the Australian dollar is now down below US$0.65. European markets are already down 6-8%. There were dramatic Government interventions in the financial markets around the world earlier this month, which markets took as good news, but it seems they were unable to sustain the initial optimism and have given in to complete despair. The Korean market once had one of the most liquid stock index futures markets in the world, courtesy of the participation of a very large number of retail investors. Today at one point there was simply no bid on the KOSPI. The term used in financial circles when markets simply give up like this is “capitulation”.

The financial crisis, which started in the US has now well and truly spread to the rest of the world. This week the focus of attention moved to Asian and emerging markets, as Argentina announced plans to seize control of private pension funds in what is seen as a desperate attempt to stave of their second default on their sovereign debt this decade. This has driven the price on credit default swaps of insuring against default by the Argentine Government to over 30%. Even the price of insurance against default by the Australian Government has soared from around 0.02% a few years ago to 0.90% today.

Continue reading

Paralympics Medal Tallies by Population and GDP

The 2008 Paralympic Games are now well underway in Beijing. Since my Olympic medal charts on Swivel proved popular, I have now created a data set for the Paralympics as well, which I will be updating regularly (source: Beijing 2008 Paralympics website). One of the topics I touched on during the Olympics was the influence of the size of a country’s population and economy on their performance at the Games. This topic did prove controversial with at least one reader and the links may be more tenuous for the Paralympics. Neverthless, I will risk revisiting the subject here.

Continue reading

Australian Grocery Prices on the Rise?

Last month, the Australian Government launched the GroceryChoice initiative, with the goal of helping consumers find the cheapest place to shop for their groceries. As I wrote at the time, the GroceryChoice website allows users to compare prices in a given area, but comparisons across areas are not made easy. Undeterred, I simply scraped all the data from the web-site for easier analysis. Today GroceryChoice released prices for the month of September, making it possible to start analysing prices over time as well as by region and retailer.

The website provides prices for a number of specific grocery “baskets” (Fruit & Vegetables, Meat & Seafood, etc.) as well as for a more general “Basic Staples” basket. A crude average of prices of this Basic Staples basket around the country would suggest that prices are on the rise, having increased from $75.41 for August to $75.97 for September. However, this figure should be taken with caution. Quite apart from the fact that this analysis does not take into account the differing population sizes in each region, there is also significant variation across the different retailers, as is evident in the chart below.


“Basic Staples” Prices by Retailer (A$)

Continue reading

Olympic Medals per Capita – Update

Since my last post, about Beijing 2008 Olympic rankings by population and economy size, there has been a lot of action in the medals per capita stakes. The Bahamas knocked Jamaica from the number one spot with a Bronze in the triple-jump, only to have Jamaica regain the crown as it continued to win Gold in track and field. Then, with a Silver in the Men’s 4 x 400m relay, the Bahamas got to the front again in what is now an unassailable lead.

For the blow-by-blow on MPC, visit the LA Times MPC blog. I can’t help mentioning that Australia has now pulled ahead of New Zealand!

Previously, the charts I used were static, unable to keep up with these rapid changes so, although the Games are drawing to a close now, I thought I would include Swivel charts which will update as the last results come through. This time I am showing rankings in terms of a simple total medal count per million of population (previously I used a points system, 3 points for Gold, etc).
Beijing Olympics 2008: Medals per mil. Population by Country
Continue reading

Olympic Medal Count by Population and GDP

Now that the swimming is over, Australia is likely to see its rankings in the Olympic medal tally start to fall. To feel better about this situation, people like to start pointing out that we still look pretty good for a small country and it’s certainly true that of the countries currently in the medal tally (as at 22 August 2008), we rank only 36th in terms of population. Ever since I blogged about the data-sharing site  Swivel, I have been regularly updating a data-set with the medal tally. So, it was a simple matter to add in population as well. The chart below provides a high-level overview of the medal results by population. It shows both the total number of medals won and the gold medals. The further a country sits in this chart above a 45 degree line, the better it is doing by population.

Total Medals (blue) and Gold medals by Population

Continue reading

I Hate Personality Tests

Earlier this week I attended a training course that, once again, leaned heavily on colourful “HBDI profiles”. HBDI stands for “Herman Brain Dominance Indicator” and, much like the better-known Myers-Briggs Type Indicator (MBTI), it is a personality test with a fancy name. I am lucky enough to have been subjected to both of these tests more than once, leaving me increasingly irritated each time. This has led me to reflect on why personality tests like these are so popular in the corporate world. I suspect that it is because they have much in common with astrology.

Continue reading