Videos
Class A vs Class C Stock - Bogleheads.org
equities - Correct Alphabet (Google) market cap calculation? - Quantitative Finance Stack Exchange
Why are GOOG (not voting shares) still trading at a premium to GOOGL (voting shares)?
Alphabet Inc ($GOOG) voting rights are essentially worthless, right?
This has been driving me nuts as well!
Thanks for providing the spreadsheet. Looking at MSN Money there is a discrepancy of over 11B in market cap between viewing GOOG and GOOGL shares! GOOGL has a market cap associated with 537B and GOOG has a market cap of 526B. I don't understand how one site can list two different market caps based on the class of shares being viewed. I thought it would be Class A Price x Class A Shares Outstanding, + Class B... + Class C... I would think that these should add up to the same amount regardless of which class of shares you are viewing, but apparently not.
There are many definitions of market cap and it is likely that depending on specific views and goals of different platforms or investment teams, one or several might get used.
Here are some variants I have been exposed to : 1) Definition given by Fenix. This is the most intuitive. A few questions asked frequently around that : a) What if a class is dual listed and has different prices ? b) What if a class is not listed ? c) Do you want the full market cap or the free float ? d) Also for some countries you might ask what part of this market cap is available to foreign investors.
2) Market Cap equivalent for a specific security... will be useful to have a Price to Earnings metrics for example. So each security has an equivalent market cap which is then used for ratios computations. Be aware that this number might need to be different depending on share structure (sometimes preferred have different attribution of earnings, so PE would need to be adjusted while BM wouldn't)
So in conclusion, I would ask myself : WHY do I want to use this market cap for ? And from there build my own formula and accept that there can be variations to what others think,compute and report.
Good luck !