SG&A Expense As Percentage Of Revenue (Historical)
Returns Selling, General & Administrative expenses as a percentage of total revenue. This metric shows operational efficiency and overhead burden.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year (2020, 2021, etc.) or period code (lq, ly) |
| Quarter | No | Calendar quarter 1-4 (default: 1) |
| TTM | No | Enter "TTM" for trailing twelve months |
What is SG&A?
SG&A includes:
- Selling expenses (advertising, sales salaries)
- General expenses (office rent, utilities)
- Administrative expenses (executive salaries, legal fees)
Examples
=hf_SGandA_expense_as_percentage_of_revenue("AAPL", 2023, 4)=hf_SGandA_expense_as_percentage_of_revenue("MSFT", 2022, , "TTM")=hf_SGandA_expense_as_percentage_of_revenue("GOOGL", "ly")When to Use
- Analyzing operational efficiency trends
- Comparing overhead costs across companies
- Identifying cost control opportunities
- Margin analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need R&D expense ratio | hf_RandD_Expense_as_percentage_of_revenue() |
| Need absolute SG&A value | hf_SGandA_expense() |
| Need gross margin | hf_Gross_margin() |
Common Issues & FAQ
Q: What is a good SG&A ratio? A: Varies by industry. Tech companies often have higher SG&A than manufacturing.
Q: Why does SG&A increase with growth? A: Companies often invest in sales and marketing to drive growth.
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?