Avocados VS Homes

Project Info

Avo Smashers thumbnail

Team Members


Dan , Chris , Lily , Marcus , Max

Project Description


Housing affordability is a problem faced by many young adults in Sydney. We decided to visualise this serious problem in a concrete but light-hearted way via a Monopoly board, letting users find out which suburbs an average person in their area would be able to afford a house in.

Users select which LGA they live in. Our model then takes an average 30-year-old living in that area, and computes their projected income and savings over the next 25 years. Comparing this against projected house prices and possible mortgage strategies, it predicts which suburbs this 'average person' would be able to afford a residential property in, and how long they would have to save before they could afford it.

This is then visualised on the Monopoly board, with each 'property' space on the board corresponding to a Sydney LGA. Check it out!

We used ABS data to calculate LGA-level income levels and growth rates, and publicly available house price data to calculate median house prices in each region.


#avocado #housing #affordability #financial future

Evidence of Work

Video

Homepage

Team DataSets

Valuer General of NSW Property Sales Information

Description of Use We programmatically extracted data for all property sales in NSW from 2020. We then calculated quartiles and mean for each LGA ("district") in dataset.

Data Set

INCOME (INCLUDING GOVERNMENT ALLOWANCES), Local Government Area, 2011-2018

Description of Use Median income and compound growth per LGA from 2013-2017 for individuals in NSW.

Data Set

65300DO014_201516 Household Expenditure Survey, Australia: Summary of Results, 2015–16

Description of Use Calculated compound annual growth rate of residential properties in Sydney from series A83728383L

Data Set

65300DO014_201516 Household Expenditure Survey, Australia: Summary of Results, 2015–16

Description of Use For couples where reference person aged under 35, calculated rate of expenditure and rent from: * Median goods and services expenditure * Median gross income * Median disposable income * Current housing costs (selected dwelling)

Data Set

Challenge Entries

Create a solution to a customer need using the ABS Data API

We are excited to provide innovators with machine to machine access to ABS Data and see what exciting customer solutions can be created. Here is a chance to draw in ABS Data and answer an important question through visualisation, mapping or even blending with other data sources. Create a solution to a customer need using data drawn from the ABS Data API.

Eligibility: Teams are encouraged to use datasets from a variety of sources, but at least one must be drawn from the ABS Data API.

Go to Challenge | 20 teams have entered this challenge.

Our financial future

How might we use publicly available data to safeguard citizens’ financial future?

Go to Challenge | 11 teams have entered this challenge.