Assets and consumables in ounces

Hi S1lv3r,

I would assume that you use gold price in A$ and the price of the assets/consumable such as house price, food cost also in A$, so the ratio is correct i.e numerator & denominator uses the same unit .
However, DOW index and price of crude oil is in US$, there fore you may need to use the denominator of the gold price in US$, instead of A$.
 
554_nov2011.jpg


Thanks to augirl - I now convert DOW and WTI to AUD before pricing in metals.

And below a potential start of something interesting :) (The interesting bit is in red)

[imgz=http://forums.silverstackers.com/uploads/554_goldvs3150.jpg]
554_goldvs3150.jpg
[/imgz]

silver line though stays flat - guess more action ahead...
 
Awesome and thanks. Can I ask why the house price box is green and the rental cost is red? Even though both have increased in gold terms?
 
euphoria said:
Awesome and thanks. Can I ask why the house price box is green and the rental cost is red? Even though both have increased in gold terms?
Click to expand...

The colors on all the assets mean their change in terms of AUD. The buying price has increased, while rent decreased.
There are movements within assets prices notwithstanding the gold/silver changes and they are independent of each other (as far as I'm aware).
 
554_pms_29jan2012.jpg


Info for the first 3 red cells was obtained from domain.com.au, against my usual habit of taking it from realestate.com.au (which is nuder maintenance at the moment).
In theory the info should be the same/similar.
The gaps between the current averages and the previous ones are not to be discounted,
but I'd suggest waiting with conclusions until the trend is established and shows for the few months (if this is a trend).

AUD has jumped up, together with PMs.
 
Maybe you overlooked the small attachment 2 months ago (in post #63, but also some older ones) which contains a plot over time...?
 
Thanks again, great work and a genuine post.

Not like some other member who only posts for FAME AND FAMINE
 
[imgz=http://forums.silverstackers.com/uploads/554_assets-pms-mar2012.jpg]
554_assets-pms-mar2012.jpg
[/imgz]


An observation:

1st column (a house):

Dec-10: 503oz
Mar-12: 351oz

Could reverse or change - no one knows the future. But still a nice move :)
 
Your excellent spreadsheet inspired me to work out the value of my home in Au at the time of purchase and today.

Let's just say i would have had $120k profit if i had invested in gold instead of the house.........
 
Byron said:
Your excellent spreadsheet inspired me to work out the value of my home in Au at the time of purchase and today.

Let's just say i would have had $120k profit if i had invested in gold instead of the house.........
Click to expand...

Thanks.
I think you still have time to do it - although you'd have to account for the rent you'll pay..
 
s1lv3r said:
Byron said:
Your excellent spreadsheet inspired me to work out the value of my home in Au at the time of purchase and today.

Let's just say i would have had $120k profit if i had invested in gold instead of the house.........
Click to expand...

Thanks.
I think you still have time to do it - although you'd have to account for the rent you'll pay..
Click to expand...


Back 3 years ago, if i had of dropped my deposit on silver instead of the house i built... id pretty much own my 550k vauled house outright 2day :(
 
Silverbullet08 said:
Back 3 years ago, if i had of dropped my deposit on silver instead of the house i built... id pretty much own my 550k vauled house outright 2day :(
Click to expand...

Ouch!

Investment is a cinch with hindsight.
 
You must log in or register to reply here.
Back
Top