Market Capitalization
Returns the market capitalization for a company, which represents the total market value of all outstanding shares.
Market Cap = Share Price x Shares Outstanding
Market Cap Categories
| Category | Range | Examples |
|---|---|---|
| Mega Cap | > $200B | AAPL, MSFT, GOOGL |
| Large Cap | $10B - $200B | Most S&P 500 stocks |
| Mid Cap | $2B - $10B | Russell Midcap index |
| Small Cap | $300M - $2B | Russell 2000 index |
| Micro Cap | $50M - $300M | OTC stocks |
| Nano Cap | < $50M | Penny stocks |
Market Cap vs Enterprise Value
| Metric | Includes | Best For |
|---|---|---|
| Market Cap | Equity only | Quick size comparison |
| Enterprise Value | Equity + Debt - Cash | Acquisition valuation |
Examples
=MarketCapitalization("AAPL")=MarketCapitalization("MSFT")=MarketCapitalization("TSLA")=MarketCapitalization(A1)=MarketCapitalization("AAPL")/1000000000When to Use
- Determining company size
- Portfolio weighting decisions
- Size-based screening
- Comparing companies by market value
- Index inclusion analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need enterprise value | EnterpriseValue() |
| Need shares count | Shares_Outstanding() |
| Need historical data | hf_MarketCap() |
| Need float-adjusted cap | Calculate with FloatShares() |
Common Issues & FAQ
Q: Why does market cap change daily? A: Market cap = Price x Shares Outstanding. As the stock price changes throughout the day, so does the market cap.
Q: How do I get market cap in billions?
A: Divide by 1 billion:
=MarketCapitalization("AAPL")/1000000000
Q: What's the difference between market cap and enterprise value? A: Market cap measures equity value only. Enterprise value adds debt and subtracts cash to show the theoretical takeover price.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?