Net Income Growth (Historical)

Returns the year-over-year growth rate in net income, showing how much the company's bottom-line profit grew compared to the prior year.

Return Value

Expressed as decimal or percentage depending on data source:

  • 0.15 = 15% growth
  • -0.10 = 10% decline

Notes

  • Key profitability trend indicator
  • Negative values indicate declining profits
  • Compare with revenue growth for margin analysis

Syntax

=hf_Net_Income_Growth(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Examples

=hf_Net_Income_Growth("AAPL", 2023)
Annual data for 2023
=hf_Net_Income_Growth("MSFT", 2023, 2)
Q2 2023 data
=hf_Net_Income_Growth("GOOGL", "lq")
Last quarter
=hf_Net_Income_Growth("TSLA", "ly")
Last year
=hf_Net_Income_Growth(A1, B1, C1)
Cell references

When to Use

Profitability trend analysis, earnings growth screening, peer comparison

When NOT to Use

| Need revenue growth | hf_Revenue_Growth() | | Need EPS growth | QuarterlyEarningsGrowthYOY() |

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
MarketXLS Excel Add-in Tutorial - How to Use Net Income Growth (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions