Depreciation (Historical)

Allocation of tangible asset costs over useful life.

Examples

=hf_Depreciation("CAT", 2023, 4)

When to Use

  • Capital intensity analysis
  • D&A for EBITDA calculation

When NOT to Use

Scenario Use Instead
Amortization hf_Amortization()

Common Issues & FAQ

Non-cash expense.

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