Normalized Income Per Employee (Historical)
Returns the normalized income per employee for a company, excluding one-time items. This metric measures workforce productivity and efficiency.
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 |
Syntax
=hf_Normalized_income_per_employee(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Calendar quarter (1-4)
TTMstring
Use TTM for trailing twelve months
Returns
number
Normalized income per employee in dollars
Examples
=hf_Normalized_income_per_employee("AAPL", 2023, 4)=hf_Normalized_income_per_employee("MSFT", 2022, , "TTM")=hf_Normalized_income_per_employee("GOOGL", "ly")When to Use
- Analyzing workforce productivity trends
- Comparing employee efficiency across companies
- Building workforce efficiency models
- Understanding per-employee profitability
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need sales per employee | hf_Sales_per_employee() |
| Need current metrics | Income_Per_Employee() |
| Need total employees | Number_Of_Employees() |
Common Issues & FAQ
Why am I getting "NA"?
Check that the symbol is valid and employee data is available for that period.
What does "normalized" mean?
Normalized metrics exclude one-time or non-recurring items.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Normalized Low Price Earnings Ratio (Historical)
- Normalized Net Profit Margin (Historical)
- Normalized Return On Assets (Historical)
- Normalized Return On Invested Capital (Historical)
- Normalized Return On Stock Equity (Historical)
- Notes Payable (Historical)
- Number Of Days Cost Of Goods Sold In Inventory (Historical)
- Number Of Employees (Historical)
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?