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 at 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.

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: