The attached spreadsheet 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.
This is a spreadsheet I have posted on and off since 2003, most recently in 2008.
I've actually simplified it from the last version as I am currently questioning some of my earlier logic with regards to mortgages (I will revisit this when I have some spare time).
That aside, I would welcome any any suggested improvements* and if you see any errors please point those out too.
(*A future version will hopefully take account of R&M and taxes)
EDIT - The spreadsheet has been improved to make it easier to use (thanks Geoff) and I have made some minor alterations to the layout.
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.
This is a spreadsheet I have posted on and off since 2003, most recently in 2008.
I've actually simplified it from the last version as I am currently questioning some of my earlier logic with regards to mortgages (I will revisit this when I have some spare time).
That aside, I would welcome any any suggested improvements* and if you see any errors please point those out too.
(*A future version will hopefully take account of R&M and taxes)
EDIT - The spreadsheet has been improved to make it easier to use (thanks Geoff) and I have made some minor alterations to the layout.
Attachments
Last edited: