Net Change In Cash And Cash Equivalents (Historical)
Returns the total net change in cash and cash equivalents for a period. This is the bottom line of the cash flow statement, representing the sum of operating, investing, and financing cash flows plus FX effects.
Understanding the Metric
This is calculated as:
Net Change = Operating CF + Investing CF + Financing CF + FX EffectsPositive value indicates cash increased during the period. Negative value indicates cash decreased during the period.
This reconciles to:
Ending Cash = Beginning Cash + Net ChangeParameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker (e.g., AAPL, MSFT) |
| Year | Fiscal year or period code (lq, ly, lq-1, ly-1, lt, lt-1) |
| Quarter | Optional: 1, 2, 3, or 4 (default: 1) |
| TTM | Optional: "TTM" for trailing twelve months |
Period Codes
| Code | Meaning |
|---|---|
| lq | Last reported quarter |
| lq-1 | Quarter before last |
| ly | Last fiscal year |
| ly-1 | Year before last |
| lt | Last trailing twelve months |
| lt-1 | Prior trailing twelve months |
Syntax
=hf_Net_change_in_cash_and_cash_equivalents(Symbol, Year, [Quarter], [TTM])Examples
=hf_Net_change_in_cash_and_cash_equivalents("AAPL", 2023, 4)=hf_Net_change_in_cash_and_cash_equivalents("MSFT", "ly")=hf_Net_change_in_cash_and_cash_equivalents("GOOGL", 2023, , "TTM")=hf_Net_change_in_cash_and_cash_equivalents(A1, B1, C1)=hf_Net_change_in_cash_and_cash_equivalents("META", "lq")When to Use
- Analyzing overall cash flow health
- Reconciling beginning to ending cash
- Understanding net liquidity change
- Verifying cash flow statement totals
- Building financial models
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need ending cash balance | hf_Cash_at_end_of_period() |
| Need beginning cash balance | hf_Cash_at_beginning_of_period() |
| Need operating cash flow | hf_Net_cash_from_continuing_operations() |
| Need specific cash flow category | Use category-specific functions |
Common Issues & FAQ
Why doesn't this match ending minus beginning cash?
Foreign currency effects on cash held in other currencies can cause small differences. The cash flow statement reconciles these explicitly.
A negative number means the company is in trouble?
Not necessarily. Companies may decrease cash for positive reasons (buybacks, debt paydown, acquisitions). Evaluate the sources and uses of cash, not just the net change.
How does this relate to free cash flow?
Free cash flow is a specific calculation (Operating CF - CapEx). Net change includes all cash flows including financing activities like dividends and buybacks.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today