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 - Taxes

Supported 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

Examples

=hf_Net_income_loss("AAPL", 2023)
Apple net income
=hf_Net_income_loss("MSFT", 2023, 2)
Microsoft Q2 2023
=hf_Net_income_loss("GOOGL", "ly")
Alphabet last fiscal year
=hf_Net_income_loss("TSLA", 2023, , "TTM")
Tesla TTM
=hf_Net_income_loss(A1, B1, C1)
Cell references

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

Q: Why is net income negative? A: A negative value means the company had a net loss for that period. This is common for growth companies or during challenging economic conditions.

Q: Why is net income different from cash flow? A: Net income includes non-cash items like depreciation and stock compensation. Operating cash flow shows actual cash generated.

Q: Why am I getting "NA"? A: Check that the symbol is valid and the company has reported financial statements for that period.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Net Income Loss (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions