MarketXLS

Net Cash Flow Change In Cash And Cash Equivalents (Historical)

Returns the total change in cash and cash equivalents during the fiscal period. This is the bottom line of the cash flow statement and equals the sum of operating, investing, and financing cash flows plus FX effects.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol (e.g., AAPL, MSFT)
Year Yes Fiscal year (2023) or period code (lq, ly)
Quarter No Quarter number 1-4 (default: 1)
TTM No Set to "TTM" for trailing twelve months

Formula

Net Cash Change = CFO + CFI + CFF + FX Effect

Where:

  • CFO = Operating Cash Flow
  • CFI = Investing Cash Flow
  • CFF = Financing Cash Flow
  • FX Effect = Exchange Rate Impact

Notes

  • Bottom line of the cash flow statement
  • Positive = cash increased during period
  • Negative = cash decreased (used more than generated)
  • Should equal: Ending Cash - Beginning Cash

Syntax

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

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (e.g., 2023, lq, ly)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Net change in cash and cash equivalents

Examples

=hf_Net_Cash_Flow_Change_in_Cash_and_Cash_Equivalents("AAPL", 2023, 4)
Q4 2023 net cash change
=hf_Net_Cash_Flow_Change_in_Cash_and_Cash_Equivalents("MSFT", "ly")
Last fiscal year
=hf_Net_Cash_Flow_Change_in_Cash_and_Cash_Equivalents("GOOGL", 2023, , "TTM")
Trailing 12 months
=hf_Net_Cash_Flow_Change_in_Cash_and_Cash_Equivalents(A1, B1, C1)
From cell references

When to Use

  • Understanding total cash position change
  • Reconciling balance sheet cash
  • Summary view of cash flow
  • Quick cash burn/generation analysis
  • Validating cash flow components

When NOT to Use

Scenario Use Instead
Need cash balance hf_Cash_and_Equivalents()
Need operating cash flow hf_Net_Cash_Flow_from_Operations()
Need investing cash flow hf_Net_Cash_Flow_from_Investing()
Need financing cash flow hf_Net_Cash_Flow_from_Financing()

Common Issues & FAQ

How do I verify this equals the sum of cash flow sections?

=hf_Net_Cash_Flow_from_Operations("AAPL","ly") + hf_Net_Cash_Flow_from_Investing("AAPL","ly") + hf_Net_Cash_Flow_from_Financing("AAPL","ly") + hf_Effect_of_Exchange_Rate_Changes_on_Cash("AAPL","ly") should equal this function.

Why might a profitable company have negative cash change?

Heavy investment (CapEx, acquisitions), shareholder returns (buybacks, dividends), or debt repayment can use more cash than operations generate.

How do I get ending cash balance?

Use hf_Cash_and_Equivalents() for the period-end balance, or calculate: Beginning Cash + Net Cash Change.

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 Net Cash Flow Change In Cash And Cash Equivalents (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions