Increase Decrease In Receivables (Historical)
Returns the historical change in accounts receivable from the cash flow statement. This shows how much cash was used or freed by changes in customer receivables.
Cash Flow Statement Convention
| Sign | Meaning |
|---|---|
| Positive | Receivables decreased (cash inflow) |
| Negative | Receivables increased (cash outflow) |
Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| International | SYMBOL | SHOP, TSM |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Working Capital Analysis
| Scenario | Cash Flow Impact |
|---|---|
| Receivables increase | Uses cash (negative) |
| Receivables decrease | Frees cash (positive) |
Notes
- Part of operating cash flow adjustments
- Increasing receivables may indicate collection issues
- Seasonal businesses have cyclical receivables swings
Examples
=hf_Increase_Decrease_in_receivables("AAPL", 2023)=hf_Increase_Decrease_in_receivables("MSFT", 2023, 2)=hf_Increase_Decrease_in_receivables("AMZN", "ly")=hf_Increase_Decrease_in_receivables("GOOGL", 2023, , "TTM")=hf_Increase_Decrease_in_receivables(A1, B1, C1)When to Use
- Analyzing working capital management
- Understanding cash flow from operations
- Evaluating collection efficiency
- Comparing with revenue growth
- Cash conversion cycle analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total receivables | hf_Accounts_Receivable() |
| Need operating cash flow | hf_Operating_Cash_Flow() |
| Need inventory changes | hf_Increase_Decrease_in_inventories() |
| Need current ratio | hf_Current_Ratio() |
Common Issues & FAQ
Q: Why does negative mean increase? A: In cash flow statements, an increase in receivables uses cash (you've sold but not collected). The negative sign shows cash is being used.
Q: Is increasing receivables bad? A: Not necessarily. Growing businesses naturally have growing receivables. Compare receivables growth to revenue growth to assess quality.
Q: Why am I getting "NA"? A: Check that the symbol is valid and the company reports detailed cash flow statement items.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?