Depreciation (Historical)
Allocation of tangible asset costs over useful life.
Syntax
=hf_Depreciation(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Depreciation expense in USD
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.
Excel Templates Using Depreciation (Historical)
These ready-made MarketXLS templates call hf_Depreciation() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Depreciation Amortization And Accretion (Historical)
- Depreciation Unreconciled (Historical)
- Diluted EPS Accounting Change (Historical)
- Diluted EPS Continuing Operations (Historical)
- Diluted EPS Discontinued Operations (Historical)
- Diluted EPS Extraordinary Items (Historical)
- Diluted EPS From Total Operations Year To Date (Historical)
- Diluted EPS Other Gains/Losses (Historical)
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?