If you find any of this useful, please consider donating via PayPal to help keep this site going.

Email news@statisticool.com to sign up to receive news and updates

Gold and Silver Valuation Spreadsheet


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:


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:

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!