Profit Margin
Returns the net profit margin for a company, calculated as net income divided by total revenue. This is a key profitability metric that shows how much of each dollar in revenue translates to profit.
Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Notes
- Value is returned as a decimal (0.25 = 25%)
- Based on trailing twelve months (TTM) data
- Also known as net profit margin or net margin
Examples
=ProfitMargin("AAPL")=ProfitMargin("MSFT")=ProfitMargin("GOOGL")=ProfitMargin(A1)When to Use
- Analyzing company profitability
- Comparing profit efficiency across companies
- Screening for highly profitable stocks
- Fundamental analysis and valuation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need gross margin | GrossMargin() |
| Need operating margin | OperatingMargin() |
| Need EBIT margin | EBITMargin() |
| Need pre-tax margin | PreTaxProfitMargin() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: Check that:
- Symbol is valid and actively traded
- Company has reported financials
- Symbol format is correct (no exchange suffix needed for US stocks)
Q: Is this TTM or quarterly? A: This returns trailing twelve months (TTM) profit margin.
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?