Machinery Furniture And Equipment (Historical)

Returns machinery, furniture, and equipment from historical balance sheets.

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

Notes

  • Includes manufacturing equipment, computers, furniture
  • Subject to depreciation
  • Key component for manufacturing companies

Examples

=hf_Machinery_furniture_and_equipment("CAT", 2023, 4)
Caterpillar Q4 2023
=hf_Machinery_furniture_and_equipment("DE", "ly", 2)
Deere last year Q2
=hf_Machinery_furniture_and_equipment(A1, B1, C1)
Cell references

When to Use

  • Capital expenditure analysis
  • Manufacturing capacity assessment
  • Fixed asset breakdown
  • Depreciation 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 land hf_Land_and_improvements()

Common Issues & FAQ

Q: What's the typical depreciation life for equipment? A: Varies by type: machinery 7-15 years, computers 3-5 years, furniture 5-10 years.

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 Machinery Furniture And Equipment (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions