This is a revised (for June 2004) version of the original MS Excel spreadsheet I posted in this thread.
The attached spreasheet contains Australian Consumer Price Index (CPI) data for each financial year since 1949/50.
Using CPI as a base it is possible to ascertain the real growth in the value of an asset. That is, the growth over and above what simply keeping pace with CPI would dictate.
MB
btw. Those who open the spreadsheet will notice some figures already plugged in. A property worth $1350 (675 pounds) in 1958, which today has a value of $500,000.
The first figure is an actual sale price for a block of land in a particular area in 1958 (46 years ago).
The second is my estimate of what that same lot would be worth in 2004.
Not a bad little earner that one.
The attached spreasheet contains Australian Consumer Price Index (CPI) data for each financial year since 1949/50.
Using CPI as a base it is possible to ascertain the real growth in the value of an asset. That is, the growth over and above what simply keeping pace with CPI would dictate.
MB
btw. Those who open the spreadsheet will notice some figures already plugged in. A property worth $1350 (675 pounds) in 1958, which today has a value of $500,000.
The first figure is an actual sale price for a block of land in a particular area in 1958 (46 years ago).
The second is my estimate of what that same lot would be worth in 2004.
Not a bad little earner that one.
Attachments
Last edited: