Depreciation (Historical)
Allocation of tangible asset costs over useful life.
Syntax
=hf_Depreciation(Symbol, Year, [Quarter], [TTM])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
▶
How does MarketXLS work?