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 |
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
Q: Why doesn't this match ending minus beginning cash? A: Foreign currency effects on cash held in other currencies can cause small differences. The cash flow statement reconciles these explicitly.
Q: A negative number means the company is in trouble? A: 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.
Q: How does this relate to free cash flow? A: 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