EBITDA (Historical)
Returns historical EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) for a company. EBITDA is a measure of operating performance that excludes financing and accounting decisions, making it useful for comparing companies across industries.
Formula
EBITDA = Operating Income + Depreciation + Amortization
OR
EBITDA = Net Income + Interest + Taxes + Depreciation + AmortizationSupported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| International | SYMBOL | SHOP, TSM |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Uses of EBITDA
| Use Case | Description |
|---|---|
| Valuation | EV/EBITDA multiples |
| Comparison | Compare profitability across companies |
| Debt Analysis | Debt/EBITDA leverage ratios |
| Cash Proxy | Rough estimate of operating cash generation |
Notes
- EBITDA is not GAAP but widely used
- Does not account for capital expenditures
- Values are in company's reporting currency
Examples
When to Use
- Calculating EV/EBITDA valuation multiples
- Comparing profitability across companies
- Analyzing operating performance trends
- Debt capacity analysis
- M&A valuation analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current EBITDA | EBITDA() |
| Need USD values | hf_EBITDA_USD() |
| Need EBITDA margin | hf_EBITDA_Margin() |
| Need net income | hf_Net_Income() |
| Need operating income | hf_Operating_Income() |
Common Issues & FAQ
Q: Why is EBITDA controversial? A: EBITDA ignores capital expenditures and working capital needs. It can overstate cash generation for capital-intensive businesses.
Q: How do I calculate EV/EBITDA?
A: EV/EBITDA = Enterprise Value / EBITDA. Use EnterpriseValue() and hf_EBITDA() together.
Q: Why am I getting "NA"? A: Check that the symbol is valid and the company has sufficient financial data to calculate EBITDA.
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?