Depreciation Amortization And Accretion (Historical)
Returns the historical depreciation, amortization, and accretion expense. This non-cash expense is added back to net income when calculating operating cash flow.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, MSFT) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Components
| Component | Description |
|---|---|
| Depreciation | Allocation of tangible asset costs (PP&E) |
| Amortization | Allocation of intangible asset costs |
| Accretion | Increase in value of discounted liabilities |
Notes
- Non-cash expense that reduces reported income
- Added back in cash flow statement
- Higher D&A indicates capital-intensive business
- Used to calculate EBITDA: Operating Income + D&A
Examples
=hf_Depreciation_Amortization_and_Accretion("AAPL", 2023, 4)=hf_Depreciation_Amortization_and_Accretion("MSFT", "ly")=hf_Depreciation_Amortization_and_Accretion("AMZN", 2023, , "TTM")=hf_Depreciation_Amortization_and_Accretion(A1, B1, C1)When to Use
- Calculating EBITDA from operating income
- Understanding non-cash expenses
- Asset intensity analysis
- Cash flow reconciliation
- Comparing capital-intensive vs asset-light businesses
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need EBITDA directly | EBITDA() |
| Need capital expenditures | hf_Capital_Expenditure() |
| Need operating cash flow | hf_Net_Cash_Flow_from_Operations() |
| Need PP&E value | hf_Property_Plant_Equipment() |
Common Issues & FAQ
Q: How do I calculate EBITDA?
A: EBITDA = Operating Income + D&A. Or use the direct EBITDA() function for current TTM.
Q: Why does Amazon have such high D&A? A: Capital-intensive businesses with large PP&E and intangibles have higher D&A. Amazon has massive fulfillment center and AWS infrastructure.
Q: Is D&A the same as CapEx? A: No. D&A is the expense recognized for past capital investments. CapEx is current spending on new assets. Over time they should roughly match.
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?