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 |
Syntax
=MarketCapitalization(Symbol)Returns
Market capitalization in USD
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
Why does market cap change daily?
Market cap = Price x Shares Outstanding. As the stock price changes throughout the day, so does the market cap.
How do I get market cap in billions?
Divide by 1 billion:
=MarketCapitalization("AAPL")/1000000000
What's the difference between market cap and enterprise value?
Market cap measures equity value only. Enterprise value adds debt and subtracts cash to show the theoretical takeover price.
Excel Templates Using Market Capitalization
These ready-made MarketXLS templates call MarketCapitalization() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Profile formulas you can use in the same worksheet:
- Market Capitalization (On Demand)
- Optionable
- Profile Value
- Sector
- Share Percent Held By Insiders
- Share Percent Held by Institutions
- Shares Outstanding (On Demand)
- Shares Owned
See MarketCapitalization used in a complete workbook: Penny Stocks Under 10 Rs: Complete Guide to Screening and Analyzing Low-Price Indian Shares
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today