Other Non-Cash Items (Historical)
Returns miscellaneous non-cash items from the cash flow statement that don't fit into standard categories. These are adjustments in the operating cash flow reconciliation.
Notes
- Catch-all for non-standard non-cash items
- Part of net income to operating cash flow reconciliation
- May include stock-based comp, deferred taxes, etc.
- Review company filings for specific items
Syntax
=hf_Other_Non_Cash_Items(Symbol, Year, [Quarter], [TTM])Examples
=hf_Other_Non_Cash_Items("AAPL", 2023)=hf_Other_Non_Cash_Items("MSFT", 2023, 2)=hf_Other_Non_Cash_Items("GOOGL", "lq")=hf_Other_Non_Cash_Items("TSLA", "ly")=hf_Other_Non_Cash_Items(A1, B1, C1)When to Use
Cash flow quality analysis, non-cash adjustment review, detailed cash flow analysis
When NOT to Use
| Need depreciation specifically | hf_Depreciation() |
| Need stock comp | hf_Share_Based_Compensation() |
Common Issues & FAQ
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
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?