Other Non-Current Assets (Historical)
Returns miscellaneous long-term assets that don't fit into standard balance sheet categories like PP&E, intangibles, or investments.
Notes
- Catch-all for non-standard long-term assets
- May include long-term prepaid expenses, deferred charges, etc.
- Review filings for specific composition
- Part of total non-current assets
Syntax
=hf_Other_Non_Current_Assets(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year
Quarter (1-4)
Use TTM for trailing twelve months
Examples
=hf_Other_Non_Current_Assets("AAPL", 2023)=hf_Other_Non_Current_Assets("MSFT", 2023, 2)=hf_Other_Non_Current_Assets("GOOGL", "lq")=hf_Other_Non_Current_Assets("TSLA", "ly")=hf_Other_Non_Current_Assets(A1, B1, C1)When to Use
Balance sheet analysis, asset composition review, non-standard asset tracking
When NOT to Use
| Need total assets | hf_Total_Assets() |
| Need PP&E | hf_Property_Plant_Equipment_Net() |
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.
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