Selling, General & Administrative Expense (Historical)
Returns historical Selling, General and Administrative (SG&A) expenses for a company. SG&A represents the indirect costs of running a business.
What is SG&A?
SG&A includes:
- Selling: Sales commissions, marketing, advertising
- General: Executive salaries, accounting, legal, IT
- Administrative: Office rent, utilities, insurance
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year (e.g., 2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Period Codes
| Code | Meaning |
|---|---|
| lq | Last quarter |
| lq-1 | Two quarters ago |
| ly | Last year |
| ly-1 | Two years ago |
Examples
=hf_Selling_General_and_Administrative_Expense("AAPL", "2023", "4")=hf_Selling_General_and_Administrative_Expense("MSFT", "2023", "3")=hf_Selling_General_and_Administrative_Expense("GOOGL", "lq")=hf_Selling_General_and_Administrative_Expense("AMZN", "2023", "4", "TTM")=hf_Selling_General_and_Administrative_Expense(A1, B1, C1)When to Use
- Analyzing operating efficiency
- Comparing overhead costs across companies
- Building expense models
- Evaluating cost management
- Operating leverage analysis
When NOT to Use
Common Issues & FAQ
Q: Why am I getting "NA"? A: Check that:
- The symbol is valid and has fundamental data available
- The year/quarter combination exists in the data
- The company reports SG&A separately
Q: How do I calculate operating expenses? A: Total Operating Expenses = SG&A + R&D + Other Operating Expenses
Q: What's the difference between SG&A and operating expenses? A: SG&A is a component of operating expenses. Operating expenses also include R&D and other operational costs.
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?