Other Fixed Assets (Historical)

Returns other fixed assets from historical balance sheets not classified in main PP&E categories.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Calendar quarter 1-4
TTM No Set to "TTM" for trailing twelve months

Examples

=hf_Other_fixed_assets("AAPL", 2023, 4)
Apple Q4 2023
=hf_Other_fixed_assets("MSFT", "ly", 2)
Microsoft last year Q2
=hf_Other_fixed_assets(A1, B1, C1)
Cell references

When to Use

  • Complete fixed asset breakdown
  • Reconciling PP&E components
  • Detailed balance sheet analysis

When NOT to Use

Scenario Use Instead
Need total PP&E hf_Gross_fixed_assets_plant_property_and_equipment()
Need buildings hf_Building_and_improvements()
Need equipment hf_Machinery_furniture_and_equipment()

Common Issues & FAQ

Q: What's typically in other fixed assets? A: May include leasehold improvements, vehicles, specialized equipment, and other long-term tangible assets.

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 Other Fixed Assets (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions