Basic Normalized Net Income Share (Historical)
Returns the basic normalized net income per share, which adjusts net income for one-time items to show underlying earnings power on a per-share basis using basic share count.
Notes
- Excludes one-time gains/losses for cleaner comparison
- Uses basic shares outstanding (not diluted)
- Useful for trend analysis across periods
- Compare with regular EPS for impact of normalizations
Syntax
=hf_Basic_Normalized_Net_Income_Share(Symbol, Year, [Quarter], [TTM])Examples
=hf_Basic_Normalized_Net_Income_Share("AAPL", 2023)=hf_Basic_Normalized_Net_Income_Share("MSFT", 2023, 2)=hf_Basic_Normalized_Net_Income_Share("GOOGL", "lq")=hf_Basic_Normalized_Net_Income_Share("TSLA", "ly")=hf_Basic_Normalized_Net_Income_Share(A1, B1, C1)When to Use
Normalized earnings analysis, removing one-time items, trend analysis
When NOT to Use
| Need diluted EPS | hf_Earning_Per_Share_Diluted() |
| Need GAAP EPS | hf_Basic_EPS_total() |
Common Issues & FAQ
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
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?