Australian Car Value History

Australian Car Value History

I was recently in the market for new wheels, and so spending a bit of time researching the Australian car market at carsales.com.au and RedBook.com.au. It got me thinking about the rates of depreciation in value of different makes of car. So, I set about creating a chart that would help me visualize this kind of information.

The result is the interactive line chart shown below. You can use the interactive version of the visualization if you have a modern, standards-compliant browser (Firefox, Chrome, Opera, Safari, etc.) or you can try Chrome Frame (Internet Explorer).

The chart plots a line for each of several popular models of car. The lines can be made to represent several different values:

+ Sticker price: price when new
+ Resale value: price when selling the car on the private market
+ Resale value (%): the resale value as a percentage of the sticker price

You can also highlight individual models using the checkboxes or by moving the mouse cursor over a line.

Data
Obtaining the data was laborious. I first determined popular makes by looking at the numbers of cars for sale at carsales.com.au. I focussed on sedans, ignoring SUVs, vans, utes etc. For each popular make I selected a couple of popular models - small and large.

Then I visited RedBook.com.au to research price history but encountered a couple of hurdles. Firstly, it isn't possible to get 10 years of price data for an individual model because RedBook only publishes the sticker price and current resale values (not the resale value last year, the year before and so on). To overcome this I used the sticker price and current resale value for comparable entry-level models from 2001 - 2011.

The second problem was that for some makes (BMW, Kia, Mercedes and Nissan) it wasn't possible to find two models that had been sold in Australia every year for the last 10 years. And no single model of Hyundai (a very popular make) has been sold continuously for the last decade.

Insights
Once I had the data I was able to visualize it, and there were a couple of surprises. Firstly, sticker price has remained fairly stable across all makes and models. I expected this would have decreased more recently, especially for imported cars, with the appreciation in the value of the Australian dollar.

Resale values drop precipitously in the first few years of a car's life - no surprises there.

What did surprise me was that when resale value is expressed as a percentage of sticker price, small Japanese cars faired best. I had expected the European marques - Audi, BMW, Mercedes and Volkswagen - to top this ranking, or even popular family sedans but it's the compact Japanese Mazda 3, Toyota Corolla, Subaru Impreza, Honda Civic and the Holden Barina (Japanese import) that top the list. The smallish VW Golf also holds its value well as does the Merc.

Commodore vs. Falcon
In Australia there is a long-running rivalry between the Holden Commodore and Ford Falcon. Falcon and Commodore track each other closely for sticker price. However, the resale value of Falcon falls away from that of the Commodore in the first few years although after 10 years the two are close together again. As a percentage of sticker price the Falcon's resale price is one of the lowest of the models compared, especially during its mid-life, but the Commodore doesn't fair much better.

Add a Comment

Login or register to post comments
 
Posted Jan 16, 2013
 
Views: 1295
 
1
Tags Australia, car buying, cars, vehicles, car maintenance, used cars, cars, d3.js, line chart
Tools d3.js, Javascript
Data
 
 
Share
Embed
<iframe src="http://visualizing.org/embedded/47521" width="620" height="450" frameborder="0" scrolling="no" marginheight="0" marginwidth="0"></iframe>
Need help embedding?