MarketXLS

NCFO Growth (Historical)

Returns the historical growth rate of Net Cash Flow from Operations (NCFO) compared to the prior period.

Formula

NCFO Growth = (Current NCFO - Prior NCFO) / Prior NCFO

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Quarter 1-4
TTM No "TTM" for trailing twelve months

Return Value

  • Returns as decimal (0.12 = 12% growth)
  • Negative values indicate decline

Syntax

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

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

NCFO growth rate as decimal

Examples

=hf_NCFO_Growth("AAPL", 2023, 4)
Q4 2023 NCFO growth
=hf_NCFO_Growth("MSFT", "ly")
Last year growth
=hf_NCFO_Growth("GOOGL", 2023, , "TTM")
TTM NCFO growth
=hf_NCFO_Growth("AAPL", 2023)*100
Convert to percentage

When to Use

  • Analyzing cash flow trends
  • Quality of earnings assessment
  • Growth sustainability analysis
  • Cash flow based valuation

When NOT to Use

Scenario Use Instead
Absolute NCFO hf_Net_Cash_Flow_from_Operating()
Revenue growth hf_Revenue_Growth()
Free cash flow hf_Free_Cash_Flow()

Common Issues & FAQ

Why is growth extremely high or low?

Small base periods can cause extreme growth rates.

What period is compared?

Year-over-year for annual, quarter-over-quarter for quarterly.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

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 NCFO Growth (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions