Net Income Loss (Historical)
Returns historical net income (or net loss) for a company. This is the "bottom line" profit after all expenses, interest, and taxes have been deducted from revenue.
Formula
Net Income = Revenue - Cost of Revenue - Operating Expenses - Interest - TaxesSupported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| International | SYMBOL | SHOP, TSM |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Understanding Net Income
| Value | Interpretation |
|---|---|
| Positive | Company is profitable |
| Negative | Company has a net loss |
| Growing | Improving profitability |
| Declining | Deteriorating profitability |
Notes
- Net income is used to calculate EPS
- Negative values indicate a loss
- Values are in company's reporting currency
Syntax
=hf_Net_income_loss(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code (lq, ly, etc.)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Net income (or loss if negative)
Examples
=hf_Net_income_loss("AAPL", 2023)=hf_Net_income_loss("MSFT", 2023, 2)=hf_Net_income_loss("GOOGL", "ly")=hf_Net_income_loss("TSLA", 2023, , "TTM")=hf_Net_income_loss(A1, B1, C1)When to Use
- Analyzing profitability trends
- Calculating profit margins
- Understanding bottom-line performance
- Valuation analysis (P/E calculation)
- Comparing profits across periods
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need EPS | EarningsPerShare() |
| Need EBITDA | hf_EBITDA() |
| Need operating income | hf_Operating_Income() |
| Need gross profit | hf_Gross_Profit() |
| Need cash flow | hf_Operating_Cash_Flow() |
Common Issues & FAQ
Why is net income negative?
A negative value means the company had a net loss for that period. This is common for growth companies or during challenging economic conditions.
Why is net income different from cash flow?
Net income includes non-cash items like depreciation and stock compensation. Operating cash flow shows actual cash generated.
Why am I getting "NA"?
Check that the symbol is valid and the company has reported financial statements for that period.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Net Income To Non Controlling Interests (Historical)
- Net Profit Indicator (Historical)
- Non Current Deferred Income Taxes (Historical)
- Normalized Income (Historical)
- Normalized Income Per Employee (Historical)
- Normalized Low Price Earnings Ratio (Historical)
- Normalized Net Profit Margin (Historical)
- Normalized Return On Assets (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today