MarketXLS

Gross Fixed Assets Plant Property And Equipment (Historical)

Returns gross fixed assets (PP&E at original cost before accumulated depreciation).

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

  • Original cost of all fixed assets
  • Gross PP&E - Accumulated Depreciation = Net PP&E
  • Shows total capital invested in fixed assets

Syntax

=hf_Gross_fixed_assets_plant_property_and_equipment(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Gross fixed assets (PP&E before depreciation)

Examples

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

When to Use

  • Understanding total capital investment
  • Calculating asset age/depreciation ratios
  • Capital intensity analysis
  • Comparing companies' fixed asset bases

When NOT to Use

Scenario Use Instead
Need net PP&E hf_Total_fixed_assets()
Need depreciation only hf_Accumulated_depreciation_and_depletion()
Need total assets hf_Total_assets()

Common Issues & FAQ

How do I calculate average asset age?

Accumulated Depreciation / Annual Depreciation Expense gives approximate asset age.

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
MarketXLS Excel Add-in Tutorial - How to Use Gross Fixed Assets Plant Property And Equipment (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions