Total Fixed Assets (Historical)

Returns total fixed assets (net property, plant & 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

  • Net of accumulated depreciation
  • Gross PP&E minus accumulated depreciation = Net PP&E
  • Key metric for capital intensity analysis

Examples

=hf_Total_fixed_assets("AAPL", 2023, 4)
Apple Q4 2023 net PP&E
=hf_Total_fixed_assets("MSFT", "ly", 2)
Microsoft last year Q2
=hf_Total_fixed_assets(A1, B1, C1)
Cell references

When to Use

  • Capital intensity analysis
  • Asset turnover calculations
  • Balance sheet analysis
  • Return on assets calculations

When NOT to Use

Scenario Use Instead
Need gross PP&E hf_Gross_fixed_assets_plant_property_and_equipment()
Need total assets hf_Total_assets()
Need depreciation hf_Accumulated_depreciation_and_depletion()

Common Issues & FAQ

Q: What's the difference between gross and net fixed assets? A: Net = Gross - Accumulated Depreciation. Net shows the remaining book value.

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

Related Functions