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
Syntax
=ProfitMargin(Symbol)Returns
number
Profit margin as a decimal (e.g., 0.25 = 25%)
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
Why am I getting "NA"?
Check that:
- Symbol is valid and actively traded
- Company has reported financials
- Symbol format is correct (no exchange suffix needed for US stocks)
Is this TTM or quarterly?
This returns trailing twelve months (TTM) profit margin.
Excel Templates Using Profit Margin
These ready-made MarketXLS templates call ProfitMargin() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Key Ratios formulas you can use in the same worksheet:
- Quick Ratio
- Receivables Turnover
- Return on Assets (Last 12 Months)
- Return On Capital
- Return On Capital (Last 12 Months)
- Return On Equity (Last 12 Months)
- Return on Invested Capital (Current Quarter)
- Return On Invested Capital (ROIC - Last 12 Months)
See ProfitMargin used in a complete workbook: ChatGPT Excel: How to Use AI with Financial Spreadsheets for Live Market Data
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?