MarketXLS

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

Syntax

=hf_Total_fixed_assets(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

Total fixed assets (net PP&E)

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

What's the difference between gross and net fixed assets?

Net = Gross - Accumulated Depreciation. Net shows the remaining book value.

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

Related Functions