MarketXLS

Accumulated Depreciation And Depletion (Historical)

Returns accumulated depreciation and depletion, the cumulative depreciation charged against fixed assets.

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

  • Usually a negative number (contra-asset)
  • Gross PP&E - Accumulated Depreciation = Net PP&E
  • Higher values indicate older asset base

Syntax

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

Accumulated depreciation and depletion (typically negative)

Examples

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

When to Use

  • Asset age analysis
  • Calculating net PP&E from gross
  • Depreciation policy analysis
  • Capital investment timing analysis

When NOT to Use

Scenario Use Instead
Need annual depreciation hf_Depreciation()
Need net PP&E hf_Total_fixed_assets()
Need gross PP&E hf_Gross_fixed_assets_plant_property_and_equipment()

Common Issues & FAQ

Why is this negative?

Accumulated depreciation is a contra-asset account that reduces gross PP&E to net 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 Accumulated Depreciation And Depletion (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions