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

Examples

=hf_Assets_Non_Current("AAPL", 2023, 4)
Q4 2023 non-current assets
=hf_Assets_Non_Current("MSFT", "ly")
Last fiscal year
=hf_Assets_Non_Current("AMZN", 2023, , "TTM")
Trailing period
=hf_Assets_Non_Current(A1, B1, C1)
From cell references

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

Q: How do I calculate total assets from this? A: Total Assets = Current + Non-Current: =hf_Current_Assets("AAPL","lq") + hf_Assets_Non_Current("AAPL","lq") should equal hf_Total_Assets("AAPL","lq")

Q: Why do tech companies have high non-current assets? A: Tech companies often have significant goodwill/intangibles from acquisitions and IP. Asset-light businesses have lower PP&E but may have high intangibles.

Q: What drives changes in non-current assets? A: CapEx increases PP&E, acquisitions increase goodwill/intangibles, depreciation/amortization decreases values, impairments cause write-downs.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Assets Non Current (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions