Email news@statisticool.com to sign up to receive news and updates
Gold and Silver Valuation Spreadsheet
2/6/17
Valuing U.S. Treasuries, bonds, and even stocks, is somewhat simple and reliable. Valuing precious metals, however, is much more difficult.
Many sources will shout "Gold to X!" and "Silver to Y!" I find to sell their latest book and to get traffic and ad revenues by pandering. However, in most cases they only give one or two supporting numbers for their valuation, or don't show any work at all, or use the valuation to make what I believe is a silly price prediction that never comes true, thus damaging their credibility and by proxy the credibility of gold and silver as a solid investment to the public.
This work of mine is different for a variety of reasons. First, I look at gold and silver valuations I've gathered (or created) from all over, not just one. Second, taking individual valuations with a large grain of salt, I report the median of the valuations as "the" valuation at this particular point in time, which is more defendable. Third, I give links to source data when I can and show the exact calculations I'm doing. Fourth, I actually like to talk about assumptions and limitations of the data. Fifth, I use logic. For example, if someone says G/S = 12, so therefore the value of silver is G/12, I say logic also says you have to have a case for the value of gold being G = 12*S. Last, I make very clear the distinction between a valuation and a price prediction.
And did I mention that I've made this gold and silver valuation spreadsheet free for you to download and use as you wish? I didn't? This gold and silver valuation spreadsheet is free for you to download and use as you wish.
The free gold and silver valuation spreadsheet is available for download here. Feel free to add to or take away anything you'd like. I hope this helps with your understanding of gold and silver and also investing in general.
Please anonymously VOTE on the content you have just read:
Like:Dislike:
Regarding investing: I do not provide personal investment advice and I am not a qualified licensed investment advisor. I am an amateur investor. All information found here, including any ideas, opinions, views, predictions, forecasts, commentaries, suggestions, expressed or implied herein, are for informational, entertainment or educational purposes only and should not be construed as personal investment advice. While the information provided is believed to be accurate, it may include errors or inaccuracies. I will not and cannot be held liable for any actions you take as a result of anything you read here. Conduct your own due diligence, or consult a licensed financial advisor or broker before making any and all investment decisions.
If you enjoyed any of my content, please consider supporting it in a variety of ways:
- PLEASE take a moment to check out two GoFundMe fundraisers I set up. The idea is to make it possible for me to pursue my passions. My goal is to be able to create free randomized educational worksheets and create poetry on a full-time basis. THANK YOU for your support!
- Email news@statisticool.com to sign up to receive news and updates
- Donate any amount via PayPal
- Take my Five Poem Challenge
- Subscribe to my YouTube channel
- Visit my Amazon author page
- Buy what you need on Amazon using my affiliate link
- Follow me on Twitter here
- Buy ad space on Statisticool.com
AFFILIATE LINK DISCLOSURE: Some links included on this page may be affiliate links. If you purchase a product or service with the affiliate link provided I may receive a small commission (at no additional charge to you). Thank you for the support!