Assets Non Current (Historical)
Returns the historical non-current assets - long-term assets not expected to be converted to cash within one year. These represent the company's long-term investments and operational infrastructure.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, MSFT) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Non-Current Asset Components
| Asset | Description |
|---|---|
| PP&E | Property, plant, and equipment |
| Goodwill | Premium paid in acquisitions |
| Intangible Assets | Patents, trademarks, software |
| Long-term Investments | Securities, equity investments |
| Other Non-Current | Deferred taxes, other long-term |
Notes
- Assets held for more than 12 months
- Total Assets = Current Assets + Non-Current Assets
- Higher for capital-intensive industries
- Subject to depreciation and impairment
Syntax
=hf_Assets_Non_Current(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code (e.g., 2023, lq, ly)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Total non-current (long-term) assets value
Examples
=hf_Assets_Non_Current("AAPL", 2023, 4)=hf_Assets_Non_Current("MSFT", "ly")=hf_Assets_Non_Current("AMZN", 2023, , "TTM")=hf_Assets_Non_Current(A1, B1, C1)When to Use
- Fixed asset analysis
- Capital intensity measurement
- Long-term investment review
- Balance sheet composition analysis
- Asset turnover calculations
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total assets | hf_Total_Assets() |
| Need current assets | hf_Current_Assets() |
| Need goodwill/intangibles | hf_Goodwill_and_Intangible_Assets() |
| Need depreciation | hf_Depreciation_Amortization_and_Accretion() |
Common Issues & FAQ
How do I calculate total assets from this?
Total Assets = Current + Non-Current: =hf_Current_Assets("AAPL","lq") + hf_Assets_Non_Current("AAPL","lq") should equal hf_Total_Assets("AAPL","lq")
Why do tech companies have high non-current assets?
Tech companies often have significant goodwill/intangibles from acquisitions and IP. Asset-light businesses have lower PP&E but may have high intangibles.
What drives changes in non-current assets?
CapEx increases PP&E, acquisitions increase goodwill/intangibles, depreciation/amortization decreases values, impairments cause write-downs.
Excel Templates Using Assets Non Current (Historical)
These ready-made MarketXLS templates call hf_Assets_Non_Current() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Auditor's Report (Historical)
- Auditors Name Aud Name And Aud Op (Historical)
- Average Assets (Historical)
- Average Equity (Historical)
- Basic EPS Accounting Change (Historical)
- Basic EPS Continuing Operations (Historical)
- Basic EPS Discontinued Operations (Historical)
- Basic EPS Extraordinary Items (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today